[Home] [Help]
PACKAGE: APPS.ASO_PA_APR_PUB
Source
1 PACKAGE ASO_PA_APR_PUB AUTHID CURRENT_USER AS
2 /* $Header: asoppaps.pls 120.0.12020000.1 2013/03/20 10:33:01 rassharm noship $ */
3
4 version CONSTANT NUMBER := 1.0;
5
6 TYPE approval_instance_rec_type IS RECORD (
7 object_approval_id NUMBER,
8 approval_instance_id NUMBER,
9 object_id NUMBER,
10 object_type VARCHAR2 (30),
11 approval_status VARCHAR2 (30),
12 requester_name VARCHAR2 (240),
13 requester_userid NUMBER,
14 requester_comments VARCHAR2 (2000),
15 start_date DATE,
16 end_date DATE
17 );
18
19 TYPE approval_instance_tbl_type IS TABLE OF approval_instance_rec_type
20 INDEX BY BINARY_INTEGER;
21
22 TYPE approvers_list_rec_type IS RECORD (
23 approval_det_id NUMBER,
24 object_approval_id NUMBER,
25 approver_person_id NUMBER,
26 approver_user_id NUMBER,
27 notification_id NUMBER,
28 approver_sequence NUMBER,
29 approver_status VARCHAR2 (30),
30 name varchar2(320),
31 approver_name VARCHAR2 (360),
32 approval_comments VARCHAR2 (240),
33 approver_category VARCHAR2 (1),
34 approver_category_desc VARCHAR2 (50),
35 approver_type_desc VARCHAR2 (50),
36 sub_list_desc varchar2(50),
37 item_id varchar2(100),
38 item_class varchar2(100),
39 action_type VARCHAR2 (150),
40 action_type_id INTEGER,
41 chain_number INTEGER,
42 occurrence INTEGER,
43 authority varchar2(1),
44 date_sent DATE,
45 date_received DATE
46 );
47
48
49 g_MISS_approvers_list_rec approvers_list_rec_type;
50
51 TYPE approvers_list_tbl_type IS TABLE OF approvers_list_rec_type
52 INDEX BY BINARY_INTEGER;
53 G_MISS_APPROVERS_LIST_TBL approvers_list_tbl_type;
54
55
56 TYPE rules_list_rec_type IS RECORD (
57 rule_id NUMBER,
58 object_approval_id NUMBER,
59 rule_action_id NUMBER,
60 rule_description VARCHAR2 (240),
61 rule_type VARCHAR2 (50),
62 approval_level VARCHAR2 (240),
63 rule_item_class AME_ITEM_CLASSES.NAME%TYPE,
64 rule_category_desc VARCHAR2 (50)
65 );
66
67 TYPE rules_list_tbl_type IS TABLE OF rules_list_rec_type
68 INDEX BY BINARY_INTEGER;
69
70 PROCEDURE get_all_approvers (
71 p_api_version_number IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
73 p_commit IN VARCHAR2 := fnd_api.g_false,
74 p_object_id IN NUMBER,
75 p_object_type IN VARCHAR2,
76 p_application_id IN NUMBER,
77 p_object_approval_id IN NUMBER,
78 p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_false,
79 p_data_flag IN VARCHAR2 :='Y',
80 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
81 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
82 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
83 x_approvers_list OUT NOCOPY /* file.sql.39 change */ approvers_list_tbl_type,
84 x_rules_list OUT NOCOPY /* file.sql.39 change */ rules_list_tbl_type
85 );
86
87
88 PROCEDURE start_papproval_process (
89 p_api_version_number IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
91 p_commit IN VARCHAR2 := fnd_api.g_false,
92 p_object_id IN NUMBER,
93 p_object_type IN VARCHAR2,
94 p_application_id IN NUMBER,
95 --p_approver_sequence IN NUMBER := fnd_api.g_miss_num,
96 p_requester_comments IN VARCHAR2,
97 p_del_appr_table IN approvers_list_tbl_type,
98 x_object_approval_id OUT NOCOPY NUMBER,
99 x_approval_instance_id OUT NOCOPY NUMBER,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105
106 PROCEDURE cancel_approval_process (
107 p_api_version_number IN NUMBER,
108 p_init_msg_list IN VARCHAR2,
109 p_commit IN VARCHAR2,
110 p_object_id IN NUMBER,
111 p_object_type IN VARCHAR2,
112 p_application_id IN NUMBER,
113 p_itemtype IN VARCHAR2,
114 p_object_approval_id IN NUMBER,
115 p_user_id IN NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2
119 );
120
121
122 PROCEDURE start_pa_approval_workflow (
123 p_api_version_number IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
125 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
126 p_object_approval_id IN NUMBER,
127 p_itemtype IN VARCHAR2,
128 p_sender_name IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2);
132
133
134
135 END ASO_PA_APR_PUB;