DBA Data[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;