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 198: FROM qp_npreq_ldets_tmp QPLT

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

Line 258: UPDATE qp_npreq_ldets_tmp --upd1

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

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

287:
288: -- Get the Related Modifier id from qp_rltd_modifiers table
289: -- Insert a line into the qp_npreq_lines_tmp table for the other item
290: -- Insert a line into qp_npreq_rltd_lines_tmp
291: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
292:
293: -- Insert a line into qp_npreq_rltd_lines_tmp
294: -- Insert a line into qp_npreq_line_attrs_tmp
295:

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

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

Line 323: FROM qp_npreq_ldets_tmp c

319: AND b.LIST_LINE_ID= p_related_modifier_id;
320:
321: CURSOR get_benefit_line_index_cur(p_list_line_id NUMBER, p_line_index NUMBER) IS
322: SELECT CREATED_FROM_LIST_LINE_ID
323: FROM qp_npreq_ldets_tmp c
324: WHERE c.CREATED_FROM_LIST_LINE_ID = p_list_line_id
325: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW
326: AND c.LINE_INDEX = p_line_index ;
327:

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

388:
389: l_rltd_line_detail_index := NULL;
390:
391: -- Ravi (If it is a LINEGROUP PRG) Then Just create the relationship
392: -- Get the line detail index of the prg line from qp_npreq_ldets_tmp and then get the rltd_line_detail_index
393: -- from qp_npreq_rltd_lines_tmp and create a relationship between the line_detail_index and the rltd_line_detail_index
394: -- If record does not exist go thru the regular prg processing
395:
396:

Line 583: INSERT INTO qp_npreq_ldets_tmp

579:
580: v_detail_line_index := v_detail_line_index + 1; -- Temporary
581:
582: -- Create a PLL Line
583: INSERT INTO qp_npreq_ldets_tmp
584: (LINE_DETAIL_INDEX
585: ,LINE_DETAIL_TYPE_CODE
586: ,LINE_INDEX
587: ,CREATED_FROM_LIST_HEADER_ID

Line 623: INSERT INTO qp_npreq_ldets_tmp

619:
620: v_detail_line_index := v_detail_line_index + 1; -- Temporary
621:
622: -- Create an Adjustment 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 748: UPDATE qp_npreq_ldets_tmp --upd1

744: -- This is the code to delete the PRG lines which do not have
745: -- adjustments/benefits even thou x_qualifier_flag=TRUE
746:
747: /* IF (v_benefit_exists = FALSE) THEN
748: UPDATE qp_npreq_ldets_tmp --upd1
749: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
750: WHERE PRICING_PHASE_ID = p_pricing_phase_id
751: AND LINE_INDEX = p_line_index
752: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id

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

785:
786: -- Get the Related Modifier id from qp_rltd_modifiers table
787: -- Insert a line into the qp_npreq_lines_tmp table for the other item
788: -- Insert a line into qp_npreq_rltd_lines_tmp
789: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
790:
791: -- Insert a line into qp_npreq_rltd_lines_tmp
792: -- Insert a line into qp_npreq_line_attrs_tmp
793:

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

794:
795: CURSOR get_related_modifier_id_cur IS
796: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,
797: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG
798: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
799: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
800: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
801: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
802: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_OTHER_ITEM_DISCOUNT

Line 838: FROM qp_npreq_ldets_tmp c

834: AND a.ATTRIBUTE_TYPE = qp_preq_grp.G_PRODUCT_TYPE
835: AND a.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED
836: AND b.LINE_TYPE_CODE <> qp_preq_grp.G_ORDER_LEVEL
837: AND NOT EXISTS ( SELECT /*+ index(c qp_preq_ldets_tmp_n1) */ 'x'
838: FROM qp_npreq_ldets_tmp c
839: WHERE c.LINE_INDEX = a.LINE_INDEX
840: AND c.CREATED_FROM_LIST_LINE_ID = p_list_line_id
841: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_NEW);
842:

Line 915: UPDATE qp_npreq_ldets_tmp --upd1

911: IF l_debug = FND_API.G_TRUE THEN
912: qp_preq_grp.engine_debug('Failed in Qualification:' || j.TO_RLTD_MODIFIER_ID);
913: END IF;
914:
915: UPDATE qp_npreq_ldets_tmp --upd1
916: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
917: WHERE PRICING_PHASE_ID = p_pricing_phase_id
918: AND LINE_INDEX = p_line_index
919: AND CREATED_FROM_LIST_LINE_ID = j.FROM_RLTD_MODIFIER_ID

Line 950: INSERT INTO qp_npreq_ldets_tmp

946:
947: v_benefit_exists := TRUE;
948: v_detail_line_index := v_detail_line_index + 1; -- Temporary
949:
950: INSERT INTO qp_npreq_ldets_tmp
951: (LINE_DETAIL_INDEX,
952: LINE_DETAIL_TYPE_CODE,
953: LINE_INDEX,
954: CREATED_FROM_LIST_HEADER_ID,

Line 1042: UPDATE qp_npreq_ldets_tmp --upd2

1038:
1039: --Begin Bug No: 7323590
1040: /* commented out for bug No: 7323590
1041: IF (v_benefit_exists = FALSE) THEN
1042: UPDATE qp_npreq_ldets_tmp --upd2
1043: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1044: WHERE PRICING_PHASE_ID = p_pricing_phase_id
1045: AND LINE_INDEX = p_line_index
1046: AND CREATED_FROM_LIST_LINE_ID = p_list_line_id

Line 1267: UPDATE qp_npreq_ldets_tmp --upd1

1263: qp_preq_grp.engine_debug('Benefit Record Count:' || v_count);
1264: END IF;
1265:
1266: IF (v_update_flag = TRUE) THEN
1267: UPDATE qp_npreq_ldets_tmp --upd1
1268: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1269: WHERE CREATED_FROM_LIST_LINE_ID = p_list_line_id;
1270:
1271: -- This statement is not needed

Line 1275: FROM qp_npreq_ldets_tmp b

1271: -- This statement is not needed
1272: /* UPDATE qp_npreq_line_attrs_tmp a
1273: SET a.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1274: WHERE a.LINE_DETAIL_INDEX IN (SELECT b.LINE_DETAIL_INDEX
1275: FROM qp_npreq_ldets_tmp b
1276: WHERE b.CREATED_FROM_LIST_LINE_ID = p_list_line_id); */
1277:
1278: IF l_debug = FND_API.G_TRUE THEN
1279: qp_preq_grp.engine_debug ('BENEFIT STATUS UPDATED');

Line 1307: FROM qp_npreq_ldets_tmp ldets

1303:
1304: CURSOR get_list_lines_cur IS
1305: SELECT /*+ index (ldets qp_preq_ldets_tmp_N2) */
1306: CREATED_FROM_LIST_LINE_ID,CREATED_FROM_LIST_LINE_TYPE,LINE_DETAIL_INDEX , MODIFIER_LEVEL_CODE
1307: FROM qp_npreq_ldets_tmp ldets
1308: WHERE CREATED_FROM_LIST_LINE_TYPE IN (qp_preq_grp.G_OTHER_ITEM_DISCOUNT, qp_preq_grp.G_PROMO_GOODS_DISCOUNT,
1309: qp_preq_grp.G_COUPON_ISSUE)
1310: AND PRICING_PHASE_ID = p_pricing_phase_id
1311: AND LINE_INDEX = p_line_index

Line 1388: UPDATE qp_npreq_ldets_tmp --upd1

1384: */
1385:
1386: END IF;
1387: ELSE
1388: UPDATE qp_npreq_ldets_tmp --upd1
1389: SET PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_OTHER_ITEM_BENEFITS
1390: WHERE PRICING_PHASE_ID = p_pricing_phase_id
1391: AND LINE_INDEX = p_line_index
1392: AND CREATED_FROM_LIST_LINE_ID = i.CREATED_FROM_LIST_LINE_ID