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 QP_NPREQ_LINES_TMP

Line 395: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1

391: v_routine_name CONSTANT VARCHAR2(240):='Routine:QP_Resolve_Incompatability_PVTRUN.Update_Invalid_List_Lines';
392: BEGIN
393:
394: /*
395: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
396: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1
397: */
398:
399: IF p_status_code IN (QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV) THEN

Line 396: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1

392: BEGIN
393:
394: /*
395: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1
396: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1
397: */
398:
399: IF p_status_code IN (QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV) THEN
400: UPDATE qp_npreq_lines_tmp -- upd1

Line 400: UPDATE qp_npreq_lines_tmp -- upd1

396: INDX,QP_Resolve_Incompatability_PVTRUN.update_invalid_list_lines.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1
397: */
398:
399: IF p_status_code IN (QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV) THEN
400: UPDATE qp_npreq_lines_tmp -- upd1
401: SET PRICING_STATUS_CODE = p_status_code,
402: PRICING_STATUS_TEXT = p_status_text,
403: PROCESSED_CODE = NULL -- To prevent big search from hapenning , if failed in mini search due to above reasons
404: WHERE LINE_INDEX = p_line_index;

Line 406: UPDATE qp_npreq_lines_tmp -- upd2

402: PRICING_STATUS_TEXT = p_status_text,
403: PROCESSED_CODE = NULL -- To prevent big search from hapenning , if failed in mini search due to above reasons
404: WHERE LINE_INDEX = p_line_index;
405: ELSIF (p_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM) THEN
406: UPDATE qp_npreq_lines_tmp -- upd2
407: SET PROCESSED_CODE = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
408: PRICING_STATUS_CODE = p_status_code,
409: PRICING_STATUS_TEXT = p_status_text
410: WHERE LINE_INDEX = p_line_index;

Line 456: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.incomp_cur,qp_npreq_lines_tmp_N2,LINE_INDEX,3

452:
453: /*
454: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.incomp_cur,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
455: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.incomp_cur,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
456: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.incomp_cur,qp_npreq_lines_tmp_N2,LINE_INDEX,3
457: */
458: --shulin bug 1829731, add contract_start_date, contract_end_date
459: --[julin/pricebook] added hint for qp_npreq_ldets_tmp
460: CURSOR incomp_cur IS

Line 464: FROM qp_npreq_lines_tmp b , qp_npreq_ldets_tmp a

460: CURSOR incomp_cur IS
461: SELECT /*+ ORDERED USE_NL(a) INDEX(a QP_PREQ_LDETS_TMP_N2) */
462: DISTINCT a.LINE_INDEX , a.INCOMPATABILITY_GRP_CODE ,a.PRICING_STATUS_CODE,b.LINE_UOM_CODE,b.LINE_QUANTITY,
463: b.PROCESSING_ORDER,b.UOM_QUANTITY, b.CONTRACT_START_DATE, b.CONTRACT_END_DATE
464: FROM qp_npreq_lines_tmp b , qp_npreq_ldets_tmp a
465: WHERE a.INCOMPATABILITY_GRP_CODE IS NOT NULL
466: AND a.PRICING_PHASE_ID = p_pricing_phase_id
467: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
468: AND a.LINE_INDEX = b.LINE_INDEX

Line 753: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N2,LINE_INDEX,3

749: -- Update all the other list lines to status 'U'
750: /*
751: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
752: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
753: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N2,LINE_INDEX,3
754: */
755: UPDATE qp_npreq_ldets_tmp -- upd1
756: SET PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UOM_FAILURE
757: WHERE INCOMPATABILITY_GRP_CODE = i.INCOMPATABILITY_GRP_CODE

Line 777: UPDATE qp_npreq_lines_tmp a

773: AND a.LINE_INDEX = i.line_index; */
774:
775: -- begin shu, fix bug 2453250, no price_list_header_id after big search
776: /* Commented for bug#2882115
777: UPDATE qp_npreq_lines_tmp a
778: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
779: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
780: AND a.line_index = i.line_index;
781: */

Line 870: UPDATE qp_npreq_lines_tmp

866: l_uom_quantity_tbl(m) := l_uom_quantity; --shu_latest
867: m := m+1;
868:
869: /* no need if bulk update later
870: UPDATE qp_npreq_lines_tmp
871: SET PRICED_UOM_CODE = i.line_uom_code,
872: PRICED_QUANTITY = v_pricing_qty, -- shulin bug 1829731
873: LINE_UOM_CODE = i.line_uom_code, -- order_uom
874: LINE_QUANTITY = l_order_qty, -- shu_latest

Line 987: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_lines_tmp_N2,LINE_INDEX,3

983: IF (v_list_line_id IS NOT NULL) THEN
984: /*
985: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
986: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
987: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_lines_tmp_N2,LINE_INDEX,3
988: */
989: -- Update all the other list lines to status 'P'
990: UPDATE qp_npreq_ldets_tmp -- upd2
991: SET PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG

Line 1022: UPDATE qp_npreq_lines_tmp a

1018: AND a.LINE_INDEX = i.line_index; */
1019:
1020: -- begin shu, fix bug 2453250, no price_list_header_id after big search
1021: /* Commented for bug#2882115
1022: UPDATE qp_npreq_lines_tmp a
1023: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
1024: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
1025: AND a.line_index = i.line_index;
1026: */

Line 1213: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N1,LINE_INDEX,1

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
1214: */
1215: -- do not nvl UOM_QUANTITY when updating UOM_QUANTITY , for a case if uom_quantity is null for a regular line , we could
1216: -- potentially update it to value by nvl'ing it , when uom_quantity is supposed to be null.
1217: -- Ex: 1Ton = 1000Kg , UOM_QUANTITY passed is null . in this case if we nvl(UOM_QUANTITY,1) then the new uom_quantity after the

Line 1220: UPDATE qp_npreq_lines_tmp -- upd1

1216: -- potentially update it to value by nvl'ing it , when uom_quantity is supposed to be null.
1217: -- Ex: 1Ton = 1000Kg , UOM_QUANTITY passed is null . in this case if we nvl(UOM_QUANTITY,1) then the new uom_quantity after the
1218: -- update will be nvl(uom_quantity,1) * 1000(v_uom_rate) = 1000 which is wrong .. bug# 2028618
1219:
1220: UPDATE qp_npreq_lines_tmp -- upd1
1221: SET PRICED_UOM_CODE = v_primary_uom_code,
1222: PRICED_QUANTITY = v_pricing_qty, -- shulin bug 1829731
1223: LINE_UOM_CODE = l_order_uom_code, -- order_uom, i.line_uom_code
1224: LINE_QUANTITY = l_order_qty, -- shu_latest

Line 1259: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1

1255: END LOOP;
1256:
1257:
1258: /*
1259: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1260: */
1261:
1262: -- Bulk Update, from no uom conversion cases
1263: FORALL i in 1 .. l_line_index_tbl.COUNT --upd2

Line 1264: UPDATE qp_npreq_lines_tmp

1260: */
1261:
1262: -- Bulk Update, from no uom conversion cases
1263: FORALL i in 1 .. l_line_index_tbl.COUNT --upd2
1264: UPDATE qp_npreq_lines_tmp
1265: SET PRICED_UOM_CODE = l_line_uom_code_tbl(i), --priced uom is the same as order uom
1266: PRICED_QUANTITY = l_priced_quantity_tbl(i), -- shu_latest
1267: LINE_UOM_CODE = l_line_uom_code_tbl(i), -- order uom
1268: LINE_QUANTITY = l_line_quantity_tbl(i), -- shu_latest

Line 1413: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_request_qty_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1*/

1409: AND ((b.AUTOMATIC_FLAG = QP_PREQ_GRP.G_YES AND p_manual_dis_flag = QP_PREQ_GRP.G_YES) OR
1410: p_manual_dis_flag = QP_PREQ_GRP.G_NO);
1411: */
1412: /*
1413: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_request_qty_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1*/
1414:
1415: CURSOR get_request_qty_cur IS
1416: SELECT nvl(PRICED_QUANTITY,LINE_QUANTITY)
1417: FROM qp_npreq_lines_tmp

Line 1417: FROM qp_npreq_lines_tmp

1413: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_request_qty_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1*/
1414:
1415: CURSOR get_request_qty_cur IS
1416: SELECT nvl(PRICED_QUANTITY,LINE_QUANTITY)
1417: FROM qp_npreq_lines_tmp
1418: WHERE LINE_INDEX = p_line_index;
1419:
1420: /*
1421: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_price_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

Line 1748: UPDATE qp_npreq_lines_tmp

1744: QP_PREQ_GRP.engine_debug('deleting lines/ldets/attrs/rltd:'||p_pricing_status_text);
1745: END IF;
1746:
1747: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1748: UPDATE qp_npreq_lines_tmp
1749: SET pricing_status_code = QP_PREQ_PUB.G_NOT_VALID, process_status = QP_PREQ_PUB.G_NOT_VALID
1750: WHERE line_index = p_line_index_tbl(i)
1751: and line_id is null; --bug 7539796
1752: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST