[Home] [Help]
PACKAGE: APPS.ASO_APR_PUB_W
Source
1 PACKAGE ASO_APR_PUB_W as
2 /* $Header: asowaprs.pls 120.0 2005/06/01 17:59:08 appldev noship $ */
3
4 PROCEDURE Set_Approvers_List_Tbl_Out(
5 p_qte_approvers_list_tbl IN ASO_Apr_Pub.Approvers_List_Tbl_Type,
6 x_approval_det_id OUT NOCOPY jtf_number_table,
7 x_object_approval_id OUT NOCOPY jtf_number_table,
8 x_approver_person_id OUT NOCOPY jtf_number_table,
9 x_approver_user_id OUT NOCOPY jtf_number_table,
10 x_notification_id OUT NOCOPY jtf_number_table,
11 x_approver_sequence OUT NOCOPY jtf_number_table,
12 x_approver_status OUT NOCOPY jtf_varchar2_table_100,
13 x_approver_name OUT NOCOPY jtf_varchar2_table_100,
14 x_approval_comments OUT NOCOPY jtf_varchar2_table_300,
15 x_date_sent OUT NOCOPY jtf_date_table,
16 x_date_received OUT NOCOPY jtf_date_table
17 );
18
19 PROCEDURE Set_Rules_List_Tbl_Out(
20 p_qte_rules_list_tbl IN ASO_Apr_Pub.Rules_List_Tbl_Type,
21 x_rule_id OUT NOCOPY jtf_number_table,
22 x_object_approval_id OUT NOCOPY jtf_number_table,
23 x_rule_action_id OUT NOCOPY jtf_number_table,
24 x_rule_description OUT NOCOPY jtf_varchar2_table_300,
25 x_approval_level OUT NOCOPY jtf_varchar2_table_300
26 );
27
28 PROCEDURE Get_All_Approvers(
29 x_qa_approval_det_id OUT NOCOPY jtf_number_table ,
30 x_qa_object_approval_id OUT NOCOPY jtf_number_table ,
31 x_qa_approver_person_id OUT NOCOPY jtf_number_table ,
32 x_qa_approver_user_id OUT NOCOPY jtf_number_table ,
33 x_qa_notification_id OUT NOCOPY jtf_number_table ,
34 x_qa_approver_sequence OUT NOCOPY jtf_number_table ,
35 x_qa_approver_status OUT NOCOPY jtf_varchar2_table_100 ,
36 x_qa_approver_name OUT NOCOPY jtf_varchar2_table_100 ,
37 x_qa_approval_comments OUT NOCOPY jtf_varchar2_table_300 ,
38 x_qa_date_sent OUT NOCOPY jtf_date_table ,
39 x_qa_date_received OUT NOCOPY jtf_date_table ,
40 x_qr_rule_id OUT NOCOPY jtf_number_table ,
41 x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
42 x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
43 x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
44 x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
45 p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
46 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
48 p_api_version_number IN NUMBER := 1 ,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
51 x_return_status OUT NOCOPY VARCHAR2 ,
52 x_msg_count OUT NOCOPY NUMBER ,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE Get_Rule_Details(
57 x_qr_rule_id OUT NOCOPY jtf_number_table ,
58 x_qr_object_approval_id OUT NOCOPY jtf_number_table ,
59 x_qr_rule_action_id OUT NOCOPY jtf_number_table ,
60 x_qr_rule_description OUT NOCOPY jtf_varchar2_table_300 ,
61 x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
62 p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
63 p_api_version_number IN NUMBER := 1 ,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66 x_return_status OUT NOCOPY VARCHAR2 ,
67 x_msg_count OUT NOCOPY NUMBER ,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 END ASO_APR_PUB_W;