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 51: -- instead of the views referring FND_SESSIONS

47: -- this time period (auto-gen='Y', pay_status='P')
48:
49: -- Bug 7359347
50: -- Changed the below cursor to use global session date variable
51: -- instead of the views referring FND_SESSIONS
52: -- Added outer join to all the session date conditions.
53: /*
54: CURSOR g_cur_asm (a_payroll_id NUMBER, a_time_period_id NUMBER)
55: IS

Line 279: manage_fnd_sessions;

275: THEN
276: g_gen_session_date := hxt_tim_col_util.return_session_date;
277: END IF;
278:
279: manage_fnd_sessions;
280: -- Save parameters to globals
281:
282:
283:

Line 529: DELETE FROM fnd_sessions

525: fnd_message.CLEAR;
526: retcode := 0;
527: END IF;
528:
529: DELETE FROM fnd_sessions
530: WHERE session_id = USERENV ('SESSIONID');
531:
532: COMMIT;
533: EXCEPTION

Line 536: DELETE FROM fnd_sessions

532: COMMIT;
533: EXCEPTION
534: WHEN g_del_obs_tim_error
535: THEN
536: DELETE FROM fnd_sessions
537: WHERE session_id = USERENV ('SESSIONID');
538:
539: COMMIT;
540: errbuf := g_sqlerrm;

Line 546: DELETE FROM fnd_sessions

542: call_gen_error (NULL, g_sqlerrm, SQLERRM);
543: retcode := 2;
544: WHEN OTHERS
545: THEN
546: DELETE FROM fnd_sessions
547: WHERE session_id = USERENV ('SESSIONID');
548:
549: fnd_message.set_name ('HXT', 'HXT_39366_AUTOGEN_SYST_ERR');
550: fnd_message.set_token ('SQLERR', SQLERRM);

Line 1528: -- Delete from the table instead of the view so FND_SESSIONS is not required.

1524: WHERE tim_id = a_tim_id;
1525:
1526: --SIR012 DELETE from hxt_sum_hours_worked
1527: -- Bug 7359347
1528: -- Delete from the table instead of the view so FND_SESSIONS is not required.
1529: /*
1530: DELETE FROM hxt_sum_hours_worked
1531: WHERE tim_id = a_tim_id; --C421
1532: */

Line 1634: PROCEDURE manage_fnd_sessions

1630: END IF;
1631: RAISE g_date_worked_error;
1632: END Get_Group_ID;
1633: */
1634: PROCEDURE manage_fnd_sessions
1635: IS
1636: CURSOR old_row_exists_cur
1637: IS
1638: SELECT '1'

Line 1639: FROM fnd_sessions

1635: IS
1636: CURSOR old_row_exists_cur
1637: IS
1638: SELECT '1'
1639: FROM fnd_sessions
1640: WHERE session_id = USERENV ('SESSIONID')
1641: AND effective_date < TRUNC ( SYSDATE
1642: - 1);
1643:

Line 1647: FROM fnd_sessions

1643:
1644: CURSOR row_exists_cur
1645: IS
1646: SELECT '1'
1647: FROM fnd_sessions
1648: WHERE session_id = USERENV ('SESSIONID')
1649: AND TRUNC (effective_date) BETWEEN TRUNC ( SYSDATE
1650: - 1)
1651: AND SYSDATE;

Line 1662: DELETE FROM fnd_sessions

1658: FETCH old_row_exists_cur INTO l_dummy;
1659:
1660: IF old_row_exists_cur%FOUND
1661: THEN
1662: DELETE FROM fnd_sessions
1663: WHERE session_id = USERENV ('SESSIONID')
1664: AND effective_date < TRUNC ( SYSDATE
1665: - 1);
1666:

Line 1674: INSERT INTO fnd_sessions

1670: FETCH row_exists_cur INTO l_dummy;
1671:
1672: IF row_exists_cur%NOTFOUND
1673: THEN
1674: INSERT INTO fnd_sessions
1675: (session_id, effective_date)
1676: VALUES (USERENV ('SESSIONID'), TRUNC (SYSDATE));
1677:
1678: COMMIT;