DBA Data[Home] [Help]

APPS.OE_PRICE_LIST_LINE_UTIL dependencies on QP_LIST_LINES

Line 1546: UPDATE QP_LIST_LINES

1542: END IF;
1543:
1544: /* reprice_flag and tp_attributes are missing- need to add */
1545:
1546: UPDATE QP_LIST_LINES
1547: SET ATTRIBUTE1 = p_PRICE_LIST_LINE_rec.attribute1
1548: , ATTRIBUTE10 = p_PRICE_LIST_LINE_rec.attribute10
1549: , ATTRIBUTE11 = p_PRICE_LIST_LINE_rec.attribute11
1550: , ATTRIBUTE12 = p_PRICE_LIST_LINE_rec.attribute12

Line 1635: insert into qp_list_lines(

1631: x_return_status varchar2(30);
1632: BEGIN
1633: oe_debug_pub.add ( 'Insert Values' || p_PRICE_LIST_LINE_rec.comments );
1634:
1635: insert into qp_list_lines(
1636: LIST_LINE_ID,
1637: CREATION_DATE,
1638: CREATED_BY,
1639: LAST_UPDATE_DATE,

Line 1854: from qp_list_lines

1850: list lines */
1851:
1852: select list_line_type_code
1853: into l_list_line_type_code
1854: from qp_list_lines
1855: where list_line_id = p_price_list_line_id;
1856:
1857:
1858: if (l_list_line_type_code = 'PBH') then

Line 1862: DELETE FROM QP_LIST_LINES

1858: if (l_list_line_type_code = 'PBH') then
1859:
1860: for child_lines_rec in child_lines loop
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;

Line 1888: DELETE FROM QP_LIST_LINES

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;
1890:
1891: end if;
1892: