APPS.QP_BULK_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 1038: INSERT INTO qp_pricing_attributes

1034: FORALL I IN
1035: P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
1036: ..P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
1037:
1038: INSERT INTO qp_pricing_attributes
1039: ( PRICING_ATTRIBUTE_ID
1040: ,CREATION_DATE
1041: ,CREATED_BY
1042: ,LAST_UPDATE_DATE

Line 1093: QP_PRICING_ATTRIBUTES_S.nextval

1089: --VALUES
1090: --(
1091: -- Bug No 6028305
1092: SELECT
1093: QP_PRICING_ATTRIBUTES_S.nextval
1094: ,sysdate
1095: ,FND_GLOBAL.USER_ID
1096: ,sysdate
1097: ,FND_GLOBAL.USER_ID

Line 1481: UPDATE qp_pricing_attributes

1477: FORALL I IN
1478: P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
1479: ..P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
1480:
1481: UPDATE qp_pricing_attributes
1482: SET LAST_UPDATE_DATE =sysdate
1483: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
1484: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID
1485: ,PROGRAM_APPLICATION_ID =null

Line 1712: DELETE FROM QP_PRICING_ATTRIBUTES

1708: p_request_id);
1709:
1710:
1711: --delete if any PBH child lines
1712: DELETE FROM QP_PRICING_ATTRIBUTES
1713: WHERE list_line_id IN
1714: (SELECT ll.list_line_id
1715: FROM QP_INTERFACE_LIST_LINES il, QP_RLTD_MODIFIERS r,
1716: QP_LIST_LINES l, QP_LIST_LINES ll

Line 1749: DELETE FROM QP_PRICING_ATTRIBUTES

1745: AND l.orig_sys_header_ref = il.orig_sys_header_ref);
1746:
1747: --end
1748:
1749: DELETE FROM QP_PRICING_ATTRIBUTES
1750: WHERE list_line_id IN
1751: (SELECT l.list_line_id
1752: FROM QP_INTERFACE_LIST_LINES il,QP_LIST_LINES l
1753: WHERE il.request_id = p_request_id

Line 1818: (SELECT 'Y' FROM QP_PRICING_ATTRIBUTES qpp

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
1818: (SELECT 'Y' FROM QP_PRICING_ATTRIBUTES qpp
1819: WHERE qpp.orig_sys_pricing_attr_ref = qpip.orig_sys_pricing_attr_ref
1820: AND qpp.pricing_attribute_context IS NOT NULL
1821: AND qpp.request_id = p_request_id
1822: AND qpp.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 1865: qp_rltd_modifiers rb, qp_pricing_attributes pb

1861: )
1862: AND pricing_attr_value_to <>
1863: (SELECT max(to_number(pb.pricing_attr_value_to))
1864: FROM qp_list_lines la, qp_rltd_modifiers ra,
1865: qp_rltd_modifiers rb, qp_pricing_attributes pb
1866: WHERE la.orig_sys_line_ref = qpip.orig_sys_line_ref
1867: AND ra.to_rltd_modifier_id = la.list_line_id
1868: AND ra.rltd_modifier_grp_type = 'PRICE BREAK'
1869: AND ra.from_rltd_modifier_id = rb.from_rltd_modifier_id

Line 1881: DELETE FROM QP_PRICING_ATTRIBUTES

1877: p_request_id);
1878:
1879:
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

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