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_parameter_tag_tbl IN jtf_varchar2_Table_100,
636:
637: x_return_status OUT NOCOPY VARCHAR2,

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_parameter_tag_tbl IN jtf_varchar2_Table_100,
636:
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_count OUT NOCOPY NUMBER,

Line 1006: p_rule_value_tbl IN jtf_varchar2_Table_300,

1002: p_action IN VARCHAR2,
1003: p_all_email IN VARCHAR2,
1004: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1006: p_rule_value_tbl IN jtf_varchar2_Table_300,
1007: p_parameter1_tbl IN jtf_varchar2_Table_300,
1008: p_parameter2_tbl IN jtf_varchar2_Table_300,
1009: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1010: x_return_status OUT NOCOPY VARCHAR2,

Line 1007: p_parameter1_tbl IN jtf_varchar2_Table_300,

1003: p_all_email IN VARCHAR2,
1004: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1006: p_rule_value_tbl IN jtf_varchar2_Table_300,
1007: p_parameter1_tbl IN jtf_varchar2_Table_300,
1008: p_parameter2_tbl IN jtf_varchar2_Table_300,
1009: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,

Line 1008: p_parameter2_tbl IN jtf_varchar2_Table_300,

1004: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
1005: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
1006: p_rule_value_tbl IN jtf_varchar2_Table_300,
1007: p_parameter1_tbl IN jtf_varchar2_Table_300,
1008: p_parameter2_tbl IN jtf_varchar2_Table_300,
1009: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2 ) is