83: --
84: --
85: hr_trn_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: hr_api_transactions
88: --
89: insert into hr_api_transactions
90: ( transaction_id,
91: creator_person_id,
85: hr_trn_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: hr_api_transactions
88: --
89: insert into hr_api_transactions
90: ( transaction_id,
91: creator_person_id,
92: transaction_privilege,
93: product_code,
214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: l_exists varchar2(1);
217: --
218: Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;
219:
220: Cursor C_Sel2 is
221: select null
222: from hr_api_transactions
218: Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;
219:
220: Cursor C_Sel2 is
221: select null
222: from hr_api_transactions
223: where transaction_id = hr_trn_ins.g_transaction_id_i;
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);