APPS.QP_BULK_UTIL dependencies on QP_INTERFACE_PRICING_ATTRIBS

Line 877: from qp_interface_pricing_Attribs

873: AND P_LINE_REC.interface_Action_code(I) = 'UPDATE'
874: AND request_id=P_LINE_REC.REQUEST_ID(I)
875: AND (orig_sys_header_Ref,orig_Sys_line_ref) IN
876: (select orig_sys_header_Ref,orig_Sys_line_ref
877: from qp_interface_pricing_Attribs
878: where process_Status_flag is NULL
879: AND request_id=P_LINE_REC.REQUEST_ID(I)); -- updating for erred records
880: end loop;
881: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);

Line 1145: WHERE exists (SELECT 'Y' from qp_interface_pricing_Attribs

1141: ,P_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF(I)
1142: --);
1143: --6028305
1144: FROM DUAL
1145: WHERE exists (SELECT 'Y' from qp_interface_pricing_Attribs
1146: WHERE ORIG_SYS_PRICING_ATTR_REF=P_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF(I)
1147: AND request_id=P_PRICING_ATTR_REC.REQUEST_ID(I)
1148: AND process_status_flag is not null);
1149:

Line 1534: from qp_interface_pricing_Attribs

1530: AND ORIG_SYS_HEADER_REF = p_pricing_attr_rec.orig_sys_header_ref(I)
1531: AND P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I) = 'P'
1532: -- 6028305
1533: AND EXISTS (Select ORIG_SYS_PRICING_ATTR_REF
1534: from qp_interface_pricing_Attribs
1535: where ORIG_SYS_PRICING_ATTR_REF = P_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF(I)
1536: AND ORIG_SYS_LINE_REF = P_PRICING_ATTR_REC.ORIG_SYS_LINE_REF(I)
1537: AND ORIG_SYS_HEADER_REF =P_PRICING_ATTR_REC.ORIG_SYS_HEADER_REF(I)
1538: AND REQUEST_ID= P_PRICING_ATTR_REC.REQUEST_ID(I)

Line 1811: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,

1807: orig_sys_pricing_attr_ref,error_message)
1808: SELECT
1809: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1810: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1811: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1812: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1813: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1814: WHERE request_id = p_request_id
1815: AND process_status_flag = 'P' --is null

Line 1813: FROM QP_INTERFACE_PRICING_ATTRIBS qpip

1809: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1810: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1811: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1812: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1813: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1814: WHERE request_id = p_request_id
1815: AND process_status_flag = 'P' --is null
1816: AND interface_action_code = 'DELETE'
1817: AND NOT EXISTS

Line 1850: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,

1846: orig_sys_pricing_attr_ref,error_message)
1847: SELECT
1848: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1849: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1850: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1851: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1852: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1853: WHERE request_id = p_request_id
1854: AND process_status_flag = 'P' --is null

Line 1852: FROM QP_INTERFACE_PRICING_ATTRIBS qpip

1848: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
1849: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 660,
1850: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,
1851: orig_sys_header_ref,orig_sys_line_ref,null,orig_sys_pricing_attr_ref, l_msg_txt
1852: FROM QP_INTERFACE_PRICING_ATTRIBS qpip
1853: WHERE request_id = p_request_id
1854: AND process_status_flag = 'P' --is null
1855: AND interface_action_code = 'DELETE'
1856: AND EXISTS (SELECT 'PRICE BREAK CHILD LINE'

Line 1884: FROM QP_INTERFACE_PRICING_ATTRIBS ipa, QP_PRICING_ATTRIBUTES pa

1880: --delete the records
1881: DELETE FROM QP_PRICING_ATTRIBUTES
1882: WHERE pricing_attribute_id IN
1883: (SELECT pa.pricing_attribute_id
1884: FROM QP_INTERFACE_PRICING_ATTRIBS ipa, QP_PRICING_ATTRIBUTES pa
1885: WHERE ipa.request_id = p_request_id
1886: AND ipa.interface_action_code = 'DELETE'
1887: AND ipa.process_status_flag = 'P' --IS NULL
1888: AND ipa.orig_sys_line_ref = pa.orig_sys_line_ref

Line 1894: UPDATE qp_interface_pricing_attribs

1890: AND ipa.orig_sys_pricing_attr_ref = pa.orig_sys_pricing_attr_ref);
1891:
1892: qp_bulk_loader_pub.write_log('Number of PA deleted: '||to_char(SQL%ROWCOUNT));
1893: --Set process_status_flag of sucessfully deleted records
1894: UPDATE qp_interface_pricing_attribs
1895: SET process_status_flag ='I'
1896: WHERE process_status_flag = 'P' --IS NULL
1897: AND request_id = p_request_id
1898: AND interface_action_code = 'DELETE';