eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_DB_PAY_SETUP dependencies on FND_SESSIONS

Line 94: from fnd_sessions ss

90: begin
91: -- Get the session date nb. this is defaulted to todays date
92: select ss.effective_date
93: into v_session_date
94: from fnd_sessions ss
95: where ss.session_id = userenv('sessionid');
96: exception
97: when NO_DATA_FOUND then NULL;
98: end;

Line 546: from fnd_sessions ss

542: begin
543: -- Get the session date nb. this is defaulted to todays date
544: select ss.effective_date
545: into v_session_date
546: from fnd_sessions ss
547: where ss.session_id = userenv('sessionid');
548: exception
549: when NO_DATA_FOUND then NULL;
550: end;

Line 788: from fnd_sessions ss

784: begin
785: -- Get the session date nb. this is defaulted to todays date
786: select ss.effective_date
787: into v_session_date
788: from fnd_sessions ss
789: where ss.session_id = userenv('sessionid');
790: exception
791: when NO_DATA_FOUND then NULL;
792: end;

Line 1065: delete from fnd_sessions where session_id = userenv('sessionid');

1061: PROCEDURE set_session_date(p_session_date date) is
1062: --..
1063: begin
1064: --
1065: delete from fnd_sessions where session_id = userenv('sessionid');
1066: --
1067: insert into fnd_sessions
1068: (SESSION_ID,
1069: EFFECTIVE_DATE)

Line 1067: insert into fnd_sessions

1063: begin
1064: --
1065: delete from fnd_sessions where session_id = userenv('sessionid');
1066: --
1067: insert into fnd_sessions
1068: (SESSION_ID,
1069: EFFECTIVE_DATE)
1070: values
1071: (userenv('sessionid'),

Line 1171: from fnd_sessions ss

1167: begin
1168: -- Get the session date nb. this is defaulted to todays date
1169: select ss.effective_date
1170: into v_session_date
1171: from fnd_sessions ss
1172: where ss.session_id = userenv('sessionid');
1173: exception
1174: when NO_DATA_FOUND then NULL;
1175: end;

Line 1911: from fnd_sessions ss

1907: begin
1908: -- Get the session date nb. this is defaulted to todays date
1909: select ss.effective_date
1910: into v_session_date
1911: from fnd_sessions ss
1912: where ss.session_id = userenv('sessionid');
1913: exception
1914: when NO_DATA_FOUND then NULL;
1915: end;

Line 2077: from fnd_sessions

2073: --
2074: cursor get_eff_date
2075: is
2076: select effective_date
2077: from fnd_sessions
2078: where session_id = userenv('sessionid');
2079: --
2080: cursor get_cat_id(p_bal_type varchar2
2081: ,p_bg_id number

Line 2159: -- default the date from fnd_sessions, as a last resort use sysdate

2155: if g_debug then
2156: hr_utility.set_location('pay_db_pay_setup.create_defined_balance',3.5);
2157: end if;
2158: if p_effective_date is null then
2159: -- default the date from fnd_sessions, as a last resort use sysdate
2160: --
2161: open get_eff_date;
2162: fetch get_eff_date into l_eff_date;
2163: if get_eff_date%notfound then