DBA Data[Home] [Help]

APPS.PAY_NO_ABS_STATISTICS_REPORT dependencies on HR_GENERAL

Line 257: abstotal(4).quatertag:= hr_general.decode_lookup('NO_FORM_LABELS','ASR04');

253: End if;
254:
255:
256: abstotal(4).initialized:='Y';
257: abstotal(4).quatertag:= hr_general.decode_lookup('NO_FORM_LABELS','ASR04');
258: gplsqltable (l_counter).tagname := 'QUARTER';
259: gplsqltable (l_counter).tagvalue := csr_abs_stat_datas.quater;
260: l_counter := l_counter+ 1;
261: gplsqltable (l_counter).tagname := 'START';

Line 265: gplsqltable (l_counter).tagvalue := hr_general.decode_lookup('SEX',csr_abs_stat_datas.sex);

261: gplsqltable (l_counter).tagname := 'START';
262: gplsqltable (l_counter).tagvalue := 'START';
263: l_counter := l_counter+ 1;
264: gplsqltable (l_counter).tagname := csr_abs_stat_datas.sex||'_SEX';
265: gplsqltable (l_counter).tagvalue := hr_general.decode_lookup('SEX',csr_abs_stat_datas.sex);
266: l_counter := l_counter+ 1;
267: gplsqltable (l_counter).tagname := csr_abs_stat_datas.sex||'_POSSIBLE_WORKING_DAYS';
268: gplsqltable (l_counter).tagvalue := csr_abs_stat_datas.possible_working_days;
269: abstotal(4).possible_working_days:=nvl(abstotal(4).possible_working_days,0)+nvl(csr_abs_stat_datas.possible_working_days,0);

Line 364: absmale(0).quatertag:=hr_general.decode_lookup('NO_FORM_LABELS','ASR02');

360: gplsqltable (l_counter).tagvalue := 'END';
361: l_counter := l_counter + 1;
362: IF csr_abs_stat_datas.sex = 'M' THEN
363: absmale(0).initialized:='Y';
364: absmale(0).quatertag:=hr_general.decode_lookup('NO_FORM_LABELS','ASR02');
365: absmale(0).possible_working_days:= nvl(absmale(0).possible_working_days,0)+nvl(csr_abs_stat_datas.possible_working_days,0);
366: absmale(0).sick_1_3_ocr_sc :=nvl(absmale(0).sick_1_3_ocr_sc,0)+nvl(csr_abs_stat_datas.occur_1_3_days_sc,0);
367: absmale(0).sick_1_3_days_sc :=nvl(absmale(0).sick_1_3_days_sc,0)+nvl(csr_abs_stat_datas.sc_1_3_abs_days,0);
368: absmale(0).sick_1_3_ocr_dc :=nvl(absmale(0).sick_1_3_ocr_dc,0)+nvl(csr_abs_stat_datas.dc_1_3_days_Occur,0);

Line 386: absfemale(0).quatertag:=hr_general.decode_lookup('NO_FORM_LABELS','ASR03');

382: absmale(0).other_abs_paid_ocrs:=nvl(absmale(0).other_abs_paid_ocrs,0)+nvl(csr_abs_stat_datas.other_abs_paid_ocrs,0);
383: absmale(0).other_abs_paid_days:=nvl(absmale(0).other_abs_paid_days,0)+nvl(csr_abs_stat_datas.other_abs_paid_days,0);
384: ELSIF csr_abs_stat_datas.sex = 'F' THEN
385: absfemale(0).initialized:='Y';
386: absfemale(0).quatertag:=hr_general.decode_lookup('NO_FORM_LABELS','ASR03');
387: absfemale(0).possible_working_days :=nvl(absfemale(0).possible_working_days,0)+nvl(csr_abs_stat_datas.possible_working_days,0);
388: absfemale(0).sick_1_3_ocr_sc :=nvl(absfemale(0).sick_1_3_ocr_sc,0)+nvl(csr_abs_stat_datas.occur_1_3_days_sc,0);
389: absfemale(0).sick_1_3_days_sc :=nvl(absfemale(0).sick_1_3_days_sc,0)+nvl(csr_abs_stat_datas.sc_1_3_abs_days,0);
390: absfemale(0).sick_1_3_ocr_dc :=nvl(absfemale(0).sick_1_3_ocr_dc,0)+nvl(csr_abs_stat_datas.dc_1_3_days_Occur,0);

Line 409: abstotal(l_quater_count).quatertag:=hr_general.decode_lookup('NO_FORM_LABELS','ASR01');

405: absfemale(0).other_abs_paid_days :=nvl(absfemale(0).other_abs_paid_days,0)+nvl(csr_abs_stat_datas.other_abs_paid_days,0);
406: END IF;
407:
408: abstotal(l_quater_count).initialized:='Y';
409: abstotal(l_quater_count).quatertag:=hr_general.decode_lookup('NO_FORM_LABELS','ASR01');
410: abstotal(l_quater_count).possible_working_days :=nvl(abstotal(l_quater_count).possible_working_days,0)+nvl(csr_abs_stat_datas.possible_working_days,0);
411: abstotal(l_quater_count).sick_1_3_ocr_sc :=nvl(abstotal(l_quater_count).sick_1_3_ocr_sc,0)+nvl(csr_abs_stat_datas.occur_1_3_days_sc,0);
412: abstotal(l_quater_count).sick_1_3_days_sc :=nvl(abstotal(l_quater_count).sick_1_3_days_sc,0)+nvl(csr_abs_stat_datas.sc_1_3_abs_days,0);
413: abstotal(l_quater_count).sick_1_3_ocr_dc :=nvl(abstotal(l_quater_count).sick_1_3_ocr_dc,0)+nvl(csr_abs_stat_datas.dc_1_3_days_Occur,0);