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_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 31: -- p_route_ids_tbl IN jtf_varchar2_Table_100 Required

27: -- p_api_version_number IN NUMBER Required
28:
29: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
31: -- p_route_ids_tbl IN jtf_varchar2_Table_100 Required
32: -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
33:
34: -- OUT
35: -- x_return_status OUT VARCHAR2

Line 51: p_route_ids_tbl IN jtf_varchar2_Table_100,

47: PROCEDURE delete_item_batch
48: (p_api_version_number IN NUMBER,
49: P_init_msg_list IN VARCHAR2 := null,
50: p_commit IN VARCHAR2 := null,
51: p_route_ids_tbl IN jtf_varchar2_Table_100,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2);
55:

Line 115: -- p_route_boolean_type_code IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100

111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_route_name IN VARCHAR2 Required
114: -- p_route_description IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
115: -- p_route_boolean_type_code IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100
116: -- Post 11.5.7 MP-O For static route: AND, OR
117: -- For dynamic route: DYNAMIC
118:
119: -- p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100

Line 119: -- p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100

115: -- p_route_boolean_type_code IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100
116: -- Post 11.5.7 MP-O For static route: AND, OR
117: -- For dynamic route: DYNAMIC
118:
119: -- p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100 Optional Default = jtf_varchar2_Table_100
120:
121: -- p_rule_value_tbl IN jtf_varchar2_Table_300 Optional Default = jtf_varchar2_Table_300
122:
123: -- OUT

Line 144: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,

140: p_route_description IN VARCHAR2:= null,
141: p_route_boolean_type_code IN VARCHAR2,
142: p_proc_name IN VARCHAR2 := null,
143: p_all_email IN VARCHAR2:= null,
144: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
145: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
146: p_rule_value_tbl IN jtf_varchar2_Table_300,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,

Line 145: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,

141: p_route_boolean_type_code IN VARCHAR2,
142: p_proc_name IN VARCHAR2 := null,
143: p_all_email IN VARCHAR2:= null,
144: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
145: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
146: p_rule_value_tbl IN jtf_varchar2_Table_300,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2 );

Line 316: -- p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

312: -- p_route_id IN NUMBER:=FND_API.G_MISS_NUM,
313: -- p_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
314: -- p_ruling_chain IN VARCHAR2:=FND_API.G_MISS_CHAR,
315: -- p_description IN VARCHAR2:=FND_API.G_MISS_CHAR,
316: -- p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
317: -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
318: -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
319: -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,
320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

Line 317: -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

313: -- p_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
314: -- p_ruling_chain IN VARCHAR2:=FND_API.G_MISS_CHAR,
315: -- p_description IN VARCHAR2:=FND_API.G_MISS_CHAR,
316: -- p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
317: -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
318: -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
319: -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,
320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
321: -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

Line 318: -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

314: -- p_ruling_chain IN VARCHAR2:=FND_API.G_MISS_CHAR,
315: -- p_description IN VARCHAR2:=FND_API.G_MISS_CHAR,
316: -- p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
317: -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
318: -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
319: -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,
320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
321: -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
322: -- p_new_rule_values_tbl IN jtf_varchar2_Table_300,

Line 320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

316: -- p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
317: -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
318: -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
319: -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,
320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
321: -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
322: -- p_new_rule_values_tbl IN jtf_varchar2_Table_300,
323:
324: -- p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

Line 321: -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

317: -- p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
318: -- p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
319: -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,
320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
321: -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
322: -- p_new_rule_values_tbl IN jtf_varchar2_Table_300,
323:
324: -- p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
325:

Line 324: -- p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

320: -- p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
321: -- p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
322: -- p_new_rule_values_tbl IN jtf_varchar2_Table_300,
323:
324: -- p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
325:
326:
327: -- OUT
328: -- x_return_status OUT VARCHAR2

Line 348: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

344: p_description IN VARCHAR2:= null,
345: p_procedure_name IN VARCHAR2:= null,
346: p_all_emails IN VARCHAR2:= null,
347: --below is the data for update
348: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
349: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
350: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
351:
352: p_update_rule_values_tbl IN jtf_varchar2_Table_300,

Line 349: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

345: p_procedure_name IN VARCHAR2:= null,
346: p_all_emails IN VARCHAR2:= null,
347: --below is the data for update
348: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
349: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
350: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
351:
352: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
353: -- below is the data for insert

Line 350: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

346: p_all_emails IN VARCHAR2:= null,
347: --below is the data for update
348: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
349: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
350: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
351:
352: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
353: -- below is the data for insert
354: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

Line 354: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

350: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
351:
352: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
353: -- below is the data for insert
354: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
355:
356: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
357: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
358: --below is the data to be removed

Line 356: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

352: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
353: -- below is the data for insert
354: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
355:
356: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
357: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
358: --below is the data to be removed
359: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
360:

Line 359: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

355:
356: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
357: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
358: --below is the data to be removed
359: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
360:
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2 );

Line 571: -- p_route_ids_tbl IN jtf_varchar2_Table_100,

567: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
568:
569: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
570:
571: -- p_route_ids_tbl IN jtf_varchar2_Table_100,
572: -- OUT
573: -- x_return_status OUT VARCHAR2
574: -- x_msg_count OUT NUMBER
575: -- x_msg_data OUT VARCHAR2

Line 586: p_route_ids_tbl IN jtf_varchar2_Table_100,

582: PROCEDURE delete_acct_route_batch
583: (p_api_version_number IN NUMBER,
584: P_init_msg_list IN VARCHAR2 := null,
585: p_commit IN VARCHAR2 := null,
586: p_route_ids_tbl IN jtf_varchar2_Table_100,
587: p_account_id IN NUMBER,
588: x_return_status OUT NOCOPY VARCHAR2,
589: x_msg_count OUT NOCOPY NUMBER,
590: x_msg_data OUT NOCOPY VARCHAR2);

Line 633: p_route_ids_tbl IN jtf_varchar2_Table_100,

629: (p_api_version_number IN NUMBER,
630: p_init_msg_list IN VARCHAR2 := null,
631: p_commit IN VARCHAR2 := null,
632: p_email_account_id IN NUMBER,
633: p_route_ids_tbl IN jtf_varchar2_Table_100,
634: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
635:
636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

Line 634: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,

630: p_init_msg_list IN VARCHAR2 := null,
631: p_commit IN VARCHAR2 := null,
632: p_email_account_id IN NUMBER,
633: p_route_ids_tbl IN jtf_varchar2_Table_100,
634: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
635:
636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
638: --p_upd_priority_tbl IN jtf_varchar2_Table_100,

Line 636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,

632: p_email_account_id IN NUMBER,
633: p_route_ids_tbl IN jtf_varchar2_Table_100,
634: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
635:
636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
638: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
639:
640: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,

Line 637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

633: p_route_ids_tbl IN jtf_varchar2_Table_100,
634: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
635:
636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
638: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
639:
640: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
641:

Line 638: --p_upd_priority_tbl IN jtf_varchar2_Table_100,

634: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
635:
636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
638: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
639:
640: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
641:
642: x_return_status OUT NOCOPY VARCHAR2,

Line 640: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,

636: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
637: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
638: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
639:
640: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
641:
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_msg_count OUT NOCOPY NUMBER,
644: x_msg_data OUT NOCOPY VARCHAR2