APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_PRICE_ADJ_ATTRIBS_S

Line 2224: , PO_PRICE_ADJ_ATTRIBS_S.nextval

2220: , QPLAT.comparison_operator_type_code
2221: , decode(QPLAT.attribute_type,
2222: 'QUALIFIER', 'QP_ATTR_DEFNS_QUALIFIER',
2223: 'QP_ATTR_DEFNS_PRICING')
2224: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2225: , 1
2226: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2227: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2228: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)

Line 2306: , PO_PRICE_ADJ_ATTRIBS_S.nextval

2302: , QPLAT.comparison_operator_type_code
2303: , decode(QPLAT.attribute_type,
2304: 'QUALIFIER', 'QP_ATTR_DEFNS_QUALIFIER',
2305: 'QP_ATTR_DEFNS_PRICING')
2306: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2307: , 1
2308: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2309: , QP_LDETS_v LDETS
2310: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ

Line 2413: , PO_PRICE_ADJ_ATTRIBS_S.nextval

2409: , PRA.pricing_attr_value_from --VALUE_FROM
2410: , PRA.pricing_attr_value_to --VALUE_TO
2411: , PRA.comparison_operator_code
2412: , 'QP_ATTR_DEFNS_PRICING' --FLEX_TITLE
2413: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2414: , 1
2415: FROM QP_PRICING_ATTRIBUTES PRA
2416: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJD
2417: WHERE ADJD.draft_id = p_draft_id

Line 2473: , PO_PRICE_ADJ_ATTRIBS_S.nextval

2469: , QUAL.qualifier_attr_value --VALUE_FROM
2470: , QUAL.qualifier_attr_value_to --VALUE_TO
2471: , QUAL.comparison_operator_code
2472: , 'QP_ATTR_DEFNS_QUALIFIER' --FLEX_TITLE
2473: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2474: , 1
2475: FROM QP_QUALIFIERS QUAL
2476: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJD
2477: WHERE ADJD.draft_id = p_draft_id

Line 2755: , PO_PRICE_ADJ_ATTRIBS_S.nextval

2751: , ATTR.pricing_attr_value_from
2752: , ATTR.pricing_attr_value_to
2753: , ATTR.comparison_operator
2754: , ATTR.FLEX_TITLE
2755: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2756: , 1
2757: FROM PO_PRICE_ADJ_ATTRIBS ATTR
2758: WHERE ATTR.price_adjustment_id = l_src_price_adjustment_id);
2759: l_dest_attr_count := l_dest_attr_count + SQL%ROWCOUNT;

Line 3161: , PO_PRICE_ADJ_ATTRIBS_S.nextval

3157: , ATTRV.pricing_attr_value_from
3158: , ATTRV.pricing_attr_value_to
3159: , ATTRV.comparison_operator
3160: , ATTRV.FLEX_TITLE
3161: , PO_PRICE_ADJ_ATTRIBS_S.nextval
3162: , 1
3163: FROM PO_PRICE_ADJ_ATTRIBS_V ATTRV
3164: WHERE ATTRV.price_adjustment_id = l_src_price_adjustment_id); --ATTRV.draft_id = p_draft_id --draft_id may not have been initialized when copy event was triggered
3165: l_dest_attr_count := l_dest_attr_count + SQL%ROWCOUNT;