APPS.QP_BULK_UTIL dependencies on QP_QUALIFIERS

Line 909: INSERT INTO qp_qualifiers

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

Line 1406: UPDATE qp_qualifiers

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

Line 1629: (SELECT 'Y' FROM QP_QUALIFIERS qpq

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

Line 1640: DELETE FROM QP_QUALIFIERS

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

Line 1643: FROM QP_INTERFACE_QUALIFIERS iq, QP_QUALIFIERS q

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