APPS.PAY_COST_ALLOCATION_SWI dependencies on FND_SESSIONS

Line 696: -- This procedure insert a row into the fnd_sessions table

692: hr_utility.set_location(' Leaving:' || l_proc,130);
693: end update_cost_allocation;
694:
695: /*For Bug 10187159 */
696: -- This procedure insert a row into the fnd_sessions table
697: procedure insert_fnd_sessions
698: (p_effective_date in varchar2
699: )is
700: --cursors

Line 697: procedure insert_fnd_sessions

693: end update_cost_allocation;
694:
695: /*For Bug 10187159 */
696: -- This procedure insert a row into the fnd_sessions table
697: procedure insert_fnd_sessions
698: (p_effective_date in varchar2
699: )is
700: --cursors
701: cursor csr_get_session_id is

Line 703: from fnd_sessions

699: )is
700: --cursors
701: cursor csr_get_session_id is
702: select session_id
703: from fnd_sessions
704: where session_id = userenv('sessionid');
705: --variables
706: l_session_id number ;
707: begin

Line 708: hr_utility.trace('Entered insert_fnd_sessions ');

704: where session_id = userenv('sessionid');
705: --variables
706: l_session_id number ;
707: begin
708: hr_utility.trace('Entered insert_fnd_sessions ');
709: -- Insert a row into fnd_sessions if reqd
710: open csr_get_session_id;
711: fetch csr_get_session_id into l_session_id;
712: if csr_get_session_id%notfound then

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

705: --variables
706: l_session_id number ;
707: begin
708: hr_utility.trace('Entered insert_fnd_sessions ');
709: -- Insert a row into fnd_sessions if reqd
710: open csr_get_session_id;
711: fetch csr_get_session_id into l_session_id;
712: if csr_get_session_id%notfound then
713: insert into fnd_sessions(session_id,effective_date)

Line 713: insert into fnd_sessions(session_id,effective_date)

709: -- Insert a row into fnd_sessions if reqd
710: open csr_get_session_id;
711: fetch csr_get_session_id into l_session_id;
712: if csr_get_session_id%notfound then
713: insert into fnd_sessions(session_id,effective_date)
714: values (userenv('sessionid'),fnd_date.canonical_to_date(p_effective_date));
715: hr_utility.trace('inserted a row into the fnd_sessions table');
716: end if;
717: close csr_get_session_id;

Line 715: hr_utility.trace('inserted a row into the fnd_sessions table');

711: fetch csr_get_session_id into l_session_id;
712: if csr_get_session_id%notfound then
713: insert into fnd_sessions(session_id,effective_date)
714: values (userenv('sessionid'),fnd_date.canonical_to_date(p_effective_date));
715: hr_utility.trace('inserted a row into the fnd_sessions table');
716: end if;
717: close csr_get_session_id;
718:
719: end insert_fnd_sessions;

Line 719: end insert_fnd_sessions;

715: hr_utility.trace('inserted a row into the fnd_sessions table');
716: end if;
717: close csr_get_session_id;
718:
719: end insert_fnd_sessions;
720:
721: end pay_cost_allocation_swi;