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_DOCUMENT_EXTRA_INFO

Line 72: ,p_transaction_ref_table in varchar2 default 'HR_DOCUMENT_EXTRA_INFO'

68: ,p_url in varchar2 default null
69: ,p_status in varchar2 default 'W'
70: ,p_section_display_name in varchar2 default null
71: ,p_function_id in number default null
72: ,p_transaction_ref_table in varchar2 default 'HR_DOCUMENT_EXTRA_INFO'
73: ,p_transaction_ref_id in number default null
74: ,p_transaction_type in varchar2 default 'WF'
75: ,p_assignment_id in number default null
76: ,p_api_addtnl_info in varchar2 default null

Line 104: where transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'

100:
101: Cursor cur_trans(p_selected_person_id IN number) is
102: select transaction_id
103: from hr_api_transactions
104: where transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
105: and status ='W'
106: and selected_person_id = p_selected_person_id ;
107:
108: BEGIN

Line 390: p_org_rec hr_document_extra_info%rowtype;

386:
387: l_proc varchar2(70) := g_package||'.save_transaction_values';
388: p_action_mode varchar2(30);
389: p_transaction_id hr_api_transactions.transaction_id%type;
390: p_org_rec hr_document_extra_info%rowtype;
391: msg_name varchar2(1000);
392: msg_appl varchar2(10);
393:
394: BEGIN

Line 915: FROM HR_DOCUMENT_EXTRA_INFO

911: elsif p_action_mode = 'DOR_UPDATE' then
912:
913: SELECT *
914: INTO p_org_rec
915: FROM HR_DOCUMENT_EXTRA_INFO
916: WHERE document_extra_info_id = p_document_extra_info_id
917: AND person_id = p_person_id
918: AND document_type_id = p_document_type_id;
919:

Line 2147: p_dor_rec HR_DOCUMENT_EXTRA_INFO%rowtype;

2143: )
2144: IS
2145:
2146: l_proc varchar2(72) := g_package ||'.process_api';
2147: p_dor_rec HR_DOCUMENT_EXTRA_INFO%rowtype;
2148: p_return_status varchar2(100);
2149: l_object_version_number number;
2150: l_effective_date date;
2151: l_validate number;

Line 2229: hr_document_extra_info_swi.create_doc_extra_info

2225:
2226: end if;
2227:
2228: if p_action_mode = 'DOR_INSERT' then
2229: hr_document_extra_info_swi.create_doc_extra_info
2230: (p_validate => l_validate
2231: ,p_person_id => p_dor_rec.person_id
2232: ,p_document_type_id => p_dor_rec.document_type_id
2233: ,p_date_from => p_dor_rec.date_from

Line 2319: hr_document_extra_info_swi.update_doc_extra_info

2315:
2316: elsif p_action_mode ='DOR_UPDATE' then
2317:
2318:
2319: hr_document_extra_info_swi.update_doc_extra_info
2320: (p_validate => l_validate
2321: ,p_person_id => p_dor_rec.person_id
2322: ,p_document_type_id => p_dor_rec.document_type_id
2323: ,p_date_from => p_dor_rec.date_from

Line 2578: and hat.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'

2574: and hatv2.transaction_step_id = hats.transaction_step_id
2575: and hatv3.transaction_step_id = hats.transaction_step_id
2576: and hatv4.transaction_step_id =hats.transaction_step_id
2577: and hats.transaction_id = hat.transaction_id
2578: and hat.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
2579: and hat.status not in ('D','E','W');
2580:
2581:
2582: cursor csr_chk_doc_number(p_document_type_id number,

Line 2598: and hat.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'

2594: and hatv2.name = 'P_DOCUMENT_NUMBER'
2595: and hatv1.transaction_step_id = hats.transaction_step_id
2596: and hatv2.transaction_step_id =hats.transaction_step_id
2597: and hats.transaction_id = hat.transaction_id
2598: and hat.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
2599: and hat.status not in ('D','E','W');
2600: --FIX FOR BUG 15835786
2601:
2602: BEGIN

Line 2610: hr_document_extra_info_swi.create_doc_extra_info

2606:
2607:
2608: --- Validating the document information thru api------------------
2609: if p_action_mode = 'DOR_INSERT' then
2610: hr_document_extra_info_swi.create_doc_extra_info
2611: (p_validate => p_validate
2612: ,p_person_id => p_person_id
2613: ,p_document_type_id => p_document_type_id
2614: ,p_date_from => p_date_from

Line 2699: hr_document_extra_info_swi.update_doc_extra_info

2695: );
2696:
2697: elsif p_action_mode ='DOR_UPDATE' then
2698:
2699: hr_document_extra_info_swi.update_doc_extra_info
2700: (p_validate => p_validate
2701: ,p_person_id => p_person_id
2702: ,p_document_type_id => p_document_type_id
2703: ,p_date_from => p_date_from

Line 2877: ,p_dor_rec out nocopy HR_DOCUMENT_EXTRA_INFO%rowtype)

2873:
2874:
2875: PROCEDURE get_review_data_from_tt(
2876: p_transaction_step_id in number
2877: ,p_dor_rec out nocopy HR_DOCUMENT_EXTRA_INFO%rowtype)
2878: IS
2879:
2880: l_proc varchar2(72) := g_package ||'get_review_data_from_tt';
2881:

Line 3411: p_dor_rec hr_document_extra_info%rowtype;

3407: ,p_system_doc_type out nocopy varchar2
3408: ) IS
3409:
3410: l_proc varchar2(72) := g_package ||'.get_transaction_values';
3411: p_dor_rec hr_document_extra_info%rowtype;
3412: l_country_name varchar2(150);
3413: l_document_type varchar2(150);
3414: l_category_name varchar2(150);
3415: l_sub_category_name varchar2(150);

Line 3966: WHERE transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'

3962: WHERE transaction_id in
3963: (
3964: SELECT transaction_id
3965: FROM hr_api_transactions
3966: WHERE transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
3967: and selected_person_id= (select person_id from hr_document_extra_info
3968: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id)
3969: )
3970: )

Line 3967: and selected_person_id= (select person_id from hr_document_extra_info

3963: (
3964: SELECT transaction_id
3965: FROM hr_api_transactions
3966: WHERE transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'
3967: and selected_person_id= (select person_id from hr_document_extra_info
3968: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id)
3969: )
3970: )
3971: and NUMBER_VALUE = p_document_extra_info_id;

Line 3976: WHERE trx.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'

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')
3980: =p_document_extra_info_id

Line 3981: and trx.selected_person_id in (select person_id from 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')
3980: =p_document_extra_info_id
3981: and trx.selected_person_id in (select person_id from hr_document_extra_info
3982: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id) ;*/
3983:
3984: cursor c_transaction is
3985: SELECT distinct trx.function_id

Line 3987: WHERE trx.transaction_ref_table = 'HR_DOCUMENT_EXTRA_INFO'

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')
3991: =p_document_extra_info_id

Line 3992: and trx.selected_person_id in (select person_id from 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')
3991: =p_document_extra_info_id
3992: and trx.selected_person_id in (select person_id from hr_document_extra_info
3993: where DOCUMENT_EXTRA_INFO_ID = p_document_extra_info_id) ;
3994:
3995: begin
3996: