APPS.PO_REQS_SV dependencies on PO_REQUISITION_HEADERS

Line 15: FROM po_requisition_headers

11: PROCEDURE lock_row_for_status_update (x_requisition_header_id IN NUMBER)
12: IS
13: CURSOR C IS
14: SELECT *
15: FROM po_requisition_headers
16: WHERE requisition_header_id = x_requisition_header_id
17: FOR UPDATE of requisition_header_id NOWAIT;
18: Recinfo C%ROWTYPE;
19:

Line 58: X_authorization_status PO_REQUISITION_HEADERS.authorization_status%TYPE := NULL;

54: X_req_action_history_code IN OUT NOCOPY VARCHAR2,
55: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
56:
57: X_progress VARCHAR2(3) := NULL;
58: X_authorization_status PO_REQUISITION_HEADERS.authorization_status%TYPE := NULL;
59: X_closed_code PO_REQUISITION_HEADERS.closed_code%TYPE := NULL;
60: X_req_has_open_shipment NUMBER := 0;
61: X_req_has_open_line NUMBER := 0;
62:

Line 59: X_closed_code PO_REQUISITION_HEADERS.closed_code%TYPE := NULL;

55: X_req_control_error_rc IN OUT NOCOPY VARCHAR2) IS
56:
57: X_progress VARCHAR2(3) := NULL;
58: X_authorization_status PO_REQUISITION_HEADERS.authorization_status%TYPE := NULL;
59: X_closed_code PO_REQUISITION_HEADERS.closed_code%TYPE := NULL;
60: X_req_has_open_shipment NUMBER := 0;
61: X_req_has_open_line NUMBER := 0;
62:
63: BEGIN

Line 129: UPDATE PO_REQUISITION_HEADERS

125:
126: END IF;
127:
128: --Start Bug 9611149 - FP of Bug 9537322
129: UPDATE PO_REQUISITION_HEADERS
130: SET active_shopping_cart_flag = null
131: WHERE requisition_header_id = X_req_header_id;
132: --End Bug 9611149 - FP of Bug 9537322
133:

Line 137: UPDATE PO_REQUISITION_HEADERS

133:
134: IF X_authorization_status IS NOT NULL OR
135: X_closed_code IS NOT NULL THEN
136: X_progress := '015';
137: UPDATE PO_REQUISITION_HEADERS
138: SET authorization_status = nvl(X_authorization_status, authorization_status),
139: closed_code = nvl(X_closed_code, closed_code),
140: contractor_status = decode(X_authorization_status,'CANCELLED',null,
141: contractor_status), -- Bug 3495679

Line 329: FROM po_requisition_headers

325: x_progress := '010';
326:
327: SELECT type_lookup_code
328: INTO x_type_lookup_code
329: FROM po_requisition_headers
330: WHERE requisition_header_id = X_req_hdr_id;
331:
332: /* Validate if the Document can be deleted */
333:

Line 350: FROM PO_REQUISITION_HEADERS

346: /* hvadlamu : commnting out the delete and adding the WorkFlow call */
347:
348: SELECT wf_item_type,wf_item_key
349: INTO x_item_type,x_item_key
350: FROM PO_REQUISITION_HEADERS
351: WHERE requisition_header_id = x_req_hdr_id;
352:
353: if ((x_item_type is null) and (x_item_key is null)) then
354: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,

Line 382: FROM po_requisition_headers

378: x_progress := '030';
379:
380: SELECT rowid
381: INTO x_rowid
382: FROM po_requisition_headers
383: WHERE requisition_header_id = X_req_hdr_id;
384:
385: -- dbms_output.put_line('After selecting rowid');
386:

Line 420: po_requisition_headers_pkg.delete_row(X_rowid);

416: */
417:
418: x_progress := '060';
419:
420: po_requisition_headers_pkg.delete_row(X_rowid);
421:
422: -- dbms_output.put_line('After delete row');
423:
424: END IF;

Line 503: po_requisition_headers_pkg.insert_row(X_Rowid,

499: BEGIN
500:
501: x_progress := '010';
502:
503: po_requisition_headers_pkg.insert_row(X_Rowid,
504: X_Requisition_Header_Id,
505: X_Preparer_Id,
506: X_Last_Update_Date,
507: X_Last_Updated_By,

Line 573: PO_REQUISITION_HEADERS_PKG.get_real_segment1.

569: document number was being inserted into the fnd_notifications table, since
570: the call below was made before we called the procedure to get the real
571: document number (segment1) in the POST-FORMS-COMMIT trigger.
572: Therefore, remove the call below from here and moving it to procedure
573: PO_REQUISITION_HEADERS_PKG.get_real_segment1.
574: */
575:
576: IF X_Manual THEN
577:

Line 613: UPDATE po_requisition_headers

609: BEGIN
610:
611: x_progress := '010';
612:
613: UPDATE po_requisition_headers
614: SET transferred_to_oe_flag = X_flag
615: WHERE requisition_header_id = X_req_hdr_id;
616:
617: -- dbms_output.put_line('After update');