DBA Data[Home] [Help]

PACKAGE: APPS.AMW_PROC_APPROVAL_PKG

Source


1 PACKAGE AMW_PROC_APPROVAL_PKG AUTHID CURRENT_USER as
2 /*$Header: amwapprs.pls 120.0 2005/05/31 20:58:15 appldev noship $*/
3 
4 APPROV_TXN_DATE date;
5 
6 --NPANANDI 11.26.2004, ADDED P_WEBADI_CALL PARAMETER
7 --BECAUSE WHEN THIS IS CALLED FROM WEBADI, WE DON'T WANT TO CALL
8 --CHECK_HIER_APPROVED PROCEDURE
9 procedure sub_for_approval (p_process_id in number
10                            ,p_webadi_call in varchar2 := NULL);
11 
12 procedure approve(p_process_id in number);
13 
14 procedure reject (p_process_id in number);
15 
16 procedure check_hier_approved(p_process_id in number);
17 
18 procedure approve_associations(p_process_id in number);
19 
20 procedure write_approved_hierarchy(
21    p_process_id in number default null,
22    p_step in number);
23 
24 procedure prod_err_unapr_obj_ass_ex (p_process_id in number,
25                                      approve_option in varchar2,
26                                      raise_ex in varchar2,
27                                      p_result out nocopy varchar2,
28                                      p_out_mesg out nocopy varchar2 );
29 
30 procedure autoapprove(
31 p_process_id            in number,
32 p_commit			    in varchar2 := FND_API.G_FALSE,
33 p_validation_level		IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34 p_init_msg_list			IN VARCHAR2 := FND_API.G_FALSE,
35 x_return_status			out nocopy varchar2,
36 x_msg_count			    out nocopy number,
37 x_msg_data			    out nocopy varchar2 );
38 
39 
40 procedure check_approval_subm_eligib(
41 p_process_id            in number,
42 p_result                out nocopy varchar2,
43 p_out_mesg              out nocopy varchar2,
44 p_commit			    in varchar2 := FND_API.G_FALSE,
45 p_validation_level		IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_init_msg_list			IN VARCHAR2 := FND_API.G_FALSE,
47 x_return_status			out nocopy varchar2,
48 x_msg_count			    out nocopy number,
49 x_msg_data			    out nocopy varchar2 );
50 
51 procedure check_hier_approved(p_process_id in number,
52                               p_result out nocopy varchar2,
53                               p_out_mesg out nocopy varchar2);
54 
55 procedure prod_err_modified_nschildlist(p_process_id in number,
56                                         approve_option in varchar2,
57                                         p_result out nocopy varchar2,
58                                         p_out_mesg out nocopy varchar2);
59 
60 procedure prod_err_unappr_nsvar(p_process_id in number,
61                                 approve_option in varchar2,
62                                 p_result out nocopy varchar2,
63                                 p_out_mesg out nocopy varchar2);
64 
65 ---05.11.2005 npanandi: added below procedure for handling
66 ---webadi approvals
67 procedure webadi_approve(
68    p_process_id in number
69   ,p_approv_choice in varchar2);
70 
71 end AMW_PROC_APPROVAL_PKG;