DBA Data[Home] [Help]

APPS.QP_RESOLVE_INCOMPATABILITY_PVT dependencies on STANDARD

Line 519: --l_qp_time_uom_conversion := nvl(FND_PROFILE.Value('QP_TIME_UOM_CONVERSION'), 'STANDARD');

515: -- shulin bug 1781829 fix
516: l_max_decimal_digits PLS_INTEGER := nvl(FND_PROFILE.Value ('QP_INV_DECIMAL_PRECISION'),10);
517:
518: --begin shulin bug 1829731, add profile qp_time_uom_conversion
519: --l_qp_time_uom_conversion := nvl(FND_PROFILE.Value('QP_TIME_UOM_CONVERSION'), 'STANDARD');
520: l_qp_time_uom_conversion VARCHAR2(20) := 'STANDARD'; --jhkuo
521: l_oks_qty NUMBER := NULL;
522: l_uom_quantity NUMBER := NULL;
523: l_sql_stmt varchar2(240) := NULL;

Line 520: l_qp_time_uom_conversion VARCHAR2(20) := 'STANDARD'; --jhkuo

516: l_max_decimal_digits PLS_INTEGER := nvl(FND_PROFILE.Value ('QP_INV_DECIMAL_PRECISION'),10);
517:
518: --begin shulin bug 1829731, add profile qp_time_uom_conversion
519: --l_qp_time_uom_conversion := nvl(FND_PROFILE.Value('QP_TIME_UOM_CONVERSION'), 'STANDARD');
520: l_qp_time_uom_conversion VARCHAR2(20) := 'STANDARD'; --jhkuo
521: l_oks_qty NUMBER := NULL;
522: l_uom_quantity NUMBER := NULL;
523: l_sql_stmt varchar2(240) := NULL;
524: l_order_qty NUMBER := NULL; -- shu_latest

Line 619: l_qp_time_uom_conversion := 'STANDARD';

615: l_duration_passed := 'N';
616: END IF;
617: ELSE
618: l_date_passed := 'NOT ';
619: l_qp_time_uom_conversion := 'STANDARD';
620: --bug 4900095
621: l_duration_passed := 'N';
622: END IF;
623:

Line 624: IF (FND_PROFILE.Value('QP_TIME_UOM_CONVERSION') = 'STANDARD') THEN --13404970

620: --bug 4900095
621: l_duration_passed := 'N';
622: END IF;
623:
624: IF (FND_PROFILE.Value('QP_TIME_UOM_CONVERSION') = 'STANDARD') THEN --13404970
625: l_date_passed := 'NOT ';
626: l_qp_time_uom_conversion := 'STANDARD';
627: l_duration_passed := 'N';
628: END IF;

Line 626: l_qp_time_uom_conversion := 'STANDARD';

622: END IF;
623:
624: IF (FND_PROFILE.Value('QP_TIME_UOM_CONVERSION') = 'STANDARD') THEN --13404970
625: l_date_passed := 'NOT ';
626: l_qp_time_uom_conversion := 'STANDARD';
627: l_duration_passed := 'N';
628: END IF;
629:
630: IF l_debug = FND_API.G_TRUE THEN

Line 838: ELSE -- oks fail, make v_pricing_qty as line_quantity just like STANDARD conversion

834: IF l_debug = FND_API.G_TRUE THEN
835: QP_PREQ_GRP.engine_debug('Pric_Qty OKS_API Conv based on Order_UOM :' || v_pricing_qty);
836: END IF; --end debug
837:
838: ELSE -- oks fail, make v_pricing_qty as line_quantity just like STANDARD conversion
839: v_pricing_qty := i.line_quantity; -- STANDARD
840: --l_uom_quantity :=1;
841: l_uom_quantity := nvl(i.uom_quantity, 1); -- to back support OM, SL BUG FOUND
842: -- no need to update l_order_qty, since it has been initialized to i.line_quantity

Line 839: v_pricing_qty := i.line_quantity; -- STANDARD

835: QP_PREQ_GRP.engine_debug('Pric_Qty OKS_API Conv based on Order_UOM :' || v_pricing_qty);
836: END IF; --end debug
837:
838: ELSE -- oks fail, make v_pricing_qty as line_quantity just like STANDARD conversion
839: v_pricing_qty := i.line_quantity; -- STANDARD
840: --l_uom_quantity :=1;
841: l_uom_quantity := nvl(i.uom_quantity, 1); -- to back support OM, SL BUG FOUND
842: -- no need to update l_order_qty, since it has been initialized to i.line_quantity
843: IF l_debug = FND_API.G_TRUE THEN

Line 849: ELSE -- l_qp_time_uom_conversion = 'STANDARD' THEN

845: QP_PREQ_GRP.engine_debug('uom_qty passed :' || l_uom_quantity); --shu 12/26/2001
846: END IF; -- end debug
847:
848: END IF; -- END IF (l_oks_qty IS NOT NULL AND l_oks_qty <> 0)
849: ELSE -- l_qp_time_uom_conversion = 'STANDARD' THEN
850: --commeneted for 9977712 smbalara
851: --v_pricing_qty := i.line_quantity; -- STANDARD
852: v_pricing_qty := ROUND(i.line_quantity,l_max_decimal_digits); --added ROUND for 9977712 smbalara
853: -- no need to update l_order_qty, since it has been initialized to i.line_quantity

Line 851: --v_pricing_qty := i.line_quantity; -- STANDARD

847:
848: END IF; -- END IF (l_oks_qty IS NOT NULL AND l_oks_qty <> 0)
849: ELSE -- l_qp_time_uom_conversion = 'STANDARD' THEN
850: --commeneted for 9977712 smbalara
851: --v_pricing_qty := i.line_quantity; -- STANDARD
852: v_pricing_qty := ROUND(i.line_quantity,l_max_decimal_digits); --added ROUND for 9977712 smbalara
853: -- no need to update l_order_qty, since it has been initialized to i.line_quantity
854: l_uom_quantity := nvl(i.uom_quantity, 1); -- to back support OM, for case user order 2 of 6 MTH service
855: IF l_debug = FND_API.G_TRUE THEN

Line 1132: -- not 'ORACLE_CONTACTS' or OKS conversion failed, use standard inventory uom conversion

1128: END IF;
1129: END IF; --oks succeed
1130: END IF; -- end profile is ORACLE_CONTRACTS
1131:
1132: -- not 'ORACLE_CONTACTS' or OKS conversion failed, use standard inventory uom conversion
1133: IF (l_qp_time_uom_conversion = 'STANDARD') OR (l_oks_qty = -999999 OR l_oks_qty = 0) THEN
1134:
1135: IF (l_qp_time_uom_conversion = 'ORACLE_CONTRACTS') then
1136: IF l_debug = FND_API.G_TRUE THEN

Line 1133: IF (l_qp_time_uom_conversion = 'STANDARD') OR (l_oks_qty = -999999 OR l_oks_qty = 0) THEN

1129: END IF; --oks succeed
1130: END IF; -- end profile is ORACLE_CONTRACTS
1131:
1132: -- not 'ORACLE_CONTACTS' or OKS conversion failed, use standard inventory uom conversion
1133: IF (l_qp_time_uom_conversion = 'STANDARD') OR (l_oks_qty = -999999 OR l_oks_qty = 0) THEN
1134:
1135: IF (l_qp_time_uom_conversion = 'ORACLE_CONTRACTS') then
1136: IF l_debug = FND_API.G_TRUE THEN
1137: QP_PREQ_GRP.engine_debug('oks conversion had failed...');

Line 1139: END IF; -- for debug, to distinglish if it is oks failed case or if profile set to standard case

1135: IF (l_qp_time_uom_conversion = 'ORACLE_CONTRACTS') then
1136: IF l_debug = FND_API.G_TRUE THEN
1137: QP_PREQ_GRP.engine_debug('oks conversion had failed...');
1138: END IF;
1139: END IF; -- for debug, to distinglish if it is oks failed case or if profile set to standard case
1140:
1141: -- Get the conversion rate based on prclist's primary_uom
1142: Inv_convert.inv_um_conversion(i.line_uom_code,
1143: v_primary_uom_code,

Line 1161: QP_PREQ_GRP.engine_debug('Standard uom conversion, non-service line...');

1157: v_pricing_qty := ROUND( i.line_quantity * v_uom_rate, l_max_decimal_digits);
1158: l_uom_quantity := 1; --shu_latest
1159: l_order_qty := i.line_quantity;
1160: IF l_debug = FND_API.G_TRUE THEN
1161: QP_PREQ_GRP.engine_debug('Standard uom conversion, non-service line...');
1162: QP_PREQ_GRP.engine_debug('pricing_qty:' || v_pricing_qty);
1163: QP_PREQ_GRP.engine_debug('pricing_uom:' || v_primary_uom_code);
1164: QP_PREQ_GRP.engine_debug('order_qty:' || l_order_qty);
1165: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);

Line 1176: QP_PREQ_GRP.engine_debug('Standard uom conversion (oks failed), service line...');

1172: v_pricing_qty := ROUND( i.line_quantity * v_uom_rate, l_max_decimal_digits);
1173: l_uom_quantity := 1;
1174: l_order_qty := i.line_quantity;
1175: IF l_debug = FND_API.G_TRUE THEN
1176: QP_PREQ_GRP.engine_debug('Standard uom conversion (oks failed), service line...');
1177: QP_PREQ_GRP.engine_debug('pricing_qty:' || v_pricing_qty);
1178: QP_PREQ_GRP.engine_debug('pricing_uom:' || v_primary_uom_code);
1179: QP_PREQ_GRP.engine_debug('order_qty:' || l_order_qty);
1180: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);

Line 1184: ELSE -- from profile being standard case, l_uom_quantity matters for OM

1180: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);
1181: QP_PREQ_GRP.engine_debug('uom_quantity:' || l_uom_quantity);
1182: END IF;
1183:
1184: ELSE -- from profile being standard case, l_uom_quantity matters for OM
1185: -- assuming OM pass l_uom_quantity is converted to order uom like the following
1186: -- 1 of 2 YR services, order_uom=YR, l_uom_quantity = 2 (YR)
1187: IF l_debug = FND_API.G_TRUE THEN
1188: QP_PREQ_GRP.engine_debug('uom_quantity from calling application:' || i.uom_quantity);

Line 1196: QP_PREQ_GRP.engine_debug('Standard uom conversion, service line...');

1192: l_uom_quantity :=1; -- reset to 1, so the unit price by pricing uom does not change
1193: l_order_qty := i.line_quantity;
1194:
1195: IF l_debug = FND_API.G_TRUE THEN
1196: QP_PREQ_GRP.engine_debug('Standard uom conversion, service line...');
1197: QP_PREQ_GRP.engine_debug('pricing_qty:' || v_pricing_qty);
1198: QP_PREQ_GRP.engine_debug('pricing_uom:' || v_primary_uom_code);
1199: QP_PREQ_GRP.engine_debug('order_qty:' || l_order_qty);
1200: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);

Line 1209: END IF; -- end profile is 'STANDARD'

1205: END IF; -- end if service or non-service line
1206:
1207: END IF; -- end if v_uom_rate
1208:
1209: END IF; -- end profile is 'STANDARD'
1210:
1211:
1212: /*
1213: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1