1 PACKAGE gl_date_period_map_pkg AS
2 /* $Header: gliprmps.pls 120.3 2005/05/05 01:18:05 kvora ship $ */
3 --
4 -- Package
5 -- gl_date_period_map_pkg
6 -- Purpose
7 -- To contain procedures for maintaining of the GL_DATE_PERIOD_MAP table
8 -- History
9 -- 12-04-95 E Weinstein Created
10 --
11 -- Procedure
12 -- maintain_date_period_map
13 -- Purpose
14 -- maintains GL_DATE_PERIOD_MAP 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_adjust_period_flag Calendar period adjustment status
22 -- x_operation UPDATE or INSERT
23 -- x_start_date date on which accounting period begins
24 -- x_end_date date on which accounting period ends
25 -- x_period_name system genrated accounting period name
26 -- Example
27 -- maintain_date_period_map ('Barclays', 'Month', 'N', 'UPDATE',
28 -- TO_DATE('01-02-1996','DD-MM-YYYY'), TO_DATE('28-02-1996','DD-MM-YYYY'),
29 -- 'FEB-96', sysdate,0,sysdate,0,0);
30 -- Notes
31 --
32 PROCEDURE maintain_date_period_map
33 (
34 x_period_set_name VARCHAR2,
35 x_period_type VARCHAR2,
36 x_adjust_period_flag VARCHAR2,
37 x_operation VARCHAR2,
38 x_start_date DATE,
39 x_end_date DATE,
40 x_period_name VARCHAR2,
41 x_CREATION_DATE DATE,
42 x_CREATED_BY NUMBER,
43 x_LAST_UPDATE_DATE DATE,
44 x_LAST_UPDATED_BY NUMBER,
45 x_LAST_UPDATE_LOGIN NUMBER
46 );
47
48 --
49 -- Procedure
50 -- select_columns
51 -- Purpose
52 -- Used to select period_name given period_set_name, period_type
53 -- and accounting_date.
54 -- History
55 -- 12-04-95 E Weinstein Created
56 -- Arguments
57 -- x_period_set_name Name of the calendar
58 -- containing the period
59 -- x_period_type Type of the period
60 -- x_accounting_date Date for which we want to find the period
61 -- x_period_name period_name which will be returned
62 -- Example
63 -- select_columns('Standard', 'Month', '10-MAY-96', x_period_name);
64 -- Notes
65 --
66 PROCEDURE select_columns
67 (
68 x_period_set_name VARCHAR2,
69 x_period_type VARCHAR2,
70 x_accounting_date DATE,
71 x_period_name IN OUT NOCOPY VARCHAR2);
72
73
74 END gl_date_period_map_pkg;