DBA Data[Home] [Help]

APPS.IEM_EMAILPROC_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,

620: --below is the data for update
621: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
622: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
623: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert
626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
628: p_new_rule_values_tbl IN jtf_varchar2_Table_300,

Line 628: p_new_rule_values_tbl IN jtf_varchar2_Table_300,

624: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
625: --below is the data for insert
626: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
627: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
628: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
629: --below is the data to be removed
630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
631: --below is the action and action parameter to be updated
632: p_action IN VARCHAR2 := null,

Line 633: p_parameter1_tbl IN jtf_varchar2_Table_300,

629: --below is the data to be removed
630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
631: --below is the action and action parameter to be updated
632: p_action IN VARCHAR2 := null,
633: p_parameter1_tbl IN jtf_varchar2_Table_300,
634: p_parameter2_tbl IN jtf_varchar2_Table_300,
635: p_parameter3_tbl IN jtf_varchar2_Table_300,
636: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
637:

Line 634: p_parameter2_tbl IN jtf_varchar2_Table_300,

630: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
631: --below is the action and action parameter to be updated
632: p_action IN VARCHAR2 := null,
633: p_parameter1_tbl IN jtf_varchar2_Table_300,
634: p_parameter2_tbl IN jtf_varchar2_Table_300,
635: p_parameter3_tbl IN jtf_varchar2_Table_300,
636: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
637:
638: x_return_status OUT NOCOPY VARCHAR2,

Line 635: p_parameter3_tbl IN jtf_varchar2_Table_300,

631: --below is the action and action parameter to be updated
632: p_action IN VARCHAR2 := null,
633: p_parameter1_tbl IN jtf_varchar2_Table_300,
634: p_parameter2_tbl IN jtf_varchar2_Table_300,
635: p_parameter3_tbl IN jtf_varchar2_Table_300,
636: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
637:
638: x_return_status OUT NOCOPY VARCHAR2,
639: x_msg_count OUT NOCOPY NUMBER,

Line 1023: p_rule_value_tbl IN jtf_varchar2_Table_300,

1019: p_action IN VARCHAR2,
1020: p_all_email IN VARCHAR2,
1021: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1022: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1023: p_rule_value_tbl IN jtf_varchar2_Table_300,
1024: p_parameter1_tbl IN jtf_varchar2_Table_300,
1025: p_parameter2_tbl IN jtf_varchar2_Table_300,
1026: p_parameter3_tbl IN jtf_varchar2_Table_300,
1027: p_parameter_tag_tbl IN jtf_varchar2_Table_100,

Line 1024: p_parameter1_tbl IN jtf_varchar2_Table_300,

1020: p_all_email IN VARCHAR2,
1021: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1022: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1023: p_rule_value_tbl IN jtf_varchar2_Table_300,
1024: p_parameter1_tbl IN jtf_varchar2_Table_300,
1025: p_parameter2_tbl IN jtf_varchar2_Table_300,
1026: p_parameter3_tbl IN jtf_varchar2_Table_300,
1027: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1028: x_return_status OUT NOCOPY VARCHAR2,

Line 1025: p_parameter2_tbl IN jtf_varchar2_Table_300,

1021: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1022: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1023: p_rule_value_tbl IN jtf_varchar2_Table_300,
1024: p_parameter1_tbl IN jtf_varchar2_Table_300,
1025: p_parameter2_tbl IN jtf_varchar2_Table_300,
1026: p_parameter3_tbl IN jtf_varchar2_Table_300,
1027: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1028: x_return_status OUT NOCOPY VARCHAR2,
1029: x_msg_count OUT NOCOPY NUMBER,

Line 1026: p_parameter3_tbl IN jtf_varchar2_Table_300,

1022: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1023: p_rule_value_tbl IN jtf_varchar2_Table_300,
1024: p_parameter1_tbl IN jtf_varchar2_Table_300,
1025: p_parameter2_tbl IN jtf_varchar2_Table_300,
1026: p_parameter3_tbl IN jtf_varchar2_Table_300,
1027: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1028: x_return_status OUT NOCOPY VARCHAR2,
1029: x_msg_count OUT NOCOPY NUMBER,
1030: x_msg_data OUT NOCOPY VARCHAR2 ) is