APPS.QP_BULK_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 1039: INSERT INTO qp_pricing_attributes

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

Line 1094: QP_PRICING_ATTRIBUTES_S.nextval

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

Line 1482: UPDATE qp_pricing_attributes

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

Line 1713: DELETE FROM QP_PRICING_ATTRIBUTES

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

Line 1750: DELETE FROM QP_PRICING_ATTRIBUTES

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

Line 1819: (SELECT 'Y' FROM QP_PRICING_ATTRIBUTES qpp

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

Line 1866: qp_rltd_modifiers rb, qp_pricing_attributes pb

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

Line 1882: DELETE FROM QP_PRICING_ATTRIBUTES

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

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