1 PACKAGE gl_bc_event_tstamps_pkg AS
2 /* $Header: glibcets.pls 120.2 2005/05/05 00:59:22 kvora ship $ */
3 --
4 -- Package
5 -- gl_bc_event_tstamps_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_bc_event_timestamps
8 -- History
9 -- 12-03-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- insert_event_timestamp
14 -- Purpose
15 -- Used to insert a record into gl_bc_event_timestamps,
16 -- if one has not yet been inserted for this chart of accounts
17 -- and event.
18 -- History
19 -- 12-03-93 D. J. Ogg Created
20 -- Arguments
21 -- x_chart_of_accounts_id ID of the chart of accounts
22 -- x_event_code Code for the event (B - budget, S - ?)
23 -- x_last_updated_by ID of the user doing the insertion
24 -- x_last_update_login Login ID of the user doing the insertion
25 -- Example
26 -- gl_bc_event_tstamps_pkg.insert_event_timestamp(101, 'B', 15, 25)
27 -- Notes
28 --
29 PROCEDURE insert_event_timestamp(
30 x_chart_of_accounts_id NUMBER,
31 x_event_code VARCHAR2,
32 x_last_updated_by NUMBER,
33 x_last_update_login NUMBER);
34
35 --
36 -- Procedure
37 -- set_event_timestamp
38 -- Purpose
39 -- Sets the event timestamp to the current time
40 -- History
41 -- 12-03-93 D. J. Ogg Created
42 -- Arguments
43 -- x_chart_of_accounts_id ID of the chart of accounts
44 -- x_event_code Code for the event (B - budget, S - ?)
45 -- x_last_updated_by ID of the user doing the insertion
46 -- x_last_update_login Login ID of the user doing the insertion
47 -- Example
48 -- gl_bc_event_tstamps_pkg.set_event_timestamp(101, 'B', 15, 25)
49 -- Notes
50 --
51 PROCEDURE set_event_timestamp(
52 x_chart_of_accounts_id NUMBER,
53 x_event_code VARCHAR2,
54 x_last_updated_by NUMBER,
55 x_last_update_login NUMBER);
56
57 --
58 -- Procedure
59 -- lock_event_timestamp
60 -- Purpose
61 -- Locks the event timestamp
62 -- History
63 -- 12-16-93 D. J. Ogg Created
64 -- Arguments
65 -- x_chart_of_accounts_id ID of the chart of accounts
66 -- x_event_code Code for the event (B - budget, S - ?)
67 -- Example
68 -- gl_bc_event_tstamps_pkg.lock_event_timestamp(101, 'B')
69 -- Notes
70 --
71 PROCEDURE lock_event_timestamp(
72 x_chart_of_accounts_id NUMBER,
73 x_event_code VARCHAR2);
74
75 END gl_bc_event_tstamps_pkg;