APPS.DDR_WEBSERVICES_PUB dependencies on DDR_WS_JOB_FILE_DLS

Line 1349: INSERT INTO ddr_ws_job_file_dls(file_id, job_id, file_name, status, delete_flag,src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr,

1345: UTL_FILE.put_line(l_xml_file,'');
1346: UTL_FILE.FCLOSE(l_xml_file);
1347: --update the job file metadata table with the file name
1348: BEGIN
1349: INSERT INTO ddr_ws_job_file_dls(file_id, job_id, file_name, status, delete_flag,src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr,
1350: created_by, creation_date, last_updated_by,
1351: last_update_date, last_update_login)
1352: VALUES (l_file_id, p_job_id, l_file_name, ddr_webservices_constants.g_ret_sts_success, 'N','ABC', SYSDATE, 'ABC', 'ABC',101, SYSDATE, 101,
1353: SYSDATE, 101);

Line 1379: INSERT INTO ddr_ws_job_file_dls

1375: UTL_FILE.put_line(l_xml_file, '');
1376: UTL_FILE.FCLOSE(l_xml_file);
1377: BEGIN
1378: -- DBMS_OUTPUT.PUT_LINE('third, l_file_id='||l_file_id);
1379: INSERT INTO ddr_ws_job_file_dls
1380: (file_id, job_id, file_name, status, delete_flag,
1381: src_sys_idnt, src_sys_dt, crtd_by_dsr, last_updt_by_dsr,
1382: created_by, creation_date, last_updated_by,
1383: last_update_date, last_update_login