APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on QP_LIST_LINES

Line 11: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');

7: BEGIN
8:
9: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');
10:
11: QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');
12:
13: EXCEPTION
14:
15: WHEN OTHERS THEN

Line 72: from qp_LIST_lines )

68: price_list_line_id
69: from
70: so_price_list_lines_115
71: where price_list_line_id not in ( select list_line_id
72: from qp_LIST_lines )
73: order by price_list_line_id;
74:
75:
76: l_total_lines number;

Line 107: from qp_LIST_lines );

103: l_max_line
104: from
105: so_price_list_lines_115
106: where price_list_line_id not in ( select list_line_id
107: from qp_LIST_lines );
108:
109: exception
110: when others then
111: null;

Line 1101: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');

1097:
1098: -- Upgrade_Flex_Structures;
1099:
1100: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LISTS', 'QP_LIST_HEADERS');
1101: -- QP_UTIL.QP_UPGRADE_CONTEXT('OE', 'QP', 'SO_PRICE_LIST_LINES', 'QP_LIST_LINES');
1102:
1103: EXCEPTION
1104:
1105: WHEN OTHERS THEN

Line 1441: from qp_LIST_lines

1437: where prl.price_list_id in ( select list_header_id
1438: from qp_LIST_headers_b
1439: where list_type_code = 'PRL')
1440: and not exists ( select null
1441: from qp_LIST_lines
1442: where list_line_id = prl.price_list_line_id )
1443: and prl.price_list_line_id between l_min_line and l_max_line;
1444:
1445: /* vivek

Line 1509: from qp_LIST_lines

1505: where prl.price_list_id = qph.list_header_id
1506: and prl.price_list_id in ( select price_list_id
1507: from so_agreements_b)
1508: and not exists ( select null
1509: from qp_LIST_lines
1510: where list_line_id = prl.price_list_line_id )
1511: comment start
1512: and not exists ( select null
1513: from qp_discount_mapping

Line 1763: select qp_list_lines_s.nextval

1759: IF ( agr_old_price_lists.exists(price_list_ids(K))
1760: and ( agr_types(K) is not null
1761: and agr_types(K) = 'AGR') ) then
1762:
1763: select qp_list_lines_s.nextval
1764: into new_prc_list_line_id
1765: from dual;
1766:
1767: price_list_line_ids(K) := new_prc_list_line_id;

Line 1820: insert into qp_LIST_lines(

1816:
1817: BEGIN /* forall k in 1_min_line..l_max_line */
1818:
1819: FORALL K IN start_prc_list_line_id..end_prc_list_line_id
1820: insert into qp_LIST_lines(
1821: LIST_LINE_ID,
1822: LIST_LINE_NO,
1823: CREATION_DATE,
1824: CREATED_BY,

Line 2897: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))

2893: prc_datatypes(J),
2894: l_prod_datatype
2895: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2896: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
2897: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
2898: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
2899: );
2900:
2901:

Line 2898: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))

2894: l_prod_datatype
2895: --ENH Upgrade BOAPI for orig_sys...ref RAVI
2896: ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
2897: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
2898: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
2899: );
2900:
2901:
2902: EXCEPTION