[Home] [Help]
PACKAGE: APPS.FEM_UD_PKG
Source
1 PACKAGE fem_ud_pkg AS
2 /* $Header: fem_ud_eng.pls 120.3.12010000.2 2008/10/08 18:46:33 huli ship $ */
3
4 type pl_register_record is record (
5 object_id fem_object_catalog_b.object_id%TYPE,
6 request_id fem_pl_requests.request_id%TYPE,
7 cal_period_id fem_pl_requests.cal_period_id%TYPE,
8 ledger_id fem_pl_requests.ledger_id%TYPE,
9 dataset_io_obj_def_id fem_pl_requests.DATASET_IO_OBJ_DEF_ID%TYPE,
10 output_dataset_code fem_pl_requests.output_dataset_code%TYPE,
11 source_system_code fem_pl_requests.source_system_code%TYPE,
12 effective_date fem_pl_requests.effective_date%TYPE,
13 rule_set_obj_def_id fem_pl_requests.rule_set_obj_def_id%TYPE,
14 user_id fnd_user.user_id%TYPE,
15 login_id fem_pl_requests.last_update_login%TYPE,
16 program_id fem_pl_requests.program_id%TYPE,
17 program_login_id fem_pl_requests.program_login_id%TYPE,
18 program_application_id fem_pl_requests.program_application_id%TYPE,
19 exec_status_code fem_pl_requests.exec_status_code%TYPE,
20 accurate_eff_dt_flg VARCHAR2(1)
21 );
22
23 TYPE dim_attr_record IS RECORD (
24 attr_table fem_xdim_dimensions_vl.ATTRIBUTE_TABLE_NAME%TYPE,
25 member_col fem_xdim_dimensions_vl.MEMBER_COL%TYPE,
26 attr_value_col_name fem_dim_attributes_b.ATTRIBUTE_VALUE_COLUMN_NAME%TYPE
27 );
28
29
30 PROCEDURE Get_Put_Messages (p_msg_count IN NUMBER,
31 p_msg_data IN VARCHAR2,
32 p_user_msg IN VARCHAR2,
33 p_module IN VARCHAR2);
34
35 PROCEDURE create_undo_list (x_undo_list_obj_id OUT NOCOPY NUMBER,
36 x_undo_list_obj_def_id OUT NOCOPY NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_api_version IN NUMBER,
41 p_commit IN VARCHAR2,
42 p_undo_list_name IN VARCHAR2,
43 p_folder_id IN NUMBER,
44 p_include_dependencies_flag IN VARCHAR2,
45 p_ignore_dependency_errs_flag IN VARCHAR2,
46 p_execution_date IN DATE);
47
48 PROCEDURE delete_undo_list (x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_api_version IN NUMBER,
52 p_commit IN VARCHAR2,
53 p_undo_list_obj_id IN NUMBER);
54
55 PROCEDURE add_candidate (x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_api_version IN NUMBER,
59 p_commit IN VARCHAR2,
60 p_undo_list_obj_def_id IN NUMBER,
61 p_request_id IN NUMBER,
62 p_object_id IN NUMBER);
63
64
65 PROCEDURE remove_candidate (x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_api_version IN NUMBER,
69 p_commit IN VARCHAR2,
70 p_undo_list_obj_def_id IN NUMBER,
71 p_request_id IN NUMBER,
72 p_object_id IN NUMBER);
73
74 PROCEDURE report_cand_dependents (x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_request_id IN NUMBER,
77 p_object_id IN NUMBER,
78 p_dependency_type IN VARCHAR2);
79
80 PROCEDURE generate_cand_dependents (x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_api_version IN NUMBER,
84 p_commit IN VARCHAR2,
85 p_undo_list_obj_def_id IN NUMBER DEFAULT NULL,
86 p_request_id IN NUMBER,
87 p_object_id IN NUMBER,
88 p_dependency_type IN VARCHAR2,
89 p_ud_session_id IN NUMBER DEFAULT NULL,
90 p_preview_flag IN VARCHAR2 DEFAULT 'N');
91
92 PROCEDURE validate_candidates (x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_api_version IN NUMBER,
96 p_commit IN VARCHAR2,
97 p_undo_list_obj_def_id IN NUMBER DEFAULT NULL,
98 p_dependency_type IN VARCHAR2,
99 p_ud_session_id IN NUMBER DEFAULT NULL,
100 p_preview_flag IN VARCHAR2 DEFAULT 'N');
101
102 PROCEDURE perform_undo_actions (x_return_status OUT NOCOPY VARCHAR2,
103 p_undo_list_obj_def_id IN NUMBER,
104 p_obj_exec_type IN VARCHAR2,
105 p_request_id IN NUMBER,
106 p_object_id IN NUMBER);
107
108 PROCEDURE set_process_status (p_undo_list_obj_id IN NUMBER,
109 p_undo_list_obj_def_id IN NUMBER,
110 p_execution_status IN VARCHAR2);
111
112 PROCEDURE execute_undo_list (errbuf OUT NOCOPY VARCHAR2,
113 retcode OUT NOCOPY VARCHAR2,
114 p_undo_list_obj_id IN NUMBER);
115
116 PROCEDURE submit_undo_lists (errbuf OUT NOCOPY VARCHAR2,
117 retcode OUT NOCOPY VARCHAR2);
118
119 PROCEDURE undo_object_execution (errbuf OUT NOCOPY VARCHAR2,
120 retcode OUT NOCOPY VARCHAR2,
121 p_object_id IN NUMBER,
122 p_request_id IN NUMBER,
123 p_folder_id IN NUMBER,
124 p_include_dependencies_flag IN VARCHAR2,
125 p_ignore_dependency_errs_flag IN VARCHAR2);
126
127 PROCEDURE undo_all_obj_execs_in_request (errbuf OUT NOCOPY VARCHAR2,
128 retcode OUT NOCOPY VARCHAR2,
129 p_request_id IN NUMBER,
130 p_folder_id IN NUMBER,
131 p_include_dependencies_flag IN VARCHAR2,
132 p_ignore_dependency_errs_flag IN VARCHAR2);
133
134 PROCEDURE create_and_submit_prview_list (x_request_id OUT NOCOPY NUMBER,
135 x_undo_list_obj_id OUT NOCOPY NUMBER,
136 x_undo_list_obj_def_id OUT NOCOPY NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_api_version IN NUMBER,
141 p_undo_list_name IN VARCHAR2,
142 p_folder_id IN NUMBER,
143 p_ud_session_id IN NUMBER);
144
145 PROCEDURE insert_preview_candidates (x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_api_version IN NUMBER,
149 p_ud_session_id IN NUMBER,
150 p_request_ids IN FEM_NUMBER_TABLE,
151 p_object_ids IN FEM_NUMBER_TABLE,
152 p_commit IN VARCHAR2);
153
154
155 PROCEDURE Delete_Balances (
156 p_api_version IN NUMBER DEFAULT 1.0,
157 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
159 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_current_request_id IN NUMBER,
164 p_object_id IN NUMBER,
165 p_cal_period_id IN NUMBER,
166 p_ledger_id IN NUMBER,
167 p_dataset_code IN NUMBER);
168
169 PROCEDURE Remove_Process_Locks (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
172 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173 p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_request_id IN NUMBER,
178 p_object_id IN NUMBER);
179
180 PROCEDURE Repair_PL_Request (
181 errbuf out nocopy varchar2
182 ,retcode out nocopy varchar2
183 ,p_request_id in number default null
184 ,p_object_id in number default null
185 );
186
187
188 END fem_ud_pkg;