APPS.GL_BC_EVENT_TSTAMPS_PKG dependencies on GL_BC_EVENT_TIMESTAMPS

Line 16: INSERT INTO GL_BC_EVENT_TIMESTAMPS

12: x_last_update_login NUMBER) IS
13:
14: BEGIN
15:
16: INSERT INTO GL_BC_EVENT_TIMESTAMPS
17: (chart_of_accounts_id, event_code, date_timestamp,
18: last_update_date, last_updated_by,
19: creation_date, created_by,
20: last_update_login)

Line 29: FROM gl_bc_event_timestamps

25: FROM fnd_dual
26: WHERE rownum = 1
27: AND NOT EXISTS
28: (SELECT 'row already exists'
29: FROM gl_bc_event_timestamps
30: WHERE chart_of_accounts_id = x_chart_of_accounts_id
31: AND event_code = x_event_code);
32:
33: EXCEPTION

Line 54: UPDATE gl_bc_event_timestamps

50: x_last_update_login NUMBER) IS
51:
52: BEGIN
53:
54: UPDATE gl_bc_event_timestamps
55: SET date_timestamp = sysdate,
56: last_update_date = sysdate,
57: last_updated_by = x_last_updated_by,
58: last_update_login = x_last_update_login

Line 78: FROM GL_BC_EVENT_TIMESTAMPS

74: x_chart_of_accounts_id NUMBER,
75: x_event_code VARCHAR2) IS
76: CURSOR lock_stamp is
77: SELECT 'Locked stamp'
78: FROM GL_BC_EVENT_TIMESTAMPS
79: WHERE chart_of_accounts_id = x_chart_of_accounts_id
80: AND event_code = x_event_code
81: FOR UPDATE OF date_timestamp;
82: dummy VARCHAR2(100);