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 294: -- Insert a line into qp_npreq_rltd_lines_tmp

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

Line 297: -- Insert a line into qp_npreq_rltd_lines_tmp

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:
300:
301: CURSOR get_related_modifier_id_cur IS

Line 367: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b

363: -- qp_npreq_lines_tmp to check the process_status for string FREEGOOD
364: --SELECT RELATED_LINE_DETAIL_INDEX,LINE_INDEX,RELATED_LINE_INDEX
365: SELECT distinct RELATED_LINE_DETAIL_INDEX,RELATED_LINE_INDEX -- fix bug 2998770
366: ,related_list_line_id -- bug 2979447
367: FROM qp_npreq_rltd_lines_tmp a, qp_npreq_lines_tmp b
368: WHERE a.LIST_LINE_ID = p_list_line_id
369: AND b.line_index = a.related_line_index
370: AND (instr(b.PROCESS_STATUS,'FREEGOOD')=0)
371: AND a.RELATIONSHIP_TYPE_CODE = qp_preq_grp.G_GENERATED_LINE

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

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

Line 431: INSERT INTO qp_npreq_rltd_lines_tmp

427: qp_preq_grp.engine_debug('Linegroup Related Line Detail Index: ' || j.related_line_detail_index);
428: END IF;
429: l_rltd_line_detail_index := j.related_line_detail_index;
430:
431: INSERT INTO qp_npreq_rltd_lines_tmp
432: (REQUEST_TYPE_CODE
433: ,LINE_DETAIL_INDEX
434: ,RELATIONSHIP_TYPE_CODE
435: ,RELATED_LINE_DETAIL_INDEX

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

608: qp_preq_grp.engine_debug('New Line Created');
609: END IF;
610:
611: -- Ravi remove line to line relationship ie comment out the insert below
612: /* INSERT INTO qp_npreq_rltd_lines_tmp(REQUEST_TYPE_CODE, LINE_INDEX,RELATIONSHIP_TYPE_CODE,
613: RELATED_LINE_INDEX, PRICING_STATUS_CODE) VALUES
614: (v_request_type_code,p_line_index,qp_preq_grp.G_GENERATED_LINE,v_line_index,
615: qp_preq_grp.G_STATUS_NEW);
616: IF l_debug = FND_API.G_TRUE THEN

Line 711: INSERT INTO qp_npreq_rltd_lines_tmp

707: IF l_debug = FND_API.G_TRUE THEN
708: qp_preq_grp.engine_debug('New Adjustment Line Created');
709: END IF;
710:
711: INSERT INTO qp_npreq_rltd_lines_tmp
712: (REQUEST_TYPE_CODE,
713: LINE_DETAIL_INDEX,
714: RELATIONSHIP_TYPE_CODE,
715: RELATED_LINE_DETAIL_INDEX,

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

714: RELATIONSHIP_TYPE_CODE,
715: RELATED_LINE_DETAIL_INDEX,
716: PRICING_STATUS_CODE,
717: LIST_LINE_ID,
718: -- begin shu,side fix bug 2491158,missing data in qp_npreq_rltd_lines_tmp
719: line_index,
720: related_line_index,
721: related_list_line_id,
722: related_list_line_type,

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

722: related_list_line_type,
723: operand_calculation_code,
724: operand,
725: qualifier_value
726: -- end shu, side fix bug 2491158, missing data in qp_npreq_rltd_lines_tmp
727: )
728: VALUES
729: (v_request_type_code,
730: j.LINE_DETAIL_INDEX,

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

731: qp_preq_grp.G_GENERATED_LINE,
732: v_detail_line_index,
733: qp_preq_grp.G_STATUS_NEW,
734: p_list_line_id,
735: -- begin shu,side fix bug 2491158,missing data in qp_npreq_rltd_lines_tmp
736: p_line_index,
737: v_line_index,
738: i.LIST_LINE_ID,
739: i.LIST_LINE_TYPE_CODE,

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

739: i.LIST_LINE_TYPE_CODE,
740: i.ARITHMETIC_OPERATOR,
741: i.OPERAND,
742: x_total_benefit_qty
743: -- end shu, side fix bug 2491158, missing data in qp_npreq_rltd_lines_tmp
744: );
745:
746: IF l_debug = FND_API.G_TRUE THEN
747: qp_preq_grp.engine_debug('New Related Line Detail-Line Detail Created');

Line 828: -- Insert a line into qp_npreq_rltd_lines_tmp

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

Line 831: -- Insert a line into qp_npreq_rltd_lines_tmp

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:
834:
835: CURSOR get_related_modifier_id_cur IS

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

1028: i.MODIFIER_LEVEL_CODE);
1029:
1030: -- shu, begin fix bug 2491158
1031: IF l_debug = FND_API.G_TRUE THEN
1032: qp_preq_grp.engine_debug ('debug data going to qp_npreq_rltd_lines_tmp .........');
1033: qp_preq_grp.engine_debug ('OID line_index: '||p_line_index);
1034: qp_preq_grp.engine_debug ('OID list_line_id: '||p_list_line_id);
1035: qp_preq_grp.engine_debug ('Benifit line_index: '||m.line_index);
1036: qp_preq_grp.engine_debug ('Benifit list_line_id: '||i.list_line_id);

Line 1043: INSERT INTO qp_npreq_rltd_lines_tmp

1039: qp_preq_grp.engine_debug ('Benifit ARITHMETIC_OPERATOR: '||i.ARITHMETIC_OPERATOR);
1040: qp_preq_grp.engine_debug ('Benifit LINE_QUANTITY: '||m.LINE_QUANTITY);
1041: END IF;
1042:
1043: INSERT INTO qp_npreq_rltd_lines_tmp
1044: (REQUEST_TYPE_CODE,
1045: LINE_DETAIL_INDEX,
1046: RELATIONSHIP_TYPE_CODE,
1047: RELATED_LINE_DETAIL_INDEX,

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

1045: LINE_DETAIL_INDEX,
1046: RELATIONSHIP_TYPE_CODE,
1047: RELATED_LINE_DETAIL_INDEX,
1048: PRICING_STATUS_CODE,
1049: line_index, -- begin shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1050: related_line_index,
1051: list_line_id,
1052: related_list_line_id,
1053: related_list_line_type,

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

1052: related_list_line_id,
1053: related_list_line_type,
1054: operand_calculation_code,
1055: operand,
1056: qualifier_value -- end shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1057: )
1058: VALUES
1059: (v_request_type_code,
1060: j.LINE_DETAIL_INDEX,

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

1060: j.LINE_DETAIL_INDEX,
1061: qp_preq_grp.G_GENERATED_LINE,
1062: v_detail_line_index,
1063: qp_preq_grp.G_STATUS_NEW,
1064: p_line_index, -- begin shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1065: m.line_index,
1066: p_list_line_id,
1067: i.list_line_id,
1068: i.list_line_type_code,

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

1067: i.list_line_id,
1068: i.list_line_type_code,
1069: i.arithmetic_operator,
1070: i.operand,
1071: m.line_quantity -- end shu, fix 2491158, missing data in qp_npreq_rltd_lines_tmp
1072: );
1073: -- shu, end fix bug 2491158
1074: END LOOP;
1075: