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_COPY_DEBUG_PVT dependencies on QP_JAVA_ENGINE_UTIL_PUB

Line 768: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

764: CONTRACT_START_DATE,
765: CONTRACT_END_DATE,
766: NULL -- sfiresto 2374448
767: FROM qp_npreq_lines_tmp
768: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
769: --added by yangli for Java Engine 3086881
770: UNION ALL
771: SELECT REQUEST_TYPE_CODE,
772: LINE_ID,

Line 818: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

814: CONTRACT_START_DATE,
815: CONTRACT_END_DATE,
816: NULL -- sfiresto 2374448
817: FROM qp_int_lines
818: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
819: --added by yangli for Java Engine 3086881
820: ORDER BY line_index;
821:
822: CURSOR LDETS_CUR IS

Line 882: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

878: BASE_CURRENCY_CODE,
879: ORDER_CURRENCY,
880: CURRENCY_DETAIL_ID
881: FROM qp_npreq_ldets_tmp
882: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
883: --added by yangli for Java Engine 3086881
884: UNION ALL
885: SELECT LINE_DETAIL_INDEX,
886: LINE_DETAIL_TYPE_CODE,

Line 944: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

940: BASE_CURRENCY_CODE,
941: ORDER_CURRENCY,
942: CURRENCY_DETAIL_ID
943: FROM qp_int_ldets
944: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
945: --added by yangli for Java Engine 3086881
946: ORDER BY LINE_INDEX, LINE_DETAIL_INDEX;
947:
948: CURSOR LINE_ATTRS_CUR IS

Line 984: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

980: LINE_DETAIL_TYPE_CODE,
981: MODIFIER_LEVEL_CODE,
982: PRIMARY_UOM_FLAG
983: FROM qp_npreq_line_attrs_tmp
984: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
985: --added by yangli for Java Engine 3086881
986: UNION ALL
987: SELECT LINE_INDEX,
988: LINE_DETAIL_INDEX,

Line 1022: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

1018: LINE_DETAIL_TYPE_CODE,
1019: MODIFIER_LEVEL_CODE,
1020: PRIMARY_UOM_FLAG
1021: FROM qp_int_line_attrs
1022: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1023: --added by yangli for Java Engine 3086881
1024: ORDER BY LINE_INDEX, LINE_DETAIL_INDEX;
1025:
1026: CURSOR RLTD_LINES_CUR IS

Line 1048: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

1044: QUALIFIER_VALUE,
1045: ADJUSTMENT_AMOUNT,
1046: SATISFIED_RANGE_VALUE
1047: FROM qp_npreq_rltd_lines_tmp
1048: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1049: --added by yangli for Java Engine 3086881
1050: UNION ALL
1051: SELECT REQUEST_TYPE_CODE,
1052: LINE_INDEX,

Line 1072: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

1068: QUALIFIER_VALUE,
1069: ADJUSTMENT_AMOUNT,
1070: SATISFIED_RANGE_VALUE
1071: FROM qp_int_rltd_lines
1072: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1073: --added by yangli for Java Engine 3086881
1074: ORDER BY LINE_INDEX, LINE_DETAIL_INDEX;
1075:
1076: CURSOR STEP_VALUES_CUR IS

Line 1086: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

1082: LIST_LINE_TYPE_CODE,
1083: LIST_HEADER_ID,
1084: LIST_LINE_ID
1085: FROM qp_nformula_step_values_tmp
1086: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1087: --added by yangli for Java Engine 3086881
1088: UNION ALL
1089: SELECT PRICE_FORMULA_ID,
1090: STEP_NUMBER,

Line 1098: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

1094: LIST_LINE_TYPE_CODE,
1095: LIST_HEADER_ID,
1096: LIST_LINE_ID
1097: FROM qp_int_formula_step_values
1098: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1099: --added by yangli for Java Engine 3086881
1100: ORDER BY LINE_INDEX, PRICE_FORMULA_ID, STEP_NUMBER;
1101:
1102: -- CURSOR REQUEST_ID_CUR IS

Line 1107: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

1103: -- SELECT qp_debug_req_s.nextval FROM dual;
1104:
1105: CURSOR LINE_ID_CUR IS
1106: SELECT LINE_ID FROM qp_npreq_lines_tmp
1107: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1108: AND LINE_TYPE_CODE = 'ORDER'
1109: AND ROWNUM = 1
1110: UNION ALL
1111: SELECT LINE_ID FROM qp_int_lines

Line 1112: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

1108: AND LINE_TYPE_CODE = 'ORDER'
1109: AND ROWNUM = 1
1110: UNION ALL
1111: SELECT LINE_ID FROM qp_int_lines
1112: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1113: AND LINE_TYPE_CODE = 'ORDER'
1114: AND ROWNUM = 1;
1115:
1116: CURSOR REQUEST_TYPE_CODE_CUR IS

Line 1118: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

1114: AND ROWNUM = 1;
1115:
1116: CURSOR REQUEST_TYPE_CODE_CUR IS
1117: SELECT REQUEST_TYPE_CODE FROM qp_npreq_lines_tmp
1118: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1119: AND ROWNUM = 1
1120: UNION ALL
1121: SELECT REQUEST_TYPE_CODE FROM qp_int_lines
1122: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

Line 1122: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

1118: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1119: AND ROWNUM = 1
1120: UNION ALL
1121: SELECT REQUEST_TYPE_CODE FROM qp_int_lines
1122: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1123: AND ROWNUM = 1;
1124:
1125: CURSOR CURRENCY_CODE_CUR IS
1126: SELECT CURRENCY_CODE FROM qp_npreq_lines_tmp

Line 1127: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'

1123: AND ROWNUM = 1;
1124:
1125: CURSOR CURRENCY_CODE_CUR IS
1126: SELECT CURRENCY_CODE FROM qp_npreq_lines_tmp
1127: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1128: AND ROWNUM = 1
1129: UNION ALL
1130: SELECT CURRENCY_CODE FROM qp_int_lines
1131: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

Line 1131: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'

1127: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
1128: AND ROWNUM = 1
1129: UNION ALL
1130: SELECT CURRENCY_CODE FROM qp_int_lines
1131: WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
1132: AND ROWNUM = 1;
1133:
1134: CURSOR LINE_ATTR_ID_CUR is
1135: SELECT qp_line_attr_s.nextval FROM dual;

Line 1467: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN

1463: EXIT WHEN line_attrs_cur%NOTFOUND;
1464: END LOOP; -- --loop over main line_attrs_cur
1465: CLOSE line_attrs_cur;
1466:
1467: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
1468: select count(*) into l_Rec_Count from qp_npreq_rltd_lines_tmp;
1469: IF l_debug = FND_API.G_TRUE THEN
1470: QP_PREQ_GRP.engine_debug('***Record count in qp_npreq_rltd_lines_tmp : ' || l_Rec_Count);
1471: END IF;