eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_GB_PROCESS_P11D_ENTRIES_PKG

Line 1885: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);

1881: WHERE action_context_id = p_assignment_action_id AND
1882: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1883: AND action_context_type = 'AAP';
1884:
1885: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

Line 1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);

1882: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
1883: AND action_context_type = 'AAP';
1884:
1885: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

Line 1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);

1883: AND action_context_type = 'AAP';
1884:
1885: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

Line 1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);

1884:
1885: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

Line 1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

1885: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

Line 1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

1886: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

Line 1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

1887: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

Line 1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

1888: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

Line 1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

1889: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

Line 1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

1890: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

Line 1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

1891: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

Line 1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

1892: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

Line 1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

1893: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

Line 1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

1894: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

Line 1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

1895: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

Line 1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

1896: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

Line 1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

1897: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

Line 1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

1898: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

Line 1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

1899: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

Line 1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

1900: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

Line 1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

1901: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

Line 1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

1902: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

Line 1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

1903: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);

Line 1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

1904: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

Line 1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

1905: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

Line 1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

1906: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1914: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

Line 1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);

1907: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1914: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1915:

Line 1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

1908: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1914: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1915:
1916: SELECT action_information1, action_information2, action_information3, action_information4,

Line 1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

1909: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1914: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1915:
1916: SELECT action_information1, action_information2, action_information3, action_information4,
1917: action_information5, action_information6, action_information7, action_information8,

Line 1914: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

1910: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
1911: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val);
1912: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
1913: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
1914: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
1915:
1916: SELECT action_information1, action_information2, action_information3, action_information4,
1917: action_information5, action_information6, action_information7, action_information8,
1918: action_information9, action_information10, action_information11, action_information12,

Line 1937: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);

1933: WHERE action_context_id = p_assignment_action_id AND
1934: action_information_category ='GB P11D ASSIGNMENT RESULTB'
1935: AND action_context_type = 'AAP';
1936:
1937: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);

Line 1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);

1934: action_information_category ='GB P11D ASSIGNMENT RESULTB'
1935: AND action_context_type = 'AAP';
1936:
1937: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);

Line 1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);

1935: AND action_context_type = 'AAP';
1936:
1937: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);

Line 1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);

1936:
1937: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);

Line 1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);

1937: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_DESC', l_col1_val);
1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);

Line 1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);

1938: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_COST', l_col2_val);
1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);

Line 1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);

1939: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_AMG', l_col3_val);
1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);

Line 1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);

1940: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_CE', l_col4_val);
1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);

Line 1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);

1941: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('NA_DESC', l_col5_val);
1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);

Line 1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);

1942: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_COST', l_col6_val);
1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);

Line 1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);

1943: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_AMG', l_col7_val);
1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);

Line 1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);

1944: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('NA_CE', l_col8_val);
1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);

Line 1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);

1945: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N_TAXPAID', l_col9_val);
1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);

Line 1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);

1946: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_COST', l_col10_val);
1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);

Line 1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);

1947: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_AMG', l_col11_val);
1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);

Line 1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);

1948: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O1_CE', l_col12_val);
1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);

Line 1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);

1949: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_COST', l_col13_val);
1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);

Line 1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);

1950: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_AMG', l_col14_val);
1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);

Line 1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);

1951: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O2_CE', l_col15_val);
1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);

Line 1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);

1952: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O_TOI', l_col16_val);
1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);

Line 1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);

1953: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_COST', l_col17_val);
1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);

Line 1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);

1954: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_AMG', l_col18_val);
1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);

Line 1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);

1955: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O3_CE', l_col19_val);
1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);

Line 1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);

1956: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_COST', l_col20_val);
1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);

Line 1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);

1957: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_AMG', l_col21_val);
1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1965: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);

Line 1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);

1958: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O4_CE', l_col22_val);
1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1965: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1966:

Line 1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);

1959: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_COST', l_col23_val);
1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1965: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1966:
1967: --

Line 1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);

1960: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_AMG', l_col24_val);
1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1965: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1966:
1967: --
1968: SELECT action_information1, action_information2, action_information3, action_information4,

Line 1965: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);

1961: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O5_CE', l_col25_val);
1962: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('O6_DESC', l_col26_val);
1963: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_COST', l_col27_val);
1964: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_AMG', l_col28_val);
1965: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('O6_CE', l_col29_val);
1966:
1967: --
1968: SELECT action_information1, action_information2, action_information3, action_information4,
1969: action_information5, action_information6, action_information7, action_information8,

Line 1989: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);

1985: WHERE action_context_id = p_assignment_action_id AND
1986: action_information_category ='GB P11D ASSIGNMENT RESULTC'
1987: AND action_context_type = 'AAP';
1988:
1989: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

Line 1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);

1986: action_information_category ='GB P11D ASSIGNMENT RESULTC'
1987: AND action_context_type = 'AAP';
1988:
1989: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

Line 1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);

1987: AND action_context_type = 'AAP';
1988:
1989: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

Line 1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);

1988:
1989: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

Line 1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

1989: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

Line 1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

1990: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1998:

Line 1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

1991: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1998:
1999: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);

Line 1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

1992: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1998:
1999: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);
2000: if l_ret_text = '1'

Line 1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

1993: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
1994: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1998:
1999: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);
2000: if l_ret_text = '1'
2001: then

Line 1999: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);

1995: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
1996: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
1997: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
1998:
1999: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('DT_FREE_FUEL_WITHDRAWN','D',l_col10_val);
2000: if l_ret_text = '1'
2001: then
2002: l_warn:=1;
2003: l_val_error_count := l_val_error_count + 1;

Line 2009: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);

2005: l_val_errors(l_val_error_count).error_assignment_name := l_assignment_name;
2006: l_val_errors(l_val_error_count).error_assignment_number := l_assignment_number;
2007: l_val_errors(l_val_error_count).error_element_name :='Car and Car Fuel 2003-04';
2008: end if;
2009: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

Line 2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);

2006: l_val_errors(l_val_error_count).error_assignment_number := l_assignment_number;
2007: l_val_errors(l_val_error_count).error_element_name :='Car and Car Fuel 2003-04';
2008: end if;
2009: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

Line 2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);

2007: l_val_errors(l_val_error_count).error_element_name :='Car and Car Fuel 2003-04';
2008: end if;
2009: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);

Line 2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);

2008: end if;
2009: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

Line 2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

2009: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('FREE_FUEL_REINSTATED','T',l_col11_val);
2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

Line 2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

2010: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

Line 2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);

2011: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

Line 2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

2012: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

Line 2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

2013: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2021: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

Line 2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

2014: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2021: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2022: else

Line 2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

2015: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col17_val);
2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2021: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2022: else
2023:

Line 2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

2016: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2021: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2022: else
2023:
2024: --Added the below procedure call for the bug fix 8864717.

Line 2021: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

2017: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2018: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2019: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2020: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2021: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2022: else
2023:
2024: --Added the below procedure call for the bug fix 8864717.
2025: update_flag_var(p_assignment_action_id);

Line 2050: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);

2046: WHERE action_context_id = p_assignment_action_id AND
2047: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
2048: AND action_context_type = 'AAP';
2049:
2050: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

Line 2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);

2047: action_information_category = 'GB P11D ASSIGNMENT RESULTA'
2048: AND action_context_type = 'AAP';
2049:
2050: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

Line 2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);

2048: AND action_context_type = 'AAP';
2049:
2050: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

Line 2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);

2049:
2050: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

Line 2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);

2050: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('A_DESC', l_col1_val);
2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

Line 2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);

2051: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_COST', l_col2_val);
2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

Line 2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);

2052: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_AMG', l_col3_val);
2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

Line 2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);

2053: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('A_CE', l_col4_val);
2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

Line 2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);

2054: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('B_DESC', l_col5_val);
2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

Line 2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);

2055: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_CE', l_col6_val);
2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

Line 2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);

2056: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TNP', l_col7_val);
2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

Line 2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);

2057: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_COST', l_col8_val);
2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

Line 2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);

2058: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_AMG', l_col9_val);
2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

Line 2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);

2059: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_CE', l_col10_val);
2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

Line 2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);

2060: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('D_CE', l_col11_val);
2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

Line 2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);

2061: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('E_CE', l_col12_val);
2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

Line 2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);

2062: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TCCE', l_col13_val);
2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

Line 2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);

2063: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_TFCE', l_col14_val);
2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

Line 2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);

2064: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_CE', l_col15_val);
2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

Line 2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);

2065: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_COST', l_col16_val);
2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

Line 2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);

2066: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_AMG', l_col17_val);
2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

Line 2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);

2067: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('I_CE', l_col18_val);
2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

Line 2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);

2068: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('J_CE', l_col19_val);
2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */

Line 2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);

2069: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_COST', l_col20_val);
2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

Line 2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);

2070: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_AMG', l_col21_val);
2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

Line 2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);

2071: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('K_CE', l_col22_val);
2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2079: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

Line 2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */

2072: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('L_DESC', l_col23_val);
2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2079: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2080:

Line 2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);

2073: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_COST', l_col24_val);
2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2079: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2080:
2081: SELECT action_information1, action_information2, action_information3, action_information4,

Line 2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);

2074: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_AMG', l_col25_val);
2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2079: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2080:
2081: SELECT action_information1, action_information2, action_information3, action_information4,
2082: action_information5, action_information6, action_information7, action_information8,

Line 2079: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);

2075: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('L_CE', l_col26_val);
2076: /* l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_SHARES', l_col27_val); */
2077: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_CE1', l_col28_val);
2078: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('H_COUNT', l_col29_val);
2079: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('F_COUNT', l_col30_val);
2080:
2081: SELECT action_information1, action_information2, action_information3, action_information4,
2082: action_information5, action_information6, action_information7, action_information8,
2083: action_information9, action_information10, action_information11, action_information12,

Line 2102: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);

2098: WHERE action_context_id = p_assignment_action_id AND
2099: action_information_category ='GB P11D ASSIGNMENT RESULTB'
2100: AND action_context_type = 'AAP';
2101:
2102: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);

Line 2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);

2099: action_information_category ='GB P11D ASSIGNMENT RESULTB'
2100: AND action_context_type = 'AAP';
2101:
2102: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);

Line 2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);

2100: AND action_context_type = 'AAP';
2101:
2102: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);

Line 2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);

2101:
2102: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);

Line 2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);

2102: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('M_DESC', l_col1_val);
2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);

Line 2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);

2103: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_COST', l_col2_val);
2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);

Line 2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);

2104: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_AMG', l_col3_val);
2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);

Line 2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);

2105: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_CE', l_col4_val);
2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);

Line 2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);

2106: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('MA_DESC', l_col5_val);
2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);

Line 2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);

2107: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_COST', l_col6_val);
2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);

Line 2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);

2108: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_AMG', l_col7_val);
2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);

Line 2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);

2109: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MA_CE', l_col8_val);
2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);

Line 2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);

2110: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAXPAID', l_col9_val);
2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);

Line 2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);

2111: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_COST', l_col10_val);
2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);

Line 2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);

2112: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_AMG', l_col11_val);
2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);

Line 2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);

2113: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N1_CE', l_col12_val);
2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);

Line 2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);

2114: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_COST', l_col13_val);
2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);

Line 2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);

2115: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_AMG', l_col14_val);
2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);

Line 2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);

2116: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N2_CE', l_col15_val);
2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);

Line 2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);

2117: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N_TOI', l_col16_val);
2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);

Line 2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);

2118: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_COST', l_col17_val);
2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);

Line 2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);

2119: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_AMG', l_col18_val);
2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);

Line 2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);

2120: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N3_CE', l_col19_val);
2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);

Line 2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);

2121: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_COST', l_col20_val);
2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);

Line 2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);

2122: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_AMG', l_col21_val);
2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);

Line 2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);

2123: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N4_CE', l_col22_val);
2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2131: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);

Line 2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);

2124: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_COST', l_col23_val);
2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2131: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2132:

Line 2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);

2125: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_AMG', l_col24_val);
2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2131: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2132:
2133: --

Line 2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);

2126: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N5_CE', l_col25_val);
2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2131: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2132:
2133: --
2134: SELECT action_information1, action_information2, action_information3, action_information4,

Line 2131: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);

2127: l_ret := hr_gb_process_p11d_entries_pkg.check_desc_and_set_global_var('N6_DESC', l_col26_val);
2128: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_COST', l_col27_val);
2129: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_AMG', l_col28_val);
2130: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('N6_CE', l_col29_val);
2131: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('G_FCE', l_col30_val);
2132:
2133: --
2134: SELECT action_information1, action_information2, action_information3, action_information4,
2135: action_information5, action_information6, action_information7, action_information8,

Line 2151: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);

2147: WHERE action_context_id = p_assignment_action_id AND
2148: action_information_category ='GB P11D ASSIGNMENT RESULTC'
2149: AND action_context_type = 'AAP';
2150:
2151: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

Line 2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);

2148: action_information_category ='GB P11D ASSIGNMENT RESULTC'
2149: AND action_context_type = 'AAP';
2150:
2151: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

Line 2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);

2149: AND action_context_type = 'AAP';
2150:
2151: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

Line 2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);

2150:
2151: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

Line 2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);

2151: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_BUS_MILES', l_col1_val);
2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

Line 2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);

2152: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_BUS_MILES', l_col2_val);
2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);

Line 2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);

2153: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_BUS_MILES', l_col3_val);
2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);

Line 2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);

2154: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE1','N',l_col4_val);
2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);

Line 2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);

2155: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('C_RATE2','N',l_col5_val);
2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

Line 2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);

2156: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE1','N',l_col6_val);
2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

Line 2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);

2157: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('M_RATE2','N',l_col7_val);
2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);

Line 2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);

2158: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE1','N',l_col8_val);
2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

Line 2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);

2159: l_ret_text:= hr_gb_process_p11d_entries_pkg.max_and_set_global_var('B_RATE2','N',l_col9_val);
2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

Line 2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);

2160: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_MILEAGE_PAYMENTS', l_col12_val);
2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

Line 2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);

2161: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_MILEAGE_PAYMENTS', l_col13_val);
2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

Line 2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);

2162: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_MILEAGE_PAYMENTS', l_col14_val);
2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

Line 2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);

2163: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MARORS_COUNT', l_col15_val);
2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2171: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

Line 2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);

2164: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('C_TAX_DEDUCTED', l_col16_val);
2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2171: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2172: end if;

Line 2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);

2165: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('B_TAX_DEDUCTED', l_col17_val);
2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2171: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2172: end if;
2173:

Line 2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);

2166: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('M_TAX_DEDUCTED', l_col18_val);
2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2171: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2172: end if;
2173:
2174: END;

Line 2171: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);

2167: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_PAYMENTS', l_col19_val);
2168: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILES', l_col20_val);
2169: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('PASSENGER_BUS_MILE_AMT', l_col21_val);
2170: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('MILEAGE_ALLOWANCE_RELIEF', l_col22_val);
2171: l_ret := hr_gb_process_p11d_entries_pkg.sum_and_set_global_var('INT_MAX_AMT_OUTSTANDING', l_col23_val);
2172: end if;
2173:
2174: END;
2175: