APPS.QP_BULK_UTIL dependencies on QP_INTERFACE_QUALIFIERS

Line 1623: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', NULL,

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

Line 1625: FROM QP_INTERFACE_QUALIFIERS qpiq

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

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

Line 1653: UPDATE qp_interface_qualifiers

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