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_PUB dependencies on DUAL

Line 10: G_ROUND_INDIVIDUAL_ADJ VARCHAR2(30);

6: G_ATTR_MGR_INSTALLED CONSTANT VARCHAR2(1) := QP_UTIL.Attrmgr_Installed;
7:
8: G_ROUNDING_OPTIONS VARCHAR2(30);
9: G_USE_MULTI_CURRENCY_PUB VARCHAR2(1); -- bug 2943033
10: G_ROUND_INDIVIDUAL_ADJ VARCHAR2(30);
11: G_CALCULATE_FLAG VARCHAR2(30); --3401941
12:
13: G_NO_ROUND CONSTANT VARCHAR2(30) := 'NO_ROUND';
14: G_ROUND_ADJ CONSTANT VARCHAR2(30) := 'ROUND_ADJ';

Line 3767: IF G_ROUND_INDIVIDUAL_ADJ not in (G_NO_ROUND, G_POST_ROUND)

3763: QP_PREQ_GRP.engine_debug('back calculation for line '
3764: || l_line_index_tbl(i));
3765: END IF; --l_debug
3766:
3767: IF G_ROUND_INDIVIDUAL_ADJ not in (G_NO_ROUND, G_POST_ROUND)
3768: --[prarasto:Post Round] added check to skip rounding for Post Rounding
3769: AND l_rounding_factor_tbl(i) IS NOT NULL THEN
3770: l_upd_adj_unit_price_tbl(i) :=
3771: round(l_upd_adj_unit_price_tbl(i), - 1 * l_rounding_factor_tbl(i));

Line 3772: END IF; --G_ROUND_INDIVIDUAL_ADJ

3768: --[prarasto:Post Round] added check to skip rounding for Post Rounding
3769: AND l_rounding_factor_tbl(i) IS NOT NULL THEN
3770: l_upd_adj_unit_price_tbl(i) :=
3771: round(l_upd_adj_unit_price_tbl(i), - 1 * l_rounding_factor_tbl(i));
3772: END IF; --G_ROUND_INDIVIDUAL_ADJ
3773:
3774:
3775: IF ((l_upd_adj_unit_price_tbl(i) -
3776: l_adj_unit_price_tbl(i)) <> 0) THEN

Line 3843: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ

3839:
3840: -- End Ravi
3841:
3842: --fix for bug 2146050 to round adjustment amt
3843: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ
3844: AND l_rounding_factor_tbl(i) IS NOT NULL THEN
3845: l_back_calc_ret_rec.adjustment_amount :=
3846: round(l_back_calc_ret_rec.adjustment_amount,
3847: - 1 * l_rounding_factor_tbl(i));

Line 3850: END IF; --G_ROUND_INDIVIDUAL_ADJ

3846: round(l_back_calc_ret_rec.adjustment_amount,
3847: - 1 * l_rounding_factor_tbl(i));
3848: l_ord_qty_adj_amt := round(l_ord_qty_adj_amt,
3849: - 1 * l_rounding_factor_tbl(i));
3850: END IF; --G_ROUND_INDIVIDUAL_ADJ
3851:
3852: --load the l_back_calc_ret_rec to plsqltbl to do bulk update
3853: l_ldet_dtl_index(l_ldet_dtl_index.COUNT + 1) :=
3854: l_back_calc_ret_rec.line_detail_index;

Line 3930: --round the selling price if ROUND_INDIVIDUAL_ADJ

3926: l_line_unit_price_tbl(i) := 0;
3927: l_ord_uom_selling_price_tbl(i) := 0;
3928: END IF; --ordered_qty
3929:
3930: --round the selling price if ROUND_INDIVIDUAL_ADJ
3931: --profile is N in this case the adjustment_amt will not be rounded
3932:
3933: --===[prarasto:Post Round] Start : Calculate rounded values ==--
3934: l_adjusted_unit_price_ur(i) := l_adj_unit_price_tbl(i);

Line 3937: IF (G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND , G_POST_ROUND )) AND (l_rounding_factor_tbl(i) is not null)

3933: --===[prarasto:Post Round] Start : Calculate rounded values ==--
3934: l_adjusted_unit_price_ur(i) := l_adj_unit_price_tbl(i);
3935: l_unit_selling_price_ur(i) := l_ord_uom_selling_price_tbl(i);
3936:
3937: IF (G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND , G_POST_ROUND )) AND (l_rounding_factor_tbl(i) is not null)
3938: THEN
3939: IF (l_catchwt_qty_tbl(i) is null) and (l_actual_order_qty_tbl(i) is not null) THEN
3940: l_extended_selling_price_ur(i) := round(l_unit_selling_price_ur(i), - 1 * l_rounding_factor_tbl(i))
3941: * l_actual_order_qty_tbl(i);

Line 3960: IF (G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND) or (l_rounding_factor_tbl(i) is null) THEN

3956: QP_PREQ_GRP.engine_debug('roundingfac to round sellingprice: '
3957: || l_rounding_factor_tbl(i));
3958: END IF; --l_debug
3959:
3960: IF (G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND) or (l_rounding_factor_tbl(i) is null) THEN
3961: -- l_adj_unit_price_tbl(i) := l_adjusted_unit_price_ur(i);
3962: l_unit_selling_price(i) := l_unit_selling_price_ur(i);
3963: l_extended_selling_price(i) := l_extended_selling_price_ur(i);
3964: ELSE

Line 3993: IF l_rounding_factor_tbl(i) IS NOT NULL and G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND THEN

3989: l_ord_uom_selling_price_tbl(i) := (nvl(l_adj_unit_price_tbl(i),l_unit_price_tbl(i)) *
3990: (l_priced_qty_tbl(i)/ l_line_qty_tbl(i)));
3991: END IF;
3992:
3993: IF l_rounding_factor_tbl(i) IS NOT NULL and G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND THEN
3994: l_ord_uom_selling_price_tbl(i) := round(l_ord_uom_selling_price_tbl(i), (-1 * l_rounding_factor_tbl(i)));
3995: END IF;--l_rounding_factor_tbl
3996: */
3997:

Line 5711: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ

5707:
5708: --round the adjustment_amount with factor on the line
5709: --engine updates the factor on the line
5710: --w/nvl(user_passed,price_list rounding_factor)
5711: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ
5712: AND l_adj_tbl(j).rounding_factor IS NOT NULL
5713: THEN
5714: l_ldet_adj_amt_tbl(i) :=
5715: round(l_ldet_adj_amt_tbl(i),

Line 6191: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ

6187: THEN
6188: --Update the adjustment amount for each adjustment
6189: -- 2892848_latest
6190: -- so we have correct current USP, considered each adj shall be rounded
6191: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ
6192: AND l_adj_tbl(j).rounding_factor IS NOT NULL
6193: THEN
6194: l_return_adjustment := round (l_return_adjustment, - 1 * l_adj_tbl(j).rounding_factor);
6195: END IF; -- end rounding

Line 6317: --round the selling price if ROUND_INDIVIDUAL_ADJ profile is N

6313: END IF;
6314: l_pricing_sts_txt_tbl(x) := l_adj_tbl(j).pricing_status_text;
6315: l_rounding_factor_tbl(x) := l_adj_tbl(j).rounding_factor;
6316:
6317: --round the selling price if ROUND_INDIVIDUAL_ADJ profile is N
6318: --in this case the adjustment_amt will not be rounded
6319: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
6320:
6321: /* 2892848_latest

Line 6319: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ

6315: l_rounding_factor_tbl(x) := l_adj_tbl(j).rounding_factor;
6316:
6317: --round the selling price if ROUND_INDIVIDUAL_ADJ profile is N
6318: --in this case the adjustment_amt will not be rounded
6319: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
6320:
6321: /* 2892848_latest
6322: -- we should round adjs, move rounding ahead
6323: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix bug 2239061

Line 6323: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix bug 2239061

6319: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
6320:
6321: /* 2892848_latest
6322: -- we should round adjs, move rounding ahead
6323: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix bug 2239061
6324: -- this is not the final USP since now we order by bucket
6325:
6326: and l_rounding_factor_tbl(x) IS NOT NULL
6327: THEN

Line 6518: IF G_ROUND_INDIVIDUAL_ADJ not in (G_NO_ROUND, G_POST_ROUND)

6514: || l_line_index_tbl(i));
6515:
6516: END IF;
6517: --fix for bug 2146050
6518: IF G_ROUND_INDIVIDUAL_ADJ not in (G_NO_ROUND, G_POST_ROUND)
6519: --[prarasto:Post Round] added check to skip rounding for Post Rounding
6520: AND l_rounding_factor_tbl(i) IS NOT NULL
6521: THEN
6522: l_upd_adj_unit_price_tbl(i) :=

Line 6720: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ

6716:
6717: -- End Ravi
6718:
6719: --fix for bug 2146050 to round adjustment amt
6720: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ
6721: AND l_rounding_factor_tbl(i) IS NOT NULL
6722: THEN
6723: l_ldet_adj_amt_tbl(l_tbl_index) :=
6724: round(l_ldet_adj_amt_tbl(l_tbl_index),

Line 6731: --round the selling price if ROUND_INDIVIDUAL_ADJ

6727: round(l_ldet_ordqty_adjamt_tbl(l_tbl_index),
6728: - 1 * l_rounding_factor_tbl(i));
6729: END IF;
6730:
6731: --round the selling price if ROUND_INDIVIDUAL_ADJ
6732: --profile is N in this case the adjustment_amt
6733: --will not be rounded
6734: IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ -- 2892848_latest, not to round current USP for G_ROUND_ADJ case since it is not final USP yet
6735: --IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061

Line 6734: IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ -- 2892848_latest, not to round current USP for G_ROUND_ADJ case since it is not final USP yet

6730:
6731: --round the selling price if ROUND_INDIVIDUAL_ADJ
6732: --profile is N in this case the adjustment_amt
6733: --will not be rounded
6734: IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ -- 2892848_latest, not to round current USP for G_ROUND_ADJ case since it is not final USP yet
6735: --IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061
6736: AND l_rounding_factor_tbl(i) IS NOT NULL
6737: THEN
6738: IF l_debug = FND_API.G_TRUE THEN

Line 6735: --IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061

6731: --round the selling price if ROUND_INDIVIDUAL_ADJ
6732: --profile is N in this case the adjustment_amt
6733: --will not be rounded
6734: IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ -- 2892848_latest, not to round current USP for G_ROUND_ADJ case since it is not final USP yet
6735: --IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061
6736: AND l_rounding_factor_tbl(i) IS NOT NULL
6737: THEN
6738: IF l_debug = FND_API.G_TRUE THEN
6739: QP_PREQ_GRP.engine_debug('need to round selling price, rounding factor: '

Line 6782: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- 2892848_latest, round finalUSP

6778: WHILE j IS NOT NULL
6779: LOOP
6780: -- begin 2892848_latest
6781: /* commented out for bug 3663518
6782: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- 2892848_latest, round finalUSP
6783: AND l_rounding_factor_tbl(j) IS NOT NULL THEN
6784:
6785: l_adj_unit_price_tbl(j) := round(l_adj_unit_price_tbl(j)
6786: ,-1*l_rounding_factor_tbl(j));

Line 6966: FROM dual

6962: , l_ldet_pricing_phase_id_tbl(i)
6963: , l_ldet_calc_code_tbl(i)
6964: , l_ldet_ordqty_operand_tbl(i)
6965: , nvl(l_ldet_ordqty_adjamt_tbl(i), l_ldet_adj_amt_tbl(i))
6966: FROM dual
6967: WHERE l_ldet_process_code_tbl(i) = G_STATUS_UPDATED;
6968: END IF;
6969:
6970: ---------------------------------------------------------------------

Line 6996: IF (G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND , G_POST_ROUND )) AND (l_rounding_factor_tbl(i) is not null)

6992: --===[prarasto:Post Round] Start : Calculate rounded values ==--
6993: l_adjusted_unit_price_ur(i) := l_adj_unit_price_tbl(i);
6994: l_unit_selling_price_ur(i) := l_ordqty_selling_price_tbl(i);
6995:
6996: IF (G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND , G_POST_ROUND )) AND (l_rounding_factor_tbl(i) is not null)
6997: THEN
6998: IF (l_catchweight_qty_tbl(i) is null) and (l_actual_order_qty_tbl(i) is not null) THEN
6999: l_extended_selling_price_ur(i) := round(l_unit_selling_price_ur(i), - 1 * l_rounding_factor_tbl(i))
7000: * l_actual_order_qty_tbl(i);

Line 7013: IF (G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND) or (l_rounding_factor_tbl(i) is null) THEN

7009: l_extended_selling_price_ur(i) := l_unit_selling_price_ur(i) * l_ordered_qty_tbl(i);
7010: END IF;
7011: END IF;
7012:
7013: IF (G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND) or (l_rounding_factor_tbl(i) is null) THEN
7014: -- l_adj_unit_price_tbl(i) := l_adjusted_unit_price_ur(i);
7015: l_unit_selling_price(i) := l_unit_selling_price_ur(i);
7016: l_extended_selling_price(i) := l_extended_selling_price_ur(i);
7017: ELSE

Line 7040: /* decode(G_ROUND_INDIVIDUAL_ADJ,

7036: UPDATE qp_npreq_lines_tmp
7037: SET unit_price = l_unit_price_tbl(i),
7038: adjusted_unit_price = l_adj_unit_price_tbl(i), --[prarasto:Post Round]
7039: --adjusted_unit_price_ur = l_adjusted_unit_price_ur(i), --[prarasto:Post Round], [julin/postround] redesign
7040: /* decode(G_ROUND_INDIVIDUAL_ADJ,
7041: G_NO_ROUND, l_adj_unit_price_tbl(i),
7042: decode(l_rounding_factor_tbl(i),
7043: NULL, l_adj_unit_price_tbl(i),
7044: round(l_adj_unit_price_tbl(i), - 1 * l_rounding_factor_tbl(i)))),

Line 7051: /* decode(G_ROUND_INDIVIDUAL_ADJ,

7047: pricing_status_code = l_pricing_sts_code_tbl(i),
7048: pricing_status_text = l_pricing_sts_txt_tbl(i),
7049: processed_flag = G_PROCESSED,
7050: line_unit_price = l_ordqty_unit_price_tbl(i), --[prarasto:Post Round]
7051: /* decode(G_ROUND_INDIVIDUAL_ADJ,
7052: G_NO_ROUND, l_ordqty_unit_price_tbl(i),
7053: decode(l_rounding_factor_tbl(i),
7054: NULL, l_ordqty_unit_price_tbl(i),
7055: round(l_ordqty_unit_price_tbl(i), - 1 * l_rounding_factor_tbl(i)))),

Line 7058: /* decode(G_ROUND_INDIVIDUAL_ADJ,

7054: NULL, l_ordqty_unit_price_tbl(i),
7055: round(l_ordqty_unit_price_tbl(i), - 1 * l_rounding_factor_tbl(i)))),
7056: */
7057: order_uom_selling_price = l_unit_selling_price(i), --[prarasto:Post Round]
7058: /* decode(G_ROUND_INDIVIDUAL_ADJ,
7059: G_NO_ROUND, l_ordqty_selling_price_tbl(i),
7060: decode(l_rounding_factor_tbl(i),
7061: NULL, l_ordqty_selling_price_tbl(i),
7062: round(l_ordqty_selling_price_tbl(i), - 1 * l_rounding_factor_tbl(i)))),

Line 8263: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ -- 2892848_latest

8259: */
8260: --round the adjustment_amount with factor on the line
8261: --engine updates the factor on the line
8262: --w/nvl(user_passed,price_list rounding_factor)
8263: IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ -- 2892848_latest
8264: AND l_bucket_price_rec.rounding_factor IS NOT NULL
8265: THEN
8266: l_return_adjustment :=
8267: round(l_return_adjustment,

Line 8427: --round the selling price if G_ROUND_INDIVIDUAL_ADJ=Y

8423: l_lines_tbl(j).line_index := l_bucket_price_rec.line_ind;
8424: l_lines_tbl(j).adjusted_unit_price := l_adjusted_price;
8425:
8426: -- 2892848_latest, do not round here since it is not final USP
8427: --round the selling price if G_ROUND_INDIVIDUAL_ADJ=Y
8428: -- need to re-evaluate how this should work now
8429: /*
8430: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu, fix bug 2239061
8431: and l_lines_tbl(j).rounding_factor IS NOT NULL

Line 8430: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu, fix bug 2239061

8426: -- 2892848_latest, do not round here since it is not final USP
8427: --round the selling price if G_ROUND_INDIVIDUAL_ADJ=Y
8428: -- need to re-evaluate how this should work now
8429: /*
8430: IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu, fix bug 2239061
8431: and l_lines_tbl(j).rounding_factor IS NOT NULL
8432: THEN
8433: IF l_debug = FND_API.G_TRUE THEN
8434: QP_PREQ_GRP.engine_debug('round current USP, rounding_factor: '

Line 8440: END IF; -- END IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ

8436: END IF;
8437: l_lines_tbl(j).adjusted_unit_price :=
8438: round(l_lines_tbl(j).adjusted_unit_price,
8439: -1*l_lines_tbl(j).rounding_factor);
8440: END IF; -- END IF G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ
8441: */
8442:
8443: IF l_debug = FND_API.G_TRUE THEN
8444: QP_PREQ_GRP.ENGINE_DEBUG('adjusted_price'

Line 8767: AND G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to

8763: l_adjusted_unit_price_ur(j) := l_lines_tbl(j).adjusted_unit_price; --[prarasto:Post Round]
8764: l_updated_adj_unit_price_ur(j) := l_lines_tbl(j).updated_adjusted_unit_price; --[prarasto:Post Round]
8765:
8766: IF l_lines_tbl(j).rounding_factor IS NOT NULL
8767: AND G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to
8768: --skip rounding for Post Round option
8769: THEN
8770: --first round the overridden selling price--2146050
8771: l_lines_tbl(j).updated_adjusted_unit_price :=

Line 8874: AND G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ

8870:
8871: END IF;
8872:
8873: IF l_lines_tbl(j).rounding_factor IS NOT NULL
8874: AND G_ROUND_INDIVIDUAL_ADJ = G_ROUND_ADJ
8875: THEN
8876: --round the adjustment amount --2146050
8877: --it must have been rounded already
8878: l_back_calc_ret_rec.adjustment_amount :=

Line 8987: --round the SP if G_ROUND_INDIVIDUAL_ADJ=G_NO_ROUND_ADJ

8983: --[prarasto:Post Round] added to calculate unrounded adjusted unit price after calculating adjustment amount
8984: l_adjusted_unit_price_ur(j) := l_adjusted_unit_price_ur(j) +
8985: nvl(l_back_calc_ret_rec.adjustment_amount, 0);
8986:
8987: --round the SP if G_ROUND_INDIVIDUAL_ADJ=G_NO_ROUND_ADJ
8988: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
8989:
8990: -- IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061,
8991: IF G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to

Line 8988: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ

8984: l_adjusted_unit_price_ur(j) := l_adjusted_unit_price_ur(j) +
8985: nvl(l_back_calc_ret_rec.adjustment_amount, 0);
8986:
8987: --round the SP if G_ROUND_INDIVIDUAL_ADJ=G_NO_ROUND_ADJ
8988: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
8989:
8990: -- IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061,
8991: IF G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to
8992: --skip rounding for Post Round option

Line 8990: -- IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061,

8986:
8987: --round the SP if G_ROUND_INDIVIDUAL_ADJ=G_NO_ROUND_ADJ
8988: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
8989:
8990: -- IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061,
8991: IF G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to
8992: --skip rounding for Post Round option
8993: AND l_lines_tbl(j).rounding_factor IS NOT NULL
8994: THEN

Line 8991: IF G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to

8987: --round the SP if G_ROUND_INDIVIDUAL_ADJ=G_NO_ROUND_ADJ
8988: --IF G_ROUND_INDIVIDUAL_ADJ = G_NO_ROUND_ADJ
8989:
8990: -- IF G_ROUND_INDIVIDUAL_ADJ <> G_NO_ROUND -- shu fix 2239061,
8991: IF G_ROUND_INDIVIDUAL_ADJ not in ( G_NO_ROUND, G_POST_ROUND ) --[prarasto:Post Round] added check to
8992: --skip rounding for Post Round option
8993: AND l_lines_tbl(j).rounding_factor IS NOT NULL
8994: THEN
8995: IF l_debug = FND_API.G_TRUE THEN

Line 13279: G_ROUND_INDIVIDUAL_ADJ := nvl(G_ROUNDING_OPTIONS, G_NO_ROUND);

13275: END IF;
13276:
13277: IF nvl(p_control_rec.rounding_flag, G_YES) = G_ROUNDING_PROFILE
13278: THEN
13279: G_ROUND_INDIVIDUAL_ADJ := nvl(G_ROUNDING_OPTIONS, G_NO_ROUND);
13280: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = G_YES
13281: THEN
13282: --this is done for bug 2635440 for OC to default the rounding_flag to 'Q'
13283: --to look at the profile for rounding if the rounding_flag is null

Line 13288: G_ROUND_INDIVIDUAL_ADJ := nvl(G_ROUNDING_OPTIONS, G_NO_ROUND);

13284: --in the pl/sql code path. OC will pass Q for direct insert path
13285: IF G_REQUEST_TYPE_CODE = 'ASO'
13286: AND nvl(p_control_rec.temp_table_insert_flag, G_YES) = G_YES
13287: AND p_control_rec.rounding_flag IS NULL THEN
13288: G_ROUND_INDIVIDUAL_ADJ := nvl(G_ROUNDING_OPTIONS, G_NO_ROUND);
13289: ELSE
13290: G_ROUND_INDIVIDUAL_ADJ := G_ROUND_ADJ;
13291: END IF; --l_control_rec.request_type_code
13292: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = G_NO

Line 13290: G_ROUND_INDIVIDUAL_ADJ := G_ROUND_ADJ;

13286: AND nvl(p_control_rec.temp_table_insert_flag, G_YES) = G_YES
13287: AND p_control_rec.rounding_flag IS NULL THEN
13288: G_ROUND_INDIVIDUAL_ADJ := nvl(G_ROUNDING_OPTIONS, G_NO_ROUND);
13289: ELSE
13290: G_ROUND_INDIVIDUAL_ADJ := G_ROUND_ADJ;
13291: END IF; --l_control_rec.request_type_code
13292: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = G_NO
13293: THEN
13294: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND;

Line 13294: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND;

13290: G_ROUND_INDIVIDUAL_ADJ := G_ROUND_ADJ;
13291: END IF; --l_control_rec.request_type_code
13292: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = G_NO
13293: THEN
13294: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND;
13295: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'U'
13296: THEN
13297: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND_ADJ;
13298: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'P' --[prarasto:Post Round] added condition to update

Line 13297: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND_ADJ;

13293: THEN
13294: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND;
13295: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'U'
13296: THEN
13297: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND_ADJ;
13298: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'P' --[prarasto:Post Round] added condition to update
13299: --G_ROUND_INDIVIDUAL_ADJ for post rounding
13300: THEN
13301: G_ROUND_INDIVIDUAL_ADJ := G_POST_ROUND;

Line 13299: --G_ROUND_INDIVIDUAL_ADJ for post rounding

13295: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'U'
13296: THEN
13297: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND_ADJ;
13298: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'P' --[prarasto:Post Round] added condition to update
13299: --G_ROUND_INDIVIDUAL_ADJ for post rounding
13300: THEN
13301: G_ROUND_INDIVIDUAL_ADJ := G_POST_ROUND;
13302: END IF;
13303:

Line 13301: G_ROUND_INDIVIDUAL_ADJ := G_POST_ROUND;

13297: G_ROUND_INDIVIDUAL_ADJ := G_NO_ROUND_ADJ;
13298: ELSIF nvl(p_control_rec.rounding_flag, G_YES) = 'P' --[prarasto:Post Round] added condition to update
13299: --G_ROUND_INDIVIDUAL_ADJ for post rounding
13300: THEN
13301: G_ROUND_INDIVIDUAL_ADJ := G_POST_ROUND;
13302: END IF;
13303:
13304: -- The below code is replaced with QP_PREQ_GRP.Set_QP_Debug
13305:

Line 13369: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: round_indv_adj '|| G_ROUND_INDIVIDUAL_ADJ);

13365:
13366: IF l_debug = FND_API.G_TRUE THEN
13367: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: request_type_code '|| G_REQUEST_TYPE_CODE);
13368: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: check_cust_view_flag '|| G_check_cust_view_flag);
13369: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: round_indv_adj '|| G_ROUND_INDIVIDUAL_ADJ);
13370:
13371: END IF;
13372: --===========END: Globals Initialization specific only to PL/SQL Engine=======
13373: END IF; --java engine is not installed

Line 13407: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: round_indv_adj '||G_ROUND_INDIVIDUAL_ADJ);

13403:
13404: IF l_debug = FND_API.G_TRUE THEN
13405: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: request_type_code '||G_REQUEST_TYPE_CODE);
13406: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: check_cust_view_flag '||G_check_cust_view_flag);
13407: QP_PREQ_GRP.ENGINE_DEBUG('BEGIN PRICE REQUEST PUB: round_indv_adj '||G_ROUND_INDIVIDUAL_ADJ);
13408:
13409: END IF;
13410: */ --moved up into PL/SQL Engine specific path
13411:

Line 14270: l_time_difference||' Total redo in QP_PREQ_PUB : '|| l_redo_difference||''''||' from dual ';

14266: --Changes for bug2961617
14267:
14268: /*
14269: execute immediate 'select '||''''|| ' Total Time in QP_PREQ_PUB(in sec) : ' ||
14270: l_time_difference||' Total redo in QP_PREQ_PUB : '|| l_redo_difference||''''||' from dual ';
14271: */
14272:
14273: IF G_QP_DEBUG = G_ENGINE_TIME_TRACE_ON THEN --3085171
14274: BEGIN

Line 14278: ' Total redo in QP_PREQ_PUB : '||l_redo_difference into l_time_stats from dual ;

14274: BEGIN
14275:
14276: /*
14277: select 'Total Time in QP_PREQ_PUB(in sec) : ' ||l_time_difference ||
14278: ' Total redo in QP_PREQ_PUB : '||l_redo_difference into l_time_stats from dual ;
14279: */
14280:
14281: EXECUTE IMMEDIATE 'select '|| '''' || ' Total Time in QP_PREQ_PUB(in sec) : ' ||
14282: l_time_difference ||' Total redo in QP_PREQ_PUB : '|| l_redo_difference || '''' ||' from dual ';

Line 14282: l_time_difference ||' Total redo in QP_PREQ_PUB : '|| l_redo_difference || '''' ||' from dual ';

14278: ' Total redo in QP_PREQ_PUB : '||l_redo_difference into l_time_stats from dual ;
14279: */
14280:
14281: EXECUTE IMMEDIATE 'select '|| '''' || ' Total Time in QP_PREQ_PUB(in sec) : ' ||
14282: l_time_difference ||' Total redo in QP_PREQ_PUB : '|| l_redo_difference || '''' ||' from dual ';
14283:
14284: EXCEPTION
14285:
14286: WHEN OTHERS THEN