APPS.OTA_TFL_API_INS dependencies on OTA_FINANCE_LINES

Line 85: -- Insert the row into: ota_finance_lines

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

Line 87: insert into ota_finance_lines

83: ota_tfl_api_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: ota_finance_lines
86: --
87: insert into ota_finance_lines
88: ( finance_line_id,
89: finance_header_id,
90: cancelled_flag,
91: date_raised,

Line 279: Cursor C_Sel1 is select ota_finance_lines_s.nextval from sys.dual;

275: Procedure pre_insert(p_rec in out nocopy ota_tfl_api_shd.g_rec_type) is
276: --
277: l_proc varchar2(72) := g_package||'pre_insert';
278: --
279: Cursor C_Sel1 is select ota_finance_lines_s.nextval from sys.dual;
280: --
281:
282: --
283: Cursor C_Sel2 is

Line 285: from ota_finance_lines

281:
282: --
283: Cursor C_Sel2 is
284: Select null
285: from ota_finance_lines
286: where finance_line_id =
287: ota_tfl_api_ins.g_finance_line_id_i;
288: --
289:

Line 307: fnd_message.set_token('TABLE_NAME','ota_finance_lines');

303: --
304: -- The primary key values are already in use.
305: --
306: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
307: fnd_message.set_token('TABLE_NAME','ota_finance_lines');
308: fnd_message.raise_error;
309: End If;
310: Close C_Sel2;
311: --