1 PACKAGE AMW_CONTROLS_PAGE_PKG AUTHID CURRENT_USER as
2 /* $Header: amwcnpgs.pls 120.0 2005/05/31 20:17:18 appldev noship $ */
3 FUNCTION OBJECTIVE_PRESENT (P_CONTROL_REV_ID IN NUMBER,
4 P_OBJECTIVE_CODE IN VARCHAR2) RETURN VARCHAR2;
5
6 FUNCTION new_OBJECTIVE_PRESENT (P_CONTROL_REV_ID IN NUMBER,
7 P_OBJECTIVE_CODE IN VARCHAR2) RETURN VARCHAR2;
8
9 -------------------------------------------------------------------------------------
10 FUNCTION preventive_control_PRESENT (P_CONTROL_REV_ID IN NUMBER)
11 RETURN VARCHAR2;
12
13 -------------------------------------------------------------------------------------
14 FUNCTION GET_OBJ (P_CONTROL_REV_ID IN NUMBER,P_TAG_NUM IN NUMBER)
15 RETURN VARCHAR2;
16
17 -------------------------------------------------------------------------------------
18 FUNCTION ASSERTION_PRESENT (P_CONTROL_REV_ID IN NUMBER,
19 P_ASSERTION_CODE IN VARCHAR2) RETURN VARCHAR2;
20
21 -------------------------------------------------------------------------------------
22 FUNCTION new_ASSERTION_PRESENT (P_CONTROL_REV_ID IN NUMBER,
23 P_ASSERTION_CODE IN VARCHAR2) RETURN VARCHAR2;
24
25 -------------------------------------------------------------------------------------
26 FUNCTION component_PRESENT (P_CONTROL_REV_ID IN NUMBER,
27 P_component_CODE IN VARCHAR2) RETURN VARCHAR2;
28
29 -------------------------------------------------------------------------------------
30 FUNCTION new_component_PRESENT (P_CONTROL_REV_ID IN NUMBER,
31 P_component_CODE IN VARCHAR2) RETURN VARCHAR2;
32
33 -------------------------------------------------------------------------------------------
34 FUNCTION GET_LOOKUP_VALUE(p_lookup_type in varchar2,
35 p_lookup_code in varchar2) return varchar2;
36
37 -------------------------------------------------------------------------------------------
38 FUNCTION association_exists (P_process_objective_ID IN NUMBER) RETURN VARCHAR2;
39
40 ------------------------------------------------------------------------------------------
41 FUNCTION GET_CONTROL_SOURCE (p_control_source_id varchar2,
42 p_control_type varchar2,
43 p_automation_type varchar2,
44 p_application_id number,
45 p_control_rev_id number) return varchar2;
46
47 ---------------------------------------------------------------------------------
48 PROCEDURE PROCESS_OBJECTIVE (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
51 p_select_flag IN VARCHAR2,
52 p_control_rev_id IN NUMBER,
53 p_objective_code IN VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2);
57 ----------------------------------------------------------------------------------
58 PROCEDURE PROCESS_ASSERTION (p_init_msg_list IN VARCHAR2,
59 p_commit IN VARCHAR2,
60 p_validate_only IN VARCHAR2,
61 p_select_flag IN VARCHAR2,
62 p_control_rev_id IN NUMBER,
63 p_assertion_code IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2);
67
68 ----------------------------------------------------------------------------------
69 PROCEDURE PROCESS_component (p_init_msg_list IN VARCHAR2,
70 p_commit IN VARCHAR2,
71 p_validate_only IN VARCHAR2,
72 p_select_flag IN VARCHAR2,
73 p_control_rev_id IN NUMBER,
74 p_component_code IN VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79 ----------------------------------------------------------------------------------
80 PROCEDURE delete_control_association (p_init_msg_list IN VARCHAR2,
81 p_commit IN VARCHAR2,
82 p_object_type IN VARCHAR2,
83 p_risk_association_id IN NUMBER,
84 p_orig_control_id in number,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
89 ----------------------------------------------------------------------------------
90 PROCEDURE delete_obj_assert_comp (p_init_msg_list IN VARCHAR2,
91 p_commit IN VARCHAR2,
92 p_control_rev_id in number,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97 --npanandi 11.16.2004
98 --enhancement bugfix: 3391157
99 ------------------------------------------------------------------------------------------------------------
100 FUNCTION IS_CONTROL_EFFECTIVE(
101 P_ORGANIZATION_ID IN NUMBER
102 ,P_CONTROL_ID IN NUMBER
103 ) RETURN VARCHAR2;
104
105 --npanandi 11.19.2004
106 --enhancement TO DISPLAY POLICY FOR A CONTROL
107 ------------------------------------------------------------------------------------------------------------
108 FUNCTION GET_POLICY(P_CONTROL_ID IN NUMBER) RETURN VARCHAR2;
109
110 --npanandi 11.19.2004
111 --enhancement TO ENABLE AUTO APPROVAL OF CTRL IF DISABLE WORKFLOW PROFILE
112 --OPTION IS SET TO YES
113 ------------------------------------------------------------------------------------------------------------
114 PROCEDURE IS_WKFLW_APPR_DISBLD(
115 P_CONTROL_REV_ID IN NUMBER
116 ,P_PROFILE_OPTION OUT NOCOPY VARCHAR2
117 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
118 ,x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 ---------------------------------------------------------------------
124 ----npanandi 12.02.2004: Added below function to get UnitOfMeasureTL
125 ----given UoM_Code, and UoM_Class (from Profile Option)
126 ---------------------------------------------------------------------
127 FUNCTION GET_UOM_TL(P_UOM_CODE IN VARCHAR2) RETURN VARCHAR2;
128
129 ---------------------------------------------------------------------
130 ----npanandi 12.03.2004: Added below function to check
131 ----if this Ctrl contains this CtrlPurposeCode or not
132 ---------------------------------------------------------------------
133 FUNCTION PURPOSE_PRESENT (
134 P_CONTROL_REV_ID IN NUMBER,
135 P_PURPOSE_CODE IN VARCHAR2) RETURN VARCHAR2;
136
137 ------------------------------------------------------------------------------------------------------------
138 FUNCTION NEW_PURPOSE_PRESENT (
139 P_CONTROL_REV_ID IN NUMBER,
140 P_PURPOSE_CODE IN VARCHAR2) RETURN VARCHAR2;
141
142 ---------------------------------------------------------------------
143 ----npanandi 12.03.2004: Added below function to insert
144 ----CtrlPurposeCode for this CtrlRevId
145 ---------------------------------------------------------------------
146 PROCEDURE PROCESS_PURPOSE(
147 p_init_msg_list IN VARCHAR2,
148 p_commit IN VARCHAR2,
149 p_validate_only IN VARCHAR2,
150 p_select_flag IN VARCHAR2,
151 p_control_rev_id IN NUMBER,
152 p_PURPOSE_code IN VARCHAR2,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2);
156
157 ---------------------------------------------------------------------
158 FUNCTION get_control_objective_rl(
159 p_process_id in number,
160 p_risk_id in number,
161 p_control_id in number,
162 p_rev in number) RETURN VARCHAR2;
163 ---------------------------------------------------------------------
164
165 END AMW_CONTROLS_PAGE_PKG;