APPS.ARI_DB_UTILITIES dependencies on AR_IREC_PRINT_REQUESTS

Line 1019: | inserts the record in ar_irec_print_requests table.

1015: | PUBLIC procedure oir_bpa_print_invoices
1016: |
1017: | DESCRIPTION
1018: | This procedure is used to submit the print request to BPA and also
1019: | inserts the record in ar_irec_print_requests table.
1020: |
1021: | PSEUDO CODE/LOGIC
1022: |
1023: | PARAMETERS

Line 1081: INSERT INTO AR_IREC_PRINT_REQUESTS(REQUEST_ID, CUSTOMER_ID, CUSTOMER_SITE_USE_ID, REQUESTED_BY, PROGRAM_NAME, UPLOAD_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

1077:
1078: loop
1079: l_start_location := instr(l_req_id_list, ',', 1);
1080: if(l_start_location = 0) then
1081: INSERT INTO AR_IREC_PRINT_REQUESTS(REQUEST_ID, CUSTOMER_ID, CUSTOMER_SITE_USE_ID, REQUESTED_BY, PROGRAM_NAME, UPLOAD_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1082: VALUES (to_number(l_req_id_list), p_customer_id, p_customer_site_id, l_created_by, p_description, sysdate, l_created_by, l_creation_date, l_last_update_login, l_last_update_date, l_last_updated_by);
1083: exit;
1084: else
1085: l_request_id := substr(l_req_id_list, 1, l_start_location-1);

Line 1087: INSERT INTO AR_IREC_PRINT_REQUESTS(REQUEST_ID, CUSTOMER_ID, CUSTOMER_SITE_USE_ID, REQUESTED_BY, PROGRAM_NAME, UPLOAD_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

1083: exit;
1084: else
1085: l_request_id := substr(l_req_id_list, 1, l_start_location-1);
1086: l_req_id_list := substr(l_req_id_list, l_start_location+1);
1087: INSERT INTO AR_IREC_PRINT_REQUESTS(REQUEST_ID, CUSTOMER_ID, CUSTOMER_SITE_USE_ID, REQUESTED_BY, PROGRAM_NAME, UPLOAD_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1088: VALUES (to_number(l_request_id), p_customer_id, p_customer_site_id, l_created_by, p_description, sysdate, l_created_by, l_creation_date, l_last_update_login, l_last_update_date, l_last_updated_by);
1089: end if;
1090: end loop;
1091: commit;