APPS.HR_DOR_REVIEW_SS dependencies on HR_API_TRANSACTION_STEPS

Line 57: -------hr_api_transaction_steps.------------------------------------------

53:
54: --------------------------------------------------------------------------
55: --------------------------Start_transaction-------------------------------
56: -------This method creates record in tables hr_api_transactions and ------
57: -------hr_api_transaction_steps.------------------------------------------
58: --------------------------------------------------------------------------
59:
60:
61: PROCEDURE start_transaction(

Line 2562: hr_api_transaction_steps hats,

2558: from hr_api_transaction_values hatv1,
2559: hr_api_transaction_values hatv2,
2560: hr_api_transaction_values hatv3,
2561: hr_api_transaction_values hatv4,
2562: hr_api_transaction_steps hats,
2563: hr_api_transactions hat
2564: WHERE hat.selected_person_id = p_person_id
2565: and hatv1.number_value = p_document_type_id
2566: and hatv2.date_value = p_date_from

Line 2588: hr_api_transaction_steps hats,

2584: p_document_number varchar2) is
2585: select count(*)
2586: from hr_api_transaction_values hatv1,
2587: hr_api_transaction_values hatv2,
2588: hr_api_transaction_steps hats,
2589: hr_api_transactions hat
2590: WHERE hat.selected_person_id = p_person_id
2591: and hatv1.number_value = p_document_type_id
2592: and hatv2.VARCHAR2_VALUE = p_document_number

Line 3947: select transaction_id from hr_api_transaction_steps

3943: CURSOR c_transaction is
3944: select transaction_id
3945: from hr_api_transactions
3946: where transaction_id = (
3947: select transaction_id from hr_api_transaction_steps
3948: where transaction_step_id = (
3949: select transaction_step_id from hr_api_transaction_values
3950: where NAME = 'P_DOCUMENT_EXTRA_INFO_ID'
3951: and NUMBER_VALUE = p_document_extra_info_id ));

Line 3961: FROM hr_api_transaction_steps

3957: WHERE name = 'P_DOCUMENT_EXTRA_INFO_ID'
3958: AND transaction_step_id in
3959: (
3960: SELECT transaction_step_id
3961: FROM hr_api_transaction_steps
3962: WHERE transaction_id in
3963: (
3964: SELECT transaction_id
3965: FROM hr_api_transactions

Line 3975: FROM hr_api_transactions trx,hr_api_transaction_steps trs,hr_api_transaction_values trv

3971: and NUMBER_VALUE = p_document_extra_info_id;
3972: */
3973: /*cursor c_transaction is
3974: SELECT 1
3975: FROM hr_api_transactions trx,hr_api_transaction_steps trs,hr_api_transaction_values trv
3976: WHERE trx.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
3977: and trx.transaction_id = trs.transaction_id
3978: and trs.transaction_step_id = trv.TRANSACTION_STEP_ID
3979: and hr_transaction_api.get_number_value(trs.TRANSACTION_STEP_ID, 'P_DOCUMENT_EXTRA_INFO_ID')

Line 3986: FROM hr_api_transactions trx,hr_api_transaction_steps trs,hr_api_transaction_values trv

3982: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id) ;*/
3983:
3984: cursor c_transaction is
3985: SELECT distinct trx.function_id
3986: FROM hr_api_transactions trx,hr_api_transaction_steps trs,hr_api_transaction_values trv
3987: WHERE trx.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
3988: and trx.transaction_id = trs.transaction_id
3989: and trs.transaction_step_id = trv.TRANSACTION_STEP_ID
3990: and hr_transaction_api.get_number_value(trs.TRANSACTION_STEP_ID, 'P_DOCUMENT_EXTRA_INFO_ID')

Line 4211: from hr_api_transaction_steps hats

4207: l_transaction_id hr_api_transactions.transaction_id%type;
4208: -- cursor to select the transaction_id of the step
4209: cursor csr_hats is
4210: select hats.transaction_id
4211: from hr_api_transaction_steps hats
4212: where hats.transaction_step_id = p_transaction_step_id;
4213:
4214: begin
4215: