APPS.IEM_ROUTE_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 121: -- p_rule_value_tbl IN jtf_varchar2_Table_300 Optional Default = jtf_varchar2_Table_300

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
124: -- x_return_status OUT VARCHAR2
125: -- x_msg_count OUT NUMBER

Line 146: p_rule_value_tbl IN jtf_varchar2_Table_300,

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 );
150:

Line 319: -- p_update_rule_values_tbl IN jtf_varchar2_Table_300,

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,
323:

Line 322: -- p_new_rule_values_tbl IN jtf_varchar2_Table_300,

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:
326:

Line 352: p_update_rule_values_tbl IN jtf_varchar2_Table_300,

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,
355:
356: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

Line 357: p_new_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:
361: x_return_status OUT NOCOPY VARCHAR2,