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 249: FROM qp_interface_list_headers a, qp_list_headers_vl b

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

Line 1577: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', NULL,

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

Line 1579: FROM QP_INTERFACE_LIST_HEADERS

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

Line 1583: UPDATE qp_interface_list_headers

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