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_DADS_EMP_PKG dependencies on FND_SESSIONS

Line 1360: l_session_id fnd_sessions.session_id%type;

1356: l_023_ss_base_above_smic NUMBER;
1357: l_023_ss_base_above_smic_retro NUMBER;
1358: l_023_gross_sbase_sec NUMBER;
1359: l_hourly_smic_rate NUMBER;
1360: l_session_id fnd_sessions.session_id%type;
1361:
1362: --temp Variables used to sort pl/sql table...
1363: tmp_start_date Date;
1364: tmp_start_reason Varchar2(10);

Line 2925: /* 4172068 checking whether a record exists in fnd_sessions table */

2921: -- need to find the last month where l_num_hrs_latest>= 60
2922: -- if the person has resigned or l_num_hrs_latest < 1200
2923: if (l_num_hrs_latest < 1200) or (l_act_dt < l_effective_date) then
2924: hr_utility.set_location('Find latest month', 22);
2925: /* 4172068 checking whether a record exists in fnd_sessions table */
2926: select count(session_id)
2927: into l_session_id
2928: from fnd_sessions
2929: where session_id = userenv('sessionid');

Line 2928: from fnd_sessions

2924: hr_utility.set_location('Find latest month', 22);
2925: /* 4172068 checking whether a record exists in fnd_sessions table */
2926: select count(session_id)
2927: into l_session_id
2928: from fnd_sessions
2929: where session_id = userenv('sessionid');
2930: if l_session_id > 0 then
2931: -- find the SMIC rate
2932: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));

Line 2934: /* 4172068 insert a record only if there is no record exists in fnd_sessions table */

2930: if l_session_id > 0 then
2931: -- find the SMIC rate
2932: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2933: else
2934: /* 4172068 insert a record only if there is no record exists in fnd_sessions table */
2935: -- insert a row into fnd_sessions for the DBI value to be retrieved
2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);
2937: -- find the SMIC rate
2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));

Line 2935: -- insert a row into fnd_sessions for the DBI value to be retrieved

2931: -- find the SMIC rate
2932: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2933: else
2934: /* 4172068 insert a record only if there is no record exists in fnd_sessions table */
2935: -- insert a row into fnd_sessions for the DBI value to be retrieved
2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);
2937: -- find the SMIC rate
2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2939: -- delete the row from fnd_sessions

Line 2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);

2932: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2933: else
2934: /* 4172068 insert a record only if there is no record exists in fnd_sessions table */
2935: -- insert a row into fnd_sessions for the DBI value to be retrieved
2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);
2937: -- find the SMIC rate
2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2939: -- delete the row from fnd_sessions
2940: Delete from fnd_sessions where session_id = userenv('sessionid');

Line 2939: -- delete the row from fnd_sessions

2935: -- insert a row into fnd_sessions for the DBI value to be retrieved
2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);
2937: -- find the SMIC rate
2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2939: -- delete the row from fnd_sessions
2940: Delete from fnd_sessions where session_id = userenv('sessionid');
2941: end if;
2942: /* 4172068 */
2943: --

Line 2940: Delete from fnd_sessions where session_id = userenv('sessionid');

2936: Insert into fnd_sessions (session_id, effective_date) values(userenv('sessionid'), sysdate);
2937: -- find the SMIC rate
2938: l_hourly_smic_rate := to_number(pay_balance_pkg.run_db_item('FR_HOURLY_SMIC_RATE', null, 'FR'));
2939: -- delete the row from fnd_sessions
2940: Delete from fnd_sessions where session_id = userenv('sessionid');
2941: end if;
2942: /* 4172068 */
2943: --
2944: For i in csr_get_per_dates(l_effective_date)