[Home] [Help]
PACKAGE: APPS.GL_TRANSACTION_CALENDAR_PKG
Source
1 PACKAGE gl_transaction_calendar_pkg AS
2 /* $Header: glitrcls.pls 120.5 2003/12/05 18:56:12 cma ship $ */
3 --
4 -- Package
5 -- gl_transaction_calendar_pkg
6 -- Purpose
7 -- To contain procedures for maintaining of the GL_TRANSACTION_DATES table
8 -- History
9 -- 12-11-95 E Weinstein Created
10
11 --
12 -- Procedure
13 -- check_unique
14 -- Purpose
15 -- Checks to make sure that the name of the calendar
16 -- is unique.
17 -- History
18 -- 12-11-95 E Weinstein Created
19 -- Arguments
20 -- calendar_name The name of the calendar
21 -- row_id The current rowid
22 -- Example
23 -- gl_transaction_calendar_pkg.check_unique('Standard', 'ABCDEDF');
24 -- Notes
25 --
26 PROCEDURE check_unique(x_name VARCHAR2, row_id VARCHAR2);
27
28 --
29 -- Procedure
30 -- lock_row
31 -- Purpose
32 -- lock row of GL_TRANSACTION_CALENDAR
33 -- History
34 -- 07-07-2003 psahay Created
35 -- Arguments
36 -- all table columns except WHO columns
37 --
38 PROCEDURE lock_row
39 (X_Rowid IN OUT NOCOPY VARCHAR2,
40 x_transaction_calendar_id NUMBER,
41 x_name VARCHAR2,
42 x_sun_business_day_flag VARCHAR2,
43 x_mon_business_day_flag VARCHAR2,
44 x_tue_business_day_flag VARCHAR2,
45 x_wed_business_day_flag VARCHAR2,
46 x_thu_business_day_flag VARCHAR2,
47 x_fri_business_day_flag VARCHAR2,
48 x_sat_business_day_flag VARCHAR2,
49 x_security_flag VARCHAR2,
50 x_description VARCHAR2,
51 x_context VARCHAR2,
52 x_attribute1 VARCHAR2,
53 x_attribute2 VARCHAR2,
54 x_attribute3 VARCHAR2,
55 x_attribute4 VARCHAR2,
56 x_attribute5 VARCHAR2,
57 x_attribute6 VARCHAR2,
58 x_attribute7 VARCHAR2,
59 x_attribute8 VARCHAR2,
60 x_attribute9 VARCHAR2,
61 x_attribute10 VARCHAR2,
62 x_attribute11 VARCHAR2,
63 x_attribute12 VARCHAR2,
64 x_attribute13 VARCHAR2,
65 x_attribute14 VARCHAR2,
66 x_attribute15 VARCHAR2
67 );
68
69 --
70 -- Procedure
71 -- insert_row
72 -- Purpose
73 -- insert record into the GL_TRANSACTION_CALENDAR
74 -- History
75 -- 12-11-95 E Weinstein Created
76 -- 07-07-03 PSAHAY Added x_security_flag
77 -- Arguments
78 -- all table columns
79 --
80 PROCEDURE insert_row
81 (X_Rowid IN OUT NOCOPY VARCHAR2,
82 x_transaction_calendar_id IN OUT NOCOPY NUMBER,
83 x_name VARCHAR2,
84 x_sun_business_day_flag VARCHAR2,
85 x_mon_business_day_flag VARCHAR2,
86 x_tue_business_day_flag VARCHAR2,
87 x_wed_business_day_flag VARCHAR2,
88 x_thu_business_day_flag VARCHAR2,
89 x_fri_business_day_flag VARCHAR2,
90 x_sat_business_day_flag VARCHAR2,
91 x_security_flag VARCHAR2,
92 x_creation_date DATE,
93 x_created_by NUMBER,
94 x_last_update_date DATE,
95 x_last_updated_by NUMBER,
96 x_last_update_login NUMBER,
97 x_description VARCHAR2,
98 x_context VARCHAR2,
99 x_attribute1 VARCHAR2,
100 x_attribute2 VARCHAR2,
101 x_attribute3 VARCHAR2,
102 x_attribute4 VARCHAR2,
103 x_attribute5 VARCHAR2,
104 x_attribute6 VARCHAR2,
105 x_attribute7 VARCHAR2,
106 x_attribute8 VARCHAR2,
107 x_attribute9 VARCHAR2,
108 x_attribute10 VARCHAR2,
109 x_attribute11 VARCHAR2,
110 x_attribute12 VARCHAR2,
111 x_attribute13 VARCHAR2,
112 x_attribute14 VARCHAR2,
113 x_attribute15 VARCHAR2
114 );
115
116 --
117 -- Procedure
118 -- delete_row
119 -- Purpose
120 -- delete record from the GL_TRANSACTION_CALENDAR and GL_TRANSACTION_DATES
121 -- History
122 -- 12-15-95 E Weinstein Created
123 -- Arguments
124 -- x_transaction_calendar_id Transaction calendar ID
125 --
126 PROCEDURE delete_row(x_transaction_calendar_id NUMBER);
127
128 --
129 -- Procedure
130 -- check_calendar
131 -- Purpose
132 -- check that the calendar is not being used in any of the Ledgers
133 -- History
134 -- 12-15-95 E Weinstein Created
135 -- Arguments
136 -- x_transaction_calendar_id Transaction calendar ID
137 --
138 PROCEDURE check_calendar(x_transaction_calendar_id NUMBER);
139
140 END gl_transaction_calendar_pkg;