APPS.QP_BULK_UTIL dependencies on QP_QUALIFIERS

Line 910: INSERT INTO qp_qualifiers

906: qp_bulk_loader_pub.write_log('Entering Insert Qualifier');
907: FORALL I IN
908: P_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST..P_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
909:
910: INSERT INTO qp_qualifiers
911: ( QUALIFIER_ID
912: ,CREATION_DATE
913: ,CREATED_BY
914: ,LAST_UPDATE_DATE

Line 1407: UPDATE qp_qualifiers

1403: qp_bulk_loader_pub.write_log('Entering Update Qualifier');
1404: FORALL I IN
1405: P_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST..P_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
1406:
1407: UPDATE qp_qualifiers
1408: SET LAST_UPDATE_DATE =SYSDATE
1409: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1410: ,REQUEST_ID =P_QUALIFIER_REC.request_id(I)
1411: ,PROGRAM_APPLICATION_ID =660

Line 1630: (SELECT 'Y' FROM QP_QUALIFIERS qpq

1626: FROM QP_INTERFACE_QUALIFIERS qpiq
1627: WHERE request_id = p_request_id
1628: AND interface_action_code = 'DELETE'
1629: AND NOT EXISTS
1630: (SELECT 'Y' FROM QP_QUALIFIERS qpq
1631: WHERE qpq.orig_sys_qualifier_ref = qpiq.orig_sys_qualifier_ref
1632: AND qpq.orig_sys_header_ref = qpiq.orig_sys_header_ref) ;
1633:
1634: --set process status flag

Line 1641: DELETE FROM QP_QUALIFIERS

1637: ('QUALIFIER',
1638: p_request_id);
1639:
1640: --delete the records
1641: DELETE FROM QP_QUALIFIERS
1642: WHERE rowid IN
1643: (SELECT q.rowid
1644: FROM QP_INTERFACE_QUALIFIERS iq, QP_QUALIFIERS q
1645: WHERE iq.request_id = p_request_id

Line 1644: FROM QP_INTERFACE_QUALIFIERS iq, QP_QUALIFIERS q

1640: --delete the records
1641: DELETE FROM QP_QUALIFIERS
1642: WHERE rowid IN
1643: (SELECT q.rowid
1644: FROM QP_INTERFACE_QUALIFIERS iq, QP_QUALIFIERS q
1645: WHERE iq.request_id = p_request_id
1646: AND iq.interface_action_code = 'DELETE'
1647: AND iq.process_status_flag = 'P' --IS NULL
1648: AND iq.orig_sys_qualifier_ref = q.orig_sys_qualifier_ref