[Home] [Help]
PACKAGE: APPS.ASO_PA_APR_INT
Source
1 PACKAGE aso_pa_apr_int AUTHID CURRENT_USER AS
2 /* $Header: asoipaps.pls 120.0.12020000.4 2013/04/12 03:55:07 rassharm noship $ */
3
4 version CONSTANT NUMBER := 1.0;
5
6
7 PROCEDURE get_all_approvers (
8 p_api_version_number IN NUMBER,
9 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
10 p_commit IN VARCHAR2 := fnd_api.g_false,
11 p_object_id IN NUMBER,
12 p_object_type IN VARCHAR2,
13 p_application_id IN NUMBER,
14 p_object_approval_id IN NUMBER,
15 p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_false,
16 p_data_flag IN VARCHAR2 :='Y',
17 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
19 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20 x_approvers_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.approvers_list_tbl_type,
21 x_rules_list OUT NOCOPY /* file.sql.39 change */ ASO_PA_APR_PUB.rules_list_tbl_type
22 );
23
24
25 PROCEDURE start_papproval_process (
26 p_api_version_number IN NUMBER,
27 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28 p_commit IN VARCHAR2 := fnd_api.g_false,
29 p_object_id IN NUMBER,
30 p_object_type IN VARCHAR2,
31 p_application_id IN NUMBER,
32 p_requester_comments IN VARCHAR2,
33 p_del_appr_table IN ASO_PA_APR_PUB.approvers_list_tbl_type,
34 x_object_approval_id OUT NOCOPY NUMBER,
35 x_approval_instance_id OUT NOCOPY NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41
42 PROCEDURE cancel_approval_process (
43 p_api_version_number IN NUMBER,
44 p_init_msg_list IN VARCHAR2,
45 p_commit IN VARCHAR2,
46 p_object_id IN NUMBER,
47 p_object_type IN VARCHAR2,
48 p_application_id IN NUMBER,
49 p_itemtype IN VARCHAR2,
50 p_object_approval_id IN NUMBER,
51 p_user_id IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57
58 PROCEDURE start_pa_approval_workflow (
59 p_api_version_number IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
61 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
62 p_object_approval_id IN NUMBER,
63 p_itemtype IN VARCHAR2,
64 p_sender_name IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2);
68
69 PROCEDURE upd_status_self_appr
70 ( p_qte_hdr_id IN NUMBER,
71 p_obj_ver_num IN NUMBER,
72 p_last_update_date IN DATE,
73 x_obj_ver_num OUT NOCOPY NUMBER,
74 x_last_update_date OUT NOCOPY DATE,
75 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
76 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
77 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 );
79
80 procedure insert_approvers_gtt
81 (approvertblin IN aso_pa_apr_pub.approvers_list_tbl_type,
82 p_object_appr_id IN number,
83 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
84 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
85 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
86
87
88
89 END aso_pa_apr_int;