APPS.PQH_PTE_BUS dependencies on PQH_POSITION_TRANSACTIONS

Line 111: from pqh_position_transactions a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pqh_position_transactions a
112: where a.position_transaction_id = p_position_transaction_id;
113: --
114: Begin
115: --

Line 127: -- check if position_transaction_id value exists in pqh_position_transactions table

123: and nvl(p_position_transaction_id,hr_api.g_number)
124: <> nvl(pqh_pte_shd.g_old_rec.position_transaction_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if position_transaction_id value exists in pqh_position_transactions table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in pqh_position_transactions

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in pqh_position_transactions
137: -- table.
138: --
139: pqh_pte_shd.constraint_error('PQH_PTX_EXTRA_INFO_FK2');
140: --

Line 237: l_ptx_rec pqh_position_transactions%rowtype;

233: Procedure insert_validate(p_rec in pqh_pte_shd.g_rec_type) is
234: --
235: l_proc varchar2(72) := g_package||'insert_validate';
236: --
237: l_ptx_rec pqh_position_transactions%rowtype;
238: --
239: cursor c_ptx(p_position_transaction_id number) is
240: select *
241: from pqh_position_transactions

Line 241: from pqh_position_transactions

237: l_ptx_rec pqh_position_transactions%rowtype;
238: --
239: cursor c_ptx(p_position_transaction_id number) is
240: select *
241: from pqh_position_transactions
242: where position_transaction_id = p_position_transaction_id;
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --