[Home] [Help]
PACKAGE: APPS.ASO_APR_PUB
Source
1 PACKAGE aso_apr_pub AUTHID CURRENT_USER AS
2 /* $Header: asopaprs.pls 120.1 2005/06/29 12:36:26 appldev ship $ */
3 version CONSTANT NUMBER := 1.0;
4
5 TYPE approval_instance_rec_type IS RECORD (
6 object_approval_id NUMBER,
7 approval_instance_id NUMBER,
8 object_id NUMBER,
9 object_type VARCHAR2 (30),
10 approval_status VARCHAR2 (30),
11 requester_name VARCHAR2 (240),
12 requester_userid NUMBER,
13 requester_comments VARCHAR2 (2000),
14 start_date DATE,
15 end_date DATE
16 );
17
18 TYPE approval_instance_tbl_type IS TABLE OF approval_instance_rec_type
19 INDEX BY BINARY_INTEGER;
20
21 TYPE approvers_list_rec_type IS RECORD (
22 approval_det_id NUMBER,
23 object_approval_id NUMBER,
24 approver_person_id NUMBER,
25 approver_user_id NUMBER,
26 notification_id NUMBER,
27 approver_sequence NUMBER,
28 approver_status VARCHAR2 (30),
29 approver_name VARCHAR2 (240),
30 approval_comments VARCHAR2 (240),
31 date_sent DATE,
32 date_recieved DATE
33 );
34
35 TYPE approvers_list_tbl_type IS TABLE OF approvers_list_rec_type
36 INDEX BY BINARY_INTEGER;
37
38 TYPE rules_list_rec_type IS RECORD (
39 rule_id NUMBER,
40 object_approval_id NUMBER,
41 rule_action_id NUMBER,
42 rule_description VARCHAR2 (240),
43 approval_level VARCHAR2 (240)
44 );
45
46 TYPE rules_list_tbl_type IS TABLE OF rules_list_rec_type
47 INDEX BY BINARY_INTEGER;
48
49 PROCEDURE get_all_approvers (
50 p_api_version_number IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52 p_commit IN VARCHAR2 := fnd_api.g_false,
53 p_object_id IN NUMBER,
54 p_object_type IN VARCHAR2,
55 p_application_id IN NUMBER,
56 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
58 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59 x_approvers_list OUT NOCOPY /* file.sql.39 change */ approvers_list_tbl_type,
60 x_rules_list OUT NOCOPY /* file.sql.39 change */ rules_list_tbl_type
61 );
62
63 PROCEDURE start_approval_process (
64 p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
66 p_commit IN VARCHAR2 := fnd_api.g_false,
67 p_object_id IN NUMBER,
68 p_object_type IN VARCHAR2,
69 p_application_id IN NUMBER,
70 p_approver_sequence IN NUMBER := fnd_api.g_miss_num,
71 p_requester_comments IN VARCHAR2,
72 x_object_approval_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
73 x_approval_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
74 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 );
78
79 PROCEDURE cancel_approval_process (
80 p_api_version_number IN NUMBER,
81 p_init_msg_list IN VARCHAR2,
82 p_commit IN VARCHAR2,
83 p_object_id IN NUMBER,
84 p_object_type IN VARCHAR2,
85 p_application_id IN NUMBER,
86 p_itemtype IN VARCHAR2,
87 p_object_approval_id IN NUMBER,
88 p_user_id IN NUMBER,
89 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
90 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
91 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 );
93 -- The following procedure may not be implemented
94
95 PROCEDURE skip_approver (
96 p_api_version_number IN NUMBER,
97 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
98 p_commit IN VARCHAR2 := fnd_api.g_false,
99 p_object_id IN NUMBER,
100 p_object_type IN VARCHAR2,
101 p_approver_id IN NUMBER,
102 p_approval_instance_id IN NUMBER,
103 p_application_id IN NUMBER,
104 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
105 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
106 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 );
108
109 PROCEDURE get_rule_details (
110 p_api_version_number IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
112 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
113 p_object_approval_id IN NUMBER,
114 x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type,
115 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
117 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
118
119 PROCEDURE start_approval_workflow (
120 p_api_version_number IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
123 p_object_approval_id IN NUMBER,
124 p_itemtype IN VARCHAR2,
125 p_sender_name IN VARCHAR2,
126 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
127 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
128 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
129
130
131 END aso_apr_pub;