DBA Data[Home] [Help]

APPS.PER_US_EEO4A_PKG dependencies on PER_US_EEO4A_PKG

Line 1: PACKAGE BODY "PER_US_EEO4A_PKG" AS

1: PACKAGE BODY "PER_US_EEO4A_PKG" AS
2: /* $Header: peuseeo4a.pkb 120.3.12020000.1 2012/07/16 10:21:50 agarai noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : PER_US_EEO4A_PKG

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : PER_US_EEO4A_PKG
21:
22: Description : This package is used by 'EEO4A Report (XML)' concurrent
23: program.
24:

Line 1542: g_select_clause :='count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''M'',1,null),null)) no_cons_wmale_emps,

1538:
1539: BEGIN
1540: g_business_group_id := p_business_group_id;
1541:
1542: g_select_clause :='count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''M'',1,null),null)) no_cons_wmale_emps,
1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,
1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,

Line 1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,

1539: BEGIN
1540: g_business_group_id := p_business_group_id;
1541:
1542: g_select_clause :='count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''M'',1,null),null)) no_cons_wmale_emps,
1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,
1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,

Line 1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,

1540: g_business_group_id := p_business_group_id;
1541:
1542: g_select_clause :='count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''M'',1,null),null)) no_cons_wmale_emps,
1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,
1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,

Line 1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,

1541:
1542: g_select_clause :='count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''M'',1,null),null)) no_cons_wmale_emps,
1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,
1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,

Line 1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,

1542: g_select_clause :='count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''M'',1,null),null)) no_cons_wmale_emps,
1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,
1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,

Line 1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,

1543: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''M'',1,null),null)) no_cons_hmale_emps,
1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,

Line 1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,

1544: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''M'',1,null),null)) no_cons_cmale_emps,
1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,
1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,

Line 1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,

1545: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''M'',1,null),null)) no_cons_fmale_emps,
1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,
1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,
1553: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''F'',1,null),null)) no_cons_ofemale_emps ';

Line 1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,

1546: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''M'',1,null),null)) no_cons_jmale_emps,
1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,
1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,
1553: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''F'',1,null),null)) no_cons_ofemale_emps ';
1554:

Line 1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,

1547: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''M'',1,null),null)) no_cons_omale_emps,
1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,
1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,
1553: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''F'',1,null),null)) no_cons_ofemale_emps ';
1554:
1555: g_from_where_clause := 'FROM per_all_people_f peo,

Line 1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,

1548: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),1,decode(peo.sex,''F'',1,null),null)) no_cons_wfemale_emps,
1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,
1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,
1553: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''F'',1,null),null)) no_cons_ofemale_emps ';
1554:
1555: g_from_where_clause := 'FROM per_all_people_f peo,
1556: per_all_assignments_f ass,

Line 1553: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''F'',1,null),null)) no_cons_ofemale_emps ';

1549: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),2,decode(peo.sex,''F'',1,null),null)) no_cons_hfemale_emps,
1550: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),3,decode(peo.sex,''F'',1,null),null)) no_cons_cfemale_emps,
1551: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),4,decode(peo.sex,''F'',1,null),null)) no_cons_ffemale_emps,
1552: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),5,decode(peo.sex,''F'',1,null),null)) no_cons_jfemale_emps,
1553: count(decode(per_us_eeo4a_pkg.derive_single_race(peo.person_id),6,decode(peo.sex,''F'',1,null),null)) no_cons_ofemale_emps ';
1554:
1555: g_from_where_clause := 'FROM per_all_people_f peo,
1556: per_all_assignments_f ass,
1557: per_assignment_status_types past,

Line 1800: END PER_US_EEO4A_PKG;

1796: fnd_file.put_line(fnd_file.OUTPUT, p_text);
1797:
1798: END write_to_concurrent_out;
1799:
1800: END PER_US_EEO4A_PKG;
1801: