APPS.PQH_PA_WHATIF_PROCESS dependencies on HR_API

Line 301: from hr_api_transaction_steps trs

297: --
298: Cursor csr_trs is
299: select trs.transaction_step_id
300: ,trs.api_name
301: from hr_api_transaction_steps trs
302: where trs.transaction_id = p_transaction_id
303: and trs.object_type is null
304: and trs.api_name not in ('BEN_PROCESS_COMPENSATION_W.PROCESS_API')
305: order by trs.processing_order, trs.transaction_step_id;

Line 397: from hr_api_transaction_steps

393: IS
394: Cursor csr_trs is
395: select transaction_step_id
396: ,api_name
397: from hr_api_transaction_steps
398: where transaction_id = p_transaction_id
399: order by transaction_step_id, api_name;
400:
401: Cursor csr_trs_values(c_transaction_step_id in NUMBER) is

Line 407: from hr_api_transaction_values

403: ,name
404: ,varchar2_value
405: ,number_value
406: ,date_value
407: from hr_api_transaction_values
408: where transaction_step_id = c_transaction_step_id
409: order by transaction_value_id, datatype;
410:
411: Cursor c_ler (p_typ_cd in varchar2) is

Line 4263: FROM hr_api_transaction_steps

4259: ,p_txn_id IN OUT NOCOPY NUMBER
4260: ) IS
4261: CURSOR csr_trans_steps(txn_id IN NUMBER) IS
4262: SELECT transaction_step_id
4263: FROM hr_api_transaction_steps
4264: WHERE transaction_id=txn_id;
4265:
4266: l_proc VARCHAR2(72);
4267: BEGIN

Line 4287: DELETE FROM hr_api_transaction_values

4283: ,p_transaction_id =>p_txn_id);
4284: ELSE
4285: FOR rec_typ IN csr_trans_steps(p_txn_id)
4286: LOOP
4287: DELETE FROM hr_api_transaction_values
4288: WHERE transaction_step_id=rec_typ.transaction_step_id;
4289: END LOOP;
4290: DELETE FROM hr_api_transaction_steps
4291: WHERE transaction_id=p_txn_id;

Line 4290: DELETE FROM hr_api_transaction_steps

4286: LOOP
4287: DELETE FROM hr_api_transaction_values
4288: WHERE transaction_step_id=rec_typ.transaction_step_id;
4289: END LOOP;
4290: DELETE FROM hr_api_transaction_steps
4291: WHERE transaction_id=p_txn_id;
4292: END IF;
4293: if g_debug then
4294: hr_utility.set_location('Leaving: ' || l_proc,50);