APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on FND_SESSIONS

Line 571: from fnd_sessions

567: and p_eff_date between effective_start_date and effective_end_date ;
568: --
569: cursor csr_get_session_id is
570: select session_id
571: from fnd_sessions
572: where session_id = userenv('sessionid');
573:
574: -- End of 4915940
575: --

Line 595: -- Insert a row into fnd_sessions if reqd

591: end if;
592: --
593: -- Bug 4915940: Setting profiles PER_PERSON_ID and PER_ASSIGNMENT_ID
594:
595: -- Insert a row into fnd_sessions if reqd
596: open csr_get_session_id;
597: fetch csr_get_session_id into l_session_id;
598: if csr_get_session_id%notfound then
599: insert into fnd_sessions(session_id,effective_date)

Line 599: insert into fnd_sessions(session_id,effective_date)

595: -- Insert a row into fnd_sessions if reqd
596: open csr_get_session_id;
597: fetch csr_get_session_id into l_session_id;
598: if csr_get_session_id%notfound then
599: insert into fnd_sessions(session_id,effective_date)
600: values (userenv('sessionid'),l_effective_date);
601: end if;
602: close csr_get_session_id;
603:

Line 1525: select session_id from fnd_sessions

1521: and p_effective_date between effective_start_date and effective_end_date;
1522: --
1523: CURSOR csr_get_session_id
1524: is
1525: select session_id from fnd_sessions
1526: where session_id = userenv('sessionid');
1527: --
1528: CURSOR csr_get_person_id(p_assignment_id NUMBER)
1529: is

Line 1567: insert into fnd_sessions(session_id,effective_date)

1563:
1564: OPEN csr_get_session_id;
1565: FETCH csr_get_session_id into l_session_id;
1566: IF csr_get_session_id%NOTFOUND then
1567: insert into fnd_sessions(session_id,effective_date)
1568: values (userenv('sessionid'),l_effective_date);
1569: END IF;
1570: CLOSE csr_get_session_id;
1571:

Line 2354: procedure insert_fnd_sessions( p_effective_date in varchar2

2350:
2351: end;
2352: ------------------------------------------------------------------------------------
2353: /* 9294813 */
2354: procedure insert_fnd_sessions( p_effective_date in varchar2
2355: )
2356: is
2357: cursor csr_get_session_id is
2358: select session_id

Line 2359: from fnd_sessions

2355: )
2356: is
2357: cursor csr_get_session_id is
2358: select session_id
2359: from fnd_sessions
2360: where session_id = userenv('sessionid');
2361: l_session_id number ;
2362: begin
2363:

Line 2364: -- Insert a row into fnd_sessions if reqd

2360: where session_id = userenv('sessionid');
2361: l_session_id number ;
2362: begin
2363:
2364: -- Insert a row into fnd_sessions if reqd
2365: open csr_get_session_id;
2366: fetch csr_get_session_id into l_session_id;
2367: if csr_get_session_id%notfound then
2368: insert into fnd_sessions(session_id,effective_date)

Line 2368: insert into fnd_sessions(session_id,effective_date)

2364: -- Insert a row into fnd_sessions if reqd
2365: open csr_get_session_id;
2366: fetch csr_get_session_id into l_session_id;
2367: if csr_get_session_id%notfound then
2368: insert into fnd_sessions(session_id,effective_date)
2369: values (userenv('sessionid'),fnd_date.canonical_to_date(p_effective_date));
2370: end if;
2371: close csr_get_session_id;
2372:

Line 2373: end insert_fnd_sessions;

2369: values (userenv('sessionid'),fnd_date.canonical_to_date(p_effective_date));
2370: end if;
2371: close csr_get_session_id;
2372:
2373: end insert_fnd_sessions;
2374: --------------------------------------------------------------------------------------
2375: --
2376: -- Bug 9737699
2377: --------------------------------------------------------------------------------------

Line 2456: insert_fnd_sessions( p_target_year||'/12/31 00:00:00');

2452: --
2453: --
2454: begin
2455: --
2456: insert_fnd_sessions( p_target_year||'/12/31 00:00:00');
2457: --
2458: for i in csr_get_base_tbl_data loop
2459: --
2460: l_asg_extra_info_id := null;