[Home] [Help]
PACKAGE: APPS.IGW_PROP_APPROVALS_PVT
Source
1 PACKAGE IGW_PROP_APPROVALS_PVT AUTHID CURRENT_USER as
2 /* $Header: igwvpaps.pls 115.3 2002/11/14 18:51:35 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 procedure get_business_rules(p_rule_type in varchar2,
28 p_run_id in out NOCOPY number,
29 p_invalid_flag out NOCOPY varchar2,
30 p_rules_found out NOCOPY varchar2,
31 p_error_message out NOCOPY varchar2);
32
33 function execute_business_rule(p_rule_id in number)
34 return varchar2;
35
36 function execute_line(p_expression_type in varchar2,
37 p_lvalue in varchar2,
38 p_operator in varchar2,
39 p_rvalue_id in varchar2)
40 return varchar2;
41
42 function found_string(p_operator in varchar2)
43 return varchar2;
44
45 function not_found_string(p_operator in varchar2)
46 return varchar2;
47
48 function execute_dynamic_sql(p_select_stmt in varchar2)
49 return varchar2;
50
51 function get_parent_org_id(l_org_id in number)
52 return number;
53
54 procedure assign_so_role(p_signing_official_id in number,
55 p_admin_official_id in number);
56
57 procedure populate_local_wf_tables(p_run_id in number);
58
59
60 END IGW_PROP_APPROVALS_PVT;