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: IF l_debug = FND_API.G_TRUE THEN

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

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

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

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

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

838: QP_PREQ_GRP.engine_debug('uom_qty passed :' || l_uom_quantity); --shu 12/26/2001
839: END IF; -- end debug
840:
841: END IF; -- END IF (l_oks_qty IS NOT NULL AND l_oks_qty <> 0)
842: ELSE -- l_qp_time_uom_conversion = 'STANDARD' THEN
843: v_pricing_qty := i.line_quantity; -- STANDARD
844: -- no need to update l_order_qty, since it has been initialized to i.line_quantity
845: l_uom_quantity := nvl(i.uom_quantity, 1); -- to back support OM, for case user order 2 of 6 MTH service
846: IF l_debug = FND_API.G_TRUE THEN

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

839: END IF; -- end debug
840:
841: END IF; -- END IF (l_oks_qty IS NOT NULL AND l_oks_qty <> 0)
842: ELSE -- l_qp_time_uom_conversion = 'STANDARD' THEN
843: v_pricing_qty := i.line_quantity; -- STANDARD
844: -- no need to update l_order_qty, since it has been initialized to i.line_quantity
845: l_uom_quantity := nvl(i.uom_quantity, 1); -- to back support OM, for case user order 2 of 6 MTH service
846: IF l_debug = FND_API.G_TRUE THEN
847: QP_PREQ_GRP.engine_debug('pric_qty same as order_qty :' || v_pricing_qty);

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

1119: END IF;
1120: END IF; --oks succeed
1121: END IF; -- end profile is ORACLE_CONTRACTS
1122:
1123: -- not 'ORACLE_CONTACTS' or OKS conversion failed, use standard inventory uom conversion
1124: IF (l_qp_time_uom_conversion = 'STANDARD') OR (l_oks_qty = -999999 OR l_oks_qty = 0) THEN
1125:
1126: IF (l_qp_time_uom_conversion = 'ORACLE_CONTRACTS') then
1127: IF l_debug = FND_API.G_TRUE THEN

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

1120: END IF; --oks succeed
1121: END IF; -- end profile is ORACLE_CONTRACTS
1122:
1123: -- not 'ORACLE_CONTACTS' or OKS conversion failed, use standard inventory uom conversion
1124: IF (l_qp_time_uom_conversion = 'STANDARD') OR (l_oks_qty = -999999 OR l_oks_qty = 0) THEN
1125:
1126: IF (l_qp_time_uom_conversion = 'ORACLE_CONTRACTS') then
1127: IF l_debug = FND_API.G_TRUE THEN
1128: QP_PREQ_GRP.engine_debug('oks conversion had failed...');

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

1126: IF (l_qp_time_uom_conversion = 'ORACLE_CONTRACTS') then
1127: IF l_debug = FND_API.G_TRUE THEN
1128: QP_PREQ_GRP.engine_debug('oks conversion had failed...');
1129: END IF;
1130: END IF; -- for debug, to distinglish if it is oks failed case or if profile set to standard case
1131:
1132: -- Get the conversion rate based on prclist's primary_uom
1133: Inv_convert.inv_um_conversion(i.line_uom_code,
1134: v_primary_uom_code,

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

1148: v_pricing_qty := ROUND( i.line_quantity * v_uom_rate, l_max_decimal_digits);
1149: l_uom_quantity := 1; --shu_latest
1150: l_order_qty := i.line_quantity;
1151: IF l_debug = FND_API.G_TRUE THEN
1152: QP_PREQ_GRP.engine_debug('Standard uom conversion, non-service line...');
1153: QP_PREQ_GRP.engine_debug('pricing_qty:' || v_pricing_qty);
1154: QP_PREQ_GRP.engine_debug('pricing_uom:' || v_primary_uom_code);
1155: QP_PREQ_GRP.engine_debug('order_qty:' || l_order_qty);
1156: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);

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

1163: v_pricing_qty := ROUND( i.line_quantity * v_uom_rate, l_max_decimal_digits);
1164: l_uom_quantity := 1;
1165: l_order_qty := i.line_quantity;
1166: IF l_debug = FND_API.G_TRUE THEN
1167: QP_PREQ_GRP.engine_debug('Standard uom conversion (oks failed), service line...');
1168: QP_PREQ_GRP.engine_debug('pricing_qty:' || v_pricing_qty);
1169: QP_PREQ_GRP.engine_debug('pricing_uom:' || v_primary_uom_code);
1170: QP_PREQ_GRP.engine_debug('order_qty:' || l_order_qty);
1171: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);

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

1171: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);
1172: QP_PREQ_GRP.engine_debug('uom_quantity:' || l_uom_quantity);
1173: END IF;
1174:
1175: ELSE -- from profile being standard case, l_uom_quantity matters for OM
1176: -- assuming OM pass l_uom_quantity is converted to order uom like the following
1177: -- 1 of 2 YR services, order_uom=YR, l_uom_quantity = 2 (YR)
1178: IF l_debug = FND_API.G_TRUE THEN
1179: QP_PREQ_GRP.engine_debug('uom_quantity from calling application:' || i.uom_quantity);

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

1183: l_uom_quantity :=1; -- reset to 1, so the unit price by pricing uom does not change
1184: l_order_qty := i.line_quantity;
1185:
1186: IF l_debug = FND_API.G_TRUE THEN
1187: QP_PREQ_GRP.engine_debug('Standard uom conversion, service line...');
1188: QP_PREQ_GRP.engine_debug('pricing_qty:' || v_pricing_qty);
1189: QP_PREQ_GRP.engine_debug('pricing_uom:' || v_primary_uom_code);
1190: QP_PREQ_GRP.engine_debug('order_qty:' || l_order_qty);
1191: QP_PREQ_GRP.engine_debug('order_uom:' || l_order_uom_code);

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

1196: END IF; -- end if service or non-service line
1197:
1198: END IF; -- end if v_uom_rate
1199:
1200: END IF; -- end profile is 'STANDARD'
1201:
1202:
1203: /*
1204: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1