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

Line 56: -------This method creates record in tables hr_api_transactions and ------

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

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 103: from hr_api_transactions

99: p_effective_date Date;
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:

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 389: p_transaction_id hr_api_transactions.transaction_id%type;

385: ) is
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:

Line 2155: p_transaction_id hr_api_transactions.transaction_id%type;

2151: l_validate number;
2152: p_item_type wf_items.item_type%type;
2153: p_item_key wf_items.item_key%type;
2154: p_action_mode varchar2(30);
2155: p_transaction_id hr_api_transactions.transaction_id%type;
2156: l_user_name varchar2(30);
2157: l_verified_by_user_name varchar2(30);
2158: l_verified_by number;
2159: l_verified_date date;

Line 2170: l_validate := hr_api.g_true_num;

2166: hr_utility.set_location(' Entering:' || l_proc,40);
2167:
2168:
2169: If p_validate then
2170: l_validate := hr_api.g_true_num;
2171: else
2172: l_validate := hr_api.g_false_num;
2173: end if;
2174:

Line 2172: l_validate := hr_api.g_false_num;

2168:
2169: If p_validate then
2170: l_validate := hr_api.g_true_num;
2171: else
2172: l_validate := hr_api.g_false_num;
2173: end if;
2174:
2175: p_transaction_id := get_transaction_id(p_transaction_step_id);
2176: p_action_mode := getActionMode(p_transaction_id);

Line 2456: p_validate in number default hr_api.g_true_num

2452:
2453:
2454:
2455: PROCEDURE validate_dor(
2456: p_validate in number default hr_api.g_true_num
2457: ,p_person_id in number
2458: ,p_document_extra_info_id in number
2459: ,p_document_type_id in number
2460: ,p_date_from in date

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 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 2563: hr_api_transactions hat

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
2567: and hatv3.date_value = p_date_to

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 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 2589: hr_api_transactions hat

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
2593: and hatv1.name = 'P_DOCUMENT_TYPE_ID'

Line 3431: from hr_api_transactions where

3427: p_transaction_id := get_transaction_id(p_transaction_step_id);
3428:
3429: begin
3430: select status into l_status
3431: from hr_api_transactions where
3432: transaction_id=p_transaction_id;
3433:
3434: exception
3435: when NO_DATA_FOUND then

Line 3909: from hr_api_transactions

3905: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 1);
3906:
3907: select item_type,item_key into
3908: p_item_type,p_item_key
3909: from hr_api_transactions
3910: where transaction_id = p_transaction_id;
3911:
3912: wf_engine.abortprocess(itemtype => p_item_type
3913: ,itemkey => p_item_key);

Line 3939: ltransaction_id hr_api_transactions.transaction_id%TYPE;

3935: IS
3936: c_proc constant varchar2(30) := 'isUpdateAllowed';
3937: dor_UpdateAllowed varchar2(30);
3938: p_count number := 0;
3939: ltransaction_id hr_api_transactions.transaction_id%TYPE;
3940: dummy varchar2(10);
3941: pNtfFyiDetails varchar2(1) := 'N';
3942: /*
3943: CURSOR c_transaction is

Line 3945: from hr_api_transactions

3941: pNtfFyiDetails varchar2(1) := 'N';
3942: /*
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

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 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 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 3965: FROM hr_api_transactions

3961: FROM hr_api_transaction_steps
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: )

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 4144: ln_hr_api_transaction_rec hr_api_transactions%rowtype;

4140: p_person_id in number) return boolean
4141: is
4142: -- local variables
4143: x_returnStatus boolean;
4144: ln_hr_api_transaction_rec hr_api_transactions%rowtype;
4145: ln_person_id number;
4146:
4147: begin
4148:

Line 4156: select hr_api_transactions.creator_person_id

4152:
4153: if(p_transaction_id is not null) then
4154: -- ignore passed personid
4155: -- derive from the transaction details
4156: select hr_api_transactions.creator_person_id
4157: into ln_person_id
4158: from hr_api_transactions
4159: where transaction_id=p_transaction_id;
4160: end if;

Line 4158: from hr_api_transactions

4154: -- ignore passed personid
4155: -- derive from the transaction details
4156: select hr_api_transactions.creator_person_id
4157: into ln_person_id
4158: from hr_api_transactions
4159: where transaction_id=p_transaction_id;
4160: end if;
4161:
4162: --

Line 4178: p_api_addtnl_info hr_api_transactions.api_addtnl_info%type;

4174: function getActionMode(p_transaction_id in number)
4175: return varchar2
4176: is
4177:
4178: p_api_addtnl_info hr_api_transactions.api_addtnl_info%type;
4179:
4180: begin
4181:
4182: SELECT api_addtnl_info

Line 4184: FROM hr_api_transactions

4180: begin
4181:
4182: SELECT api_addtnl_info
4183: INTO p_api_addtnl_info
4184: FROM hr_api_transactions
4185: WHERE transaction_id = p_transaction_id;
4186:
4187: return p_api_addtnl_info;
4188:

Line 4207: l_transaction_id hr_api_transactions.transaction_id%type;

4203: -- --------------------------------------------------------------------------
4204: -- declare local variables
4205: -- --------------------------------------------------------------------------
4206: l_proc constant varchar2(100) := g_package || ' get_transaction_id';
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

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: