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 746: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N2,LINE_INDEX,3

742: -- Update all the other list lines to status 'U'
743: /*
744: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
745: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
746: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd1,qp_npreq_lines_tmp_N2,LINE_INDEX,3
747: */
748: UPDATE qp_npreq_ldets_tmp -- upd1
749: SET PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_UOM_FAILURE
750: WHERE INCOMPATABILITY_GRP_CODE = i.INCOMPATABILITY_GRP_CODE

Line 770: UPDATE qp_npreq_lines_tmp a

766: AND a.LINE_INDEX = i.line_index; */
767:
768: -- begin shu, fix bug 2453250, no price_list_header_id after big search
769: /* Commented for bug#2882115
770: UPDATE qp_npreq_lines_tmp a
771: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
772: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
773: AND a.line_index = i.line_index;
774: */

Line 861: UPDATE qp_npreq_lines_tmp

857: l_uom_quantity_tbl(m) := l_uom_quantity; --shu_latest
858: m := m+1;
859:
860: /* no need if bulk update later
861: UPDATE qp_npreq_lines_tmp
862: SET PRICED_UOM_CODE = i.line_uom_code,
863: PRICED_QUANTITY = v_pricing_qty, -- shulin bug 1829731
864: LINE_UOM_CODE = i.line_uom_code, -- order_uom
865: LINE_QUANTITY = l_order_qty, -- shu_latest

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

974: IF (v_list_line_id IS NOT NULL) THEN
975: /*
976: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
977: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
978: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_lines_tmp_N2,LINE_INDEX,3
979: */
980: -- Update all the other list lines to status 'P'
981: UPDATE qp_npreq_ldets_tmp -- upd2
982: SET PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_PRIMARY_UOM_FLAG

Line 1013: UPDATE qp_npreq_lines_tmp a

1009: AND a.LINE_INDEX = i.line_index; */
1010:
1011: -- begin shu, fix bug 2453250, no price_list_header_id after big search
1012: /* Commented for bug#2882115
1013: UPDATE qp_npreq_lines_tmp a
1014: SET a.price_list_header_id = (SELECT list_header_id from qp_list_lines where list_line_id = v_list_line_id )
1015: WHERE ( a.price_list_header_id < 0 OR a.price_list_header_id IS NULL)
1016: AND a.line_index = i.line_index;
1017: */

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

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
1205: */
1206: -- do not nvl UOM_QUANTITY when updating UOM_QUANTITY , for a case if uom_quantity is null for a regular line , we could
1207: -- potentially update it to value by nvl'ing it , when uom_quantity is supposed to be null.
1208: -- 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 1211: UPDATE qp_npreq_lines_tmp -- upd1

1207: -- potentially update it to value by nvl'ing it , when uom_quantity is supposed to be null.
1208: -- Ex: 1Ton = 1000Kg , UOM_QUANTITY passed is null . in this case if we nvl(UOM_QUANTITY,1) then the new uom_quantity after the
1209: -- update will be nvl(uom_quantity,1) * 1000(v_uom_rate) = 1000 which is wrong .. bug# 2028618
1210:
1211: UPDATE qp_npreq_lines_tmp -- upd1
1212: SET PRICED_UOM_CODE = v_primary_uom_code,
1213: PRICED_QUANTITY = v_pricing_qty, -- shulin bug 1829731
1214: LINE_UOM_CODE = l_order_uom_code, -- order_uom, i.line_uom_code
1215: LINE_QUANTITY = l_order_qty, -- shu_latest

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

1246: END LOOP;
1247:
1248:
1249: /*
1250: INDX,QP_Resolve_Incompatability_PVTRUN.determine_pricing_uom_and_qty.upd2,qp_npreq_lines_tmp_N1,LINE_INDEX,1
1251: */
1252:
1253: -- Bulk Update, from no uom conversion cases
1254: FORALL i in 1 .. l_line_index_tbl.COUNT --upd2

Line 1255: UPDATE qp_npreq_lines_tmp

1251: */
1252:
1253: -- Bulk Update, from no uom conversion cases
1254: FORALL i in 1 .. l_line_index_tbl.COUNT --upd2
1255: UPDATE qp_npreq_lines_tmp
1256: SET PRICED_UOM_CODE = l_line_uom_code_tbl(i), --priced uom is the same as order uom
1257: PRICED_QUANTITY = l_priced_quantity_tbl(i), -- shu_latest
1258: LINE_UOM_CODE = l_line_uom_code_tbl(i), -- order uom
1259: LINE_QUANTITY = l_line_quantity_tbl(i), -- shu_latest

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

1400: AND ((b.AUTOMATIC_FLAG = QP_PREQ_GRP.G_YES AND p_manual_dis_flag = QP_PREQ_GRP.G_YES) OR
1401: p_manual_dis_flag = QP_PREQ_GRP.G_NO);
1402: */
1403: /*
1404: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_request_qty_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1*/
1405:
1406: CURSOR get_request_qty_cur IS
1407: SELECT nvl(PRICED_QUANTITY,LINE_QUANTITY)
1408: FROM qp_npreq_lines_tmp

Line 1408: FROM qp_npreq_lines_tmp

1404: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_request_qty_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1*/
1405:
1406: CURSOR get_request_qty_cur IS
1407: SELECT nvl(PRICED_QUANTITY,LINE_QUANTITY)
1408: FROM qp_npreq_lines_tmp
1409: WHERE LINE_INDEX = p_line_index;
1410:
1411: /*
1412: INDX,QP_Resolve_Incompatability_PVTRUN.best_price_evaluation.get_list_price_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1

Line 1712: UPDATE qp_npreq_lines_tmp

1708: QP_PREQ_GRP.engine_debug('deleting lines/ldets/attrs/rltd:'||p_pricing_status_text);
1709: END IF;
1710:
1711: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST
1712: UPDATE qp_npreq_lines_tmp
1713: SET pricing_status_code = QP_PREQ_PUB.G_NOT_VALID, process_status = QP_PREQ_PUB.G_NOT_VALID
1714: WHERE line_index = p_line_index_tbl(i)
1715: and line_id is null; --bug 7539796
1716: FORALL i IN p_line_index_tbl.FIRST..p_line_index_tbl.LAST