APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINES

Line 118: l_line_closed po_lines.closed_code%TYPE;

114: l_head_closed po_releases.closed_code%TYPE;
115:
116: l_user_hold_flag po_releases.hold_flag%TYPE;
117: l_ship_closed po_line_locations.closed_code%TYPE;
118: l_line_closed po_lines.closed_code%TYPE;
119: l_closed_code VARCHAR2(26);
120: l_frozen_flag po_releases.frozen_flag%TYPE;
121:
122: l_state_found BOOLEAN;

Line 177: FROM po_lines pol

173: AND poll.draft_id = draftId;
174:
175: CURSOR line_closed(lineid NUMBER) is
176: SELECT nvl(pol.closed_code, 'OPEN')
177: FROM po_lines pol
178: WHERE pol.po_line_id = lineid;
179:
180: -- CLM Apprvl
181: CURSOR line_closed_mod(lineid NUMBER, draftId NUMBER) is

Line 183: FROM po_lines_merge_v pol

179:
180: -- CLM Apprvl
181: CURSOR line_closed_mod(lineid NUMBER, draftId NUMBER) is
182: SELECT nvl(pol.closed_code, 'OPEN')
183: FROM po_lines_merge_v pol
184: WHERE pol.po_line_id = lineid
185: AND pol.draft_id = draftId;
186:
187:

Line 2045: -- Stamping conforming details for PO_LINES_UCAs

2041: END;
2042:
2043: IF (l_is_clm_document = 'Y') THEN
2044: --UCA Project - CLM R4 Changes Begin
2045: -- Stamping conforming details for PO_LINES_UCAs
2046: UPDATE po_line_ucas
2047: SET undef_approved_date =
2048: Decode (p_draft_id,
2049: undef_draft_id, nvl(undef_approved_date, SYSDATE),

Line 2617: FROM po_lines_merge_v

2613:
2614: -- Changed the above line to handle the CPA case also
2615: SELECT po_header_id, from_line_id, nvl(from_header_id, contract_id), amount, quantity, matching_basis
2616: INTO l_po_header_id, l_idv_line_id, l_idv_header_id, l_line_amount, l_line_quantity, l_line_type
2617: FROM po_lines_merge_v
2618: WHERE po_line_id = p_po_line_id
2619: AND draft_id = p_draft_id;
2620:
2621: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/

Line 2642: FROM po_lines_all

2638:
2639: -- Changed the above line to handle the BPA case only
2640: IF ( l_idv_line_id IS NOT NULL) THEN
2641: SELECT clm_total_amount_ordered, clm_total_quantity_ordered INTO l_amt_ordered_idv_line, l_qty_ordered_idv_line
2642: FROM po_lines_all
2643: WHERE po_line_id = l_idv_line_id;
2644: END IF;
2645:
2646: d_progress := 10;

Line 2686: FROM po_lines_draft_all

2682: ELSE -- Mod
2683: d_progress := 40;
2684: BEGIN
2685: SELECT quantity, amount INTO l_mod_quantity, l_mod_amount
2686: FROM po_lines_draft_all
2687: WHERE po_line_id = p_po_line_id
2688: AND draft_id = p_draft_id;
2689:
2690: /*get Amount FROM po_document_totals_pvt.getAmountOrdered and not from line*/

Line 2778: UPDATE po_lines_all SET clm_total_amount_ordered = l_amt_ordered_idv_line, clm_total_quantity_ordered = l_qty_ordered_idv_line

2774:
2775: d_progress := 80;
2776: -- Changed the above line to handle the BPA case only
2777: IF l_idv_line_id IS NOT NULL THEN
2778: UPDATE po_lines_all SET clm_total_amount_ordered = l_amt_ordered_idv_line, clm_total_quantity_ordered = l_qty_ordered_idv_line
2779: WHERE po_line_id = l_idv_line_id;
2780: END IF;
2781:
2782: END IF; -- l_idv_header_id is not null

Line 2835: SELECT po_line_id FROM po_lines_merge_v

2831: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
2832: d_progress NUMBER := 0;
2833:
2834: CURSOR c_get_po_line_dtls(p_po_header_id NUMBER) IS
2835: SELECT po_line_id FROM po_lines_merge_v
2836: WHERE po_header_id = p_po_header_id
2837: AND draft_id = p_draft_id
2838: AND (from_header_id IS NOT NULL or contract_id is not null);
2839: --AND from_line_id IS NOT null;