DBA Data[Home] [Help]

APPS.HR_NO_VALIDATE_PKG dependencies on FND_SESSIONS

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

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

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

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

Line 329: SELECT effective_date INTO s_effective_date FROM fnd_sessions

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

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

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

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

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

Line 801: SELECT effective_date INTO s_effective_date FROM fnd_sessions

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

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

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

Line 1935: FROM fnd_sessions

1931: ) IS
1932: --
1933: CURSOR csr_get_session_id IS
1934: SELECT 1
1935: FROM fnd_sessions
1936: WHERE session_id = userenv('sessionid');
1937: --
1938: l_sess_row csr_get_session_id%ROWTYPE;
1939: BEGIN

Line 1944: INSERT INTO fnd_sessions (session_id, effective_date)

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

Line 1958: FROM fnd_sessions

1954: ) IS
1955: --
1956: CURSOR csr_get_session_id IS
1957: SELECT 1
1958: FROM fnd_sessions
1959: WHERE session_id = userenv('sessionid');
1960: --
1961: l_sess_row csr_get_session_id%ROWTYPE;
1962: BEGIN

Line 1967: INSERT INTO fnd_sessions (session_id, effective_date)

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

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

1974: PROCEDURE update_ele_entry_ap
1975: ( p_effective_date IN DATE
1976: ) IS
1977: BEGIN
1978: DELETE FROM fnd_sessions WHERE session_id = userenv('sessionid');
1979: END;
1980: --
1981: PROCEDURE create_ele_entry_ap
1982: ( p_effective_date IN DATE

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

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