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.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_PRICE_ADJUSTMENTS_V

Line 106: ,p_adj_rec IN PO_PRICE_ADJUSTMENTS_V%ROWTYPE);

102: (p_adj_rec IN PO_PRICE_ADJUSTMENTS%ROWTYPE);
103:
104: PROCEDURE insert_draft_adj_rec
105: (p_draft_id IN NUMBER
106: ,p_adj_rec IN PO_PRICE_ADJUSTMENTS_V%ROWTYPE);
107:
108: --------------------------------------------------------------------------------
109: -- Procedure definitions
110: --------------------------------------------------------------------------------

Line 155: FROM PO_PRICE_ADJUSTMENTS_V ADJV

151: BEGIN
152: --Check if manual modifiers are applied
153: SELECT COUNT(1)
154: INTO l_man_mod_count
155: FROM PO_PRICE_ADJUSTMENTS_V ADJV
156: WHERE ADJV.po_header_id = p_po_header_id
157: AND ADJV.po_line_id = p_po_line_id
158: AND ADJV.automatic_flag = 'N'
159: --AND ADJ.update_allowed = 'N'

Line 165: FROM PO_PRICE_ADJUSTMENTS_V ADJV

161:
162: --Check if manual overridden modifiers are applied
163: SELECT COUNT(1)
164: INTO l_man_ovr_mod_count
165: FROM PO_PRICE_ADJUSTMENTS_V ADJV
166: WHERE ADJV.po_header_id = p_po_header_id
167: AND ADJV.po_line_id = p_po_line_id
168: AND ADJV.automatic_flag = 'N'
169: AND ADJV.update_allowed = 'Y'

Line 175: FROM PO_PRICE_ADJUSTMENTS_V ADJV

171:
172: --Check if automatic modifiers are applied
173: SELECT COUNT(1)
174: INTO l_auto_mod_count
175: FROM PO_PRICE_ADJUSTMENTS_V ADJV
176: WHERE ADJV.po_header_id = p_po_header_id
177: AND ADJV.po_line_id = p_po_line_id
178: AND ADJV.automatic_flag = 'Y'
179: --AND ADJ.update_allowed = 'N'

Line 185: FROM PO_PRICE_ADJUSTMENTS_V ADJV

181:
182: --Check if automatic overridden modifiers are applied
183: SELECT COUNT(1)
184: INTO l_auto_ovr_mod_count
185: FROM PO_PRICE_ADJUSTMENTS_V ADJV
186: WHERE ADJV.po_header_id = p_po_header_id
187: AND ADJV.po_line_id = p_po_line_id
188: AND ADJV.automatic_flag = 'Y'
189: AND ADJV.update_allowed = 'Y'

Line 575: FROM PO_PRICE_ADJUSTMENTS_V ADJV

571: --E_INVALID_PARAMS EXCEPTION;
572:
573: CURSOR man_ovr_min_adj_cur(p_order_line_id PO_LINES_ALL.po_line_id%TYPE) IS
574: SELECT MIN(ADJV.price_adjustment_id) "MIN_PRICE_ADJ_ID"
575: FROM PO_PRICE_ADJUSTMENTS_V ADJV
576: WHERE ADJV.po_header_id = p_order_header_id --ADJV.draft_id = p_draft_id --sometimes draft_id may be passed as null
577: AND ADJV.po_line_id = p_order_line_id
578: AND NVL(ADJV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
579: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual

Line 615: FROM PO_PRICE_ADJUSTMENTS_V ADJV

611: ,ADJV.price_adjustment_id "PRICE_ADJUSTMENT_ID" --Child price adjustment id
612: ,ADJV.parent_adjustment_id "RLTD_PRICE_ADJUSTMENT_ID" --Parent price adjustment id
613: ,ADJV.parent_list_line_type_code "RELATIONSHIP_TYPE_CODE" --Parent Child relationship type code
614: ,ADJV.parent_list_line_id "RLTD_LIST_LINE_ID" --Parent List Line Id
615: FROM PO_PRICE_ADJUSTMENTS_V ADJV
616: WHERE ADJV.po_header_id = p_order_header_id --ADJV.draft_id = p_draft_id --sometimes draft_id may be passed as null
617: AND ADJV.po_line_id = p_order_line_id
618: AND NVL(ADJV.applied_flag,'Y') = 'Y' --To avoid applying manual modifiers selected and cancelled by the user
619: AND (ADJV.automatic_flag = QP_PREQ_GRP.G_NO -- If modifier is not automatic. i.e., manual

Line 2838: l_po_price_adjustment_record PO_PRICE_ADJUSTMENTS_V%ROWTYPE;

2834: l_progress VARCHAR2(4) := '000';
2835: l_return_status_text VARCHAR2(2000);
2836: COPYDOC_ADJUSTMENT_FAILURE EXCEPTION;
2837:
2838: l_po_price_adjustment_record PO_PRICE_ADJUSTMENTS_V%ROWTYPE;
2839: l_src_price_adjustment_id PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE;
2840:
2841: l_src_adj_count NUMBER;
2842: --l_src_asoc_count NUMBER;

Line 2866: FROM PO_PRICE_ADJUSTMENTS_V ADJV

2862: ,p_auto_manual_flag VARCHAR2
2863: ,p_override_allowed_flag VARCHAR2
2864: ,p_overridden_flag VARCHAR2) IS
2865: SELECT ADJV.*
2866: FROM PO_PRICE_ADJUSTMENTS_V ADJV
2867: WHERE ADJV.po_line_id = p_src_line_id --ADJV.draft_id = p_draft_id --the draft id may not have been initialized when copy event was triggered
2868: AND (p_auto_manual_flag IS NULL OR ADJV.automatic_flag = p_auto_manual_flag)
2869: AND (p_override_allowed_flag IS NULL OR ADJV.update_allowed = p_override_allowed_flag)
2870: AND (p_overridden_flag IS NULL OR ADJV.updated_flag = p_overridden_flag);

Line 2945: FROM PO_PRICE_ADJUSTMENTS_V ADJV

2941:
2942: --Check if adjsutments already exist for the destination line id
2943: SELECT COUNT(1)
2944: INTO l_adjustments_exist
2945: FROM PO_PRICE_ADJUSTMENTS_V ADJV
2946: WHERE ADJV.draft_id = p_draft_id
2947: AND ADJV.po_line_id = p_dest_po_line_id
2948: AND (l_auto_manual_flag IS NULL OR ADJV.automatic_flag = l_auto_manual_flag)
2949: AND (l_override_allowed_flag IS NULL OR ADJV.update_allowed = l_override_allowed_flag)

Line 2967: FROM PO_PRICE_ADJUSTMENTS_V ADJV

2963: END IF;
2964:
2965: SELECT COUNT(1)
2966: INTO l_src_adj_count
2967: FROM PO_PRICE_ADJUSTMENTS_V ADJV
2968: WHERE ADJV.po_line_id = p_src_po_line_id --ADJV.draft_id = p_draft_id --the draft id may not have been initialized when copy event was triggered
2969: AND (l_auto_manual_flag IS NULL OR ADJV.automatic_flag = l_auto_manual_flag)
2970: AND (l_override_allowed_flag IS NULL OR ADJV.update_allowed = l_override_allowed_flag)
2971: AND (l_overridden_flag IS NULL OR ADJV.updated_flag = l_overridden_flag);

Line 3433: ,p_adj_rec IN PO_PRICE_ADJUSTMENTS_V%ROWTYPE)

3429: --Exception will be caught by the calling procedure
3430: END insert_adj_rec;
3431:
3432: PROCEDURE insert_draft_adj_rec(p_draft_id IN NUMBER
3433: ,p_adj_rec IN PO_PRICE_ADJUSTMENTS_V%ROWTYPE)
3434: IS
3435: BEGIN
3436: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
3437: (DRAFT_ID