eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_CALC_SQL_EXPS

Line 1: PACKAGE CN_CALC_SQL_EXPS_PVT AUTHID CURRENT_USER AS

1: PACKAGE CN_CALC_SQL_EXPS_PVT AUTHID CURRENT_USER AS
2: /*$Header: cnvcexps.pls 120.6 2007/03/14 12:56:42 kjayapau ship $*/
3:
4: TYPE parent_expression_tbl_type IS TABLE OF VARCHAR2(30)
5: INDEX BY BINARY_INTEGER;

Line 8: (CALC_SQL_EXP_ID CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

4: TYPE parent_expression_tbl_type IS TABLE OF VARCHAR2(30)
5: INDEX BY BINARY_INTEGER;
6:
7: TYPE calc_expression_rec_type IS RECORD
8: (CALC_SQL_EXP_ID CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
9: NAME CN_CALC_SQL_EXPS.NAME%TYPE,
10: DESCRIPTION CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
11: STATUS CN_CALC_SQL_EXPS.STATUS%TYPE,
12: EXP_TYPE_CODE CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE);

Line 9: NAME CN_CALC_SQL_EXPS.NAME%TYPE,

5: INDEX BY BINARY_INTEGER;
6:
7: TYPE calc_expression_rec_type IS RECORD
8: (CALC_SQL_EXP_ID CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
9: NAME CN_CALC_SQL_EXPS.NAME%TYPE,
10: DESCRIPTION CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
11: STATUS CN_CALC_SQL_EXPS.STATUS%TYPE,
12: EXP_TYPE_CODE CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE);
13:

Line 10: DESCRIPTION CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,

6:
7: TYPE calc_expression_rec_type IS RECORD
8: (CALC_SQL_EXP_ID CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
9: NAME CN_CALC_SQL_EXPS.NAME%TYPE,
10: DESCRIPTION CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
11: STATUS CN_CALC_SQL_EXPS.STATUS%TYPE,
12: EXP_TYPE_CODE CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE);
13:
14: TYPE calc_expression_tbl_type IS TABLE OF calc_expression_rec_type

Line 11: STATUS CN_CALC_SQL_EXPS.STATUS%TYPE,

7: TYPE calc_expression_rec_type IS RECORD
8: (CALC_SQL_EXP_ID CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
9: NAME CN_CALC_SQL_EXPS.NAME%TYPE,
10: DESCRIPTION CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
11: STATUS CN_CALC_SQL_EXPS.STATUS%TYPE,
12: EXP_TYPE_CODE CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE);
13:
14: TYPE calc_expression_tbl_type IS TABLE OF calc_expression_rec_type
15: INDEX BY BINARY_INTEGER;

Line 12: EXP_TYPE_CODE CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE);

8: (CALC_SQL_EXP_ID CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
9: NAME CN_CALC_SQL_EXPS.NAME%TYPE,
10: DESCRIPTION CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
11: STATUS CN_CALC_SQL_EXPS.STATUS%TYPE,
12: EXP_TYPE_CODE CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE);
13:
14: TYPE calc_expression_tbl_type IS TABLE OF calc_expression_rec_type
15: INDEX BY BINARY_INTEGER;
16:

Line 83: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,

79: (p_api_version IN NUMBER ,
80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
84: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
85: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
86: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
87: p_sql_select IN VARCHAR2 := NULL,

Line 84: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,

80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
81: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
84: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
85: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
86: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
87: p_sql_select IN VARCHAR2 := NULL,
88: p_sql_from IN VARCHAR2 := NULL,

Line 85: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,

81: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
84: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
85: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
86: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
87: p_sql_select IN VARCHAR2 := NULL,
88: p_sql_from IN VARCHAR2 := NULL,
89: p_piped_expression_disp IN VARCHAR2 := NULL,

Line 92: x_calc_sql_exp_id IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

88: p_sql_from IN VARCHAR2 := NULL,
89: p_piped_expression_disp IN VARCHAR2 := NULL,
90: p_piped_sql_select IN VARCHAR2 := NULL,
91: p_piped_sql_from IN VARCHAR2 := NULL,
92: x_calc_sql_exp_id IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
93: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
94: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
95: x_return_status OUT NOCOPY VARCHAR2 ,
96: x_msg_count OUT NOCOPY NUMBER ,

Line 93: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

89: p_piped_expression_disp IN VARCHAR2 := NULL,
90: p_piped_sql_select IN VARCHAR2 := NULL,
91: p_piped_sql_from IN VARCHAR2 := NULL,
92: x_calc_sql_exp_id IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
93: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
94: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
95: x_return_status OUT NOCOPY VARCHAR2 ,
96: x_msg_count OUT NOCOPY NUMBER ,
97: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 94: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,

90: p_piped_sql_select IN VARCHAR2 := NULL,
91: p_piped_sql_from IN VARCHAR2 := NULL,
92: x_calc_sql_exp_id IN OUT NOCOPY CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
93: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
94: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
95: x_return_status OUT NOCOPY VARCHAR2 ,
96: x_msg_count OUT NOCOPY NUMBER ,
97: x_msg_data OUT NOCOPY VARCHAR2 ,
98: x_object_version_number OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

Line 98: x_object_version_number OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);

94: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
95: x_return_status OUT NOCOPY VARCHAR2 ,
96: x_msg_count OUT NOCOPY NUMBER ,
97: x_msg_data OUT NOCOPY VARCHAR2 ,
98: x_object_version_number OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);
99:
100: -- Start of comments
101: -- API name : Update_Expressions
102: -- Type : Private.

Line 159: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,

155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
156: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
159: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
160: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
161: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
162: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
163: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs

Line 160: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

156: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
159: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
160: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
161: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
162: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
163: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
164: p_sql_select IN VARCHAR2 := NULL,

Line 161: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,

157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
159: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
160: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
161: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
162: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
163: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
164: p_sql_select IN VARCHAR2 := NULL,
165: p_sql_from IN VARCHAR2 := NULL,

Line 162: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,

158: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,
159: p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
160: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
161: p_name IN CN_CALC_SQL_EXPS.NAME%TYPE,
162: p_description IN CN_CALC_SQL_EXPS.DESCRIPTION%TYPE := NULL,
163: p_expression_disp IN VARCHAR2 := NULL, -- CLOBs
164: p_sql_select IN VARCHAR2 := NULL,
165: p_sql_from IN VARCHAR2 := NULL,
166: p_piped_expression_disp IN VARCHAR2 := NULL,

Line 169: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,

165: p_sql_from IN VARCHAR2 := NULL,
166: p_piped_expression_disp IN VARCHAR2 := NULL,
167: p_piped_sql_select IN VARCHAR2 := NULL,
168: p_piped_sql_from IN VARCHAR2 := NULL,
169: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
170: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
171: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
172: x_return_status OUT NOCOPY VARCHAR2 ,
173: x_msg_count OUT NOCOPY NUMBER ,

Line 170: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

166: p_piped_expression_disp IN VARCHAR2 := NULL,
167: p_piped_sql_select IN VARCHAR2 := NULL,
168: p_piped_sql_from IN VARCHAR2 := NULL,
169: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
170: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
171: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
172: x_return_status OUT NOCOPY VARCHAR2 ,
173: x_msg_count OUT NOCOPY NUMBER ,
174: x_msg_data OUT NOCOPY VARCHAR2 );

Line 171: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,

167: p_piped_sql_select IN VARCHAR2 := NULL,
168: p_piped_sql_from IN VARCHAR2 := NULL,
169: p_ovn IN OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE,
170: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
171: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
172: x_return_status OUT NOCOPY VARCHAR2 ,
173: x_msg_count OUT NOCOPY NUMBER ,
174: x_msg_data OUT NOCOPY VARCHAR2 );
175:

Line 208: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

204: (p_api_version IN NUMBER ,
205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
206: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
208: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
209: x_return_status OUT NOCOPY VARCHAR2 ,
210: x_msg_count OUT NOCOPY NUMBER ,
211: x_msg_data OUT NOCOPY VARCHAR2 );
212:

Line 242: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

238: (p_api_version IN NUMBER ,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
243: x_parents_tbl OUT NOCOPY parent_expression_tbl_type ,
244: x_return_status OUT NOCOPY VARCHAR2 ,
245: x_msg_count OUT NOCOPY NUMBER ,
246: x_msg_data OUT NOCOPY VARCHAR2 );*/

Line 250: (p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,

246: x_msg_data OUT NOCOPY VARCHAR2 );*/
247:
248: -- determine the expression type given its SQL statement.
249: PROCEDURE classify_expression
250: (p_org_id IN CN_CALC_SQL_EXPS.ORG_ID%TYPE,
251: p_sql_select IN VARCHAR2, -- CLOBs
252: p_sql_from IN VARCHAR2,
253: p_piped_sql_select IN VARCHAR2,
254: p_piped_sql_from IN VARCHAR2,

Line 255: x_status IN OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,

251: p_sql_select IN VARCHAR2, -- CLOBs
252: p_sql_from IN VARCHAR2,
253: p_piped_sql_select IN VARCHAR2,
254: p_piped_sql_from IN VARCHAR2,
255: x_status IN OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
256: x_exp_type_code IN OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2);
259:

Line 256: x_exp_type_code IN OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

252: p_sql_from IN VARCHAR2,
253: p_piped_sql_select IN VARCHAR2,
254: p_piped_sql_from IN VARCHAR2,
255: x_status IN OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
256: x_exp_type_code IN OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2);
259:
260: -- translate the usage code of an expression to get its meaning

Line 262: (p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

258: x_msg_data OUT NOCOPY VARCHAR2);
259:
260: -- translate the usage code of an expression to get its meaning
261: PROCEDURE get_usage_info
262: (p_exp_type_code IN CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
263: x_usage_info OUT NOCOPY VARCHAR2);
264:
265: -- populate the summary screen
266: /*PROCEDURE get_expr_summary

Line 275: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

271: x_result_tbl OUT NOCOPY calc_expression_tbl_type);*/
272:
273: -- populate the details for an expression
274: /*PROCEDURE get_expr_detail
275: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
276: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
277: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
278: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
279: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

Line 276: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,

272:
273: -- populate the details for an expression
274: /*PROCEDURE get_expr_detail
275: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
276: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
277: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
278: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
279: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
280: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs

Line 277: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,

273: -- populate the details for an expression
274: /*PROCEDURE get_expr_detail
275: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
276: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
277: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
278: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
279: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
280: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
281: x_sql_select OUT NOCOPY VARCHAR2,

Line 278: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,

274: /*PROCEDURE get_expr_detail
275: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
276: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
277: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
278: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
279: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
280: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
281: x_sql_select OUT NOCOPY VARCHAR2,
282: x_sql_from OUT NOCOPY VARCHAR2,

Line 279: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

275: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
276: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
277: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
278: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
279: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
280: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
281: x_sql_select OUT NOCOPY VARCHAR2,
282: x_sql_from OUT NOCOPY VARCHAR2,
283: x_piped_sql_select OUT NOCOPY VARCHAR2,

Line 286: x_ovn OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);*/

282: x_sql_from OUT NOCOPY VARCHAR2,
283: x_piped_sql_select OUT NOCOPY VARCHAR2,
284: x_piped_sql_from OUT NOCOPY VARCHAR2,
285: x_piped_expression_disp OUT NOCOPY VARCHAR2,
286: x_ovn OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE);*/
287:
288: -- get all the types of elements that can be included in expressions. the
289: -- types are arranged in a tree structure. each type has a value, a label
290: -- and a parent value, as well as the element that gets included in the

Line 355: x_new_expr_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,

351: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: p_old_expr_id IN NUMBER,
354: x_new_expr_id OUT NOCOPY NUMBER,
355: x_new_expr_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
358: x_msg_data OUT NOCOPY VARCHAR2);
359:

Line 360: END CN_CALC_SQL_EXPS_PVT;

356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
358: x_msg_data OUT NOCOPY VARCHAR2);
359:
360: END CN_CALC_SQL_EXPS_PVT;