DEclare l_tax_combination_id number; l_return_status           VARCHAR2 (100); l_error                   VARCHAR2 (1000); v_request_id              NUMBER; v_msg_count               NUMBER; [...]

We made use of utl_http to post json_data. This piece of code will help in sending data to Custom Applications DECLARE    vrequest                                  CLOB;    [...]

In XML Publisher Bursting Barcode Font is Ignored. An XML Publisher concurrent program that produces a PDF output with barcodes works when running the concurrent program and viewing the output. [...]

BoM-Interface

bom-components-drill-down-query

supplier_.import_fbdldocx

person_security_profile_hcm

Shipment is happening from third party system and if partial shipment is happening then sales order line should be split based on balance quantity and with shipped quantity line should get [...]

Need to write output file using CLOB variable which contains more than 32767 bytes of data even it may contain up to 8 GB data. If it exceeds more than 32767 bytes we can not write it in one [...]

PROCEDURE xxbom_explode_bom_for_abc(i_item_id IN NUMBER, i_organization_id number, i_num_so_line_id number) IS g_chr_excp_msg VARCHAR2(4000); g_chr_log_msg VARCHAR2(4000); g_dte_sysdate DATE := [...]