APPS.GHR_CDT_INS dependencies on GHR_COMPL_CA_DETAILS

Line 87: -- Insert the row into: ghr_compl_ca_details

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ghr_compl_ca_details
88: --
89: insert into ghr_compl_ca_details
90: (compl_ca_detail_id
91: ,compl_ca_header_id

Line 89: insert into ghr_compl_ca_details

85: --
86: --
87: -- Insert the row into: ghr_compl_ca_details
88: --
89: insert into ghr_compl_ca_details
90: (compl_ca_detail_id
91: ,compl_ca_header_id
92: --,action
93: ,amount

Line 189: Cursor C_Sel1 is select ghr_compl_ca_details_s.nextval from sys.dual;

185: Procedure pre_insert
186: (p_rec in out nocopy ghr_cdt_shd.g_rec_type
187: ) is
188: --
189: Cursor C_Sel1 is select ghr_compl_ca_details_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from ghr_compl_ca_details

Line 193: from ghr_compl_ca_details

189: Cursor C_Sel1 is select ghr_compl_ca_details_s.nextval from sys.dual;
190: --
191: Cursor C_Sel2 is
192: Select null
193: from ghr_compl_ca_details
194: where compl_ca_detail_id =
195: ghr_cdt_ins.g_compl_ca_detail_id_i;
196: --
197: l_proc varchar2(72) := g_package||'pre_insert';

Line 215: fnd_message.set_token('TABLE_NAME','ghr_compl_ca_details');

211: --
212: -- The primary key values are already in use.
213: --
214: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
215: fnd_message.set_token('TABLE_NAME','ghr_compl_ca_details');
216: fnd_message.raise_error;
217: End If;
218: Close C_Sel2;
219: --

Line 307: (p_module_name => 'GHR_COMPL_CA_DETAILS'

303: --
304: when hr_api.cannot_find_prog_unit then
305: --
306: hr_api.cannot_find_prog_unit_error
307: (p_module_name => 'GHR_COMPL_CA_DETAILS'
308: ,p_hook_type => 'AI');
309: --
310: end;
311: --