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 109: p_route_ids_tbl IN jtf_varchar2_Table_100,

105: PROCEDURE delete_item_batch
106: (p_api_version_number IN NUMBER,
107: P_init_msg_list IN VARCHAR2 := null,
108: p_commit IN VARCHAR2 := null,
109: p_route_ids_tbl IN jtf_varchar2_Table_100,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2)
113: IS

Line 237: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,

233: p_route_description IN VARCHAR2:= null,
234: p_route_boolean_type_code IN VARCHAR2,
235: p_proc_name IN VARCHAR2 := null,
236: p_all_email IN VARCHAR2 := null,
237: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
238: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
239: p_rule_value_tbl IN jtf_varchar2_Table_300,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,

Line 238: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,

234: p_route_boolean_type_code IN VARCHAR2,
235: p_proc_name IN VARCHAR2 := null,
236: p_all_email IN VARCHAR2 := null,
237: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
238: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
239: p_rule_value_tbl IN jtf_varchar2_Table_300,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2 ) is

Line 1051: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

1047: p_description IN VARCHAR2:= null,
1048: p_procedure_name IN VARCHAR2:= null,
1049: p_all_emails IN VARCHAR2:= null,
1050: --below is the data for update
1051: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
1052: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
1053: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
1054: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
1055: --below is the data for insert

Line 1052: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

1048: p_procedure_name IN VARCHAR2:= null,
1049: p_all_emails IN VARCHAR2:= null,
1050: --below is the data for update
1051: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
1052: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
1053: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
1054: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
1055: --below is the data for insert
1056: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

Line 1053: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

1049: p_all_emails IN VARCHAR2:= null,
1050: --below is the data for update
1051: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
1052: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
1053: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
1054: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
1055: --below is the data for insert
1056: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
1057: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

Line 1056: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

1052: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
1053: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
1054: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
1055: --below is the data for insert
1056: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
1057: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
1058: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
1059: --below is the data to be removed
1060: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

Line 1057: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

1053: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
1054: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
1055: --below is the data for insert
1056: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
1057: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
1058: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
1059: --below is the data to be removed
1060: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
1061: x_return_status OUT NOCOPY VARCHAR2,

Line 1060: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

1056: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
1057: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
1058: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
1059: --below is the data to be removed
1060: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
1061: x_return_status OUT NOCOPY VARCHAR2,
1062: x_msg_count OUT NOCOPY NUMBER,
1063: x_msg_data OUT NOCOPY VARCHAR2 )is
1064:

Line 1955: p_route_ids_tbl IN jtf_varchar2_Table_100,

1951: PROCEDURE delete_acct_route_batch
1952: (p_api_version_number IN NUMBER,
1953: P_init_msg_list IN VARCHAR2 := null,
1954: p_commit IN VARCHAR2 := null,
1955: p_route_ids_tbl IN jtf_varchar2_Table_100,
1956: p_account_id IN NUMBER,
1957: x_return_status OUT NOCOPY VARCHAR2,
1958: x_msg_count OUT NOCOPY NUMBER,
1959: x_msg_data OUT NOCOPY VARCHAR2)

Line 2066: p_route_ids_tbl IN jtf_varchar2_Table_100,

2062: (p_api_version_number IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 := null,
2064: p_commit IN VARCHAR2 := null,
2065: p_email_account_id IN NUMBER,
2066: p_route_ids_tbl IN jtf_varchar2_Table_100,
2067: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
2068:
2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

Line 2067: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,

2063: p_init_msg_list IN VARCHAR2 := null,
2064: p_commit IN VARCHAR2 := null,
2065: p_email_account_id IN NUMBER,
2066: p_route_ids_tbl IN jtf_varchar2_Table_100,
2067: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
2068:
2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2071: --p_upd_priority_tbl IN jtf_varchar2_Table_100,

Line 2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,

2065: p_email_account_id IN NUMBER,
2066: p_route_ids_tbl IN jtf_varchar2_Table_100,
2067: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
2068:
2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2071: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2072:
2073: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,

Line 2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

2066: p_route_ids_tbl IN jtf_varchar2_Table_100,
2067: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
2068:
2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2071: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2072:
2073: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
2074:

Line 2071: --p_upd_priority_tbl IN jtf_varchar2_Table_100,

2067: p_upd_dest_ids_tbl IN jtf_varchar2_Table_100,
2068:
2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2071: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2072:
2073: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
2074:
2075: x_return_status OUT NOCOPY VARCHAR2,

Line 2073: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,

2069: p_upd_default_ids_tbl IN jtf_varchar2_Table_100,
2070: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2071: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2072:
2073: p_delete_route_ids_tbl IN jtf_varchar2_Table_100,
2074:
2075: x_return_status OUT NOCOPY VARCHAR2,
2076: x_msg_count OUT NOCOPY NUMBER,
2077: x_msg_data OUT NOCOPY VARCHAR2