APPS.HR_PAY_RATE_SS dependencies on HR_TRANSACTION_API

Line 164: l_new_pay_basis_id := hr_transaction_api.get_number_value

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
166: ,p_name => 'P_PAY_BASIS_ID');
167:
168: l_payroll_id := hr_transaction_api.get_number_value

Line 168: l_payroll_id := hr_transaction_api.get_number_value

164: l_new_pay_basis_id := hr_transaction_api.get_number_value
165: (p_transaction_step_id => l_asg_txn_step_id
166: ,p_name => 'P_PAY_BASIS_ID');
167:
168: l_payroll_id := hr_transaction_api.get_number_value
169: (p_transaction_step_id => l_asg_txn_step_id
170: ,p_name => 'P_PAYROLL_ID');
171:
172: l_assignment_id := hr_transaction_api.get_number_value

Line 172: l_assignment_id := hr_transaction_api.get_number_value

168: l_payroll_id := hr_transaction_api.get_number_value
169: (p_transaction_step_id => l_asg_txn_step_id
170: ,p_name => 'P_PAYROLL_ID');
171:
172: l_assignment_id := hr_transaction_api.get_number_value
173: (p_transaction_step_id => l_asg_txn_step_id
174: ,p_name => 'P_ASSIGNMENT_ID');
175:
176: -- Now get the old pay basis id

Line 650: hr_transaction_api.get_varchar2_value

646: IF p_transaction_step_id IS NOT NULL
647: THEN
648: hr_utility.set_location(l_proc,10);
649: p_gsp_assignment :=
650: hr_transaction_api.get_varchar2_value
651: (p_transaction_step_id => p_transaction_step_id,
652: p_name =>'p_gsp_dummy_txn');
653: END IF;
654: hr_utility.set_location(' Leaving:' || l_proc,15);

Line 765: ln_txn_grade_ladder_id := hr_transaction_api.get_number_value

761: hr_utility.set_location(l_proc,30);
762: -- In a chained process navigated from the Assignment page.
763: -- Get the grade_ladder_id from the txn step
764: ln_transaction_step_id := p_asg_txn_step_id;
765: ln_txn_grade_ladder_id := hr_transaction_api.get_number_value
766: (p_transaction_step_id => ln_transaction_step_id
767: ,p_name => 'P_GRADE_LADDER_PGM_ID');
768:
769: p_new_grade_ladder_id := ln_txn_grade_ladder_id;

Line 804: ln_txn_grade_ladder_id := hr_transaction_api.get_number_value

800: -- to the Assignment page but user last stopped at the Pay Rate
801: -- page.
802: -- Get the grade_ladder_id from the txn step
803: -- p_asg_txn_step_id := ln_transaction_step_id;
804: ln_txn_grade_ladder_id := hr_transaction_api.get_number_value
805: (p_transaction_step_id => ln_transaction_step_id
806: ,p_name => 'P_GRADE_LADDER_PGM_ID');
807: p_new_grade_ladder_id := ln_txn_grade_ladder_id;
808:

Line 1102: ln_txn_pay_basis_id := hr_transaction_api.get_number_value

1098: hr_utility.set_location(l_proc,25);
1099: -- In a chained process navigated from the Assignment page.
1100: -- Get the pay_basis_id from the txn step
1101: ln_transaction_step_id := p_asg_txn_step_id;
1102: ln_txn_pay_basis_id := hr_transaction_api.get_number_value
1103: (p_transaction_step_id => ln_transaction_step_id
1104: ,p_name => 'P_PAY_BASIS_ID');
1105: p_new_pay_basis_id := ln_txn_pay_basis_id;
1106:

Line 1107: ln_payroll_id := hr_transaction_api.get_number_value

1103: (p_transaction_step_id => ln_transaction_step_id
1104: ,p_name => 'P_PAY_BASIS_ID');
1105: p_new_pay_basis_id := ln_txn_pay_basis_id;
1106:
1107: ln_payroll_id := hr_transaction_api.get_number_value
1108: (p_transaction_step_id => ln_transaction_step_id
1109: ,p_name => 'P_PAYROLL_ID');
1110:
1111: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value

Line 1111: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value

1107: ln_payroll_id := hr_transaction_api.get_number_value
1108: (p_transaction_step_id => ln_transaction_step_id
1109: ,p_name => 'P_PAYROLL_ID');
1110:
1111: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value
1112: (p_transaction_step_id => ln_transaction_step_id
1113: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1114:
1115: ln_job_id := hr_transaction_api.get_number_value

Line 1115: ln_job_id := hr_transaction_api.get_number_value

1111: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value
1112: (p_transaction_step_id => ln_transaction_step_id
1113: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1114:
1115: ln_job_id := hr_transaction_api.get_number_value
1116: (p_transaction_step_id => ln_transaction_step_id
1117: ,p_name => 'P_JOB_ID');
1118:
1119: -- 05/03/2002 Fix Begins

Line 1159: ln_txn_pay_basis_id := hr_transaction_api.get_number_value

1155: -- page.
1156: -- Get the value of pay basis id from the txn table.
1157: p_asg_txn_step_id := ln_transaction_step_id;
1158:
1159: ln_txn_pay_basis_id := hr_transaction_api.get_number_value
1160: (p_transaction_step_id => ln_transaction_step_id
1161: ,p_name => 'P_PAY_BASIS_ID');
1162:
1163: ln_payroll_id := hr_transaction_api.get_number_value

Line 1163: ln_payroll_id := hr_transaction_api.get_number_value

1159: ln_txn_pay_basis_id := hr_transaction_api.get_number_value
1160: (p_transaction_step_id => ln_transaction_step_id
1161: ,p_name => 'P_PAY_BASIS_ID');
1162:
1163: ln_payroll_id := hr_transaction_api.get_number_value
1164: (p_transaction_step_id => ln_transaction_step_id
1165: ,p_name => 'P_PAYROLL_ID');
1166:
1167: p_new_pay_basis_id := ln_txn_pay_basis_id;

Line 1169: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value

1165: ,p_name => 'P_PAYROLL_ID');
1166:
1167: p_new_pay_basis_id := ln_txn_pay_basis_id;
1168:
1169: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value
1170: (p_transaction_step_id => ln_transaction_step_id
1171: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1172:
1173:

Line 1174: ln_job_id := hr_transaction_api.get_number_value

1170: (p_transaction_step_id => ln_transaction_step_id
1171: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1172:
1173:
1174: ln_job_id := hr_transaction_api.get_number_value
1175: (p_transaction_step_id => ln_transaction_step_id
1176: ,p_name => 'P_JOB_ID');
1177:
1178: -- 05/03/2002 Fix Begins

Line 1885: hr_transaction_api.create_transaction(p_validate => false

1881: ,avalue => l_transaction_privilege);
1882: end if;
1883:
1884: -- call the BP API to create the transaction
1885: hr_transaction_api.create_transaction(p_validate => false
1886: ,p_creator_person_id => p_creator_person_id
1887: ,p_transaction_privilege => l_transaction_privilege
1888: ,p_transaction_id => l_transaction_id );
1889: -- set the TRANSACTION_ID

Line 2443: hr_transaction_api.get_number_value

2439: IF p_transaction_step_id IS NOT NULL
2440: THEN
2441: hr_utility.set_location(l_proc,10);
2442: ln_no_of_components :=
2443: hr_transaction_api.get_number_value
2444: (p_transaction_step_id => p_transaction_step_id,
2445: p_name => 'p_no_of_components');
2446:
2447: IF ln_no_of_components IS NOT NULL THEN

Line 2453: hr_transaction_api.get_varchar2_value

2449: no_of_components := ln_no_of_components;
2450: END IF;
2451:
2452: lv_pay_rate_type :=
2453: hr_transaction_api.get_varchar2_value
2454: (p_transaction_step_id => p_transaction_step_id,
2455: p_name => 'P_MULTIPLE_COMPONENTS');
2456:
2457: IF lv_pay_rate_type IS NOT NULL THEN

Line 2528: hr_transaction_api.get_transaction_step_info

2524:
2525: IF ln_transaction_id IS NOT NULL
2526: THEN
2527: hr_utility.set_location(l_proc,15);
2528: hr_transaction_api.get_transaction_step_info
2529: (p_Item_Type => p_item_type,
2530: p_Item_Key => p_item_key,
2531: p_activity_id =>p_act_id,
2532: p_transaction_step_id => ltt_trans_step_ids,

Line 2561: hr_transaction_api.get_number_value

2557: p_trans_step_id_tbl => ltt_trans_step_ids);
2558:
2559:
2560: ln_no_of_components :=
2561: hr_transaction_api.get_number_value
2562: (p_transaction_step_id => ln_transaction_step_id,
2563: p_name => 'p_no_of_components');
2564:
2565: IF ln_no_of_components IS NOT NULL THEN

Line 2573: hr_transaction_api.get_varchar2_value

2569:
2570: -- hr_utility.trace(' ln_no_of_components ' || ln_no_of_components);
2571:
2572: lv_pay_rate_type :=
2573: hr_transaction_api.get_varchar2_value
2574: (p_transaction_step_id => ln_transaction_step_id,
2575: p_name => 'P_MULTIPLE_COMPONENTS');
2576:
2577: IF lv_pay_rate_type IS NOT NULL THEN

Line 3800: hr_transaction_api.get_transaction_step_info

3796: --insert into dev_test values (' Created Txn');
3797: --commit;
3798:
3799: -- now we have a valid txn id , let's find out txn steps
3800: hr_transaction_api.get_transaction_step_info
3801: (p_Item_Type => p_item_type
3802: ,p_Item_Key => p_item_key
3803: ,p_activity_id => p_act_id
3804: ,p_transaction_step_id => ltt_trans_step_ids

Line 3818: hr_transaction_api.create_transaction_step

3814: --Create a step within this new transaction
3815:
3816: hr_utility.trace('create_transaction_step ');
3817:
3818: hr_transaction_api.create_transaction_step
3819: (p_validate => false
3820: ,p_creator_person_id => ln_creator_person_id
3821: ,p_transaction_id => ln_transaction_id
3822: ,p_api_name => lv_api_name

Line 4114: ln_assignment_id := hr_transaction_api.get_number_value

4110: if ln_transaction_step_id is not null then
4111: -- if an assignment step already exists then apply the
4112: -- assignment data
4113:
4114: ln_assignment_id := hr_transaction_api.get_number_value
4115: (p_transaction_step_id => ln_transaction_step_id
4116: ,p_name => 'P_ASSIGNMENT_ID');
4117:
4118: ln_job_id := hr_transaction_api.get_number_value

Line 4118: ln_job_id := hr_transaction_api.get_number_value

4114: ln_assignment_id := hr_transaction_api.get_number_value
4115: (p_transaction_step_id => ln_transaction_step_id
4116: ,p_name => 'P_ASSIGNMENT_ID');
4117:
4118: ln_job_id := hr_transaction_api.get_number_value
4119: (p_transaction_step_id => ln_transaction_step_id
4120: ,p_name => 'P_JOB_ID');
4121:
4122: -- Must set the element warning to TRUE so that the ASG wrapper will

Line 4434: hr_transaction_api.get_transaction_step_info

4430: IF ln_transaction_id IS NOT NULL
4431: THEN
4432: hr_utility.set_location(l_proc,10);
4433: -- hr_utility.trace('Transaction Exists');
4434: hr_transaction_api.get_transaction_step_info
4435: (p_Item_Type => p_item_type,
4436: p_Item_Key => p_item_key,
4437: p_activity_id =>p_act_id,
4438: p_transaction_step_id => ltt_trans_step_ids,

Line 4468: hr_transaction_api.get_number_value

4464: -- hr_utility.trace(' ln_transaction_step_id ' || ln_transaction_step_id);
4465:
4466: -- now get the individual salary data
4467: p_ltt_salary_data(1).current_salary :=
4468: hr_transaction_api.get_number_value
4469: (p_transaction_step_id => ln_transaction_step_id,
4470: p_name =>'p_current_salary');
4471:
4472: -- hr_utility.trace(' p_current_salary ' || p_ltt_salary_data(1).current_salary);

Line 4475: hr_transaction_api.get_number_value

4471:
4472: -- hr_utility.trace(' p_current_salary ' || p_ltt_salary_data(1).current_salary);
4473:
4474: p_ltt_salary_data(1).assignment_id :=
4475: hr_transaction_api.get_number_value
4476: (p_transaction_step_id => ln_transaction_step_id,
4477: p_name =>'p_assignment_id');
4478:
4479:

Line 4482: hr_transaction_api.get_number_value

4478:
4479:
4480:
4481: p_ltt_salary_data(1).business_group_id :=
4482: hr_transaction_api.get_number_value
4483: (p_transaction_step_id => ln_transaction_step_id,
4484: p_name =>'p_bus_group_id');
4485:
4486: -- hr_utility.trace(' p_bus_group_id ' || p_ltt_salary_data(1).business_group_id);

Line 4489: hr_transaction_api.get_date_value

4485:
4486: -- hr_utility.trace(' p_bus_group_id ' || p_ltt_salary_data(1).business_group_id);
4487:
4488: p_ltt_salary_data(1).effective_date :=
4489: hr_transaction_api.get_date_value
4490: (p_transaction_step_id => ln_transaction_step_id,
4491: p_name =>'p_effective_date');
4492:
4493: -- GSP change

Line 4495: hr_transaction_api.get_date_value

4491: p_name =>'p_effective_date');
4492:
4493: -- GSP change
4494: p_ltt_salary_data(1).salary_effective_date :=
4495: hr_transaction_api.get_date_value
4496: (p_transaction_step_id => ln_transaction_step_id,
4497: p_name =>'p_effective_date');
4498:
4499: p_ltt_salary_data(1).gsp_dummy_txn :=

Line 4500: hr_transaction_api.get_varchar2_value

4496: (p_transaction_step_id => ln_transaction_step_id,
4497: p_name =>'p_effective_date');
4498:
4499: p_ltt_salary_data(1).gsp_dummy_txn :=
4500: hr_transaction_api.get_varchar2_value
4501: (p_transaction_step_id => ln_transaction_step_id,
4502: p_name =>'p_gsp_dummy_txn');
4503: --End of GSP change
4504:

Line 4506: hr_transaction_api.get_number_value

4502: p_name =>'p_gsp_dummy_txn');
4503: --End of GSP change
4504:
4505: p_ltt_salary_data(1).salary_change_amount:=
4506: hr_transaction_api.get_number_value
4507: (p_transaction_step_id => ln_transaction_step_id,
4508: p_name =>'p_change_amount');
4509:
4510: -- hr_utility.trace(' p_change_amount ' || p_ltt_salary_data(1).salary_change_amount);

Line 4513: hr_transaction_api.get_number_value

4509:
4510: -- hr_utility.trace(' p_change_amount ' || p_ltt_salary_data(1).salary_change_amount);
4511:
4512: p_ltt_salary_data(1).annual_change:=
4513: hr_transaction_api.get_number_value
4514: (p_transaction_step_id => ln_transaction_step_id,
4515: p_name =>'p_annual_change');
4516:
4517: -- hr_utility.trace(' p_annual_change ' || p_ltt_salary_data(1).annual_change);

Line 4521: hr_transaction_api.get_number_value

4517: -- hr_utility.trace(' p_annual_change ' || p_ltt_salary_data(1).annual_change);
4518:
4519:
4520: p_ltt_salary_data(1).salary_change_percent:=
4521: hr_transaction_api.get_number_value
4522: (p_transaction_step_id => ln_transaction_step_id,
4523: p_name =>'p_change_percent');
4524:
4525: p_ltt_salary_data(1).proposed_salary:=

Line 4526: hr_transaction_api.get_number_value

4522: (p_transaction_step_id => ln_transaction_step_id,
4523: p_name =>'p_change_percent');
4524:
4525: p_ltt_salary_data(1).proposed_salary:=
4526: hr_transaction_api.get_number_value
4527: (p_transaction_step_id => ln_transaction_step_id,
4528: p_name => 'p_proposed_salary');
4529:
4530: p_ltt_salary_data(1).proposal_reason:=

Line 4531: hr_transaction_api.get_varchar2_value

4527: (p_transaction_step_id => ln_transaction_step_id,
4528: p_name => 'p_proposed_salary');
4529:
4530: p_ltt_salary_data(1).proposal_reason:=
4531: hr_transaction_api.get_varchar2_value
4532: (p_transaction_step_id => ln_transaction_step_id,
4533: p_name => 'p_proposal_reason');
4534:
4535: p_ltt_salary_data(1).currency:=

Line 4536: hr_transaction_api.get_varchar2_value

4532: (p_transaction_step_id => ln_transaction_step_id,
4533: p_name => 'p_proposal_reason');
4534:
4535: p_ltt_salary_data(1).currency:=
4536: hr_transaction_api.get_varchar2_value
4537: (p_transaction_step_id => ln_transaction_step_id,
4538: p_name => 'p_currency');
4539:
4540:

Line 4542: hr_transaction_api.get_varchar2_value

4538: p_name => 'p_currency');
4539:
4540:
4541: p_ltt_salary_data(1).pay_basis_name:=
4542: hr_transaction_api.get_varchar2_value
4543: (p_transaction_step_id => ln_transaction_step_id,
4544: p_name => 'p_pay_basis_name');
4545:
4546: p_ltt_salary_data(1).element_entry_id:=

Line 4547: hr_transaction_api.get_number_value

4543: (p_transaction_step_id => ln_transaction_step_id,
4544: p_name => 'p_pay_basis_name');
4545:
4546: p_ltt_salary_data(1).element_entry_id:=
4547: hr_transaction_api.get_number_value
4548: (p_transaction_step_id => ln_transaction_step_id,
4549: p_name => 'p_element_entry_id');
4550:
4551:

Line 4553: hr_transaction_api.get_number_value

4549: p_name => 'p_element_entry_id');
4550:
4551:
4552: p_ltt_salary_data(1).annual_equivalent:=
4553: hr_transaction_api.get_number_value
4554: (p_transaction_step_id => ln_transaction_step_id,
4555: p_name => 'p_annual_equivalent');
4556:
4557:

Line 4559: hr_transaction_api.get_number_value

4555: p_name => 'p_annual_equivalent');
4556:
4557:
4558: p_ltt_salary_data(1).total_percent:=
4559: hr_transaction_api.get_number_value
4560: (p_transaction_step_id => ln_transaction_step_id,
4561: p_name => 'p_total_percent');
4562:
4563: p_ltt_salary_data(1).selection_mode:=

Line 4564: hr_transaction_api.get_varchar2_value

4560: (p_transaction_step_id => ln_transaction_step_id,
4561: p_name => 'p_total_percent');
4562:
4563: p_ltt_salary_data(1).selection_mode:=
4564: hr_transaction_api.get_varchar2_value
4565: (p_transaction_step_id => ln_transaction_step_id,
4566: p_name => 'p_selection_mode');
4567:
4568: p_ltt_salary_data(1).quartile:=

Line 4569: hr_transaction_api.get_number_value

4565: (p_transaction_step_id => ln_transaction_step_id,
4566: p_name => 'p_selection_mode');
4567:
4568: p_ltt_salary_data(1).quartile:=
4569: hr_transaction_api.get_number_value
4570: (p_transaction_step_id => ln_transaction_step_id,
4571: p_name => 'p_quartile');
4572:
4573: p_ltt_salary_data(1).comparatio:=

Line 4574: hr_transaction_api.get_number_value

4570: (p_transaction_step_id => ln_transaction_step_id,
4571: p_name => 'p_quartile');
4572:
4573: p_ltt_salary_data(1).comparatio:=
4574: hr_transaction_api.get_number_value
4575: (p_transaction_step_id => ln_transaction_step_id,
4576: p_name => 'p_comparatio');
4577:
4578: p_ltt_salary_data(1).ranking:=

Line 4579: hr_transaction_api.get_number_value

4575: (p_transaction_step_id => ln_transaction_step_id,
4576: p_name => 'p_comparatio');
4577:
4578: p_ltt_salary_data(1).ranking:=
4579: hr_transaction_api.get_number_value
4580: (p_transaction_step_id => ln_transaction_step_id,
4581: p_name => 'p_ranking');
4582:
4583:

Line 4585: hr_transaction_api.get_varchar2_value

4581: p_name => 'p_ranking');
4582:
4583:
4584: p_ltt_salary_data(1).multiple_components:=
4585: hr_transaction_api.get_varchar2_value
4586: (p_transaction_step_id => ln_transaction_step_id,
4587: p_name => 'p_multiple_components');
4588:
4589:

Line 4591: hr_transaction_api.get_varchar2_value

4587: p_name => 'p_multiple_components');
4588:
4589:
4590: p_ltt_salary_data(1).comments:=
4591: hr_transaction_api.get_varchar2_value
4592: (p_transaction_step_id => ln_transaction_step_id,
4593: p_name => 'p_comments');
4594:
4595:

Line 4597: hr_transaction_api.get_varchar2_value (

4593: p_name => 'p_comments');
4594:
4595:
4596: p_ltt_salary_data(1).attribute_category :=
4597: hr_transaction_api.get_varchar2_value (
4598: p_transaction_step_id => ln_transaction_step_id,
4599: p_name => 'p_attribute_category'
4600: );
4601:

Line 4603: hr_transaction_api.get_varchar2_value (

4599: p_name => 'p_attribute_category'
4600: );
4601:
4602: p_ltt_salary_data(1).attribute1 :=
4603: hr_transaction_api.get_varchar2_value (
4604: p_transaction_step_id => ln_transaction_step_id,
4605: p_name => 'p_attribute1'
4606: );
4607:

Line 4611: hr_transaction_api.get_varchar2_value (

4607:
4608: -- hr_utility.trace(' p_attribute1 ' || p_ltt_salary_data(1).attribute1);
4609:
4610: p_ltt_salary_data(1).attribute2 :=
4611: hr_transaction_api.get_varchar2_value (
4612: p_transaction_step_id => ln_transaction_step_id,
4613: p_name => 'p_attribute2'
4614: );
4615:

Line 4619: hr_transaction_api.get_varchar2_value (

4615:
4616: -- hr_utility.trace(' p_attribute2 ' || p_ltt_salary_data(1).attribute2);
4617:
4618: p_ltt_salary_data(1).attribute3 :=
4619: hr_transaction_api.get_varchar2_value (
4620: p_transaction_step_id => ln_transaction_step_id,
4621: p_name => 'p_attribute3'
4622: );
4623:

Line 4625: hr_transaction_api.get_varchar2_value (

4621: p_name => 'p_attribute3'
4622: );
4623:
4624: p_ltt_salary_data(1).attribute4 :=
4625: hr_transaction_api.get_varchar2_value (
4626: p_transaction_step_id => ln_transaction_step_id,
4627: p_name => 'p_attribute4'
4628: );
4629:

Line 4632: hr_transaction_api.get_varchar2_value (

4628: );
4629:
4630:
4631: p_ltt_salary_data(1).attribute5 :=
4632: hr_transaction_api.get_varchar2_value (
4633: p_transaction_step_id => ln_transaction_step_id,
4634: p_name => 'p_attribute5'
4635: );
4636:

Line 4638: hr_transaction_api.get_varchar2_value (

4634: p_name => 'p_attribute5'
4635: );
4636:
4637: p_ltt_salary_data(1).attribute6 :=
4638: hr_transaction_api.get_varchar2_value (
4639: p_transaction_step_id => ln_transaction_step_id,
4640: p_name => 'p_attribute6'
4641: );
4642:

Line 4645: hr_transaction_api.get_varchar2_value (

4641: );
4642:
4643:
4644: p_ltt_salary_data(1).attribute7 :=
4645: hr_transaction_api.get_varchar2_value (
4646: p_transaction_step_id => ln_transaction_step_id,
4647: p_name => 'p_attribute7'
4648: );
4649:

Line 4651: hr_transaction_api.get_varchar2_value (

4647: p_name => 'p_attribute7'
4648: );
4649:
4650: p_ltt_salary_data(1).attribute8 :=
4651: hr_transaction_api.get_varchar2_value (
4652: p_transaction_step_id => ln_transaction_step_id,
4653: p_name => 'p_attribute8'
4654: );
4655:

Line 4657: hr_transaction_api.get_varchar2_value (

4653: p_name => 'p_attribute8'
4654: );
4655:
4656: p_ltt_salary_data(1).attribute9 :=
4657: hr_transaction_api.get_varchar2_value (
4658: p_transaction_step_id => ln_transaction_step_id,
4659: p_name => 'p_attribute9'
4660: );
4661:

Line 4663: hr_transaction_api.get_varchar2_value (

4659: p_name => 'p_attribute9'
4660: );
4661:
4662: p_ltt_salary_data(1).attribute10 :=
4663: hr_transaction_api.get_varchar2_value (
4664: p_transaction_step_id => ln_transaction_step_id,
4665: p_name => 'p_attribute10'
4666: );
4667:

Line 4669: hr_transaction_api.get_varchar2_value (

4665: p_name => 'p_attribute10'
4666: );
4667:
4668: p_ltt_salary_data(1).attribute11 :=
4669: hr_transaction_api.get_varchar2_value (
4670: p_transaction_step_id => ln_transaction_step_id,
4671: p_name => 'p_attribute11'
4672: );
4673:

Line 4675: hr_transaction_api.get_varchar2_value (

4671: p_name => 'p_attribute11'
4672: );
4673:
4674: p_ltt_salary_data(1).attribute12 :=
4675: hr_transaction_api.get_varchar2_value (
4676: p_transaction_step_id => ln_transaction_step_id,
4677: p_name => 'p_attribute12'
4678: );
4679:

Line 4681: hr_transaction_api.get_varchar2_value (

4677: p_name => 'p_attribute12'
4678: );
4679:
4680: p_ltt_salary_data(1).attribute13 :=
4681: hr_transaction_api.get_varchar2_value (
4682: p_transaction_step_id => ln_transaction_step_id,
4683: p_name => 'p_attribute13'
4684: );
4685:

Line 4687: hr_transaction_api.get_varchar2_value (

4683: p_name => 'p_attribute13'
4684: );
4685:
4686: p_ltt_salary_data(1).attribute14 :=
4687: hr_transaction_api.get_varchar2_value (
4688: p_transaction_step_id => ln_transaction_step_id,
4689: p_name => 'p_attribute14'
4690: );
4691:

Line 4693: hr_transaction_api.get_varchar2_value (

4689: p_name => 'p_attribute14'
4690: );
4691:
4692: p_ltt_salary_data(1).attribute15 :=
4693: hr_transaction_api.get_varchar2_value (
4694: p_transaction_step_id => ln_transaction_step_id,
4695: p_name => 'p_attribute15'
4696: );
4697:

Line 4699: hr_transaction_api.get_varchar2_value (

4695: p_name => 'p_attribute15'
4696: );
4697:
4698: p_ltt_salary_data(1).attribute16 :=
4699: hr_transaction_api.get_varchar2_value (
4700: p_transaction_step_id => ln_transaction_step_id,
4701: p_name => 'p_attribute16'
4702: );
4703:

Line 4706: hr_transaction_api.get_varchar2_value (

4702: );
4703:
4704:
4705: p_ltt_salary_data(1).attribute17 :=
4706: hr_transaction_api.get_varchar2_value (
4707: p_transaction_step_id => ln_transaction_step_id,
4708: p_name => 'p_attribute17'
4709: );
4710:

Line 4712: hr_transaction_api.get_varchar2_value (

4708: p_name => 'p_attribute17'
4709: );
4710:
4711: p_ltt_salary_data(1).attribute18 :=
4712: hr_transaction_api.get_varchar2_value (
4713: p_transaction_step_id => ln_transaction_step_id,
4714: p_name => 'p_attribute18'
4715: );
4716:

Line 4718: hr_transaction_api.get_varchar2_value (

4714: p_name => 'p_attribute18'
4715: );
4716:
4717: p_ltt_salary_data(1).attribute19 :=
4718: hr_transaction_api.get_varchar2_value (
4719: p_transaction_step_id => ln_transaction_step_id,
4720: p_name => 'p_attribute19'
4721: );
4722:

Line 4724: hr_transaction_api.get_varchar2_value (

4720: p_name => 'p_attribute19'
4721: );
4722:
4723: p_ltt_salary_data(1).attribute20 :=
4724: hr_transaction_api.get_varchar2_value (
4725: p_transaction_step_id => ln_transaction_step_id,
4726: p_name => 'p_attribute20'
4727: );
4728:

Line 4730: hr_transaction_api.get_number_value (

4726: p_name => 'p_attribute20'
4727: );
4728:
4729: p_ltt_salary_data(1).no_of_components :=
4730: hr_transaction_api.get_number_value (
4731: p_transaction_step_id => ln_transaction_step_id,
4732: p_name => 'p_no_of_components'
4733: );
4734:

Line 4737: hr_transaction_api.get_varchar2_value (

4733: );
4734:
4735: -- 04/12/02 Salary Basis Enhancement Begins
4736: p_ltt_salary_data(1).salary_basis_change_type :=
4737: hr_transaction_api.get_varchar2_value (
4738: p_transaction_step_id => ln_transaction_step_id,
4739: p_name => 'p_salary_basis_change_type'
4740: );
4741:

Line 4743: hr_transaction_api.get_date_value (

4739: p_name => 'p_salary_basis_change_type'
4740: );
4741:
4742: p_ltt_salary_data(1).default_date :=
4743: hr_transaction_api.get_date_value (
4744: p_transaction_step_id => ln_transaction_step_id,
4745: p_name => 'p_default_date'
4746: );
4747:

Line 4749: hr_transaction_api.get_number_value (

4745: p_name => 'p_default_date'
4746: );
4747:
4748: p_ltt_salary_data(1).default_bg_id :=
4749: hr_transaction_api.get_number_value (
4750: p_transaction_step_id => ln_transaction_step_id,
4751: p_name => 'p_default_bg_id'
4752: );
4753:

Line 4755: hr_transaction_api.get_varchar2_value (

4751: p_name => 'p_default_bg_id'
4752: );
4753:
4754: p_ltt_salary_data(1).default_currency :=
4755: hr_transaction_api.get_varchar2_value (
4756: p_transaction_step_id => ln_transaction_step_id,
4757: p_name => 'p_default_currency'
4758: );
4759:

Line 4761: hr_transaction_api.get_varchar2_value (

4757: p_name => 'p_default_currency'
4758: );
4759:
4760: p_ltt_salary_data(1).default_format_string :=
4761: hr_transaction_api.get_varchar2_value (
4762: p_transaction_step_id => ln_transaction_step_id,
4763: p_name => 'p_default_format_string'
4764: );
4765:

Line 4767: hr_transaction_api.get_varchar2_value (

4763: p_name => 'p_default_format_string'
4764: );
4765:
4766: p_ltt_salary_data(1).default_salary_basis_name :=
4767: hr_transaction_api.get_varchar2_value (
4768: p_transaction_step_id => ln_transaction_step_id,
4769: p_name => 'p_default_salary_basis_name'
4770: );
4771:

Line 4773: hr_transaction_api.get_varchar2_value (

4769: p_name => 'p_default_salary_basis_name'
4770: );
4771:
4772: p_ltt_salary_data(1).default_pay_basis_name :=
4773: hr_transaction_api.get_varchar2_value (
4774: p_transaction_step_id => ln_transaction_step_id,
4775: p_name => 'p_default_pay_basis_name'
4776: );
4777:

Line 4779: hr_transaction_api.get_varchar2_value (

4775: p_name => 'p_default_pay_basis_name'
4776: );
4777:
4778: p_ltt_salary_data(1).default_pay_basis :=
4779: hr_transaction_api.get_varchar2_value (
4780: p_transaction_step_id => ln_transaction_step_id,
4781: p_name => 'p_default_pay_basis'
4782: );
4783:

Line 4785: hr_transaction_api.get_number_value (

4781: p_name => 'p_default_pay_basis'
4782: );
4783:
4784: p_ltt_salary_data(1).default_pay_annual_factor :=
4785: hr_transaction_api.get_number_value (
4786: p_transaction_step_id => ln_transaction_step_id,
4787: p_name => 'p_default_pay_annual_factor'
4788: );
4789:

Line 4791: hr_transaction_api.get_varchar2_value (

4787: p_name => 'p_default_pay_annual_factor'
4788: );
4789:
4790: p_ltt_salary_data(1).default_grade :=
4791: hr_transaction_api.get_varchar2_value (
4792: p_transaction_step_id => ln_transaction_step_id,
4793: p_name => 'p_default_grade'
4794: );
4795:

Line 4797: hr_transaction_api.get_number_value (

4793: p_name => 'p_default_grade'
4794: );
4795:
4796: p_ltt_salary_data(1).default_grade_annual_factor :=
4797: hr_transaction_api.get_number_value (
4798: p_transaction_step_id => ln_transaction_step_id,
4799: p_name => 'p_default_grade_annual_factor'
4800: );
4801:

Line 4803: hr_transaction_api.get_number_value (

4799: p_name => 'p_default_grade_annual_factor'
4800: );
4801:
4802: p_ltt_salary_data(1).default_minimum_salary :=
4803: hr_transaction_api.get_number_value (
4804: p_transaction_step_id => ln_transaction_step_id,
4805: p_name => 'p_default_minimum_salary'
4806: );
4807:

Line 4809: hr_transaction_api.get_number_value (

4805: p_name => 'p_default_minimum_salary'
4806: );
4807:
4808: p_ltt_salary_data(1).default_maximum_salary :=
4809: hr_transaction_api.get_number_value (
4810: p_transaction_step_id => ln_transaction_step_id,
4811: p_name => 'p_default_maximum_salary'
4812: );
4813:

Line 4815: hr_transaction_api.get_number_value (

4811: p_name => 'p_default_maximum_salary'
4812: );
4813:
4814: p_ltt_salary_data(1).default_midpoint_salary :=
4815: hr_transaction_api.get_number_value (
4816: p_transaction_step_id => ln_transaction_step_id,
4817: p_name => 'p_default_midpoint_salary'
4818: );
4819:

Line 4821: hr_transaction_api.get_number_value (

4817: p_name => 'p_default_midpoint_salary'
4818: );
4819:
4820: p_ltt_salary_data(1).default_prev_salary :=
4821: hr_transaction_api.get_number_value (
4822: p_transaction_step_id => ln_transaction_step_id,
4823: p_name => 'p_default_prev_salary'
4824: );
4825:

Line 4827: hr_transaction_api.get_date_value (

4823: p_name => 'p_default_prev_salary'
4824: );
4825:
4826: p_ltt_salary_data(1).default_last_change_date :=
4827: hr_transaction_api.get_date_value (
4828: p_transaction_step_id => ln_transaction_step_id,
4829: p_name => 'p_default_last_change_date'
4830: );
4831:

Line 4833: hr_transaction_api.get_number_value (

4829: p_name => 'p_default_last_change_date'
4830: );
4831:
4832: p_ltt_salary_data(1).default_element_entry_id :=
4833: hr_transaction_api.get_number_value (
4834: p_transaction_step_id => ln_transaction_step_id,
4835: p_name => 'p_default_element_entry_id'
4836: );
4837:

Line 4839: hr_transaction_api.get_number_value (

4835: p_name => 'p_default_element_entry_id'
4836: );
4837:
4838: p_ltt_salary_data(1).default_basis_changed :=
4839: hr_transaction_api.get_number_value (
4840: p_transaction_step_id => ln_transaction_step_id,
4841: p_name => 'p_default_basis_changed'
4842: );
4843:

Line 4845: hr_transaction_api.get_varchar2_value (

4841: p_name => 'p_default_basis_changed'
4842: );
4843:
4844: p_ltt_salary_data(1).default_uom :=
4845: hr_transaction_api.get_varchar2_value (
4846: p_transaction_step_id => ln_transaction_step_id,
4847: p_name => 'p_default_uom'
4848: );
4849:

Line 4851: hr_transaction_api.get_varchar2_value (

4847: p_name => 'p_default_uom'
4848: );
4849:
4850: p_ltt_salary_data(1).default_grade_uom :=
4851: hr_transaction_api.get_varchar2_value (
4852: p_transaction_step_id => ln_transaction_step_id,
4853: p_name => 'p_default_grade_uom'
4854: );
4855:

Line 4857: hr_transaction_api.get_number_value (

4853: p_name => 'p_default_grade_uom'
4854: );
4855:
4856: p_ltt_salary_data(1).default_change_amount :=
4857: hr_transaction_api.get_number_value (
4858: p_transaction_step_id => ln_transaction_step_id,
4859: p_name => 'p_default_change_amount'
4860: );
4861:

Line 4863: hr_transaction_api.get_number_value (

4859: p_name => 'p_default_change_amount'
4860: );
4861:
4862: p_ltt_salary_data(1).default_change_percent :=
4863: hr_transaction_api.get_number_value (
4864: p_transaction_step_id => ln_transaction_step_id,
4865: p_name => 'p_default_change_percent'
4866: );
4867:

Line 4869: hr_transaction_api.get_number_value (

4865: p_name => 'p_default_change_percent'
4866: );
4867:
4868: p_ltt_salary_data(1).default_quartile :=
4869: hr_transaction_api.get_number_value (
4870: p_transaction_step_id => ln_transaction_step_id,
4871: p_name => 'p_default_quartile'
4872: );
4873:

Line 4875: hr_transaction_api.get_number_value (

4871: p_name => 'p_default_quartile'
4872: );
4873:
4874: p_ltt_salary_data(1).default_comparatio :=
4875: hr_transaction_api.get_number_value (
4876: p_transaction_step_id => ln_transaction_step_id,
4877: p_name => 'p_default_comparatio'
4878: );
4879:

Line 4881: hr_transaction_api.get_varchar2_value (

4877: p_name => 'p_default_comparatio'
4878: );
4879:
4880: p_ltt_salary_data(1).default_last_pay_change :=
4881: hr_transaction_api.get_varchar2_value (
4882: p_transaction_step_id => ln_transaction_step_id,
4883: p_name => 'p_default_last_pay_change'
4884: );
4885:

Line 4887: hr_transaction_api.get_varchar2_value (

4883: p_name => 'p_default_last_pay_change'
4884: );
4885:
4886: p_ltt_salary_data(1).default_flsa_status :=
4887: hr_transaction_api.get_varchar2_value (
4888: p_transaction_step_id => ln_transaction_step_id,
4889: p_name => 'p_default_flsa_status'
4890: );
4891:

Line 4893: hr_transaction_api.get_varchar2_value (

4889: p_name => 'p_default_flsa_status'
4890: );
4891:
4892: p_ltt_salary_data(1).default_currency_symbol :=
4893: hr_transaction_api.get_varchar2_value (
4894: p_transaction_step_id => ln_transaction_step_id,
4895: p_name => 'p_default_currency_symbol'
4896: );
4897:

Line 4899: hr_transaction_api.get_number_value (

4895: p_name => 'p_default_currency_symbol'
4896: );
4897:
4898: p_ltt_salary_data(1).default_precision :=
4899: hr_transaction_api.get_number_value (
4900: p_transaction_step_id => ln_transaction_step_id,
4901: p_name => 'p_default_precision'
4902: );
4903:

Line 4910: hr_transaction_api.get_number_value

4906: -- hr_utility.trace('Populated Proposal Values');
4907:
4908: -- now get the component records
4909: ln_no_of_components :=
4910: hr_transaction_api.get_number_value
4911: (p_transaction_step_id => ln_transaction_step_id,
4912: p_name => 'p_no_of_components');
4913:
4914: -- hr_utility.trace('ln_no_of_components' || ln_no_of_components);

Line 4921: hr_transaction_api.get_number_value

4917: LOOP
4918:
4919: -- hr_utility.trace(' Retrieving ' || i || ' compoent ');
4920: p_ltt_component(i).change_amount :=
4921: hr_transaction_api.get_number_value
4922: (p_transaction_step_id => ln_transaction_step_id,
4923: p_name => 'p_change_amount'||i);
4924: -- hr_utility.trace('change_amount ' || p_ltt_component(i).change_amount);
4925:

Line 4929: hr_transaction_api.get_varchar2_value

4925:
4926:
4927:
4928: p_ltt_component(i).component_reason :=
4929: hr_transaction_api.get_varchar2_value
4930: (p_transaction_step_id => ln_transaction_step_id,
4931: p_name => 'p_component_reason'||i);
4932: -- hr_utility.trace('p_component_reason ' || p_ltt_component(i).component_reason);
4933:

Line 4935: hr_transaction_api.get_varchar2_value

4931: p_name => 'p_component_reason'||i);
4932: -- hr_utility.trace('p_component_reason ' || p_ltt_component(i).component_reason);
4933:
4934: p_ltt_component(i).reason_meaning :=
4935: hr_transaction_api.get_varchar2_value
4936: (p_transaction_step_id => ln_transaction_step_id,
4937: p_name => 'p_reason_meaning'||i);
4938: -- hr_utility.trace('p_reason_meaning ' || p_ltt_component(i).reason_meaning);
4939:

Line 4949: hr_transaction_api.get_number_value

4945: hr_utility.trace('reason_meaning ' || p_ltt_component(i).reason_meaning);
4946: */
4947:
4948: p_ltt_component(i).change_percent :=
4949: hr_transaction_api.get_number_value
4950: (p_transaction_step_id => ln_transaction_step_id,
4951: p_name => 'p_change_percent'||i);
4952:
4953: -- hr_utility.trace('p_change_percent ' || p_ltt_component(i).change_percent);

Line 4956: hr_transaction_api.get_number_value

4952:
4953: -- hr_utility.trace('p_change_percent ' || p_ltt_component(i).change_percent);
4954:
4955: p_ltt_component(i).change_annual :=
4956: hr_transaction_api.get_number_value
4957: (p_transaction_step_id => ln_transaction_step_id,
4958: p_name => 'p_change_annual'||i);
4959:
4960: p_ltt_component(i).comments :=

Line 4961: hr_transaction_api.get_varchar2_value

4957: (p_transaction_step_id => ln_transaction_step_id,
4958: p_name => 'p_change_annual'||i);
4959:
4960: p_ltt_component(i).comments :=
4961: hr_transaction_api.get_varchar2_value
4962: (p_transaction_step_id => ln_transaction_step_id,
4963: p_name => 'p_comments'||i);
4964:
4965:

Line 4967: hr_transaction_api.get_varchar2_value

4963: p_name => 'p_comments'||i);
4964:
4965:
4966: p_ltt_component(i).approved :=
4967: hr_transaction_api.get_varchar2_value
4968: (p_transaction_step_id => ln_transaction_step_id,
4969: p_name => 'p_approved'||i);
4970:
4971: p_ltt_component(i).attribute_category :=

Line 4972: hr_transaction_api.get_varchar2_value

4968: (p_transaction_step_id => ln_transaction_step_id,
4969: p_name => 'p_approved'||i);
4970:
4971: p_ltt_component(i).attribute_category :=
4972: hr_transaction_api.get_varchar2_value
4973: (p_transaction_step_id => ln_transaction_step_id,
4974: p_name => 'p_cattribute_category'||i);
4975:
4976: p_ltt_component(i).attribute1 :=

Line 4977: hr_transaction_api.get_varchar2_value

4973: (p_transaction_step_id => ln_transaction_step_id,
4974: p_name => 'p_cattribute_category'||i);
4975:
4976: p_ltt_component(i).attribute1 :=
4977: hr_transaction_api.get_varchar2_value
4978: (p_transaction_step_id => ln_transaction_step_id,
4979: p_name => 'p_cattribute1'||i);
4980:
4981: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute1);

Line 4985: hr_transaction_api.get_varchar2_value

4981: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute1);
4982:
4983:
4984: p_ltt_component(i).attribute2:=
4985: hr_transaction_api.get_varchar2_value
4986: (p_transaction_step_id => ln_transaction_step_id,
4987: p_name => 'p_cattribute2'||i);
4988:
4989: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute2);

Line 4993: hr_transaction_api.get_varchar2_value

4989: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute2);
4990:
4991:
4992: p_ltt_component(i).attribute3 :=
4993: hr_transaction_api.get_varchar2_value
4994: (p_transaction_step_id => ln_transaction_step_id,
4995: p_name => 'p_cattribute3'||i);
4996:
4997: -- hr_utility.trace('p_cattribute1 ');

Line 5000: hr_transaction_api.get_varchar2_value

4996:
4997: -- hr_utility.trace('p_cattribute1 ');
4998:
4999: p_ltt_component(i).attribute4 :=
5000: hr_transaction_api.get_varchar2_value
5001: (p_transaction_step_id => ln_transaction_step_id,
5002: p_name => 'p_cattribute4'||i);
5003:
5004: p_ltt_component(i).attribute5 :=

Line 5005: hr_transaction_api.get_varchar2_value

5001: (p_transaction_step_id => ln_transaction_step_id,
5002: p_name => 'p_cattribute4'||i);
5003:
5004: p_ltt_component(i).attribute5 :=
5005: hr_transaction_api.get_varchar2_value
5006: (p_transaction_step_id => ln_transaction_step_id,
5007: p_name => 'p_cattribute5'||i);
5008:
5009: -- hr_utility.trace('p_cattribute5 ');

Line 5012: hr_transaction_api.get_varchar2_value

5008:
5009: -- hr_utility.trace('p_cattribute5 ');
5010:
5011: p_ltt_component(i).attribute6 :=
5012: hr_transaction_api.get_varchar2_value
5013: (p_transaction_step_id => ln_transaction_step_id,
5014: p_name => 'p_cattribute6'||i);
5015:
5016: p_ltt_component(i).attribute7 :=

Line 5017: hr_transaction_api.get_varchar2_value

5013: (p_transaction_step_id => ln_transaction_step_id,
5014: p_name => 'p_cattribute6'||i);
5015:
5016: p_ltt_component(i).attribute7 :=
5017: hr_transaction_api.get_varchar2_value
5018: (p_transaction_step_id => ln_transaction_step_id,
5019: p_name => 'p_cattribute7'||i);
5020:
5021: -- hr_utility.trace('p_cattribute7 ');

Line 5025: hr_transaction_api.get_varchar2_value

5021: -- hr_utility.trace('p_cattribute7 ');
5022:
5023:
5024: p_ltt_component(i).attribute8 :=
5025: hr_transaction_api.get_varchar2_value
5026: (p_transaction_step_id => ln_transaction_step_id,
5027: p_name => 'p_cattribute8'||i);
5028:
5029: p_ltt_component(i).attribute9 :=

Line 5030: hr_transaction_api.get_varchar2_value

5026: (p_transaction_step_id => ln_transaction_step_id,
5027: p_name => 'p_cattribute8'||i);
5028:
5029: p_ltt_component(i).attribute9 :=
5030: hr_transaction_api.get_varchar2_value
5031: (p_transaction_step_id => ln_transaction_step_id,
5032: p_name => 'p_cattribute9'||i);
5033:
5034: -- hr_utility.trace('p_cattribute9 ');

Line 5037: hr_transaction_api.get_varchar2_value

5033:
5034: -- hr_utility.trace('p_cattribute9 ');
5035:
5036: p_ltt_component(i).attribute10 :=
5037: hr_transaction_api.get_varchar2_value
5038: (p_transaction_step_id => ln_transaction_step_id,
5039: p_name => 'p_cattribute10'||i);
5040:
5041: p_ltt_component(i).attribute11 :=

Line 5042: hr_transaction_api.get_varchar2_value

5038: (p_transaction_step_id => ln_transaction_step_id,
5039: p_name => 'p_cattribute10'||i);
5040:
5041: p_ltt_component(i).attribute11 :=
5042: hr_transaction_api.get_varchar2_value
5043: (p_transaction_step_id => ln_transaction_step_id,
5044: p_name => 'p_cattribute11'||i);
5045:
5046: p_ltt_component(i).attribute12 :=

Line 5047: hr_transaction_api.get_varchar2_value

5043: (p_transaction_step_id => ln_transaction_step_id,
5044: p_name => 'p_cattribute11'||i);
5045:
5046: p_ltt_component(i).attribute12 :=
5047: hr_transaction_api.get_varchar2_value
5048: (p_transaction_step_id => ln_transaction_step_id,
5049: p_name => 'p_cattribute12'||i);
5050:
5051: -- hr_utility.trace('p_cattribute12 ');

Line 5054: hr_transaction_api.get_varchar2_value

5050:
5051: -- hr_utility.trace('p_cattribute12 ');
5052:
5053: p_ltt_component(i).attribute13 :=
5054: hr_transaction_api.get_varchar2_value
5055: (p_transaction_step_id => ln_transaction_step_id,
5056: p_name => 'p_cattribute13'||i);
5057:
5058: p_ltt_component(i).attribute14 :=

Line 5059: hr_transaction_api.get_varchar2_value

5055: (p_transaction_step_id => ln_transaction_step_id,
5056: p_name => 'p_cattribute13'||i);
5057:
5058: p_ltt_component(i).attribute14 :=
5059: hr_transaction_api.get_varchar2_value
5060: (p_transaction_step_id => ln_transaction_step_id,
5061: p_name => 'p_cattribute14'||i);
5062:
5063: -- hr_utility.trace('p_cattribute14 ');

Line 5066: hr_transaction_api.get_varchar2_value

5062:
5063: -- hr_utility.trace('p_cattribute14 ');
5064:
5065: p_ltt_component(i).attribute15 :=
5066: hr_transaction_api.get_varchar2_value
5067: (p_transaction_step_id => ln_transaction_step_id,
5068: p_name => 'p_cattribute15'||i);
5069:
5070: p_ltt_component(i).attribute16 :=

Line 5071: hr_transaction_api.get_varchar2_value

5067: (p_transaction_step_id => ln_transaction_step_id,
5068: p_name => 'p_cattribute15'||i);
5069:
5070: p_ltt_component(i).attribute16 :=
5071: hr_transaction_api.get_varchar2_value
5072: (p_transaction_step_id => ln_transaction_step_id,
5073: p_name => 'p_cattribute16'||i);
5074:
5075: -- hr_utility.trace('p_cattribute16 ');

Line 5078: hr_transaction_api.get_varchar2_value

5074:
5075: -- hr_utility.trace('p_cattribute16 ');
5076:
5077: p_ltt_component(i).attribute17 :=
5078: hr_transaction_api.get_varchar2_value
5079: (p_transaction_step_id => ln_transaction_step_id,
5080: p_name => 'p_cattribute17'||i);
5081:
5082: p_ltt_component(i).attribute18 :=

Line 5083: hr_transaction_api.get_varchar2_value

5079: (p_transaction_step_id => ln_transaction_step_id,
5080: p_name => 'p_cattribute17'||i);
5081:
5082: p_ltt_component(i).attribute18 :=
5083: hr_transaction_api.get_varchar2_value
5084: (p_transaction_step_id => ln_transaction_step_id,
5085: p_name => 'p_cattribute18'||i);
5086:
5087: -- hr_utility.trace('p_cattribute18 ');

Line 5090: hr_transaction_api.get_varchar2_value

5086:
5087: -- hr_utility.trace('p_cattribute18 ');
5088:
5089: p_ltt_component(i).attribute19 :=
5090: hr_transaction_api.get_varchar2_value
5091: (p_transaction_step_id => ln_transaction_step_id,
5092: p_name => 'p_cattribute19'||i);
5093:
5094: p_ltt_component(i).attribute20 :=

Line 5095: hr_transaction_api.get_varchar2_value

5091: (p_transaction_step_id => ln_transaction_step_id,
5092: p_name => 'p_cattribute19'||i);
5093:
5094: p_ltt_component(i).attribute20 :=
5095: hr_transaction_api.get_varchar2_value
5096: (p_transaction_step_id => ln_transaction_step_id,
5097: p_name => 'p_cattribute20'||i);
5098:
5099: -- hr_utility.trace('p_cattribute20 ' || p_ltt_component(i).attribute20);

Line 5164: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value

5160:
5161: hr_utility.set_location(l_proc,10);
5162: ln_transaction_step_id := p_transaction_step_id;
5163:
5164: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value
5165: (p_transaction_step_id => ln_transaction_step_id,
5166: p_name => 'p_effective_date')
5167: ,p_assignment_id => hr_transaction_api.get_number_value
5168: (p_transaction_step_id => ln_transaction_step_id,

Line 5167: ,p_assignment_id => hr_transaction_api.get_number_value

5163:
5164: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value
5165: (p_transaction_step_id => ln_transaction_step_id,
5166: p_name => 'p_effective_date')
5167: ,p_assignment_id => hr_transaction_api.get_number_value
5168: (p_transaction_step_id => ln_transaction_step_id,
5169: p_name => 'p_assignment_id')
5170: ,p_currency => lv_old_currency
5171: ,p_salary_basis_name => lv_old_salary_basis_name

Line 5181: hr_transaction_api.get_varchar2_value

5177: ,p_element_type_id => ln_old_element_type_id
5178: ,p_uom => lv_old_uom);
5179:
5180: lv_currency :=
5181: hr_transaction_api.get_varchar2_value
5182: (p_transaction_step_id => ln_transaction_step_id,
5183: p_name => 'p_currency');
5184:
5185: uom := hr_transaction_api.get_varchar2_value (

Line 5185: uom := hr_transaction_api.get_varchar2_value (

5181: hr_transaction_api.get_varchar2_value
5182: (p_transaction_step_id => ln_transaction_step_id,
5183: p_name => 'p_currency');
5184:
5185: uom := hr_transaction_api.get_varchar2_value (
5186: p_transaction_step_id => ln_transaction_step_id,
5187: p_name => 'p_default_uom');
5188:
5189: fnd_currency.BUILD_FORMAT_MASK(return_mask, 25, 5, null);

Line 5199: hr_transaction_api.get_number_value

5195: END IF;
5196:
5197: -- now get the individual salary data
5198: p_ltt_salary_data(1).current_salary :=
5199: hr_transaction_api.get_number_value
5200: (p_transaction_step_id => ln_transaction_step_id,
5201: p_name =>'p_current_salary');
5202:
5203: if (uom='N') then

Line 5210: hr_transaction_api.get_number_value

5206: p_ltt_salary_data(1).curr_sal_mc := hr_util_misc_ss.get_in_preferred_currency_str(p_ltt_salary_data(1).current_salary,lv_tmp_currency,trunc(sysdate));
5207: end if;
5208:
5209: p_ltt_salary_data(1).assignment_id :=
5210: hr_transaction_api.get_number_value
5211: (p_transaction_step_id => ln_transaction_step_id,
5212: p_name =>'p_assignment_id');
5213:
5214:

Line 5216: hr_transaction_api.get_number_value

5212: p_name =>'p_assignment_id');
5213:
5214:
5215: p_ltt_salary_data(1).business_group_id :=
5216: hr_transaction_api.get_number_value
5217: (p_transaction_step_id => ln_transaction_step_id,
5218: p_name =>'p_bus_group_id');
5219:
5220: p_ltt_salary_data(1).effective_date :=

Line 5221: hr_transaction_api.get_date_value

5217: (p_transaction_step_id => ln_transaction_step_id,
5218: p_name =>'p_bus_group_id');
5219:
5220: p_ltt_salary_data(1).effective_date :=
5221: hr_transaction_api.get_date_value
5222: (p_transaction_step_id => ln_transaction_step_id,
5223: p_name =>'p_effective_date');
5224:
5225: -- GSP change

Line 5227: hr_transaction_api.get_date_value

5223: p_name =>'p_effective_date');
5224:
5225: -- GSP change
5226: p_ltt_salary_data(1).salary_effective_date :=
5227: hr_transaction_api.get_date_value
5228: (p_transaction_step_id => ln_transaction_step_id,
5229: p_name =>'p_effective_date');
5230:
5231: p_ltt_salary_data(1).gsp_dummy_txn :=

Line 5232: hr_transaction_api.get_varchar2_value

5228: (p_transaction_step_id => ln_transaction_step_id,
5229: p_name =>'p_effective_date');
5230:
5231: p_ltt_salary_data(1).gsp_dummy_txn :=
5232: hr_transaction_api.get_varchar2_value
5233: (p_transaction_step_id => ln_transaction_step_id,
5234: p_name =>'p_gsp_dummy_txn');
5235: -- End of GSP change
5236:

Line 5238: hr_transaction_api.get_number_value

5234: p_name =>'p_gsp_dummy_txn');
5235: -- End of GSP change
5236:
5237: p_ltt_salary_data(1).salary_change_amount:=
5238: hr_transaction_api.get_number_value
5239: (p_transaction_step_id => ln_transaction_step_id,
5240: p_name =>'p_change_amount');
5241:
5242: if (uom='N') then

Line 5253: hr_transaction_api.get_number_value

5249: p_ltt_salary_data(1).chg_amt_mc := hr_util_misc_ss.get_in_preferred_currency_str(p_ltt_salary_data(1).salary_change_amount,lv_currency,trunc(sysdate));
5250: end if;
5251:
5252: p_ltt_salary_data(1).annual_change:=
5253: hr_transaction_api.get_number_value
5254: (p_transaction_step_id => ln_transaction_step_id,
5255: p_name =>'p_annual_change');
5256:
5257:

Line 5259: hr_transaction_api.get_number_value

5255: p_name =>'p_annual_change');
5256:
5257:
5258: p_ltt_salary_data(1).salary_change_percent:=
5259: hr_transaction_api.get_number_value
5260: (p_transaction_step_id => ln_transaction_step_id,
5261: p_name =>'p_change_percent');
5262:
5263: p_ltt_salary_data(1).proposed_salary:=

Line 5264: hr_transaction_api.get_number_value

5260: (p_transaction_step_id => ln_transaction_step_id,
5261: p_name =>'p_change_percent');
5262:
5263: p_ltt_salary_data(1).proposed_salary:=
5264: hr_transaction_api.get_number_value
5265: (p_transaction_step_id => ln_transaction_step_id,
5266: p_name => 'p_proposed_salary');
5267:
5268: if (uom='N') then

Line 5275: hr_transaction_api.get_varchar2_value

5271: p_ltt_salary_data(1).prop_sal_mc := hr_util_misc_ss.get_in_preferred_currency_str(p_ltt_salary_data(1).proposed_salary,lv_currency,trunc(sysdate));
5272: end if;
5273:
5274: p_ltt_salary_data(1).proposal_reason:=
5275: hr_transaction_api.get_varchar2_value
5276: (p_transaction_step_id => ln_transaction_step_id,
5277: p_name => 'p_proposal_reason');
5278:
5279: p_ltt_salary_data(1).currency:=

Line 5280: hr_transaction_api.get_varchar2_value

5276: (p_transaction_step_id => ln_transaction_step_id,
5277: p_name => 'p_proposal_reason');
5278:
5279: p_ltt_salary_data(1).currency:=
5280: hr_transaction_api.get_varchar2_value
5281: (p_transaction_step_id => ln_transaction_step_id,
5282: p_name => 'p_currency');
5283:
5284: p_ltt_salary_data(1).pay_basis_name:=

Line 5285: hr_transaction_api.get_varchar2_value

5281: (p_transaction_step_id => ln_transaction_step_id,
5282: p_name => 'p_currency');
5283:
5284: p_ltt_salary_data(1).pay_basis_name:=
5285: hr_transaction_api.get_varchar2_value
5286: (p_transaction_step_id => ln_transaction_step_id,
5287: p_name => 'p_pay_basis_name');
5288:
5289: p_ltt_salary_data(1).element_entry_id:=

Line 5290: hr_transaction_api.get_number_value

5286: (p_transaction_step_id => ln_transaction_step_id,
5287: p_name => 'p_pay_basis_name');
5288:
5289: p_ltt_salary_data(1).element_entry_id:=
5290: hr_transaction_api.get_number_value
5291: (p_transaction_step_id => ln_transaction_step_id,
5292: p_name => 'p_element_entry_id');
5293:
5294: p_ltt_salary_data(1).annual_equivalent:=

Line 5295: hr_transaction_api.get_number_value

5291: (p_transaction_step_id => ln_transaction_step_id,
5292: p_name => 'p_element_entry_id');
5293:
5294: p_ltt_salary_data(1).annual_equivalent:=
5295: hr_transaction_api.get_number_value
5296: (p_transaction_step_id => ln_transaction_step_id,
5297: p_name => 'p_annual_equivalent');
5298:
5299: if (uom='N') then

Line 5306: hr_transaction_api.get_number_value

5302: p_ltt_salary_data(1).prop_ann_eqv_mc := hr_util_misc_ss.get_in_preferred_currency_str(p_ltt_salary_data(1).annual_equivalent,lv_currency,trunc(sysdate));
5303: end if;
5304:
5305: p_ltt_salary_data(1).total_percent:=
5306: hr_transaction_api.get_number_value
5307: (p_transaction_step_id => ln_transaction_step_id,
5308: p_name => 'p_total_percent');
5309:
5310: p_ltt_salary_data(1).selection_mode:=

Line 5311: hr_transaction_api.get_varchar2_value

5307: (p_transaction_step_id => ln_transaction_step_id,
5308: p_name => 'p_total_percent');
5309:
5310: p_ltt_salary_data(1).selection_mode:=
5311: hr_transaction_api.get_varchar2_value
5312: (p_transaction_step_id => ln_transaction_step_id,
5313: p_name => 'p_selection_mode');
5314:
5315: p_ltt_salary_data(1).quartile:=

Line 5316: hr_transaction_api.get_number_value

5312: (p_transaction_step_id => ln_transaction_step_id,
5313: p_name => 'p_selection_mode');
5314:
5315: p_ltt_salary_data(1).quartile:=
5316: hr_transaction_api.get_number_value
5317: (p_transaction_step_id => ln_transaction_step_id,
5318: p_name => 'p_quartile');
5319:
5320: p_ltt_salary_data(1).comparatio:=

Line 5321: hr_transaction_api.get_number_value

5317: (p_transaction_step_id => ln_transaction_step_id,
5318: p_name => 'p_quartile');
5319:
5320: p_ltt_salary_data(1).comparatio:=
5321: hr_transaction_api.get_number_value
5322: (p_transaction_step_id => ln_transaction_step_id,
5323: p_name => 'p_comparatio');
5324:
5325: p_ltt_salary_data(1).ranking:=

Line 5326: hr_transaction_api.get_number_value

5322: (p_transaction_step_id => ln_transaction_step_id,
5323: p_name => 'p_comparatio');
5324:
5325: p_ltt_salary_data(1).ranking:=
5326: hr_transaction_api.get_number_value
5327: (p_transaction_step_id => ln_transaction_step_id,
5328: p_name => 'p_ranking');
5329:
5330: p_ltt_salary_data(1).multiple_components:=

Line 5331: hr_transaction_api.get_varchar2_value

5327: (p_transaction_step_id => ln_transaction_step_id,
5328: p_name => 'p_ranking');
5329:
5330: p_ltt_salary_data(1).multiple_components:=
5331: hr_transaction_api.get_varchar2_value
5332: (p_transaction_step_id => ln_transaction_step_id,
5333: p_name => 'p_multiple_components');
5334:
5335: p_ltt_salary_data(1).comments:=

Line 5336: hr_transaction_api.get_varchar2_value

5332: (p_transaction_step_id => ln_transaction_step_id,
5333: p_name => 'p_multiple_components');
5334:
5335: p_ltt_salary_data(1).comments:=
5336: hr_transaction_api.get_varchar2_value
5337: (p_transaction_step_id => ln_transaction_step_id,
5338: p_name => 'p_comments');
5339:
5340: p_ltt_salary_data(1).attribute_category :=

Line 5341: hr_transaction_api.get_varchar2_value (

5337: (p_transaction_step_id => ln_transaction_step_id,
5338: p_name => 'p_comments');
5339:
5340: p_ltt_salary_data(1).attribute_category :=
5341: hr_transaction_api.get_varchar2_value (
5342: p_transaction_step_id => ln_transaction_step_id,
5343: p_name => 'p_attribute_category'
5344: );
5345:

Line 5347: hr_transaction_api.get_varchar2_value (

5343: p_name => 'p_attribute_category'
5344: );
5345:
5346: p_ltt_salary_data(1).attribute1 :=
5347: hr_transaction_api.get_varchar2_value (
5348: p_transaction_step_id => ln_transaction_step_id,
5349: p_name => 'p_attribute1'
5350: );
5351:

Line 5353: hr_transaction_api.get_varchar2_value (

5349: p_name => 'p_attribute1'
5350: );
5351:
5352: p_ltt_salary_data(1).attribute2 :=
5353: hr_transaction_api.get_varchar2_value (
5354: p_transaction_step_id => ln_transaction_step_id,
5355: p_name => 'p_attribute2'
5356: );
5357:

Line 5359: hr_transaction_api.get_varchar2_value (

5355: p_name => 'p_attribute2'
5356: );
5357:
5358: p_ltt_salary_data(1).attribute3 :=
5359: hr_transaction_api.get_varchar2_value (
5360: p_transaction_step_id => ln_transaction_step_id,
5361: p_name => 'p_attribute3'
5362: );
5363:

Line 5365: hr_transaction_api.get_varchar2_value (

5361: p_name => 'p_attribute3'
5362: );
5363:
5364: p_ltt_salary_data(1).attribute4 :=
5365: hr_transaction_api.get_varchar2_value (
5366: p_transaction_step_id => ln_transaction_step_id,
5367: p_name => 'p_attribute4'
5368: );
5369:

Line 5372: hr_transaction_api.get_varchar2_value (

5368: );
5369:
5370:
5371: p_ltt_salary_data(1).attribute5 :=
5372: hr_transaction_api.get_varchar2_value (
5373: p_transaction_step_id => ln_transaction_step_id,
5374: p_name => 'p_attribute5'
5375: );
5376:

Line 5378: hr_transaction_api.get_varchar2_value (

5374: p_name => 'p_attribute5'
5375: );
5376:
5377: p_ltt_salary_data(1).attribute6 :=
5378: hr_transaction_api.get_varchar2_value (
5379: p_transaction_step_id => ln_transaction_step_id,
5380: p_name => 'p_attribute6'
5381: );
5382:

Line 5385: hr_transaction_api.get_varchar2_value (

5381: );
5382:
5383:
5384: p_ltt_salary_data(1).attribute7 :=
5385: hr_transaction_api.get_varchar2_value (
5386: p_transaction_step_id => ln_transaction_step_id,
5387: p_name => 'p_attribute7'
5388: );
5389:

Line 5391: hr_transaction_api.get_varchar2_value (

5387: p_name => 'p_attribute7'
5388: );
5389:
5390: p_ltt_salary_data(1).attribute8 :=
5391: hr_transaction_api.get_varchar2_value (
5392: p_transaction_step_id => ln_transaction_step_id,
5393: p_name => 'p_attribute8'
5394: );
5395:

Line 5397: hr_transaction_api.get_varchar2_value (

5393: p_name => 'p_attribute8'
5394: );
5395:
5396: p_ltt_salary_data(1).attribute9 :=
5397: hr_transaction_api.get_varchar2_value (
5398: p_transaction_step_id => ln_transaction_step_id,
5399: p_name => 'p_attribute9'
5400: );
5401:

Line 5403: hr_transaction_api.get_varchar2_value (

5399: p_name => 'p_attribute9'
5400: );
5401:
5402: p_ltt_salary_data(1).attribute10 :=
5403: hr_transaction_api.get_varchar2_value (
5404: p_transaction_step_id => ln_transaction_step_id,
5405: p_name => 'p_attribute10'
5406: );
5407:

Line 5409: hr_transaction_api.get_varchar2_value (

5405: p_name => 'p_attribute10'
5406: );
5407:
5408: p_ltt_salary_data(1).attribute11 :=
5409: hr_transaction_api.get_varchar2_value (
5410: p_transaction_step_id => ln_transaction_step_id,
5411: p_name => 'p_attribute11'
5412: );
5413:

Line 5415: hr_transaction_api.get_varchar2_value (

5411: p_name => 'p_attribute11'
5412: );
5413:
5414: p_ltt_salary_data(1).attribute12 :=
5415: hr_transaction_api.get_varchar2_value (
5416: p_transaction_step_id => ln_transaction_step_id,
5417: p_name => 'p_attribute12'
5418: );
5419:

Line 5421: hr_transaction_api.get_varchar2_value (

5417: p_name => 'p_attribute12'
5418: );
5419:
5420: p_ltt_salary_data(1).attribute13 :=
5421: hr_transaction_api.get_varchar2_value (
5422: p_transaction_step_id => ln_transaction_step_id,
5423: p_name => 'p_attribute13'
5424: );
5425:

Line 5427: hr_transaction_api.get_varchar2_value (

5423: p_name => 'p_attribute13'
5424: );
5425:
5426: p_ltt_salary_data(1).attribute14 :=
5427: hr_transaction_api.get_varchar2_value (
5428: p_transaction_step_id => ln_transaction_step_id,
5429: p_name => 'p_attribute14'
5430: );
5431:

Line 5433: hr_transaction_api.get_varchar2_value (

5429: p_name => 'p_attribute14'
5430: );
5431:
5432: p_ltt_salary_data(1).attribute15 :=
5433: hr_transaction_api.get_varchar2_value (
5434: p_transaction_step_id => ln_transaction_step_id,
5435: p_name => 'p_attribute15'
5436: );
5437:

Line 5439: hr_transaction_api.get_varchar2_value (

5435: p_name => 'p_attribute15'
5436: );
5437:
5438: p_ltt_salary_data(1).attribute16 :=
5439: hr_transaction_api.get_varchar2_value (
5440: p_transaction_step_id => ln_transaction_step_id,
5441: p_name => 'p_attribute16'
5442: );
5443:

Line 5446: hr_transaction_api.get_varchar2_value (

5442: );
5443:
5444:
5445: p_ltt_salary_data(1).attribute17 :=
5446: hr_transaction_api.get_varchar2_value (
5447: p_transaction_step_id => ln_transaction_step_id,
5448: p_name => 'p_attribute17'
5449: );
5450:

Line 5452: hr_transaction_api.get_varchar2_value (

5448: p_name => 'p_attribute17'
5449: );
5450:
5451: p_ltt_salary_data(1).attribute18 :=
5452: hr_transaction_api.get_varchar2_value (
5453: p_transaction_step_id => ln_transaction_step_id,
5454: p_name => 'p_attribute18'
5455: );
5456:

Line 5458: hr_transaction_api.get_varchar2_value (

5454: p_name => 'p_attribute18'
5455: );
5456:
5457: p_ltt_salary_data(1).attribute19 :=
5458: hr_transaction_api.get_varchar2_value (
5459: p_transaction_step_id => ln_transaction_step_id,
5460: p_name => 'p_attribute19'
5461: );
5462:

Line 5464: hr_transaction_api.get_varchar2_value (

5460: p_name => 'p_attribute19'
5461: );
5462:
5463: p_ltt_salary_data(1).attribute20 :=
5464: hr_transaction_api.get_varchar2_value (
5465: p_transaction_step_id => ln_transaction_step_id,
5466: p_name => 'p_attribute20'
5467: );
5468:

Line 5470: hr_transaction_api.get_number_value (

5466: p_name => 'p_attribute20'
5467: );
5468:
5469: p_ltt_salary_data(1).no_of_components :=
5470: hr_transaction_api.get_number_value (
5471: p_transaction_step_id => ln_transaction_step_id,
5472: p_name => 'p_no_of_components'
5473: );
5474:

Line 5477: hr_transaction_api.get_varchar2_value (

5473: );
5474:
5475: -- 04/12/02 Salary Basis Enhancement Begins
5476: p_ltt_salary_data(1).salary_basis_change_type :=
5477: hr_transaction_api.get_varchar2_value (
5478: p_transaction_step_id => ln_transaction_step_id,
5479: p_name => 'p_salary_basis_change_type'
5480: );
5481:

Line 5483: hr_transaction_api.get_date_value (

5479: p_name => 'p_salary_basis_change_type'
5480: );
5481:
5482: p_ltt_salary_data(1).default_date :=
5483: hr_transaction_api.get_date_value (
5484: p_transaction_step_id => ln_transaction_step_id,
5485: p_name => 'p_default_date'
5486: );
5487:

Line 5489: hr_transaction_api.get_number_value (

5485: p_name => 'p_default_date'
5486: );
5487:
5488: p_ltt_salary_data(1).default_bg_id :=
5489: hr_transaction_api.get_number_value (
5490: p_transaction_step_id => ln_transaction_step_id,
5491: p_name => 'p_default_bg_id'
5492: );
5493:

Line 5495: hr_transaction_api.get_varchar2_value (

5491: p_name => 'p_default_bg_id'
5492: );
5493:
5494: p_ltt_salary_data(1).default_currency :=
5495: hr_transaction_api.get_varchar2_value (
5496: p_transaction_step_id => ln_transaction_step_id,
5497: p_name => 'p_default_currency'
5498: );
5499:

Line 5501: hr_transaction_api.get_varchar2_value (

5497: p_name => 'p_default_currency'
5498: );
5499:
5500: p_ltt_salary_data(1).default_format_string :=
5501: hr_transaction_api.get_varchar2_value (
5502: p_transaction_step_id => ln_transaction_step_id,
5503: p_name => 'p_default_format_string'
5504: );
5505:

Line 5507: hr_transaction_api.get_varchar2_value (

5503: p_name => 'p_default_format_string'
5504: );
5505:
5506: p_ltt_salary_data(1).default_salary_basis_name :=
5507: hr_transaction_api.get_varchar2_value (
5508: p_transaction_step_id => ln_transaction_step_id,
5509: p_name => 'p_default_salary_basis_name'
5510: );
5511:

Line 5513: hr_transaction_api.get_varchar2_value (

5509: p_name => 'p_default_salary_basis_name'
5510: );
5511:
5512: p_ltt_salary_data(1).default_pay_basis_name :=
5513: hr_transaction_api.get_varchar2_value (
5514: p_transaction_step_id => ln_transaction_step_id,
5515: p_name => 'p_default_pay_basis_name'
5516: );
5517:

Line 5519: hr_transaction_api.get_varchar2_value (

5515: p_name => 'p_default_pay_basis_name'
5516: );
5517:
5518: p_ltt_salary_data(1).default_pay_basis :=
5519: hr_transaction_api.get_varchar2_value (
5520: p_transaction_step_id => ln_transaction_step_id,
5521: p_name => 'p_default_pay_basis'
5522: );
5523:

Line 5525: hr_transaction_api.get_number_value (

5521: p_name => 'p_default_pay_basis'
5522: );
5523:
5524: p_ltt_salary_data(1).default_pay_annual_factor :=
5525: hr_transaction_api.get_number_value (
5526: p_transaction_step_id => ln_transaction_step_id,
5527: p_name => 'p_default_pay_annual_factor'
5528: );
5529:

Line 5537: hr_transaction_api.get_varchar2_value (

5533: p_ltt_salary_data(1).curr_ann_eqv_mc := hr_util_misc_ss.get_in_preferred_currency_str((p_ltt_salary_data(1).default_pay_annual_factor*p_ltt_salary_data(1).current_salary),lv_tmp_currency,trunc(sysdate));
5534: end if;
5535:
5536: p_ltt_salary_data(1).default_grade :=
5537: hr_transaction_api.get_varchar2_value (
5538: p_transaction_step_id => ln_transaction_step_id,
5539: p_name => 'p_default_grade'
5540: );
5541:

Line 5543: hr_transaction_api.get_number_value (

5539: p_name => 'p_default_grade'
5540: );
5541:
5542: p_ltt_salary_data(1).default_grade_annual_factor :=
5543: hr_transaction_api.get_number_value (
5544: p_transaction_step_id => ln_transaction_step_id,
5545: p_name => 'p_default_grade_annual_factor'
5546: );
5547:

Line 5549: hr_transaction_api.get_number_value (

5545: p_name => 'p_default_grade_annual_factor'
5546: );
5547:
5548: p_ltt_salary_data(1).default_minimum_salary :=
5549: hr_transaction_api.get_number_value (
5550: p_transaction_step_id => ln_transaction_step_id,
5551: p_name => 'p_default_minimum_salary'
5552: );
5553:

Line 5555: hr_transaction_api.get_number_value (

5551: p_name => 'p_default_minimum_salary'
5552: );
5553:
5554: p_ltt_salary_data(1).default_maximum_salary :=
5555: hr_transaction_api.get_number_value (
5556: p_transaction_step_id => ln_transaction_step_id,
5557: p_name => 'p_default_maximum_salary'
5558: );
5559:

Line 5561: hr_transaction_api.get_number_value (

5557: p_name => 'p_default_maximum_salary'
5558: );
5559:
5560: p_ltt_salary_data(1).default_midpoint_salary :=
5561: hr_transaction_api.get_number_value (
5562: p_transaction_step_id => ln_transaction_step_id,
5563: p_name => 'p_default_midpoint_salary'
5564: );
5565:

Line 5567: hr_transaction_api.get_number_value (

5563: p_name => 'p_default_midpoint_salary'
5564: );
5565:
5566: p_ltt_salary_data(1).default_prev_salary :=
5567: hr_transaction_api.get_number_value (
5568: p_transaction_step_id => ln_transaction_step_id,
5569: p_name => 'p_default_prev_salary'
5570: );
5571:

Line 5573: hr_transaction_api.get_date_value (

5569: p_name => 'p_default_prev_salary'
5570: );
5571:
5572: p_ltt_salary_data(1).default_last_change_date :=
5573: hr_transaction_api.get_date_value (
5574: p_transaction_step_id => ln_transaction_step_id,
5575: p_name => 'p_default_last_change_date'
5576: );
5577:

Line 5579: hr_transaction_api.get_number_value (

5575: p_name => 'p_default_last_change_date'
5576: );
5577:
5578: p_ltt_salary_data(1).default_element_entry_id :=
5579: hr_transaction_api.get_number_value (
5580: p_transaction_step_id => ln_transaction_step_id,
5581: p_name => 'p_default_element_entry_id'
5582: );
5583:

Line 5585: hr_transaction_api.get_number_value (

5581: p_name => 'p_default_element_entry_id'
5582: );
5583:
5584: p_ltt_salary_data(1).default_basis_changed :=
5585: hr_transaction_api.get_number_value (
5586: p_transaction_step_id => ln_transaction_step_id,
5587: p_name => 'p_default_basis_changed'
5588: );
5589:

Line 5591: hr_transaction_api.get_varchar2_value (

5587: p_name => 'p_default_basis_changed'
5588: );
5589:
5590: p_ltt_salary_data(1).default_uom :=
5591: hr_transaction_api.get_varchar2_value (
5592: p_transaction_step_id => ln_transaction_step_id,
5593: p_name => 'p_default_uom'
5594: );
5595:

Line 5597: hr_transaction_api.get_varchar2_value (

5593: p_name => 'p_default_uom'
5594: );
5595:
5596: p_ltt_salary_data(1).default_grade_uom :=
5597: hr_transaction_api.get_varchar2_value (
5598: p_transaction_step_id => ln_transaction_step_id,
5599: p_name => 'p_default_grade_uom'
5600: );
5601:

Line 5603: hr_transaction_api.get_number_value (

5599: p_name => 'p_default_grade_uom'
5600: );
5601:
5602: p_ltt_salary_data(1).default_change_amount :=
5603: hr_transaction_api.get_number_value (
5604: p_transaction_step_id => ln_transaction_step_id,
5605: p_name => 'p_default_change_amount'
5606: );
5607:

Line 5609: hr_transaction_api.get_number_value (

5605: p_name => 'p_default_change_amount'
5606: );
5607:
5608: p_ltt_salary_data(1).default_change_percent :=
5609: hr_transaction_api.get_number_value (
5610: p_transaction_step_id => ln_transaction_step_id,
5611: p_name => 'p_default_change_percent'
5612: );
5613:

Line 5615: hr_transaction_api.get_number_value (

5611: p_name => 'p_default_change_percent'
5612: );
5613:
5614: p_ltt_salary_data(1).default_quartile :=
5615: hr_transaction_api.get_number_value (
5616: p_transaction_step_id => ln_transaction_step_id,
5617: p_name => 'p_default_quartile'
5618: );
5619:

Line 5621: hr_transaction_api.get_number_value (

5617: p_name => 'p_default_quartile'
5618: );
5619:
5620: p_ltt_salary_data(1).default_comparatio :=
5621: hr_transaction_api.get_number_value (
5622: p_transaction_step_id => ln_transaction_step_id,
5623: p_name => 'p_default_comparatio'
5624: );
5625:

Line 5627: hr_transaction_api.get_varchar2_value (

5623: p_name => 'p_default_comparatio'
5624: );
5625:
5626: p_ltt_salary_data(1).default_last_pay_change :=
5627: hr_transaction_api.get_varchar2_value (
5628: p_transaction_step_id => ln_transaction_step_id,
5629: p_name => 'p_default_last_pay_change'
5630: );
5631:

Line 5633: hr_transaction_api.get_varchar2_value (

5629: p_name => 'p_default_last_pay_change'
5630: );
5631:
5632: p_ltt_salary_data(1).default_flsa_status :=
5633: hr_transaction_api.get_varchar2_value (
5634: p_transaction_step_id => ln_transaction_step_id,
5635: p_name => 'p_default_flsa_status'
5636: );
5637:

Line 5639: hr_transaction_api.get_varchar2_value (

5635: p_name => 'p_default_flsa_status'
5636: );
5637:
5638: p_ltt_salary_data(1).default_currency_symbol :=
5639: hr_transaction_api.get_varchar2_value (
5640: p_transaction_step_id => ln_transaction_step_id,
5641: p_name => 'p_default_currency_symbol'
5642: );
5643:

Line 5645: hr_transaction_api.get_number_value (

5641: p_name => 'p_default_currency_symbol'
5642: );
5643:
5644: p_ltt_salary_data(1).default_precision :=
5645: hr_transaction_api.get_number_value (
5646: p_transaction_step_id => ln_transaction_step_id,
5647: p_name => 'p_default_precision'
5648: );
5649:

Line 5654: hr_transaction_api.get_number_value

5650: -- 04/12/02 Salary Basis Enhancement Ends'
5651:
5652: -- now get the component records
5653: ln_no_of_components :=
5654: hr_transaction_api.get_number_value
5655: (p_transaction_step_id => ln_transaction_step_id,
5656: p_name => 'p_no_of_components');
5657:
5658: FOR i in 1..ln_no_of_components

Line 5663: hr_transaction_api.get_number_value

5659: LOOP
5660:
5661: --hr_utility.trace(' Retrieving ' || i || ' compoent ');
5662: p_ltt_component(i).change_amount :=
5663: hr_transaction_api.get_number_value
5664: (p_transaction_step_id => ln_transaction_step_id,
5665: p_name => 'p_change_amount'||i);
5666:
5667: if (uom='N') then

Line 5674: hr_transaction_api.get_varchar2_value

5670: p_ltt_component(i).chg_amt_mc := hr_util_misc_ss.get_in_preferred_currency_str(p_ltt_component(i).change_amount,lv_currency,trunc(sysdate));
5671: end if;
5672:
5673: p_ltt_component(i).component_reason :=
5674: hr_transaction_api.get_varchar2_value
5675: (p_transaction_step_id => ln_transaction_step_id,
5676: p_name => 'p_component_reason'||i);
5677:
5678: p_ltt_component(i).reason_meaning :=

Line 5679: hr_transaction_api.get_varchar2_value

5675: (p_transaction_step_id => ln_transaction_step_id,
5676: p_name => 'p_component_reason'||i);
5677:
5678: p_ltt_component(i).reason_meaning :=
5679: hr_transaction_api.get_varchar2_value
5680: (p_transaction_step_id => ln_transaction_step_id,
5681: p_name => 'p_reason_meaning'||i);
5682: /*
5683: hr_misc_web.get_lookup_meaning(

Line 5691: hr_transaction_api.get_number_value

5687: hr_utility.trace('reason_meaning ' || p_ltt_component(i).reason_meaning);
5688: */
5689:
5690: p_ltt_component(i).change_percent :=
5691: hr_transaction_api.get_number_value
5692: (p_transaction_step_id => ln_transaction_step_id,
5693: p_name => 'p_change_percent'||i);
5694:
5695: p_ltt_component(i).change_annual :=

Line 5696: hr_transaction_api.get_number_value

5692: (p_transaction_step_id => ln_transaction_step_id,
5693: p_name => 'p_change_percent'||i);
5694:
5695: p_ltt_component(i).change_annual :=
5696: hr_transaction_api.get_number_value
5697: (p_transaction_step_id => ln_transaction_step_id,
5698: p_name => 'p_change_annual'||i);
5699:
5700: p_ltt_component(i).comments :=

Line 5701: hr_transaction_api.get_varchar2_value

5697: (p_transaction_step_id => ln_transaction_step_id,
5698: p_name => 'p_change_annual'||i);
5699:
5700: p_ltt_component(i).comments :=
5701: hr_transaction_api.get_varchar2_value
5702: (p_transaction_step_id => ln_transaction_step_id,
5703: p_name => 'p_comments'||i);
5704:
5705: p_ltt_component(i).approved :=

Line 5706: hr_transaction_api.get_varchar2_value

5702: (p_transaction_step_id => ln_transaction_step_id,
5703: p_name => 'p_comments'||i);
5704:
5705: p_ltt_component(i).approved :=
5706: hr_transaction_api.get_varchar2_value
5707: (p_transaction_step_id => ln_transaction_step_id,
5708: p_name => 'p_approved'||i);
5709:
5710: p_ltt_component(i).attribute_category :=

Line 5711: hr_transaction_api.get_varchar2_value

5707: (p_transaction_step_id => ln_transaction_step_id,
5708: p_name => 'p_approved'||i);
5709:
5710: p_ltt_component(i).attribute_category :=
5711: hr_transaction_api.get_varchar2_value
5712: (p_transaction_step_id => ln_transaction_step_id,
5713: p_name => 'p_cattribute_category'||i);
5714:
5715: p_ltt_component(i).attribute1 :=

Line 5716: hr_transaction_api.get_varchar2_value

5712: (p_transaction_step_id => ln_transaction_step_id,
5713: p_name => 'p_cattribute_category'||i);
5714:
5715: p_ltt_component(i).attribute1 :=
5716: hr_transaction_api.get_varchar2_value
5717: (p_transaction_step_id => ln_transaction_step_id,
5718: p_name => 'p_cattribute1'||i);
5719:
5720: p_ltt_component(i).attribute2:=

Line 5721: hr_transaction_api.get_varchar2_value

5717: (p_transaction_step_id => ln_transaction_step_id,
5718: p_name => 'p_cattribute1'||i);
5719:
5720: p_ltt_component(i).attribute2:=
5721: hr_transaction_api.get_varchar2_value
5722: (p_transaction_step_id => ln_transaction_step_id,
5723: p_name => 'p_cattribute2'||i);
5724:
5725: p_ltt_component(i).attribute3 :=

Line 5726: hr_transaction_api.get_varchar2_value

5722: (p_transaction_step_id => ln_transaction_step_id,
5723: p_name => 'p_cattribute2'||i);
5724:
5725: p_ltt_component(i).attribute3 :=
5726: hr_transaction_api.get_varchar2_value
5727: (p_transaction_step_id => ln_transaction_step_id,
5728: p_name => 'p_cattribute3'||i);
5729:
5730: p_ltt_component(i).attribute4 :=

Line 5731: hr_transaction_api.get_varchar2_value

5727: (p_transaction_step_id => ln_transaction_step_id,
5728: p_name => 'p_cattribute3'||i);
5729:
5730: p_ltt_component(i).attribute4 :=
5731: hr_transaction_api.get_varchar2_value
5732: (p_transaction_step_id => ln_transaction_step_id,
5733: p_name => 'p_cattribute4'||i);
5734:
5735: p_ltt_component(i).attribute5 :=

Line 5736: hr_transaction_api.get_varchar2_value

5732: (p_transaction_step_id => ln_transaction_step_id,
5733: p_name => 'p_cattribute4'||i);
5734:
5735: p_ltt_component(i).attribute5 :=
5736: hr_transaction_api.get_varchar2_value
5737: (p_transaction_step_id => ln_transaction_step_id,
5738: p_name => 'p_cattribute5'||i);
5739:
5740: -- hr_utility.trace('p_cattribute5 ');

Line 5743: hr_transaction_api.get_varchar2_value

5739:
5740: -- hr_utility.trace('p_cattribute5 ');
5741:
5742: p_ltt_component(i).attribute6 :=
5743: hr_transaction_api.get_varchar2_value
5744: (p_transaction_step_id => ln_transaction_step_id,
5745: p_name => 'p_cattribute6'||i);
5746:
5747: p_ltt_component(i).attribute7 :=

Line 5748: hr_transaction_api.get_varchar2_value

5744: (p_transaction_step_id => ln_transaction_step_id,
5745: p_name => 'p_cattribute6'||i);
5746:
5747: p_ltt_component(i).attribute7 :=
5748: hr_transaction_api.get_varchar2_value
5749: (p_transaction_step_id => ln_transaction_step_id,
5750: p_name => 'p_cattribute7'||i);
5751:
5752: -- hr_utility.trace('p_cattribute7 ');

Line 5756: hr_transaction_api.get_varchar2_value

5752: -- hr_utility.trace('p_cattribute7 ');
5753:
5754:
5755: p_ltt_component(i).attribute8 :=
5756: hr_transaction_api.get_varchar2_value
5757: (p_transaction_step_id => ln_transaction_step_id,
5758: p_name => 'p_cattribute8'||i);
5759:
5760: p_ltt_component(i).attribute9 :=

Line 5761: hr_transaction_api.get_varchar2_value

5757: (p_transaction_step_id => ln_transaction_step_id,
5758: p_name => 'p_cattribute8'||i);
5759:
5760: p_ltt_component(i).attribute9 :=
5761: hr_transaction_api.get_varchar2_value
5762: (p_transaction_step_id => ln_transaction_step_id,
5763: p_name => 'p_cattribute9'||i);
5764:
5765: -- hr_utility.trace('p_cattribute9 ');

Line 5768: hr_transaction_api.get_varchar2_value

5764:
5765: -- hr_utility.trace('p_cattribute9 ');
5766:
5767: p_ltt_component(i).attribute10 :=
5768: hr_transaction_api.get_varchar2_value
5769: (p_transaction_step_id => ln_transaction_step_id,
5770: p_name => 'p_cattribute10'||i);
5771:
5772: p_ltt_component(i).attribute11 :=

Line 5773: hr_transaction_api.get_varchar2_value

5769: (p_transaction_step_id => ln_transaction_step_id,
5770: p_name => 'p_cattribute10'||i);
5771:
5772: p_ltt_component(i).attribute11 :=
5773: hr_transaction_api.get_varchar2_value
5774: (p_transaction_step_id => ln_transaction_step_id,
5775: p_name => 'p_cattribute11'||i);
5776:
5777: p_ltt_component(i).attribute12 :=

Line 5778: hr_transaction_api.get_varchar2_value

5774: (p_transaction_step_id => ln_transaction_step_id,
5775: p_name => 'p_cattribute11'||i);
5776:
5777: p_ltt_component(i).attribute12 :=
5778: hr_transaction_api.get_varchar2_value
5779: (p_transaction_step_id => ln_transaction_step_id,
5780: p_name => 'p_cattribute12'||i);
5781:
5782: -- hr_utility.trace('p_cattribute12 ');

Line 5785: hr_transaction_api.get_varchar2_value

5781:
5782: -- hr_utility.trace('p_cattribute12 ');
5783:
5784: p_ltt_component(i).attribute13 :=
5785: hr_transaction_api.get_varchar2_value
5786: (p_transaction_step_id => ln_transaction_step_id,
5787: p_name => 'p_cattribute13'||i);
5788:
5789: p_ltt_component(i).attribute14 :=

Line 5790: hr_transaction_api.get_varchar2_value

5786: (p_transaction_step_id => ln_transaction_step_id,
5787: p_name => 'p_cattribute13'||i);
5788:
5789: p_ltt_component(i).attribute14 :=
5790: hr_transaction_api.get_varchar2_value
5791: (p_transaction_step_id => ln_transaction_step_id,
5792: p_name => 'p_cattribute14'||i);
5793:
5794: -- hr_utility.trace('p_cattribute14 ');

Line 5797: hr_transaction_api.get_varchar2_value

5793:
5794: -- hr_utility.trace('p_cattribute14 ');
5795:
5796: p_ltt_component(i).attribute15 :=
5797: hr_transaction_api.get_varchar2_value
5798: (p_transaction_step_id => ln_transaction_step_id,
5799: p_name => 'p_cattribute15'||i);
5800:
5801: p_ltt_component(i).attribute16 :=

Line 5802: hr_transaction_api.get_varchar2_value

5798: (p_transaction_step_id => ln_transaction_step_id,
5799: p_name => 'p_cattribute15'||i);
5800:
5801: p_ltt_component(i).attribute16 :=
5802: hr_transaction_api.get_varchar2_value
5803: (p_transaction_step_id => ln_transaction_step_id,
5804: p_name => 'p_cattribute16'||i);
5805:
5806: -- hr_utility.trace('p_cattribute16 ');

Line 5809: hr_transaction_api.get_varchar2_value

5805:
5806: -- hr_utility.trace('p_cattribute16 ');
5807:
5808: p_ltt_component(i).attribute17 :=
5809: hr_transaction_api.get_varchar2_value
5810: (p_transaction_step_id => ln_transaction_step_id,
5811: p_name => 'p_cattribute17'||i);
5812:
5813: p_ltt_component(i).attribute18 :=

Line 5814: hr_transaction_api.get_varchar2_value

5810: (p_transaction_step_id => ln_transaction_step_id,
5811: p_name => 'p_cattribute17'||i);
5812:
5813: p_ltt_component(i).attribute18 :=
5814: hr_transaction_api.get_varchar2_value
5815: (p_transaction_step_id => ln_transaction_step_id,
5816: p_name => 'p_cattribute18'||i);
5817:
5818: -- hr_utility.trace('p_cattribute18 ');

Line 5821: hr_transaction_api.get_varchar2_value

5817:
5818: -- hr_utility.trace('p_cattribute18 ');
5819:
5820: p_ltt_component(i).attribute19 :=
5821: hr_transaction_api.get_varchar2_value
5822: (p_transaction_step_id => ln_transaction_step_id,
5823: p_name => 'p_cattribute19'||i);
5824:
5825: p_ltt_component(i).attribute20 :=

Line 5826: hr_transaction_api.get_varchar2_value

5822: (p_transaction_step_id => ln_transaction_step_id,
5823: p_name => 'p_cattribute19'||i);
5824:
5825: p_ltt_component(i).attribute20 :=
5826: hr_transaction_api.get_varchar2_value
5827: (p_transaction_step_id => ln_transaction_step_id,
5828: p_name => 'p_cattribute20'||i);
5829:
5830: -- hr_utility.trace('p_cattribute20 ' || p_ltt_component(i).attribute20);

Line 6037: hr_transaction_api.get_transaction_step_info(

6033: null, null, null, null, null, null, null, null, null )
6034: );
6035:
6036:
6037: hr_transaction_api.get_transaction_step_info(
6038: p_transaction_step_id => p_transaction_step_id
6039: ,p_item_type => lv_item_type
6040: ,p_item_key => lv_item_key
6041: ,p_activity_id => ln_act_id);