eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PREQ_GRP dependencies on QP_PREQ_PUB

Line 12411: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN

12407: -- if break uom was set up, then get the passed break uom
12408: -- if break_uom is not set up, then no proration and proceed with normal price break evaluation
12409: -- feb 22 toi comment end
12410: -- price book
12411: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
12412: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12413: engine_debug('call from price book with proration ==> skip this break entirely');
12414: END IF;
12415: EXIT; -- exit big loop to stop processing remaining child lines

Line 19573: IF (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) THEN -- price book

19569: x_status_code := FND_API.G_RET_STS_SUCCESS;
19570:
19571: IF (p_pricing_phase_id <> G_PRICE_LIST_PHASE_ID) THEN -- Only for modifiers ask for list headers/lines
19572:
19573: IF (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) THEN -- price book
19574: -- Validated List Headers / List Lines
19575:
19576: qp_debug_util.tstart('L_VALIDATED_CUR_EXT','Cursor Loop L_VALIDATED_CUR exterior');
19577:

Line 25557: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

25553: and qpl.list_line_id = qpprod.list_line_id
25554: and (qpl.modifier_level_code = qplines.line_type_code
25555: OR
25556: (qpl.modifier_level_code = G_LINE_GROUP and
25557: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
25558: and TRUNC(qplines.pricing_effective_date) BETWEEN
25559: nvl(TRUNC(qpl.start_date_active), TRUNC(qplines.pricing_effective_date))
25560: and nvl(TRUNC(qpl.end_date_active),TRUNC(qplines.pricing_effective_date))
25561: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 25576: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

25572: --and qpq.search_ind = 1
25573: and qplatpr.attribute_type='PRODUCT'
25574: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
25575: -- price book
25576: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25577: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25578: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25579: or
25580: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 25580: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

25576: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25577: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25578: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25579: or
25580: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25581: union all
25582: select /*+ ORDERED USE_NL(QPLATPR QPPROD QPL) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpr qp_preq_line_attrs_tmp_n1) l_prod_qual_cur_mod */
25583: qpl.list_header_id,
25584: qpl.list_line_id,

Line 25647: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

25643: and qpl.list_line_id = qpprod.list_line_id
25644: and (qpl.modifier_level_code = qplines.line_type_code
25645: OR
25646: (qpl.modifier_level_code = G_LINE_GROUP and
25647: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
25648: and TRUNC(qplines.pricing_effective_date) BETWEEN
25649: nvl(TRUNC(qpl.start_date_active), TRUNC(qplines.pricing_effective_date))
25650: and nvl(TRUNC(qpl.end_date_active),TRUNC(qplines.pricing_effective_date))
25651: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 25665: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

25661: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
25662: --and qpq.pricing_status_code=G_STATUS_UNCHANGED
25663: --and qpq.search_ind = 1
25664: -- price book
25665: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25666: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25667: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25668: or
25669: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 25669: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

25665: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25666: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25667: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25668: or
25669: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25670: order by 4,2;
25671:
25672: /*
25673: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1

Line 25804: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

25800: and qpl.list_line_id = qpprod.list_line_id
25801: and (qpl.modifier_level_code = qplines.line_type_code
25802: OR
25803: (qpl.modifier_level_code = G_LINE_GROUP and
25804: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
25805: and TRUNC(qplines.pricing_effective_date) BETWEEN
25806: nvl(TRUNC(qpl.start_date_active), TRUNC(qplines.pricing_effective_date))
25807: AND nvl(TRUNC(qpl.end_date_active),TRUNC(qplines.pricing_effective_date))
25808: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 25835: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

25831: and qplatpc.pricing_status_code = G_STATUS_UNCHANGED
25832: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
25833: --and qpq.search_ind = 1
25834: -- price book
25835: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25836: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25837: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25838: or
25839: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 25839: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

25835: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25836: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25837: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25838: or
25839: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25840: union all
25841: select /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPL ) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpr qp_preq_line_attrs_tmp_N1) index(qplatpc qp_preq_line_attrs_tmp_N2) l_prod_qual_pric_cur_mod */
25842: qpl.list_header_id,
25843: qpl.list_line_id,

Line 25918: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

25914: and qpl.list_line_id = qpprod.list_line_id
25915: and (qpl.modifier_level_code = qplines.line_type_code
25916: OR
25917: (qpl.modifier_level_code = G_LINE_GROUP and
25918: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
25919: and TRUNC(qplines.pricing_effective_date) BETWEEN
25920: nvl(TRUNC(qpl.start_date_active), TRUNC(qplines.pricing_effective_date))
25921: AND nvl(TRUNC(qpl.end_date_active),TRUNC(qplines.pricing_effective_date))
25922: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 25946: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

25942: and qplatpc.pricing_status_code = G_STATUS_UNCHANGED
25943: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
25944: --and qpq.search_ind = 1
25945: -- price book
25946: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25947: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25948: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25949: or
25950: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 25950: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

25946: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
25947: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
25948: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25949: or
25950: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25951: order by 4,2;
25952:
25953: /*
25954: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

Line 26024: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

26020: and qpl.list_line_id = qpq.list_line_id
26021: and (qpl.modifier_level_code = qpq.line_type_code
26022: OR
26023: (qpl.modifier_level_code = G_LINE_GROUP and
26024: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
26025: and qpq.pricing_effective_date BETWEEN
26026: nvl(TRUNC(qpl.start_date_active), qpq.pricing_effective_date)
26027: AND nvl(TRUNC(qpl.end_date_active),qpq.pricing_effective_date)
26028: and qpl.QUALIFICATION_IND in (QP_PREQ_GRP.G_YES_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_HDR_LINE_QUAL_IND)

Line 26034: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

26030: and qpl.pricing_phase_id = p_pricing_phase_id
26031: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
26032: --and qpq.search_ind = 1
26033: -- price book
26034: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26035: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26036: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26037: or
26038: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 26038: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

26034: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26035: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26036: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26037: or
26038: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
26039: union all
26040: select /*+ ORDERED INDEX(qpl,QP_LIST_LINES_N5) l_inner_qual_cur */
26041: qpl.list_header_id,
26042: qpl.list_line_id,

Line 26091: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

26087: qpl.list_header_id = qpq.list_header_id
26088: and (qpl.modifier_level_code = qpq.line_type_code
26089: OR
26090: (qpl.modifier_level_code = G_LINE_GROUP and
26091: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
26092: and qpq.pricing_effective_date BETWEEN
26093: nvl(TRUNC(qpl.start_date_active), qpq.pricing_effective_date)
26094: AND nvl(TRUNC(qpl.end_date_active),qpq.pricing_effective_date)
26095: and qpl.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_HDR_QUAL_IND

Line 26101: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

26097: and qpl.pricing_phase_id = p_pricing_phase_id
26098: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
26099: --and qpq.search_ind = 1
26100: -- price book
26101: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26102: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26103: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26104: or
26105: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 26105: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

26101: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26102: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26103: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26104: or
26105: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
26106: order by 4,2;
26107:
26108:
26109: /*

Line 26217: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

26213: qplines.line_type_code = G_ORDER_LEVEL)
26214: and (qpl.modifier_level_code = qplines.line_type_code
26215: OR
26216: (qpl.modifier_level_code = G_LINE_GROUP and
26217: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
26218: and qph.active_flag = G_YES
26219: AND ((qph.ASK_FOR_FLAG = G_YES and exists (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/pricebook]
26220: FROM qp_npreq_line_attrs_tmp la
26221: WHERE attribute_type = 'QUALIFIER'

Line 26262: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

26258: AND QPLATPR.LINE_INDEX = QPLINES.LINE_INDEX
26259: and qplatpr.attribute_type='PRODUCT'
26260: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
26261: -- price book
26262: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26263: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26264: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26265: or
26266: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 26266: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

26262: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26263: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26264: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26265: or
26266: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
26267: order by 4,2;
26268:
26269: /*
26270: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

Line 26386: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

26382: qplines.line_type_code = G_ORDER_LEVEL)
26383: and (qpl.modifier_level_code = qplines.line_type_code
26384: OR
26385: (qpl.modifier_level_code = G_LINE_GROUP and
26386: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
26387: and qph.active_flag = G_YES
26388: AND ((qph.ASK_FOR_FLAG = G_YES and exists (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/pricebook]
26389: FROM qp_npreq_line_attrs_tmp la
26390: WHERE attribute_type = 'QUALIFIER'

Line 26444: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

26440: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
26441: and qplatpc.attribute_type = 'PRICING'
26442: and qplatpc.pricing_status_code = G_STATUS_UNCHANGED
26443: -- price book
26444: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26445: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26446: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26447: or
26448: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 26448: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

26444: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26445: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26446: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26447: or
26448: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
26449: order by 4,2;
26450:
26451: /*
26452: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1

Line 26539: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

26535: qplines.line_type_code = G_ORDER_LEVEL)
26536: and (qpl.modifier_level_code = qplines.line_type_code
26537: OR
26538: (qpl.modifier_level_code = G_LINE_GROUP and
26539: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
26540: and nvl(TRUNC(qplines.pricing_effective_date),TRUNC(SYSDATE)) BETWEEN
26541: nvl(qph.start_date_active,nvl(TRUNC(qplines.pricing_effective_date),TRUNC(SYSDATE))) AND
26542: nvl(qph.end_date_active,nvl(TRUNC(qplines.pricing_effective_date),TRUNC(SYSDATE)))
26543: and nvl(qplines.start_date_active_first,TRUNC(SYSDATE)) BETWEEN

Line 26561: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

26557: AND nvl(TRUNC(qpl.end_date_active),TRUNC(qplines.pricing_effective_date))
26558: and qph.source_system_code = qprs.source_system_code
26559: and qplines.request_type_code = qprs.request_type_code
26560: -- price book
26561: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26562: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26563: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26564: or
26565: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 26565: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

26561: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
26562: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
26563: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
26564: or
26565: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
26566: order by 4,2;
26567:
26568: /*
26569: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1

Line 27072: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN

27068: END IF;
27069: --hw
27070: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), 'Y');
27071: --[julin/pricebook]
27072: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
27073: l_satis_quals_opt := 'N';
27074: END IF;
27075:
27076: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 31152: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31148: FROM --[julin/5007789]
31149: (SELECT /*+ dynamic_sampling(1) */ *
31150: FROM qp_npreq_lines_tmp
31151: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31152: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31153: qp_npreq_line_attrs_tmp qplatq,
31154: qp_qualifiers qpq,
31155: qp_list_headers_b qph,
31156: qp_price_req_sources_v qprs,

Line 31262: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31258: FROM --[julin/5007789]
31259: (SELECT /*+ dynamic_sampling(1) */ *
31260: FROM qp_npreq_lines_tmp
31261: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31262: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31263: qp_npreq_line_attrs_tmp qplatq,
31264: qp_qualifiers qpq,
31265: qp_list_headers_b qph,
31266: qp_price_req_sources_v qprs,

Line 31372: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31368: FROM --[julin/5007789]
31369: (SELECT /*+ dynamic_sampling(1) */ *
31370: FROM qp_npreq_lines_tmp
31371: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31372: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31373: qp_npreq_line_attrs_tmp qplatq,
31374: qp_qualifiers qpq,
31375: qp_list_headers_b qph,
31376: qp_price_req_sources_v qprs,

Line 31501: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31497: FROM --[julin/5007789]
31498: (SELECT /*+ dynamic_sampling(1) */ *
31499: FROM qp_npreq_lines_tmp
31500: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31501: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31502: qp_npreq_line_attrs_tmp qplatq,
31503: qp_qualifiers qpq,
31504: qp_list_headers_b qph,
31505: qp_price_req_sources_v qprs,

Line 31658: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31654: FROM --[julin/5007789]
31655: (SELECT /*+ dynamic_sampling(1) */ *
31656: FROM qp_npreq_lines_tmp
31657: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31658: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31659: qp_npreq_line_attrs_tmp qplatq,
31660: qp_qualifiers qpq,
31661: qp_list_headers_b qph,
31662: qp_price_req_sources_v qprs,

Line 31815: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31811: FROM --[julin/5007789]
31812: (SELECT /*+ dynamic_sampling(1) */ *
31813: FROM qp_npreq_lines_tmp
31814: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31815: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31816: qp_npreq_line_attrs_tmp qplatq,
31817: qp_qualifiers qpq,
31818: qp_list_headers_b qph,
31819: qp_price_req_sources_v qprs,

Line 31985: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

31981: FROM --[julin/5007789]
31982: (SELECT /*+ dynamic_sampling(1) */ *
31983: FROM qp_npreq_lines_tmp
31984: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
31985: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31986: qp_npreq_line_attrs_tmp qplatq,
31987: qp_qualifiers qpq ,
31988: qp_list_headers_b qph,
31989: qp_price_req_sources_v qprs,

Line 32113: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32109: FROM --[julin/5007789]
32110: (SELECT /*+ dynamic_sampling(1) */ *
32111: FROM qp_npreq_lines_tmp
32112: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32113: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32114: qp_npreq_line_attrs_tmp qplatq,
32115: qp_qualifiers qpq ,
32116: qp_list_headers_b qph,
32117: qp_price_req_sources_v qprs,

Line 32241: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32237: FROM --[julin/5007789]
32238: (SELECT /*+ dynamic_sampling(1) */ *
32239: FROM qp_npreq_lines_tmp
32240: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32241: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32242: qp_npreq_line_attrs_tmp qplatq,
32243: qp_qualifiers qpq ,
32244: qp_list_headers_b qph,
32245: qp_price_req_sources_v qprs,

Line 32389: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32385: FROM --[julin/5007789]
32386: (SELECT /*+ dynamic_sampling(1) */ *
32387: FROM qp_npreq_lines_tmp
32388: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32389: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32390: qp_npreq_line_attrs_tmp qplatq,
32391: qp_qualifiers qpq ,
32392: qp_list_headers_b qph,
32393: qp_price_req_sources_v qprs,

Line 32564: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32560: FROM --[julin/5007789]
32561: (SELECT /*+ dynamic_sampling(1) */ *
32562: FROM qp_npreq_lines_tmp
32563: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32564: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32565: qp_npreq_line_attrs_tmp qplatq,
32566: qp_qualifiers qpq ,
32567: qp_list_headers_b qph,
32568: qp_price_req_sources_v qprs,

Line 32739: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32735: FROM --[julin/5007789]
32736: (SELECT /*+ dynamic_sampling(1) */ *
32737: FROM qp_npreq_lines_tmp
32738: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
32739: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32740: qp_npreq_line_attrs_tmp qplatq,
32741: qp_qualifiers qpq ,
32742: qp_list_headers_b qph,
32743: qp_price_req_sources_v qprs,

Line 32896: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32892: FROM --[julin/5000789]
32893: (SELECT /*+ dynamic_sampling(1) */ *
32894: FROM qp_npreq_lines_tmp
32895: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
32896: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32897: qp_npreq_line_attrs_tmp qplatpr,
32898: qp_pricing_attributes qpprod ,
32899: qp_list_lines qpl ,
32900: qp_list_headers_b qph ,

Line 32983: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

32979: FROM --[julin/5007789]
32980: (SELECT /*+ dynamic_sampling(1) */ *
32981: FROM qp_npreq_lines_tmp
32982: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
32983: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32984: qp_npreq_line_attrs_tmp qplatpr,
32985: qp_pricing_attributes qpprod,
32986: qp_list_lines qpl,
32987: qp_list_headers_b qph,

Line 33117: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

33113: FROM --[julin/5007789]
33114: (SELECT /*+ dynamic_sampling(1) */ *
33115: FROM qp_npreq_lines_tmp
33116: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
33117: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
33118: qp_npreq_line_attrs_tmp qplatpr,
33119: qp_pricing_attributes qpprod,
33120: qp_npreq_line_attrs_tmp qplatpc,
33121: qp_list_lines qpl,

Line 33223: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

33219: FROM --[julin/5007789]
33220: (SELECT /*+ dynamic_sampling(1) */ *
33221: FROM qp_npreq_lines_tmp
33222: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
33223: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
33224: qp_npreq_line_attrs_tmp qplatpr,
33225: qp_pricing_attributes qpprod ,
33226: qp_npreq_line_attrs_tmp qplatpc,
33227: qp_list_lines qpl ,

Line 37870: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES))

37866: AND intmdt.line_index = qplines.line_index
37867: AND intmdt.pricing_status_code=QP_PREQ_GRP.G_STATUS_UNCHANGED
37868: AND(atrgrps.modifier_level_code = qplines.line_type_code
37869: OR (atrgrps.modifier_level_code = qp_preq_grp.g_line_group and
37870: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES))
37871: AND((atrgrps.currency_code IS NOT NULL
37872: AND atrgrps.currency_code = qp_preq_grp.g_currency_code)
37873: OR atrgrps.currency_code IS NULL) -- optional currency
37874: AND TRUNC(nvl(qplines.pricing_effective_date, sysdate))

Line 37896: AND (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES AND

37892: AND list_header_id = atrgrps.list_header_id
37893: AND line_index = qplines.line_index)
37894: )
37895: OR atrgrps.ask_for_flag = qp_preq_grp.g_no)
37896: AND (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES AND
37897: atrgrps.list_line_type_code NOT IN (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
37898: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE) AND
37899: atrgrps.automatic_flag = 'Y'
37900: OR

Line 37901: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES);

37897: atrgrps.list_line_type_code NOT IN (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
37898: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE) AND
37899: atrgrps.automatic_flag = 'Y'
37900: OR
37901: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES);
37902: /*UNION ALL
37903: SELECT
37904: ---This union all is to fetch all the lines whose header_quals_exist_flag is N(means pure no header quals)
37905: + ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3) index(qppattmp QP_NPREQ_LINE_PATRNS_T_N2) l_line_cache_cur */

Line 37939: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES))

37935: AND atrgrps.list_type_code NOT IN('PRL', 'AGR') -- Filter
37936: AND atrgrps.active_flag = 'Y' -- Filter
37937: AND(atrgrps.modifier_level_code = qplines.line_type_code
37938: OR (atrgrps.modifier_level_code = qp_preq_grp.g_line_group and
37939: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES))
37940: AND( qplines.unit_price IS NOT NULL
37941: OR qplines.usage_pricing_type = qp_preq_grp.g_authoring_type
37942: OR qplines.line_type_code = qp_preq_grp.g_order_level
37943: )

Line 37984: AND (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES AND

37980: AND list_header_id = atrgrps.list_header_id
37981: AND line_index = qplines.line_index)
37982: )
37983: OR atrgrps.ask_for_flag = qp_preq_grp.g_no)
37984: AND (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES AND
37985: atrgrps.list_line_type_code NOT IN (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
37986: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE) AND
37987: atrgrps.automatic_flag = 'Y'
37988: OR

Line 37989: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)*/

37985: atrgrps.list_line_type_code NOT IN (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
37986: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE) AND
37987: atrgrps.automatic_flag = 'Y'
37988: OR
37989: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)*/
37990:
37991: CURSOR l_line_cache_path2_cur(p_pricing_phase_id NUMBER) IS
37992: SELECT
37993: /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3)

Line 38036: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES))

38032: AND qprs.APPLICATION_SHORT_NAME = atrgrps.source_system_code
38033: AND qprs.pte_code = G_PTE_CODE
38034: AND(atrgrps.modifier_level_code = qplines.line_type_code
38035: OR (atrgrps.modifier_level_code = qp_preq_grp.g_line_group and
38036: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES))
38037: AND( qplines.unit_price IS NOT NULL
38038: OR qplines.usage_pricing_type = qp_preq_grp.g_authoring_type
38039: OR qplines.line_type_code = qp_preq_grp.g_order_level
38040: )

Line 38083: AND (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES AND

38079: AND list_header_id = atrgrps.list_header_id
38080: AND line_index = qplines.line_index)
38081: )
38082: OR atrgrps.ask_for_flag = qp_preq_grp.g_no)
38083: AND (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES AND
38084: atrgrps.list_line_type_code NOT IN (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
38085: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE) AND
38086: atrgrps.automatic_flag = 'Y'
38087: OR

Line 38088: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES);

38084: atrgrps.list_line_type_code NOT IN (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
38085: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE) AND
38086: atrgrps.automatic_flag = 'Y'
38087: OR
38088: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES);
38089:
38090: CURSOR l_hdr_cache_cur_path2(p_pricing_phase_id NUMBER) IS
38091: SELECT
38092:

Line 39774: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN

39770:
39771: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), G_NO);
39772:
39773: --[julin/pricebook] -- pat impact
39774: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
39775: l_satis_quals_opt := G_NO;
39776: END IF;
39777:
39778: IF qp_preq_grp.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 41611: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;

41607: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
41608: engine_debug('Calling application inserted into temp tables');
41609:
41610: END IF;
41611: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;

Line 41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;

41608: engine_debug('Calling application inserted into temp tables');
41609:
41610: END IF;
41611: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
41616: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;

Line 41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;

41609:
41610: END IF;
41611: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
41616: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
41617:

Line 41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;

41610: END IF;
41611: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
41616: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
41617:
41618: l_price_flag_yes_only := NULL; -- reset, default

Line 41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;

41611: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
41616: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
41617:
41618: l_price_flag_yes_only := NULL; -- reset, default
41619: -- Check if atleast there is one line with price_flag = 'Y'

Line 41616: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;

41612: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
41613: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
41614: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
41615: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
41616: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
41617:
41618: l_price_flag_yes_only := NULL; -- reset, default
41619: -- Check if atleast there is one line with price_flag = 'Y'
41620: -- shu, begin bug 2437534 fix

Line 42121: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) THEN

42117: OPEN l_check_no_list_passed;
42118: FETCH l_check_no_list_passed INTO l_dummy;
42119:
42120: IF (l_check_no_list_passed%FOUND and (I.SEARCH_FLAG = G_YES OR
42121: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) THEN
42122: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42123: engine_debug('Trying to Perform pattern BIG Search ');
42124: END IF;
42125:

Line 42170: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) -- price book

42166: -- Do further search only if asked for using I.SEARCH_FLAG on the price list phase
42167: -- Bug# 1367546
42168:
42169: IF (l_further_search = G_YES and (I.SEARCH_FLAG = G_YES or
42170: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) -- price book
42171: THEN
42172: qp_debug_util.tstart('SELECT_PRICE_LIST_LINES','Select Price List Lines(Search Flag on) - SELECT_PRICE_LIST_LINES API');
42173:
42174: SELECT_PRICE_LIST_LINES(p_pricing_phase_id => I.pricing_phase_id,

Line 42737: QP_PREQ_PUB.Determine_svc_item_quantity;

42733:
42734: END IF;
42735: --4900095
42736: IF QP_PREQ_GRP.G_Service_line_qty_tbl.COUNT = 0 THEN
42737: QP_PREQ_PUB.Determine_svc_item_quantity;
42738: END IF;
42739: -- Reset
42740: -- This global variable is used to not calculate the Recurring Qty routine and update the Operand
42741: -- if Limits Code is called to avoid second time calculation of the OPERAND value from the Calculation Engine

Line 42748: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book

42744:
42745: -- If advanced pricing and limits profile option = 'Y' call calc engine for limits
42746: IF (l_install_status = 'I' and l_limits_installed = G_YES and
42747: UPPER(p_control_rec.simulation_flag) = 'N' and
42748: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book
42749: THEN
42750: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42751: engine_debug('------Advanced Pricing and Limits Profile is Set-----------');
42752: END IF;

Line 42776: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book

42772:
42773:
42774: IF (l_install_status = 'I' and l_limits_installed = G_YES and
42775: UPPER(p_control_rec.simulation_flag) = 'N' and
42776: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book
42777: THEN
42778: qp_debug_util.tstart('LIMITS_CALCULATION','Inside LIMITS_CALCULATION');
42779: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42780: engine_debug('------Advanced Pricing and Limits Profile is Set 2 -----------');