[Home] [Help]
PACKAGE: APPS.GL_TRANSACTION_DATES_PKG
Source
1 PACKAGE gl_transaction_dates_pkg AUTHID CURRENT_USER AS
2 /* $Header: glitcdas.pls 120.2 2005/05/05 01:28:49 kvora ship $ */
3 --
4 -- Package
5 -- gl_transaction_dates_pkg
6 -- Purpose
7 -- To contain procedures for maintaining of the GL_TRANSACTION_DATES table
8 -- History
9 -- 12-04-95 E Weinstein Created
10 --
11 -- Procedure
12 -- extend_transaction_calendars
13 -- Purpose
14 -- maintains GL_TRANSACTION_DATES table
15 -- History
16 -- 12-04-95 E Weinstein Created
17 -- Arguments
18 -- x_period_set_name Name of the calendar
19 -- containing the period
20 -- x_period_type Type of the period
21 -- x_entered_year the year which was entered for a period
22 -- Example
23 -- gl_transaction_dates_pkg.extend_transaction_calendars('Barclays',
24 -- 'Month','1997',sysdate,0,sysdate,0,0);
25 -- Notes
26 --
27 PROCEDURE extend_transaction_calendars
28 (
29 x_period_set_name VARCHAR2,
30 x_period_type VARCHAR2,
31 x_entered_year VARCHAR2,
32 x_CREATION_DATE DATE,
33 x_CREATED_BY NUMBER,
34 x_LAST_UPDATE_DATE DATE,
35 x_LAST_UPDATED_BY NUMBER,
36 x_LAST_UPDATE_LOGIN NUMBER
37 );
38 --
39 -- Procedure
40 -- insert_all_years_for_calendar
41 -- Purpose
42 -- maintains GL_TRANSACTION_DATES table
43 -- History
44 -- 12-12-95 E Weinstein Created
45 -- Arguments
46 -- x_transaction_calendar_id transaction_calendar_id from
47 -- GL_TRANSACTION_CALENDAR
48 -- Example
49 -- gl_transaction_dates_pkg.insert_all_years_for_calendar
50 -- (3,sysdate,0,sysdate,0,0);
51 -- Notes
52 --
53 PROCEDURE insert_all_years_for_calendar
54 (
55 x_transaction_calendar_id NUMBER,
56 x_CREATION_DATE DATE,
57 x_CREATED_BY NUMBER,
58 x_LAST_UPDATE_DATE DATE,
59 x_LAST_UPDATED_BY NUMBER,
60 x_LAST_UPDATE_LOGIN NUMBER
61 );
62 END gl_transaction_dates_pkg;