209: IF user_row_id_csr%NOTFOUND THEN
210: --
211: SELECT pay_user_rows_s.nextval
212: INTO v_user_row_id
213: FROM dual;
214:
215: -- this insertion creates the row
216:
217: hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);
1732: --
1733: hr_summary_api.CREATE_ITEM_TYPE (p_item_type_id => l_id_value
1734: ,p_business_group_id => p_business_group_id
1735: ,p_object_version_number => l_object_version_number
1736: ,p_name => 'INDIVIDUAL_WORK_PATTERN'
1737: ,p_units => 'HEADCOUNT'
1738: ,p_datatype => 'N'
1739: ,p_count_clause1 => 'count(distinct(p.person_id))'
1740: ,p_seeded_data => 'Y'
1804: , per_all_people_f p
1805: , per_assignment_status_types per_ast
1806: , per_all_assignments_f a
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1805: , per_assignment_status_types per_ast
1806: , per_all_assignments_f a
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1806: , per_all_assignments_f a
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1807: , P_ESTABLISHMENT_TABLE
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1808: , (select ''01'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1809: union select ''02'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1810: union select ''03'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1811: union select ''04'' month from sys.dual
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1812: union select ''05'' month from sys.dual
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1813: union select ''06'' month from sys.dual
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1821: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1814: union select ''07'' month from sys.dual
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1821: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1822: and a.assignment_type = ''E''
1815: union select ''08'' month from sys.dual
1816: union select ''09'' month from sys.dual
1817: union select ''10'' month from sys.dual
1818: union select ''11'' month from sys.dual
1819: union select ''12'' month from sys.dual) m
1820: where a.establishment_id = v.establishment_id
1821: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1822: and a.assignment_type = ''E''
1823: and userenv(''lang'')=pt.language
1891: , per_all_people_f p
1892: , per_assignment_status_types per_ast
1893: , per_all_assignments_f a
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1892: , per_assignment_status_types per_ast
1893: , per_all_assignments_f a
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1893: , per_all_assignments_f a
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1894: , P_ESTABLISHMENT_TABLE
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1895: , (select ''01'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1896: union select ''02'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1897: union select ''03'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1898: union select ''04'' month from sys.dual
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1899: union select ''05'' month from sys.dual
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1900: union select ''06'' month from sys.dual
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1908: and userenv(''lang'')=pt.language
1901: union select ''07'' month from sys.dual
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1908: and userenv(''lang'')=pt.language
1909: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1902: union select ''08'' month from sys.dual
1903: union select ''09'' month from sys.dual
1904: union select ''10'' month from sys.dual
1905: union select ''11'' month from sys.dual
1906: union select ''12'' month from sys.dual) m
1907: where a.establishment_id = v.establishment_id
1908: and userenv(''lang'')=pt.language
1909: and a.assignment_status_type_id = per_ast.assignment_status_type_id
1910: and a.assignment_type = ''E''
1980: , per_bf_balances_v bal
1981: , per_person_types_tl pt
1982: , per_all_people_f p
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1981: , per_person_types_tl pt
1982: , per_all_people_f p
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1982: , per_all_people_f p
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1983: , per_all_assignments_f a
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1984: , (select ''01'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1985: union select ''02'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1986: union select ''03'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1987: union select ''04'' month from sys.dual
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1988: union select ''05'' month from sys.dual
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1989: union select ''06'' month from sys.dual
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1997: (select max(p2.effective_start_date),max(a2.effective_start_date)
1990: union select ''07'' month from sys.dual
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1997: (select max(p2.effective_start_date),max(a2.effective_start_date)
1998: from per_person_types_tl pt2
1991: union select ''08'' month from sys.dual
1992: union select ''09'' month from sys.dual
1993: union select ''10'' month from sys.dual
1994: union select ''11'' month from sys.dual
1995: union select ''12'' month from sys.dual) m
1996: where (p.effective_start_date,a.effective_start_date) =
1997: (select max(p2.effective_start_date),max(a2.effective_start_date)
1998: from per_person_types_tl pt2
1999: , per_all_people_f p2
2068: , per_all_people_f p
2069: , per_assignment_status_types per_ast
2070: , per_all_assignments_f a
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2069: , per_assignment_status_types per_ast
2070: , per_all_assignments_f a
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2070: , per_all_assignments_f a
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2071: , P_ESTABLISHMENT_TABLE
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2072: , (select ''01'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2073: union select ''02'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2074: union select ''03'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2075: union select ''04'' month from sys.dual
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2076: union select ''05'' month from sys.dual
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2077: union select ''06'' month from sys.dual
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2085: and userenv(''lang'')=pt.language
2078: union select ''07'' month from sys.dual
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2085: and userenv(''lang'')=pt.language
2086: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2079: union select ''08'' month from sys.dual
2080: union select ''09'' month from sys.dual
2081: union select ''10'' month from sys.dual
2082: union select ''11'' month from sys.dual
2083: union select ''12'' month from sys.dual) m
2084: where a.establishment_id = v.establishment_id
2085: and userenv(''lang'')=pt.language
2086: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2087: and a.assignment_type = ''E''
2148: , per_all_people_f p
2149: , per_assignment_status_types per_ast
2150: , per_all_assignments_f a
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2149: , per_assignment_status_types per_ast
2150: , per_all_assignments_f a
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2150: , per_all_assignments_f a
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2151: , P_ESTABLISHMENT_TABLE
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2152: , (select ''01'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2153: union select ''02'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2154: union select ''03'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2155: union select ''04'' month from sys.dual
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2156: union select ''05'' month from sys.dual
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2157: union select ''06'' month from sys.dual
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2165: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2158: union select ''07'' month from sys.dual
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2165: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2166: and a.assignment_type = ''E''
2159: union select ''08'' month from sys.dual
2160: union select ''09'' month from sys.dual
2161: union select ''10'' month from sys.dual
2162: union select ''11'' month from sys.dual
2163: union select ''12'' month from sys.dual) m
2164: where a.establishment_id = v.establishment_id
2165: and a.assignment_status_type_id = per_ast.assignment_status_type_id
2166: and a.assignment_type = ''E''
2167: RESTRICTION.PRIMARY_FLAG[a]
6584: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6585: ,p_business_group_id => p_business_group_id
6586: ,p_object_version_number => l_object_version_number
6587: ,p_seeded_data => 'Y'
6588: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6589: ,p_restriction_type_id => hr_summary_api.get_id('EMPLOYMENT_CATEGORY','RESTRICTION_TYPE',p_business_group_id));
6590: --
6591: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6592: ,p_business_group_id => p_business_group_id
6591: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6592: ,p_business_group_id => p_business_group_id
6593: ,p_object_version_number => l_object_version_number
6594: ,p_seeded_data => 'Y'
6595: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6596: ,p_restriction_type_id => hr_summary_api.get_id('WORK_PATTERN','RESTRICTION_TYPE',p_business_group_id));
6597: --
6598: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6599: ,p_business_group_id => p_business_group_id
6598: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6599: ,p_business_group_id => p_business_group_id
6600: ,p_object_version_number => l_object_version_number
6601: ,p_seeded_data => 'Y'
6602: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6603: ,p_restriction_type_id => hr_summary_api.get_id('ASSIGNMENT_STATUS_TYPE','RESTRICTION_TYPE',p_business_group_id));
6604: --
6605: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6606: ,p_business_group_id => p_business_group_id
6605: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6606: ,p_business_group_id => p_business_group_id
6607: ,p_object_version_number => l_object_version_number
6608: ,p_seeded_data => 'Y'
6609: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6610: ,p_restriction_type_id => hr_summary_api.get_id('NEW_USER_PERSON_TYPE','RESTRICTION_TYPE',p_business_group_id));
6611: --
6612: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6613: ,p_business_group_id => p_business_group_id
6612: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6613: ,p_business_group_id => p_business_group_id
6614: ,p_object_version_number => l_object_version_number
6615: ,p_seeded_data => 'Y'
6616: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id)
6617: ,p_restriction_type_id => hr_summary_api.get_id('PRIMARY_FLAG','RESTRICTION_TYPE',p_business_group_id));
6618: --
6619: hr_summary_api.CREATE_VALID_RESTRICTION (p_valid_restriction_id => l_id_value
6620: ,p_business_group_id => p_business_group_id
7708: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
7709: ,p_business_group_id => p_business_group_id
7710: ,p_object_version_number => l_object_version_number
7711: ,p_sequence_number => 62
7712: ,p_name => 'Individual Work Pattern'
7713: ,p_seeded_data => 'Y'
7714: ,p_template_id => l_template_id
7715: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
7716: --
7711: ,p_sequence_number => 62
7712: ,p_name => 'Individual Work Pattern'
7713: ,p_seeded_data => 'Y'
7714: ,p_template_id => l_template_id
7715: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
7716: --
7717: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
7718: ,p_business_group_id => p_business_group_id
7719: ,p_object_version_number => l_object_version_number
8230: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
8231: ,p_business_group_id => p_business_group_id
8232: ,p_object_version_number => l_object_version_number
8233: ,p_sequence_number => 62
8234: ,p_name => 'Individual Work Pattern'
8235: ,p_seeded_data => 'Y'
8236: ,p_template_id => l_template_id
8237: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
8238: --
8233: ,p_sequence_number => 62
8234: ,p_name => 'Individual Work Pattern'
8235: ,p_seeded_data => 'Y'
8236: ,p_template_id => l_template_id
8237: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
8238: --
8239: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
8240: ,p_business_group_id => p_business_group_id
8241: ,p_object_version_number => l_object_version_number
9157: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9158: ,p_business_group_id => p_business_group_id
9159: ,p_object_version_number => l_object_version_number
9160: ,p_seeded_data => 'Y'
9161: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9162: ,p_valid_restriction_id => hr_summary_api.get_ru_id('ASSIGNMENT_STATUS_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9163: ,p_restriction_type => 'IN');
9164: --
9165: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9158: ,p_business_group_id => p_business_group_id
9159: ,p_object_version_number => l_object_version_number
9160: ,p_seeded_data => 'Y'
9161: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9162: ,p_valid_restriction_id => hr_summary_api.get_ru_id('ASSIGNMENT_STATUS_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9163: ,p_restriction_type => 'IN');
9164: --
9165: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9166: ,p_business_group_id => p_business_group_id
9165: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9166: ,p_business_group_id => p_business_group_id
9167: ,p_object_version_number => l_object_version_number
9168: ,p_seeded_data => 'Y'
9169: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9170: ,p_valid_restriction_id => hr_summary_api.get_ru_id('EMPLOYMENT_CATEGORY','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9171: ,p_restriction_type => 'IN');
9172: --
9173: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9166: ,p_business_group_id => p_business_group_id
9167: ,p_object_version_number => l_object_version_number
9168: ,p_seeded_data => 'Y'
9169: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9170: ,p_valid_restriction_id => hr_summary_api.get_ru_id('EMPLOYMENT_CATEGORY','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9171: ,p_restriction_type => 'IN');
9172: --
9173: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9174: ,p_business_group_id => p_business_group_id
9173: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9174: ,p_business_group_id => p_business_group_id
9175: ,p_object_version_number => l_object_version_number
9176: ,p_seeded_data => 'Y'
9177: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9178: ,p_valid_restriction_id => hr_summary_api.get_ru_id('NEW_USER_PERSON_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9179: ,p_restriction_type => 'IN');
9180: --
9181: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9174: ,p_business_group_id => p_business_group_id
9175: ,p_object_version_number => l_object_version_number
9176: ,p_seeded_data => 'Y'
9177: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9178: ,p_valid_restriction_id => hr_summary_api.get_ru_id('NEW_USER_PERSON_TYPE','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9179: ,p_restriction_type => 'IN');
9180: --
9181: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9182: ,p_business_group_id => p_business_group_id
9181: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9182: ,p_business_group_id => p_business_group_id
9183: ,p_object_version_number => l_object_version_number
9184: ,p_seeded_data => 'Y'
9185: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9186: ,p_valid_restriction_id => hr_summary_api.get_ru_id('WORK_PATTERN','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9187: ,p_restriction_type => 'IN');
9188: --
9189: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9182: ,p_business_group_id => p_business_group_id
9183: ,p_object_version_number => l_object_version_number
9184: ,p_seeded_data => 'Y'
9185: ,p_item_type_usage_id => hr_summary_api.get_itu_id(l_template_name,'INDIVIDUAL_WORK_PATTERN','Individual Work Pattern',p_business_group_id)
9186: ,p_valid_restriction_id => hr_summary_api.get_ru_id('WORK_PATTERN','INDIVIDUAL_WORK_PATTERN',p_business_group_id)
9187: ,p_restriction_type => 'IN');
9188: --
9189: hr_summary_api.CREATE_RESTRICTION_USAGE (p_restriction_usage_id => l_id_value
9190: ,p_business_group_id => p_business_group_id
11286: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
11287: ,p_business_group_id => p_business_group_id
11288: ,p_object_version_number => l_object_version_number
11289: ,p_sequence_number => 62
11290: ,p_name => 'C4 - Number of employees on an individual work schedule'
11291: ,p_seeded_data => 'Y'
11292: ,p_template_id => l_template_id
11293: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
11294: --
11289: ,p_sequence_number => 62
11290: ,p_name => 'C4 - Number of employees on an individual work schedule'
11291: ,p_seeded_data => 'Y'
11292: ,p_template_id => l_template_id
11293: ,p_item_type_id => hr_summary_api.get_id('INDIVIDUAL_WORK_PATTERN','ITEM_TYPE',p_business_group_id));
11294: --
11295: hr_summary_api.CREATE_ITEM_TYPE_USAGE (p_item_type_usage_id => l_id_value
11296: ,p_business_group_id => p_business_group_id
11297: ,p_object_version_number => l_object_version_number