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_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_NPREQ_LDETS_TMP

Line 32: FROM qp_npreq_ldets_tmp

28: AND a.PRICING_STATUS_CODE in (qp_preq_grp.G_STATUS_UNCHANGED,qp_preq_grp.G_STATUS_NEW);*/
29:
30: CURSOR get_total_qty_cur IS
31: SELECT LINE_QUANTITY,GROUP_QUANTITY,GROUP_AMOUNT
32: FROM qp_npreq_ldets_tmp
33: WHERE CREATED_FROM_LIST_LINE_ID = p_list_line_id
34: AND LINE_INDEX = p_line_index
35: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
36:

Line 39: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp b

35: AND PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW;
36:
37: CURSOR get_base_qty_cur(p_pricing_attribute VARCHAR2) IS
38: SELECT a.SETUP_VALUE_FROM , b.CREATED_FROM_LIST_LINE_TYPE,b.OPERAND_VALUE,b.BENEFIT_QTY
39: FROM qp_npreq_line_attrs_tmp a , qp_npreq_ldets_tmp b
40: WHERE a.LINE_INDEX = p_line_index
41: AND a.LINE_INDEX = b.LINE_INDEX
42: AND a.LIST_LINE_ID = b.CREATED_FROM_LIST_LINE_ID
43: AND a.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT

Line 202: FROM qp_npreq_ldets_tmp QPLT

198: SELECT QPLT.LINE_DETAIL_INDEX,
199: QPLT.CREATED_FROM_LIST_LINE_ID,
200: QPLT.CREATED_FROM_LIST_HEADER_ID,
201: QPLT.LINE_INDEX
202: FROM qp_npreq_ldets_tmp QPLT
203: WHERE PRICING_PHASE_ID = p_pricing_phase_id
204: AND QPLT.AUTOMATIC_FLAG = QP_PREQ_GRP.G_YES -- 5632314
205: AND QPLT.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
206: AND CREATED_FROM_LIST_LINE_TYPE IN (QP_PREQ_GRP.G_DISCOUNT, QP_PREQ_GRP.G_SURCHARGE, QP_PREQ_GRP.G_FREIGHT_CHARGE)

Line 262: UPDATE qp_npreq_ldets_tmp --upd1

258: END IF;
259: END LOOP;
260:
261: FORALL I IN l_line_detail_index_tbl.first..l_line_detail_index_tbl.last
262: UPDATE qp_npreq_ldets_tmp --upd1
263: SET operand_value = l_benefit_line_qty_tbl(I)
264: WHERE LINE_DETAIL_INDEX = l_line_detail_index_tbl(I);
265:
266: IF l_debug = FND_API.G_TRUE THEN

Line 295: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line

291:
292: -- Get the Related Modifier id from qp_rltd_modifiers table
293: -- Insert a line into the qp_npreq_lines_tmp table for the other item
294: -- Insert a line into qp_npreq_rltd_lines_tmp
295: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
296:
297: -- Insert a line into qp_npreq_rltd_lines_tmp
298: -- Insert a line into qp_npreq_line_attrs_tmp
299:

Line 304: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c

300:
301: CURSOR get_related_modifier_id_cur IS
302: SELECT distinct a.PRICE_BREAK_TYPE_CODE , b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID,c.LINE_DETAIL_INDEX ,
303: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG,a.LIST_HEADER_ID
304: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
305: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
306: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
307: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
308: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_PROMO_GOODS_DISCOUNT

Line 329: FROM qp_npreq_ldets_tmp c

325: AND b.LIST_LINE_ID= p_related_modifier_id;
326:
327: CURSOR get_benefit_line_index_cur(p_list_line_id NUMBER, p_line_index NUMBER) IS
328: SELECT CREATED_FROM_LIST_LINE_ID
329: FROM qp_npreq_ldets_tmp c
330: WHERE c.CREATED_FROM_LIST_LINE_ID = p_list_line_id
331: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW
332: AND c.LINE_INDEX = p_line_index ;
333:

Line 407: -- Get the line detail index of the prg line from qp_npreq_ldets_tmp and then get the rltd_line_detail_index

403:
404: l_rltd_line_detail_index := NULL;
405:
406: -- Ravi (If it is a LINEGROUP PRG) Then Just create the relationship
407: -- Get the line detail index of the prg line from qp_npreq_ldets_tmp and then get the rltd_line_detail_index
408: -- from qp_npreq_rltd_lines_tmp and create a relationship between the line_detail_index and the rltd_line_detail_index
409: -- If record does not exist go thru the regular prg processing
410:
411:

Line 623: INSERT INTO qp_npreq_ldets_tmp

619:
620: v_detail_line_index := v_detail_line_index + 1; -- Temporary
621:
622: -- Create a PLL Line
623: INSERT INTO qp_npreq_ldets_tmp
624: (LINE_DETAIL_INDEX
625: ,LINE_DETAIL_TYPE_CODE
626: ,LINE_INDEX
627: ,CREATED_FROM_LIST_HEADER_ID

Line 663: INSERT INTO qp_npreq_ldets_tmp

659:
660: v_detail_line_index := v_detail_line_index + 1; -- Temporary
661:
662: -- Create an Adjustment Line
663: INSERT INTO qp_npreq_ldets_tmp
664: (LINE_DETAIL_INDEX
665: ,LINE_DETAIL_TYPE_CODE
666: ,LINE_INDEX
667: ,CREATED_FROM_LIST_HEADER_ID

Line 788: UPDATE qp_npreq_ldets_tmp --upd1

784: -- This is the code to delete the PRG lines which do not have
785: -- adjustments/benefits even thou x_qualifier_flag=TRUE
786:
787: /* IF (v_benefit_exists = FALSE) THEN
788: UPDATE qp_npreq_ldets_tmp --upd1
789: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
790: WHERE PRICING_PHASE_ID = p_pricing_phase_id
791: AND LINE_INDEX = p_line_index
792: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id

Line 829: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line

825:
826: -- Get the Related Modifier id from qp_rltd_modifiers table
827: -- Insert a line into the qp_npreq_lines_tmp table for the other item
828: -- Insert a line into qp_npreq_rltd_lines_tmp
829: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
830:
831: -- Insert a line into qp_npreq_rltd_lines_tmp
832: -- Insert a line into qp_npreq_line_attrs_tmp
833:

Line 838: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c

834:
835: CURSOR get_related_modifier_id_cur IS
836: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,
837: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG
838: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
839: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
840: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
841: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
842: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_OTHER_ITEM_DISCOUNT

Line 878: FROM qp_npreq_ldets_tmp c

874: AND a.ATTRIBUTE_TYPE = qp_preq_grp.G_PRODUCT_TYPE
875: AND a.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED
876: AND b.LINE_TYPE_CODE <> qp_preq_grp.G_ORDER_LEVEL
877: AND NOT EXISTS ( SELECT /*+ index(c qp_preq_ldets_tmp_n1) */ 'x'
878: FROM qp_npreq_ldets_tmp c
879: WHERE c.LINE_INDEX = a.LINE_INDEX
880: AND c.CREATED_FROM_LIST_LINE_ID = p_list_line_id
881: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW);
882:

Line 955: UPDATE qp_npreq_ldets_tmp --upd1

951: IF l_debug = FND_API.G_TRUE THEN
952: qp_preq_grp.engine_debug('Failed in Qualification:' || j.TO_RLTD_MODIFIER_ID);
953: END IF;
954:
955: UPDATE qp_npreq_ldets_tmp --upd1
956: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
957: WHERE PRICING_PHASE_ID = p_pricing_phase_id
958: AND LINE_INDEX = p_line_index
959: AND CREATED_FROM_LIST_LINE_ID = j.FROM_RLTD_MODIFIER_ID

Line 990: INSERT INTO qp_npreq_ldets_tmp

986:
987: v_benefit_exists := TRUE;
988: v_detail_line_index := v_detail_line_index + 1; -- Temporary
989:
990: INSERT INTO qp_npreq_ldets_tmp
991: (LINE_DETAIL_INDEX,
992: LINE_DETAIL_TYPE_CODE,
993: LINE_INDEX,
994: CREATED_FROM_LIST_HEADER_ID,

Line 1082: UPDATE qp_npreq_ldets_tmp --upd2

1078:
1079: --Begin Bug No: 7323590
1080: /* commented out for bug No: 7323590
1081: IF (v_benefit_exists = FALSE) THEN
1082: UPDATE qp_npreq_ldets_tmp --upd2
1083: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1084: WHERE PRICING_PHASE_ID = p_pricing_phase_id
1085: AND LINE_INDEX = p_line_index
1086: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id

Line 1307: UPDATE qp_npreq_ldets_tmp --upd1

1303: qp_preq_grp.engine_debug('Benefit Record Count:' || v_count);
1304: END IF;
1305:
1306: IF (v_update_flag = TRUE) THEN
1307: UPDATE qp_npreq_ldets_tmp --upd1
1308: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1309: WHERE CREATED_FROM_LIST_LINE_ID = p_list_line_id;
1310:
1311: -- This statement is not needed

Line 1315: FROM qp_npreq_ldets_tmp b

1311: -- This statement is not needed
1312: /* UPDATE qp_npreq_line_attrs_tmp a
1313: SET a.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1314: WHERE a.LINE_DETAIL_INDEX IN (SELECT b.LINE_DETAIL_INDEX
1315: FROM qp_npreq_ldets_tmp b
1316: WHERE b.CREATED_FROM_LIST_LINE_ID = p_list_line_id); */
1317:
1318: IF l_debug = FND_API.G_TRUE THEN
1319: qp_preq_grp.engine_debug ('BENEFIT STATUS UPDATED');

Line 1347: FROM qp_npreq_ldets_tmp ldets

1343:
1344: CURSOR get_list_lines_cur IS
1345: SELECT /*+ index (ldets qp_preq_ldets_tmp_N2) */
1346: CREATED_FROM_LIST_LINE_ID,CREATED_FROM_LIST_LINE_TYPE,LINE_DETAIL_INDEX , MODIFIER_LEVEL_CODE
1347: FROM qp_npreq_ldets_tmp ldets
1348: WHERE CREATED_FROM_LIST_LINE_TYPE IN (qp_preq_grp.G_OTHER_ITEM_DISCOUNT, qp_preq_grp.G_PROMO_GOODS_DISCOUNT,
1349: qp_preq_grp.G_COUPON_ISSUE)
1350: AND PRICING_PHASE_ID = p_pricing_phase_id
1351: AND LINE_INDEX = p_line_index

Line 1428: UPDATE qp_npreq_ldets_tmp --upd1

1424: */
1425:
1426: END IF;
1427: ELSE
1428: UPDATE qp_npreq_ldets_tmp --upd1
1429: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1430: WHERE PRICING_PHASE_ID = p_pricing_phase_id
1431: AND LINE_INDEX = p_line_index
1432: AND CREATED_FROM_LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID