1 PACKAGE PO_REQS_SV2 AUTHID CURRENT_USER as
2 /* $Header: POXRQR2S.pls 115.2 2002/11/23 01:55:10 sbull ship $ */
3 /*===========================================================================
4 PACKAGE NAME: po_reqs_sv2
5
6 DESCRIPTION: Contains all server side procedures that access the
7 requisitions entity for WF functionality.
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME: None
12
13 OWNER: IALI
14
15 PROCEDURE/FUNCTIONS: get_reqs_auth_status(..); THIS PROCEDURE WAS MOVED HERE
16 AS PO_REQS_SV GOT TOO BIG.
17 WF_notifications_commit;
18
19 ===========================================================================*/
20
21
22 /*===========================================================================
23 PROCEDURE NAME: get_reqs_auth_status
24
25 DESCRIPTION: Gets requisition header's authorization_status
26
27
28 PARAMETERS: X_req_header_id IN NUMBER,
29 X_req_header_auth_status IN OUT VARCHAR2,
30 X_req_header_auth_status_dsp IN OUT VARCHAR2,
31 X_req_control_error_rc IN OUT VARCHAR2
32
33 DESIGN REFERENCES: ../POXDOCON.dd
34
35 ALGORITHM: Get requisition authorization status from
36 the requisition header.
37
38 NOTES:
39
40 OPEN ISSUES:
41
42 CLOSED ISSUES:
43
44 CHANGE HISTORY: WLAU 5/12 Created
45 IALI 7/25/97 Updated and moved to diff package
46 ===========================================================================*/
47 PROCEDURE get_reqs_auth_status
48 (X_req_header_id IN NUMBER,
49 X_req_header_auth_status IN OUT NOCOPY VARCHAR2,
50 X_req_header_auth_status_dsp IN OUT NOCOPY VARCHAR2,
51 X_req_control_error_rc IN OUT NOCOPY VARCHAR2);
52
53 /* ========================================================================*/
54
55 /*
56 Procedure to execute a server side commit after returning from
57 approval WF to kickoff any notifications. Else the notifications
58 would be suspended untill the form is exited or a forms commit
59 is executed.
60 */
61
62 PROCEDURE WF_notifications_commit;
63
64 END PO_REQS_SV2;