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.GML_PO_RECV2_PKG dependencies on PO_LINES_ALL

Line 83: FROM po_lines_all

79: v_last_update_date IN DATE )
80: IS
81: CURSOR line_cur IS
82: SELECT closed_code
83: FROM po_lines_all
84: WHERE po_header_id = v_po_header_id
85: AND org_id = v_org_id;
86:
87: CURSOR po_cur IS

Line 93: v_closed_code po_lines_all.closed_code%TYPE;

89: FROM po_headers_all
90: WHERE po_header_id = v_po_header_id
91: AND org_id = v_org_id;
92:
93: v_closed_code po_lines_all.closed_code%TYPE;
94: v_new_status po_headers_all.closed_code%TYPE;
95: v_old_status po_headers_all.closed_code%TYPE;
96: v_all_lines_closed BOOLEAN :=TRUE;
97:

Line 109: /* closed_code can be OPEN, CLOSED or NULL in po_lines_all */

105:
106: WHILE line_cur%FOUND
107: LOOP
108:
109: /* closed_code can be OPEN, CLOSED or NULL in po_lines_all */
110:
111: IF v_closed_code IS NULL OR v_closed_code = 'OPEN' THEN
112: v_all_lines_closed :=FALSE;
113: END IF;

Line 181: FROM po_lines_all

177: AND org_id = v_org_id;
178:
179: CURSOR line_cur IS
180: SELECT closed_code
181: FROM po_lines_all
182: WHERE po_header_id = v_po_header_id
183: AND po_line_id = v_po_line_id
184: AND org_id = v_org_id;
185:

Line 187: v_new_status po_lines_all.closed_code%TYPE;

183: AND po_line_id = v_po_line_id
184: AND org_id = v_org_id;
185:
186: v_closed_code po_line_locations_all.closed_code%TYPE;
187: v_new_status po_lines_all.closed_code%TYPE;
188: v_old_status po_lines_all.closed_code%TYPE;
189: v_all_locations_closed BOOLEAN :=TRUE;
190:
191: err_num NUMBER;

Line 188: v_old_status po_lines_all.closed_code%TYPE;

184: AND org_id = v_org_id;
185:
186: v_closed_code po_line_locations_all.closed_code%TYPE;
187: v_new_status po_lines_all.closed_code%TYPE;
188: v_old_status po_lines_all.closed_code%TYPE;
189: v_all_locations_closed BOOLEAN :=TRUE;
190:
191: err_num NUMBER;
192: err_msg VARCHAR2(100);

Line 219: UPDATE po_lines_all

215: FETCH line_cur INTO v_old_status;
216: CLOSE line_cur;
217:
218: IF v_old_status IS NULL OR v_new_status <> v_old_status THEN
219: UPDATE po_lines_all
220: SET closed_code = v_new_status,
221: last_update_date= v_last_update_date,
222: last_updated_by = v_last_updated_by
223: WHERE po_header_id = v_po_header_id AND

Line 280: v_new_status po_lines_all.closed_code%TYPE;

276: AND po_release_id = v_po_release_id
277: AND org_id = v_org_id;
278:
279: v_closed_code po_line_locations_all.closed_code%TYPE;
280: v_new_status po_lines_all.closed_code%TYPE;
281: v_old_status po_lines_all.closed_code%TYPE;
282: v_all_locations_closed BOOLEAN :=TRUE;
283:
284: err_num NUMBER;

Line 281: v_old_status po_lines_all.closed_code%TYPE;

277: AND org_id = v_org_id;
278:
279: v_closed_code po_line_locations_all.closed_code%TYPE;
280: v_new_status po_lines_all.closed_code%TYPE;
281: v_old_status po_lines_all.closed_code%TYPE;
282: v_all_locations_closed BOOLEAN :=TRUE;
283:
284: err_num NUMBER;
285: err_msg VARCHAR2(100);

Line 390: FROM po_lines_all

386: WHERE po_header_id = v_po_header_id;
387:
388: CURSOR line_cur IS
389: SELECT line_num
390: FROM po_lines_all
391: WHERE po_line_id = v_po_line_id;
392:
393: CURSOR shipment_cur IS
394: SELECT shipment_num