1 PACKAGE AMW_FINSTMT_CERT_MIG_PKG AUTHID CURRENT_USER AS
2 /* $Header: amwfmigs.pls 120.0 2005/09/09 14:49:57 appldev noship $ */
3
4 PROCEDURE POPULATE_PROC_HIERARCHY(
5 p_api_version_number IN NUMBER := 1.0,
6 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
7 p_commit IN VARCHAR2 := FND_API.g_false,
8 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
9 P_CERTIFICATION_ID IN NUMBER,
10 P_PROCESS_ID IN NUMBER,
11 P_ORGANIZATION_ID IN NUMBER,
12 p_account_process_flag IN VARCHAR2,
13 x_return_status OUT nocopy VARCHAR2,
14 x_msg_count OUT nocopy NUMBER,
15 x_msg_data OUT nocopy VARCHAR2
16 );
17
18 PROCEDURE INSERT_FIN_CERT_SCOPE(
19 p_api_version_number IN NUMBER := 1.0,
20 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
21 p_commit IN VARCHAR2 := FND_API.g_false,
22 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23 p_certification_id IN NUMBER,
24 x_return_status OUT nocopy VARCHAR2,
25 x_msg_count OUT nocopy NUMBER,
26 x_msg_data OUT nocopy VARCHAR2
27 );
28
29 PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
30 p_api_version_number IN NUMBER := 1.0,
31 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
32 p_commit IN VARCHAR2 := FND_API.g_false,
33 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
34 p_certification_id IN NUMBER,
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 Populate_Fin_Ctrl_Ass_Sum_M(
41 p_api_version_number IN NUMBER := 1.0,
42 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
43 p_commit IN VARCHAR2 := FND_API.g_false,
44 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
45 p_certification_id IN NUMBER,
46 x_return_status OUT nocopy VARCHAR2,
47 x_msg_count OUT nocopy NUMBER,
48 x_msg_data OUT nocopy VARCHAR2
49 );
50
51 PROCEDURE Populate_Fin_AP_Ass_Sum_M(
52 p_api_version_number IN NUMBER := 1.0,
53 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
54 p_commit IN VARCHAR2 := FND_API.g_false,
55 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
56 p_certification_id IN NUMBER,
57 x_return_status OUT nocopy VARCHAR2,
58 x_msg_count OUT nocopy NUMBER,
59 x_msg_data OUT nocopy VARCHAR2
60 );
61
62 PROCEDURE INSERT_FIN_RISK(
63 p_api_version_number IN NUMBER := 1.0,
64 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65 p_commit IN VARCHAR2 := FND_API.g_false,
66 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
67 p_certification_id IN NUMBER,
68 x_return_status OUT nocopy VARCHAR2,
69 x_msg_count OUT nocopy NUMBER,
70 x_msg_data OUT nocopy VARCHAR2
71 );
72
73 PROCEDURE INSERT_FIN_CTRL(
74 p_api_version_number IN NUMBER := 1.0,
75 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
76 p_commit IN VARCHAR2 := FND_API.g_false,
77 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
78 p_certification_id IN NUMBER,
79 x_return_status OUT nocopy VARCHAR2,
80 x_msg_count OUT nocopy NUMBER,
81 x_msg_data OUT nocopy VARCHAR2
82 );
83
84 FUNCTION Get_Proc_Verified_M
85 (
86 P_CERTIFICATION_ID in number,
87 P_STATEMENT_GROUP_ID in number,
88 P_FINANCIAL_STATEMENT_ID in number,
89 P_FINANCIAL_ITEM_ID in number,
90 P_ACCOUNT_GROUP_ID in number,
91 P_ACCOUNT_ID in number,
92 P_OBJECT_TYPE in varchar2) RETURN Number;
93
94 FUNCTION Get_ORG_EVALUATED_M
95 (
96 P_CERTIFICATION_ID in number,
97 P_STATEMENT_GROUP_ID in number,
98 P_FINANCIAL_STATEMENT_ID in number,
99 P_FINANCIAL_ITEM_ID in number,
100 P_ACCOUNT_GROUP_ID in number,
101 P_ACCOUNT_ID in number,
102 P_OBJECT_TYPE in varchar2) RETURN Number;
103
104 FUNCTION Get_RISKS_VERIFIED_M
105 (
106 P_CERTIFICATION_ID in number,
107 P_STATEMENT_GROUP_ID in number,
108 P_FINANCIAL_STATEMENT_ID in number,
109 P_FINANCIAL_ITEM_ID in number,
110 P_ACCOUNT_GROUP_ID in number,
111 P_ACCOUNT_ID in number,
112 P_OBJECT_TYPE in varchar2) RETURN Number;
113
114 FUNCTION Get_CONTROLS_VERIFIED_M
115 (
116 P_CERTIFICATION_ID in number,
117 P_STATEMENT_GROUP_ID in number,
118 P_FINANCIAL_STATEMENT_ID in number,
119 P_FINANCIAL_ITEM_ID in number,
120 P_ACCOUNT_GROUP_ID in number,
121 P_ACCOUNT_ID in number,
122 P_OBJECT_TYPE in varchar2 )RETURN Number;
123
124
125 END AMW_FINSTMT_CERT_MIG_PKG;