APPS.HXT_TIME_GEN dependencies on FND_SESSIONS

Line 10: PROCEDURE manage_fnd_sessions; --SIR520

6: a_error_text VARCHAR2,
7: a_ora_err_text VARCHAR2 DEFAULT NULL
8: );
9:
10: PROCEDURE manage_fnd_sessions; --SIR520
11:
12: PROCEDURE update_batch_ref (l_batch_id NUMBER, a_reference_num VARCHAR2); --SIR71
13:
14: FUNCTION convert_time (

Line 171: manage_fnd_sessions;

167: --least one timecard has got autogenerated or
168: --change.If it remains false then log file will show message
169: --saying there no timecard is generated.
170: BEGIN
171: manage_fnd_sessions;
172: -- Save parameters to globals
173: g_payroll_id := a_payroll_id;
174: g_time_period_id := a_time_period_id;
175: -- Delete timecards that were autogen'ed for this period that won't be auto-

Line 396: DELETE FROM fnd_sessions

392: fnd_message.CLEAR;
393: retcode := 0;
394: END IF;
395:
396: DELETE FROM fnd_sessions
397: WHERE session_id = USERENV ('SESSIONID');
398:
399: COMMIT;
400: EXCEPTION

Line 403: DELETE FROM fnd_sessions

399: COMMIT;
400: EXCEPTION
401: WHEN g_del_obs_tim_error
402: THEN
403: DELETE FROM fnd_sessions
404: WHERE session_id = USERENV ('SESSIONID');
405:
406: COMMIT;
407: errbuf := g_sqlerrm;

Line 413: DELETE FROM fnd_sessions

409: call_gen_error (NULL, g_sqlerrm, SQLERRM);
410: retcode := 2;
411: WHEN OTHERS
412: THEN
413: DELETE FROM fnd_sessions
414: WHERE session_id = USERENV ('SESSIONID');
415:
416: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');
417: fnd_message.set_token ('SQLERR', SQLERRM);

Line 1486: PROCEDURE manage_fnd_sessions

1482: END IF;
1483: RAISE g_date_worked_error;
1484: END Get_Group_ID;
1485: */
1486: PROCEDURE manage_fnd_sessions
1487: IS
1488: CURSOR old_row_exists_cur
1489: IS
1490: SELECT '1'

Line 1491: FROM fnd_sessions

1487: IS
1488: CURSOR old_row_exists_cur
1489: IS
1490: SELECT '1'
1491: FROM fnd_sessions
1492: WHERE session_id = USERENV ('SESSIONID')
1493: AND effective_date < TRUNC ( SYSDATE
1494: - 1);
1495:

Line 1499: FROM fnd_sessions

1495:
1496: CURSOR row_exists_cur
1497: IS
1498: SELECT '1'
1499: FROM fnd_sessions
1500: WHERE session_id = USERENV ('SESSIONID')
1501: AND TRUNC (effective_date) BETWEEN TRUNC ( SYSDATE
1502: - 1)
1503: AND SYSDATE;

Line 1512: DELETE FROM fnd_sessions

1508: FETCH old_row_exists_cur INTO l_dummy;
1509:
1510: IF old_row_exists_cur%FOUND
1511: THEN
1512: DELETE FROM fnd_sessions
1513: WHERE session_id = USERENV ('SESSIONID')
1514: AND effective_date < TRUNC ( SYSDATE
1515: - 1);
1516:

Line 1525: INSERT INTO fnd_sessions

1521: FETCH row_exists_cur INTO l_dummy;
1522:
1523: IF row_exists_cur%NOTFOUND
1524: THEN
1525: INSERT INTO fnd_sessions
1526: (session_id, effective_date)
1527: VALUES (USERENV ('SESSIONID'), TRUNC (SYSDATE));
1528:
1529: COMMIT;