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 131: UPDATE PO_REQUISITION_HEADERS

127:
128: IF X_authorization_status IS NOT NULL OR
129: X_closed_code IS NOT NULL THEN
130: X_progress := '015';
131: UPDATE PO_REQUISITION_HEADERS
132: SET authorization_status = nvl(X_authorization_status, authorization_status),
133: closed_code = nvl(X_closed_code, closed_code),
134: contractor_status = decode(X_authorization_status,'CANCELLED',null,
135: contractor_status), -- Bug 3495679

Line 323: FROM po_requisition_headers

319: x_progress := '010';
320:
321: SELECT type_lookup_code
322: INTO x_type_lookup_code
323: FROM po_requisition_headers
324: WHERE requisition_header_id = X_req_hdr_id;
325:
326: /* Validate if the Document can be deleted */
327:

Line 344: FROM PO_REQUISITION_HEADERS

340: /* hvadlamu : commnting out the delete and adding the WorkFlow call */
341:
342: SELECT wf_item_type,wf_item_key
343: INTO x_item_type,x_item_key
344: FROM PO_REQUISITION_HEADERS
345: WHERE requisition_header_id = x_req_hdr_id;
346:
347: if ((x_item_type is null) and (x_item_key is null)) then
348: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,

Line 376: FROM po_requisition_headers

372: x_progress := '030';
373:
374: SELECT rowid
375: INTO x_rowid
376: FROM po_requisition_headers
377: WHERE requisition_header_id = X_req_hdr_id;
378:
379: -- dbms_output.put_line('After selecting rowid');
380:

Line 412: po_requisition_headers_pkg.delete_row(X_rowid);

408: */
409:
410: x_progress := '060';
411:
412: po_requisition_headers_pkg.delete_row(X_rowid);
413:
414: -- dbms_output.put_line('After delete row');
415:
416: END IF;

Line 495: po_requisition_headers_pkg.insert_row(X_Rowid,

491: BEGIN
492:
493: x_progress := '010';
494:
495: po_requisition_headers_pkg.insert_row(X_Rowid,
496: X_Requisition_Header_Id,
497: X_Preparer_Id,
498: X_Last_Update_Date,
499: X_Last_Updated_By,

Line 565: PO_REQUISITION_HEADERS_PKG.get_real_segment1.

561: document number was being inserted into the fnd_notifications table, since
562: the call below was made before we called the procedure to get the real
563: document number (segment1) in the POST-FORMS-COMMIT trigger.
564: Therefore, remove the call below from here and moving it to procedure
565: PO_REQUISITION_HEADERS_PKG.get_real_segment1.
566: */
567:
568: IF X_Manual THEN
569:

Line 605: UPDATE po_requisition_headers

601: BEGIN
602:
603: x_progress := '010';
604:
605: UPDATE po_requisition_headers
606: SET transferred_to_oe_flag = X_flag
607: WHERE requisition_header_id = X_req_hdr_id;
608:
609: -- dbms_output.put_line('After update');