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_PAY_RATE_SS dependencies on HR_TRANSACTION_SS

Line 13: l_transaction_table hr_transaction_ss.transaction_table;

9: approved_warn boolean;
10: payroll_warn boolean;
11: basischanged boolean;
12: -- Package scope global variables.
13: l_transaction_table hr_transaction_ss.transaction_table;
14:
15: l_count INTEGER := 0;
16: p_count INTEGER := 0;
17: l_praddr_ovrlap VARCHAR2(2);

Line 115: -- The following cursor is copied from hr_transaction_ss.process_transaction.

111: where p_eff_date_csr > start_date
112: and p_eff_date_csr <= end_date
113: and payroll_id = p_payroll_id_csr;
114:
115: -- The following cursor is copied from hr_transaction_ss.process_transaction.
116: CURSOR csr_trs is
117: select trs.transaction_step_id
118: ,trs.api_name
119: ,trs.item_type

Line 159: hr_transaction_ss.get_wf_effective_date

155: IF l_asg_txn_step_id IS NOT NULL
156: THEN
157: hr_utility.set_location(l_proc,15);
158: l_effective_date := to_date(
159: hr_transaction_ss.get_wf_effective_date
160: (p_transaction_step_id => l_asg_txn_step_id),
161: hr_transaction_ss.g_date_format);
162:
163: -- Get the pay_basis_id and payroll_id

Line 161: hr_transaction_ss.g_date_format);

157: hr_utility.set_location(l_proc,15);
158: l_effective_date := to_date(
159: hr_transaction_ss.get_wf_effective_date
160: (p_transaction_step_id => l_asg_txn_step_id),
161: hr_transaction_ss.g_date_format);
162:
163: -- Get the pay_basis_id and payroll_id
164: l_new_pay_basis_id := hr_transaction_api.get_number_value
165: (p_transaction_step_id => l_asg_txn_step_id

Line 1829: if hr_transaction_ss.get_transaction_id(p_item_type => itemtype

1825: ,p_name => 'TRANSACTION_ID') then
1826:
1827: -- the TRANSACTION_ID exists so ensure that it is null
1828:
1829: if hr_transaction_ss.get_transaction_id(p_item_type => itemtype
1830: ,p_item_key => itemkey) is not null then
1831:
1832: -- a current transaction is in progress we cannot overwrite it
1833: -- get the Transaction Step Id

Line 1835: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => itemtype

1831:
1832: -- a current transaction is in progress we cannot overwrite it
1833: -- get the Transaction Step Id
1834: hr_utility.set_location( l_proc,15);
1835: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => itemtype
1836: ,p_item_key => itemkey);
1837: open c_get_transaction_step_id;
1838: fetch c_get_transaction_step_id into l_transaction_step_id;
1839: /*if c_get_transaction_step_id%found then

Line 1845: hr_transaction_ss.delete_transaction_step(l_transaction_step_id,null,p_creator_person_id);

1841: hr_utility.set_message(801, 'HR_51750_WEB_TRANSAC_STARTED');
1842: hr_utility.raise_error;
1843: end if;*/
1844: close c_get_transaction_step_id;
1845: hr_transaction_ss.delete_transaction_step(l_transaction_step_id,null,p_creator_person_id);
1846: end if;
1847:
1848: else
1849: hr_utility.set_location( l_proc,20);

Line 2435: ln_transaction_id := hr_transaction_ss.get_transaction_id

2431: --hr_utility.trace(' p_item_type' || p_item_type || ' ' ||
2432: -- ' p_item_key' || p_item_key || ' ' ||
2433: -- ' p_transaction_step_id' || p_transaction_step_id );
2434:
2435: ln_transaction_id := hr_transaction_ss.get_transaction_id
2436: (p_Item_Type => p_item_type,
2437: p_Item_Key => p_item_key);
2438:
2439: IF p_transaction_step_id IS NOT NULL

Line 2512: IF( hr_transaction_ss.check_txn_step_exists(

2508: --hr_utility.trace(' p_item_type' || p_item_type || ' ' ||
2509: -- ' p_item_key' || p_item_key || ' ' ||
2510: -- ' p_act_id' || p_act_id );
2511:
2512: IF( hr_transaction_ss.check_txn_step_exists(
2513: p_item_type,
2514: p_item_key,
2515: p_act_id )= TRUE )
2516: THEN

Line 2519: ln_transaction_id := hr_transaction_ss.get_transaction_id

2515: p_act_id )= TRUE )
2516: THEN
2517:
2518: hr_utility.set_location(l_proc,10);
2519: ln_transaction_id := hr_transaction_ss.get_transaction_id
2520: (p_Item_Type => p_item_type,
2521: p_Item_Key => p_item_key);
2522:
2523: -- hr_utility.trace(' ln_transaction_id ' || ln_transaction_id);

Line 2555: hr_transaction_ss.get_activity_trans_step_id

2551:
2552: -- hr_utility.trace(' lv_activity_name ' || lv_activity_name);
2553:
2554: ln_transaction_step_id :=
2555: hr_transaction_ss.get_activity_trans_step_id
2556: (p_activity_name =>lv_activity_name,
2557: p_trans_step_id_tbl => ltt_trans_step_ids);
2558:
2559:

Line 2974: gtt_trans_steps hr_transaction_ss.transaction_table;

2970: AND item_key = c_item_key
2971: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
2972: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';
2973:
2974: gtt_trans_steps hr_transaction_ss.transaction_table;
2975:
2976: BEGIN
2977: hr_utility.set_location(' Entering:' || l_proc,5);
2978: -- bug # 1641590

Line 3057: to_char(p_ltt_salary_data(1).effective_date,hr_transaction_ss.g_date_format);

3053:
3054:
3055: gtt_trans_steps(li_count).param_name := 'p_effective_date' ;
3056: gtt_trans_steps(li_count).param_value :=
3057: to_char(p_ltt_salary_data(1).effective_date,hr_transaction_ss.g_date_format);
3058: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3059: li_count := li_count+1 ;
3060:
3061:

Line 3064: to_char(p_ltt_salary_data(1).salary_effective_date,hr_transaction_ss.g_date_format);

3060:
3061:
3062: gtt_trans_steps(li_count).param_name := 'p_salary_effective_date' ;
3063: gtt_trans_steps(li_count).param_value :=
3064: to_char(p_ltt_salary_data(1).salary_effective_date,hr_transaction_ss.g_date_format);
3065: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3066: li_count := li_count+1 ;
3067:
3068: hr_mee_workflow_service.get_activity_name

Line 3588: hr_transaction_ss.g_date_format);

3584: li_count := li_count + 1 ;
3585: gtt_trans_steps(li_count).param_name := 'p_default_date';
3586: gtt_trans_steps(li_count).param_value :=
3587: to_char(p_ltt_salary_data(1).default_date,
3588: hr_transaction_ss.g_date_format);
3589: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3590:
3591: li_count := li_count + 1 ;
3592: gtt_trans_steps(li_count).param_name := 'p_default_bg_id';

Line 3673: hr_transaction_ss.g_date_format);

3669: li_count := li_count + 1 ;
3670: gtt_trans_steps(li_count).param_name := 'p_default_last_change_date';
3671: gtt_trans_steps(li_count).param_value :=
3672: to_char(p_ltt_salary_data(1).default_last_change_date,
3673: hr_transaction_ss.g_date_format);
3674: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3675:
3676: li_count := li_count + 1 ;
3677: gtt_trans_steps(li_count).param_name := 'p_default_element_entry_id';

Line 3758: hr_transaction_ss.get_transaction_id

3754:
3755: /********
3756: -- check if there is a txn for this transaction
3757: ln_transaction_id :=
3758: hr_transaction_ss.get_transaction_id
3759: (p_Item_Type => p_item_type
3760: ,p_Item_Key => p_item_key);
3761:
3762: hr_utility.trace('No Txn Exists' || ln_transaction_id);

Line 3784: hr_transaction_ss.get_transaction_id

3780: -- insert into dev_test values (' result of start_transaction' || lv_result);
3781: -- commit;
3782:
3783: ln_transaction_id :=
3784: hr_transaction_ss.get_transaction_id
3785: (p_Item_Type => p_item_type
3786: ,p_Item_Key => p_item_key);
3787:
3788: --insert into dev_test values (' ln_transaction_id = ' || ln_transaction_id);

Line 3839: hr_Transaction_ss.get_activity_trans_step_id (

3835: --Get the Transaction Step ID for this activity.
3836:
3837: hr_utility.trace('Txn Step Id'|| ln_transaction_step_id);
3838: ln_transaction_step_id :=
3839: hr_Transaction_ss.get_activity_trans_step_id (
3840: p_activity_name => lv_activity_name,
3841: p_trans_step_id_tbl => ltt_trans_step_ids);
3842:
3843: END IF;

Line 3858: --hr_transaction_ss.save_transaction_step(

3854: --commit;
3855: ************/
3856:
3857: -- save the txn data
3858: --hr_transaction_ss.save_transaction_step(
3859:
3860: -- hr_utility.trace('Create Transaction and Transaction Step ');
3861:
3862: open get_transaction_step_id

Line 3872: hr_transaction_ss.save_transaction_step(

3868: close get_transaction_step_id;
3869:
3870: -- hr_utility.trace(' existing ln_transaction_step_id ' || ln_transaction_step_id);
3871:
3872: hr_transaction_ss.save_transaction_step(
3873: p_Item_Type => p_item_type
3874: ,p_Item_Key => p_item_key
3875: ,p_ActID => p_act_id
3876: ,p_login_person_id => ln_creator_person_id

Line 4426: ln_transaction_id := hr_transaction_ss.get_transaction_id

4422: -- hr_utility.trace_on(null,'dev_log');
4423:
4424:
4425:
4426: ln_transaction_id := hr_transaction_ss.get_transaction_id
4427: (p_Item_Type => p_item_type,
4428: p_Item_Key => p_item_key);
4429:
4430: IF ln_transaction_id IS NOT NULL

Line 4460: hr_transaction_ss.get_activity_trans_step_id

4456: ,p_activity_name => lv_activity_name
4457: ,p_activity_display_name => lv_activity_display_name);
4458:
4459: ln_transaction_step_id :=
4460: hr_transaction_ss.get_activity_trans_step_id
4461: (p_activity_name =>lv_activity_name,
4462: p_trans_step_id_tbl => ltt_trans_step_ids);
4463:
4464: -- hr_utility.trace(' ln_transaction_step_id ' || ln_transaction_step_id);

Line 5887: l_effective_date:= hr_transaction_ss.get_wf_effective_date

5883: hr_utility.set_location(l_proc,10);
5884: l_effective_date:= p_effective_date;
5885: else
5886: hr_utility.set_location(l_proc,15);
5887: l_effective_date:= hr_transaction_ss.get_wf_effective_date
5888: (p_transaction_step_id => p_transaction_step_id);
5889: end if;
5890:
5891: -- check for GSP assignment

Line 6316: HR_TRANSACTION_SS.delete_transaction_step(

6312: hr_utility.set_location(' Entering:' || l_proc,5);
6313: open c1(p_transaction_id);
6314: fetch c1 into l_transaction_step_id;
6315: close c1;
6316: HR_TRANSACTION_SS.delete_transaction_step(
6317: p_transaction_step_id =>l_transaction_step_id,
6318: p_login_person_id => p_login_person_id);
6319: hr_utility.set_location(' Leaving:' || l_proc,10);
6320: END;