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 791: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12

787: QP_PREQ_GRP.engine_debug( 'line_uom_code/order uom :' || i.line_uom_code); -- order_uom
788: END IF;
789:
790: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
791: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
792: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
793: * when env language has ',' delimiter
794: 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';
795: IF l_debug = FND_API.G_TRUE THEN

Line 794: 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';

790: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
791: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
792: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
793: * when env language has ',' delimiter
794: 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';
795: IF l_debug = FND_API.G_TRUE THEN
796: QP_PREQ_GRP.engine_debug('l_sql_stmt:' || l_sql_stmt);
797: END IF; -- end debug
798: execute immediate l_sql_stmt INTO l_oks_qty;

Line 803: -- 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);

799: */
800: --END IF;
801: --bug 4900095
802: IF l_duration_passed = 'N' THEN --call OKS API for OKS calls where uom_quantity is passed as null
803: -- 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);
804: --bug 4900095
805: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
806: p_end_date => i.contract_end_date,
807: p_source_uom => i.line_uom_code,

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

801: --bug 4900095
802: IF l_duration_passed = 'N' THEN --call OKS API for OKS calls where uom_quantity is passed as null
803: -- 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);
804: --bug 4900095
805: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
806: p_end_date => i.contract_end_date,
807: p_source_uom => i.line_uom_code,
808: p_source_duration => i.uom_quantity,
809: p_target_uom => i.line_uom_code,/*Default Month*/

Line 1046: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12

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

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

1045: --IF i.contract_start_date IS NOT NULL AND i.contract_end_date IS NOT NULL THEN
1046: -- OKS_TIME_MEASURES_PUB replaced with OKS_OMINT_PUB in R12
1047: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
1048: * when env language has ',' delimiter
1049: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1050: i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1051: execute immediate l_sql_stmt INTO l_oks_qty; -- shulin
1052: */
1053: --END IF;

Line 1054: -- 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);

1050: i.contract_end_date, v_primary_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1051: execute immediate l_sql_stmt INTO l_oks_qty; -- shulin
1052: */
1053: --END IF;
1054: -- 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);
1055: --bug 4900095
1056: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1057: p_end_date => i.contract_end_date,
1058: p_source_uom => i.line_uom_code,

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

1052: */
1053: --END IF;
1054: -- 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);
1055: --bug 4900095
1056: l_oks_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1057: p_end_date => i.contract_end_date,
1058: p_source_uom => i.line_uom_code,
1059: p_source_duration => i.uom_quantity,
1060: p_target_uom => v_primary_uom_code,/*Default Month*/

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

1070:
1071: -- order_qty is based on odr_uom
1072: /* [julin/4285975/4662388] removing dynamic SQL, unnecessary and causes error
1073: * when env language has ',' delimiter
1074: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1075: i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1076: execute immediate l_sql_stmt INTO l_order_qty; -- shu_latest
1077: */
1078: -- 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 1078: -- 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);

1074: l_sql_stmt := 'select ' || ROUND (OKS_OMINT_PUB.get_quantity (i.contract_start_date,
1075: i.contract_end_date, i.line_uom_code, QP_PREQ_GRP.G_CURRENT_USER_OP_UNIT), l_max_decimal_digits) ||' from dual';
1076: execute immediate l_sql_stmt INTO l_order_qty; -- shu_latest
1077: */
1078: -- 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);
1079: --bug 4900095
1080: l_order_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1081: p_end_date => i.contract_end_date,
1082: p_source_uom => i.line_uom_code,

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

1076: execute immediate l_sql_stmt INTO l_order_qty; -- shu_latest
1077: */
1078: -- 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);
1079: --bug 4900095
1080: l_order_qty := nvl(round(OKS_OMINT_PUB.get_target_duration( p_start_date => i.contract_start_date,
1081: p_end_date => i.contract_end_date,
1082: p_source_uom => i.line_uom_code,
1083: p_source_duration => i.uom_quantity,
1084: p_target_uom => i.line_uom_code,/*Default Month*/