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_REQ_LINES_SV dependencies on PO_REQUISITION_LINES

Line 20: FROM po_requisition_lines

16: PROCEDURE lock_row_for_buyer_update (x_rowid IN VARCHAR2)
17: IS
18: CURSOR C IS
19: SELECT *
20: FROM po_requisition_lines
21: WHERE rowid = x_rowid
22: FOR UPDATE of requisition_line_id NOWAIT;
23: Recinfo C%ROWTYPE;
24:

Line 68: FROM po_requisition_lines

64: x_progress := '010';
65:
66: SELECT rowid
67: INTO x_rowid
68: FROM po_requisition_lines
69: WHERE requisition_line_id = x_line_id;
70:
71: -- dbms_output.put_line('After selecting rowid');
72:

Line 93: po_requisition_lines_pkg1.delete_row(x_rowid, x_transferred_to_oe_flag);

89: */
90:
91: x_progress := '030';
92:
93: po_requisition_lines_pkg1.delete_row(x_rowid, x_transferred_to_oe_flag);
94:
95: -- dbms_output.put_line('After call to delete line');
96:
97: EXCEPTION

Line 170: FROM PO_REQUISITION_LINES PORL,

166:
167: X_progress := '010';
168: SELECT COUNT(1)
169: INTO X_row_exists
170: FROM PO_REQUISITION_LINES PORL,
171: PO_LINE_LOCATIONS_ALL POLL -- Bug 8659519
172: WHERE PORL.requisition_header_id = X_req_header_id
173: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
174: AND PORL.line_location_id = POLL.line_location_id

Line 217: From po_requisition_lines

213: p_req_line_id NUMBER;
214:
215: Cursor get_req_lines_cur is
216: Select requisition_line_id
217: From po_requisition_lines
218: Where requisition_line_id = nvl(X_req_line_id, requisition_line_id)
219: And requisition_header_id = X_req_header_id
220: and nvl(cancel_flag,'N')<>'Y' --Added for bug 13036681
221: And source_type_code = 'INVENTORY';

Line 243: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,

239: --Toju George 08/31/2000
240: --Modified the call to procedure to replace req_num and line_num with ids.
241: /* SELECT COUNT(1)
242: INTO X_row_exists
243: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
244: PO_SYSTEM_PARAMETERS POSP
245: WHERE PORH.requisition_header_id = X_req_header_id
246: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
247: AND PORH.requisition_header_id = PORL.requisition_header_id

Line 255: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,

251: PORL.line_num ) > 0 ;
252: */
253: SELECT COUNT(1)
254: INTO X_row_exists
255: FROM PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL,
256: PO_SYSTEM_PARAMETERS POSP
257: WHERE PORH.requisition_header_id = X_req_header_id
258: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
259: AND PORH.requisition_header_id = PORL.requisition_header_id

Line 327: to compare with quantity_deliverd in po_requisition_lines.

323: ** 1. all document lines - if header_id is passed or,
324: ** 2. one document line - if both header_id and line_id are passed.
325: */
326: /* Bug# 5414478, We were using RCV_SHIPMENT_LINES quantity_received
327: to compare with quantity_deliverd in po_requisition_lines.
328: But in certain cases the Req. line and rcv_shipment_line are
329: in different UOM and were not doing the quantity conversion while
330: comparing quantity. Since we store the quantity_received in
331: po_requisition_lines and it is in the same UOM as quantity_received

Line 331: po_requisition_lines and it is in the same UOM as quantity_received

327: to compare with quantity_deliverd in po_requisition_lines.
328: But in certain cases the Req. line and rcv_shipment_line are
329: in different UOM and were not doing the quantity conversion while
330: comparing quantity. Since we store the quantity_received in
331: po_requisition_lines and it is in the same UOM as quantity_received
332: we are going on quantity_received of po_requisition_lines
333: to do the comparision. */
334: X_progress := '010';
335: SELECT COUNT(1)

Line 332: we are going on quantity_received of po_requisition_lines

328: But in certain cases the Req. line and rcv_shipment_line are
329: in different UOM and were not doing the quantity conversion while
330: comparing quantity. Since we store the quantity_received in
331: po_requisition_lines and it is in the same UOM as quantity_received
332: we are going on quantity_received of po_requisition_lines
333: to do the comparision. */
334: X_progress := '010';
335: SELECT COUNT(1)
336: INTO X_row_exists

Line 337: FROM PO_REQUISITION_LINES PORL

333: to do the comparision. */
334: X_progress := '010';
335: SELECT COUNT(1)
336: INTO X_row_exists
337: FROM PO_REQUISITION_LINES PORL
338: WHERE PORL.requisition_header_id = X_req_header_id
339: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id)
340: AND PORL.source_type_code = 'INVENTORY'
341: AND nvl(PORL.cancel_flag, 'N') = 'N'

Line 385: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;

381: X_req_control_error_rc IN OUT NOCOPY VARCHAR2,
382: X_oe_installed_flag IN VARCHAR2) IS
383:
384: X_progress VARCHAR2(3) := NULL;
385: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
386: X_order_source_id po_system_parameters.order_source_id%TYPE;
387:
388: BEGIN
389:

Line 432: UPDATE PO_REQUISITION_LINES

428: ** 1. all document lines - if header_id is passed or,
429: ** 2. one document line - if both header_id and line_id are passed.
430: */
431: X_progress := '010';
432: UPDATE PO_REQUISITION_LINES
433: SET cancel_flag = 'I',
434: quantity_cancelled = NVL(X_quantity_cancelled, quantity_cancelled),
435: reqs_in_pool_flag = NULL, --
436: last_update_login = fnd_global.login_id,

Line 480: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;

476: X_oe_installed_flag IN VARCHAR2,
477: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
478:
479: X_progress VARCHAR2(3) := NULL;
480: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;

Line 481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;

477: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
478:
479: X_progress VARCHAR2(3) := NULL;
480: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;

Line 482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;

478:
479: X_progress VARCHAR2(3) := NULL;
480: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;

Line 483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;

479: X_progress VARCHAR2(3) := NULL;
480: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --

Line 484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;

480: X_cancel_flag PO_REQUISITION_LINES.cancel_flag%TYPE := NULL;
481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;

Line 485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;

481: X_cancel_date PO_REQUISITION_LINES.cancel_date%TYPE := NULL;
482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;

Line 486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;

482: X_cancel_reason PO_REQUISITION_LINES.cancel_reason%TYPE := NULL;
483: X_closed_code PO_REQUISITION_LINES.closed_code%TYPE := NULL;
484: X_closed_reason PO_REQUISITION_LINES.closed_reason%TYPE := NULL;
485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;

Line 489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;

485: X_closed_date PO_REQUISITION_LINES.closed_date%TYPE := NULL;
486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;

Line 490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;

486: X_quantity_cancelled PO_REQUISITION_LINES.quantity_cancelled%TYPE := NULL;
487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;

Line 491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;

487: X_terminal_performed NUMBER(1) := 0; --
488: X_order_source_id PO_SYSTEM_PARAMETERS.order_source_id%TYPE;
489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;

Line 493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;

489: x_last_update_login po_requisition_lines.last_update_login%TYPE := fnd_global.login_id;
490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;

Line 494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;

490: x_last_updated_by po_requisition_lines.last_updated_by%TYPE := fnd_global.user_id;
491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;

Line 495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;

491: x_last_update_date po_requisition_lines.last_update_date%TYPE := SYSDATE;
492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;

Line 496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;

492:
493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;

Line 497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;

493: TYPE requisition_line_id_tb IS TABLE OF po_requisition_lines.requisition_line_id%TYPE INDEX BY PLS_INTEGER;
494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;

Line 498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;

494: TYPE cancel_flag_tb IS TABLE OF po_requisition_lines.cancel_flag%TYPE INDEX BY PLS_INTEGER;
495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;

Line 499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;

495: TYPE cancel_date_tb IS TABLE OF po_requisition_lines.cancel_date%TYPE INDEX BY PLS_INTEGER;
496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;
503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;

Line 500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;

496: TYPE cancel_reason_tb IS TABLE OF po_requisition_lines.cancel_reason%TYPE INDEX BY PLS_INTEGER;
497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;
503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;
504: TYPE quantity_cancelled_tb IS TABLE OF po_requisition_lines.quantity_cancelled%TYPE INDEX BY PLS_INTEGER;

Line 501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;

497: TYPE closed_code_tb IS TABLE OF po_requisition_lines.closed_code%TYPE INDEX BY PLS_INTEGER;
498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;
503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;
504: TYPE quantity_cancelled_tb IS TABLE OF po_requisition_lines.quantity_cancelled%TYPE INDEX BY PLS_INTEGER;
505:

Line 502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;

498: TYPE closed_reason_tb IS TABLE OF po_requisition_lines.closed_reason%TYPE INDEX BY PLS_INTEGER;
499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;
503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;
504: TYPE quantity_cancelled_tb IS TABLE OF po_requisition_lines.quantity_cancelled%TYPE INDEX BY PLS_INTEGER;
505:
506: requisition_line_id_v requisition_line_id_tb;

Line 503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;

499: TYPE closed_date_tb IS TABLE OF po_requisition_lines.closed_date%TYPE INDEX BY PLS_INTEGER;
500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;
503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;
504: TYPE quantity_cancelled_tb IS TABLE OF po_requisition_lines.quantity_cancelled%TYPE INDEX BY PLS_INTEGER;
505:
506: requisition_line_id_v requisition_line_id_tb;
507: cancel_flag_v cancel_flag_tb;

Line 504: TYPE quantity_cancelled_tb IS TABLE OF po_requisition_lines.quantity_cancelled%TYPE INDEX BY PLS_INTEGER;

500: TYPE contractor_status_tb IS TABLE OF po_requisition_lines.contractor_status%TYPE INDEX BY PLS_INTEGER;
501: TYPE last_update_login_tb IS TABLE OF po_requisition_lines.last_update_login%TYPE INDEX BY PLS_INTEGER;
502: TYPE last_updated_by_tb IS TABLE OF po_requisition_lines.last_updated_by%TYPE INDEX BY PLS_INTEGER;
503: TYPE last_update_date_tb IS TABLE OF po_requisition_lines.last_update_date%TYPE INDEX BY PLS_INTEGER;
504: TYPE quantity_cancelled_tb IS TABLE OF po_requisition_lines.quantity_cancelled%TYPE INDEX BY PLS_INTEGER;
505:
506: requisition_line_id_v requisition_line_id_tb;
507: cancel_flag_v cancel_flag_tb;
508: cancel_date_v cancel_date_tb;

Line 543: FROM po_requisition_lines

539: Nvl(to_char(X_req_line_id), requisition_line_id)),quantity),
540: quantity - quantity_delivered), quantity_cancelled)
541:
542:
543: FROM po_requisition_lines
544: WHERE requisition_header_id = X_req_header_id
545: AND requisition_line_id = nvl(X_req_line_id, requisition_line_id)
546: AND nvl(cancel_flag, 'N') IN ('N', 'I')
547: AND nvl(closed_code, 'OPEN') <> 'FINALLY CLOSED';

Line 644: UPDATE po_requisition_lines SET

640: LIMIT 2500;
641: EXIT WHEN cancel_flag_v.Count = 0;
642:
643: FORALL indx IN requisition_line_id_v.First .. requisition_line_id_v.LAST
644: UPDATE po_requisition_lines SET
645: cancel_flag = cancel_flag_v(indx),
646: cancel_date = cancel_date_v(indx),
647: cancel_reason = cancel_reason_v(indx),
648: closed_code = closed_code_v(indx),

Line 668: FROM po_requisition_lines PORL

664: UPDATE PO_REQ_DISTRIBUTIONS
665: SET req_line_quantity = 0
666: WHERE requisition_line_id IN
667: (SELECT requisition_line_id
668: FROM po_requisition_lines PORL
669: WHERE PORL.requisition_header_id = X_req_header_id
670: AND nvl(PORL.cancel_flag,'N') = 'Y'
671: -- AND PORL.source_type_code = 'VENDOR' /* commenting this condition for bug 16240233 to update dist quantity for internal reqs also */
672: AND PORL.requisition_line_id = nvl(X_req_line_id, PORL.requisition_line_id));

Line 745: FROM po_line_locations s, po_requisition_lines rl

741: l_po_line_id,
742: l_line_location_id,
743: L_req_header_id,
744: l_req_line_id
745: FROM po_line_locations s, po_requisition_lines rl
746: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
747: AND s.po_header_id = X_entity_id;
748: --
749:

Line 750: UPDATE po_requisition_lines_all rl -- Bug 3592153

746: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
747: AND s.po_header_id = X_entity_id;
748: --
749:
750: UPDATE po_requisition_lines_all rl -- Bug 3592153
751: SET rl.line_location_id = NULL,
752: --reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
753: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
754: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 783: FROM po_line_locations s, po_requisition_lines rl

779: l_po_line_id,
780: l_line_location_id,
781: L_req_header_id,
782: l_req_line_id
783: FROM po_line_locations s, po_requisition_lines rl
784: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
785: AND s.po_release_id = X_entity_id;
786: --
787:

Line 788: UPDATE po_requisition_lines_all rl -- Bug 3592153

784: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
785: AND s.po_release_id = X_entity_id;
786: --
787:
788: UPDATE po_requisition_lines_all rl -- Bug 3592153
789: SET rl.line_location_id = NULL,
790: --reqs_in_pool_flag = 'Y', -- Bug 2781027
791: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
792: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 821: FROM po_line_locations s, po_requisition_lines rl

817: l_po_line_id,
818: l_line_location_id,
819: L_req_header_id,
820: l_req_line_id
821: FROM po_line_locations s, po_requisition_lines rl
822: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
823: AND s.po_line_id = X_entity_id;
824: --
825:

Line 826: UPDATE po_requisition_lines_all rl -- Bug 3592153

822: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
823: AND s.po_line_id = X_entity_id;
824: --
825:
826: UPDATE po_requisition_lines_all rl -- Bug 3592153
827: SET rl.line_location_id = NULL,
828: -- reqs_in_pool_flag = 'Y', -- Bug 2781027
829: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
830: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 865: FROM po_line_locations s, po_requisition_lines rl

861: l_po_line_id,
862: l_line_location_id,
863: L_req_header_id,
864: l_req_line_id
865: FROM po_line_locations s, po_requisition_lines rl
866: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
867: AND s.line_location_id = X_entity_id;
868: --
869:

Line 871: UPDATE po_requisition_lines_all rl -- Bug 3592153

867: AND s.line_location_id = X_entity_id;
868: --
869:
870:
871: UPDATE po_requisition_lines_all rl -- Bug 3592153
872: SET rl.line_location_id = NULL,
873: --reqs_in_pool_flag = 'Y', -- Bug 2781027
874: --Bug 9976204.Set the reqs_in_pool_flag back to Y only if the Req is APPROVED or PRE-APPROVED
875: rl.reqs_in_pool_flag = (SELECT Decode(rh.authorization_status,'APPROVED','Y','PRE-APPROVED','Y',rl.reqs_in_pool_flag)

Line 1159: FROM po_requisition_lines prl

1155: x_progress := '010';
1156:
1157: SELECT count(*)
1158: INTO x_inv_count
1159: FROM po_requisition_lines prl
1160: WHERE prl.requisition_header_id = x_req_hdr_id
1161: AND prl.source_type_code = 'INVENTORY';
1162:
1163: -- dbms_output.put_line ('x_inv_count: ' ||to_char(x_inv_count));

Line 1257: UPDATE po_requisition_lines_all prl

1253: -- be placed on a purchasing document; those that fail all
1254: -- the above criteria can.
1255: --
1256: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL
1257: UPDATE po_requisition_lines_all prl
1258: SET prl.reqs_in_pool_flag =
1259: CASE
1260: WHEN NVL(prl.cancel_flag,'N') = 'Y'
1261: OR NVL(prl.closed_code,'OPEN') = 'FINALLY CLOSED'

Line 1299: FROM PO_REQUISITION_LINES_ALL SUB

1295: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1296: WHERE
1297: PRL.Requisition_Line_ID in (
1298: SELECT SUB.Requisition_Line_ID
1299: FROM PO_REQUISITION_LINES_ALL SUB
1300: WHERE SUB.Requisition_Header_Id = x_req_header_id
1301: AND x_req_line_id IS NULL
1302: UNION ALL
1303: SELECT SUB2.Requisition_Line_ID

Line 1304: FROM PO_REQUISITION_LINES_ALL SUB2

1300: WHERE SUB.Requisition_Header_Id = x_req_header_id
1301: AND x_req_line_id IS NULL
1302: UNION ALL
1303: SELECT SUB2.Requisition_Line_ID
1304: FROM PO_REQUISITION_LINES_ALL SUB2
1305: WHERE SUB2.Requisition_Line_Id = x_req_line_id
1306: );
1307:
1308: ELSE

Line 1562: FROM po_requisition_lines_all reqline, TABLE(X_entity_id) entity

1558: -- Linked_PO _Count would be 1 for all req lines, as Info and Option lines
1559: -- can be linked to Award only by Autocreate and its one to one mapping.
1560: SELECT requisition_line_id, linked_po_count
1561: BULK COLLECT INTO l_unlinked_reqLine_ids, l_unlinked_po_count
1562: FROM po_requisition_lines_all reqline, TABLE(X_entity_id) entity
1563: WHERE (reqline.clm_info_flag = 'Y' OR reqline.clm_option_indicator = 'O'
1564: OR reqLine.par_draft_id IS NOT NULL) --To process PAR lines without any distribution
1565: -- Dod - Exclude Info Funded Slins
1566: AND NOT EXISTS ( SELECT 1 FROM po_req_distributions_all prd

Line 1699: UPDATE po_requisition_lines_all

1695: -- If atleast on requisition line found whioh is linked to deleted entity.
1696: IF l_unlinked_reqLine_ids.Count > 0 THEN
1697: -- Update the linked po count by decrementing it.
1698: FORALL i IN 1..l_unlinked_reqLine_ids.Count
1699: UPDATE po_requisition_lines_all
1700: SET linked_po_count = linked_po_count - l_unlinked_po_count(i),
1701: last_update_date = SYSDATE,
1702: last_updated_by = FND_GLOBAL.USER_ID,
1703: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1717: UPDATE po_requisition_lines_all

1713:
1714: -- Nullify the po-Line-id and line_location_id for the all the requisition lines
1715: -- whose linked_po_count is zero.
1716: FORALL i IN 1..l_unlinked_reqLine_ids.Count
1717: UPDATE po_requisition_lines_all
1718: SET po_line_id = NULL, line_location_id = NULL
1719: WHERE requisition_line_id = l_unlinked_reqLine_ids(i)
1720: AND linked_po_count = 0;
1721:

Line 1739: FROM po_requisition_lines_all rl, TABLE(l_unlinked_reqLine_ids) entity

1735: -- Priced Clins those got deleted from Ditribution tab
1736: BEGIN
1737: SELECT requisition_line_id
1738: BULK COLLECT INTO l_pclin_ids
1739: FROM po_requisition_lines_all rl, TABLE(l_unlinked_reqLine_ids) entity
1740: WHERE rl.requisition_line_id = entity.column_value
1741: AND group_line_id IS NULL
1742: AND Nvl(clm_info_flag,'N') <> 'Y' AND Nvl(clm_option_indicator,'X') <> 'O';
1743:

Line 1750: UPDATE po_requisition_lines_all

1746: END;
1747: -- Nullify the po-Line-id, line_location_id and linked_po_count to 0 for the all Slins,
1748: -- if deleted/unlinked line is Priced Clin from distribution tab
1749: FORALL i IN 1..l_pclin_ids.Count
1750: UPDATE po_requisition_lines_all
1751: SET po_line_id = NULL, line_location_id = NULL , linked_po_count = 0
1752: WHERE group_line_id = l_pclin_ids(i);
1753:
1754: x_progress := 50;

Line 1777: FROM po_requisition_lines_all rl, TABLE(l_infofunded_slin_grp_ids) entity

1773: BEGIN
1774: -- Check if all the Info Funded Slins are unlinked for the group_line_id
1775: SELECT group_line_id
1776: BULK COLLECT INTO l_infofd_group_line_ids
1777: FROM po_requisition_lines_all rl, TABLE(l_infofunded_slin_grp_ids) entity
1778: WHERE group_line_id = entity.column_value
1779: GROUP BY group_line_id HAVING Sum(Nvl(linked_po_count,0)) = 0;
1780:
1781: EXCEPTION WHEN No_Data_Found THEN

Line 1795: UPDATE po_requisition_lines_all

1791: END IF;
1792:
1793: -- Update the Priced Clin of Info Funded Slins, if all Slins unlinked
1794: FORALL i IN 1..l_infofd_group_line_ids.Count
1795: UPDATE po_requisition_lines_all
1796: SET po_line_id = NULL, line_location_id = NULL , linked_po_count = 0
1797: WHERE requisition_line_id = l_infofd_group_line_ids(i);
1798:
1799: -- Enter Priced Clin of Info funded slins into GT table, for sending all reqs in structure back to pool

Line 1817: FROM po_requisition_lines_all l

1813: group_line_id,
1814: clm_base_line_num,
1815: linked_po_count,
1816: requisition_line_id
1817: FROM po_requisition_lines_all l
1818: WHERE requisition_line_id = l_infofd_group_line_ids(i);
1819:
1820: x_progress := 80;
1821: IF g_fnd_debug = 'Y' THEN

Line 1851: FROM po_requisition_lines_all l

1847: group_line_id,
1848: clm_base_line_num,
1849: linked_po_count,
1850: requisition_line_id
1851: FROM po_requisition_lines_all l
1852: WHERE requisition_line_id = l_unlinked_reqLine_ids(i)
1853: AND (
1854: (group_line_id IS NULL ) -- All Clins (AutoCreate and SoftLinked)
1855: OR

Line 1915: FROM po_requisition_lines_all

1911: FORALL i IN 1..p_reqLine_ids.Count
1912: UPDATE po_lines_draft_all
1913: SET DRAFT_LINE_STATUS = 'COMPLETED'
1914: WHERE (po_line_id, draft_id) IN ( SELECT par_line_id, par_draft_id
1915: FROM po_requisition_lines_all
1916: WHERE requisition_line_id = p_reqLine_ids(i)
1917: AND requisition_header_id = p_reqHeader_ids(i)
1918: AND assignment_number IS NULL
1919: );

Line 1925: FROM po_requisition_lines_all

1921: FORALL i IN 1..p_reqLine_ids.Count
1922: UPDATE po_lines_draft_all
1923: SET DRAFT_LINE_STATUS = 'ASSIGNED'
1924: WHERE (po_line_id, draft_id) IN ( SELECT par_line_id, par_draft_id
1925: FROM po_requisition_lines_all
1926: WHERE requisition_line_id = p_reqLine_ids(i)
1927: AND requisition_header_id = p_reqHeader_ids(i)
1928: AND assignment_number IS NOT NULL
1929: );

Line 1986: FROM po_requisition_lines_all r,

1982: LOOP
1983: INSERT INTO po_session_gt gt3 (index_char1, index_num1, index_num2, num1, num2, num3, num10)
1984:
1985: SELECT 'UNLINKED_REQUISITIONS', r.requisition_line_id, r.requisition_header_id, r.group_line_id, r.clm_base_line_num, r.linked_po_count, num10
1986: FROM po_requisition_lines_all r,
1987: po_session_gt gt
1988: WHERE
1989: r.requisition_header_id = gt.index_num2
1990: AND gt.index_char1 = 'UNLINKED_REQUISITIONS'

Line 2038: UPDATE po_requisition_lines_all

2034:
2035: -- Update the reqs_in_pool_flag for the entire Clin-Slin structure if it dont have any
2036: -- POs linked. Above l_eligible_reqLine_ids will give us the list.
2037: FORALL i IN 1..l_eligible_reqLine_ids.Count
2038: UPDATE po_requisition_lines_all
2039: SET reqs_in_pool_flag = 'Y',
2040: linked_po_count = NULL,
2041: last_update_date = SYSDATE,
2042: last_updated_by = FND_GLOBAL.USER_ID,