DBA Data[Home] [Help]

APPS.IEM_EMAILPROC_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 119: p_update_rule_ids_tbl IN jtf_varchar2_Table_100,

115: p_all_email IN VARCHAR2:= null,
116: p_rule_type IN VARCHAR2:= null,
117:
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

Line 120: p_update_rule_keys_tbl IN jtf_varchar2_Table_100,

116: p_rule_type IN VARCHAR2:= null,
117:
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,

Line 121: p_update_rule_operators_tbl IN jtf_varchar2_Table_100,

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

Line 124: p_new_rule_keys_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,
127: --below is the data to be removed
128: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

Line 125: p_new_rule_operators_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,
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

Line 128: p_remove_rule_ids_tbl IN jtf_varchar2_Table_100,

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,
131: p_parameter1_tbl IN jtf_varchar2_Table_300,
132: p_parameter2_tbl IN jtf_varchar2_Table_300,

Line 134: p_parameter_tag_tbl IN jtf_varchar2_Table_100,

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_parameter3_tbl IN jtf_varchar2_Table_300,
134: p_parameter_tag_tbl IN jtf_varchar2_Table_100,
135:
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2 );

Line 159: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,

155: p_route_boolean_type_code IN VARCHAR2,
156: p_rule_type IN VARCHAR2,
157: p_action IN VARCHAR2,
158: p_all_email IN VARCHAR2,
159: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
160: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
161: p_rule_value_tbl IN jtf_varchar2_Table_300,
162: p_parameter1_tbl IN jtf_varchar2_Table_300 ,
163: p_parameter2_tbl IN jtf_varchar2_Table_300 ,

Line 160: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,

156: p_rule_type IN VARCHAR2,
157: p_action IN VARCHAR2,
158: p_all_email IN VARCHAR2,
159: p_rule_key_typecode_tbl IN jtf_varchar2_Table_100 ,
160: p_rule_operator_typecode_tbl IN jtf_varchar2_Table_100,
161: p_rule_value_tbl IN jtf_varchar2_Table_300,
162: p_parameter1_tbl IN jtf_varchar2_Table_300 ,
163: p_parameter2_tbl IN jtf_varchar2_Table_300 ,
164: p_parameter3_tbl IN jtf_varchar2_Table_300 ,

Line 165: p_parameter_tag_tbl IN jtf_varchar2_Table_100 ,

161: p_rule_value_tbl IN jtf_varchar2_Table_300,
162: p_parameter1_tbl IN jtf_varchar2_Table_300 ,
163: p_parameter2_tbl IN jtf_varchar2_Table_300 ,
164: p_parameter3_tbl IN jtf_varchar2_Table_300 ,
165: p_parameter_tag_tbl IN jtf_varchar2_Table_100 ,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2 );
169:

Line 207: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,

203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := null,
205: p_commit IN VARCHAR2 := null,
206: p_email_account_id IN NUMBER,
207: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
208: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
209: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,
210: p_rule_type IN varchar2,
211: x_return_status OUT NOCOPY VARCHAR2,

Line 208: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,

204: p_init_msg_list IN VARCHAR2 := null,
205: p_commit IN VARCHAR2 := null,
206: p_email_account_id IN NUMBER,
207: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
208: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
209: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,
210: p_rule_type IN varchar2,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,

Line 209: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,

205: p_commit IN VARCHAR2 := null,
206: p_email_account_id IN NUMBER,
207: p_emailproc_ids_tbl IN jtf_varchar2_Table_100,
208: p_upd_enable_flag_tbl IN jtf_varchar2_Table_100,
209: p_delete_emailproc_ids_tbl IN jtf_varchar2_Table_100,
210: p_rule_type IN varchar2,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2