APPS.QP_BULK_UTIL dependencies on QP_INTERFACE_QUALIFIERS

Line 1624: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,

1620: orig_sys_pricing_attr_ref, error_message)
1621: SELECT
1622: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1623: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1624: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
1625: orig_sys_header_ref,null,orig_sys_qualifier_ref,null, l_msg_txt
1626: FROM QP_INTERFACE_QUALIFIERS qpiq
1627: WHERE request_id = p_request_id
1628: AND interface_action_code = 'DELETE'

Line 1626: FROM QP_INTERFACE_QUALIFIERS qpiq

1622: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1623: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1624: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,
1625: orig_sys_header_ref,null,orig_sys_qualifier_ref,null, l_msg_txt
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

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

Line 1654: UPDATE qp_interface_qualifiers

1650:
1651: qp_bulk_loader_pub.write_log('Qualifier Records Deleted: '|| sql%rowcount);
1652:
1653: --Set process_status_flag of sucessfully deleted records
1654: UPDATE qp_interface_qualifiers
1655: SET process_status_flag ='I'
1656: WHERE process_status_flag = 'P' --IS NULL
1657: AND request_id = p_request_id
1658: AND interface_action_code = 'DELETE';