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.IEM_ROUTE_CLASS_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 37: p_class_ids_tbl IN jtf_varchar2_Table_100,

33: PROCEDURE delete_item_batch
34: (p_api_version_number IN NUMBER,
35: P_init_msg_list IN VARCHAR2 := null,
36: p_commit IN VARCHAR2 := null,
37: p_class_ids_tbl IN jtf_varchar2_Table_100,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2);
41:

Line 85: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,

81: p_class_description IN VARCHAR2:= null,
82: p_class_boolean_type_code IN VARCHAR2,
83: p_proc_name IN VARCHAR2 := null,
84:
85: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
86: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
87: p_rule_value_tbl IN jtf_varchar2_Table_300,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,

Line 86: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,

82: p_class_boolean_type_code IN VARCHAR2,
83: p_proc_name IN VARCHAR2 := null,
84:
85: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
86: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
87: p_rule_value_tbl IN jtf_varchar2_Table_300,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2 ) ;

Line 197: -- p_update_rule_ids_tbl IN Optional jtf_varchar2_Table_100,

193: -- p_class_id IN Optional NUMBER:=FND_API.G_MISS_NUM,
194: -- p_name IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
195: -- p_ruling_chain IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
196: -- p_description IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
197: -- p_update_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
198: -- p_update_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
199: -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
200: -- p_update_rule_values_tbl IN Optional jtf_varchar2_Table_300,
201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,

Line 198: -- p_update_rule_keys_tbl IN Optional jtf_varchar2_Table_100,

194: -- p_name IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
195: -- p_ruling_chain IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
196: -- p_description IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
197: -- p_update_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
198: -- p_update_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
199: -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
200: -- p_update_rule_values_tbl IN Optional jtf_varchar2_Table_300,
201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
202:

Line 199: -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,

195: -- p_ruling_chain IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
196: -- p_description IN Optional VARCHAR2:=FND_API.G_MISS_CHAR,
197: -- p_update_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
198: -- p_update_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
199: -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
200: -- p_update_rule_values_tbl IN Optional jtf_varchar2_Table_300,
201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
202:
203: -- p_new_rule_operators_tbl IN Optional jtf_varchar2_Table_100,

Line 201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,

197: -- p_update_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
198: -- p_update_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
199: -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
200: -- p_update_rule_values_tbl IN Optional jtf_varchar2_Table_300,
201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
202:
203: -- p_new_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
204: -- p_new_rule_values_tbl IN Optional jtf_varchar2_Table_300,
205: -- p_remove_rule_ids_tbl IN Optional jtf_varchar2_Table_100,

Line 203: -- p_new_rule_operators_tbl IN Optional jtf_varchar2_Table_100,

199: -- p_update_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
200: -- p_update_rule_values_tbl IN Optional jtf_varchar2_Table_300,
201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
202:
203: -- p_new_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
204: -- p_new_rule_values_tbl IN Optional jtf_varchar2_Table_300,
205: -- p_remove_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
206:
207: -- OUT

Line 205: -- p_remove_rule_ids_tbl IN Optional jtf_varchar2_Table_100,

201: -- p_new_rule_keys_tbl IN Optional jtf_varchar2_Table_100,
202:
203: -- p_new_rule_operators_tbl IN Optional jtf_varchar2_Table_100,
204: -- p_new_rule_values_tbl IN Optional jtf_varchar2_Table_300,
205: -- p_remove_rule_ids_tbl IN Optional jtf_varchar2_Table_100,
206:
207: -- OUT
208: -- x_return_status OUT VARCHAR2
209: -- x_msg_count OUT NUMBER

Line 227: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

223: p_ruling_chain IN VARCHAR2:= null,
224: p_description IN VARCHAR2:= null,
225: p_procedure_name IN VARCHAR2:= null,
226: --below is the data for update
227: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
228: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
229: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
230: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
231: --below is the data for insert

Line 228: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

224: p_description IN VARCHAR2:= null,
225: p_procedure_name IN VARCHAR2:= null,
226: --below is the data for update
227: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
228: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
229: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
230: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
231: --below is the data for insert
232: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

Line 229: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

225: p_procedure_name IN VARCHAR2:= null,
226: --below is the data for update
227: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
228: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
229: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
230: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
231: --below is the data for insert
232: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
233: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

Line 232: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

228: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
229: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
230: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
231: --below is the data for insert
232: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
233: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
234: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
235: --below is the data to be removed
236: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

Line 233: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

229: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
230: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
231: --below is the data for insert
232: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
233: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
234: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
235: --below is the data to be removed
236: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
237: x_return_status OUT NOCOPY VARCHAR2,

Line 236: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

232: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
233: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
234: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
235: --below is the data to be removed
236: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2 );
240:

Line 423: -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required

419: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
420: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
421:
422: -- p_email_account_id IN NUMBER Required
423: -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required
424: -- p_upd_enable_flag_tbl IN jtf_varchar2_Table_100 Required
425: -- p_delete_class_ids_tbl IN jtf_varchar2_Table_100 Required
426: -- OUT
427: -- x_return_status OUT VARCHAR2

Line 424: -- p_upd_enable_flag_tbl IN jtf_varchar2_Table_100 Required

420: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
421:
422: -- p_email_account_id IN NUMBER Required
423: -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required
424: -- p_upd_enable_flag_tbl IN jtf_varchar2_Table_100 Required
425: -- p_delete_class_ids_tbl IN jtf_varchar2_Table_100 Required
426: -- OUT
427: -- x_return_status OUT VARCHAR2
428: -- x_msg_count OUT NUMBER

Line 425: -- p_delete_class_ids_tbl IN jtf_varchar2_Table_100 Required

421:
422: -- p_email_account_id IN NUMBER Required
423: -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required
424: -- p_upd_enable_flag_tbl IN jtf_varchar2_Table_100 Required
425: -- p_delete_class_ids_tbl IN jtf_varchar2_Table_100 Required
426: -- OUT
427: -- x_return_status OUT VARCHAR2
428: -- x_msg_count OUT NUMBER
429: -- x_msg_data OUT VARCHAR2

Line 442: p_class_ids_tbl IN jtf_varchar2_Table_100,

438: p_init_msg_list IN VARCHAR2 := null,
439: p_commit IN VARCHAR2 := null,
440:
441: p_email_account_id IN NUMBER,
442: p_class_ids_tbl IN jtf_varchar2_Table_100,
443: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
444: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
445: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
446: x_return_status OUT NOCOPY VARCHAR2,

Line 443: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

439: p_commit IN VARCHAR2 := null,
440:
441: p_email_account_id IN NUMBER,
442: p_class_ids_tbl IN jtf_varchar2_Table_100,
443: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
444: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
445: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,

Line 444: --p_upd_priority_tbl IN jtf_varchar2_Table_100,

440:
441: p_email_account_id IN NUMBER,
442: p_class_ids_tbl IN jtf_varchar2_Table_100,
443: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
444: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
445: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2

Line 445: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,

441: p_email_account_id IN NUMBER,
442: p_class_ids_tbl IN jtf_varchar2_Table_100,
443: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
444: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
445: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2
449:

Line 503: -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required

499: -- IN
500: -- p_api_version_number IN NUMBER Required
501: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
502: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
503: -- p_class_ids_tbl IN jtf_varchar2_Table_100 Required
504: -- p_account_id IN NUMBER Required
505: -- OUT
506: -- x_return_status OUT VARCHAR2
507: -- x_msg_count OUT NUMBER

Line 521: p_class_ids_tbl IN jtf_varchar2_Table_100,

517: (p_api_version_number IN NUMBER,
518: P_init_msg_list IN VARCHAR2 := NULL,
519:
520: p_commit IN VARCHAR2 := NULL,
521: p_class_ids_tbl IN jtf_varchar2_Table_100,
522: p_account_id IN NUMBER,
523: x_return_status OUT NOCOPY VARCHAR2,
524: x_msg_count OUT NOCOPY NUMBER,
525: x_msg_data OUT NOCOPY VARCHAR2);