8: P_CONC_REQUEST_ID := fnd_global.CONC_REQUEST_ID;
9: declare
10:
11: ret number;
12: l_gre_name per_ca_ee_extract_pkg.tab_varchar2;
13:
14: begin
15:
16: null;
18: hr_reports.get_business_group(p_business_group_id);
19:
20:
21:
22: ret := per_ca_ee_extract_pkg.check_gre_without_naic(p_business_group_id,
23: l_gre_name) ;
24: if ret = -1 then
25: /*srw.message(1,'The following GRE(s) has NAIC missing: ');*/null;
26:
31:
32: return (FALSE);
33: else
34:
35: ret := per_ca_ee_extract_pkg.form1(p_business_group_id,
36: p_conc_request_id,
37: p_year,
38: p_naic_code,
39: fnd_date.canonical_to_date(p_date_all_emp),
38: p_naic_code,
39: fnd_date.canonical_to_date(p_date_all_emp),
40: fnd_date.canonical_to_date(p_date_tmp_emp));
41:
42: ret := per_ca_ee_extract_pkg.form2n(p_business_group_id,
43: p_conc_request_id,
44: p_year,
45: fnd_date.canonical_to_date(p_date_tmp_emp));
46:
43: p_conc_request_id,
44: p_year,
45: fnd_date.canonical_to_date(p_date_tmp_emp));
46:
47: ret := per_ca_ee_extract_pkg.form2(p_business_group_id,
48: p_conc_request_id,
49: p_year,
50: fnd_date.canonical_to_date(p_date_tmp_emp));
51:
50: fnd_date.canonical_to_date(p_date_tmp_emp));
51:
52:
53:
54: ret := per_ca_ee_extract_pkg.form3(p_business_group_id,
55: p_conc_request_id,
56: p_year,
57: fnd_date.canonical_to_date(p_date_tmp_emp));
58:
55: p_conc_request_id,
56: p_year,
57: fnd_date.canonical_to_date(p_date_tmp_emp));
58:
59: ret := per_ca_ee_extract_pkg.form4(p_business_group_id,
60: p_conc_request_id,
61: p_year,
62: fnd_date.canonical_to_date(p_date_tmp_emp));
63: ret := per_ca_ee_extract_pkg.form5(p_business_group_id,
59: ret := per_ca_ee_extract_pkg.form4(p_business_group_id,
60: p_conc_request_id,
61: p_year,
62: fnd_date.canonical_to_date(p_date_tmp_emp));
63: ret := per_ca_ee_extract_pkg.form5(p_business_group_id,
64: p_conc_request_id,
65: p_year,
66: fnd_date.canonical_to_date(p_date_tmp_emp));
67: ret := per_ca_ee_extract_pkg.form6(p_business_group_id,
63: ret := per_ca_ee_extract_pkg.form5(p_business_group_id,
64: p_conc_request_id,
65: p_year,
66: fnd_date.canonical_to_date(p_date_tmp_emp));
67: ret := per_ca_ee_extract_pkg.form6(p_business_group_id,
68: p_conc_request_id,
69: p_year,
70: fnd_date.canonical_to_date(p_date_tmp_emp));
71: ret := per_ca_ee_extract_pkg.update_rec(p_conc_request_id);
67: ret := per_ca_ee_extract_pkg.form6(p_business_group_id,
68: p_conc_request_id,
69: p_year,
70: fnd_date.canonical_to_date(p_date_tmp_emp));
71: ret := per_ca_ee_extract_pkg.update_rec(p_conc_request_id);
72: return (TRUE);
73: end if;
74: end; end;
75: