APPS.PAY_GB_ENROLL_PENSION dependencies on DUAL

Line 24: FROM DUAL;

20: BEGIN
21: -- RETURNS DATE OF BIRTH +22 YEARS
22: SELECT ADD_MONTHS(P_DATE_OF_BIRTH,(22*12))
23: INTO L_DATE
24: FROM DUAL;
25: RETURN L_DATE;
26: END FETCH_START_DATE;
27: ----------------------------------------------------------------------------
28: FUNCTION GET_AGGREGATED_EARNINGS(

Line 740: FROM DUAL

736: --This cursor will check whether the default Pension element entered is a QUALIFYING pension scheme or not.
737: CURSOR C_VALIDATE_PENSION_INFO(P_SCHEME_ELEMENT_NAME VARCHAR2 )
738: IS
739: SELECT 1
740: FROM DUAL
741: WHERE EXISTS
742: (SELECT PCV_INFORMATION1
743: FROM PQP_CONFIGURATION_VALUES
744: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'

Line 1886: FROM dual ;

1882: l_flag:=1;
1883: ---------------------------------------Location-------------------------------------------
1884: SELECT p_config_values('Location')
1885: INTO l_value
1886: FROM dual ;
1887: hr_utility.trace('Location:: l_value:'||l_value);
1888: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
1889: l_flag :=0;
1890: l_position :=0;

Line 1895: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

1891: temp_num :=0;
1892: l_seg_collect.delete;
1893: LOOP -- '~'
1894: temp_num:=temp_num+1;
1895: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1896: SELECT instr(l_value,'~') INTO l_position FROM dual;
1897: IF(l_position=0) THEN
1898: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1899: END IF;

Line 1896: SELECT instr(l_value,'~') INTO l_position FROM dual;

1892: l_seg_collect.delete;
1893: LOOP -- '~'
1894: temp_num:=temp_num+1;
1895: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1896: SELECT instr(l_value,'~') INTO l_position FROM dual;
1897: IF(l_position=0) THEN
1898: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1899: END IF;
1900: EXIT

Line 1898: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

1894: temp_num:=temp_num+1;
1895: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1896: SELECT instr(l_value,'~') INTO l_position FROM dual;
1897: IF(l_position=0) THEN
1898: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1899: END IF;
1900: EXIT
1901: WHEN l_position=0;
1902: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 1904: FROM dual;

1900: EXIT
1901: WHEN l_position=0;
1902: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
1903: INTO l_seg_collect(temp_num)
1904: FROM dual;
1905: END LOOP; -- '~'
1906: FOR i IN 1..l_seg_collect.count
1907: LOOP
1908: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 1926: SELECT p_config_values('Grade') INTO l_value FROM dual ;

1922: END IF;
1923: END IF;--
1924: ---------------------------------------Location-------------------------------------------
1925: IF l_flag =1 OR l_value IS NULL THEN
1926: SELECT p_config_values('Grade') INTO l_value FROM dual ;
1927: hr_utility.trace('Grade :: l_value:'||l_value);
1928: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
1929: l_flag :=0;
1930: l_position :=0;

Line 1935: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

1931: temp_num :=0;
1932: l_seg_collect.delete;
1933: LOOP -- '~'
1934: temp_num:=temp_num+1;
1935: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1936: SELECT instr(l_value,'~') INTO l_position FROM dual;
1937: IF(l_position=0) THEN
1938: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1939: END IF;

Line 1936: SELECT instr(l_value,'~') INTO l_position FROM dual;

1932: l_seg_collect.delete;
1933: LOOP -- '~'
1934: temp_num:=temp_num+1;
1935: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1936: SELECT instr(l_value,'~') INTO l_position FROM dual;
1937: IF(l_position=0) THEN
1938: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1939: END IF;
1940: EXIT

Line 1938: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

1934: temp_num:=temp_num+1;
1935: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1936: SELECT instr(l_value,'~') INTO l_position FROM dual;
1937: IF(l_position=0) THEN
1938: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1939: END IF;
1940: EXIT
1941: WHEN l_position=0;
1942: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 1944: FROM dual;

1940: EXIT
1941: WHEN l_position=0;
1942: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
1943: INTO l_seg_collect(temp_num)
1944: FROM dual;
1945: END LOOP; -- '~'
1946: FOR i IN 1..l_seg_collect.count
1947: LOOP
1948: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 1967: SELECT p_config_values('Job') INTO l_value FROM dual ;

1963: END IF;
1964: END IF;--
1965: ---------------------------------------Grade-------------------------------------------
1966: IF l_flag =1 OR l_value IS NULL THEN
1967: SELECT p_config_values('Job') INTO l_value FROM dual ;
1968: hr_utility.trace('Job :: l_value:'||l_value);
1969: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
1970: l_flag :=0;
1971: l_position :=0;

Line 1976: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

1972: temp_num :=0;
1973: l_seg_collect.delete;
1974: LOOP -- '~'
1975: temp_num:=temp_num+1;
1976: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1977: SELECT instr(l_value,'~') INTO l_position FROM dual;
1978: IF(l_position=0) THEN
1979: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1980: END IF;

Line 1977: SELECT instr(l_value,'~') INTO l_position FROM dual;

1973: l_seg_collect.delete;
1974: LOOP -- '~'
1975: temp_num:=temp_num+1;
1976: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1977: SELECT instr(l_value,'~') INTO l_position FROM dual;
1978: IF(l_position=0) THEN
1979: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1980: END IF;
1981: EXIT

Line 1979: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

1975: temp_num:=temp_num+1;
1976: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
1977: SELECT instr(l_value,'~') INTO l_position FROM dual;
1978: IF(l_position=0) THEN
1979: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
1980: END IF;
1981: EXIT
1982: WHEN l_position=0;
1983: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 1985: FROM dual;

1981: EXIT
1982: WHEN l_position=0;
1983: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
1984: INTO l_seg_collect(temp_num)
1985: FROM dual;
1986: END LOOP; -- '~'
1987: FOR i IN 1..l_seg_collect.count
1988: LOOP
1989: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 2008: SELECT p_config_values('Organization') INTO l_value FROM dual ;

2004: END IF;
2005: END IF;--
2006: ---------------------------------------Job-------------------------------------------
2007: IF l_flag =1 OR l_value IS NULL THEN
2008: SELECT p_config_values('Organization') INTO l_value FROM dual ;
2009: hr_utility.trace('Organization :: l_value:'||l_value);
2010: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
2011: l_flag :=0;
2012: l_position :=0;

Line 2017: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

2013: temp_num :=0;
2014: l_seg_collect.delete;
2015: LOOP -- '~'
2016: temp_num:=temp_num+1;
2017: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2018: SELECT instr(l_value,'~') INTO l_position FROM dual;
2019: IF(l_position=0) THEN
2020: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2021: END IF;

Line 2018: SELECT instr(l_value,'~') INTO l_position FROM dual;

2014: l_seg_collect.delete;
2015: LOOP -- '~'
2016: temp_num:=temp_num+1;
2017: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2018: SELECT instr(l_value,'~') INTO l_position FROM dual;
2019: IF(l_position=0) THEN
2020: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2021: END IF;
2022: EXIT

Line 2020: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

2016: temp_num:=temp_num+1;
2017: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2018: SELECT instr(l_value,'~') INTO l_position FROM dual;
2019: IF(l_position=0) THEN
2020: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2021: END IF;
2022: EXIT
2023: WHEN l_position=0;
2024: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 2026: FROM dual;

2022: EXIT
2023: WHEN l_position=0;
2024: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
2025: INTO l_seg_collect(temp_num)
2026: FROM dual;
2027: END LOOP; -- '~'
2028: FOR i IN 1..l_seg_collect.count
2029: LOOP
2030: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 2049: SELECT p_config_values('Payroll') INTO l_value FROM dual ;

2045: END IF;
2046: END IF;--
2047: ---------------------------------------Organization-------------------------------------------
2048: IF l_flag =1 OR l_value IS NULL THEN
2049: SELECT p_config_values('Payroll') INTO l_value FROM dual ;
2050: hr_utility.trace('Payroll :: l_value:'||l_value);
2051: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
2052: l_flag :=0;
2053: l_position :=0;

Line 2058: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

2054: temp_num :=0;
2055: l_seg_collect.delete;
2056: LOOP -- '~'
2057: temp_num:=temp_num+1;
2058: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2059: SELECT instr(l_value,'~') INTO l_position FROM dual;
2060: IF(l_position=0) THEN
2061: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2062: END IF;

Line 2059: SELECT instr(l_value,'~') INTO l_position FROM dual;

2055: l_seg_collect.delete;
2056: LOOP -- '~'
2057: temp_num:=temp_num+1;
2058: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2059: SELECT instr(l_value,'~') INTO l_position FROM dual;
2060: IF(l_position=0) THEN
2061: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2062: END IF;
2063: EXIT

Line 2061: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

2057: temp_num:=temp_num+1;
2058: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2059: SELECT instr(l_value,'~') INTO l_position FROM dual;
2060: IF(l_position=0) THEN
2061: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2062: END IF;
2063: EXIT
2064: WHEN l_position=0;
2065: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 2067: FROM dual;

2063: EXIT
2064: WHEN l_position=0;
2065: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
2066: INTO l_seg_collect(temp_num)
2067: FROM dual;
2068: END LOOP; -- '~'
2069: FOR i IN 1..l_seg_collect.count
2070: LOOP
2071: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 2090: SELECT p_config_values('Position') INTO l_value FROM dual ;

2086: END IF;
2087: END IF;--
2088: ---------------------------------------Payroll-------------------------------------------
2089: IF l_flag =1 OR l_value IS NULL THEN
2090: SELECT p_config_values('Position') INTO l_value FROM dual ;
2091: hr_utility.trace('Position :: l_value:'||l_value);
2092: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
2093: l_flag :=0;
2094: l_position :=0;

Line 2099: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

2095: temp_num :=0;
2096: l_seg_collect.delete;
2097: LOOP -- '~'
2098: temp_num:=temp_num+1;
2099: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2100: SELECT instr(l_value,'~') INTO l_position FROM dual;
2101: IF(l_position=0) THEN
2102: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2103: END IF;

Line 2100: SELECT instr(l_value,'~') INTO l_position FROM dual;

2096: l_seg_collect.delete;
2097: LOOP -- '~'
2098: temp_num:=temp_num+1;
2099: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2100: SELECT instr(l_value,'~') INTO l_position FROM dual;
2101: IF(l_position=0) THEN
2102: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2103: END IF;
2104: EXIT

Line 2102: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

2098: temp_num:=temp_num+1;
2099: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2100: SELECT instr(l_value,'~') INTO l_position FROM dual;
2101: IF(l_position=0) THEN
2102: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2103: END IF;
2104: EXIT
2105: WHEN l_position=0;
2106: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 2108: FROM dual;

2104: EXIT
2105: WHEN l_position=0;
2106: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
2107: INTO l_seg_collect(temp_num)
2108: FROM dual;
2109: END LOOP; -- '~'
2110: FOR i IN 1..l_seg_collect.count
2111: LOOP
2112: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 2131: SELECT p_config_values('Salary Basis') INTO l_value FROM dual ;

2127: END IF;
2128: END IF;--
2129: ---------------------------------------Position-------------------------------------------
2130: IF l_flag =1 OR l_value IS NULL THEN
2131: SELECT p_config_values('Salary Basis') INTO l_value FROM dual ;
2132: hr_utility.trace('Salary Basis :: l_value:'||l_value);
2133: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
2134: l_flag :=0;
2135: l_position :=0;

Line 2140: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

2136: temp_num :=0;
2137: l_seg_collect.delete;
2138: LOOP -- '~'
2139: temp_num:=temp_num+1;
2140: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2141: SELECT instr(l_value,'~') INTO l_position FROM dual;
2142: IF(l_position=0) THEN
2143: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2144: END IF;

Line 2141: SELECT instr(l_value,'~') INTO l_position FROM dual;

2137: l_seg_collect.delete;
2138: LOOP -- '~'
2139: temp_num:=temp_num+1;
2140: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2141: SELECT instr(l_value,'~') INTO l_position FROM dual;
2142: IF(l_position=0) THEN
2143: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2144: END IF;
2145: EXIT

Line 2143: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

2139: temp_num:=temp_num+1;
2140: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2141: SELECT instr(l_value,'~') INTO l_position FROM dual;
2142: IF(l_position=0) THEN
2143: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2144: END IF;
2145: EXIT
2146: WHEN l_position=0;
2147: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 2149: FROM dual;

2145: EXIT
2146: WHEN l_position=0;
2147: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
2148: INTO l_seg_collect(temp_num)
2149: FROM dual;
2150: END LOOP; -- '~'
2151: FOR i IN 1..l_seg_collect.count
2152: LOOP
2153: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 2172: SELECT p_config_values('Emp Category') INTO l_value FROM dual ;

2168: END IF;
2169: END IF;--
2170: ---------------------------------------Salary Basis-------------------------------------------
2171: IF l_flag =1 OR l_value IS NULL THEN
2172: SELECT p_config_values('Emp Category') INTO l_value FROM dual ;
2173: hr_utility.trace('Emp Category :: l_value:'||l_value);
2174: IF l_value IS NOT NULL THEN --If Any eligiblity criteria is set
2175: l_flag :=0;
2176: l_position :=0;

Line 2180: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;

2176: l_position :=0;
2177: temp_num :=0;
2178: LOOP -- '~'
2179: temp_num:=temp_num+1;
2180: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2181: SELECT instr(l_value,'~') INTO l_position FROM dual;
2182: IF(l_position=0) THEN
2183: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2184: END IF;

Line 2181: SELECT instr(l_value,'~') INTO l_position FROM dual;

2177: temp_num :=0;
2178: LOOP -- '~'
2179: temp_num:=temp_num+1;
2180: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2181: SELECT instr(l_value,'~') INTO l_position FROM dual;
2182: IF(l_position=0) THEN
2183: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2184: END IF;
2185: EXIT

Line 2183: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;

2179: temp_num:=temp_num+1;
2180: SELECT trim(SUBSTR(l_value,(l_position+1))) INTO l_value FROM dual;
2181: SELECT instr(l_value,'~') INTO l_position FROM dual;
2182: IF(l_position=0) THEN
2183: SELECT trim(SUBSTR(l_value,1)) INTO l_seg_collect(temp_num) FROM dual;
2184: END IF;
2185: EXIT
2186: WHEN l_position=0;
2187: SELECT trim(SUBSTR(l_value,1,(l_position-1)))

Line 2189: FROM dual;

2185: EXIT
2186: WHEN l_position=0;
2187: SELECT trim(SUBSTR(l_value,1,(l_position-1)))
2188: INTO l_seg_collect(temp_num)
2189: FROM dual;
2190: END LOOP; -- '~'
2191: FOR i IN 1..l_seg_collect.count
2192: LOOP
2193: hr_utility.trace('Segment Collection:: '||i||l_seg_collect(i));

Line 2471: SELECT p_config_values('Group') INTO L_group_value FROM dual ;

2467: l_people_group_id NUMBER;
2468: l_temp_char VARCHAR2(150);
2469: tc sys_refcursor;
2470: BEGIN
2471: SELECT p_config_values('Group') INTO L_group_value FROM dual ;
2472: IF L_group_value IS NOT NULL THEN --If Any eligiblity criteria is set for 'GROUP'
2473: SELECT instr(L_group_value,'|') INTO l_position FROM dual;
2474: SELECT trim(SUBSTR(L_group_value,1,(l_position-1)))
2475: INTO l_group_name

Line 2473: SELECT instr(L_group_value,'|') INTO l_position FROM dual;

2469: tc sys_refcursor;
2470: BEGIN
2471: SELECT p_config_values('Group') INTO L_group_value FROM dual ;
2472: IF L_group_value IS NOT NULL THEN --If Any eligiblity criteria is set for 'GROUP'
2473: SELECT instr(L_group_value,'|') INTO l_position FROM dual;
2474: SELECT trim(SUBSTR(L_group_value,1,(l_position-1)))
2475: INTO l_group_name
2476: FROM dual;
2477: hr_utility.trace('l_group_name:'||l_group_name);

Line 2476: FROM dual;

2472: IF L_group_value IS NOT NULL THEN --If Any eligiblity criteria is set for 'GROUP'
2473: SELECT instr(L_group_value,'|') INTO l_position FROM dual;
2474: SELECT trim(SUBSTR(L_group_value,1,(l_position-1)))
2475: INTO l_group_name
2476: FROM dual;
2477: hr_utility.trace('l_group_name:'||l_group_name);
2478: OPEN c_group_name_check(l_group_name);
2479: FETCH c_group_name_check INTO l_test;
2480: IF c_group_name_check%notfound THEN

Line 2493: FROM dual;

2489: LOOP -- '~'
2490: temp_num:=temp_num +1;
2491: SELECT trim(SUBSTR(L_group_value,(l_position+1)))
2492: INTO L_group_value
2493: FROM dual;
2494: SELECT instr(L_group_value,'~') INTO l_position FROM dual;
2495: IF(l_position=0) THEN
2496: SELECT trim(SUBSTR(L_group_value,1))
2497: INTO l_seg_collection(temp_num)

Line 2494: SELECT instr(L_group_value,'~') INTO l_position FROM dual;

2490: temp_num:=temp_num +1;
2491: SELECT trim(SUBSTR(L_group_value,(l_position+1)))
2492: INTO L_group_value
2493: FROM dual;
2494: SELECT instr(L_group_value,'~') INTO l_position FROM dual;
2495: IF(l_position=0) THEN
2496: SELECT trim(SUBSTR(L_group_value,1))
2497: INTO l_seg_collection(temp_num)
2498: FROM dual;

Line 2498: FROM dual;

2494: SELECT instr(L_group_value,'~') INTO l_position FROM dual;
2495: IF(l_position=0) THEN
2496: SELECT trim(SUBSTR(L_group_value,1))
2497: INTO l_seg_collection(temp_num)
2498: FROM dual;
2499: END IF;
2500: EXIT
2501: WHEN l_position=0;
2502: SELECT trim(SUBSTR(L_group_value,1,(l_position-1)))

Line 2504: FROM dual;

2500: EXIT
2501: WHEN l_position=0;
2502: SELECT trim(SUBSTR(L_group_value,1,(l_position-1)))
2503: INTO l_seg_collection(temp_num)
2504: FROM dual;
2505: END LOOP; -- '~'
2506: FOR i IN 1..l_seg_collection.count
2507: LOOP
2508: hr_utility.trace('Seg Collection:: '||i||l_seg_collection(i));

Line 2522: FROM dual;

2518: LOOP -- '|'
2519: temp_num_sub:=temp_num_sub +1;
2520: SELECT trim(SUBSTR(l_seg_collection(ii),(l_position+1)))
2521: INTO l_seg_collection(ii)
2522: FROM dual;
2523: SELECT instr(l_seg_collection(ii),'|') INTO l_position FROM dual;
2524: IF(l_position=0) THEN
2525: SELECT trim(SUBSTR(l_seg_collection(ii),1)) INTO l_temp_char FROM dual;
2526: SELECT trim(SUBSTR(l_temp_char,1,(instr(l_temp_char,'.')-1))),

Line 2523: SELECT instr(l_seg_collection(ii),'|') INTO l_position FROM dual;

2519: temp_num_sub:=temp_num_sub +1;
2520: SELECT trim(SUBSTR(l_seg_collection(ii),(l_position+1)))
2521: INTO l_seg_collection(ii)
2522: FROM dual;
2523: SELECT instr(l_seg_collection(ii),'|') INTO l_position FROM dual;
2524: IF(l_position=0) THEN
2525: SELECT trim(SUBSTR(l_seg_collection(ii),1)) INTO l_temp_char FROM dual;
2526: SELECT trim(SUBSTR(l_temp_char,1,(instr(l_temp_char,'.')-1))),
2527: trim(SUBSTR(l_temp_char,(instr(l_temp_char,'.') +1)))

Line 2525: SELECT trim(SUBSTR(l_seg_collection(ii),1)) INTO l_temp_char FROM dual;

2521: INTO l_seg_collection(ii)
2522: FROM dual;
2523: SELECT instr(l_seg_collection(ii),'|') INTO l_position FROM dual;
2524: IF(l_position=0) THEN
2525: SELECT trim(SUBSTR(l_seg_collection(ii),1)) INTO l_temp_char FROM dual;
2526: SELECT trim(SUBSTR(l_temp_char,1,(instr(l_temp_char,'.')-1))),
2527: trim(SUBSTR(l_temp_char,(instr(l_temp_char,'.') +1)))
2528: INTO l_seg_name_value_tab(temp_num_sub).name,
2529: l_seg_name_value_tab(temp_num_sub).value

Line 2530: FROM dual;

2526: SELECT trim(SUBSTR(l_temp_char,1,(instr(l_temp_char,'.')-1))),
2527: trim(SUBSTR(l_temp_char,(instr(l_temp_char,'.') +1)))
2528: INTO l_seg_name_value_tab(temp_num_sub).name,
2529: l_seg_name_value_tab(temp_num_sub).value
2530: FROM dual;
2531: END IF;
2532: EXIT
2533: WHEN l_position=0;
2534: SELECT trim(SUBSTR(l_seg_collection(ii),1,(l_position-1)))

Line 2536: FROM dual;

2532: EXIT
2533: WHEN l_position=0;
2534: SELECT trim(SUBSTR(l_seg_collection(ii),1,(l_position-1)))
2535: INTO l_temp_char
2536: FROM dual;
2537: SELECT trim(SUBSTR(l_temp_char,1,(instr(l_temp_char,'.')-1))),
2538: trim(SUBSTR(l_temp_char,(instr(l_temp_char,'.') +1)))
2539: INTO l_seg_name_value_tab(temp_num_sub).name,
2540: l_seg_name_value_tab(temp_num_sub).value

Line 2541: FROM dual;

2537: SELECT trim(SUBSTR(l_temp_char,1,(instr(l_temp_char,'.')-1))),
2538: trim(SUBSTR(l_temp_char,(instr(l_temp_char,'.') +1)))
2539: INTO l_seg_name_value_tab(temp_num_sub).name,
2540: l_seg_name_value_tab(temp_num_sub).value
2541: FROM dual;
2542: END LOOP;-- '|'
2543: FOR i IN 1..l_seg_name_value_tab.count
2544: LOOP
2545: hr_utility.trace('For ii='||ii||'Seg val tab::'||l_seg_name_value_tab(i).name||'##'||l_seg_name_value_tab(i).value);

Line 3446: SELECT pay_assignment_actions_s.nextval INTO l_ass_act_id FROM dual;

3442: --- Moved to Arch Init*/
3443: FOR ASG_REC IN C_ALL_ASSIGNMENTS_PAYROLL
3444: LOOP
3445: hr_utility.set_location('Creating assignment action for ' || asg_rec.assignment_id,30);
3446: SELECT pay_assignment_actions_s.nextval INTO l_ass_act_id FROM dual;
3447: --
3448: -- insert into pay_assignment_actions.
3449: hr_nonrun_asact.insact(l_ass_act_id, asg_rec.assignment_id, pactid, chunk, NULL);
3450: END LOOP;

Line 3498: FROM DUAL;

3494: ---'GB_VALIDATE' Then Donot Update the Element
3495: --G_MODE='GB_VALIDATE_COMMIT')
3496: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3497: INTO l_mode
3498: FROM DUAL;
3499: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAER' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3500: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3501: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3502: -- Commit;

Line 3516: FROM DUAL;

3512: ---'GB_VALIDATE' Then Donot Update the Element
3513: --G_MODE='GB_VALIDATE_COMMIT')
3514: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3515: INTO l_mode
3516: FROM DUAL;
3517: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAENR' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3518: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3519: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3520: -- Commit;

Line 3535: FROM DUAL;

3531: ---'GB_VALIDATE' Then Donot Update the Element
3532: --G_MODE='GB_VALIDATE_COMMIT')
3533: SELECT DECODE(G_MODE,'GB_VALIDATE','Validate Only','GB_VALIDATE_COMMIT','Validate and Commit','NA')
3534: INTO l_mode
3535: FROM DUAL;
3536: l_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAEQ' ,argument1 => pactid ,argument2 =>fnd_date.date_to_canonical( G_PAYROLL_START_DATE) ,
3537: argument3 => fnd_date.date_to_canonical(G_PAYROLL_END_DATE) ,argument4 =>fnd_date.date_to_canonical( G_PRP_START_DATE) ,argument5 => fnd_date.date_to_canonical(G_PRP_END_DATE) ,
3538: argument6 => L_MODE ,argument7 => G_PAYROLL_NAME ,argument8 => G_PERIOD_NAME );
3539: -- Commit;