[Home] [Help]
PACKAGE: APPS.ASO_APR_INT
Source
1 PACKAGE aso_apr_int AUTHID CURRENT_USER AS
2 /* $Header: asoiaprs.pls 120.2 2005/11/03 16:01:46 skulkarn ship $ */
3 version CONSTANT NUMBER := 1.0;
4
5 PROCEDURE get_all_approvers (
6 p_api_version_number IN NUMBER,
7 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9 p_object_id IN NUMBER,
10 p_object_type IN VARCHAR2,
11 p_application_id IN NUMBER,
12 p_clear_transaction_flag IN VARCHAR2 DEFAULT fnd_api.g_true,
13 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
14 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
15 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
16 x_approvers_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.approvers_list_tbl_type,
17 x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type
18 );
19
20 PROCEDURE start_approval_process (
21 p_api_version_number IN NUMBER,
22 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
23 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
24 p_object_id IN NUMBER,
25 p_object_type IN VARCHAR2,
26 p_application_id IN NUMBER,
27 p_approver_sequence IN NUMBER DEFAULT fnd_api.g_miss_num,
28 p_requester_comments IN VARCHAR2,
29 x_object_approval_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
30 x_approval_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
31 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
32 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
33 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 );
35
36 PROCEDURE cancel_approval_process (
37 p_api_version_number IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
39 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
40 p_object_id IN NUMBER,
41 p_object_type IN VARCHAR2,
42 p_application_id IN NUMBER,
43 p_itemtype IN VARCHAR2,
44 p_object_approval_id IN NUMBER,
45 p_user_id IN NUMBER,
46 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
47 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
48 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 );
50 -- The following procedure may not be implemented
51
52 PROCEDURE skip_approver (
53 p_api_version_number IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
55 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
56 p_object_id IN NUMBER,
57 p_object_type IN VARCHAR2,
58 p_approver_id IN NUMBER,
59 p_approval_instance_id IN NUMBER,
60 p_application_id IN NUMBER,
61 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
63 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 );
65
66 FUNCTION get_approver_name (
67 p_user_id NUMBER,
68 p_person_id NUMBER
69 )
70 RETURN VARCHAR2;
71
72 PROCEDURE get_rule_details (
73 p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
75 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
76 p_object_approval_id IN NUMBER,
77 x_rules_list OUT NOCOPY /* file.sql.39 change */ aso_apr_pub.rules_list_tbl_type,
78 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
79 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
80 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
81
82
83 PROCEDURE start_approval_workflow (
84 p_api_version_number IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
86 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
87 P_Object_approval_id IN NUMBER,
88 P_itemtype IN VARCHAR2,
89 P_sender_name IN VARCHAR2,
90 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
91 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
92 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 );
94
95 PROCEDURE upd_status_self_appr
96 ( p_qte_hdr_id IN NUMBER,
97 p_obj_ver_num IN NUMBER,
98 p_last_update_date IN DATE,
99 x_obj_ver_num OUT NOCOPY NUMBER,
100 x_last_update_date OUT NOCOPY DATE,
101 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 );
105
106
107
108 END aso_apr_int;