[Home] [Help]
PACKAGE: APPS.IGW_PROPOSAL_APPROVAL
Source
1 package igw_proposal_approval AUTHID CURRENT_USER as
2 --$Header: igwpraps.pls 115.7 2002/11/14 18:50:12 vmedikon ship $
3
4 g_proposal_id number := 0;
5 g_run_id number := 0;
6
7 Procedure start_approval_process (
8 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
11 p_proposal_id IN NUMBER,
12 x_return_status OUT NOCOPY VARCHAR2,
13 x_msg_count OUT NOCOPY NUMBER,
14 x_msg_data OUT NOCOPY VARCHAR2);
15
16 ------------------------------------------------------------------------------------
17 PROCEDURE VALIDATE_LOGGED_USER_RIGHTS
18 (p_proposal_id IN NUMBER
19 ,p_logged_user_id IN NUMBER
20 ,x_return_status OUT NOCOPY VARCHAR2);
21
22 --------------------------------------------------------------------------------------
23 procedure start_approval(p_proposal_id in number,
24 p_error_message out NOCOPY varchar2,
25 p_return_status out NOCOPY varchar2);
26
27 ------------------------------------------------------------------------------------------
28 procedure get_business_rules(p_rule_type in varchar2,
29 p_run_id in out NOCOPY number,
30 p_invalid_flag out NOCOPY varchar2,
31 p_rules_found out NOCOPY varchar2,
32 p_error_message out NOCOPY varchar2);
33
34 -------------------------------------------------------------------------------------------
35 function execute_business_rule(p_rule_id in number)
36 return varchar2;
37
38 -----------------------------------------------------------------------------------------
39 function execute_line(p_expression_type in varchar2,
40 p_lvalue in varchar2,
41 p_operator in varchar2,
42 p_rvalue_id in varchar2)
43 return varchar2;
44
45 -----------------------------------------------------------------------------------------
46 function found_string(p_operator in varchar2)
47 return varchar2;
48
49 ----------------------------------------------------------------------------------------
50 function not_found_string(p_operator in varchar2)
51 return varchar2;
52
53 ----------------------------------------------------------------------------------------
54 function execute_dynamic_sql(p_select_stmt in varchar2)
55 return varchar2;
56
57 -----------------------------------------------------------------------------------------
58 function get_parent_org_id(l_org_id in number)
59 return number;
60
61 -------------------------------------------------------------------------------------------
62 procedure assign_so_role(p_signing_official_id in number,
63 p_admin_official_id in number);
64
65 ------------------------------------------------------------------------------------------
66 procedure populate_local_wf_tables(p_run_id in number);
67
68
69 end igw_proposal_approval;