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 399: FROM qp_pricing_phases a , qp_event_phases b

395: p_request_type_code IN VARCHAR2 DEFAULT NULL) IS
396:
397: CURSOR l_all_lines_info_cur(p_event_code1 VARCHAR2) IS
398: SELECT 'X'
399: FROM qp_pricing_phases a , qp_event_phases b
400: WHERE a.pricing_phase_id = b.pricing_phase_id
401: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y')
402: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
403: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

Line 427: FROM qp_pricing_phases a , qp_event_phases b

423: * the l_all_lines_info_cur_freight cursor has been modified to reflect this
424: */
425: CURSOR l_all_lines_info_cur_freight(p_event_code1 VARCHAR2) IS
426: SELECT 'X'
427: FROM qp_pricing_phases a , qp_event_phases b
428: WHERE a.pricing_phase_id = b.pricing_phase_id
429: AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y')
430: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM
431: ,1 ,SUBSTR(p_event_code,1,INSTR(p_event_code1,',',1,1)-1)

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

511: AND pricing_phase_id = 1;
512:
513:
514: l_pricing_phase_id NUMBER;
515: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
516: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
517: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;

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

512:
513:
514: l_pricing_phase_id NUMBER;
515: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
516: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
517: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
520: l_dummy VARCHAR2(1);

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

513:
514: l_pricing_phase_id NUMBER;
515: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
516: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
517: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
520: l_dummy VARCHAR2(1);
521: BEGIN

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

607: /***********************************************************************
608: Change done for bug 7241731/7596981.
609: Procedure to Determine how many lines to pass to the pricing engine
610: during a manual modifier call. Currently there is no column in
611: qp_pricing_phases that will indicate exclusive presence of a manual
612: linegroup modifier for particular phases.
613: Due to which a query on qp_list_lines was used earlier in
614: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
615: causing performance issue for some customers.

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

612: linegroup modifier for particular phases.
613: Due to which a query on qp_list_lines was used earlier in
614: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
615: causing performance issue for some customers.
616: Final fix will be to add such a column in qp_pricing_phases table.
617: Meanwhile, this procedure is written to use manual_modifier_flag and
618: line_group_exists from qp_pricing_phases to determine the manual Linegroup
619: status which will take care of most of the customer set-up cases.
620: Once the change is made to add a column to the qp_pricing_table this

Line 618: line_group_exists from qp_pricing_phases to determine the manual Linegroup

614: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
615: causing performance issue for some customers.
616: Final fix will be to add such a column in qp_pricing_phases table.
617: Meanwhile, this procedure is written to use manual_modifier_flag and
618: line_group_exists from qp_pricing_phases to determine the manual Linegroup
619: status which will take care of most of the customer set-up cases.
620: Once the change is made to add a column to the qp_pricing_table this
621: procedure will be changed to look at that column value.
622: ***********************************************************************/

Line 630: FROM qp_pricing_phases a , qp_event_phases b

626: x_manual_all_lines_status OUT NOCOPY VARCHAR2) IS
627:
628: CURSOR l_manual_all_lines_info_cur(p_event_code1 VARCHAR2) IS
629: SELECT 'Y'
630: FROM qp_pricing_phases a , qp_event_phases b
631: WHERE a.pricing_phase_id = b.pricing_phase_id
632: AND a.line_group_exists = 'Y' -- no need to consider PRG/OID for manual mod call
633: AND a.manual_modifier_flag in ('M','B') -- phases tagged to have manual modifiers
634: AND b.pricing_event_code IN (SELECT DECODE(ROWNUM