DBA Data[Home] [Help]

APPS.HR_NO_VALIDATE_PKG dependencies on FND_SESSIONS

Line 228: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */

224: select business_group_id
225: from hr_organization_units
226: where organization_id = p_organization_id;
227:
228: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
229: cursor orgnum(s_eff_date date) is
230: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou
231: where ( orgif.org_information_context = 'NO_LOCAL_UNIT_DETAILS' or orgif.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS')
232: and ou.organization_id = orgif.organization_id

Line 237: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */

233: and ou.business_group_id = l_business_group_id
234: and orgif.org_information1 = p_org_information1
235: and s_eff_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
236:
237: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
238: cursor orglocalunit(s_eff_date date) is
239: select o.organization_id
240: from hr_organization_units o , hr_organization_information hoi
241: where o.organization_id = hoi.organization_id

Line 333: SELECT effective_date INTO s_effective_date FROM fnd_sessions

329: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
330: --
331: /* Performance Bug fix 4892110 - Start */
332: begin
333: SELECT effective_date INTO s_effective_date FROM fnd_sessions
334: WHERE session_id = userenv('sessionid');
335: exception
336: WHEN OTHERS then
337: s_effective_date := null;

Line 682: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */

678: cursor getorgid is
679: select organization_id
680: from hr_organization_information
681: where org_information_id = p_org_information_id;
682: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
683: cursor orgnum(s_eff_date date) is
684: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou
685: where ( orgif.org_information_context = 'NO_LOCAL_UNIT_DETAILS' or orgif.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS')
686: and ou.organization_id = orgif.organization_id

Line 691: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */

687: and ou.business_group_id = l_business_group_id
688: and orgif.org_information1 = p_org_information1
689: and s_eff_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
690:
691: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
692: cursor orglocalunit(s_eff_date date) is
693: select o.organization_id
694: from hr_organization_units o , hr_organization_information hoi
695: where o.organization_id = hoi.organization_id

Line 805: SELECT effective_date INTO s_effective_date FROM fnd_sessions

801: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
802: --
803: /* Performance Bug fix 4892110 - Start */
804: begin
805: SELECT effective_date INTO s_effective_date FROM fnd_sessions
806: WHERE session_id = userenv('sessionid');
807: exception
808: WHEN OTHERS then
809: s_effective_date := null;

Line 1231: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s

1227: from hr_organization_units
1228: where organization_id = p_organization_id;
1229:
1230: cursor orgtype is
1231: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
1232: where ou.organization_id= p_organization_id
1233: and s.session_id = userenv('sessionid')
1234: and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
1235:

Line 1939: FROM fnd_sessions

1935: ) IS
1936: --
1937: CURSOR csr_get_session_id IS
1938: SELECT 1
1939: FROM fnd_sessions
1940: WHERE session_id = userenv('sessionid');
1941: --
1942: l_sess_row csr_get_session_id%ROWTYPE;
1943: BEGIN

Line 1948: INSERT INTO fnd_sessions (session_id, effective_date)

1944: --
1945: OPEN csr_get_session_id;
1946: FETCH csr_get_session_id INTO l_sess_row;
1947: IF csr_get_session_id%NOTFOUND THEN
1948: INSERT INTO fnd_sessions (session_id, effective_date)
1949: VALUES (userenv('sessionid'), trunc(p_effective_date));
1950: END IF;
1951: CLOSE csr_get_session_id;
1952: --

Line 1962: FROM fnd_sessions

1958: ) IS
1959: --
1960: CURSOR csr_get_session_id IS
1961: SELECT 1
1962: FROM fnd_sessions
1963: WHERE session_id = userenv('sessionid');
1964: --
1965: l_sess_row csr_get_session_id%ROWTYPE;
1966: BEGIN

Line 1971: INSERT INTO fnd_sessions (session_id, effective_date)

1967: --
1968: OPEN csr_get_session_id;
1969: FETCH csr_get_session_id INTO l_sess_row;
1970: IF csr_get_session_id%NOTFOUND THEN
1971: INSERT INTO fnd_sessions (session_id, effective_date)
1972: VALUES (userenv('sessionid'), trunc(p_effective_date));
1973: END IF;
1974: CLOSE csr_get_session_id;
1975: --

Line 1982: DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');

1978: PROCEDURE update_ele_entry_ap
1979: ( p_effective_date IN DATE
1980: ) IS
1981: BEGIN
1982: DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');
1983: END;
1984: --
1985: PROCEDURE create_ele_entry_ap
1986: ( p_effective_date IN DATE

Line 1989: DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');

1985: PROCEDURE create_ele_entry_ap
1986: ( p_effective_date IN DATE
1987: ) IS
1988: BEGIN
1989: DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');
1990: END;
1991:
1992: -----------------------------------------------------------------------------------------------
1993: