DBA Data[Home] [Help]

APPS.PQH_ATT_INS dependencies on PQH_ATTRIBUTES

Line 60: p_entity_name=>'PQH_ATTRIBUTES',

56: -- Added the following code as a part of Zero Downtime Patching Project.
57: -- Code Starts Here.
58: --
59: per_ric_pkg.Chk_integrity (
60: p_entity_name=>'PQH_ATTRIBUTES',
61: p_ref_entity=>'PQH_TABLE_ROUTE',
62: p_ref_column_name=>'MASTER_TABLE_ROUTE_ID',
63: p_ref_col_value_number=>p_rec.master_table_route_id,
64: p_ref_col_value_varchar=>NULL,

Line 71: -- Insert the row into: pqh_attributes

67: --
68: -- Code Ends Here
69: --
70: --
71: -- Insert the row into: pqh_attributes
72: --
73: insert into pqh_attributes
74: ( attribute_id,
75: attribute_name,

Line 73: insert into pqh_attributes

69: --
70: --
71: -- Insert the row into: pqh_attributes
72: --
73: insert into pqh_attributes
74: ( attribute_id,
75: attribute_name,
76: master_attribute_id,
77: master_table_route_id,

Line 162: Cursor C_Sel1 is select pqh_attributes_s.nextval from sys.dual;

158: Procedure pre_insert(p_rec in out nocopy pqh_att_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'pre_insert';
161: --
162: Cursor C_Sel1 is select pqh_attributes_s.nextval from sys.dual;
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --

Line 244: (p_module_name => 'pqh_attributes'

240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'pqh_attributes'
245: ,p_hook_type => 'AI');
246: --
247: end;
248: --