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 FND_API

Line 38: -- Default = FND_API.G_FALSE

34: -- Pre-reqs : None.
35: -- Parameters :
36: -- IN : p_api_version IN NUMBER Required
37: -- p_init_msg_list IN VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_commit IN VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level IN NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 40: -- Default = FND_API.G_FALSE

36: -- IN : p_api_version IN NUMBER Required
37: -- p_init_msg_list IN VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_commit IN VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level IN NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_name IN VARCHAR2 Required
44: -- p_description IN VARCHAR2 Optional

Line 42: -- Default = FND_API.G_VALID_LEVEL_FULL

38: -- Default = FND_API.G_FALSE
39: -- p_commit IN VARCHAR2 Optional
40: -- Default = FND_API.G_FALSE
41: -- p_validation_level IN NUMBER Optional
42: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- p_name IN VARCHAR2 Required
44: -- p_description IN VARCHAR2 Optional
45: -- Default = null
46: -- p_expression_disp IN VARCHAR2 Optional

Line 80: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

76: -- End of comments
77:
78: PROCEDURE Create_Expression
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,

Line 81: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

77:
78: PROCEDURE Create_Expression
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,

Line 82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

78: PROCEDURE Create_Expression
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

Line 108: -- Default = FND_API.G_FALSE

104: -- Pre-reqs : None.
105: -- Parameters :
106: -- IN : p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 110: -- Default = FND_API.G_FALSE

106: -- IN : p_api_version IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_update_parent_also IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE

Line 112: -- Default = FND_API.G_VALID_LEVEL_FULL

108: -- Default = FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Optional
110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_update_parent_also IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_calc_sql_exp_id IN NUMBER Required
116: -- p_name IN VARCHAR2 Required

Line 114: -- Default = FND_API.G_FALSE

110: -- Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional
112: -- Default = FND_API.G_VALID_LEVEL_FULL
113: -- p_update_parent_also IN VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_calc_sql_exp_id IN NUMBER Required
116: -- p_name IN VARCHAR2 Required
117: -- p_description IN VARCHAR2 Optional
118: -- Default = null

Line 155: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

151: -- End of comments
152:
153: PROCEDURE Update_Expression
154: (p_api_version IN NUMBER ,
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,

Line 156: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

152:
153: PROCEDURE Update_Expression
154: (p_api_version IN NUMBER ,
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,

Line 157: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

153: PROCEDURE Update_Expression
154: (p_api_version IN NUMBER ,
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,

Line 158: p_update_parent_also IN VARCHAR2 := fnd_api.g_false ,

154: (p_api_version IN NUMBER ,
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,

Line 184: -- Default = FND_API.G_FALSE

180: -- Pre-reqs : None.
181: -- Parameters :
182: -- IN : p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional
184: -- Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional
186: -- Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 186: -- Default = FND_API.G_FALSE

182: -- IN : p_api_version IN NUMBER Required
183: -- p_init_msg_list IN VARCHAR2 Optional
184: -- Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional
186: -- Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_calc_sql_exp_id IN NUMBER
190: -- OUT : x_return_status OUT VARCHAR2(1)

Line 188: -- Default = FND_API.G_VALID_LEVEL_FULL

184: -- Default = FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Optional
186: -- Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional
188: -- Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_calc_sql_exp_id IN NUMBER
190: -- OUT : x_return_status OUT VARCHAR2(1)
191: -- x_msg_count OUT NUMBER
192: -- x_msg_data OUT VARCHAR2(2000)

Line 205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

201: -- End of comments
202:
203: PROCEDURE Delete_Expression
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 ,

Line 206: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

202:
203: PROCEDURE Delete_Expression
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 ,

Line 207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

203: PROCEDURE Delete_Expression
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 );

Line 221: -- Default = FND_API.G_FALSE

217: -- Pre-reqs : None.
218: -- Parameters :
219: -- IN : p_api_version IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional
225: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 223: -- Default = FND_API.G_FALSE

219: -- IN : p_api_version IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional
225: -- Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_calc_sql_exp_id IN NUMBER
227: -- OUT : x_parents_tbl OUT expression_tbl_type

Line 225: -- Default = FND_API.G_VALID_LEVEL_FULL

221: -- Default = FND_API.G_FALSE
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional
225: -- Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_calc_sql_exp_id IN NUMBER
227: -- OUT : x_parents_tbl OUT expression_tbl_type
228: -- x_return_status OUT VARCHAR2(1)
229: -- x_msg_count OUT NUMBER

Line 239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

235: --
236: -- End of comments
237: /*PROCEDURE Get_Parent_Expressions
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 ,

Line 240: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

236: -- End of comments
237: /*PROCEDURE Get_Parent_Expressions
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 ,

Line 241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

237: /*PROCEDURE Get_Parent_Expressions
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 ,

Line 308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

304: -- elements referenced directly or indirectly
305: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
306: PROCEDURE get_dependent_plan_elts
307: (p_api_version IN NUMBER ,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
311: p_node_type IN VARCHAR2,
312: p_node_id IN NUMBER,

Line 309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

305: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
306: PROCEDURE get_dependent_plan_elts
307: (p_api_version IN NUMBER ,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
311: p_node_type IN VARCHAR2,
312: p_node_id IN NUMBER,
313: x_plan_elt_id_tbl OUT NOCOPY num_tbl_type,

Line 310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

306: PROCEDURE get_dependent_plan_elts
307: (p_api_version IN NUMBER ,
308: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
309: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
310: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
311: p_node_type IN VARCHAR2,
312: p_node_id IN NUMBER,
313: x_plan_elt_id_tbl OUT NOCOPY num_tbl_type,
314: x_return_status OUT NOCOPY VARCHAR2 ,

Line 323: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

319: -- elements that reference it directly or indirectly
320: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
321: PROCEDURE get_parent_plan_elts
322: (p_api_version IN NUMBER ,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
326: p_node_type IN VARCHAR2,
327: p_node_id IN NUMBER,

Line 324: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

320: -- pass in a node type (formula=F, plan element=P, expression=E), and the ID
321: PROCEDURE get_parent_plan_elts
322: (p_api_version IN NUMBER ,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
326: p_node_type IN VARCHAR2,
327: p_node_id IN NUMBER,
328: x_plan_elt_id_tbl OUT NOCOPY num_tbl_type,

Line 325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

321: PROCEDURE get_parent_plan_elts
322: (p_api_version IN NUMBER ,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
325: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
326: p_node_type IN VARCHAR2,
327: p_node_id IN NUMBER,
328: x_plan_elt_id_tbl OUT NOCOPY num_tbl_type,
329: x_return_status OUT NOCOPY VARCHAR2 ,

Line 350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

346: p_org_id IN NUMBER);
347:
348: PROCEDURE duplicate_expression
349: (p_api_version IN NUMBER ,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
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,

Line 351: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

347:
348: PROCEDURE duplicate_expression
349: (p_api_version IN NUMBER ,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
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,

Line 352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

348: PROCEDURE duplicate_expression
349: (p_api_version IN NUMBER ,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
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,