APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_IMP_ERRORS

Line 118: INSERT INTO OKS_IMP_ERRORS

114: END IF;
115:
116: l_stmt_num := 10;
117:
118: INSERT INTO OKS_IMP_ERRORS
119: (REQUEST_ID,
120: PARENT_REQUEST_ID,
121: INTERFACE_TABLE,
122: HEADER_INTERFACE_ID,

Line 508: INSERT INTO OKS_IMP_ERRORS

504: UPDATE oks_headers_interface
505: SET interface_status ='E'
506: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
507:
508: INSERT INTO OKS_IMP_ERRORS
509: (REQUEST_ID,
510: PARENT_REQUEST_ID,
511: INTERFACE_TABLE,
512: HEADER_INTERFACE_ID,

Line 528: INSERT INTO OKS_IMP_ERRORS

524: UPDATE oks_headers_interface
525: SET interface_status ='E'
526: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
527:
528: INSERT INTO OKS_IMP_ERRORS
529: (REQUEST_ID,
530: PARENT_REQUEST_ID,
531: INTERFACE_TABLE,
532: HEADER_INTERFACE_ID,

Line 548: INSERT INTO OKS_IMP_ERRORS

544: UPDATE oks_headers_interface
545: SET interface_status ='E'
546: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
547:
548: INSERT INTO OKS_IMP_ERRORS
549: (REQUEST_ID,
550: PARENT_REQUEST_ID,
551: INTERFACE_TABLE,
552: HEADER_INTERFACE_ID,

Line 567: INSERT INTO OKS_IMP_ERRORS

563: IF(process_rec.line_flow =-3)THEN
564: UPDATE oks_headers_interface
565: SET interface_status ='E'
566: WHERE header_interface_id =process_rec.HEADER_INTERFACE_ID;
567: INSERT INTO OKS_IMP_ERRORS
568: (REQUEST_ID,
569: PARENT_REQUEST_ID,
570: INTERFACE_TABLE,
571: HEADER_INTERFACE_ID,