APPS.OE_PRICE_LIST_LINE_UTIL dependencies on QP_PRICING_ATTRIBUTES

Line 1865: DELETE FROM QP_PRICING_ATTRIBUTES

1861:
1862: DELETE FROM QP_LIST_LINES
1863: WHERE LIST_LINE_ID = child_lines_rec.to_rltd_modifier_id;
1864:
1865: DELETE FROM QP_PRICING_ATTRIBUTES
1866: WHERE LIST_LINE_ID = child_lines_rec.to_rltd_modifier_id;
1867:
1868: QP_RLTD_MODIFIER_PVT.Delete_Row(child_lines_rec.rltd_modifier_id);
1869:

Line 1885: DELETE FROM QP_PRICING_ATTRIBUTES

1881: WHEN NO_DATA_FOUND THEN NULL;
1882:
1883: END;
1884:
1885: DELETE FROM QP_PRICING_ATTRIBUTES
1886: WHERE LIST_LINE_ID = p_price_list_line_id;
1887:
1888: DELETE FROM QP_LIST_LINES
1889: WHERE LIST_LINE_ID = p_price_list_line_id;

Line 2712: from qp_pricing_attributes

2708:
2709:
2710: select 1
2711: into l_count
2712: from qp_pricing_attributes
2713: where list_line_id = p_list_line_id
2714: for update nowait;
2715:
2716: exception

Line 3199: SELECT QP_PRICING_ATTRIBUTES_S.nextval

3195: oe_debug_pub.add ( 'Geresh 18 :: Before Insert into Pricing attributes Maintain attributes ' );
3196:
3197: FOR I in 1..l_pricing_attr_tbl.count loop
3198:
3199: SELECT QP_PRICING_ATTRIBUTES_S.nextval
3200: INTO l_pricing_attribute_id
3201: from dual;
3202:
3203: QP_PRICING_ATTRIBUTE_PVT.Insert_Row(

Line 3379: FROM QP_PRICING_ATTRIBUTES

3375: , PROGRAM_APPLICATION_ID
3376: , PROGRAM_ID
3377: , PROGRAM_UPDATE_DATE
3378: , REQUEST_ID
3379: FROM QP_PRICING_ATTRIBUTES
3380: WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
3381: )
3382: OR ( LIST_LINE_ID = p_list_line_id
3383: );