DBA Data[Home] [Help]

APPS.HR_TRN_INS dependencies on HR_API_TRANSACTIONS

Line 87: -- Insert the row into: hr_api_transactions

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,

Line 89: insert into hr_api_transactions

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,

Line 218: Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;

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

Line 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);