DBA Data[Home] [Help]

APPS.IEM_EMAILPROC_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 122: p_update_rule_values_tbl IN jtf_varchar2_Table_300,

118: --below is the data for update
119: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,
120: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,
121: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,
122: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
123: --below is the data for insert
124: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
125: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
126: p_new_rule_values_tbl IN jtf_varchar2_Table_300,

Line 126: p_new_rule_values_tbl IN jtf_varchar2_Table_300,

122: p_update_rule_values_tbl IN jtf_varchar2_Table_300,
123: --below is the data for insert
124: p_new_rule_keys_tbl IN jtf_varchar2_Table_100,
125: p_new_rule_operators_tbl IN jtf_varchar2_Table_100,
126: p_new_rule_values_tbl IN jtf_varchar2_Table_300,
127: --below is the data to be removed
128: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
129: --below is the action and action parameter to be updated
130: p_action IN VARCHAR2 :=null,

Line 131: p_parameter1_tbl IN jtf_varchar2_Table_300,

127: --below is the data to be removed
128: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
129: --below is the action and action parameter to be updated
130: p_action IN VARCHAR2 :=null,
131: p_parameter1_tbl IN jtf_varchar2_Table_300,
132: p_parameter2_tbl IN jtf_varchar2_Table_300,
133: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
134:
135: x_return_status OUT NOCOPY VARCHAR2,

Line 132: p_parameter2_tbl IN jtf_varchar2_Table_300,

128: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,
129: --below is the action and action parameter to be updated
130: p_action IN VARCHAR2 :=null,
131: p_parameter1_tbl IN jtf_varchar2_Table_300,
132: p_parameter2_tbl IN jtf_varchar2_Table_300,
133: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
134:
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,

Line 160: p_rule_value_tbl IN jtf_varchar2_Table_300,

156: p_action IN VARCHAR2,
157: p_all_email IN VARCHAR2,
158: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
159: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
160: p_rule_value_tbl IN jtf_varchar2_Table_300,
161: p_parameter1_tbl IN jtf_varchar2_Table_300 ,
162: p_parameter2_tbl IN jtf_varchar2_Table_300 ,
163: p_parameter_tag_tbl IN jtf_varchar2_Table_100 ,
164: x_return_status OUT NOCOPY VARCHAR2,

Line 161: p_parameter1_tbl IN jtf_varchar2_Table_300 ,

157: p_all_email IN VARCHAR2,
158: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
159: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
160: p_rule_value_tbl IN jtf_varchar2_Table_300,
161: p_parameter1_tbl IN jtf_varchar2_Table_300 ,
162: p_parameter2_tbl IN jtf_varchar2_Table_300 ,
163: p_parameter_tag_tbl IN jtf_varchar2_Table_100 ,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,

Line 162: p_parameter2_tbl IN jtf_varchar2_Table_300 ,

158: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
159: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
160: p_rule_value_tbl IN jtf_varchar2_Table_300,
161: p_parameter1_tbl IN jtf_varchar2_Table_300 ,
162: p_parameter2_tbl IN jtf_varchar2_Table_300 ,
163: p_parameter_tag_tbl IN jtf_varchar2_Table_100 ,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2 );