DBA Data[Home] [Help]

APPS.IEM_ROUTE_CLASS_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 123: p_class_ids_tbl IN jtf_varchar2_Table_100,

119: PROCEDURE delete_item_batch
120: (p_api_version_number IN NUMBER,
121: P_init_msg_list IN VARCHAR2 := null,
122: p_commit IN VARCHAR2 := null,
123: p_class_ids_tbl IN jtf_varchar2_Table_100,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2)
127: IS

Line 321: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,

317: p_class_description IN VARCHAR2:= null,
318: p_class_boolean_type_code IN VARCHAR2,
319: p_proc_name IN VARCHAR2 := null,
320:
321: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
322: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
323: p_rule_value_tbl IN jtf_varchar2_Table_300,
324:
325: x_return_status OUT NOCOPY VARCHAR2,

Line 322: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,

318: p_class_boolean_type_code IN VARCHAR2,
319: p_proc_name IN VARCHAR2 := null,
320:
321: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100,
322: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
323: p_rule_value_tbl IN jtf_varchar2_Table_300,
324:
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,

Line 955: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

951: p_ruling_chain IN VARCHAR2:= null,
952: p_description IN VARCHAR2:= null,
953: p_procedure_name IN VARCHAR2:= null,
954: --below is the data for update
955: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
956: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
957: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
958: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
959: --below is the data for insert

Line 956: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

952: p_description IN VARCHAR2:= null,
953: p_procedure_name IN VARCHAR2:= null,
954: --below is the data for update
955: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
956: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
957: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
958: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
959: --below is the data for insert
960: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

Line 957: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

953: p_procedure_name IN VARCHAR2:= null,
954: --below is the data for update
955: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
956: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
957: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
958: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
959: --below is the data for insert
960: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
961: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

Line 960: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,

956: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
957: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
958: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
959: --below is the data for insert
960: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
961: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
962: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
963: --below is the data to be removed
964: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

Line 961: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,

957: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
958: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
959: --below is the data for insert
960: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
961: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
962: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
963: --below is the data to be removed
964: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
965: x_return_status OUT NOCOPY VARCHAR2,

Line 964: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

960: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
961: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
962: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
963: --below is the data to be removed
964: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
965: x_return_status OUT NOCOPY VARCHAR2,
966: x_msg_count OUT NOCOPY NUMBER,
967: x_msg_data OUT NOCOPY VARCHAR2 )is
968:

Line 1998: p_class_ids_tbl IN jtf_varchar2_Table_100,

1994: p_init_msg_list IN VARCHAR2 := null,
1995: p_commit IN VARCHAR2 := null,
1996:
1997: p_email_account_id IN NUMBER,
1998: p_class_ids_tbl IN jtf_varchar2_Table_100,
1999: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2000: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2001:
2002: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,

Line 1999: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

1995: p_commit IN VARCHAR2 := null,
1996:
1997: p_email_account_id IN NUMBER,
1998: p_class_ids_tbl IN jtf_varchar2_Table_100,
1999: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2000: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2001:
2002: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
2003:

Line 2000: --p_upd_priority_tbl IN jtf_varchar2_Table_100,

1996:
1997: p_email_account_id IN NUMBER,
1998: p_class_ids_tbl IN jtf_varchar2_Table_100,
1999: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2000: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2001:
2002: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
2003:
2004: x_return_status OUT NOCOPY VARCHAR2,

Line 2002: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,

1998: p_class_ids_tbl IN jtf_varchar2_Table_100,
1999: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
2000: --p_upd_priority_tbl IN jtf_varchar2_Table_100,
2001:
2002: p_delete_class_ids_tbl IN jtf_varchar2_Table_100,
2003:
2004: x_return_status OUT NOCOPY VARCHAR2,
2005: x_msg_count OUT NOCOPY NUMBER,
2006: x_msg_data OUT NOCOPY VARCHAR2

Line 2328: p_class_ids_tbl IN jtf_varchar2_Table_100,

2324: (p_api_version_number IN NUMBER,
2325:
2326: P_init_msg_list IN VARCHAR2 := null,
2327: p_commit IN VARCHAR2 := null,
2328: p_class_ids_tbl IN jtf_varchar2_Table_100,
2329:
2330: p_account_id IN NUMBER,
2331: x_return_status OUT NOCOPY VARCHAR2,
2332: x_msg_count OUT NOCOPY NUMBER,