The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy hxc_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'insert_dml';
insert into hxc_time_recipients
(time_recipient_id
,name
,application_id
,object_version_number
,application_retrieval_function
,application_update_process
,appl_validation_process
,application_period_function
,appl_dynamic_template_process
,extension_function1
,extension_function2
,creation_date
,created_by
,last_updated_by
,last_update_date
,last_update_login
)
Values
(p_rec.time_recipient_id
,p_rec.name
,p_rec.application_id
,p_rec.object_version_number
,p_rec.application_retrieval_function
,p_rec.application_update_process
,p_rec.appl_validation_process
,p_rec.application_period_function
,p_rec.appl_dynamic_template_process
,p_rec.extension_function1
,p_rec.extension_function2
,sysdate
,fnd_global.user_id
,fnd_global.user_id
,sysdate
,fnd_global.login_id
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy hxc_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
Cursor C_Sel1 is select hxc_time_recipients_s.nextval from sys.dual;
l_proc := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_effective_date in date
,p_rec in hxc_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'post_insert';
hxc_htr_rki.after_insert
(p_effective_date => p_effective_date
,p_time_recipient_id
=> p_rec.time_recipient_id
,p_name
=> p_rec.name
,p_application_id
=> p_rec.application_id
,p_object_version_number
=> p_rec.object_version_number
,p_appl_retrieval_function
=> p_rec.application_retrieval_function
,p_appl_update_process
=> p_rec.application_update_process
,p_appl_validation_process
=> p_rec.appl_validation_process
,p_appl_period_function
=> p_rec.application_period_function
,p_appl_dyn_template_process
=> p_rec.appl_dynamic_template_process
,p_extension_function1
=> p_rec.extension_function1
,p_extension_function2
=> p_rec.extension_function2
);
End post_insert;
hxc_htr_bus.insert_validate
(p_effective_date
,p_rec
);
hxc_htr_ins.pre_insert(p_rec);
hxc_htr_ins.insert_dml(p_rec);
hxc_htr_ins.post_insert
(p_effective_date
,p_rec
);
,p_appl_update_process in varchar2 default NULL
,p_appl_validation_process in varchar2 default NULL
,p_appl_period_function in varchar2 default NULL
,p_appl_dyn_template_process in varchar2 default NULL
,p_extension_function1 in varchar2 default NULL
,p_extension_function2 in varchar2 default NULL
,p_application_id in number default null
,p_time_recipient_id out nocopy number
,p_object_version_number out nocopy number
) is
--
l_rec hxc_htr_shd.g_rec_type;
,p_appl_update_process
,p_appl_validation_process
,p_appl_period_function
,p_appl_dyn_template_process
,p_extension_function1
,p_extension_function2
,p_application_id
,null
);