[Home] [Help]
PACKAGE: APPS.ASO_PA_APR_PUB_W
Source
1 PACKAGE ASO_PA_APR_PUB_W AUTHID CURRENT_USER as
2 /* $Header: asowpaps.pls 120.0.12020000.1 2013/03/19 20:29:51 cazhou noship $ */
3
4 FUNCTION Construct_Approvers_List_Tbl(
5 p_approval_det_id IN jtf_number_table := NULL,
6 p_object_approval_id IN jtf_number_table := NULL,
7 p_approver_person_id IN jtf_number_table := NULL,
8 p_approver_user_id IN jtf_number_table := NULL,
9 p_notification_id IN jtf_number_table := NULL,
10 p_approver_sequence IN jtf_number_table := NULL,
11 p_approver_status IN jtf_varchar2_table_100 := NULL,
12 p_name IN jtf_varchar2_table_300 := NULL,
13 p_approver_name IN jtf_varchar2_table_100 := NULL,
14 p_approval_comments IN jtf_varchar2_table_300 := NULL,
15 p_approver_category IN jtf_varchar2_table_100 := NULL,
16 p_approver_category_desc IN jtf_varchar2_table_100 := NULL,
17 p_approver_type_desc IN jtf_varchar2_table_100 := NULL,
18 p_sub_list_desc IN jtf_varchar2_table_100 := NULL,
19 p_item_id IN jtf_varchar2_table_100 := NULL,
20 p_item_class IN jtf_varchar2_table_100 := NULL,
21 p_action_type IN jtf_varchar2_table_300 := NULL,
22 p_action_type_id IN jtf_number_table := NULL,
23 p_chain_number IN jtf_number_table := NULL,
24 p_occurrence IN jtf_number_table := NULL,
25 p_authority IN jtf_varchar2_table_100 := NULL,
26 p_date_sent IN jtf_date_table := NULL,
27 p_date_received IN jtf_date_table := NULL
28 )
29 RETURN ASO_PA_APR_PUB.Approvers_List_Tbl_Type;
30
31 PROCEDURE Set_Approvers_List_Tbl_Out(
32 p_qte_approvers_list_tbl IN ASO_PA_Apr_Pub.Approvers_List_Tbl_Type,
33 x_approval_det_id OUT NOCOPY jtf_number_table,
34 x_object_approval_id OUT NOCOPY jtf_number_table,
35 x_approver_person_id OUT NOCOPY jtf_number_table,
36 x_approver_user_id OUT NOCOPY jtf_number_table,
37 x_notification_id OUT NOCOPY jtf_number_table,
38 x_approver_sequence OUT NOCOPY jtf_number_table,
39 x_approver_status OUT NOCOPY jtf_varchar2_table_100,
40 x_name OUT NOCOPY jtf_varchar2_table_300,
41 x_approver_name OUT NOCOPY jtf_varchar2_table_100,
42 x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
43 x_approver_category OUT NOCOPY jtf_varchar2_table_100,
44 x_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
45 x_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
46 x_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
47 x_item_id OUT NOCOPY jtf_varchar2_table_100,
48 x_item_class OUT NOCOPY jtf_varchar2_table_100,
49 x_action_type OUT NOCOPY jtf_varchar2_table_300,
50 x_action_type_id OUT NOCOPY jtf_number_table,
51 x_chain_number OUT NOCOPY jtf_number_table,
52 x_occurrence OUT NOCOPY jtf_number_table,
53 x_authority OUT NOCOPY jtf_varchar2_table_100,
54 x_date_sent OUT NOCOPY jtf_date_table,
55 x_date_received OUT NOCOPY jtf_date_table
56 );
57
58 PROCEDURE Set_Rules_List_Tbl_Out(
59 p_qte_rules_list_tbl IN ASO_PA_Apr_Pub.Rules_List_Tbl_Type,
60 x_rule_id OUT NOCOPY jtf_number_table,
61 x_object_approval_id OUT NOCOPY jtf_number_table,
62 x_rule_action_id OUT NOCOPY jtf_number_table,
63 x_rule_description OUT NOCOPY jtf_varchar2_table_300,
64 x_rule_type OUT NOCOPY jtf_varchar2_table_100,
65 x_approval_level OUT NOCOPY jtf_varchar2_table_300,
66 x_rule_item_class OUT NOCOPY jtf_varchar2_table_100,
67 x_rule_category_desc OUT NOCOPY jtf_varchar2_table_100
68 );
69
70 PROCEDURE Get_All_Approvers(
71 x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
72 x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
73 x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
74 x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
75 x_qa_notification_id OUT NOCOPY jtf_number_table ,
76 x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
77 x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
78 x_qa_name OUT NOCOPY jtf_varchar2_table_300 ,
79 x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100,
80 x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300,
81 x_qa_approver_category OUT NOCOPY jtf_varchar2_table_100,
82 x_qa_approver_category_desc OUT NOCOPY jtf_varchar2_table_100,
83 x_qa_approver_type_desc OUT NOCOPY jtf_varchar2_table_100,
84 x_qa_sub_list_desc OUT NOCOPY jtf_varchar2_table_100,
85 x_qa_item_id OUT NOCOPY jtf_varchar2_table_100,
86 x_qa_item_class OUT NOCOPY jtf_varchar2_table_100,
87 x_qa_action_type OUT NOCOPY jtf_varchar2_table_300,
88 x_qa_action_type_id OUT NOCOPY jtf_number_table,
89 x_qa_chain_number OUT NOCOPY jtf_number_table,
90 x_qa_occurrence OUT NOCOPY jtf_number_table,
91 x_qa_authority OUT NOCOPY jtf_varchar2_table_100,
92 x_qa_date_sent OUT NOCOPY jtf_date_table ,
93 x_qa_date_received OUT NOCOPY jtf_date_table ,
94 x_qr_rule_id OUT NOCOPY jtf_number_table ,
95 x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
96 x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
97 x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
98 x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
99 x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
100 x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
101 x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
102 p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
103 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
105 p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
106 p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
107 p_data_flag IN VARCHAR2 :='X',
108 p_api_version_number IN NUMBER := 1 ,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
111 x_return_status OUT NOCOPY VARCHAR2 ,
112 x_msg_count OUT NOCOPY NUMBER ,
113 x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116 PROCEDURE start_papproval_process (
117 p_api_version_number IN NUMBER := 1,
118 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
119 p_commit IN VARCHAR2 := fnd_api.g_false,
120 p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
121 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
123 p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_qa_approval_det_id IN jtf_number_table := NULL,
125 p_qa_object_approval_id IN jtf_number_table := NULL,
126 p_qa_approver_person_id IN jtf_number_table := NULL,
127 p_qa_approver_user_id IN jtf_number_table := NULL,
128 p_qa_notification_id IN jtf_number_table := NULL,
129 p_qa_approver_sequence IN jtf_number_table := NULL,
130 p_qa_approver_status IN jtf_varchar2_table_100 := NULL,
131 p_qa_name IN jtf_varchar2_table_300 := NULL,
132 p_qa_approver_name IN jtf_varchar2_table_100 := NULL,
133 p_qa_approval_comments IN jtf_varchar2_table_300 := NULL,
134 p_qa_approver_category IN jtf_varchar2_table_100 := NULL,
135 p_qa_approver_category_desc IN jtf_varchar2_table_100 := NULL,
136 p_qa_approver_type_desc IN jtf_varchar2_table_100 := NULL,
137 p_qa_sub_list_desc IN jtf_varchar2_table_100 := NULL,
138 p_qa_item_id IN jtf_varchar2_table_100 := NULL,
139 p_qa_item_class IN jtf_varchar2_table_100 := NULL,
140 p_qa_action_type IN jtf_varchar2_table_300 := NULL,
141 p_qa_action_type_id IN jtf_number_table := NULL,
142 p_qa_chain_number IN jtf_number_table := NULL,
143 p_qa_occurrence IN jtf_number_table := NULL,
144 p_qa_authority IN jtf_varchar2_table_100 := NULL,
145 p_qa_date_sent IN jtf_date_table := NULL,
146 p_qa_date_received IN jtf_date_table := NULL,
147 x_object_approval_id OUT NOCOPY NUMBER,
148 x_approval_instance_id OUT NOCOPY NUMBER,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152 );
153
154 END ASO_PA_APR_PUB_W;