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_RLTD_LINES_TMP

Line 290: -- Insert a line into qp_npreq_rltd_lines_tmp

286: x_return_status_txt OUT NOCOPY VARCHAR2) AS
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

Line 293: -- Insert a line into qp_npreq_rltd_lines_tmp

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:
296:
297: CURSOR get_related_modifier_id_cur IS

Line 355: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b

351: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD
352: --SELECT RELATED_LINE_DETAIL_INDEX,LINE_INDEX,RELATED_LINE_INDEX
353: SELECT distinct RELATED_LINE_DETAIL_INDEX,RELATED_LINE_INDEX -- fix bug 2998770
354: ,related_list_line_id -- bug 2979447
355: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b
356: WHERE a.LIST_LINE_ID = p_list_line_id
357: AND b.line_index = a.related_line_index
358: AND (instr(b.PROCESS_STATUS,'FREEGOOD')=0)
359: AND a.RELATIONSHIP_TYPE_CODE = qp_preq_grp.G_GENERATED_LINE

Line 393: -- from qp_npreq_rltd_lines_tmp and create a relationship between the line_detail_index and the rltd_line_detail_index

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:
397: IF l_debug = FND_API.G_TRUE THEN

Line 416: INSERT INTO qp_npreq_rltd_lines_tmp

412: qp_preq_grp.engine_debug('Linegroup Related Line Detail Index: ' || j.related_line_detail_index);
413: END IF;
414: l_rltd_line_detail_index := j.related_line_detail_index;
415:
416: INSERT INTO qp_npreq_rltd_lines_tmp
417: (REQUEST_TYPE_CODE
418: ,LINE_DETAIL_INDEX
419: ,RELATIONSHIP_TYPE_CODE
420: ,RELATED_LINE_DETAIL_INDEX

Line 572: /* INSERT INTO qp_npreq_rltd_lines_tmp(REQUEST_TYPE_CODE, LINE_INDEX,RELATIONSHIP_TYPE_CODE,

568: qp_preq_grp.engine_debug('New Line Created');
569: END IF;
570:
571: -- Ravi remove line to line relationship ie comment out the insert below
572: /* INSERT INTO qp_npreq_rltd_lines_tmp(REQUEST_TYPE_CODE, LINE_INDEX,RELATIONSHIP_TYPE_CODE,
573: RELATED_LINE_INDEX, PRICING_STATUS_CODE) VALUES
574: (v_request_type_code,p_line_index,qp_preq_grp.G_GENERATED_LINE,v_line_index,
575: qp_preq_grp.G_STATUS_NEW);
576: IF l_debug = FND_API.G_TRUE THEN

Line 671: INSERT INTO qp_npreq_rltd_lines_tmp

667: IF l_debug = FND_API.G_TRUE THEN
668: qp_preq_grp.engine_debug('New Adjustment Line Created');
669: END IF;
670:
671: INSERT INTO qp_npreq_rltd_lines_tmp
672: (REQUEST_TYPE_CODE,
673: LINE_DETAIL_INDEX,
674: RELATIONSHIP_TYPE_CODE,
675: RELATED_LINE_DETAIL_INDEX,

Line 678: -- begin shu,side fix bug 2491158,missing data in qp_npreq_rltd_lines_tmp

674: RELATIONSHIP_TYPE_CODE,
675: RELATED_LINE_DETAIL_INDEX,
676: PRICING_STATUS_CODE,
677: LIST_LINE_ID,
678: -- begin shu,side fix bug 2491158,missing data in qp_npreq_rltd_lines_tmp
679: line_index,
680: related_line_index,
681: related_list_line_id,
682: related_list_line_type,

Line 686: -- end shu, side fix bug 2491158, missing data in qp_npreq_rltd_lines_tmp

682: related_list_line_type,
683: operand_calculation_code,
684: operand,
685: qualifier_value
686: -- end shu, side fix bug 2491158, missing data in qp_npreq_rltd_lines_tmp
687: )
688: VALUES
689: (v_request_type_code,
690: j.LINE_DETAIL_INDEX,

Line 695: -- begin shu,side fix bug 2491158,missing data in qp_npreq_rltd_lines_tmp

691: qp_preq_grp.G_GENERATED_LINE,
692: v_detail_line_index,
693: qp_preq_grp.G_STATUS_NEW,
694: p_list_line_id,
695: -- begin shu,side fix bug 2491158,missing data in qp_npreq_rltd_lines_tmp
696: p_line_index,
697: v_line_index,
698: i.LIST_LINE_ID,
699: i.LIST_LINE_TYPE_CODE,

Line 703: -- end shu, side fix bug 2491158, missing data in qp_npreq_rltd_lines_tmp

699: i.LIST_LINE_TYPE_CODE,
700: i.ARITHMETIC_OPERATOR,
701: i.OPERAND,
702: x_total_benefit_qty
703: -- end shu, side fix bug 2491158, missing data in qp_npreq_rltd_lines_tmp
704: );
705:
706: IF l_debug = FND_API.G_TRUE THEN
707: qp_preq_grp.engine_debug('New Related Line Detail-Line Detail Created');

Line 788: -- Insert a line into qp_npreq_rltd_lines_tmp

784: x_return_status_txt OUT NOCOPY VARCHAR2) AS
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

Line 791: -- Insert a line into qp_npreq_rltd_lines_tmp

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:
794:
795: CURSOR get_related_modifier_id_cur IS

Line 992: qp_preq_grp.engine_debug ('debug data going to qp_npreq_rltd_lines_tmp .........');

988: i.MODIFIER_LEVEL_CODE);
989:
990: -- shu, begin fix bug 2491158
991: IF l_debug = FND_API.G_TRUE THEN
992: qp_preq_grp.engine_debug ('debug data going to qp_npreq_rltd_lines_tmp .........');
993: qp_preq_grp.engine_debug ('OID line_index: '||p_line_index);
994: qp_preq_grp.engine_debug ('OID list_line_id: '||p_list_line_id);
995: qp_preq_grp.engine_debug ('Benifit line_index: '||m.line_index);
996: qp_preq_grp.engine_debug ('Benifit list_line_id: '||i.list_line_id);

Line 1003: INSERT INTO qp_npreq_rltd_lines_tmp

999: qp_preq_grp.engine_debug ('Benifit ARITHMETIC_OPERATOR: '||i.ARITHMETIC_OPERATOR);
1000: qp_preq_grp.engine_debug ('Benifit LINE_QUANTITY: '||m.LINE_QUANTITY);
1001: END IF;
1002:
1003: INSERT INTO qp_npreq_rltd_lines_tmp
1004: (REQUEST_TYPE_CODE,
1005: LINE_DETAIL_INDEX,
1006: RELATIONSHIP_TYPE_CODE,
1007: RELATED_LINE_DETAIL_INDEX,

Line 1009: line_index, -- begin shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp

1005: LINE_DETAIL_INDEX,
1006: RELATIONSHIP_TYPE_CODE,
1007: RELATED_LINE_DETAIL_INDEX,
1008: PRICING_STATUS_CODE,
1009: line_index, -- begin shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1010: related_line_index,
1011: list_line_id,
1012: related_list_line_id,
1013: related_list_line_type,

Line 1016: qualifier_value -- end shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp

1012: related_list_line_id,
1013: related_list_line_type,
1014: operand_calculation_code,
1015: operand,
1016: qualifier_value -- end shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1017: )
1018: VALUES
1019: (v_request_type_code,
1020: j.LINE_DETAIL_INDEX,

Line 1024: p_line_index, -- begin shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp

1020: j.LINE_DETAIL_INDEX,
1021: qp_preq_grp.G_GENERATED_LINE,
1022: v_detail_line_index,
1023: qp_preq_grp.G_STATUS_NEW,
1024: p_line_index, -- begin shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1025: m.line_index,
1026: p_list_line_id,
1027: i.list_line_id,
1028: i.list_line_type_code,

Line 1031: m.line_quantity -- end shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp

1027: i.list_line_id,
1028: i.list_line_type_code,
1029: i.arithmetic_operator,
1030: i.operand,
1031: m.line_quantity -- end shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1032: );
1033: -- shu, end fix bug 2491158
1034: END LOOP;
1035: