The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT product_short_name
FROM hr_owner_definitions
WHERE session_id = hr_startup_data_api_support.g_session_id;
INSERT INTO hr_application_ownerships
(key_name
,key_value
,product_name
)
VALUES
(p_pk_column
,fnd_number.number_to_canonical(p_pk_value)
,c1.product_short_name
);
Procedure insert_dml
(p_rec in out nocopy pqh_crd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into pqh_criteria_rate_defn
(criteria_rate_defn_id
,short_name
,uom
,currency_code
,reference_period_cd
,define_max_rate_flag
,define_min_rate_flag
,define_mid_rate_flag
,define_std_rate_flag
,rate_calc_cd
,rate_calc_rule
,preferential_rate_cd
,preferential_rate_rule
,rounding_cd
,rounding_rule
,business_group_id
,legislation_code
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,object_version_number
)
Values
(p_rec.criteria_rate_defn_id
,p_rec.short_name
,p_rec.uom
,p_rec.currency_code
,p_rec.reference_period_cd
,p_rec.define_max_rate_flag
,p_rec.define_min_rate_flag
,p_rec.define_mid_rate_flag
,p_rec.define_std_rate_flag
,p_rec.rate_calc_cd
,p_rec.rate_calc_rule
,p_rec.preferential_rate_cd
,p_rec.preferential_rate_rule
,p_rec.rounding_cd
,p_rec.rounding_rule
,p_rec.business_group_id
,p_rec.legislation_code
,p_rec.attribute_category
,p_rec.attribute1
,p_rec.attribute2
,p_rec.attribute3
,p_rec.attribute4
,p_rec.attribute5
,p_rec.attribute6
,p_rec.attribute7
,p_rec.attribute8
,p_rec.attribute9
,p_rec.attribute10
,p_rec.attribute11
,p_rec.attribute12
,p_rec.attribute13
,p_rec.attribute14
,p_rec.attribute15
,p_rec.attribute16
,p_rec.attribute17
,p_rec.attribute18
,p_rec.attribute19
,p_rec.attribute20
,p_rec.attribute21
,p_rec.attribute22
,p_rec.attribute23
,p_rec.attribute24
,p_rec.attribute25
,p_rec.attribute26
,p_rec.attribute27
,p_rec.attribute28
,p_rec.attribute29
,p_rec.attribute30
,p_rec.object_version_number
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy pqh_crd_shd.g_rec_type
) is
--
Cursor C_Sel1 is select pqh_criteria_rate_defn_s.nextval from sys.dual;
Select null
from pqh_criteria_rate_defn
where criteria_rate_defn_id =
pqh_crd_ins.g_criteria_rate_defn_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_effective_date in date
,p_rec in pqh_crd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
pqh_crd_rki.after_insert
(p_effective_date => p_effective_date
,p_criteria_rate_defn_id
=> p_rec.criteria_rate_defn_id
,p_short_name
=> p_rec.short_name
,p_uom
=> p_rec.uom
,p_currency_code
=> p_rec.currency_code
,p_reference_period_cd
=> p_rec.reference_period_cd
,p_define_max_rate_flag
=> p_rec.define_max_rate_flag
,p_define_min_rate_flag
=> p_rec.define_min_rate_flag
,p_define_mid_rate_flag
=> p_rec.define_mid_rate_flag
,p_define_std_rate_flag
=> p_rec.define_std_rate_flag
,p_rate_calc_cd
=> p_rec.rate_calc_cd
,p_rate_calc_rule
=> p_rec.rate_calc_rule
,p_preferential_rate_cd
=> p_rec.preferential_rate_cd
,p_preferential_rate_rule
=> p_rec.preferential_rate_rule
,p_rounding_cd
=> p_rec.rounding_cd
,p_rounding_rule
=> p_rec.rounding_rule
,p_business_group_id
=> p_rec.business_group_id
,p_legislation_code
=> p_rec.legislation_code
,p_attribute_category
=> p_rec.attribute_category
,p_attribute1
=> p_rec.attribute1
,p_attribute2
=> p_rec.attribute2
,p_attribute3
=> p_rec.attribute3
,p_attribute4
=> p_rec.attribute4
,p_attribute5
=> p_rec.attribute5
,p_attribute6
=> p_rec.attribute6
,p_attribute7
=> p_rec.attribute7
,p_attribute8
=> p_rec.attribute8
,p_attribute9
=> p_rec.attribute9
,p_attribute10
=> p_rec.attribute10
,p_attribute11
=> p_rec.attribute11
,p_attribute12
=> p_rec.attribute12
,p_attribute13
=> p_rec.attribute13
,p_attribute14
=> p_rec.attribute14
,p_attribute15
=> p_rec.attribute15
,p_attribute16
=> p_rec.attribute16
,p_attribute17
=> p_rec.attribute17
,p_attribute18
=> p_rec.attribute18
,p_attribute19
=> p_rec.attribute19
,p_attribute20
=> p_rec.attribute20
,p_attribute21
=> p_rec.attribute21
,p_attribute22
=> p_rec.attribute22
,p_attribute23
=> p_rec.attribute23
,p_attribute24
=> p_rec.attribute24
,p_attribute25
=> p_rec.attribute25
,p_attribute26
=> p_rec.attribute26
,p_attribute27
=> p_rec.attribute27
,p_attribute28
=> p_rec.attribute28
,p_attribute29
=> p_rec.attribute29
,p_attribute30
=> p_rec.attribute30
,p_object_version_number
=> p_rec.object_version_number
);
End post_insert;
pqh_crd_bus.insert_validate
(p_effective_date
,p_rec
);
pqh_crd_ins.pre_insert(p_rec);
pqh_crd_ins.insert_dml(p_rec);
pqh_crd_ins.post_insert
(p_effective_date
,p_rec
);