APPS.GHR_CAH_INS dependencies on GHR_COMPL_CA_HEADERS

Line 87: -- Insert the row into: ghr_compl_ca_headers

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

Line 89: insert into ghr_compl_ca_headers

85: --
86: --
87: -- Insert the row into: ghr_compl_ca_headers
88: --
89: insert into ghr_compl_ca_headers
90: (compl_ca_header_id
91: ,complaint_id
92: ,ca_source
93: ,last_compliance_report

Line 205: Cursor C_Sel1 is select ghr_compl_ca_headers_s.nextval from sys.dual;

201: Procedure pre_insert
202: (p_rec in out nocopy ghr_cah_shd.g_rec_type
203: ) is
204: --
205: Cursor C_Sel1 is select ghr_compl_ca_headers_s.nextval from sys.dual;
206: --
207: Cursor C_Sel2 is
208: Select null
209: from ghr_compl_ca_headers

Line 209: from ghr_compl_ca_headers

205: Cursor C_Sel1 is select ghr_compl_ca_headers_s.nextval from sys.dual;
206: --
207: Cursor C_Sel2 is
208: Select null
209: from ghr_compl_ca_headers
210: where compl_ca_header_id =
211: ghr_cah_ins.g_compl_ca_header_id_i;
212: --
213: l_proc varchar2(72) := g_package||'pre_insert';

Line 231: fnd_message.set_token('TABLE_NAME','ghr_compl_ca_headers');

227: --
228: -- The primary key values are already in use.
229: --
230: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
231: fnd_message.set_token('TABLE_NAME','ghr_compl_ca_headers');
232: fnd_message.raise_error;
233: End If;
234: Close C_Sel2;
235: --

Line 331: (p_module_name => 'GHR_COMPL_CA_HEADERS'

327: --
328: when hr_api.cannot_find_prog_unit then
329: --
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'GHR_COMPL_CA_HEADERS'
332: ,p_hook_type => 'AI');
333: --
334: end;
335: --