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_RESOLVE_INCOMPATABILITY_PVT

Line 7931: -- [julin/4116856]: moved from QP_Resolve_Incompatability_PVT.Best_Price_-

7927: l_pricing_status_code varchar2(30);
7928: BEGIN
7929: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
7930:
7931: -- [julin/4116856]: moved from QP_Resolve_Incompatability_PVT.Best_Price_-
7932: -- For_Phase; required to delete un-asked-for promotions before they are
7933: -- processed.
7934: -- Delete lines which are actually ask_for in setup , but are not asked for in the Order
7935: -- Because Engine selects these lines irrespective of their ask_for_flag

Line 7938: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,LINE_INDEX,1

7934: -- Delete lines which are actually ask_for in setup , but are not asked for in the Order
7935: -- Because Engine selects these lines irrespective of their ask_for_flag
7936: -- Index Certificate
7937: /*
7938: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

Line 7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2

7935: -- Because Engine selects these lines irrespective of their ask_for_flag
7936: -- Index Certificate
7937: /*
7938: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

Line 7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3

7936: -- Index Certificate
7937: /*
7938: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4

Line 7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

7937: /*
7938: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5

Line 7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

7938: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,LINE_INDEX,1
7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7946: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6

Line 7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3

7939: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,PRICING_PHASE_ID,2
7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7946: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
7947: */

Line 7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4

7940: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_ldets_tmp_N3,ASK_FOR_FLAG,3
7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7946: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
7947: */
7948: IF (p_incompat_resolve_code = G_INCOMP_BEST_PRICE) THEN

Line 7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5

7941: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7946: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
7947: */
7948: IF (p_incompat_resolve_code = G_INCOMP_BEST_PRICE) THEN
7949: l_pricing_status_code := QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL;

Line 7946: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6

7942: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
7943: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
7944: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
7945: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
7946: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_for_phase.upd1,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
7947: */
7948: IF (p_incompat_resolve_code = G_INCOMP_BEST_PRICE) THEN
7949: l_pricing_status_code := QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL;
7950: ELSE

Line 16682: QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty

16678: engine_debug('Secondary Price List Grouping Return Status : ' || l_status_code);
16679:
16680:
16681: END IF;
16682: QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty
16683: (p_line_index => NULL,
16684: p_order_uom_code => NULL,
16685: p_order_qty => NULL,
16686: p_pricing_phase_id => G_PRICE_LIST_PHASE_ID, -- pricing_phase_id,

Line 16721: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty

16717: RAISE E_ROUTINE_ERRORS;
16718: END IF;
16719:
16720: --bug# 2091386 not reflecting the right price on change on UOM on the order line . Since
16721: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty
16722: --which is needed later in Get_Eligible_Price_Break we need to call Get_Eligible_Price_Break
16723: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.
16724: --By doing this we will get the right price in the PRICE event on change of UOM on the order line
16725: --for price based on price break

Line 16723: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.

16719:
16720: --bug# 2091386 not reflecting the right price on change on UOM on the order line . Since
16721: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty
16722: --which is needed later in Get_Eligible_Price_Break we need to call Get_Eligible_Price_Break
16723: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.
16724: --By doing this we will get the right price in the PRICE event on change of UOM on the order line
16725: --for price based on price break
16726: Get_Eligible_Price_Break(G_PRICE_LIST_PHASE_ID,NULL,l_status_code,l_status_text);
16727:

Line 16734: --QP_Resolve_Incompatability_PVT

16730: END IF;
16731:
16732:
16733: --delete children lines of PBH if the parent PBH line get eliminated in
16734: --QP_Resolve_Incompatability_PVT
16735:
16736: /* OPEN l_chk_deleted_pbh_cur(l_line_index,G_PRICE_LIST_PHASE_ID);
16737: FETCH l_chk_deleted_pbh_cur INTO l_dummy;
16738: IF l_chk_deleted_pbh_cur%FOUND THEN

Line 20562: QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty

20558:
20559: engine_debug('Calling Incomp Routine in Non Validated Price List');
20560:
20561: END IF;
20562: QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty
20563: (p_line_index => NULL,
20564: p_order_uom_code => NULL,
20565: p_order_qty => NULL,
20566: p_pricing_phase_id => G_PRICE_LIST_PHASE_ID,

Line 20606: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty

20602: RAISE E_ROUTINE_ERRORS;
20603: END IF;
20604:
20605: --bug# 2091386 not reflecting the right price on change on UOM on the order line . Since
20606: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty
20607: --which is needed later in Get_Eligible_Price_Break we need to call Get_Eligible_Price_Break
20608: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.
20609: --By doing this we will get the right price in the PRICE event on change of UOM on the order line
20610: --for price based on price break

Line 20608: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.

20604:
20605: --bug# 2091386 not reflecting the right price on change on UOM on the order line . Since
20606: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty
20607: --which is needed later in Get_Eligible_Price_Break we need to call Get_Eligible_Price_Break
20608: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.
20609: --By doing this we will get the right price in the PRICE event on change of UOM on the order line
20610: --for price based on price break
20611: Get_Eligible_Price_Break(p_pricing_phase_id,NULL,l_return_status,l_status_text);
20612: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 20628: --delete children lines of PBH if the parent PBH line get eliminated in QP_Resolve_Incompatability_PVT

20624: Perform_Secondary_Search(p_freeze_override_flag,p_control_rec,l_return_status,l_status_text);
20625: END IF;
20626: CLOSE l_check_secondary_search;
20627:
20628: --delete children lines of PBH if the parent PBH line get eliminated in QP_Resolve_Incompatability_PVT
20629:
20630: /*OPEN l_chk_deleted_pbh_cur(J.line_index,G_PRICE_LIST_PHASE_ID);
20631: FETCH l_chk_deleted_pbh_cur INTO l_dummy;
20632: IF l_chk_deleted_pbh_cur%FOUND THEN

Line 33276: QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty

33272: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
33273: RAISE E_ROUTINE_ERRORS;
33274: END IF;
33275:
33276: QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty
33277: (p_line_index => NULL,
33278: p_order_uom_code => NULL,
33279: p_order_qty => NULL,
33280: p_pricing_phase_id => I.pricing_phase_id,

Line 33315: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty

33311: END IF;
33312:
33313:
33314: --bug# 2091386 not reflecting the right price on change on UOM on the order line . Since
33315: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty
33316: --which is needed later in Get_Eligible_Price_Break we need to call Get_Eligible_Price_Break
33317: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.
33318: --By doing this we will get the right price in the PRICE event on change of UOM on the order line
33319: --for price based on price break

Line 33317: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.

33313:
33314: --bug# 2091386 not reflecting the right price on change on UOM on the order line . Since
33315: --QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty determines the pricing_qty
33316: --which is needed later in Get_Eligible_Price_Break we need to call Get_Eligible_Price_Break
33317: --after QP_Resolve_Incompatability_PVT.Determine_Pricing_UOM_And_Qty.
33318: --By doing this we will get the right price in the PRICE event on change of UOM on the order line
33319: --for price based on price break
33320: Get_Eligible_Price_Break(I.pricing_phase_id,NULL,l_return_status,l_status_text);
33321:

Line 33325: --QP_Resolve_Incompatability_PVT

33321:
33322: -- Update the request line status for lines which got valid price list
33323:
33324: --delete children lines of PBH if the parent PBH line get eliminated in
33325: --QP_Resolve_Incompatability_PVT
33326:
33327: /*OPEN l_chk_deleted_pbh_cur(J.line_index,G_PRICE_LIST_PHASE_ID);
33328: FETCH l_chk_deleted_pbh_cur INTO l_dummy;
33329: IF l_chk_deleted_pbh_cur%FOUND THEN

Line 33602: QP_Resolve_Incompatability_PVT.Resolve_Incompatability

33598: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
33599: engine_debug('Precedence evaluation');
33600: END IF;
33601: qp_debug_util.tstart('RESOLVE_INCOMPATABILITY','Resolving Modifiers Incompatability - Resolve_Incompatability API');
33602: QP_Resolve_Incompatability_PVT.Resolve_Incompatability
33603: (I.pricing_phase_id,
33604: G_DISCOUNT_PROCESSING,
33605: l_list_price,
33606: J.LINE_INDEX,

Line 33617: QP_Resolve_Incompatability_PVT.Best_Price_For_Phase

33613: ELSIF (I.INCOMPAT_RESOLVE_CODE = G_INCOMP_BEST_PRICE) THEN
33614: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
33615: engine_debug('Best price for phase');
33616: END IF;
33617: QP_Resolve_Incompatability_PVT.Best_Price_For_Phase
33618: (l_list_price,
33619: J.LINE_INDEX,
33620: I.pricing_phase_id,
33621: l_return_status,