APPS.QP_BULK_UTIL dependencies on QP_INTERFACE_PRICING_ATTRIBS

Line 878: from qp_interface_pricing_Attribs

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

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

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

Line 1535: from qp_interface_pricing_Attribs

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

Line 1812: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,

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

Line 1814: FROM QP_INTERFACE_PRICING_ATTRIBS qpip

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

Line 1851: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', NULL,

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

Line 1853: FROM QP_INTERFACE_PRICING_ATTRIBS qpip

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

Line 1885: FROM QP_INTERFACE_PRICING_ATTRIBS ipa, QP_PRICING_ATTRIBUTES pa

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

Line 1895: UPDATE qp_interface_pricing_attribs

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