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_RESOLVE_INCOMPATABILITY_PVT dependencies on OKS_OMINT_PUB

Line 798: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12

794: QP_PREQ_GRP.engine_debug( 'line_uom_code/order uom :' || i.line_uom_code); -- order_uom
795: END IF;
796:
797: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
798: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
799: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
800: * when env language has ',' delimiter
801: l_sql_stmt := 'select ' || nvl(ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits), -999999) ||' from dual';
802: IF l_debug = FND_API.G_TRUE THEN

Line 801: l_sql_stmt := 'select ' || nvl(ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits), -999999) ||' from dual';

797: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
798: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
799: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
800: * when env language has ',' delimiter
801: l_sql_stmt := 'select ' || nvl(ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits), -999999) ||' from dual';
802: IF l_debug = FND_API.G_TRUE THEN
803: QP_PREQ_GRP.engine_debug('l_sql_stmt:' || l_sql_stmt);
804: END IF; -- end debug
805: execute immediate l_sql_stmt INTO l_oks_qty;

Line 810: -- l_oks_qty := nvl(ROUND (OKS_OMINT_PUB.get_target_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits), -999999);

806: */
807: --END IF;
808: --bug 4900095
809: IF l_duration_passed = 'N' THEN --call OKS API for OKS calls where uom_quantity is passed as null
810: -- l_oks_qty := nvl(ROUND (OKS_OMINT_PUB.get_target_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits), -999999);
811: --bug 4900095
812: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
813: p_end_date => i.contract_end_date,
814: p_source_uom => i.line_uom_code,

Line 812: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,

808: --bug 4900095
809: IF l_duration_passed = 'N' THEN --call OKS API for OKS calls where uom_quantity is passed as null
810: -- l_oks_qty := nvl(ROUND (OKS_OMINT_PUB.get_target_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits), -999999);
811: --bug 4900095
812: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
813: p_end_date => i.contract_end_date,
814: p_source_uom => i.line_uom_code,
815: p_source_duration => i.uom_quantity,
816: p_target_uom => i.line_uom_code,/*Default Month*/

Line 1055: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12

1051: -- when contract_start_date or contract_end_date is null, or uom is 'MO' instead of 'MTH', l_oks_qty = 0
1052: -- when uom is not time_related or invalid to oks API, i.e. 'EA', 'MI', l_oks_qty = NULL
1053:
1054: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
1055: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
1056: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
1057: * when env language has ',' delimiter
1058: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1059: i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';

Line 1058: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,

1054: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
1055: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
1056: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
1057: * when env language has ',' delimiter
1058: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1059: i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1060: execute immediate l_sql_stmt INTO l_oks_qty; -- shulin
1061: */
1062: --END IF;

Line 1063: -- l_oks_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);

1059: i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1060: execute immediate l_sql_stmt INTO l_oks_qty; -- shulin
1061: */
1062: --END IF;
1063: -- l_oks_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);
1064: --bug 4900095
1065: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1066: p_end_date => i.contract_end_date,
1067: p_source_uom => i.line_uom_code,

Line 1065: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,

1061: */
1062: --END IF;
1063: -- l_oks_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);
1064: --bug 4900095
1065: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1066: p_end_date => i.contract_end_date,
1067: p_source_uom => i.line_uom_code,
1068: p_source_duration => i.uom_quantity,
1069: p_target_uom => v_primary_uom_code,/*Default Month*/

Line 1083: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,

1079:
1080: -- order_qty is based on odr_uom
1081: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
1082: * when env language has ',' delimiter
1083: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1084: i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1085: execute immediate l_sql_stmt INTO l_order_qty; -- shu_latest
1086: */
1087: -- l_order_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);

Line 1087: -- l_order_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);

1083: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1084: i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1085: execute immediate l_sql_stmt INTO l_order_qty; -- shu_latest
1086: */
1087: -- l_order_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);
1088: --bug 4900095
1089: l_order_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1090: p_end_date => i.contract_end_date,
1091: p_source_uom => i.line_uom_code,

Line 1089: l_order_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,

1085: execute immediate l_sql_stmt INTO l_order_qty; -- shu_latest
1086: */
1087: -- l_order_qty := ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date, i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits);
1088: --bug 4900095
1089: l_order_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1090: p_end_date => i.contract_end_date,
1091: p_source_uom => i.line_uom_code,
1092: p_source_duration => i.uom_quantity,
1093: p_target_uom => i.line_uom_code,/*Default Month*/