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 1929: if hr_transaction_ss.get_transaction_id(p_item_type => itemtype

1925: ,p_name => 'TRANSACTION_ID') then
1926:
1927: -- the TRANSACTION_ID exists so ensure that it is null
1928:
1929: if hr_transaction_ss.get_transaction_id(p_item_type => itemtype
1930: ,p_item_key => itemkey) is not null then
1931:
1932: -- a current transaction is in progress we cannot overwrite it
1933: -- get the Transaction Step Id

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

1931:
1932: -- a current transaction is in progress we cannot overwrite it
1933: -- get the Transaction Step Id
1934: hr_utility.set_location( l_proc,15);
1935: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => itemtype
1936: ,p_item_key => itemkey);
1937: open c_get_transaction_step_id;
1938: fetch c_get_transaction_step_id into l_transaction_step_id;
1939: /*if c_get_transaction_step_id%found then

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

1941: hr_utility.set_message(801, 'HR_51750_WEB_TRANSAC_STARTED');
1942: hr_utility.raise_error;
1943: end if;*/
1944: close c_get_transaction_step_id;
1945: hr_transaction_ss.delete_transaction_step(l_transaction_step_id,null,p_creator_person_id);
1946: end if;
1947:
1948: else
1949: hr_utility.set_location( l_proc,20);

Line 2535: ln_transaction_id := hr_transaction_ss.get_transaction_id

2531: --hr_utility.trace(' p_item_type' || p_item_type || ' ' ||
2532: -- ' p_item_key' || p_item_key || ' ' ||
2533: -- ' p_transaction_step_id' || p_transaction_step_id );
2534:
2535: ln_transaction_id := hr_transaction_ss.get_transaction_id
2536: (p_Item_Type => p_item_type,
2537: p_Item_Key => p_item_key);
2538:
2539: IF p_transaction_step_id IS NOT NULL

Line 2612: IF( hr_transaction_ss.check_txn_step_exists(

2608: --hr_utility.trace(' p_item_type' || p_item_type || ' ' ||
2609: -- ' p_item_key' || p_item_key || ' ' ||
2610: -- ' p_act_id' || p_act_id );
2611:
2612: IF( hr_transaction_ss.check_txn_step_exists(
2613: p_item_type,
2614: p_item_key,
2615: p_act_id )= TRUE )
2616: THEN

Line 2619: ln_transaction_id := hr_transaction_ss.get_transaction_id

2615: p_act_id )= TRUE )
2616: THEN
2617:
2618: hr_utility.set_location(l_proc,10);
2619: ln_transaction_id := hr_transaction_ss.get_transaction_id
2620: (p_Item_Type => p_item_type,
2621: p_Item_Key => p_item_key);
2622:
2623: -- hr_utility.trace(' ln_transaction_id ' || ln_transaction_id);

Line 2655: hr_transaction_ss.get_activity_trans_step_id

2651:
2652: -- hr_utility.trace(' lv_activity_name ' || lv_activity_name);
2653:
2654: ln_transaction_step_id :=
2655: hr_transaction_ss.get_activity_trans_step_id
2656: (p_activity_name =>lv_activity_name,
2657: p_trans_step_id_tbl => ltt_trans_step_ids);
2658:
2659:

Line 3131: gtt_trans_steps hr_transaction_ss.transaction_table;

3127: AND item_key = c_item_key
3128: --AND api_name = 'HR_PAY_RATE_SS.process_api_java';
3129: AND api_name = 'HR_PAY_RATE_SS.PROCESS_API';
3130:
3131: gtt_trans_steps hr_transaction_ss.transaction_table;
3132:
3133: BEGIN
3134: hr_utility.set_location(' Entering:' || l_proc,5);
3135: -- bug # 1641590

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

3210:
3211:
3212: gtt_trans_steps(li_count).param_name := 'p_effective_date' ;
3213: gtt_trans_steps(li_count).param_value :=
3214: to_char(p_ltt_salary_data(1).effective_date,hr_transaction_ss.g_date_format);
3215: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3216: li_count := li_count+1 ;
3217:
3218:

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

3217:
3218:
3219: gtt_trans_steps(li_count).param_name := 'p_salary_effective_date' ;
3220: gtt_trans_steps(li_count).param_value :=
3221: to_char(p_ltt_salary_data(1).salary_effective_date,hr_transaction_ss.g_date_format);
3222: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3223: li_count := li_count+1 ;
3224:
3225: hr_mee_workflow_service.get_activity_name

Line 3745: hr_transaction_ss.g_date_format);

3741: li_count := li_count + 1 ;
3742: gtt_trans_steps(li_count).param_name := 'p_default_date';
3743: gtt_trans_steps(li_count).param_value :=
3744: to_char(p_ltt_salary_data(1).default_date,
3745: hr_transaction_ss.g_date_format);
3746: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3747:
3748: li_count := li_count + 1 ;
3749: gtt_trans_steps(li_count).param_name := 'p_default_bg_id';

Line 3830: hr_transaction_ss.g_date_format);

3826: li_count := li_count + 1 ;
3827: gtt_trans_steps(li_count).param_name := 'p_default_last_change_date';
3828: gtt_trans_steps(li_count).param_value :=
3829: to_char(p_ltt_salary_data(1).default_last_change_date,
3830: hr_transaction_ss.g_date_format);
3831: gtt_trans_steps(li_count).param_data_type := 'DATE' ;
3832:
3833: li_count := li_count + 1 ;
3834: gtt_trans_steps(li_count).param_name := 'p_default_element_entry_id';

Line 3915: hr_transaction_ss.get_transaction_id

3911:
3912: /********
3913: -- check if there is a txn for this transaction
3914: ln_transaction_id :=
3915: hr_transaction_ss.get_transaction_id
3916: (p_Item_Type => p_item_type
3917: ,p_Item_Key => p_item_key);
3918:
3919: hr_utility.trace('No Txn Exists' || ln_transaction_id);

Line 3941: hr_transaction_ss.get_transaction_id

3937: -- insert into dev_test values (' result of start_transaction' || lv_result);
3938: -- commit;
3939:
3940: ln_transaction_id :=
3941: hr_transaction_ss.get_transaction_id
3942: (p_Item_Type => p_item_type
3943: ,p_Item_Key => p_item_key);
3944:
3945: --insert into dev_test values (' ln_transaction_id = ' || ln_transaction_id);

Line 3996: hr_Transaction_ss.get_activity_trans_step_id (

3992: --Get the Transaction Step ID for this activity.
3993:
3994: hr_utility.trace('Txn Step Id'|| ln_transaction_step_id);
3995: ln_transaction_step_id :=
3996: hr_Transaction_ss.get_activity_trans_step_id (
3997: p_activity_name => lv_activity_name,
3998: p_trans_step_id_tbl => ltt_trans_step_ids);
3999:
4000: END IF;

Line 4015: --hr_transaction_ss.save_transaction_step(

4011: --commit;
4012: ************/
4013:
4014: -- save the txn data
4015: --hr_transaction_ss.save_transaction_step(
4016:
4017: -- hr_utility.trace('Create Transaction and Transaction Step ');
4018:
4019: open get_transaction_step_id

Line 4029: hr_transaction_ss.save_transaction_step(

4025: close get_transaction_step_id;
4026:
4027: -- hr_utility.trace(' existing ln_transaction_step_id ' || ln_transaction_step_id);
4028:
4029: hr_transaction_ss.save_transaction_step(
4030: p_Item_Type => p_item_type
4031: ,p_Item_Key => p_item_key
4032: ,p_ActID => p_act_id
4033: ,p_login_person_id => ln_creator_person_id

Line 4587: ln_transaction_id := hr_transaction_ss.get_transaction_id

4583: -- hr_utility.trace_on(null,'dev_log');
4584:
4585:
4586:
4587: ln_transaction_id := hr_transaction_ss.get_transaction_id
4588: (p_Item_Type => p_item_type,
4589: p_Item_Key => p_item_key);
4590:
4591: IF ln_transaction_id IS NOT NULL

Line 4621: hr_transaction_ss.get_activity_trans_step_id

4617: ,p_activity_name => lv_activity_name
4618: ,p_activity_display_name => lv_activity_display_name);
4619:
4620: ln_transaction_step_id :=
4621: hr_transaction_ss.get_activity_trans_step_id
4622: (p_activity_name =>lv_activity_name,
4623: p_trans_step_id_tbl => ltt_trans_step_ids);
4624:
4625: -- hr_utility.trace(' ln_transaction_step_id ' || ln_transaction_step_id);

Line 6120: l_effective_date:= hr_transaction_ss.get_wf_effective_date

6116: hr_utility.set_location(l_proc,10);
6117: l_effective_date:= p_effective_date;
6118: else
6119: hr_utility.set_location(l_proc,15);
6120: l_effective_date:= hr_transaction_ss.get_wf_effective_date
6121: (p_transaction_step_id => p_transaction_step_id);
6122: end if;
6123:
6124: -- check for GSP assignment

Line 6618: HR_TRANSACTION_SS.delete_transaction_step(

6614: hr_utility.set_location(' Entering:' || l_proc,5);
6615: open c1(p_transaction_id);
6616: fetch c1 into l_transaction_step_id;
6617: close c1;
6618: HR_TRANSACTION_SS.delete_transaction_step(
6619: p_transaction_step_id =>l_transaction_step_id,
6620: p_login_person_id => p_login_person_id);
6621: hr_utility.set_location(' Leaving:' || l_proc,10);
6622: END;