APPS.OTA_TFH_API_INS dependencies on OTA_FINANCE_HEADERS

Line 85: -- Insert the row into: ota_finance_headers

81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: ota_tfh_api_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: ota_finance_headers
86: --
87: insert into ota_finance_headers
88: ( finance_header_id,
89: superceding_header_id,

Line 87: insert into ota_finance_headers

83: ota_tfh_api_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: ota_finance_headers
86: --
87: insert into ota_finance_headers
88: ( finance_header_id,
89: superceding_header_id,
90: authorizer_person_id,
91: organization_id,

Line 421: Cursor C_Sel1 is select ota_finance_headers_s.nextval from sys.dual;

417: Procedure pre_insert(p_rec in out nocopy ota_tfh_api_shd.g_rec_type) is
418: --
419: l_proc varchar2(72) := g_package||'pre_insert';
420: --
421: Cursor C_Sel1 is select ota_finance_headers_s.nextval from sys.dual;
422: --
423:
424: --
425: Cursor C_Sel2 is

Line 427: from ota_finance_headers

423:
424: --
425: Cursor C_Sel2 is
426: Select null
427: from ota_finance_headers
428: where finance_header_id =
429: ota_tfh_api_ins.g_finance_header_id_i;
430: --
431:

Line 449: fnd_message.set_token('TABLE_NAME','ota_finance_headers');

445: --
446: -- The primary key values are already in use.
447: --
448: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
449: fnd_message.set_token('TABLE_NAME','ota_finance_headers');
450: fnd_message.raise_error;
451: End If;
452: Close C_Sel2;
453: --