[Home] [Help]
PACKAGE: APPS.CN_CALC_SUB_BATCHES_PKG
Source
1 PACKAGE CN_CALC_SUB_BATCHES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cnsbbats.pls 120.1 2005/06/10 14:04:06 appldev $ */
3
4 TYPE calc_sub_batch_rec_type IS RECORD
5 ( calc_sub_batch_id cn_calc_submission_batches.calc_sub_batch_id%TYPE,
6 name cn_calc_submission_batches.name%TYPE,
7 intelligent_flag cn_calc_submission_batches.intelligent_flag%TYPE,
8 hierarchy_flag cn_calc_submission_batches.hierarchy_flag%TYPE,
9 salesrep_option cn_calc_submission_batches.salesrep_option%TYPE,
10 -- concurrent_flag cn_calc_submission_batches.concurrent_flag%TYPE,
11 logical_batch_id cn_calc_submission_batches.logical_batch_id%TYPE,
12 start_date cn_calc_submission_batches.start_date%TYPE,
13 end_date cn_calc_submission_batches.end_date%TYPE,
14 calc_type cn_calc_submission_batches.calc_type%TYPE,
15 -- ledger_je_batch_id cn_calc_submission_batches.ledger_je_batch_id%TYPE,
16 interval_type_id cn_calc_submission_batches.interval_type_id%TYPE );
17
18
19 --
20 --
21 --
22 -- This Procedure is called to
23 -- 1. Insert
24 -- 2. Update
25 -- 3. Delete
26 -- Records into Table cn_calc_submission_batches
27 --
28 --
29 --
30 Procedure Begin_Record ( P_OPERATION VARCHAR2,
31 p_calc_sub_batch_id NUMBER := NULL,
32 p_name VARCHAR2 := NULL,
33 p_start_date DATE := NULL,
34 p_end_date DATE := NULL,
35 p_intelligent_flag VARCHAR2 := NULL,
36 p_hierarchy_flag VARCHAR2 := NULL,
37 p_salesrep_option VARCHAR2 := NULL,
38 p_concurrent_flag VARCHAR2 := NULL,
39 p_status VARCHAR2 := NULL,
40 p_logical_batch_id NUMBER := NULL,
41 p_calc_type VARCHAR2 := NULL,
42 p_interval_type_id NUMBER := NULL,
43 p_org_id NUMBER,
44 p_log_name VARCHAR2 := NULL,
45 P_ATTRIBUTE_CATEGORY VARCHAR2 := NULL,
46 P_ATTRIBUTE1 VARCHAR2 := NULL,
47 P_ATTRIBUTE2 VARCHAR2 := NULL,
48 P_ATTRIBUTE3 VARCHAR2 := NULL,
49 P_ATTRIBUTE4 VARCHAR2 := NULL,
50 P_ATTRIBUTE5 VARCHAR2 := NULL,
51 P_ATTRIBUTE6 VARCHAR2 := NULL,
52 P_ATTRIBUTE7 VARCHAR2 := NULL,
53 P_ATTRIBUTE8 VARCHAR2 := NULL,
54 P_ATTRIBUTE9 VARCHAR2 := NULL,
55 P_ATTRIBUTE10 VARCHAR2 := NULL,
56 P_ATTRIBUTE11 VARCHAR2 := NULL,
57 P_ATTRIBUTE12 VARCHAR2 := NULL,
58 P_ATTRIBUTE13 VARCHAR2 := NULL,
59 P_ATTRIBUTE14 VARCHAR2 := NULL,
60 P_ATTRIBUTE15 VARCHAR2 := NULL,
61 P_CREATED_BY NUMBER := NULL,
62 P_CREATION_DATE DATE := NULL,
63 P_LAST_UPDATE_LOGIN NUMBER := NULL,
64 P_LAST_UPDATE_DATE DATE := NULL,
65 P_LAST_UPDATED_BY NUMBER := NULL
66 );
67
68 --+
69 -- Procedure Name
70 -- get_calc_sub_batch
71 -- Scope
72 -- public
73 -- Purpose
74 -- get the calc_submission for this physical batch
75 -- state.
76 -- History
77 -- 10-JUL-98 Richard Jin Created
78 --+
79 PROCEDURE get_calc_sub_batch ( p_physical_batch_id NUMBER,
80 x_calc_sub_batch_rec OUT NOCOPY calc_sub_batch_rec_type );
81
82 --+
83 -- Procedure Name
84 -- get_intel_calc_flag
85 -- Scope
86 -- public
87 -- Purpose
88 -- get the intelligent_flag for this physical batch
89 -- state.
90 -- History
91 -- 10-JUL-98 Richard Jin Created
92 --+
93 FUNCTION get_intel_calc_flag (p_calc_batch_id NUMBER) RETURN VARCHAR2;
94
95
96 --+
97 -- Procedure Name
98 -- get_forecast_flag
99 -- Scope
100 -- public
101 -- Purpose
102 -- get the intelligent_flag for this physical batch
103 -- state.
104 -- History
105 -- 10-JUL-98 Richard Jin Created
106 --+
107 FUNCTION get_forecast_flag (p_calc_batch_id NUMBER) RETURN VARCHAR2 ;
108
109 --+
110 -- Procedure Name
111 -- get_calc_type
112 -- Scope
113 -- public
114 -- Purpose
115 -- get the calculation type for this physical batch
116 -- state.
117 -- History
118 -- 10-JUL-98 Richard Jin Created
119 --+
120
121 FUNCTION get_calc_type (p_calc_batch_id NUMBER) RETURN VARCHAR2 ;
122
123 --+
124 -- Procedure Name
125 -- get_concurrent_flag
126 -- Scope
127 -- public
128 -- Purpose
129 -- get the concurrent flag for this physical batch
130 -- state.
131 -- History
132 -- 10-JUL-98 Richard Jin Created
133 --+
134 FUNCTION get_concurrent_flag (p_calc_sub_batch_id NUMBER) RETURN VARCHAR2 ;
135
136 --+
137 -- Procedure Name
138 -- get_salesrep_option
139 -- Scope
140 -- public
141 -- Purpose
142 -- get the calculation type for this physical batch
143 -- state.
144 -- History
145 -- 10-JUL-98 Richard Jin Created
146 --+
147
148 FUNCTION get_salesrep_option (p_calc_batch_id NUMBER) RETURN VARCHAR2 ;
149
150 --+
151 -- Procedure Name
152 -- get_calc_sub_batch_id
153 -- Scope
154 -- public
155 -- Purpose
156 -- get new calc_sub_batch_id
157 -- state.
158 -- History
159 -- 10-JUL-98 Richard Jin Created
160 --+
161 FUNCTION get_calc_sub_batch_id RETURN NUMBER;
162
163 --+
164 -- Procedure Name
165 -- delete_calc_sub_batch
166 -- Scope
167 -- public
168 -- Purpose
169 -- delete a calc submission batch
170 -- state.
171 -- History
172 -- 10-JUL-98 Richard Jin Created
173 --+
174 PROCEDURE delete_calc_sub_batch (p_calc_sub_batch_id NUMBER);
175
176 --+
177 -- Procedure Name
178 -- update_calc_sub_batch
179 -- Scope
180 -- public
181 -- Purpose
182 -- update status of a calc submission batch
183 -- state.
184 -- History
185 -- 10-JUL-98 Richard Jin Created
186 --+
187 PROCEDURE update_calc_sub_batch (p_logical_batch_id NUMBER,
188 p_status VARCHAR2);
189
190 END cn_calc_sub_batches_pkg;