APPS.QP_BULK_UTIL dependencies on QP_INTERFACE_LIST_HEADERS

Line 81: FROM qp_interface_list_headers

77: ,list_source_code
78: ,orig_sys_header_ref
79: ,orig_org_id
80: ,global_flag
81: FROM qp_interface_list_headers
82: WHERE request_id = p_request_id
83: AND process_status_flag = 'P' --IS NULL
84: AND interface_action_code='INSERT';
85:

Line 250: FROM qp_interface_list_headers a, qp_list_headers_vl b

246: a.list_source_code,
247: a.orig_sys_header_ref,
248: a.orig_org_id,
249: a.global_flag
250: FROM qp_interface_list_headers a, qp_list_headers_vl b
251: -- ENH undo alcoa changes RAVI
252: /**
253: The key between interface and qp tables is only orig_sys_hdr_ref
254: (not list_header_id)

Line 1578: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,

1574: orig_sys_pricing_attr_ref,error_message)
1575: SELECT
1576: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1577: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1578: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
1579: orig_sys_header_ref,null,null, null,l_msg_txt
1580: FROM QP_INTERFACE_LIST_HEADERS
1581: WHERE request_id = p_request_id
1582: AND interface_action_code = 'DELETE';

Line 1580: FROM QP_INTERFACE_LIST_HEADERS

1576: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1577: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1578: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,
1579: orig_sys_header_ref,null,null, null,l_msg_txt
1580: FROM QP_INTERFACE_LIST_HEADERS
1581: WHERE request_id = p_request_id
1582: AND interface_action_code = 'DELETE';
1583:
1584: UPDATE qp_interface_list_headers

Line 1584: UPDATE qp_interface_list_headers

1580: FROM QP_INTERFACE_LIST_HEADERS
1581: WHERE request_id = p_request_id
1582: AND interface_action_code = 'DELETE';
1583:
1584: UPDATE qp_interface_list_headers
1585: SET process_status_flag = NULL --'E'
1586: WHERE request_id = p_request_id
1587: AND interface_action_code = 'DELETE';
1588: