[Home] [Help]
40:
41: l_proc VARCHAR2(120) := g_package || 'setup_balance_table';
42: BEGIN
43:
44: hr_utility.set_location('Entering ' || l_proc,10);
45: hr_utility.set_location('Step ' || l_proc,20);
46:
47: g_balance_name(1).balance_name := 'Regular Earnings';
48: g_balance_name(2).balance_name := 'Irregular Earnings';
41: l_proc VARCHAR2(120) := g_package || 'setup_balance_table';
42: BEGIN
43:
44: hr_utility.set_location('Entering ' || l_proc,10);
45: hr_utility.set_location('Step ' || l_proc,20);
46:
47: g_balance_name(1).balance_name := 'Regular Earnings';
48: g_balance_name(2).balance_name := 'Irregular Earnings';
49: g_balance_name(3).balance_name := 'Overtime Payments';
77:
78: g_balance_name(28).balance_name := 'Annual Leave and Bank Holiday Hours';
79: g_balance_name(29).balance_name := 'Annual Leave and Bank Holiday Days';
80:
81: hr_utility.set_location('Step = ' || l_proc,30);
82:
83: FOR l_index IN 1 .. g_balance_name.COUNT
84: LOOP
85:
83: FOR l_index IN 1 .. g_balance_name.COUNT
84: LOOP
85:
86: l_dimension := '_ASG_QTD';
87: hr_utility.set_location('l_index = ' || l_index,30);
88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);
89: hr_utility.set_location('l_dimension = ' || l_dimension,30);
90:
91: l_index_id := l_index_id +1;
84: LOOP
85:
86: l_dimension := '_ASG_QTD';
87: hr_utility.set_location('l_index = ' || l_index,30);
88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);
89: hr_utility.set_location('l_dimension = ' || l_dimension,30);
90:
91: l_index_id := l_index_id +1;
92: OPEN csr_balance_dimension(g_balance_name(l_index).balance_name,
85:
86: l_dimension := '_ASG_QTD';
87: hr_utility.set_location('l_index = ' || l_index,30);
88: hr_utility.set_location('balance_name = ' || g_balance_name(l_index).balance_name,30);
89: hr_utility.set_location('l_dimension = ' || l_dimension,30);
90:
91: l_index_id := l_index_id +1;
92: OPEN csr_balance_dimension(g_balance_name(l_index).balance_name,
93: l_dimension);
101: END IF;
102:
103: CLOSE csr_balance_dimension;
104:
105: hr_utility.set_location('Balance Name = ' || g_def_bal_id(l_index_id).balance_name,30);
106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);
107:
108: END LOOP;
109:
102:
103: CLOSE csr_balance_dimension;
104:
105: hr_utility.set_location('Balance Name = ' || g_def_bal_id(l_index_id).balance_name,30);
106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);
107:
108: END LOOP;
109:
110: hr_utility.set_location('Step ' || l_proc,50);
106: hr_utility.set_location('defined_balance_id = ' || g_def_bal_id(l_index_id).defined_balance_id,30);
107:
108: END LOOP;
109:
110: hr_utility.set_location('Step ' || l_proc,50);
111:
112: hr_utility.set_location('Leaving ' || l_proc,60);
113:
114: END setup_balance_table;
108: END LOOP;
109:
110: hr_utility.set_location('Step ' || l_proc,50);
111:
112: hr_utility.set_location('Leaving ' || l_proc,60);
113:
114: END setup_balance_table;
115: /* 9719281 */
116: --
246:
247:
248: BEGIN
249:
250: hr_utility.set_location('Entering ' || l_proc, 100);
251: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);
252:
253: OPEN csr_parameter_info
254: (
247:
248: BEGIN
249:
250: hr_utility.set_location('Entering ' || l_proc, 100);
251: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);
252:
253: OPEN csr_parameter_info
254: (
255: p_payroll_action_id,
257: );
258: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
259: CLOSE csr_parameter_info;
260:
261: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);
262: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
263:
264: IF p_token_name = 'BG_ID' THEN
265: p_token_value := l_business_group_id;
258: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
259: CLOSE csr_parameter_info;
260:
261: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);
262: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
263:
264: IF p_token_name = 'BG_ID' THEN
265: p_token_value := l_business_group_id;
266: hr_utility.set_location('p_token_name '||p_token_name,125);
262: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
263:
264: IF p_token_name = 'BG_ID' THEN
265: p_token_value := l_business_group_id;
266: hr_utility.set_location('p_token_name '||p_token_name,125);
267: /*6856473 */
268:
269: ELSIF p_token_name= 'COMMENTS' THEN
270: hr_utility.set_location('comments before replace ' || TO_CHAR(l_token_value), 120);
266: hr_utility.set_location('p_token_name '||p_token_name,125);
267: /*6856473 */
268:
269: ELSIF p_token_name= 'COMMENTS' THEN
270: hr_utility.set_location('comments before replace ' || TO_CHAR(l_token_value), 120);
271: l_token_name:=p_token_name||'=';
272: OPEN csr_comments
273: (
274: p_payroll_action_id,
275: l_token_name /* 7367314QA */
276: );
277: FETCH csr_comments INTO l_token_value;
278: CLOSE csr_comments;
279: hr_utility.set_location('comments after replace ' || TO_CHAR(l_token_value), 120);
280: p_token_value := l_token_value;
281: ELSE
282: p_token_value := l_token_value;
283: --7367314
288: p_token_value := '0' ;
289: END IF;
290: END IF;
291: --7367314
292: hr_utility.set_location('p_token_name '||p_token_name,130);
293: END IF;
294:
295: hr_utility.set_location('Leaving ' || l_proc, 135);
296: --
291: --7367314
292: hr_utility.set_location('p_token_name '||p_token_name,130);
293: END IF;
294:
295: hr_utility.set_location('Leaving ' || l_proc, 135);
296: --
297: EXCEPTION
298: WHEN others THEN
299: hr_utility.set_location('Leaving' || l_proc,140);
295: hr_utility.set_location('Leaving ' || l_proc, 135);
296: --
297: EXCEPTION
298: WHEN others THEN
299: hr_utility.set_location('Leaving' || l_proc,140);
300: p_token_value := NULL;
301: --
302: END get_parameters;
303: -----------------------------------------------------------------------
340: l_occupational_catg VARCHAR2(50);
341: l_cur_inc_exc_flag_rec cur_inc_exc_flag%rowtype;
342:
343: BEGIN
344: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT.get_all_parameters ', 200);
345:
346: get_parameters(p_payroll_action_id,'REP_GROUP',p_rep_group);
347: get_parameters(p_payroll_action_id,'PAYROLL',p_payroll_id);
348: get_parameters(p_payroll_action_id,'YEAR',p_year);
355: get_parameters(p_payroll_action_id,'DDATE',p_declare_date);
356: get_parameters(p_payroll_action_id,'ADD_CHANGE',p_change_add);
357: get_parameters(p_payroll_action_id,'COMMENTS',p_comments);
358:
359: hr_utility.set_location(' After last get_parameters call ', 210);
360:
361: IF p_quarter = '1' THEN
362: g_qtr_start_date := to_date('01/01/' || p_year,'DD/MM/RRRR');
363: g_qtr_end_date := to_date('31/03/' || p_year,'DD/MM/RRRR');
371: g_qtr_start_date := to_date('01/10/' || p_year,'DD/MM/RRRR');
372: g_qtr_end_date := to_date('31/12/' || p_year,'DD/MM/RRRR');
373: END IF;
374:
375: hr_utility.set_location(' After populating the Quarter dates. ', 220);
376:
377: OPEN cur_nat_min_wg;
378: FETCH cur_nat_min_wg INTO g_ie_nat_min_wage_rate;
379: CLOSE cur_nat_min_wg;
377: OPEN cur_nat_min_wg;
378: FETCH cur_nat_min_wg INTO g_ie_nat_min_wage_rate;
379: CLOSE cur_nat_min_wg;
380:
381: hr_utility.set_location(' After cur_nat_min_wg Cursor ', 230);
382: hr_utility.set_location(' g_ie_nat_min_wage_rate '||g_ie_nat_min_wage_rate, 230);
383:
384: OPEN cur_inc_exc_flag;
385: FETCH cur_inc_exc_flag INTO l_cur_inc_exc_flag_rec;
378: FETCH cur_nat_min_wg INTO g_ie_nat_min_wage_rate;
379: CLOSE cur_nat_min_wg;
380:
381: hr_utility.set_location(' After cur_nat_min_wg Cursor ', 230);
382: hr_utility.set_location(' g_ie_nat_min_wage_rate '||g_ie_nat_min_wage_rate, 230);
383:
384: OPEN cur_inc_exc_flag;
385: FETCH cur_inc_exc_flag INTO l_cur_inc_exc_flag_rec;
386: CLOSE cur_inc_exc_flag;
386: CLOSE cur_inc_exc_flag;
387:
388: g_exc_inc := l_cur_inc_exc_flag_rec.inc_or_exc;
389:
390: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
391: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
387:
388: g_exc_inc := l_cur_inc_exc_flag_rec.inc_or_exc;
389:
390: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
391: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
388: g_exc_inc := l_cur_inc_exc_flag_rec.inc_or_exc;
389:
390: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
391: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
389:
390: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
391: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
390: hr_utility.set_location(' After cur_inc_exc_flag Cursor ', 235);
391: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
391: hr_utility.set_location(' l_cur_inc_exc_flag_rec.inc_or_exc '||l_cur_inc_exc_flag_rec.inc_or_exc, 235);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
392: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
393: hr_utility.set_location(' REP_GROUP = '||p_rep_group,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
394: hr_utility.set_location(' PAYROLL = '||p_payroll_id,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
395: hr_utility.set_location(' YEAR = '||p_year,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
396: hr_utility.set_location(' QUARTER = '||p_quarter,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
404: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
397: hr_utility.set_location(' ASSIGNMENT_SET_ID = '||p_assignment_set_id,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
404: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
405: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
398: hr_utility.set_location(' OCCUPATION CATEGORY = '||p_occupational_category,240);
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
404: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
405: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
406:
399: hr_utility.set_location(' EMPLOYER = '||p_employer_id,240);
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
404: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
405: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
406:
407: IF p_occupational_category IS NOT NULL THEN
400: hr_utility.set_location(' REPORT TYPE = '||p_report_type,240);
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
404: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
405: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
406:
407: IF p_occupational_category IS NOT NULL THEN
408: --g_occupational_category_M_C_P :=
401: hr_utility.set_location(' DDATE = '||p_declare_date,240);
402: hr_utility.set_location(' ADD_CHANGE = '||p_change_add,240);
403: hr_utility.set_location(' COMMENTS = '||p_comments,240);
404: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,240);
405: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,240);
406:
407: IF p_occupational_category IS NOT NULL THEN
408: --g_occupational_category_M_C_P :=
409: /*NVL(hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','MPAP',substr(p_occupational_category,-2,length(p_occupational_category)),g_qtr_start_date),
424:
425:
426: END IF;
427:
428: hr_utility.set_location(' g_occupational_category_M_C_P = '||g_occupational_category_M_C_P,245);
429:
430: IF p_payroll_id IS NOT NULL THEN
431: g_where_clause :=
432: ' and papf.payroll_id = '||to_char(p_payroll_id);
470: g_where_clause_asg_set := ' and 1=1 ';
471: END IF;
472:
473:
474: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
475: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
476: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
477:
478: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
471: END IF;
472:
473:
474: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
475: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
476: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
477:
478: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
479:
472:
473:
474: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
475: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
476: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
477:
478: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
479:
480: EXCEPTION
474: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,250);
475: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,260);
476: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause_asg_set,265);
477:
478: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
479:
480: EXCEPTION
481: WHEN Others THEN
482: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);
478: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters: ', 270);
479:
480: EXCEPTION
481: WHEN Others THEN
482: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);
483: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);
484: END get_all_parameters;
485:
486: -----------------------------------------------------------------------
479:
480: EXCEPTION
481: WHEN Others THEN
482: hr_utility.set_location(' Leaving: PAY_IE_EHECS_REPORT.get_all_parameters with errors: ', 280);
483: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);
484: END get_all_parameters;
485:
486: -----------------------------------------------------------------------
487: -- RANGE_CODE
625: BEGIN
626:
627: l_procedure_name := g_package||'range_code';
628:
629: hr_utility.set_location('Entering '||l_procedure_name, 300);
630: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
631:
632: sqlstr := ' select distinct p.person_id' ||
633: ' from per_people_f p,' ||
626:
627: l_procedure_name := g_package||'range_code';
628:
629: hr_utility.set_location('Entering '||l_procedure_name, 300);
630: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
631:
632: sqlstr := ' select distinct p.person_id' ||
633: ' from per_people_f p,' ||
634: ' pay_payroll_actions pa' ||
642: FETCH csr_archive_effective_date
643: INTO g_archive_effective_date;
644: CLOSE csr_archive_effective_date;
645:
646: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);
647:
648: get_all_parameters(pactid
649: ,g_rep_group
650: ,g_payroll_id
663: g_quarter := l_quarter;
664: g_occupational_category := l_occupational_category;
665: g_assignment_set_id := l_assignment_set_id;
666:
667: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);
668:
669: setup_balance_table;
670:
671: hr_utility.set_location('After the call of setup_balance_table in '||l_procedure_name, 320);
667: hr_utility.set_location('After fetching the g_archive_effective_date '||g_archive_effective_date, 310);
668:
669: setup_balance_table;
670:
671: hr_utility.set_location('After the call of setup_balance_table in '||l_procedure_name, 320);
672:
673: OPEN csr_employer_details(g_employer_id, g_business_group_id);
674: FETCH csr_employer_details INTO l_employer_details;
675: CLOSE csr_employer_details;
673: OPEN csr_employer_details(g_employer_id, g_business_group_id);
674: FETCH csr_employer_details INTO l_employer_details;
675: CLOSE csr_employer_details;
676:
677: hr_utility.set_location('After fetching the csr_employer_details ', 330);
678:
679: l_org_id := l_employer_details.org_id;
680: l_employer_name := l_employer_details.employer_name;
681: /* 9719281 */
690: --
691:
692: /* 9719281 */
693: --
694: hr_utility.set_location(' Before deleting the PL table pl_address. ',1100);
695: pl_address.delete;
696:
697: pl_address(1) := l_employer_details.addr1;
698: pl_address(2) := l_employer_details.addr2;
700: pl_address(4) := l_employer_details.City;
701: pl_address(5) := l_employer_details.COUNTY;
702: pl_address(6) := l_employer_details.Country_Name;
703:
704: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
705:
706: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
702: pl_address(6) := l_employer_details.Country_Name;
703:
704: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
705:
706: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
703:
704: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
705:
706: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
704: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
705:
706: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
712:
705:
706: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
712:
713: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
706: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
712:
713: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
714: pl_address_final.delete;
707: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
708: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
712:
713: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
714: pl_address_final.delete;
715: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
709: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
710: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
712:
713: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
714: pl_address_final.delete;
715: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
716:
717: FOR j in 1..pl_address.LAST
711: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
712:
713: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
714: pl_address_final.delete;
715: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
716:
717: FOR j in 1..pl_address.LAST
718: LOOP
719: IF pl_address(j) IS NOT NULL THEN
718: LOOP
719: IF pl_address(j) IS NOT NULL THEN
720: k:=k+1;
721: pl_address_final(k) := pl_address(j);
722: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);
723: END IF;
724: END LOOP;
725:
726: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
722: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);
723: END IF;
724: END LOOP;
725:
726: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
727:
728: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
729: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
730:
724: END LOOP;
725:
726: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
727:
728: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
729: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
730:
731:
732:
725:
726: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
727:
728: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
729: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
730:
731:
732:
733: IF pl_address_final.COUNT > 0 THEN
739: l_employer_details.addr5 := NULL; */
740:
741: FOR l in 1..pl_address_final.LAST
742: LOOP
743: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);
744: BEGIN
745: IF l = 1 THEN
746: hr_utility.set_location(' employer address .addr1 ',1100);
747: l_addr1 := pl_address_final(1);
742: LOOP
743: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);
744: BEGIN
745: IF l = 1 THEN
746: hr_utility.set_location(' employer address .addr1 ',1100);
747: l_addr1 := pl_address_final(1);
748: hr_utility.set_location('employer address .addr1 ',1101);
749: END IF;
750: --
744: BEGIN
745: IF l = 1 THEN
746: hr_utility.set_location(' employer address .addr1 ',1100);
747: l_addr1 := pl_address_final(1);
748: hr_utility.set_location('employer address .addr1 ',1101);
749: END IF;
750: --
751: IF l = 2 THEN
752: hr_utility.set_location(' employer address.addr2 ',1102);
748: hr_utility.set_location('employer address .addr1 ',1101);
749: END IF;
750: --
751: IF l = 2 THEN
752: hr_utility.set_location(' employer address.addr2 ',1102);
753: l_addr2 := pl_address_final(2);
754: hr_utility.set_location(' employer address .addr2 ',1103);
755: END IF;
756: --
750: --
751: IF l = 2 THEN
752: hr_utility.set_location(' employer address.addr2 ',1102);
753: l_addr2 := pl_address_final(2);
754: hr_utility.set_location(' employer address .addr2 ',1103);
755: END IF;
756: --
757: IF l = 3 THEN
758: hr_utility.set_location(' employer address.addr3 ',1104);
754: hr_utility.set_location(' employer address .addr2 ',1103);
755: END IF;
756: --
757: IF l = 3 THEN
758: hr_utility.set_location(' employer address.addr3 ',1104);
759: l_addr3 := pl_address_final(3);
760: hr_utility.set_location(' employer address .addr3 ',1105);
761: END IF;
762: --
756: --
757: IF l = 3 THEN
758: hr_utility.set_location(' employer address.addr3 ',1104);
759: l_addr3 := pl_address_final(3);
760: hr_utility.set_location(' employer address .addr3 ',1105);
761: END IF;
762: --
763: IF l = 4 THEN
764: hr_utility.set_location(' l_person_details.addr4 ',1106);
760: hr_utility.set_location(' employer address .addr3 ',1105);
761: END IF;
762: --
763: IF l = 4 THEN
764: hr_utility.set_location(' l_person_details.addr4 ',1106);
765: l_addr4 := pl_address_final(4);
766: hr_utility.set_location(' employer address .addr4 ',1107);
767: END IF;
768: IF l = 5 THEN
762: --
763: IF l = 4 THEN
764: hr_utility.set_location(' l_person_details.addr4 ',1106);
765: l_addr4 := pl_address_final(4);
766: hr_utility.set_location(' employer address .addr4 ',1107);
767: END IF;
768: IF l = 5 THEN
769: hr_utility.set_location(' l_person_details.addr5 ',1106);
770: l_addr5 := pl_address_final(5);
765: l_addr4 := pl_address_final(4);
766: hr_utility.set_location(' employer address .addr4 ',1107);
767: END IF;
768: IF l = 5 THEN
769: hr_utility.set_location(' l_person_details.addr5 ',1106);
770: l_addr5 := pl_address_final(5);
771: hr_utility.set_location(' employer address .addr5 ',1107);
772: END IF;
773: EXCEPTION
767: END IF;
768: IF l = 5 THEN
769: hr_utility.set_location(' l_person_details.addr5 ',1106);
770: l_addr5 := pl_address_final(5);
771: hr_utility.set_location(' employer address .addr5 ',1107);
772: END IF;
773: EXCEPTION
774: WHEN NO_DATA_FOUND THEN
775: NULL;
778: END IF;
779: --
780:
781:
782: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
783: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
784: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
785: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
786: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
779: --
780:
781:
782: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
783: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
784: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
785: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
786: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
787:
780:
781:
782: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
783: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
784: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
785: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
786: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
787:
788: OPEN csr_declarant(g_employer_id, g_business_group_id, l_year, l_quarter);
781:
782: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
783: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
784: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
785: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
786: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
787:
788: OPEN csr_declarant(g_employer_id, g_business_group_id, l_year, l_quarter);
789: FETCH csr_declarant INTO l_declarant;
782: hr_utility.set_location('After fetching the csr_employer_details l_org_id'||l_org_id, 330);
783: hr_utility.set_location('After fetching the csr_employer_details l_employer_name'||l_employer_name, 330);
784: hr_utility.set_location('After fetching the csr_employer_details l_addr1'||l_addr1, 330);
785: hr_utility.set_location('After fetching the csr_employer_details l_addr2'||l_addr2, 330);
786: hr_utility.set_location('After fetching the csr_employer_details l_addr3'||l_addr3, 330);
787:
788: OPEN csr_declarant(g_employer_id, g_business_group_id, l_year, l_quarter);
789: FETCH csr_declarant INTO l_declarant;
790: CLOSE csr_declarant;
793: l_declarant_position := l_declarant.position; -- bug 6850742
794: l_declarant_phone := l_declarant.phone; -- bug 6850742
795: l_declarant_email_add := l_declarant.email; -- bug 6850742
796:
797: hr_utility.set_location('After fetching the csr_declarant ', 340);
798: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
799: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
800: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
801: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
794: l_declarant_phone := l_declarant.phone; -- bug 6850742
795: l_declarant_email_add := l_declarant.email; -- bug 6850742
796:
797: hr_utility.set_location('After fetching the csr_declarant ', 340);
798: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
799: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
800: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
801: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
802: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
795: l_declarant_email_add := l_declarant.email; -- bug 6850742
796:
797: hr_utility.set_location('After fetching the csr_declarant ', 340);
798: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
799: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
800: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
801: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
802: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
803:
796:
797: hr_utility.set_location('After fetching the csr_declarant ', 340);
798: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
799: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
800: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
801: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
802: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
803:
804: OPEN csr_declarant_details(l_person_id);
797: hr_utility.set_location('After fetching the csr_declarant ', 340);
798: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
799: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
800: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
801: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
802: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
803:
804: OPEN csr_declarant_details(l_person_id);
805: FETCH csr_declarant_details into l_declarant_details;
798: hr_utility.set_location('After fetching the l_cbr_no '||l_cbr_no, 340);
799: hr_utility.set_location('After fetching the l_person_id '||l_person_id, 340);
800: hr_utility.set_location('l_declarant_position '||l_declarant_position, 340);
801: hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 340);
802: hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 340);
803:
804: OPEN csr_declarant_details(l_person_id);
805: FETCH csr_declarant_details into l_declarant_details;
806: CLOSE csr_declarant_details;
804: OPEN csr_declarant_details(l_person_id);
805: FETCH csr_declarant_details into l_declarant_details;
806: CLOSE csr_declarant_details;
807:
808: hr_utility.set_location('After fetching the csr_declarant_details ', 350);
809:
810: l_declarant_name := l_declarant_details.declarant_name;
811: /* bug 6850742*/
812: -- l_declarant_phone := l_declarant_details.declarant_phone;
812: -- l_declarant_phone := l_declarant_details.declarant_phone;
813: --l_declarant_email_add := l_declarant_details.declarant_email;
814: -- l_declarant_position := l_declarant_details.declarant_position;
815:
816: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
817: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
818: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
819: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
820:
813: --l_declarant_email_add := l_declarant_details.declarant_email;
814: -- l_declarant_position := l_declarant_details.declarant_position;
815:
816: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
817: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
818: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
819: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
820:
821: IF l_employer_name IS NULL THEN
814: -- l_declarant_position := l_declarant_details.declarant_position;
815:
816: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
817: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
818: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
819: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
820:
821: IF l_employer_name IS NULL THEN
822: l_errflag := 'Y';
815:
816: hr_utility.set_location('l_declarant_name '||l_declarant_name, 350);
817: --hr_utility.set_location('l_declarant_phone '||l_declarant_phone, 350);
818: --hr_utility.set_location('l_declarant_email_add '||l_declarant_email_add, 350);
819: --hr_utility.set_location('l_declarant_position '||l_declarant_position, 350);
820:
821: IF l_employer_name IS NULL THEN
822: l_errflag := 'Y';
823: --Fnd_file.put_line(FND_FILE.LOG,'Employer name is missing. Please enter it first.' );
839: --Fnd_file.put_line(FND_FILE.LOG,'Declarant details are missing. Please check for Name, Phone, Email, Position.' );
840: Fnd_file.put_line(FND_FILE.LOG,'You have not entered the declaration contact details. Enter the Name, Phone, Email and Position of the declaration contact.' );
841: END IF;
842:
843: hr_utility.set_location('l_errflag '||l_errflag, 370);
844:
845: IF l_errflag = 'Y' THEN
846: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
847: Raise l_ehecs_exception;
846: Fnd_file.put_line(FND_FILE.LOG,'Some mandatory data is misssing.' );
847: Raise l_ehecs_exception;
848: END IF;
849:
850: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);
851:
852: pay_action_information_api.create_action_information
853: ( p_action_information_id => l_action_info_id
854: ,p_action_context_id => pactid
880: ,p_action_information25 => l_declare_date
881: ,p_action_information26 => l_declarant_position
882: );
883:
884: hr_utility.set_location('After entering record for IE_EHECS_HEADER ', 390);
885:
886: hr_utility.set_location('Leaving '||l_procedure_name, 400);
887:
888: EXCEPTION
882: );
883:
884: hr_utility.set_location('After entering record for IE_EHECS_HEADER ', 390);
885:
886: hr_utility.set_location('Leaving '||l_procedure_name, 400);
887:
888: EXCEPTION
889: WHEN l_ehecs_exception THEN
890: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
886: hr_utility.set_location('Leaving '||l_procedure_name, 400);
887:
888: EXCEPTION
889: WHEN l_ehecs_exception THEN
890: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
891: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','EHECS Report errors out. Some mandatory values are missing.');
892: WHEN Others THEN
893: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
894: END range_code;
889: WHEN l_ehecs_exception THEN
890: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
891: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','EHECS Report errors out. Some mandatory values are missing.');
892: WHEN Others THEN
893: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,410);
894: END range_code;
895: -----------------------------------------------------------------------
896: -- ASSIGNMENT_ACTION_CODE
897: -----------------------------------------------------------------------
924: l_ass_check varchar2(1);
925: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';
926: BEGIN
927:
928: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);
929:
930: -- Get all the parameters
931: /*6978389 */
932: hr_utility.set_location('Before get_all_parameters',501);
928: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);
929:
930: -- Get all the parameters
931: /*6978389 */
932: hr_utility.set_location('Before get_all_parameters',501);
933: get_all_parameters(pactid
934: ,g_rep_group
935: ,g_payroll_id
936: ,g_year
942: ,g_report_type
943: ,g_declare_date
944: ,g_change_indicator
945: ,g_comments);
946: hr_utility.set_location('after get_all_parameters',502);
947: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
948: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
943: ,g_declare_date
944: ,g_change_indicator
945: ,g_comments);
946: hr_utility.set_location('after get_all_parameters',502);
947: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
948: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
951:
944: ,g_change_indicator
945: ,g_comments);
946: hr_utility.set_location('after get_all_parameters',502);
947: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
948: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
951:
952: --g_start_date := fnd_date.canonical_to_date(l_start_date);
945: ,g_comments);
946: hr_utility.set_location('after get_all_parameters',502);
947: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
948: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
951:
952: --g_start_date := fnd_date.canonical_to_date(l_start_date);
953: --g_end_date := fnd_date.canonical_to_date(l_end_date);
946: hr_utility.set_location('after get_all_parameters',502);
947: hr_utility.set_location(' g_qtr_start_date = '||g_qtr_start_date,505);
948: hr_utility.set_location(' g_qtr_end_date = '||g_qtr_end_date,505);
949: hr_utility.set_location(' g_business_group_id = '||g_business_group_id,505);
950: hr_utility.set_location(' g_employer_id = '||g_employer_id,505);
951:
952: --g_start_date := fnd_date.canonical_to_date(l_start_date);
953: --g_end_date := fnd_date.canonical_to_date(l_end_date);
954:
953: --g_end_date := fnd_date.canonical_to_date(l_end_date);
954:
955: -- g_pact_id := pactid;
956:
957: --hr_utility.set_location('after get_all_parameter called',225);
958: --hr_utility.set_location('report start date= '||g_start_date,300);
959:
960: hr_utility.set_location('Before building the dynamic query.',510);
961: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
954:
955: -- g_pact_id := pactid;
956:
957: --hr_utility.set_location('after get_all_parameter called',225);
958: --hr_utility.set_location('report start date= '||g_start_date,300);
959:
960: hr_utility.set_location('Before building the dynamic query.',510);
961: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
962: l_select_str :='select distinct paaf.assignment_id asgid
956:
957: --hr_utility.set_location('after get_all_parameter called',225);
958: --hr_utility.set_location('report start date= '||g_start_date,300);
959:
960: hr_utility.set_location('Before building the dynamic query.',510);
961: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
962: l_select_str :='select distinct paaf.assignment_id asgid
963: from per_all_assignments_f paaf,
964: per_all_people_f ppf,
986: ||g_where_clause
987: ||g_where_clause_asg_set
988: ||' Order by paaf.assignment_id';
989:
990: hr_utility.set_location('After building the dynamic query.',520);
991:
992: /*6978389 */
993: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
994:
993: Fnd_file.put_line(FND_FILE.LOG,'Dynamic Query:'||l_select_str );
994:
995: OPEN csr_get_asg FOR l_select_str; -- ref cursor
996: LOOP
997: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
998: FETCH csr_get_asg INTO l_assg_id;
999: EXIT WHEN csr_get_asg%NOTFOUND;
1000: SELECT pay_assignment_actions_s.nextval
1001: INTO lockingactid
1000: SELECT pay_assignment_actions_s.nextval
1001: INTO lockingactid
1002: FROM dual;
1003:
1004: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);
1005: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
1006: /* hr_nonrun_asact.insact(lockingactid => lockingactid
1007: ,assignid => l_assg_id
1008: ,pactid => pactid
1010: ,greid => NULL);
1011: */
1012:
1013: -- Insert assignment into PAY_TEMP_OBJECT_ACTION TABLE.
1014: hr_utility.set_location(' Before hr_nonrun_asact.insact call',550);
1015: hr_nonrun_asact.insact(lockingactid => lockingactid
1016: ,assignid => l_assg_id --asgrec.assignment_id --
1017: ,object_id => l_assg_id --asgrec.assignment_id --
1018: ,pactid => pactid
1018: ,pactid => pactid
1019: ,chunk => chunk
1020: ,greid => NULL);
1021: --,p_transient_action => TRUE);
1022: hr_utility.set_location(' After hr_nonrun_asact.insact call',560);
1023:
1024: END LOOP;-- ref cursor
1025:
1026: END assignment_action_code;
1040: WHERE payroll_action_id = pactid;
1041:
1042: BEGIN
1043:
1044: hr_utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.archive_init: ',600);
1045:
1046: OPEN csr_archive_effective_date(p_payroll_action_id);
1047: FETCH csr_archive_effective_date
1048: INTO g_archive_effective_date;
1047: FETCH csr_archive_effective_date
1048: INTO g_archive_effective_date;
1049: CLOSE csr_archive_effective_date;
1050:
1051: hr_utility.set_location('Before calling get_all_parameters ',610);
1052:
1053: get_all_parameters(p_payroll_action_id
1054: ,g_rep_group
1055: ,g_payroll_id
1063: ,g_declare_date
1064: ,g_change_indicator
1065: ,g_comments);
1066:
1067: hr_utility.set_location('After calling get_all_parameters ',620);
1068:
1069: setup_balance_table;
1070:
1071: hr_utility.set_location('After calling setup_balance_table ',630);
1067: hr_utility.set_location('After calling get_all_parameters ',620);
1068:
1069: setup_balance_table;
1070:
1071: hr_utility.set_location('After calling setup_balance_table ',630);
1072:
1073: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
1074:
1075: EXCEPTION
1069: setup_balance_table;
1070:
1071: hr_utility.set_location('After calling setup_balance_table ',630);
1072:
1073: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
1074:
1075: EXCEPTION
1076: WHEN Others THEN
1077: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
1073: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
1074:
1075: EXCEPTION
1076: WHEN Others THEN
1077: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
1078: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
1079:
1080: END archive_init;
1081: -----------------------------------------------------------------------
1074:
1075: EXCEPTION
1076: WHEN Others THEN
1077: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
1078: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
1079:
1080: END archive_init;
1081: -----------------------------------------------------------------------
1082: -- ARCHIVE_DATA
1086: IS
1087:
1088: BEGIN
1089:
1090: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1091: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
1092: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
1093:
1094: NUll;
1087:
1088: BEGIN
1089:
1090: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1091: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
1092: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
1093:
1094: NUll;
1095:
1088: BEGIN
1089:
1090: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1091: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
1092: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
1093:
1094: NUll;
1095:
1096: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1092: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
1093:
1094: NUll;
1095:
1096: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1097:
1098: END archive_data;
1099:
1100: PROCEDURE ehecs_main_proc(p_business_group_id IN VARCHAR2
1271:
1272: l_factor NUMBER :=1; /* 10040939 */
1273:
1274: BEGIN
1275: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);
1276:
1277: /*6856473*/
1278: hr_utility.set_location(' before calling get parameters ', 800);
1279:
1274: BEGIN
1275: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);
1276:
1277: /*6856473*/
1278: hr_utility.set_location(' before calling get parameters ', 800);
1279:
1280: get_parameters(p_payroll_action_id,'EMPLOYER',l_org_id);
1281: hr_utility.set_location(' before cursor csr_hours_per_day and org_id '||l_org_id, 801);
1282: OPEN csr_hours_per_day(l_org_id,p_business_group_id);
1277: /*6856473*/
1278: hr_utility.set_location(' before calling get parameters ', 800);
1279:
1280: get_parameters(p_payroll_action_id,'EMPLOYER',l_org_id);
1281: hr_utility.set_location(' before cursor csr_hours_per_day and org_id '||l_org_id, 801);
1282: OPEN csr_hours_per_day(l_org_id,p_business_group_id);
1283: FETCH csr_hours_per_day INTO l_hours_per_day;
1284: CLOSE csr_hours_per_day;
1285:
1282: OPEN csr_hours_per_day(l_org_id,p_business_group_id);
1283: FETCH csr_hours_per_day INTO l_hours_per_day;
1284: CLOSE csr_hours_per_day;
1285:
1286: hr_utility.set_location(' AFTER cursor csr_hours_per_day '||l_hours_per_day, 801);
1287:
1288: hr_utility.set_location(' Before Cursor cur_valid_asg', 810);
1289:
1290: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1284: CLOSE csr_hours_per_day;
1285:
1286: hr_utility.set_location(' AFTER cursor csr_hours_per_day '||l_hours_per_day, 801);
1287:
1288: hr_utility.set_location(' Before Cursor cur_valid_asg', 810);
1289:
1290: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1291: FETCH cur_valid_asg INTO l_valid_asg_rec;
1292: --EXIT WHEN cur_valid_asg%NOTFOUND;
1289:
1290: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1291: FETCH cur_valid_asg INTO l_valid_asg_rec;
1292: --EXIT WHEN cur_valid_asg%NOTFOUND;
1293: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1294: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1295: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1296:
1297: /* 10040939 start */
1290: OPEN cur_valid_asg(p_assignment_id, p_person_id);
1291: FETCH cur_valid_asg INTO l_valid_asg_rec;
1292: --EXIT WHEN cur_valid_asg%NOTFOUND;
1293: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1294: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1295: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1296:
1297: /* 10040939 start */
1298: IF l_valid_asg_rec.frequency='W' THEN
1291: FETCH cur_valid_asg INTO l_valid_asg_rec;
1292: --EXIT WHEN cur_valid_asg%NOTFOUND;
1293: hr_utility.set_location(' Inside Cursor cur_valid_asg', 820);
1294: hr_utility.set_location(' l_valid_asg_rec.assignment_id '||l_valid_asg_rec.assignment_id, 820);
1295: hr_utility.set_location(' l_valid_asg_rec.payroll_id '||l_valid_asg_rec.payroll_id, 820);
1296:
1297: /* 10040939 start */
1298: IF l_valid_asg_rec.frequency='W' THEN
1299: IF l_valid_asg_rec.PERIOD_TYPE='Week' THEN
1317: END IF;
1318: END IF;
1319: /* 10040939 end */
1320:
1321: hr_utility.set_location(' Before Cursor cur_valid_asg_act', 830);
1322:
1323: OPEN cur_valid_asg_act(l_valid_asg_rec.assignment_id, l_valid_asg_rec.payroll_id);
1324: FETCH cur_valid_asg_act INTO l_valid_asg_act_rec;
1325:
1322:
1323: OPEN cur_valid_asg_act(l_valid_asg_rec.assignment_id, l_valid_asg_rec.payroll_id);
1324: FETCH cur_valid_asg_act INTO l_valid_asg_act_rec;
1325:
1326: hr_utility.set_location(' Inside Cursor cur_valid_asg_act', 840);
1327:
1328: IF cur_valid_asg_act%FOUND THEN
1329: --IF l_valid_asg_act_rec.assignment_action_id IS NOT NULL
1330: --THEN
1339: FOR bal_index IN 1..g_def_bal_id.COUNT
1340: LOOP
1341: IF g_def_bal_id(bal_index).balance_name = 'Regular Earnings' THEN
1342:
1343: hr_utility.set_location(' Inside balance Loop ', 850);
1344: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1345: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1346:
1347: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1340: LOOP
1341: IF g_def_bal_id(bal_index).balance_name = 'Regular Earnings' THEN
1342:
1343: hr_utility.set_location(' Inside balance Loop ', 850);
1344: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1345: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1346:
1347: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1348: l_valid_asg_act_rec.assignment_action_id,
1341: IF g_def_bal_id(bal_index).balance_name = 'Regular Earnings' THEN
1342:
1343: hr_utility.set_location(' Inside balance Loop ', 850);
1344: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1345: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1346:
1347: l_regwg_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1348: l_valid_asg_act_rec.assignment_action_id,
1349: g_employer_id,
1351: null,
1352: null,
1353: null,
1354: null);
1355: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);
1356: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1357:
1358: hr_utility.set_location(' Inside balance Loop ', 850);
1359: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1354: null);
1355: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);
1356: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1357:
1358: hr_utility.set_location(' Inside balance Loop ', 850);
1359: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1360: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1361:
1362: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1355: hr_utility.set_location(' l_regwg_bal_val '|| l_regwg_bal_val, 850);
1356: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1357:
1358: hr_utility.set_location(' Inside balance Loop ', 850);
1359: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1360: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1361:
1362: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1363: l_valid_asg_act_rec.assignment_action_id,
1356: ELSIF g_def_bal_id(bal_index).balance_name = 'Irregular Earnings' THEN
1357:
1358: hr_utility.set_location(' Inside balance Loop ', 850);
1359: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1360: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1361:
1362: l_irrb_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1363: l_valid_asg_act_rec.assignment_action_id,
1364: g_employer_id,
1366: null,
1367: null,
1368: null,
1369: null);
1370: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);
1371: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1372:
1373: hr_utility.set_location(' Inside balance Loop ', 850);
1374: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1369: null);
1370: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);
1371: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1372:
1373: hr_utility.set_location(' Inside balance Loop ', 850);
1374: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1375: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1376:
1377: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1370: hr_utility.set_location(' l_irrb_bal_val '|| l_irrb_bal_val, 850);
1371: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1372:
1373: hr_utility.set_location(' Inside balance Loop ', 850);
1374: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1375: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1376:
1377: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1378: l_valid_asg_act_rec.assignment_action_id,
1371: ELSIF g_def_bal_id(bal_index).balance_name = 'Overtime Payments' THEN
1372:
1373: hr_utility.set_location(' Inside balance Loop ', 850);
1374: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1375: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1376:
1377: l_ovrt_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1378: l_valid_asg_act_rec.assignment_action_id,
1379: g_employer_id,
1381: null,
1382: null,
1383: null,
1384: null);
1385: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);
1386: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1387:
1388: hr_utility.set_location(' Inside balance Loop ', 850);
1389: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1384: null);
1385: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);
1386: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1387:
1388: hr_utility.set_location(' Inside balance Loop ', 850);
1389: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1390: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1391:
1392: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1385: hr_utility.set_location(' l_ovrt_bal_val '|| l_ovrt_bal_val, 850);
1386: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1387:
1388: hr_utility.set_location(' Inside balance Loop ', 850);
1389: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1390: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1391:
1392: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1393: l_valid_asg_act_rec.assignment_action_id,
1386: ELSIF g_def_bal_id(bal_index).balance_name = 'Paid Overtime Hours' THEN
1387:
1388: hr_utility.set_location(' Inside balance Loop ', 850);
1389: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1390: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1391:
1392: l_othr_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1393: l_valid_asg_act_rec.assignment_action_id,
1394: g_employer_id,
1396: null,
1397: null,
1398: null,
1399: null);
1400: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);
1401: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1402:
1403: hr_utility.set_location(' Inside balance Loop ', 850);
1404: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1399: null);
1400: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);
1401: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1402:
1403: hr_utility.set_location(' Inside balance Loop ', 850);
1404: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1405: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1406:
1407:
1400: hr_utility.set_location(' l_othr_bal_val '|| l_othr_bal_val, 850);
1401: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1402:
1403: hr_utility.set_location(' Inside balance Loop ', 850);
1404: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1405: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1406:
1407:
1408:
1401: ELSIF g_def_bal_id(bal_index).balance_name = 'Normal Working Hours' THEN
1402:
1403: hr_utility.set_location(' Inside balance Loop ', 850);
1404: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1405: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1406:
1407:
1408:
1409: /*6856473 added if conditions to check for salaried code*/
1407:
1408:
1409: /*6856473 added if conditions to check for salaried code*/
1410:
1411: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);
1412: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);
1413: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);
1414:
1415: IF(l_valid_asg_rec.hourly_or_salaried='S')
1408:
1409: /*6856473 added if conditions to check for salaried code*/
1410:
1411: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);
1412: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);
1413: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);
1414:
1415: IF(l_valid_asg_rec.hourly_or_salaried='S')
1416: THEN
1409: /*6856473 added if conditions to check for salaried code*/
1410:
1411: hr_utility.set_location(' l_valid_asg_rec.normal_hours '||l_valid_asg_rec.normal_hours, 850);
1412: hr_utility.set_location(' l_valid_asg_rec.frequency '||l_valid_asg_rec.frequency, 850);
1413: hr_utility.set_location(' l_valid_asg_rec.hourly_or_salaried '||l_valid_asg_rec.hourly_or_salaried, 850);
1414:
1415: IF(l_valid_asg_rec.hourly_or_salaried='S')
1416: THEN
1417: /* 9776525 */
1431: OR
1432: (l_valid_asg_rec.PERIOD_TYPE='Year' and l_valid_asg_rec.frequency='Y') /* 10040939 */
1433: )-- 9776525
1434: THEN
1435: hr_utility.set_location(' IF: l_valid_asg_rec.frequency '|| l_valid_asg_rec.frequency, 850);
1436: hr_utility.set_location(' IF: l_valid_asg_rec.PERIOD_TYPE '|| l_valid_asg_rec.PERIOD_TYPE, 850);
1437: hr_utility.set_location(' IF: l_valid_asg_rec.normal_hours '|| NVL(l_valid_asg_rec.normal_hours,0), 850);
1438: hr_utility.set_location(' IF: l_paid_pay_periods '|| l_paid_pay_periods, 850);
1439: hr_utility.set_location(' IF: l_factor '|| l_factor, 850);
1432: (l_valid_asg_rec.PERIOD_TYPE='Year' and l_valid_asg_rec.frequency='Y') /* 10040939 */
1433: )-- 9776525
1434: THEN
1435: hr_utility.set_location(' IF: l_valid_asg_rec.frequency '|| l_valid_asg_rec.frequency, 850);
1436: hr_utility.set_location(' IF: l_valid_asg_rec.PERIOD_TYPE '|| l_valid_asg_rec.PERIOD_TYPE, 850);
1437: hr_utility.set_location(' IF: l_valid_asg_rec.normal_hours '|| NVL(l_valid_asg_rec.normal_hours,0), 850);
1438: hr_utility.set_location(' IF: l_paid_pay_periods '|| l_paid_pay_periods, 850);
1439: hr_utility.set_location(' IF: l_factor '|| l_factor, 850);
1440: l_chrs_bal_val:=nvl(l_valid_asg_rec.normal_hours,0)*l_paid_pay_periods*l_factor; /* 10040939 */
1433: )-- 9776525
1434: THEN
1435: hr_utility.set_location(' IF: l_valid_asg_rec.frequency '|| l_valid_asg_rec.frequency, 850);
1436: hr_utility.set_location(' IF: l_valid_asg_rec.PERIOD_TYPE '|| l_valid_asg_rec.PERIOD_TYPE, 850);
1437: hr_utility.set_location(' IF: l_valid_asg_rec.normal_hours '|| NVL(l_valid_asg_rec.normal_hours,0), 850);
1438: hr_utility.set_location(' IF: l_paid_pay_periods '|| l_paid_pay_periods, 850);
1439: hr_utility.set_location(' IF: l_factor '|| l_factor, 850);
1440: l_chrs_bal_val:=nvl(l_valid_asg_rec.normal_hours,0)*l_paid_pay_periods*l_factor; /* 10040939 */
1441: --
1434: THEN
1435: hr_utility.set_location(' IF: l_valid_asg_rec.frequency '|| l_valid_asg_rec.frequency, 850);
1436: hr_utility.set_location(' IF: l_valid_asg_rec.PERIOD_TYPE '|| l_valid_asg_rec.PERIOD_TYPE, 850);
1437: hr_utility.set_location(' IF: l_valid_asg_rec.normal_hours '|| NVL(l_valid_asg_rec.normal_hours,0), 850);
1438: hr_utility.set_location(' IF: l_paid_pay_periods '|| l_paid_pay_periods, 850);
1439: hr_utility.set_location(' IF: l_factor '|| l_factor, 850);
1440: l_chrs_bal_val:=nvl(l_valid_asg_rec.normal_hours,0)*l_paid_pay_periods*l_factor; /* 10040939 */
1441: --
1442: ELSE
1435: hr_utility.set_location(' IF: l_valid_asg_rec.frequency '|| l_valid_asg_rec.frequency, 850);
1436: hr_utility.set_location(' IF: l_valid_asg_rec.PERIOD_TYPE '|| l_valid_asg_rec.PERIOD_TYPE, 850);
1437: hr_utility.set_location(' IF: l_valid_asg_rec.normal_hours '|| NVL(l_valid_asg_rec.normal_hours,0), 850);
1438: hr_utility.set_location(' IF: l_paid_pay_periods '|| l_paid_pay_periods, 850);
1439: hr_utility.set_location(' IF: l_factor '|| l_factor, 850);
1440: l_chrs_bal_val:=nvl(l_valid_asg_rec.normal_hours,0)*l_paid_pay_periods*l_factor; /* 10040939 */
1441: --
1442: ELSE
1443:
1471: null,
1472: null,
1473: null);
1474: END IF;
1475: hr_utility.set_location(' l_chrs_bal_val '|| l_chrs_bal_val, 850);
1476: --Bug # 6774024
1477: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1478:
1479: hr_utility.set_location(' Inside balance Loop ', 850);
1475: hr_utility.set_location(' l_chrs_bal_val '|| l_chrs_bal_val, 850);
1476: --Bug # 6774024
1477: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1478:
1479: hr_utility.set_location(' Inside balance Loop ', 850);
1480: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1481: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1482:
1483: l_mat_bal_val := nvl(l_mat_bal_val,0)
1476: --Bug # 6774024
1477: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1478:
1479: hr_utility.set_location(' Inside balance Loop ', 850);
1480: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1481: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1482:
1483: l_mat_bal_val := nvl(l_mat_bal_val,0)
1484: +
1477: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Hours') THEN
1478:
1479: hr_utility.set_location(' Inside balance Loop ', 850);
1480: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1481: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1482:
1483: l_mat_bal_val := nvl(l_mat_bal_val,0)
1484: +
1485: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1490: null,
1491: null,
1492: null);/*6856473*/
1493:
1494: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1495:
1496: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1497: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1498:
1492: null);/*6856473*/
1493:
1494: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1495:
1496: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1497: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1498:
1499: hr_utility.set_location(' Inside balance Loop ', 850);
1500: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1495:
1496: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1497: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1498:
1499: hr_utility.set_location(' Inside balance Loop ', 850);
1500: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1501: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1502:
1503: l_sic_bal_val :=
1496: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1497: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1498:
1499: hr_utility.set_location(' Inside balance Loop ', 850);
1500: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1501: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1502:
1503: l_sic_bal_val :=
1504: nvl(l_sic_bal_val,0)
1497: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Hours' ) THEN
1498:
1499: hr_utility.set_location(' Inside balance Loop ', 850);
1500: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1501: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1502:
1503: l_sic_bal_val :=
1504: nvl(l_sic_bal_val,0)
1505: +
1511: null,
1512: null,
1513: null);/*6856473*/
1514:
1515: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1516: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1517: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1518:
1519: hr_utility.set_location(' Inside balance Loop ', 850);
1512: null,
1513: null);/*6856473*/
1514:
1515: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1516: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1517: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1518:
1519: hr_utility.set_location(' Inside balance Loop ', 850);
1520: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1515: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1516: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1517: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1518:
1519: hr_utility.set_location(' Inside balance Loop ', 850);
1520: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1521: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1522:
1523: l_otl_bal_val :=
1516: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1517: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1518:
1519: hr_utility.set_location(' Inside balance Loop ', 850);
1520: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1521: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1522:
1523: l_otl_bal_val :=
1524: l_otl_bal_val
1517: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Hours' ) THEN
1518:
1519: hr_utility.set_location(' Inside balance Loop ', 850);
1520: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1521: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1522:
1523: l_otl_bal_val :=
1524: l_otl_bal_val
1525: +
1531: null,
1532: null,
1533: null);/*6856473*/
1534:
1535: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1536: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1537:
1538: /*6856473 added checks for balances Paid Maternity Days, Paid Sick Leave Days and Paid Other Leave Days*/
1539:
1532: null,
1533: null);/*6856473*/
1534:
1535: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1536: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1537:
1538: /*6856473 added checks for balances Paid Maternity Days, Paid Sick Leave Days and Paid Other Leave Days*/
1539:
1540: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1538: /*6856473 added checks for balances Paid Maternity Days, Paid Sick Leave Days and Paid Other Leave Days*/
1539:
1540: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1541:
1542: hr_utility.set_location(' Inside balance Loop ', 850);
1543: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1544: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1545:
1546: l_mat_bal_val :=
1539:
1540: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1541:
1542: hr_utility.set_location(' Inside balance Loop ', 850);
1543: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1544: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1545:
1546: l_mat_bal_val :=
1547: nvl(l_mat_bal_val,0)
1540: ELSIF (g_def_bal_id(bal_index).balance_name = 'Paid Maternity Days') THEN
1541:
1542: hr_utility.set_location(' Inside balance Loop ', 850);
1543: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1544: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1545:
1546: l_mat_bal_val :=
1547: nvl(l_mat_bal_val,0)
1548: +
1554: null,
1555: null,
1556: null)*l_hours_per_day;
1557:
1558: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1559:
1560: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1561: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1562:
1556: null)*l_hours_per_day;
1557:
1558: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1559:
1560: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1561: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1562:
1563: hr_utility.set_location(' Inside balance Loop ', 850);
1564: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1559:
1560: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1561: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1562:
1563: hr_utility.set_location(' Inside balance Loop ', 850);
1564: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1565: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1566:
1567: l_sic_bal_val :=
1560: hr_utility.set_location(' l_mat_bal_val '|| l_mat_bal_val, 850);
1561: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1562:
1563: hr_utility.set_location(' Inside balance Loop ', 850);
1564: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1565: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1566:
1567: l_sic_bal_val :=
1568: nvl(l_sic_bal_val,0)
1561: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Sick Leave Days') THEN
1562:
1563: hr_utility.set_location(' Inside balance Loop ', 850);
1564: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1565: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1566:
1567: l_sic_bal_val :=
1568: nvl(l_sic_bal_val,0)
1569: +
1574: null,
1575: null,
1576: null,
1577: null)*l_hours_per_day;
1578: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1579: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1580: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1581:
1582: hr_utility.set_location(' Inside balance Loop ', 850);
1575: null,
1576: null,
1577: null)*l_hours_per_day;
1578: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1579: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1580: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1581:
1582: hr_utility.set_location(' Inside balance Loop ', 850);
1583: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1578: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1579: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1580: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1581:
1582: hr_utility.set_location(' Inside balance Loop ', 850);
1583: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1584: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1585:
1586: l_otl_bal_val :=
1579: hr_utility.set_location(' l_sic_bal_val '|| l_sic_bal_val, 850);
1580: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1581:
1582: hr_utility.set_location(' Inside balance Loop ', 850);
1583: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1584: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1585:
1586: l_otl_bal_val :=
1587: nvl(l_otl_bal_val,0)
1580: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Paid Other Leave Days') THEN
1581:
1582: hr_utility.set_location(' Inside balance Loop ', 850);
1583: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1584: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1585:
1586: l_otl_bal_val :=
1587: nvl(l_otl_bal_val,0)
1588: +
1594: null,
1595: null,
1596: null)*l_hours_per_day
1597: ;
1598: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1599:
1600: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1601:
1602: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1596: null)*l_hours_per_day
1597: ;
1598: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1599:
1600: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1601:
1602: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1603:
1604: hr_utility.set_location(' Inside balance Loop ', 850);
1600: hr_utility.set_location(' l_otl_bal_val '|| l_otl_bal_val, 850);
1601:
1602: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1603:
1604: hr_utility.set_location(' Inside balance Loop ', 850);
1605: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1606: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1607:
1608: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1601:
1602: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1603:
1604: hr_utility.set_location(' Inside balance Loop ', 850);
1605: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1606: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1607:
1608: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1609: l_valid_asg_act_rec.assignment_action_id,
1602: ELSIF g_def_bal_id(bal_index).balance_name = 'Income Continuance Insurance' THEN
1603:
1604: hr_utility.set_location(' Inside balance Loop ', 850);
1605: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1606: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1607:
1608: l_incct_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1609: l_valid_asg_act_rec.assignment_action_id,
1610: g_employer_id,
1612: null,
1613: null,
1614: null,
1615: null);
1616: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);
1617: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1618:
1619: hr_utility.set_location(' Inside balance Loop ', 850);
1620: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1615: null);
1616: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);
1617: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1618:
1619: hr_utility.set_location(' Inside balance Loop ', 850);
1620: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1621: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1622:
1623: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1616: hr_utility.set_location(' l_incct_bal_val '|| l_incct_bal_val, 850);
1617: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1618:
1619: hr_utility.set_location(' Inside balance Loop ', 850);
1620: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1621: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1622:
1623: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1624: l_valid_asg_act_rec.assignment_action_id,
1617: ELSIF g_def_bal_id(bal_index).balance_name = 'Redundancy Payments' THEN
1618:
1619: hr_utility.set_location(' Inside balance Loop ', 850);
1620: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1621: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1622:
1623: l_red_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1624: l_valid_asg_act_rec.assignment_action_id,
1625: g_employer_id,
1627: null,
1628: null,
1629: null,
1630: null);
1631: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);
1632: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1633:
1634: hr_utility.set_location(' Inside balance Loop ', 850);
1635: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1630: null);
1631: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);
1632: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1633:
1634: hr_utility.set_location(' Inside balance Loop ', 850);
1635: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1636: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1637:
1638: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1631: hr_utility.set_location(' l_red_bal_val '|| l_red_bal_val, 850);
1632: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1633:
1634: hr_utility.set_location(' Inside balance Loop ', 850);
1635: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1636: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1637:
1638: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1639: l_valid_asg_act_rec.assignment_action_id,
1632: ELSIF g_def_bal_id(bal_index).balance_name = 'Employee Related Payments' THEN
1633:
1634: hr_utility.set_location(' Inside balance Loop ', 850);
1635: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1636: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1637:
1638: l_otsoc_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1639: l_valid_asg_act_rec.assignment_action_id,
1640: g_employer_id,
1642: null,
1643: null,
1644: null,
1645: null);
1646: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);
1647: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1648:
1649: hr_utility.set_location(' Inside balance Loop ', 850);
1650: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1645: null);
1646: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);
1647: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1648:
1649: hr_utility.set_location(' Inside balance Loop ', 850);
1650: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1651: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1652:
1653: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1646: hr_utility.set_location(' l_otsoc_bal_val '|| l_otsoc_bal_val, 850);
1647: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1648:
1649: hr_utility.set_location(' Inside balance Loop ', 850);
1650: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1651: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1652:
1653: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1654: l_valid_asg_act_rec.assignment_action_id,
1647: ELSIF g_def_bal_id(bal_index).balance_name = 'Training Subsidies' THEN
1648:
1649: hr_utility.set_location(' Inside balance Loop ', 850);
1650: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1651: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1652:
1653: l_tr_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1654: l_valid_asg_act_rec.assignment_action_id,
1655: g_employer_id,
1657: null,
1658: null,
1659: null,
1660: null);
1661: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);
1662: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1663:
1664: hr_utility.set_location(' Inside balance Loop ', 850);
1665: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1660: null);
1661: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);
1662: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1663:
1664: hr_utility.set_location(' Inside balance Loop ', 850);
1665: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1666: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1667:
1668: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1661: hr_utility.set_location(' l_tr_sub_bal_val '|| l_tr_sub_bal_val, 850);
1662: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1663:
1664: hr_utility.set_location(' Inside balance Loop ', 850);
1665: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1666: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1667:
1668: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1669: l_valid_asg_act_rec.assignment_action_id,
1662: ELSIF g_def_bal_id(bal_index).balance_name = 'Refunds' THEN
1663:
1664: hr_utility.set_location(' Inside balance Loop ', 850);
1665: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1666: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1667:
1668: l_refund_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1669: l_valid_asg_act_rec.assignment_action_id,
1670: g_employer_id,
1672: null,
1673: null,
1674: null,
1675: null);
1676: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);
1677: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1678:
1679: hr_utility.set_location(' Inside balance Loop ', 850);
1680: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1675: null);
1676: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);
1677: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1678:
1679: hr_utility.set_location(' Inside balance Loop ', 850);
1680: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1681: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1682:
1683: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1676: hr_utility.set_location(' l_refund_bal_val '|| l_refund_bal_val, 850);
1677: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1678:
1679: hr_utility.set_location(' Inside balance Loop ', 850);
1680: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1681: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1682:
1683: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1684: l_valid_asg_act_rec.assignment_action_id,
1677: ELSIF g_def_bal_id(bal_index).balance_name = 'Voluntary Sickness Insurance' THEN
1678:
1679: hr_utility.set_location(' Inside balance Loop ', 850);
1680: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1681: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1682:
1683: l_vhi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1684: l_valid_asg_act_rec.assignment_action_id,
1685: g_employer_id,
1687: null,
1688: null,
1689: null,
1690: null);
1691: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);
1692: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1693:
1694: hr_utility.set_location(' Inside balance Loop ', 850);
1695: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1690: null);
1691: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);
1692: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1693:
1694: hr_utility.set_location(' Inside balance Loop ', 850);
1695: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1696: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1697:
1698: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1691: hr_utility.set_location(' l_vhi_bal_val '|| l_vhi_bal_val, 850);
1692: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1693:
1694: hr_utility.set_location(' Inside balance Loop ', 850);
1695: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1696: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1697:
1698: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1699: l_valid_asg_act_rec.assignment_action_id,
1692: ELSIF g_def_bal_id(bal_index).balance_name = 'Staff Housing' THEN
1693:
1694: hr_utility.set_location(' Inside balance Loop ', 850);
1695: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1696: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1697:
1698: l_hse_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1699: l_valid_asg_act_rec.assignment_action_id,
1700: g_employer_id,
1702: null,
1703: null,
1704: null,
1705: null);
1706: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);
1707: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1708:
1709: hr_utility.set_location(' Inside balance Loop ', 850);
1710: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1705: null);
1706: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);
1707: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1708:
1709: hr_utility.set_location(' Inside balance Loop ', 850);
1710: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1711: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1712:
1713: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1706: hr_utility.set_location(' l_hse_bal_val '|| l_hse_bal_val, 850);
1707: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1708:
1709: hr_utility.set_location(' Inside balance Loop ', 850);
1710: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1711: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1712:
1713: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1714: l_valid_asg_act_rec.assignment_action_id,
1707: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Benefits' THEN
1708:
1709: hr_utility.set_location(' Inside balance Loop ', 850);
1710: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1711: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1712:
1713: l_otben_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1714: l_valid_asg_act_rec.assignment_action_id,
1715: g_employer_id,
1717: null,
1718: null,
1719: null,
1720: null);
1721: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);
1722: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1723:
1724: hr_utility.set_location(' Inside balance Loop ', 850);
1725: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1720: null);
1721: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);
1722: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1723:
1724: hr_utility.set_location(' Inside balance Loop ', 850);
1725: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1726: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1727:
1728: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1721: hr_utility.set_location(' l_otben_bal_val '|| l_otben_bal_val, 850);
1722: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1723:
1724: hr_utility.set_location(' Inside balance Loop ', 850);
1725: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1726: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1727:
1728: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1729: l_valid_asg_act_rec.assignment_action_id,
1722: ELSIF g_def_bal_id(bal_index).balance_name = 'Other Subsidies' THEN
1723:
1724: hr_utility.set_location(' Inside balance Loop ', 850);
1725: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1726: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1727:
1728: l_ot_sub_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1729: l_valid_asg_act_rec.assignment_action_id,
1730: g_employer_id,
1732: null,
1733: null,
1734: null,
1735: null);
1736: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);
1737: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1738:
1739: hr_utility.set_location(' Inside balance Loop ', 850);
1740: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1735: null);
1736: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);
1737: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1738:
1739: hr_utility.set_location(' Inside balance Loop ', 850);
1740: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1741: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1742:
1743: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1736: hr_utility.set_location(' l_ot_sub_bal_val '|| l_ot_sub_bal_val, 850);
1737: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1738:
1739: hr_utility.set_location(' Inside balance Loop ', 850);
1740: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1741: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1742:
1743: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1744: l_valid_asg_act_rec.assignment_action_id,
1737: ELSIF g_def_bal_id(bal_index).balance_name = 'Hourly Rate' THEN
1738:
1739: hr_utility.set_location(' Inside balance Loop ', 850);
1740: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1741: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1742:
1743: /* l_nmw_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1744: l_valid_asg_act_rec.assignment_action_id,
1745: g_employer_id,
1749: null,
1750: null);
1751: */
1752: l_nmw_bal_val:=( NVL(l_regwg_bal_val,0) + NVL(l_irrb_bal_val,0));
1753: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);
1754: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1755:
1756: hr_utility.set_location(' Inside balance Loop ', 850);
1757: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1752: l_nmw_bal_val:=( NVL(l_regwg_bal_val,0) + NVL(l_irrb_bal_val,0));
1753: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);
1754: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1755:
1756: hr_utility.set_location(' Inside balance Loop ', 850);
1757: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1758: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1759:
1760: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1753: hr_utility.set_location(' l_nmw_bal_val '|| l_nmw_bal_val, 850);
1754: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1755:
1756: hr_utility.set_location(' Inside balance Loop ', 850);
1757: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1758: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1759:
1760: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1761: l_valid_asg_act_rec.assignment_action_id,
1754: ELSIF g_def_bal_id(bal_index).balance_name = 'Stock Options and Share Purchase' THEN
1755:
1756: hr_utility.set_location(' Inside balance Loop ', 850);
1757: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1758: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1759:
1760: l_stks_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1761: l_valid_asg_act_rec.assignment_action_id,
1762: g_employer_id,
1764: null,
1765: null,
1766: null,
1767: null);
1768: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);
1769: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1770:
1771: hr_utility.set_location(' Inside balance Loop ', 850);
1772: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1767: null);
1768: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);
1769: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1770:
1771: hr_utility.set_location(' Inside balance Loop ', 850);
1772: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1773: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1774:
1775: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1768: hr_utility.set_location(' l_stks_bal_val '|| l_stks_bal_val, 850);
1769: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1770:
1771: hr_utility.set_location(' Inside balance Loop ', 850);
1772: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1773: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1774:
1775: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1776: l_valid_asg_act_rec.assignment_action_id,
1769: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RBS ER Contribution' THEN
1770:
1771: hr_utility.set_location(' Inside balance Loop ', 850);
1772: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1773: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1774:
1775: l_rbs_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1776: l_valid_asg_act_rec.assignment_action_id,
1777: g_employer_id,
1779: null,
1780: null,
1781: null,
1782: null);
1783: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);
1784: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1785:
1786: hr_utility.set_location(' Inside balance Loop ', 850);
1787: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1782: null);
1783: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);
1784: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1785:
1786: hr_utility.set_location(' Inside balance Loop ', 850);
1787: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1788: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1789:
1790: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1783: hr_utility.set_location(' l_rbs_er_bal_val '|| l_rbs_er_bal_val, 850);
1784: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1785:
1786: hr_utility.set_location(' Inside balance Loop ', 850);
1787: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1788: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1789:
1790: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1791: l_valid_asg_act_rec.assignment_action_id,
1784: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSA ER Contribution' THEN
1785:
1786: hr_utility.set_location(' Inside balance Loop ', 850);
1787: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1788: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1789:
1790: l_prsa_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1791: l_valid_asg_act_rec.assignment_action_id,
1792: g_employer_id,
1794: null,
1795: null,
1796: null,
1797: null);
1798: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);
1799: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1800:
1801: hr_utility.set_location(' Inside balance Loop ', 850);
1802: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1797: null);
1798: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);
1799: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1800:
1801: hr_utility.set_location(' Inside balance Loop ', 850);
1802: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1803: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1804:
1805: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1798: hr_utility.set_location(' l_prsa_er_bal_val '|| l_prsa_er_bal_val, 850);
1799: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1800:
1801: hr_utility.set_location(' Inside balance Loop ', 850);
1802: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1803: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1804:
1805: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1806: l_valid_asg_act_rec.assignment_action_id,
1799: ELSIF g_def_bal_id(bal_index).balance_name = 'IE RAC ER Contribution' THEN
1800:
1801: hr_utility.set_location(' Inside balance Loop ', 850);
1802: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1803: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1804:
1805: l_rac_er_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1806: l_valid_asg_act_rec.assignment_action_id,
1807: g_employer_id,
1809: null,
1810: null,
1811: null,
1812: null);
1813: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);
1814: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1815:
1816: hr_utility.set_location(' Inside balance Loop ', 850);
1817: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1812: null);
1813: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);
1814: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1815:
1816: hr_utility.set_location(' Inside balance Loop ', 850);
1817: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1818: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1819:
1820: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1813: hr_utility.set_location(' l_rac_er_bal_val '|| l_rac_er_bal_val, 850);
1814: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1815:
1816: hr_utility.set_location(' Inside balance Loop ', 850);
1817: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1818: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1819:
1820: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1821: l_valid_asg_act_rec.assignment_action_id,
1814: ELSIF g_def_bal_id(bal_index).balance_name = 'IE PRSI Employer' THEN
1815:
1816: hr_utility.set_location(' Inside balance Loop ', 850);
1817: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1818: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1819:
1820: l_prsi_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1821: l_valid_asg_act_rec.assignment_action_id,
1822: g_employer_id,
1824: null,
1825: null,
1826: null,
1827: null);
1828: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);
1829: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1830:
1831: hr_utility.set_location(' Inside balance Loop ', 850);
1832: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1827: null);
1828: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);
1829: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1830:
1831: hr_utility.set_location(' Inside balance Loop ', 850);
1832: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1833: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1834:
1835: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1828: hr_utility.set_location(' l_prsi_bal_val '|| l_prsi_bal_val, 850);
1829: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1830:
1831: hr_utility.set_location(' Inside balance Loop ', 850);
1832: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1833: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1834:
1835: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1836: l_valid_asg_act_rec.assignment_action_id,
1829: ELSIF g_def_bal_id(bal_index).balance_name = 'IE BIK Company Vehicle' THEN
1830:
1831: hr_utility.set_location(' Inside balance Loop ', 850);
1832: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1833: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1834:
1835: l_bik_veh_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1836: l_valid_asg_act_rec.assignment_action_id,
1837: g_employer_id,
1840: null,
1841: null,
1842: null);
1843:
1844: hr_utility.set_location(' l_bik_veh_bal_val '|| l_bik_veh_bal_val, 850);
1845:
1846: /* 6856473 */
1847: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1848: hr_utility.set_location(' Inside balance Loop ', 850);
1844: hr_utility.set_location(' l_bik_veh_bal_val '|| l_bik_veh_bal_val, 850);
1845:
1846: /* 6856473 */
1847: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1848: hr_utility.set_location(' Inside balance Loop ', 850);
1849: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1850: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1851: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1852: l_valid_asg_act_rec.assignment_action_id,
1845:
1846: /* 6856473 */
1847: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1848: hr_utility.set_location(' Inside balance Loop ', 850);
1849: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1850: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1851: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1852: l_valid_asg_act_rec.assignment_action_id,
1853: g_employer_id,
1846: /* 6856473 */
1847: ELSIF g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Hours' THEN
1848: hr_utility.set_location(' Inside balance Loop ', 850);
1849: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1850: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1851: l_al_bal_val := PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1852: l_valid_asg_act_rec.assignment_action_id,
1853: g_employer_id,
1854: null,
1855: null,
1856: null,
1857: null,
1858: null);
1859: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1860: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1861: hr_utility.set_location(' Inside balance Loop ', 850);
1862: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1863: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1857: null,
1858: null);
1859: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1860: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1861: hr_utility.set_location(' Inside balance Loop ', 850);
1862: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1863: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1864: l_al_bal_val :=
1865: nvl(l_al_bal_val,0)
1858: null);
1859: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1860: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1861: hr_utility.set_location(' Inside balance Loop ', 850);
1862: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1863: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1864: l_al_bal_val :=
1865: nvl(l_al_bal_val,0)
1866: +
1859: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1860: ELSIF ( g_def_bal_id(bal_index).balance_name = 'Annual Leave and Bank Holiday Days') THEN
1861: hr_utility.set_location(' Inside balance Loop ', 850);
1862: hr_utility.set_location(' g_def_bal_id(bal_index).balance_name '||g_def_bal_id(bal_index).balance_name, 850);
1863: hr_utility.set_location(' l_valid_asg_act_rec.assignment_action_id '||l_valid_asg_act_rec.assignment_action_id, 850);
1864: l_al_bal_val :=
1865: nvl(l_al_bal_val,0)
1866: +
1867: PAY_BALANCE_PKG.GET_VALUE(g_def_bal_id(bal_index).defined_balance_id,
1872: null,
1873: null,
1874: null)*l_hours_per_day
1875: ;
1876: hr_utility.set_location(' l_al_bal_val '|| l_al_bal_val, 850);
1877:
1878: END IF;
1879: END LOOP;
1880:
1887: IF (l_nmw_bal_val / l_chrs_bal_val) <= g_ie_nat_min_wage_rate THEN
1888: l_nmw_count := l_nmw_count + 1;
1889: END IF;
1890: END IF;
1891: hr_utility.set_location(' l_nmw_count '|| l_nmw_count , 860);
1892:
1893: l_pen_bal_val_tot := NVL(l_rbs_er_bal_val,0) + NVL(l_prsa_er_bal_val,0) + NVL(l_rac_er_bal_val,0);
1894:
1895: hr_utility.set_location(' l_pen_bal_val_tot '|| l_pen_bal_val_tot , 870);
1891: hr_utility.set_location(' l_nmw_count '|| l_nmw_count , 860);
1892:
1893: l_pen_bal_val_tot := NVL(l_rbs_er_bal_val,0) + NVL(l_prsa_er_bal_val,0) + NVL(l_rac_er_bal_val,0);
1894:
1895: hr_utility.set_location(' l_pen_bal_val_tot '|| l_pen_bal_val_tot , 870);
1896:
1897: IF l_valid_asg_rec.EMP_CATG = 'AT' THEN
1898: l_app_wg_bal_val_tot := NVL(l_regwg_bal_val,0) + NVL(l_ovrt_bal_val,0) + NVL(l_irrb_bal_val,0);
1899: l_lap_bal_val_tot := NVL(l_mat_bal_val,0) + NVL(l_sic_bal_val,0) + NVL(l_otl_bal_val,0);
1899: l_lap_bal_val_tot := NVL(l_mat_bal_val,0) + NVL(l_sic_bal_val,0) + NVL(l_otl_bal_val,0);
1900: l_ssec_bal_val_tot := NVL(l_prsi_bal_val,0) + NVL(l_incct_bal_val,0)
1901: + NVL(l_red_bal_val,0) + NVL(l_otsoc_bal_val,0);
1902:
1903: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);
1904: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);
1905: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);
1906: END IF;
1907: -- END IF; --assignment action ID
1900: l_ssec_bal_val_tot := NVL(l_prsi_bal_val,0) + NVL(l_incct_bal_val,0)
1901: + NVL(l_red_bal_val,0) + NVL(l_otsoc_bal_val,0);
1902:
1903: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);
1904: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);
1905: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);
1906: END IF;
1907: -- END IF; --assignment action ID
1908: END IF;
1901: + NVL(l_red_bal_val,0) + NVL(l_otsoc_bal_val,0);
1902:
1903: hr_utility.set_location(' l_app_wg_bal_val_tot '|| l_app_wg_bal_val_tot , 880);
1904: hr_utility.set_location(' l_lap_bal_val_tot '|| l_lap_bal_val_tot , 880);
1905: hr_utility.set_location(' l_ssec_bal_val_tot '|| l_ssec_bal_val_tot , 880);
1906: END IF;
1907: -- END IF; --assignment action ID
1908: END IF;
1909: CLOSE cur_valid_asg_act;
1907: -- END IF; --assignment action ID
1908: END IF;
1909: CLOSE cur_valid_asg_act;
1910:
1911: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);
1912: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);
1913:
1914: INSERT INTO PAY_US_RPT_TOTALS
1915: (BUSINESS_GROUP_ID
1908: END IF;
1909: CLOSE cur_valid_asg_act;
1910:
1911: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);
1912: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);
1913:
1914: INSERT INTO PAY_US_RPT_TOTALS
1915: (BUSINESS_GROUP_ID
1916: ,ATTRIBUTE1 --payroll_action_id
1985: ,l_rac_er_bal_val
1986: ,l_al_bal_val -- 6856473
1987: );
1988:
1989: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1990:
1991: CLOSE cur_valid_asg;
1992:
1993: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);
1989: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1990:
1991: CLOSE cur_valid_asg;
1992:
1993: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);
1994:
1995: END;
1996:
1997: -----------------------------------------------------------------------
2005: buffer RAW( 32767 );
2006: res BLOB;
2007: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
2008: BEGIN
2009: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
2010: DBMS_LOB.createTemporary( res, TRUE );
2011: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
2012:
2013:
2021: pos := pos + 16000;
2022: EXIT WHEN pos > lob_len;
2023: END LOOP;
2024:
2025: Hr_Utility.set_location('Leaving: PAY_IE_EHECS_REPORT_PKG.c2b',1010);
2026: RETURN res; -- res is OPEN here
2027: END c2b;
2028: -----------------------------------------------------------------------
2029: -- GEN_BODY_XML
2054: AND ptoa.Object_id = paa.assignment_id
2055: AND ptoa.object_action_id = p_object_action_id;
2056:
2057: BEGIN
2058: hr_utility.set_location(' Entering: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2000);
2059:
2060: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2061: l_object_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2062:
2063: OPEN C_Perid_Asgid(l_payroll_action_id, l_object_action_id);
2064: FETCH C_Perid_Asgid into l_person_id, l_assignment_id;
2065: CLOSE C_Perid_Asgid;
2066:
2067: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
2068: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
2069: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
2070: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
2071:
2064: FETCH C_Perid_Asgid into l_person_id, l_assignment_id;
2065: CLOSE C_Perid_Asgid;
2066:
2067: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
2068: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
2069: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
2070: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
2071:
2072: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
2065: CLOSE C_Perid_Asgid;
2066:
2067: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
2068: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
2069: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
2070: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
2071:
2072: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
2073:
2066:
2067: hr_utility.set_location('l_person_id '||TO_CHAR(l_person_id),2010);
2068: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
2069: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
2070: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
2071:
2072: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
2073:
2074: ehecs_main_proc( g_business_Group_id
2068: hr_utility.set_location('l_assignment_id '||TO_CHAR(l_assignment_id),2010);
2069: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),2010);
2070: hr_utility.set_location('l_object_action_id '||TO_CHAR(l_object_action_id),2010);
2071:
2072: hr_utility.set_location('befiore calling Ehecs_main_proc ',2020);
2073:
2074: ehecs_main_proc( g_business_Group_id
2075: ,l_payroll_action_id
2076: ,l_assignment_id
2075: ,l_payroll_action_id
2076: ,l_assignment_id
2077: ,l_person_id);
2078:
2079: hr_utility.set_location('befiore calling Ehecs_main_proc ',2030);
2080:
2081: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);
2082:
2083: EXCEPTION
2077: ,l_person_id);
2078:
2079: hr_utility.set_location('befiore calling Ehecs_main_proc ',2030);
2080:
2081: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);
2082:
2083: EXCEPTION
2084: WHEN Others THEN
2085: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,2050);
2081: hr_utility.set_location(' Leaving: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 2040);
2082:
2083: EXCEPTION
2084: WHEN Others THEN
2085: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,2050);
2086: END gen_body_xml;
2087: -----------------------------------------------------------------------
2088: -- GEN_HEADER_XML
2089: -----------------------------------------------------------------------
2128: l_payroll_action_id number;
2129:
2130: BEGIN
2131: l_proc := g_package || 'gen_header_xml';
2132: hr_utility.set_location ('Entering '||l_proc,1500);
2133:
2134: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2135: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
2136:
2131: l_proc := g_package || 'gen_header_xml';
2132: hr_utility.set_location ('Entering '||l_proc,1500);
2133:
2134: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2135: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
2136:
2137: OPEN c_get_header(l_payroll_action_id);
2138: FETCH c_get_header into l_header;
2139: CLOSE c_get_header;
2176: END IF;
2177:
2178: EXCEPTION
2179: WHEN Others THEN
2180: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1214);
2181:
2182: END gen_header_xml;
2183: -----------------------------------------------------------------------
2184: -- GEN_FOOTER_XML
3146: l_is_gt_0 Varchar2(100);
3147:
3148: begin
3149:
3150: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);
3151:
3152: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
3153: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
3154:
3149:
3150: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);
3151:
3152: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
3153: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
3154:
3155:
3156: l_tab_get_totals.delete;
3157: hr_utility.set_location('After deleting l_tab_get_totals pltable ',3020);
3153: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
3154:
3155:
3156: l_tab_get_totals.delete;
3157: hr_utility.set_location('After deleting l_tab_get_totals pltable ',3020);
3158:
3159: --Initializing to prevent the no data found error
3160: l_tab_get_totals('M') := l_get_totals_empty_rec;
3161: l_tab_get_totals('C') := l_get_totals_empty_rec;
3160: l_tab_get_totals('M') := l_get_totals_empty_rec;
3161: l_tab_get_totals('C') := l_get_totals_empty_rec;
3162: l_tab_get_totals('P') := l_get_totals_empty_rec;
3163:
3164: hr_utility.set_location('After initializing l_tab_get_totals pltable ',3030);
3165:
3166: open cur_get_totals(l_payroll_action_id);
3167: loop
3168: fetch cur_get_totals into l_get_totals_rec;
3166: open cur_get_totals(l_payroll_action_id);
3167: loop
3168: fetch cur_get_totals into l_get_totals_rec;
3169: EXIT WHEN cur_get_totals%NOTFOUND;
3170: hr_utility.set_location('Inside cursor cur_get_totals.',3031);
3171: l_tab_get_totals(l_get_totals_rec.ehecs_catg) := l_get_totals_rec;
3172: end loop;
3173: close cur_get_totals;
3174:
3171: l_tab_get_totals(l_get_totals_rec.ehecs_catg) := l_get_totals_rec;
3172: end loop;
3173: close cur_get_totals;
3174:
3175: hr_utility.set_location('After cursor cur_get_totals ',3040);
3176:
3177: -- Override Values.
3178: l_tab_get_override_totals.delete;
3179: hr_utility.set_location('After deleting l_tab_get_override_totals pltable ',3050);
3175: hr_utility.set_location('After cursor cur_get_totals ',3040);
3176:
3177: -- Override Values.
3178: l_tab_get_override_totals.delete;
3179: hr_utility.set_location('After deleting l_tab_get_override_totals pltable ',3050);
3180:
3181: --Initializing to prevent the no data found error
3182: l_tab_get_override_totals('M') := l_get_ovrrd_tot_empty_rec;
3183: l_tab_get_override_totals('C') := l_get_ovrrd_tot_empty_rec;
3182: l_tab_get_override_totals('M') := l_get_ovrrd_tot_empty_rec;
3183: l_tab_get_override_totals('C') := l_get_ovrrd_tot_empty_rec;
3184: l_tab_get_override_totals('P') := l_get_ovrrd_tot_empty_rec;
3185:
3186: hr_utility.set_location('After initializing l_tab_get_override_totals pltable ',3060);
3187:
3188: open cur_get_override_totals(g_employer_id,g_business_group_id);
3189: loop
3190: fetch cur_get_override_totals into l_get_override_totals_rec;
3188: open cur_get_override_totals(g_employer_id,g_business_group_id);
3189: loop
3190: fetch cur_get_override_totals into l_get_override_totals_rec;
3191: EXIT WHEN cur_get_override_totals%NOTFOUND;
3192: hr_utility.set_location('Inside cursor cur_get_override_totals.',3061);
3193: l_tab_get_override_totals(l_get_override_totals_rec.ehecs_catg) := l_get_override_totals_rec;
3194: end loop;
3195: close cur_get_override_totals;
3196:
3193: l_tab_get_override_totals(l_get_override_totals_rec.ehecs_catg) := l_get_override_totals_rec;
3194: end loop;
3195: close cur_get_override_totals;
3196:
3197: hr_utility.set_location('After Cursor cur_get_override_totals ',3070);
3198:
3199: OPEN csr_ehecs_eit(g_employer_id, g_business_group_id, g_year, g_quarter);
3200: FETCH csr_ehecs_eit INTO l_csr_ehecs_eit;
3201: CLOSE csr_ehecs_eit;
3199: OPEN csr_ehecs_eit(g_employer_id, g_business_group_id, g_year, g_quarter);
3200: FETCH csr_ehecs_eit INTO l_csr_ehecs_eit;
3201: CLOSE csr_ehecs_eit;
3202:
3203: hr_utility.set_location('After Cursor csr_ehecs_eit ',3080);
3204:
3205: OPEN csr_part1_qtr_start;
3206: LOOP
3207: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
3205: OPEN csr_part1_qtr_start;
3206: LOOP
3207: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
3208: EXIT WHEN csr_part1_qtr_start%NOTFOUND;
3209: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);
3210: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);
3211: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);
3212:
3213: IF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'M' THEN
3206: LOOP
3207: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
3208: EXIT WHEN csr_part1_qtr_start%NOTFOUND;
3209: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);
3210: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);
3211: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);
3212:
3213: IF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'M' THEN
3214: l_fst_ft_mg := l_part1_qtr_start.tot;
3207: FETCH csr_part1_qtr_start INTO l_part1_qtr_start;
3208: EXIT WHEN csr_part1_qtr_start%NOTFOUND;
3209: hr_utility.set_location('Inside Cursor csr_part1_qtr_start ',3085);
3210: hr_utility.set_location('l_part1_qtr_start.EMP_CATG '||l_part1_qtr_start.EMP_CATG,3086);
3211: hr_utility.set_location('l_part1_qtr_start.EHECS_CATG '||l_part1_qtr_start.EHECS_CATG,3087);
3212:
3213: IF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'M' THEN
3214: l_fst_ft_mg := l_part1_qtr_start.tot;
3215: ELSIF l_part1_qtr_start.EMP_CATG = 'F' AND l_part1_qtr_start.EHECS_CATG = 'C' THEN
3225: END IF;
3226: END LOOP;
3227: CLOSE csr_part1_qtr_start;
3228:
3229: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
3230: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
3231: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
3232: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3226: END LOOP;
3227: CLOSE csr_part1_qtr_start;
3228:
3229: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
3230: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
3231: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
3232: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3234: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
3227: CLOSE csr_part1_qtr_start;
3228:
3229: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
3230: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
3231: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
3232: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3234: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
3235:
3228:
3229: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
3230: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
3231: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
3232: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3234: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
3235:
3236:
3229: hr_utility.set_location('l_fst_ft_mg'||l_fst_ft_mg,3085);
3230: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
3231: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
3232: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3234: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
3235:
3236:
3237: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);
3230: hr_utility.set_location('l_fst_ft_cl'||l_fst_ft_cl,3085);
3231: hr_utility.set_location('l_fst_ft_ot'||l_fst_ft_ot,3085);
3232: hr_utility.set_location('l_fst_pt_mg'||l_fst_pt_mg,3085);
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3234: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
3235:
3236:
3237: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);
3238:
3233: hr_utility.set_location('l_fst_pt_cl'||l_fst_pt_cl,3085);
3234: hr_utility.set_location('l_fst_pt_ot'||l_fst_pt_ot,3085);
3235:
3236:
3237: hr_utility.set_location('After Cursor csr_part1_qtr_start ',3090);
3238:
3239: OPEN csr_part1_qtr_end;
3240: LOOP
3241: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
3239: OPEN csr_part1_qtr_end;
3240: LOOP
3241: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
3242: EXIT WHEN csr_part1_qtr_end%NOTFOUND;
3243: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);
3244: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);
3245: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);
3246:
3247: IF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'M' THEN
3240: LOOP
3241: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
3242: EXIT WHEN csr_part1_qtr_end%NOTFOUND;
3243: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);
3244: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);
3245: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);
3246:
3247: IF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'M' THEN
3248: l_lst_ft_mg := l_part1_qtr_end.tot;
3241: FETCH csr_part1_qtr_end INTO l_part1_qtr_end;
3242: EXIT WHEN csr_part1_qtr_end%NOTFOUND;
3243: hr_utility.set_location('Inside Cursor csr_part1_qtr_end ',3091);
3244: hr_utility.set_location('l_part1_qtr_end.EMP_CATG '||l_part1_qtr_end.EMP_CATG,3092);
3245: hr_utility.set_location('l_part1_qtr_end.EHECS_CATG '||l_part1_qtr_end.EHECS_CATG,3093);
3246:
3247: IF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'M' THEN
3248: l_lst_ft_mg := l_part1_qtr_end.tot;
3249: ELSIF l_part1_qtr_end.EMP_CATG = 'F' AND l_part1_qtr_end.EHECS_CATG = 'C' THEN
3259: END IF;
3260: END LOOP;
3261: CLOSE csr_part1_qtr_end;
3262:
3263: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
3264: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
3265: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3260: END LOOP;
3261: CLOSE csr_part1_qtr_end;
3262:
3263: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
3264: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
3265: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3268: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
3261: CLOSE csr_part1_qtr_end;
3262:
3263: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
3264: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
3265: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3268: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
3269:
3262:
3263: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
3264: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
3265: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3268: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
3269:
3270: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
3263: hr_utility.set_location('l_lst_ft_mg'||l_lst_ft_mg,3095);
3264: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
3265: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3268: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
3269:
3270: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
3271:
3264: hr_utility.set_location('l_lst_ft_cl'||l_lst_ft_cl,3095);
3265: hr_utility.set_location('l_lst_ft_ot'||l_lst_ft_ot,3095);
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3268: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
3269:
3270: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
3271:
3272: OPEN csr_part1_hire_qtr;
3266: hr_utility.set_location('l_lst_pt_mg'||l_lst_pt_mg,3095);
3267: hr_utility.set_location('l_lst_pt_cl'||l_lst_pt_cl,3095);
3268: hr_utility.set_location('l_lst_pt_ot'||l_lst_pt_ot,3095);
3269:
3270: hr_utility.set_location('After Cursor csr_part1_qtr_end ',3100);
3271:
3272: OPEN csr_part1_hire_qtr;
3273: LOOP
3274: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
3272: OPEN csr_part1_hire_qtr;
3273: LOOP
3274: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
3275: EXIT WHEN csr_part1_hire_qtr%NOTFOUND;
3276: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);
3277: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);
3278: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);
3279:
3280: IF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'M' THEN
3273: LOOP
3274: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
3275: EXIT WHEN csr_part1_hire_qtr%NOTFOUND;
3276: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);
3277: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);
3278: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);
3279:
3280: IF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'M' THEN
3281: l_hire_ft_mg := l_part1_hire_qtr.tot;
3274: FETCH csr_part1_hire_qtr INTO l_part1_hire_qtr;
3275: EXIT WHEN csr_part1_hire_qtr%NOTFOUND;
3276: hr_utility.set_location('Inside Cursor csr_part1_hire_qtr ',3101);
3277: hr_utility.set_location('l_part1_hire_qtr.EMP_CATG '||l_part1_hire_qtr.EMP_CATG,3102);
3278: hr_utility.set_location('l_part1_hire_qtr.EHECS_CATG '||l_part1_hire_qtr.EHECS_CATG,3103);
3279:
3280: IF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'M' THEN
3281: l_hire_ft_mg := l_part1_hire_qtr.tot;
3282: ELSIF l_part1_hire_qtr.EMP_CATG = 'F' AND l_part1_hire_qtr.EHECS_CATG = 'C' THEN
3292: END IF;
3293: END LOOP;
3294: CLOSE csr_part1_hire_qtr;
3295:
3296: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3297: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3298: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3293: END LOOP;
3294: CLOSE csr_part1_hire_qtr;
3295:
3296: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3297: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3298: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3301: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3294: CLOSE csr_part1_hire_qtr;
3295:
3296: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3297: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3298: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3301: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3302:
3295:
3296: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3297: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3298: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3301: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3302:
3303: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3296: hr_utility.set_location('l_hire_ft_mg'||l_hire_ft_mg,3095);
3297: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3298: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3301: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3302:
3303: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3304:
3297: hr_utility.set_location('l_hire_ft_cl'||l_hire_ft_cl,3095);
3298: hr_utility.set_location('l_hire_ft_ot'||l_hire_ft_ot,3095);
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3301: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3302:
3303: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3304:
3305: l_cnt_app_mgr_final := 0;
3299: hr_utility.set_location('l_hire_pt_mg'||l_hire_pt_mg,3095);
3300: hr_utility.set_location('l_hire_pt_cl'||l_hire_pt_cl,3095);
3301: hr_utility.set_location('l_hire_pt_ot'||l_hire_pt_ot,3095);
3302:
3303: hr_utility.set_location('After Cursor csr_part1_hire_qtr ',3110);
3304:
3305: l_cnt_app_mgr_final := 0;
3306: l_cnt_app_clk_final := 0;
3307: l_cnt_app_oth_final := 0;
3305: l_cnt_app_mgr_final := 0;
3306: l_cnt_app_clk_final := 0;
3307: l_cnt_app_oth_final := 0;
3308:
3309: hr_utility.set_location('Before Cursor csr_all_payrolls ',3130);
3310:
3311: FOR pyr_index IN csr_all_payrolls
3312: LOOP
3313: hr_utility.set_location('Inside Cursor csr_all_payrolls ',3140);
3309: hr_utility.set_location('Before Cursor csr_all_payrolls ',3130);
3310:
3311: FOR pyr_index IN csr_all_payrolls
3312: LOOP
3313: hr_utility.set_location('Inside Cursor csr_all_payrolls ',3140);
3314: l_number_of_periods := 0;
3315: /* 9848705 */
3316: --
3317: l_cnt_app_mgr := 0;
3320: --
3321:
3322: FOR prd_index IN csr_period_dates(pyr_index.payroll_id)
3323: LOOP
3324: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);
3325: l_number_of_periods := l_number_of_periods + 1;
3326: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);
3327: hr_utility.set_location('pyr_index.payroll_id '||pyr_index.payroll_id,3150);
3328:
3322: FOR prd_index IN csr_period_dates(pyr_index.payroll_id)
3323: LOOP
3324: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);
3325: l_number_of_periods := l_number_of_periods + 1;
3326: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);
3327: hr_utility.set_location('pyr_index.payroll_id '||pyr_index.payroll_id,3150);
3328:
3329: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3330: LOOP
3323: LOOP
3324: hr_utility.set_location('Inside Cursor csr_period_dates ',3150);
3325: l_number_of_periods := l_number_of_periods + 1;
3326: hr_utility.set_location('l_number_of_periods '||l_number_of_periods,3150);
3327: hr_utility.set_location('pyr_index.payroll_id '||pyr_index.payroll_id,3150);
3328:
3329: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3330: LOOP
3331: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3327: hr_utility.set_location('pyr_index.payroll_id '||pyr_index.payroll_id,3150);
3328:
3329: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3330: LOOP
3331: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3332: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3333: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3334: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3335: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3328:
3329: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3330: LOOP
3331: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3332: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3333: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3334: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3335: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3336: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3329: FOR asg_index IN csr_app_mgr_clk_pro(pyr_index.payroll_id, prd_index.pay_advice_date)
3330: LOOP
3331: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3332: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3333: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3334: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3335: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3336: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3337:
3330: LOOP
3331: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3332: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3333: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3334: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3335: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3336: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3337:
3338: IF asg_index.EHECS_CATG = 'M' THEN
3331: hr_utility.set_location('Inside Cursor csr_app_mgr_clk_pro ',3160);
3332: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3333: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3334: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3335: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3336: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3337:
3338: IF asg_index.EHECS_CATG = 'M' THEN
3339: l_cnt_app_mgr := l_cnt_app_mgr + asg_index.tot;
3332: hr_utility.set_location('asg_index.EHECS_CATG '||asg_index.EHECS_CATG,3160);
3333: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3160);
3334: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3160);
3335: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3160);
3336: hr_utility.set_location('asg_index.tot '||asg_index.tot,3160);
3337:
3338: IF asg_index.EHECS_CATG = 'M' THEN
3339: l_cnt_app_mgr := l_cnt_app_mgr + asg_index.tot;
3340: ELSIF asg_index.EHECS_CATG = 'C' THEN
3345: END LOOP;
3346: END LOOP;
3347:
3348: IF l_number_of_periods > 0 THEN
3349: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3350: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3351: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3352:
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3346: END LOOP;
3347:
3348: IF l_number_of_periods > 0 THEN
3349: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3350: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3351: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3352:
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3354: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3347:
3348: IF l_number_of_periods > 0 THEN
3349: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3350: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3351: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3352:
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3354: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3355:
3349: hr_utility.set_location('Inside IF l_number_of_periods > 0 before ',3170);
3350: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3351: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3352:
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3354: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3355:
3356: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3357: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3350: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3351: hr_utility.set_location('l_cnt_app_mgr '||l_cnt_app_mgr,3170);
3352:
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3354: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3355:
3356: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3357: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3358:
3352:
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3354: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3355:
3356: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3357: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3358:
3359: l_cnt_app_mgr_final := l_cnt_app_mgr_final + ROUND(l_cnt_app_mgr/l_number_of_periods);
3360: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3353: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3354: hr_utility.set_location('l_cnt_app_clk '||l_cnt_app_clk,3170);
3355:
3356: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3357: hr_utility.set_location('l_cnt_app_oth '||l_cnt_app_oth,3170);
3358:
3359: l_cnt_app_mgr_final := l_cnt_app_mgr_final + ROUND(l_cnt_app_mgr/l_number_of_periods);
3360: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3361: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3359: l_cnt_app_mgr_final := l_cnt_app_mgr_final + ROUND(l_cnt_app_mgr/l_number_of_periods);
3360: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3361: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3362:
3363: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3364: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3365: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3366: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3367: END IF;
3360: l_cnt_app_clk_final := l_cnt_app_clk_final + ROUND(l_cnt_app_clk/l_number_of_periods);
3361: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3362:
3363: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3364: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3365: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3366: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3367: END IF;
3368:
3361: l_cnt_app_oth_final := l_cnt_app_oth_final + ROUND(l_cnt_app_oth/l_number_of_periods);
3362:
3363: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3364: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3365: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3366: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3367: END IF;
3368:
3369:
3362:
3363: hr_utility.set_location('Inside IF l_number_of_periods > 0 after ',3170);
3364: hr_utility.set_location('l_cnt_app_mgr_final '||l_cnt_app_mgr_final,3170);
3365: hr_utility.set_location('l_cnt_app_clk_final '||l_cnt_app_clk_final,3170);
3366: hr_utility.set_location('l_cnt_app_oth_final '||l_cnt_app_oth_final,3170);
3367: END IF;
3368:
3369:
3370: END LOOP;
3369:
3370: END LOOP;
3371:
3372:
3373: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);
3374: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);
3375:
3376: pay_action_information_api.create_action_information
3377: ( p_action_information_id => l_action_info_id
3370: END LOOP;
3371:
3372:
3373: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);
3374: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);
3375:
3376: pay_action_information_api.create_action_information
3377: ( p_action_information_id => l_action_info_id
3378: ,p_action_context_id => l_payroll_action_id
3414: ,p_action_information30 => NVL(l_tab_get_override_totals('P').l_sum_nmw,l_tab_get_totals('P').nmw_pt_ft_mg_cl_ot)
3415: );
3416:
3417:
3418: hr_utility.set_location('After Inserting IE_EHECS_PART1 ',3200);
3419:
3420: l_appwgmg := NVL(l_tab_get_override_totals('M').l_sum_regwg_at,NVL(l_tab_get_totals('M').regwg_at_mg_cl_ot,0))
3421: + NVL(l_tab_get_override_totals('M').l_sum_ovrt_at,NVL(l_tab_get_totals('M').ovrt_at_mg_cl_ot,0))
3422: + NVL(l_tab_get_override_totals('M').l_sum_irrb_at,NVL(l_tab_get_totals('M').irrb_at_mg_cl_ot,0));
3428: l_appwgot := NVL(l_tab_get_override_totals('P').l_sum_regwg_at,NVL(l_tab_get_totals('P').regwg_at_mg_cl_ot,0))
3429: + NVL(l_tab_get_override_totals('P').l_sum_ovrt_at,NVL(l_tab_get_totals('P').ovrt_at_mg_cl_ot,0))
3430: + NVL(l_tab_get_override_totals('P').l_sum_irrb_at,NVL(l_tab_get_totals('P').irrb_at_mg_cl_ot,0));
3431:
3432: hr_utility.set_location('Before Inserting IE_EHECS_PART2 ',3210);
3433:
3434: pay_action_information_api.create_action_information
3435: ( p_action_information_id => l_action_info_id
3436: ,p_action_context_id => l_payroll_action_id
3462: ,p_action_information20 => l_appwgcl
3463: ,p_action_information21 => l_appwgot
3464: );
3465:
3466: hr_utility.set_location('After Inserting IE_EHECS_PART2 ',3220);
3467:
3468: pay_action_information_api.create_action_information
3469: ( p_action_information_id => l_action_info_id
3470: ,p_action_context_id => l_payroll_action_id
3493: ,p_action_information17 => NVL(l_tab_get_override_totals('C').l_sum_othr_at,NVL(l_tab_get_totals('C').othr_at_mg_cl_ot,0))
3494: ,p_action_information18 => NVL(l_tab_get_override_totals('P').l_sum_othr_at,NVL(l_tab_get_totals('P').othr_at_mg_cl_ot,0))
3495: );
3496:
3497: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);
3498:
3499: /* 6856473 */
3500: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3501: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3496:
3497: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);
3498:
3499: /* 6856473 */
3500: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3501: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3502: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);
3503:
3504:
3497: hr_utility.set_location('After Inserting IE_EHECS_PART3 ',3230);
3498:
3499: /* 6856473 */
3500: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3501: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3502: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);
3503:
3504:
3505: l_lapmg := NVL(l_tab_get_override_totals('M').l_sum_al_at,NVL(l_tab_get_totals('M').al_at_mg_cl_ot,0)) -- 6856473
3498:
3499: /* 6856473 */
3500: hr_utility.set_location(' l_tab_get_totals:M.al_at_mg_cl_ot ' || l_tab_get_totals('M').al_at_mg_cl_ot,3230);
3501: hr_utility.set_location(' l_tab_get_totals:C.al_at_mg_cl_ot ' || l_tab_get_totals('C').al_at_mg_cl_ot,3230);
3502: hr_utility.set_location(' l_tab_get_totals:P.al_at_mg_cl_ot ' || l_tab_get_totals('P').al_at_mg_cl_ot,3230);
3503:
3504:
3505: l_lapmg := NVL(l_tab_get_override_totals('M').l_sum_al_at,NVL(l_tab_get_totals('M').al_at_mg_cl_ot,0)) -- 6856473
3506: + NVL(l_tab_get_override_totals('M').l_sum_mat_at,NVL(l_tab_get_totals('M').mat_at_mg_cl_ot,0))
3516: + NVL(l_tab_get_override_totals('P').l_sum_mat_at,NVL(l_tab_get_totals('P').mat_at_mg_cl_ot,0))
3517: + NVL(l_tab_get_override_totals('P').l_sum_sic_at,NVL(l_tab_get_totals('P').sic_at_mg_cl_ot,0))
3518: + NVL(l_tab_get_override_totals('P').l_sum_otl_at,NVL(l_tab_get_totals('P').otl_at_mg_cl_ot,0));
3519:
3520: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);
3521:
3522: /* 6856473 */
3523: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3524: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3519:
3520: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);
3521:
3522: /* 6856473 */
3523: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3524: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3525: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3526:
3527:
3520: hr_utility.set_location('Before Inserting IE_EHECS_PART4 ',3240);
3521:
3522: /* 6856473 */
3523: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3524: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3525: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3526:
3527:
3528: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3521:
3522: /* 6856473 */
3523: hr_utility.set_location(' l_tab_get_totals:M.al_ft_mg_cl_ot ' || l_tab_get_totals('M').al_ft_mg_cl_ot,3230);
3524: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3525: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3526:
3527:
3528: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3529: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3524: hr_utility.set_location(' l_tab_get_totals:C.al_ft_mg_cl_ot ' || l_tab_get_totals('C').al_ft_mg_cl_ot,3230);
3525: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3526:
3527:
3528: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3529: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3530: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3531: pay_action_information_api.create_action_information
3532: ( p_action_information_id => l_action_info_id
3525: hr_utility.set_location(' l_tab_get_totals:P.al_ft_mg_cl_ot ' || l_tab_get_totals('P').al_ft_mg_cl_ot,3230);
3526:
3527:
3528: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3529: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3530: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3531: pay_action_information_api.create_action_information
3532: ( p_action_information_id => l_action_info_id
3533: ,p_action_context_id => l_payroll_action_id
3526:
3527:
3528: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3529: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3530: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3531: pay_action_information_api.create_action_information
3532: ( p_action_information_id => l_action_info_id
3533: ,p_action_context_id => l_payroll_action_id
3534: ,p_action_context_type => 'PA'
3565: ,p_action_information26 => l_lapcl
3566: ,p_action_information27 => l_lapot
3567: );
3568:
3569: hr_utility.set_location('After Inserting IE_EHECS_PART4 ',3250);
3570:
3571: l_ssecapmg := NVL(l_tab_get_totals('M').prsi_at_mg_cl_ot,0)
3572: + NVL(l_tab_get_override_totals('M').l_sum_incc_at,NVL(l_tab_get_totals('M').incct_at_mg_cl_ot,0))
3573: + NVL(l_tab_get_override_totals('M').l_sum_red_at,NVL(l_tab_get_totals('M').red_at_mg_cl_ot,0))
3582: + NVL(l_tab_get_override_totals('P').l_sum_incc_at,NVL(l_tab_get_totals('P').incct_at_mg_cl_ot,0))
3583: + NVL(l_tab_get_override_totals('P').l_sum_red_at,NVL(l_tab_get_totals('P').red_at_mg_cl_ot,0))
3584: + NVL(l_tab_get_override_totals('P').l_sum_otsoc_at,NVL(l_tab_get_totals('P').otsoc_at_mg_cl_ot,0));
3585:
3586: hr_utility.set_location('Before Inserting IE_EHECS_PART7 ',3260);
3587:
3588: pay_action_information_api.create_action_information
3589: ( p_action_information_id => l_action_info_id
3590: ,p_action_context_id => l_payroll_action_id
3610: ,p_action_information14 => l_ssecapcl
3611: ,p_action_information15 => l_ssecapot
3612: );
3613:
3614: hr_utility.set_location('After Inserting IE_EHECS_PART7 ',3270);
3615:
3616: pay_action_information_api.create_action_information
3617: ( p_action_information_id => l_action_info_id
3618: ,p_action_context_id => l_payroll_action_id
3638: ,p_action_information14 => NVL(l_tab_get_override_totals('C').l_sum_otben_ft,NVL(l_tab_get_totals('C').otben_pt_ft_mg_cl_ot,0))
3639: ,p_action_information15 => NVL(l_tab_get_override_totals('P').l_sum_otben_ft,NVL(l_tab_get_totals('P').otben_pt_ft_mg_cl_ot,0))
3640: );
3641:
3642: hr_utility.set_location('After Inserting IE_EHECS_PART8 ',3270);
3643:
3644: pay_action_information_api.create_action_information
3645: ( p_action_information_id => l_action_info_id
3646: ,p_action_context_id => l_payroll_action_id
3662: ,p_action_information10 => NULL -- not used
3663: ,p_action_information11 => NULL -- not used
3664: ,p_action_information12 => NULL -- not used
3665: );
3666: hr_utility.set_location('After Inserting IE_EHECS_ALL_OTHER ',3280);
3667:
3668: OPEN c_get_part1(l_payroll_action_id);
3669: FETCH c_get_part1 INTO l_data_part1;
3670: CLOSE c_get_part1;
3667:
3668: OPEN c_get_part1(l_payroll_action_id);
3669: FETCH c_get_part1 INTO l_data_part1;
3670: CLOSE c_get_part1;
3671: hr_utility.set_location('After c_get_part1',3281);
3672: OPEN c_get_part2(l_payroll_action_id);
3673: FETCH c_get_part2 INTO l_data_part2;
3674: CLOSE c_get_part2;
3675:
3672: OPEN c_get_part2(l_payroll_action_id);
3673: FETCH c_get_part2 INTO l_data_part2;
3674: CLOSE c_get_part2;
3675:
3676: hr_utility.set_location('After c_get_part2',3281);
3677: OPEN c_get_part3(l_payroll_action_id);
3678: FETCH c_get_part3 INTO l_data_part3;
3679: CLOSE c_get_part3;
3680:
3677: OPEN c_get_part3(l_payroll_action_id);
3678: FETCH c_get_part3 INTO l_data_part3;
3679: CLOSE c_get_part3;
3680:
3681: hr_utility.set_location('After c_get_part3',3281);
3682: OPEN c_get_part4(l_payroll_action_id);
3683: FETCH c_get_part4 INTO l_data_part4;
3684: CLOSE c_get_part4;
3685:
3682: OPEN c_get_part4(l_payroll_action_id);
3683: FETCH c_get_part4 INTO l_data_part4;
3684: CLOSE c_get_part4;
3685:
3686: hr_utility.set_location('After c_get_part4',3281);
3687: OPEN c_get_part7(l_payroll_action_id);
3688: FETCH c_get_part7 INTO l_data_part7;
3689: CLOSE c_get_part7;
3690:
3687: OPEN c_get_part7(l_payroll_action_id);
3688: FETCH c_get_part7 INTO l_data_part7;
3689: CLOSE c_get_part7;
3690:
3691: hr_utility.set_location('After c_get_part7',3281);
3692: OPEN c_get_part8(l_payroll_action_id);
3693: FETCH c_get_part8 INTO l_data_part8;
3694: CLOSE c_get_part8;
3695:
3692: OPEN c_get_part8(l_payroll_action_id);
3693: FETCH c_get_part8 INTO l_data_part8;
3694: CLOSE c_get_part8;
3695:
3696: hr_utility.set_location('After c_get_part8',3281);
3697: OPEN c_get_part_all_other(l_payroll_action_id);
3698: FETCH c_get_part_all_other INTO l_data_part_all_other;
3699: CLOSE c_get_part_all_other;
3700:
3697: OPEN c_get_part_all_other(l_payroll_action_id);
3698: FETCH c_get_part_all_other INTO l_data_part_all_other;
3699: CLOSE c_get_part_all_other;
3700:
3701: hr_utility.set_location('After c_get_partall ote',3281);
3702:
3703: hr_utility.set_location('After Fetching ALL Cursors.',3280);
3704:
3705: --for l_data_part1 in c_get_part1(l_payroll_action_id)
3699: CLOSE c_get_part_all_other;
3700:
3701: hr_utility.set_location('After c_get_partall ote',3281);
3702:
3703: hr_utility.set_location('After Fetching ALL Cursors.',3280);
3704:
3705: --for l_data_part1 in c_get_part1(l_payroll_action_id)
3706: --loop
3707:
5308: l_string:=l_string || '
5309:
5310: --end loop;
5311:
5312: hr_utility.set_location('Before completing the l_data_part1: length(l_string) = '||length(l_string),3300);
5313: l_clob := l_clob||l_string;
5314:
5315: IF l_clob IS NOT NULL THEN
5316: l_blob := c2b(l_clob);
5321: l_clob:='';
5322:
5323: --for l_data_part2 in c_get_part2(l_payroll_action_id)
5324: --loop
5325: hr_utility.set_location('entering c_get_part2 ',280);
5326: l_string:=l_string || '
5327: l_string:=l_string || '
5328: l_string:=l_string || '
5329: l_string:=l_string || '
5345: l_string:=l_string || '
5346: l_string:=l_string || '
5347: -- end loop;
5348:
5349: hr_utility.set_location('Before completing the l_data_part2: length(l_string) = '||length(l_string),3310);
5350: l_clob := l_clob||l_string;
5351:
5352: IF l_clob IS NOT NULL THEN
5353: l_blob := c2b(l_clob);
5357: l_string:='';
5358: l_clob:='';
5359: --for l_data_part3 in c_get_part3(l_payroll_action_id)
5360: --loop
5361: hr_utility.set_location('entering c_get_part3 ',280);
5362: l_string:=l_string || '
5363: l_string:=l_string || '
5364: l_string:=l_string || '
5365: l_string:=l_string || '
5378: l_string:=l_string || '
5379: l_string:=l_string || '
5380: -- end loop;
5381:
5382: hr_utility.set_location('Before completing the l_data_part3: length(l_string) = '||length(l_string),3320);
5383: l_clob := l_clob||l_string;
5384:
5385: IF l_clob IS NOT NULL THEN
5386: l_blob := c2b(l_clob);
5390: l_string:='';
5391: l_clob:='';
5392: --for l_data_part4 in c_get_part4(l_payroll_action_id)
5393: --loop
5394: hr_utility.set_location('entering c_get_part4 ',280);
5395: l_string:=l_string || '
5396: l_string:=l_string || '
5397: l_string:=l_string || '
5398: l_string:=l_string || '
5420: l_string:=l_string || '
5421: l_string:=l_string || '
5422: --end loop;
5423:
5424: hr_utility.set_location('Before completing the l_data_part4: length(l_string) = '||length(l_string),3330);
5425: l_clob := l_clob||l_string;
5426:
5427: IF l_clob IS NOT NULL THEN
5428: l_blob := c2b(l_clob);
5444: l_string:=l_string || '
5445:
5446: --for l_data_part7 in c_get_part7(l_payroll_action_id)
5447: --loop
5448: hr_utility.set_location('entering c_get_part7 ',280);
5449: l_string:=l_string || '
5450: l_string:=l_string || '
5451: l_string:=l_string || '
5452: l_string:=l_string || '
5462: l_string:=l_string || '
5463: l_string:=l_string || '
5464: --end loop;
5465:
5466: hr_utility.set_location('Before completing the l_data_part7: length(l_string) = '||length(l_string),3340);
5467: l_clob := l_clob||l_string;
5468:
5469: IF l_clob IS NOT NULL THEN
5470: l_blob := c2b(l_clob);
5473: l_string:='';
5474: l_clob:='';
5475: --for l_data_part8 in c_get_part8(l_payroll_action_id)
5476: --loop
5477: hr_utility.set_location('entering c_get_part8 ',280);
5478: l_string:=l_string || '
5479: l_string:=l_string || '
5480: l_string:=l_string || '
5481: l_string:=l_string || '
5491: l_string:=l_string || '
5492: l_string:=l_string || '
5493: --end loop;
5494:
5495: hr_utility.set_location('Before completing the l_data_part8: length(l_string) = '||length(l_string),3350);
5496:
5497: /*
5498: for l_data_part_all_other in c_get_part_all_other(l_payroll_action_id)
5499: loop
5497: /*
5498: for l_data_part_all_other in c_get_part_all_other(l_payroll_action_id)
5499: loop
5500: */
5501: hr_utility.set_location('entering c_get_part others ',280);
5502: l_string:=l_string || '
5503: l_string:=l_string || '
5504: l_string:=l_string || '
5505: l_string:=l_string || '
5516: */
5517: l_string:=l_string || '
5518:
5519: l_string := l_string ||''||EOL ; --7367314
5520: hr_utility.set_location('Before completing the l_data_part_all_other: length(l_string) = '||length(l_string),3360);
5521:
5522: l_clob := l_clob||l_string;
5523:
5524: IF l_clob IS NOT NULL THEN
5539:
5540:
5541: EXCEPTION
5542: WHEN l_ehecs_exception THEN
5543: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
5544: l_string := l_string ||''||EOL ; --7367314
5545: l_clob := l_clob||l_string;
5546: IF l_clob IS NOT NULL THEN
5547: l_blob := c2b(l_clob);
5548: pay_core_files.write_to_magtape_lob(l_blob);
5549: END IF;
5550: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','EHECS Report errors out.');
5551: WHEN Others THEN
5552: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,3370);
5553: l_string := l_string ||''||EOL ; --7367314
5554: l_clob := l_clob||l_string;
5555: IF l_clob IS NOT NULL THEN
5556: l_blob := c2b(l_clob);