eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_MANAGE_LIFE_EVENTS dependencies on BEN_BATCH_PARAMETER

Line 111: l_ben_batch_parameter_exists BOOLEAN;

107: l_after_run_last_ben_report csr_last_ben_report%ROWTYPE;
108: l_before_run_last_ben_report csr_last_ben_report%ROWTYPE;
109:
110: l_benmngle_batch_parameter csr_benmngle_batch_parameter%ROWTYPE;
111: l_ben_batch_parameter_exists BOOLEAN;
112:
113: l_proc_step NUMBER(38,10):= 0;
114: l_proc_name VARCHAR2(61):= g_package_name||'abse_process';
115:

Line 130: PROCEDURE del_or_upd_ben_batch_parameter

126:
127: l_error_code fnd_new_messages.message_number%TYPE;
128: l_error_message ben_reporting.text%TYPE;
129:
130: PROCEDURE del_or_upd_ben_batch_parameter
131: (p_ben_batch_parameter_exists IN BOOLEAN
132: ,p_batch_parameter_id IN NUMBER
133: ,p_max_err_num IN NUMBER
134: )

Line 131: (p_ben_batch_parameter_exists IN BOOLEAN

127: l_error_code fnd_new_messages.message_number%TYPE;
128: l_error_message ben_reporting.text%TYPE;
129:
130: PROCEDURE del_or_upd_ben_batch_parameter
131: (p_ben_batch_parameter_exists IN BOOLEAN
132: ,p_batch_parameter_id IN NUMBER
133: ,p_max_err_num IN NUMBER
134: )
135: IS

Line 139: g_package_name||'del_or_upd_ben_batch_parameter';

135: IS
136:
137: l_proc_step NUMBER(38,10);
138: l_proc_name VARCHAR2(61):=
139: g_package_name||'del_or_upd_ben_batch_parameter';
140:
141: BEGIN
142:
143: IF g_debug THEN

Line 147: IF p_ben_batch_parameter_exists

143: IF g_debug THEN
144: debug_enter(l_proc_name);
145: END IF;
146:
147: IF p_ben_batch_parameter_exists
148: THEN -- update max_err_num to what it was before the run
149:
150: IF g_debug THEN
151: l_proc_step := 10;

Line 155: UPDATE ben_batch_parameter

151: l_proc_step := 10;
152: debug(l_proc_name,l_proc_step);
153: END IF;
154:
155: UPDATE ben_batch_parameter
156: SET max_err_num = p_max_err_num
157: WHERE batch_parameter_id = p_batch_parameter_id;
158:
159: IF g_debug THEN

Line 173: DELETE FROM ben_batch_parameter WHERE batch_parameter_id = p_batch_parameter_id;

169: debug(l_proc_name,l_proc_step);
170: debug('p_batch_parameter_id:'||p_batch_parameter_id);
171: END IF;
172:
173: DELETE FROM ben_batch_parameter WHERE batch_parameter_id = p_batch_parameter_id;
174:
175: IF g_debug THEN
176: debug(SQL%ROWCOUNT||' rows deleted.');
177: l_proc_step := 25;

Line 188: END del_or_upd_ben_batch_parameter;

184: IF g_debug THEN
185: debug_exit(l_proc_name);
186: END IF;
187:
188: END del_or_upd_ben_batch_parameter;
189:
190: PROCEDURE get_last_ben_report
191: (p_person_id IN NUMBER
192: ,p_process_date IN DATE

Line 234: 1. retrieve ben_batch_parameter for BENMNGLE

230: END IF;
231:
232: -- error handling improvements
233: /*
234: 1. retrieve ben_batch_parameter for BENMNGLE
235: 2. set max error count to 1, insert if a row did not exist in ben_batch_param
236: 3. count the number of ben_reporting entries for this person
237: -- to count try join with ben_benefit_actions
238: 4. set audit flag to Y

Line 261: l_ben_batch_parameter_exists := TRUE;

257: l_proc_step := 10;
258: debug(l_proc_name,l_proc_step);
259: END IF;
260:
261: l_ben_batch_parameter_exists := TRUE;
262: UPDATE ben_batch_parameter
263: SET max_err_num = 1
264: WHERE batch_parameter_id = l_benmngle_batch_parameter.batch_parameter_id;
265:

Line 262: UPDATE ben_batch_parameter

258: debug(l_proc_name,l_proc_step);
259: END IF;
260:
261: l_ben_batch_parameter_exists := TRUE;
262: UPDATE ben_batch_parameter
263: SET max_err_num = 1
264: WHERE batch_parameter_id = l_benmngle_batch_parameter.batch_parameter_id;
265:
266: ELSE

Line 273: l_ben_batch_parameter_exists := FALSE;

269: l_proc_step := 20;
270: debug(l_proc_name,l_proc_step);
271: END IF;
272:
273: l_ben_batch_parameter_exists := FALSE;
274: INSERT INTO ben_batch_parameter
275: (batch_parameter_id -- NOT NULL NUMBER(15)
276: ,batch_exe_cd -- VARCHAR2(30)
277: ,business_group_id -- NOT NULL NUMBER(15)

Line 274: INSERT INTO ben_batch_parameter

270: debug(l_proc_name,l_proc_step);
271: END IF;
272:
273: l_ben_batch_parameter_exists := FALSE;
274: INSERT INTO ben_batch_parameter
275: (batch_parameter_id -- NOT NULL NUMBER(15)
276: ,batch_exe_cd -- VARCHAR2(30)
277: ,business_group_id -- NOT NULL NUMBER(15)
278: ,thread_cnt_num -- NUMBER(15)

Line 288: SELECT ben_batch_parameter_s.NEXTVAL --batch_parameter_id

284: ,created_by -- NUMBER(15)
285: ,creation_date -- DATE
286: ,object_version_number -- NUMBER(9)
287: )
288: SELECT ben_batch_parameter_s.NEXTVAL --batch_parameter_id
289: ,'BENMNGLE' --batch_exe_cd
290: ,p_business_group_id --business_group_id
291: ,NULL --thread_cnt_num
292: ,1 --max_err_num

Line 444: del_or_upd_ben_batch_parameter

440: l_proc_step := 80;
441: debug(l_proc_name,l_proc_step);
442: END IF;
443:
444: del_or_upd_ben_batch_parameter
445: (l_ben_batch_parameter_exists
446: ,l_benmngle_batch_parameter.batch_parameter_id
447: ,l_benmngle_batch_parameter.max_err_num
448: );

Line 445: (l_ben_batch_parameter_exists

441: debug(l_proc_name,l_proc_step);
442: END IF;
443:
444: del_or_upd_ben_batch_parameter
445: (l_ben_batch_parameter_exists
446: ,l_benmngle_batch_parameter.batch_parameter_id
447: ,l_benmngle_batch_parameter.max_err_num
448: );
449:

Line 540: del_or_upd_ben_batch_parameter

536: debug(l_proc_name,-990);
537: debug('l_batch_parameter_id:'||l_benmngle_batch_parameter.batch_parameter_id);
538: END IF;
539:
540: del_or_upd_ben_batch_parameter
541: (l_ben_batch_parameter_exists
542: ,l_benmngle_batch_parameter.batch_parameter_id
543: ,l_benmngle_batch_parameter.max_err_num
544: );

Line 541: (l_ben_batch_parameter_exists

537: debug('l_batch_parameter_id:'||l_benmngle_batch_parameter.batch_parameter_id);
538: END IF;
539:
540: del_or_upd_ben_batch_parameter
541: (l_ben_batch_parameter_exists
542: ,l_benmngle_batch_parameter.batch_parameter_id
543: ,l_benmngle_batch_parameter.max_err_num
544: );
545:

Line 609: -- to ensure that the changes to ben_batch_parameters are applied.

605: debug_exit(l_proc_name);
606: END IF;
607:
608: COMMIT; -- why ??
609: -- to ensure that the changes to ben_batch_parameters are applied.
610:
611: fnd_message.raise_error;
612:
613: END abse_process;