eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DOR_REVIEW_SS dependencies on HR_API_TRANSACTION_VALUES

Line 214: ----Saving all the mandatory values in the hr_api_transaction_values table----

210: ,p_activity_id => p_act_id
211: ,p_transaction_step_id => l_transaction_step_id
212: ,p_object_version_number => l_trans_obj_vers_num);
213:
214: ----Saving all the mandatory values in the hr_api_transaction_values table----
215:
216:
217: l_count := l_count + 1;
218: l_transaction_table(l_count).param_name := 'P_LOGIN_PERSON_ID';

Line 295: -----hr_api_transaction_values table--------------------------------------

291:
292: --------------------------------------------------------------------------
293: --------------------------save_transaction_values-------------------------
294: -----This method stores the document information of a person in the ------
295: -----hr_api_transaction_values table--------------------------------------
296: --------------------------------------------------------------------------
297:
298:
299: PROCEDURE save_transaction_values(

Line 2558: from hr_api_transaction_values hatv1,

2554: p_date_from DATE,
2555: p_date_to DATE,
2556: p_document_number varchar2) is
2557: select count(*)
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,

Line 2559: hr_api_transaction_values hatv2,

2555: p_date_to DATE,
2556: p_document_number varchar2) is
2557: select count(*)
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

Line 2560: hr_api_transaction_values hatv3,

2556: p_document_number varchar2) is
2557: select count(*)
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

Line 2561: hr_api_transaction_values hatv4,

2557: select count(*)
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

Line 2586: from hr_api_transaction_values hatv1,

2582: cursor csr_chk_doc_number(p_document_type_id number,
2583: p_person_id number,
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

Line 2587: hr_api_transaction_values hatv2,

2583: p_person_id number,
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

Line 3949: select transaction_step_id from hr_api_transaction_values

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 ));
3952:
3953:

Line 3956: FROM hr_api_transaction_values

3952:
3953:
3954: cursor c_transaction is
3955: select 1
3956: FROM hr_api_transaction_values
3957: WHERE name = 'P_DOCUMENT_EXTRA_INFO_ID'
3958: AND transaction_step_id in
3959: (
3960: SELECT transaction_step_id

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')