DBA Data[Home] [Help]

APPS.PQH_ATT_DEL dependencies on PQH_ATTRIBUTES

Line 57: p_entity_name=>'PQH_ATTRIBUTES',

53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.
55: --
56: PER_RIC_PKG.chk_integrity (
57: p_entity_name=>'PQH_ATTRIBUTES',
58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),

Line 62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(

58: p_ref_entity_info=>
59: PER_RIC_PKG.ref_entity_tbl(
60: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTE_RANGES',PER_RIC_PKG.column_info_tbl(
61: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
62: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES_TL',PER_RIC_PKG.column_info_tbl(
63: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
64: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATE_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
65: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL, p_rec.attribute_id,NULL))),
66: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(

Line 73: -- Delete the pqh_attributes row.

69: --
70: --
71: -- Code Ends Here
72: --
73: -- Delete the pqh_attributes row.
74: --
75: delete from pqh_attributes
76: where attribute_id = p_rec.attribute_id;
77: --

Line 75: delete from pqh_attributes

71: -- Code Ends Here
72: --
73: -- Delete the pqh_attributes row.
74: --
75: delete from pqh_attributes
76: where attribute_id = p_rec.attribute_id;
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 198: (p_module_name => 'pqh_attributes'

194: --
195: when hr_api.cannot_find_prog_unit then
196: --
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'pqh_attributes'
199: ,p_hook_type => 'AD');
200: --
201: end;
202: --