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_UTIL_PUB dependencies on QP_PRICING_PHASES

Line 465: FROM qp_pricing_phases a , qp_event_phases b

461: p_request_type_code IN VARCHAR2 DEFAULT NULL) IS
462:
463: CURSOR l_all_lines_info_cur(p_event_code1 VARCHAR2) IS
464: SELECT 'X'
465: FROM qp_pricing_phases a , qp_event_phases b
466: WHERE a.pricing_phase_id = b.pricing_phase_id
467: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y')
468: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
469: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 493: FROM qp_pricing_phases a , qp_event_phases b

489: * the l_all_lines_info_cur_freight cursor has been modified to reflect this
490: */
491: CURSOR l_all_lines_info_cur_freight(p_event_code1 VARCHAR2) IS
492: SELECT 'X'
493: FROM qp_pricing_phases a , qp_event_phases b
494: WHERE a.pricing_phase_id = b.pricing_phase_id
495: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y')
496: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
497: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 583: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';

579: AND pricing_phase_id = 1;
580:
581:
582: l_pricing_phase_id NUMBER;
583: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
584: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
585: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
586: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;

Line 584: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';

580:
581:
582: l_pricing_phase_id NUMBER;
583: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
584: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
585: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
586: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
588: l_dummy VARCHAR2(1);

Line 585: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';

581:
582: l_pricing_phase_id NUMBER;
583: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
584: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
585: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
586: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
588: l_dummy VARCHAR2(1);
589: BEGIN

Line 683: FROM qp_pricing_phases a , qp_event_phases b

679: p_freight_call_flag IN VARCHAR2 := 'N',
680: p_request_type_code IN VARCHAR2 DEFAULT NULL) is
681: CURSOR l_all_lines_info_cur(p_event_code1 VARCHAR2) IS
682: SELECT 'X'
683: FROM qp_pricing_phases a , qp_event_phases b
684: WHERE a.pricing_phase_id = b.pricing_phase_id
685: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y')
686: AND b.pricing_event_code in (SELECT decode(rownum
687: ,1 ,substr(p_event_code,1,instr(p_event_code1,',',1,1)-1)

Line 711: FROM qp_pricing_phases a , qp_event_phases b

707: * the l_all_lines_info_cur_freight cursor has been modified to reflect this
708: */
709: CURSOR l_all_lines_info_cur_freight(p_event_code1 VARCHAR2) IS
710: SELECT 'X'
711: FROM qp_pricing_phases a , qp_event_phases b
712: WHERE a.pricing_phase_id = b.pricing_phase_id
713: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y')
714: AND b.pricing_event_code in (SELECT decode(rownum
715: ,1 ,substr(p_event_code,1,instr(p_event_code1,',',1,1)-1)

Line 827: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';

823: AND pricing_phase_id = 1;
824:
825:
826: l_pricing_phase_id NUMBER;
827: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
828: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
829: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
830: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
831: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

Line 828: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';

824:
825:
826: l_pricing_phase_id NUMBER;
827: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
828: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
829: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
830: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
831: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
832: l_dummy VARCHAR2(1);

Line 829: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';

825:
826: l_pricing_phase_id NUMBER;
827: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
828: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
829: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
830: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
831: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
832: l_dummy VARCHAR2(1);
833: x_pass_all_lines varchar2(1):='Y'; -- 9251187

Line 936: qp_pricing_phases that will indicate exclusive presence of a manual

932: /***********************************************************************
933: Change done for bug 7241731/7596981.
934: Procedure to Determine how many lines to pass to the pricing engine
935: during a manual modifier call. Currently there is no column in
936: qp_pricing_phases that will indicate exclusive presence of a manual
937: linegroup modifier for particular phases.
938: Due to which a query on qp_list_lines was used earlier in
939: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
940: causing performance issue for some customers.

Line 941: Final fix will be to add such a column in qp_pricing_phases table.

937: linegroup modifier for particular phases.
938: Due to which a query on qp_list_lines was used earlier in
939: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
940: causing performance issue for some customers.
941: Final fix will be to add such a column in qp_pricing_phases table.
942: Meanwhile, this procedure is written to use manual_modifier_flag and
943: line_group_exists from qp_pricing_phases to determine the manual Linegroup
944: status which will take care of most of the customer set-up cases.
945: Once the change is made to add a column to the qp_pricing_table this

Line 943: line_group_exists from qp_pricing_phases to determine the manual Linegroup

939: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
940: causing performance issue for some customers.
941: Final fix will be to add such a column in qp_pricing_phases table.
942: Meanwhile, this procedure is written to use manual_modifier_flag and
943: line_group_exists from qp_pricing_phases to determine the manual Linegroup
944: status which will take care of most of the customer set-up cases.
945: Once the change is made to add a column to the qp_pricing_table this
946: procedure will be changed to look at that column value.
947: ***********************************************************************/

Line 955: FROM qp_pricing_phases a , qp_event_phases b

951: x_manual_all_lines_status OUT NOCOPY VARCHAR2) IS
952:
953: CURSOR l_manual_all_lines_info_cur(p_event_code1 VARCHAR2) IS
954: SELECT 'Y'
955: FROM qp_pricing_phases a , qp_event_phases b
956: WHERE a.pricing_phase_id = b.pricing_phase_id
957: AND a.line_group_exists = 'Y' -- no need to consider PRG/OID for manual mod call
958: AND a.manual_modifier_flag in ('M','B') -- phases tagged to have manual modifiers
959: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM