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 1129: ln_txn_pay_basis_id := hr_transaction_api.get_number_value

1125: hr_utility.set_location(l_proc,25);
1126: -- In a chained process navigated from the Assignment page.
1127: -- Get the pay_basis_id from the txn step
1128: ln_transaction_step_id := p_asg_txn_step_id;
1129: ln_txn_pay_basis_id := hr_transaction_api.get_number_value
1130: (p_transaction_step_id => ln_transaction_step_id
1131: ,p_name => 'P_PAY_BASIS_ID');
1132: p_new_pay_basis_id := ln_txn_pay_basis_id;
1133:

Line 1134: ln_payroll_id := hr_transaction_api.get_number_value

1130: (p_transaction_step_id => ln_transaction_step_id
1131: ,p_name => 'P_PAY_BASIS_ID');
1132: p_new_pay_basis_id := ln_txn_pay_basis_id;
1133:
1134: ln_payroll_id := hr_transaction_api.get_number_value
1135: (p_transaction_step_id => ln_transaction_step_id
1136: ,p_name => 'P_PAYROLL_ID');
1137:
1138: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value

Line 1138: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value

1134: ln_payroll_id := hr_transaction_api.get_number_value
1135: (p_transaction_step_id => ln_transaction_step_id
1136: ,p_name => 'P_PAYROLL_ID');
1137:
1138: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value
1139: (p_transaction_step_id => ln_transaction_step_id
1140: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1141:
1142: ln_job_id := hr_transaction_api.get_number_value

Line 1142: ln_job_id := hr_transaction_api.get_number_value

1138: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value
1139: (p_transaction_step_id => ln_transaction_step_id
1140: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1141:
1142: ln_job_id := hr_transaction_api.get_number_value
1143: (p_transaction_step_id => ln_transaction_step_id
1144: ,p_name => 'P_JOB_ID');
1145:
1146: -- 05/03/2002 Fix Begins

Line 1192: ln_txn_pay_basis_id := hr_transaction_api.get_number_value

1188: -- page.
1189: -- Get the value of pay basis id from the txn table.
1190: p_asg_txn_step_id := ln_transaction_step_id;
1191:
1192: ln_txn_pay_basis_id := hr_transaction_api.get_number_value
1193: (p_transaction_step_id => ln_transaction_step_id
1194: ,p_name => 'P_PAY_BASIS_ID');
1195:
1196: ln_payroll_id := hr_transaction_api.get_number_value

Line 1196: ln_payroll_id := hr_transaction_api.get_number_value

1192: ln_txn_pay_basis_id := hr_transaction_api.get_number_value
1193: (p_transaction_step_id => ln_transaction_step_id
1194: ,p_name => 'P_PAY_BASIS_ID');
1195:
1196: ln_payroll_id := hr_transaction_api.get_number_value
1197: (p_transaction_step_id => ln_transaction_step_id
1198: ,p_name => 'P_PAYROLL_ID');
1199:
1200: p_new_pay_basis_id := ln_txn_pay_basis_id;

Line 1202: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value

1198: ,p_name => 'P_PAYROLL_ID');
1199:
1200: p_new_pay_basis_id := ln_txn_pay_basis_id;
1201:
1202: lv_sal_rev_period_frequency := hr_transaction_api.get_varchar2_value
1203: (p_transaction_step_id => ln_transaction_step_id
1204: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1205:
1206:

Line 1207: ln_job_id := hr_transaction_api.get_number_value

1203: (p_transaction_step_id => ln_transaction_step_id
1204: ,p_name => 'P_SAL_REVIEW_PERIOD_FREQUENCY');
1205:
1206:
1207: ln_job_id := hr_transaction_api.get_number_value
1208: (p_transaction_step_id => ln_transaction_step_id
1209: ,p_name => 'P_JOB_ID');
1210:
1211: -- 05/03/2002 Fix Begins

Line 1985: hr_transaction_api.create_transaction(p_validate => false

1981: ,avalue => l_transaction_privilege);
1982: end if;
1983:
1984: -- call the BP API to create the transaction
1985: hr_transaction_api.create_transaction(p_validate => false
1986: ,p_creator_person_id => p_creator_person_id
1987: ,p_transaction_privilege => l_transaction_privilege
1988: ,p_transaction_id => l_transaction_id );
1989: -- set the TRANSACTION_ID

Line 2543: hr_transaction_api.get_number_value

2539: IF p_transaction_step_id IS NOT NULL
2540: THEN
2541: hr_utility.set_location(l_proc,10);
2542: ln_no_of_components :=
2543: hr_transaction_api.get_number_value
2544: (p_transaction_step_id => p_transaction_step_id,
2545: p_name => 'p_no_of_components');
2546:
2547: IF ln_no_of_components IS NOT NULL THEN

Line 2553: hr_transaction_api.get_varchar2_value

2549: no_of_components := ln_no_of_components;
2550: END IF;
2551:
2552: lv_pay_rate_type :=
2553: hr_transaction_api.get_varchar2_value
2554: (p_transaction_step_id => p_transaction_step_id,
2555: p_name => 'P_MULTIPLE_COMPONENTS');
2556:
2557: IF lv_pay_rate_type IS NOT NULL THEN

Line 2628: hr_transaction_api.get_transaction_step_info

2624:
2625: IF ln_transaction_id IS NOT NULL
2626: THEN
2627: hr_utility.set_location(l_proc,15);
2628: hr_transaction_api.get_transaction_step_info
2629: (p_Item_Type => p_item_type,
2630: p_Item_Key => p_item_key,
2631: p_activity_id =>p_act_id,
2632: p_transaction_step_id => ltt_trans_step_ids,

Line 2661: hr_transaction_api.get_number_value

2657: p_trans_step_id_tbl => ltt_trans_step_ids);
2658:
2659:
2660: ln_no_of_components :=
2661: hr_transaction_api.get_number_value
2662: (p_transaction_step_id => ln_transaction_step_id,
2663: p_name => 'p_no_of_components');
2664:
2665: IF ln_no_of_components IS NOT NULL THEN

Line 2673: hr_transaction_api.get_varchar2_value

2669:
2670: -- hr_utility.trace(' ln_no_of_components ' || ln_no_of_components);
2671:
2672: lv_pay_rate_type :=
2673: hr_transaction_api.get_varchar2_value
2674: (p_transaction_step_id => ln_transaction_step_id,
2675: p_name => 'P_MULTIPLE_COMPONENTS');
2676:
2677: IF lv_pay_rate_type IS NOT NULL THEN

Line 3957: hr_transaction_api.get_transaction_step_info

3953: --insert into dev_test values (' Created Txn');
3954: --commit;
3955:
3956: -- now we have a valid txn id , let's find out txn steps
3957: hr_transaction_api.get_transaction_step_info
3958: (p_Item_Type => p_item_type
3959: ,p_Item_Key => p_item_key
3960: ,p_activity_id => p_act_id
3961: ,p_transaction_step_id => ltt_trans_step_ids

Line 3975: hr_transaction_api.create_transaction_step

3971: --Create a step within this new transaction
3972:
3973: hr_utility.trace('create_transaction_step ');
3974:
3975: hr_transaction_api.create_transaction_step
3976: (p_validate => false
3977: ,p_creator_person_id => ln_creator_person_id
3978: ,p_transaction_id => ln_transaction_id
3979: ,p_api_name => lv_api_name

Line 4273: ln_assignment_id := hr_transaction_api.get_number_value

4269: if ln_transaction_step_id is not null then
4270: -- if an assignment step already exists then apply the
4271: -- assignment data
4272:
4273: ln_assignment_id := hr_transaction_api.get_number_value
4274: (p_transaction_step_id => ln_transaction_step_id
4275: ,p_name => 'P_ASSIGNMENT_ID');
4276:
4277: ln_job_id := hr_transaction_api.get_number_value

Line 4277: ln_job_id := hr_transaction_api.get_number_value

4273: ln_assignment_id := hr_transaction_api.get_number_value
4274: (p_transaction_step_id => ln_transaction_step_id
4275: ,p_name => 'P_ASSIGNMENT_ID');
4276:
4277: ln_job_id := hr_transaction_api.get_number_value
4278: (p_transaction_step_id => ln_transaction_step_id
4279: ,p_name => 'P_JOB_ID');
4280:
4281: -- Must set the element warning to TRUE so that the ASG wrapper will

Line 4595: hr_transaction_api.get_transaction_step_info

4591: IF ln_transaction_id IS NOT NULL
4592: THEN
4593: hr_utility.set_location(l_proc,10);
4594: -- hr_utility.trace('Transaction Exists');
4595: hr_transaction_api.get_transaction_step_info
4596: (p_Item_Type => p_item_type,
4597: p_Item_Key => p_item_key,
4598: p_activity_id =>p_act_id,
4599: p_transaction_step_id => ltt_trans_step_ids,

Line 4629: hr_transaction_api.get_number_value

4625: -- hr_utility.trace(' ln_transaction_step_id ' || ln_transaction_step_id);
4626:
4627: -- now get the individual salary data
4628: p_ltt_salary_data(1).current_salary :=
4629: hr_transaction_api.get_number_value
4630: (p_transaction_step_id => ln_transaction_step_id,
4631: p_name =>'p_current_salary');
4632:
4633: -- hr_utility.trace(' p_current_salary ' || p_ltt_salary_data(1).current_salary);

Line 4636: hr_transaction_api.get_number_value

4632:
4633: -- hr_utility.trace(' p_current_salary ' || p_ltt_salary_data(1).current_salary);
4634:
4635: p_ltt_salary_data(1).assignment_id :=
4636: hr_transaction_api.get_number_value
4637: (p_transaction_step_id => ln_transaction_step_id,
4638: p_name =>'p_assignment_id');
4639:
4640:

Line 4643: hr_transaction_api.get_number_value

4639:
4640:
4641:
4642: p_ltt_salary_data(1).business_group_id :=
4643: hr_transaction_api.get_number_value
4644: (p_transaction_step_id => ln_transaction_step_id,
4645: p_name =>'p_bus_group_id');
4646:
4647: -- hr_utility.trace(' p_bus_group_id ' || p_ltt_salary_data(1).business_group_id);

Line 4650: hr_transaction_api.get_date_value

4646:
4647: -- hr_utility.trace(' p_bus_group_id ' || p_ltt_salary_data(1).business_group_id);
4648:
4649: p_ltt_salary_data(1).effective_date :=
4650: hr_transaction_api.get_date_value
4651: (p_transaction_step_id => ln_transaction_step_id,
4652: p_name =>'p_effective_date');
4653:
4654: -- GSP change

Line 4656: hr_transaction_api.get_date_value

4652: p_name =>'p_effective_date');
4653:
4654: -- GSP change
4655: p_ltt_salary_data(1).salary_effective_date :=
4656: hr_transaction_api.get_date_value
4657: (p_transaction_step_id => ln_transaction_step_id,
4658: p_name =>'p_effective_date');
4659:
4660: p_ltt_salary_data(1).gsp_dummy_txn :=

Line 4661: hr_transaction_api.get_varchar2_value

4657: (p_transaction_step_id => ln_transaction_step_id,
4658: p_name =>'p_effective_date');
4659:
4660: p_ltt_salary_data(1).gsp_dummy_txn :=
4661: hr_transaction_api.get_varchar2_value
4662: (p_transaction_step_id => ln_transaction_step_id,
4663: p_name =>'p_gsp_dummy_txn');
4664: --End of GSP change
4665:

Line 4667: hr_transaction_api.get_number_value

4663: p_name =>'p_gsp_dummy_txn');
4664: --End of GSP change
4665:
4666: p_ltt_salary_data(1).salary_change_amount:=
4667: hr_transaction_api.get_number_value
4668: (p_transaction_step_id => ln_transaction_step_id,
4669: p_name =>'p_change_amount');
4670:
4671: -- hr_utility.trace(' p_change_amount ' || p_ltt_salary_data(1).salary_change_amount);

Line 4674: hr_transaction_api.get_number_value

4670:
4671: -- hr_utility.trace(' p_change_amount ' || p_ltt_salary_data(1).salary_change_amount);
4672:
4673: p_ltt_salary_data(1).annual_change:=
4674: hr_transaction_api.get_number_value
4675: (p_transaction_step_id => ln_transaction_step_id,
4676: p_name =>'p_annual_change');
4677:
4678: -- hr_utility.trace(' p_annual_change ' || p_ltt_salary_data(1).annual_change);

Line 4682: hr_transaction_api.get_number_value

4678: -- hr_utility.trace(' p_annual_change ' || p_ltt_salary_data(1).annual_change);
4679:
4680:
4681: p_ltt_salary_data(1).salary_change_percent:=
4682: hr_transaction_api.get_number_value
4683: (p_transaction_step_id => ln_transaction_step_id,
4684: p_name =>'p_change_percent');
4685:
4686: p_ltt_salary_data(1).proposed_salary:=

Line 4687: hr_transaction_api.get_number_value

4683: (p_transaction_step_id => ln_transaction_step_id,
4684: p_name =>'p_change_percent');
4685:
4686: p_ltt_salary_data(1).proposed_salary:=
4687: hr_transaction_api.get_number_value
4688: (p_transaction_step_id => ln_transaction_step_id,
4689: p_name => 'p_proposed_salary');
4690:
4691: p_ltt_salary_data(1).proposal_reason:=

Line 4692: hr_transaction_api.get_varchar2_value

4688: (p_transaction_step_id => ln_transaction_step_id,
4689: p_name => 'p_proposed_salary');
4690:
4691: p_ltt_salary_data(1).proposal_reason:=
4692: hr_transaction_api.get_varchar2_value
4693: (p_transaction_step_id => ln_transaction_step_id,
4694: p_name => 'p_proposal_reason');
4695:
4696: p_ltt_salary_data(1).currency:=

Line 4697: hr_transaction_api.get_varchar2_value

4693: (p_transaction_step_id => ln_transaction_step_id,
4694: p_name => 'p_proposal_reason');
4695:
4696: p_ltt_salary_data(1).currency:=
4697: hr_transaction_api.get_varchar2_value
4698: (p_transaction_step_id => ln_transaction_step_id,
4699: p_name => 'p_currency');
4700:
4701:

Line 4703: hr_transaction_api.get_varchar2_value

4699: p_name => 'p_currency');
4700:
4701:
4702: p_ltt_salary_data(1).pay_basis_name:=
4703: hr_transaction_api.get_varchar2_value
4704: (p_transaction_step_id => ln_transaction_step_id,
4705: p_name => 'p_pay_basis_name');
4706:
4707: p_ltt_salary_data(1).element_entry_id:=

Line 4708: hr_transaction_api.get_number_value

4704: (p_transaction_step_id => ln_transaction_step_id,
4705: p_name => 'p_pay_basis_name');
4706:
4707: p_ltt_salary_data(1).element_entry_id:=
4708: hr_transaction_api.get_number_value
4709: (p_transaction_step_id => ln_transaction_step_id,
4710: p_name => 'p_element_entry_id');
4711:
4712:

Line 4714: hr_transaction_api.get_number_value

4710: p_name => 'p_element_entry_id');
4711:
4712:
4713: p_ltt_salary_data(1).annual_equivalent:=
4714: hr_transaction_api.get_number_value
4715: (p_transaction_step_id => ln_transaction_step_id,
4716: p_name => 'p_annual_equivalent');
4717:
4718:

Line 4720: hr_transaction_api.get_number_value

4716: p_name => 'p_annual_equivalent');
4717:
4718:
4719: p_ltt_salary_data(1).total_percent:=
4720: hr_transaction_api.get_number_value
4721: (p_transaction_step_id => ln_transaction_step_id,
4722: p_name => 'p_total_percent');
4723:
4724: p_ltt_salary_data(1).selection_mode:=

Line 4725: hr_transaction_api.get_varchar2_value

4721: (p_transaction_step_id => ln_transaction_step_id,
4722: p_name => 'p_total_percent');
4723:
4724: p_ltt_salary_data(1).selection_mode:=
4725: hr_transaction_api.get_varchar2_value
4726: (p_transaction_step_id => ln_transaction_step_id,
4727: p_name => 'p_selection_mode');
4728:
4729: p_ltt_salary_data(1).quartile:=

Line 4730: hr_transaction_api.get_number_value

4726: (p_transaction_step_id => ln_transaction_step_id,
4727: p_name => 'p_selection_mode');
4728:
4729: p_ltt_salary_data(1).quartile:=
4730: hr_transaction_api.get_number_value
4731: (p_transaction_step_id => ln_transaction_step_id,
4732: p_name => 'p_quartile');
4733:
4734: p_ltt_salary_data(1).comparatio:=

Line 4735: hr_transaction_api.get_number_value

4731: (p_transaction_step_id => ln_transaction_step_id,
4732: p_name => 'p_quartile');
4733:
4734: p_ltt_salary_data(1).comparatio:=
4735: hr_transaction_api.get_number_value
4736: (p_transaction_step_id => ln_transaction_step_id,
4737: p_name => 'p_comparatio');
4738:
4739: p_ltt_salary_data(1).ranking:=

Line 4740: hr_transaction_api.get_number_value

4736: (p_transaction_step_id => ln_transaction_step_id,
4737: p_name => 'p_comparatio');
4738:
4739: p_ltt_salary_data(1).ranking:=
4740: hr_transaction_api.get_number_value
4741: (p_transaction_step_id => ln_transaction_step_id,
4742: p_name => 'p_ranking');
4743:
4744:

Line 4746: hr_transaction_api.get_varchar2_value

4742: p_name => 'p_ranking');
4743:
4744:
4745: p_ltt_salary_data(1).multiple_components:=
4746: hr_transaction_api.get_varchar2_value
4747: (p_transaction_step_id => ln_transaction_step_id,
4748: p_name => 'p_multiple_components');
4749:
4750:

Line 4752: hr_transaction_api.get_varchar2_value

4748: p_name => 'p_multiple_components');
4749:
4750:
4751: p_ltt_salary_data(1).comments:=
4752: hr_transaction_api.get_varchar2_value
4753: (p_transaction_step_id => ln_transaction_step_id,
4754: p_name => 'p_comments');
4755:
4756:

Line 4758: hr_transaction_api.get_varchar2_value (

4754: p_name => 'p_comments');
4755:
4756:
4757: p_ltt_salary_data(1).attribute_category :=
4758: hr_transaction_api.get_varchar2_value (
4759: p_transaction_step_id => ln_transaction_step_id,
4760: p_name => 'p_attribute_category'
4761: );
4762:

Line 4764: hr_transaction_api.get_varchar2_value (

4760: p_name => 'p_attribute_category'
4761: );
4762:
4763: p_ltt_salary_data(1).attribute1 :=
4764: hr_transaction_api.get_varchar2_value (
4765: p_transaction_step_id => ln_transaction_step_id,
4766: p_name => 'p_attribute1'
4767: );
4768:

Line 4772: hr_transaction_api.get_varchar2_value (

4768:
4769: -- hr_utility.trace(' p_attribute1 ' || p_ltt_salary_data(1).attribute1);
4770:
4771: p_ltt_salary_data(1).attribute2 :=
4772: hr_transaction_api.get_varchar2_value (
4773: p_transaction_step_id => ln_transaction_step_id,
4774: p_name => 'p_attribute2'
4775: );
4776:

Line 4780: hr_transaction_api.get_varchar2_value (

4776:
4777: -- hr_utility.trace(' p_attribute2 ' || p_ltt_salary_data(1).attribute2);
4778:
4779: p_ltt_salary_data(1).attribute3 :=
4780: hr_transaction_api.get_varchar2_value (
4781: p_transaction_step_id => ln_transaction_step_id,
4782: p_name => 'p_attribute3'
4783: );
4784:

Line 4786: hr_transaction_api.get_varchar2_value (

4782: p_name => 'p_attribute3'
4783: );
4784:
4785: p_ltt_salary_data(1).attribute4 :=
4786: hr_transaction_api.get_varchar2_value (
4787: p_transaction_step_id => ln_transaction_step_id,
4788: p_name => 'p_attribute4'
4789: );
4790:

Line 4793: hr_transaction_api.get_varchar2_value (

4789: );
4790:
4791:
4792: p_ltt_salary_data(1).attribute5 :=
4793: hr_transaction_api.get_varchar2_value (
4794: p_transaction_step_id => ln_transaction_step_id,
4795: p_name => 'p_attribute5'
4796: );
4797:

Line 4799: hr_transaction_api.get_varchar2_value (

4795: p_name => 'p_attribute5'
4796: );
4797:
4798: p_ltt_salary_data(1).attribute6 :=
4799: hr_transaction_api.get_varchar2_value (
4800: p_transaction_step_id => ln_transaction_step_id,
4801: p_name => 'p_attribute6'
4802: );
4803:

Line 4806: hr_transaction_api.get_varchar2_value (

4802: );
4803:
4804:
4805: p_ltt_salary_data(1).attribute7 :=
4806: hr_transaction_api.get_varchar2_value (
4807: p_transaction_step_id => ln_transaction_step_id,
4808: p_name => 'p_attribute7'
4809: );
4810:

Line 4812: hr_transaction_api.get_varchar2_value (

4808: p_name => 'p_attribute7'
4809: );
4810:
4811: p_ltt_salary_data(1).attribute8 :=
4812: hr_transaction_api.get_varchar2_value (
4813: p_transaction_step_id => ln_transaction_step_id,
4814: p_name => 'p_attribute8'
4815: );
4816:

Line 4818: hr_transaction_api.get_varchar2_value (

4814: p_name => 'p_attribute8'
4815: );
4816:
4817: p_ltt_salary_data(1).attribute9 :=
4818: hr_transaction_api.get_varchar2_value (
4819: p_transaction_step_id => ln_transaction_step_id,
4820: p_name => 'p_attribute9'
4821: );
4822:

Line 4824: hr_transaction_api.get_varchar2_value (

4820: p_name => 'p_attribute9'
4821: );
4822:
4823: p_ltt_salary_data(1).attribute10 :=
4824: hr_transaction_api.get_varchar2_value (
4825: p_transaction_step_id => ln_transaction_step_id,
4826: p_name => 'p_attribute10'
4827: );
4828:

Line 4830: hr_transaction_api.get_varchar2_value (

4826: p_name => 'p_attribute10'
4827: );
4828:
4829: p_ltt_salary_data(1).attribute11 :=
4830: hr_transaction_api.get_varchar2_value (
4831: p_transaction_step_id => ln_transaction_step_id,
4832: p_name => 'p_attribute11'
4833: );
4834:

Line 4836: hr_transaction_api.get_varchar2_value (

4832: p_name => 'p_attribute11'
4833: );
4834:
4835: p_ltt_salary_data(1).attribute12 :=
4836: hr_transaction_api.get_varchar2_value (
4837: p_transaction_step_id => ln_transaction_step_id,
4838: p_name => 'p_attribute12'
4839: );
4840:

Line 4842: hr_transaction_api.get_varchar2_value (

4838: p_name => 'p_attribute12'
4839: );
4840:
4841: p_ltt_salary_data(1).attribute13 :=
4842: hr_transaction_api.get_varchar2_value (
4843: p_transaction_step_id => ln_transaction_step_id,
4844: p_name => 'p_attribute13'
4845: );
4846:

Line 4848: hr_transaction_api.get_varchar2_value (

4844: p_name => 'p_attribute13'
4845: );
4846:
4847: p_ltt_salary_data(1).attribute14 :=
4848: hr_transaction_api.get_varchar2_value (
4849: p_transaction_step_id => ln_transaction_step_id,
4850: p_name => 'p_attribute14'
4851: );
4852:

Line 4854: hr_transaction_api.get_varchar2_value (

4850: p_name => 'p_attribute14'
4851: );
4852:
4853: p_ltt_salary_data(1).attribute15 :=
4854: hr_transaction_api.get_varchar2_value (
4855: p_transaction_step_id => ln_transaction_step_id,
4856: p_name => 'p_attribute15'
4857: );
4858:

Line 4860: hr_transaction_api.get_varchar2_value (

4856: p_name => 'p_attribute15'
4857: );
4858:
4859: p_ltt_salary_data(1).attribute16 :=
4860: hr_transaction_api.get_varchar2_value (
4861: p_transaction_step_id => ln_transaction_step_id,
4862: p_name => 'p_attribute16'
4863: );
4864:

Line 4867: hr_transaction_api.get_varchar2_value (

4863: );
4864:
4865:
4866: p_ltt_salary_data(1).attribute17 :=
4867: hr_transaction_api.get_varchar2_value (
4868: p_transaction_step_id => ln_transaction_step_id,
4869: p_name => 'p_attribute17'
4870: );
4871:

Line 4873: hr_transaction_api.get_varchar2_value (

4869: p_name => 'p_attribute17'
4870: );
4871:
4872: p_ltt_salary_data(1).attribute18 :=
4873: hr_transaction_api.get_varchar2_value (
4874: p_transaction_step_id => ln_transaction_step_id,
4875: p_name => 'p_attribute18'
4876: );
4877:

Line 4879: hr_transaction_api.get_varchar2_value (

4875: p_name => 'p_attribute18'
4876: );
4877:
4878: p_ltt_salary_data(1).attribute19 :=
4879: hr_transaction_api.get_varchar2_value (
4880: p_transaction_step_id => ln_transaction_step_id,
4881: p_name => 'p_attribute19'
4882: );
4883:

Line 4885: hr_transaction_api.get_varchar2_value (

4881: p_name => 'p_attribute19'
4882: );
4883:
4884: p_ltt_salary_data(1).attribute20 :=
4885: hr_transaction_api.get_varchar2_value (
4886: p_transaction_step_id => ln_transaction_step_id,
4887: p_name => 'p_attribute20'
4888: );
4889:

Line 4891: hr_transaction_api.get_number_value (

4887: p_name => 'p_attribute20'
4888: );
4889:
4890: p_ltt_salary_data(1).no_of_components :=
4891: hr_transaction_api.get_number_value (
4892: p_transaction_step_id => ln_transaction_step_id,
4893: p_name => 'p_no_of_components'
4894: );
4895:

Line 4898: hr_transaction_api.get_varchar2_value (

4894: );
4895:
4896: -- 04/12/02 Salary Basis Enhancement Begins
4897: p_ltt_salary_data(1).salary_basis_change_type :=
4898: hr_transaction_api.get_varchar2_value (
4899: p_transaction_step_id => ln_transaction_step_id,
4900: p_name => 'p_salary_basis_change_type'
4901: );
4902:

Line 4904: hr_transaction_api.get_date_value (

4900: p_name => 'p_salary_basis_change_type'
4901: );
4902:
4903: p_ltt_salary_data(1).default_date :=
4904: hr_transaction_api.get_date_value (
4905: p_transaction_step_id => ln_transaction_step_id,
4906: p_name => 'p_default_date'
4907: );
4908:

Line 4910: hr_transaction_api.get_number_value (

4906: p_name => 'p_default_date'
4907: );
4908:
4909: p_ltt_salary_data(1).default_bg_id :=
4910: hr_transaction_api.get_number_value (
4911: p_transaction_step_id => ln_transaction_step_id,
4912: p_name => 'p_default_bg_id'
4913: );
4914:

Line 4916: hr_transaction_api.get_varchar2_value (

4912: p_name => 'p_default_bg_id'
4913: );
4914:
4915: p_ltt_salary_data(1).default_currency :=
4916: hr_transaction_api.get_varchar2_value (
4917: p_transaction_step_id => ln_transaction_step_id,
4918: p_name => 'p_default_currency'
4919: );
4920:

Line 4922: hr_transaction_api.get_varchar2_value (

4918: p_name => 'p_default_currency'
4919: );
4920:
4921: p_ltt_salary_data(1).default_format_string :=
4922: hr_transaction_api.get_varchar2_value (
4923: p_transaction_step_id => ln_transaction_step_id,
4924: p_name => 'p_default_format_string'
4925: );
4926:

Line 4928: hr_transaction_api.get_varchar2_value (

4924: p_name => 'p_default_format_string'
4925: );
4926:
4927: p_ltt_salary_data(1).default_salary_basis_name :=
4928: hr_transaction_api.get_varchar2_value (
4929: p_transaction_step_id => ln_transaction_step_id,
4930: p_name => 'p_default_salary_basis_name'
4931: );
4932:

Line 4934: hr_transaction_api.get_varchar2_value (

4930: p_name => 'p_default_salary_basis_name'
4931: );
4932:
4933: p_ltt_salary_data(1).default_pay_basis_name :=
4934: hr_transaction_api.get_varchar2_value (
4935: p_transaction_step_id => ln_transaction_step_id,
4936: p_name => 'p_default_pay_basis_name'
4937: );
4938:

Line 4940: hr_transaction_api.get_varchar2_value (

4936: p_name => 'p_default_pay_basis_name'
4937: );
4938:
4939: p_ltt_salary_data(1).default_pay_basis :=
4940: hr_transaction_api.get_varchar2_value (
4941: p_transaction_step_id => ln_transaction_step_id,
4942: p_name => 'p_default_pay_basis'
4943: );
4944:

Line 4946: hr_transaction_api.get_number_value (

4942: p_name => 'p_default_pay_basis'
4943: );
4944:
4945: p_ltt_salary_data(1).default_pay_annual_factor :=
4946: hr_transaction_api.get_number_value (
4947: p_transaction_step_id => ln_transaction_step_id,
4948: p_name => 'p_default_pay_annual_factor'
4949: );
4950:

Line 4952: hr_transaction_api.get_varchar2_value (

4948: p_name => 'p_default_pay_annual_factor'
4949: );
4950:
4951: p_ltt_salary_data(1).default_grade :=
4952: hr_transaction_api.get_varchar2_value (
4953: p_transaction_step_id => ln_transaction_step_id,
4954: p_name => 'p_default_grade'
4955: );
4956:

Line 4958: hr_transaction_api.get_number_value (

4954: p_name => 'p_default_grade'
4955: );
4956:
4957: p_ltt_salary_data(1).default_grade_annual_factor :=
4958: hr_transaction_api.get_number_value (
4959: p_transaction_step_id => ln_transaction_step_id,
4960: p_name => 'p_default_grade_annual_factor'
4961: );
4962:

Line 4964: hr_transaction_api.get_number_value (

4960: p_name => 'p_default_grade_annual_factor'
4961: );
4962:
4963: p_ltt_salary_data(1).default_minimum_salary :=
4964: hr_transaction_api.get_number_value (
4965: p_transaction_step_id => ln_transaction_step_id,
4966: p_name => 'p_default_minimum_salary'
4967: );
4968:

Line 4970: hr_transaction_api.get_number_value (

4966: p_name => 'p_default_minimum_salary'
4967: );
4968:
4969: p_ltt_salary_data(1).default_maximum_salary :=
4970: hr_transaction_api.get_number_value (
4971: p_transaction_step_id => ln_transaction_step_id,
4972: p_name => 'p_default_maximum_salary'
4973: );
4974:

Line 4976: hr_transaction_api.get_number_value (

4972: p_name => 'p_default_maximum_salary'
4973: );
4974:
4975: p_ltt_salary_data(1).default_midpoint_salary :=
4976: hr_transaction_api.get_number_value (
4977: p_transaction_step_id => ln_transaction_step_id,
4978: p_name => 'p_default_midpoint_salary'
4979: );
4980:

Line 4982: hr_transaction_api.get_number_value (

4978: p_name => 'p_default_midpoint_salary'
4979: );
4980:
4981: p_ltt_salary_data(1).default_prev_salary :=
4982: hr_transaction_api.get_number_value (
4983: p_transaction_step_id => ln_transaction_step_id,
4984: p_name => 'p_default_prev_salary'
4985: );
4986:

Line 4988: hr_transaction_api.get_date_value (

4984: p_name => 'p_default_prev_salary'
4985: );
4986:
4987: p_ltt_salary_data(1).default_last_change_date :=
4988: hr_transaction_api.get_date_value (
4989: p_transaction_step_id => ln_transaction_step_id,
4990: p_name => 'p_default_last_change_date'
4991: );
4992:

Line 4994: hr_transaction_api.get_number_value (

4990: p_name => 'p_default_last_change_date'
4991: );
4992:
4993: p_ltt_salary_data(1).default_element_entry_id :=
4994: hr_transaction_api.get_number_value (
4995: p_transaction_step_id => ln_transaction_step_id,
4996: p_name => 'p_default_element_entry_id'
4997: );
4998:

Line 5000: hr_transaction_api.get_number_value (

4996: p_name => 'p_default_element_entry_id'
4997: );
4998:
4999: p_ltt_salary_data(1).default_basis_changed :=
5000: hr_transaction_api.get_number_value (
5001: p_transaction_step_id => ln_transaction_step_id,
5002: p_name => 'p_default_basis_changed'
5003: );
5004:

Line 5006: hr_transaction_api.get_varchar2_value (

5002: p_name => 'p_default_basis_changed'
5003: );
5004:
5005: p_ltt_salary_data(1).default_uom :=
5006: hr_transaction_api.get_varchar2_value (
5007: p_transaction_step_id => ln_transaction_step_id,
5008: p_name => 'p_default_uom'
5009: );
5010:

Line 5012: hr_transaction_api.get_varchar2_value (

5008: p_name => 'p_default_uom'
5009: );
5010:
5011: p_ltt_salary_data(1).default_grade_uom :=
5012: hr_transaction_api.get_varchar2_value (
5013: p_transaction_step_id => ln_transaction_step_id,
5014: p_name => 'p_default_grade_uom'
5015: );
5016:

Line 5018: hr_transaction_api.get_number_value (

5014: p_name => 'p_default_grade_uom'
5015: );
5016:
5017: p_ltt_salary_data(1).default_change_amount :=
5018: hr_transaction_api.get_number_value (
5019: p_transaction_step_id => ln_transaction_step_id,
5020: p_name => 'p_default_change_amount'
5021: );
5022:

Line 5024: hr_transaction_api.get_number_value (

5020: p_name => 'p_default_change_amount'
5021: );
5022:
5023: p_ltt_salary_data(1).default_change_percent :=
5024: hr_transaction_api.get_number_value (
5025: p_transaction_step_id => ln_transaction_step_id,
5026: p_name => 'p_default_change_percent'
5027: );
5028:

Line 5030: hr_transaction_api.get_number_value (

5026: p_name => 'p_default_change_percent'
5027: );
5028:
5029: p_ltt_salary_data(1).default_quartile :=
5030: hr_transaction_api.get_number_value (
5031: p_transaction_step_id => ln_transaction_step_id,
5032: p_name => 'p_default_quartile'
5033: );
5034:

Line 5036: hr_transaction_api.get_number_value (

5032: p_name => 'p_default_quartile'
5033: );
5034:
5035: p_ltt_salary_data(1).default_comparatio :=
5036: hr_transaction_api.get_number_value (
5037: p_transaction_step_id => ln_transaction_step_id,
5038: p_name => 'p_default_comparatio'
5039: );
5040:

Line 5042: hr_transaction_api.get_varchar2_value (

5038: p_name => 'p_default_comparatio'
5039: );
5040:
5041: p_ltt_salary_data(1).default_last_pay_change :=
5042: hr_transaction_api.get_varchar2_value (
5043: p_transaction_step_id => ln_transaction_step_id,
5044: p_name => 'p_default_last_pay_change'
5045: );
5046:

Line 5048: hr_transaction_api.get_varchar2_value (

5044: p_name => 'p_default_last_pay_change'
5045: );
5046:
5047: p_ltt_salary_data(1).default_flsa_status :=
5048: hr_transaction_api.get_varchar2_value (
5049: p_transaction_step_id => ln_transaction_step_id,
5050: p_name => 'p_default_flsa_status'
5051: );
5052:

Line 5054: hr_transaction_api.get_varchar2_value (

5050: p_name => 'p_default_flsa_status'
5051: );
5052:
5053: p_ltt_salary_data(1).default_currency_symbol :=
5054: hr_transaction_api.get_varchar2_value (
5055: p_transaction_step_id => ln_transaction_step_id,
5056: p_name => 'p_default_currency_symbol'
5057: );
5058:

Line 5060: hr_transaction_api.get_number_value (

5056: p_name => 'p_default_currency_symbol'
5057: );
5058:
5059: p_ltt_salary_data(1).default_precision :=
5060: hr_transaction_api.get_number_value (
5061: p_transaction_step_id => ln_transaction_step_id,
5062: p_name => 'p_default_precision'
5063: );
5064:

Line 5071: hr_transaction_api.get_number_value

5067: -- hr_utility.trace('Populated Proposal Values');
5068:
5069: -- now get the component records
5070: ln_no_of_components :=
5071: hr_transaction_api.get_number_value
5072: (p_transaction_step_id => ln_transaction_step_id,
5073: p_name => 'p_no_of_components');
5074:
5075: -- hr_utility.trace('ln_no_of_components' || ln_no_of_components);

Line 5082: hr_transaction_api.get_number_value

5078: LOOP
5079:
5080: -- hr_utility.trace(' Retrieving ' || i || ' compoent ');
5081: p_ltt_component(i).change_amount :=
5082: hr_transaction_api.get_number_value
5083: (p_transaction_step_id => ln_transaction_step_id,
5084: p_name => 'p_change_amount'||i);
5085: -- hr_utility.trace('change_amount ' || p_ltt_component(i).change_amount);
5086:

Line 5090: hr_transaction_api.get_varchar2_value

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

Line 5096: hr_transaction_api.get_varchar2_value

5092: p_name => 'p_component_reason'||i);
5093: -- hr_utility.trace('p_component_reason ' || p_ltt_component(i).component_reason);
5094:
5095: p_ltt_component(i).reason_meaning :=
5096: hr_transaction_api.get_varchar2_value
5097: (p_transaction_step_id => ln_transaction_step_id,
5098: p_name => 'p_reason_meaning'||i);
5099: -- hr_utility.trace('p_reason_meaning ' || p_ltt_component(i).reason_meaning);
5100:

Line 5110: hr_transaction_api.get_number_value

5106: hr_utility.trace('reason_meaning ' || p_ltt_component(i).reason_meaning);
5107: */
5108:
5109: p_ltt_component(i).change_percent :=
5110: hr_transaction_api.get_number_value
5111: (p_transaction_step_id => ln_transaction_step_id,
5112: p_name => 'p_change_percent'||i);
5113:
5114: -- hr_utility.trace('p_change_percent ' || p_ltt_component(i).change_percent);

Line 5117: hr_transaction_api.get_number_value

5113:
5114: -- hr_utility.trace('p_change_percent ' || p_ltt_component(i).change_percent);
5115:
5116: p_ltt_component(i).change_annual :=
5117: hr_transaction_api.get_number_value
5118: (p_transaction_step_id => ln_transaction_step_id,
5119: p_name => 'p_change_annual'||i);
5120:
5121: p_ltt_component(i).comments :=

Line 5122: hr_transaction_api.get_varchar2_value

5118: (p_transaction_step_id => ln_transaction_step_id,
5119: p_name => 'p_change_annual'||i);
5120:
5121: p_ltt_component(i).comments :=
5122: hr_transaction_api.get_varchar2_value
5123: (p_transaction_step_id => ln_transaction_step_id,
5124: p_name => 'p_comments'||i);
5125:
5126:

Line 5128: hr_transaction_api.get_varchar2_value

5124: p_name => 'p_comments'||i);
5125:
5126:
5127: p_ltt_component(i).approved :=
5128: hr_transaction_api.get_varchar2_value
5129: (p_transaction_step_id => ln_transaction_step_id,
5130: p_name => 'p_approved'||i);
5131:
5132: p_ltt_component(i).attribute_category :=

Line 5133: hr_transaction_api.get_varchar2_value

5129: (p_transaction_step_id => ln_transaction_step_id,
5130: p_name => 'p_approved'||i);
5131:
5132: p_ltt_component(i).attribute_category :=
5133: hr_transaction_api.get_varchar2_value
5134: (p_transaction_step_id => ln_transaction_step_id,
5135: p_name => 'p_cattribute_category'||i);
5136:
5137: p_ltt_component(i).attribute1 :=

Line 5138: hr_transaction_api.get_varchar2_value

5134: (p_transaction_step_id => ln_transaction_step_id,
5135: p_name => 'p_cattribute_category'||i);
5136:
5137: p_ltt_component(i).attribute1 :=
5138: hr_transaction_api.get_varchar2_value
5139: (p_transaction_step_id => ln_transaction_step_id,
5140: p_name => 'p_cattribute1'||i);
5141:
5142: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute1);

Line 5146: hr_transaction_api.get_varchar2_value

5142: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute1);
5143:
5144:
5145: p_ltt_component(i).attribute2:=
5146: hr_transaction_api.get_varchar2_value
5147: (p_transaction_step_id => ln_transaction_step_id,
5148: p_name => 'p_cattribute2'||i);
5149:
5150: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute2);

Line 5154: hr_transaction_api.get_varchar2_value

5150: -- hr_utility.trace('p_cattribute1 ' || p_ltt_component(i).attribute2);
5151:
5152:
5153: p_ltt_component(i).attribute3 :=
5154: hr_transaction_api.get_varchar2_value
5155: (p_transaction_step_id => ln_transaction_step_id,
5156: p_name => 'p_cattribute3'||i);
5157:
5158: -- hr_utility.trace('p_cattribute1 ');

Line 5161: hr_transaction_api.get_varchar2_value

5157:
5158: -- hr_utility.trace('p_cattribute1 ');
5159:
5160: p_ltt_component(i).attribute4 :=
5161: hr_transaction_api.get_varchar2_value
5162: (p_transaction_step_id => ln_transaction_step_id,
5163: p_name => 'p_cattribute4'||i);
5164:
5165: p_ltt_component(i).attribute5 :=

Line 5166: hr_transaction_api.get_varchar2_value

5162: (p_transaction_step_id => ln_transaction_step_id,
5163: p_name => 'p_cattribute4'||i);
5164:
5165: p_ltt_component(i).attribute5 :=
5166: hr_transaction_api.get_varchar2_value
5167: (p_transaction_step_id => ln_transaction_step_id,
5168: p_name => 'p_cattribute5'||i);
5169:
5170: -- hr_utility.trace('p_cattribute5 ');

Line 5173: hr_transaction_api.get_varchar2_value

5169:
5170: -- hr_utility.trace('p_cattribute5 ');
5171:
5172: p_ltt_component(i).attribute6 :=
5173: hr_transaction_api.get_varchar2_value
5174: (p_transaction_step_id => ln_transaction_step_id,
5175: p_name => 'p_cattribute6'||i);
5176:
5177: p_ltt_component(i).attribute7 :=

Line 5178: hr_transaction_api.get_varchar2_value

5174: (p_transaction_step_id => ln_transaction_step_id,
5175: p_name => 'p_cattribute6'||i);
5176:
5177: p_ltt_component(i).attribute7 :=
5178: hr_transaction_api.get_varchar2_value
5179: (p_transaction_step_id => ln_transaction_step_id,
5180: p_name => 'p_cattribute7'||i);
5181:
5182: -- hr_utility.trace('p_cattribute7 ');

Line 5186: hr_transaction_api.get_varchar2_value

5182: -- hr_utility.trace('p_cattribute7 ');
5183:
5184:
5185: p_ltt_component(i).attribute8 :=
5186: hr_transaction_api.get_varchar2_value
5187: (p_transaction_step_id => ln_transaction_step_id,
5188: p_name => 'p_cattribute8'||i);
5189:
5190: p_ltt_component(i).attribute9 :=

Line 5191: hr_transaction_api.get_varchar2_value

5187: (p_transaction_step_id => ln_transaction_step_id,
5188: p_name => 'p_cattribute8'||i);
5189:
5190: p_ltt_component(i).attribute9 :=
5191: hr_transaction_api.get_varchar2_value
5192: (p_transaction_step_id => ln_transaction_step_id,
5193: p_name => 'p_cattribute9'||i);
5194:
5195: -- hr_utility.trace('p_cattribute9 ');

Line 5198: hr_transaction_api.get_varchar2_value

5194:
5195: -- hr_utility.trace('p_cattribute9 ');
5196:
5197: p_ltt_component(i).attribute10 :=
5198: hr_transaction_api.get_varchar2_value
5199: (p_transaction_step_id => ln_transaction_step_id,
5200: p_name => 'p_cattribute10'||i);
5201:
5202: p_ltt_component(i).attribute11 :=

Line 5203: hr_transaction_api.get_varchar2_value

5199: (p_transaction_step_id => ln_transaction_step_id,
5200: p_name => 'p_cattribute10'||i);
5201:
5202: p_ltt_component(i).attribute11 :=
5203: hr_transaction_api.get_varchar2_value
5204: (p_transaction_step_id => ln_transaction_step_id,
5205: p_name => 'p_cattribute11'||i);
5206:
5207: p_ltt_component(i).attribute12 :=

Line 5208: hr_transaction_api.get_varchar2_value

5204: (p_transaction_step_id => ln_transaction_step_id,
5205: p_name => 'p_cattribute11'||i);
5206:
5207: p_ltt_component(i).attribute12 :=
5208: hr_transaction_api.get_varchar2_value
5209: (p_transaction_step_id => ln_transaction_step_id,
5210: p_name => 'p_cattribute12'||i);
5211:
5212: -- hr_utility.trace('p_cattribute12 ');

Line 5215: hr_transaction_api.get_varchar2_value

5211:
5212: -- hr_utility.trace('p_cattribute12 ');
5213:
5214: p_ltt_component(i).attribute13 :=
5215: hr_transaction_api.get_varchar2_value
5216: (p_transaction_step_id => ln_transaction_step_id,
5217: p_name => 'p_cattribute13'||i);
5218:
5219: p_ltt_component(i).attribute14 :=

Line 5220: hr_transaction_api.get_varchar2_value

5216: (p_transaction_step_id => ln_transaction_step_id,
5217: p_name => 'p_cattribute13'||i);
5218:
5219: p_ltt_component(i).attribute14 :=
5220: hr_transaction_api.get_varchar2_value
5221: (p_transaction_step_id => ln_transaction_step_id,
5222: p_name => 'p_cattribute14'||i);
5223:
5224: -- hr_utility.trace('p_cattribute14 ');

Line 5227: hr_transaction_api.get_varchar2_value

5223:
5224: -- hr_utility.trace('p_cattribute14 ');
5225:
5226: p_ltt_component(i).attribute15 :=
5227: hr_transaction_api.get_varchar2_value
5228: (p_transaction_step_id => ln_transaction_step_id,
5229: p_name => 'p_cattribute15'||i);
5230:
5231: p_ltt_component(i).attribute16 :=

Line 5232: hr_transaction_api.get_varchar2_value

5228: (p_transaction_step_id => ln_transaction_step_id,
5229: p_name => 'p_cattribute15'||i);
5230:
5231: p_ltt_component(i).attribute16 :=
5232: hr_transaction_api.get_varchar2_value
5233: (p_transaction_step_id => ln_transaction_step_id,
5234: p_name => 'p_cattribute16'||i);
5235:
5236: -- hr_utility.trace('p_cattribute16 ');

Line 5239: hr_transaction_api.get_varchar2_value

5235:
5236: -- hr_utility.trace('p_cattribute16 ');
5237:
5238: p_ltt_component(i).attribute17 :=
5239: hr_transaction_api.get_varchar2_value
5240: (p_transaction_step_id => ln_transaction_step_id,
5241: p_name => 'p_cattribute17'||i);
5242:
5243: p_ltt_component(i).attribute18 :=

Line 5244: hr_transaction_api.get_varchar2_value

5240: (p_transaction_step_id => ln_transaction_step_id,
5241: p_name => 'p_cattribute17'||i);
5242:
5243: p_ltt_component(i).attribute18 :=
5244: hr_transaction_api.get_varchar2_value
5245: (p_transaction_step_id => ln_transaction_step_id,
5246: p_name => 'p_cattribute18'||i);
5247:
5248: -- hr_utility.trace('p_cattribute18 ');

Line 5251: hr_transaction_api.get_varchar2_value

5247:
5248: -- hr_utility.trace('p_cattribute18 ');
5249:
5250: p_ltt_component(i).attribute19 :=
5251: hr_transaction_api.get_varchar2_value
5252: (p_transaction_step_id => ln_transaction_step_id,
5253: p_name => 'p_cattribute19'||i);
5254:
5255: p_ltt_component(i).attribute20 :=

Line 5256: hr_transaction_api.get_varchar2_value

5252: (p_transaction_step_id => ln_transaction_step_id,
5253: p_name => 'p_cattribute19'||i);
5254:
5255: p_ltt_component(i).attribute20 :=
5256: hr_transaction_api.get_varchar2_value
5257: (p_transaction_step_id => ln_transaction_step_id,
5258: p_name => 'p_cattribute20'||i);
5259:
5260: -- hr_utility.trace('p_cattribute20 ' || p_ltt_component(i).attribute20);

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

5323:
5324: hr_utility.set_location(l_proc,10);
5325: ln_transaction_step_id := p_transaction_step_id;
5326:
5327: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value
5328: (p_transaction_step_id => ln_transaction_step_id,
5329: p_name => 'p_effective_date')
5330: ,p_assignment_id => hr_transaction_api.get_number_value
5331: (p_transaction_step_id => ln_transaction_step_id,

Line 5330: ,p_assignment_id => hr_transaction_api.get_number_value

5326:
5327: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value
5328: (p_transaction_step_id => ln_transaction_step_id,
5329: p_name => 'p_effective_date')
5330: ,p_assignment_id => hr_transaction_api.get_number_value
5331: (p_transaction_step_id => ln_transaction_step_id,
5332: p_name => 'p_assignment_id')
5333: ,p_currency => lv_old_currency
5334: ,p_salary_basis_name => lv_old_salary_basis_name

Line 5344: hr_transaction_api.get_number_value (p_transaction_step_id => ln_transaction_step_id,

5340: ,p_element_type_id => ln_old_element_type_id
5341: ,p_uom => lv_old_uom);
5342:
5343: lv_old_fte_factor := per_saladmin_utility.get_fte_factor(
5344: hr_transaction_api.get_number_value (p_transaction_step_id => ln_transaction_step_id,
5345: p_name => 'p_assignment_id'),
5346: hr_transaction_api.get_date_value (p_transaction_step_id => ln_transaction_step_id,
5347: p_name => 'p_effective_date'));
5348:

Line 5346: hr_transaction_api.get_date_value (p_transaction_step_id => ln_transaction_step_id,

5342:
5343: lv_old_fte_factor := per_saladmin_utility.get_fte_factor(
5344: hr_transaction_api.get_number_value (p_transaction_step_id => ln_transaction_step_id,
5345: p_name => 'p_assignment_id'),
5346: hr_transaction_api.get_date_value (p_transaction_step_id => ln_transaction_step_id,
5347: p_name => 'p_effective_date'));
5348:
5349: lv_currency :=
5350: hr_transaction_api.get_varchar2_value

Line 5350: hr_transaction_api.get_varchar2_value

5346: hr_transaction_api.get_date_value (p_transaction_step_id => ln_transaction_step_id,
5347: p_name => 'p_effective_date'));
5348:
5349: lv_currency :=
5350: hr_transaction_api.get_varchar2_value
5351: (p_transaction_step_id => ln_transaction_step_id,
5352: p_name => 'p_currency');
5353:
5354: uom := hr_transaction_api.get_varchar2_value (

Line 5354: uom := hr_transaction_api.get_varchar2_value (

5350: hr_transaction_api.get_varchar2_value
5351: (p_transaction_step_id => ln_transaction_step_id,
5352: p_name => 'p_currency');
5353:
5354: uom := hr_transaction_api.get_varchar2_value (
5355: p_transaction_step_id => ln_transaction_step_id,
5356: p_name => 'p_default_uom');
5357:
5358: fnd_currency.BUILD_FORMAT_MASK(return_mask, 25, 5, null);

Line 5368: hr_transaction_api.get_number_value

5364: END IF;
5365:
5366: -- now get the individual salary data
5367: p_ltt_salary_data(1).current_salary :=
5368: hr_transaction_api.get_number_value
5369: (p_transaction_step_id => ln_transaction_step_id,
5370: p_name =>'p_current_salary');
5371:
5372: if (uom='N') then

Line 5379: hr_transaction_api.get_number_value

5375: 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));
5376: end if;
5377:
5378: p_ltt_salary_data(1).assignment_id :=
5379: hr_transaction_api.get_number_value
5380: (p_transaction_step_id => ln_transaction_step_id,
5381: p_name =>'p_assignment_id');
5382:
5383:

Line 5385: hr_transaction_api.get_number_value

5381: p_name =>'p_assignment_id');
5382:
5383:
5384: p_ltt_salary_data(1).business_group_id :=
5385: hr_transaction_api.get_number_value
5386: (p_transaction_step_id => ln_transaction_step_id,
5387: p_name =>'p_bus_group_id');
5388:
5389: p_ltt_salary_data(1).effective_date :=

Line 5390: hr_transaction_api.get_date_value

5386: (p_transaction_step_id => ln_transaction_step_id,
5387: p_name =>'p_bus_group_id');
5388:
5389: p_ltt_salary_data(1).effective_date :=
5390: hr_transaction_api.get_date_value
5391: (p_transaction_step_id => ln_transaction_step_id,
5392: p_name =>'p_effective_date');
5393:
5394: -- GSP change

Line 5396: hr_transaction_api.get_date_value

5392: p_name =>'p_effective_date');
5393:
5394: -- GSP change
5395: p_ltt_salary_data(1).salary_effective_date :=
5396: hr_transaction_api.get_date_value
5397: (p_transaction_step_id => ln_transaction_step_id,
5398: p_name =>'p_effective_date');
5399:
5400: p_ltt_salary_data(1).gsp_dummy_txn :=

Line 5401: hr_transaction_api.get_varchar2_value

5397: (p_transaction_step_id => ln_transaction_step_id,
5398: p_name =>'p_effective_date');
5399:
5400: p_ltt_salary_data(1).gsp_dummy_txn :=
5401: hr_transaction_api.get_varchar2_value
5402: (p_transaction_step_id => ln_transaction_step_id,
5403: p_name =>'p_gsp_dummy_txn');
5404: -- End of GSP change
5405:

Line 5407: hr_transaction_api.get_number_value

5403: p_name =>'p_gsp_dummy_txn');
5404: -- End of GSP change
5405:
5406: p_ltt_salary_data(1).salary_change_amount:=
5407: hr_transaction_api.get_number_value
5408: (p_transaction_step_id => ln_transaction_step_id,
5409: p_name =>'p_change_amount');
5410:
5411: if (uom='N') then

Line 5422: hr_transaction_api.get_number_value

5418: 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));
5419: end if;
5420:
5421: p_ltt_salary_data(1).annual_change:=
5422: hr_transaction_api.get_number_value
5423: (p_transaction_step_id => ln_transaction_step_id,
5424: p_name =>'p_annual_change');
5425:
5426:

Line 5428: hr_transaction_api.get_number_value

5424: p_name =>'p_annual_change');
5425:
5426:
5427: p_ltt_salary_data(1).salary_change_percent:=
5428: hr_transaction_api.get_number_value
5429: (p_transaction_step_id => ln_transaction_step_id,
5430: p_name =>'p_change_percent');
5431:
5432: p_ltt_salary_data(1).proposed_salary:=

Line 5433: hr_transaction_api.get_number_value

5429: (p_transaction_step_id => ln_transaction_step_id,
5430: p_name =>'p_change_percent');
5431:
5432: p_ltt_salary_data(1).proposed_salary:=
5433: hr_transaction_api.get_number_value
5434: (p_transaction_step_id => ln_transaction_step_id,
5435: p_name => 'p_proposed_salary');
5436:
5437: if (uom='N') then

Line 5444: hr_transaction_api.get_varchar2_value

5440: 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));
5441: end if;
5442:
5443: p_ltt_salary_data(1).proposal_reason:=
5444: hr_transaction_api.get_varchar2_value
5445: (p_transaction_step_id => ln_transaction_step_id,
5446: p_name => 'p_proposal_reason');
5447:
5448: p_ltt_salary_data(1).currency:=

Line 5449: hr_transaction_api.get_varchar2_value

5445: (p_transaction_step_id => ln_transaction_step_id,
5446: p_name => 'p_proposal_reason');
5447:
5448: p_ltt_salary_data(1).currency:=
5449: hr_transaction_api.get_varchar2_value
5450: (p_transaction_step_id => ln_transaction_step_id,
5451: p_name => 'p_currency');
5452:
5453: p_ltt_salary_data(1).pay_basis_name:=

Line 5454: hr_transaction_api.get_varchar2_value

5450: (p_transaction_step_id => ln_transaction_step_id,
5451: p_name => 'p_currency');
5452:
5453: p_ltt_salary_data(1).pay_basis_name:=
5454: hr_transaction_api.get_varchar2_value
5455: (p_transaction_step_id => ln_transaction_step_id,
5456: p_name => 'p_pay_basis_name');
5457:
5458: p_ltt_salary_data(1).element_entry_id:=

Line 5459: hr_transaction_api.get_number_value

5455: (p_transaction_step_id => ln_transaction_step_id,
5456: p_name => 'p_pay_basis_name');
5457:
5458: p_ltt_salary_data(1).element_entry_id:=
5459: hr_transaction_api.get_number_value
5460: (p_transaction_step_id => ln_transaction_step_id,
5461: p_name => 'p_element_entry_id');
5462:
5463: p_ltt_salary_data(1).annual_equivalent:=

Line 5464: hr_transaction_api.get_number_value

5460: (p_transaction_step_id => ln_transaction_step_id,
5461: p_name => 'p_element_entry_id');
5462:
5463: p_ltt_salary_data(1).annual_equivalent:=
5464: hr_transaction_api.get_number_value
5465: (p_transaction_step_id => ln_transaction_step_id,
5466: p_name => 'p_annual_equivalent');
5467:
5468: if (uom='N') then

Line 5475: hr_transaction_api.get_number_value

5471: 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));
5472: end if;
5473:
5474: p_ltt_salary_data(1).total_percent:=
5475: hr_transaction_api.get_number_value
5476: (p_transaction_step_id => ln_transaction_step_id,
5477: p_name => 'p_total_percent');
5478:
5479: p_ltt_salary_data(1).selection_mode:=

Line 5480: hr_transaction_api.get_varchar2_value

5476: (p_transaction_step_id => ln_transaction_step_id,
5477: p_name => 'p_total_percent');
5478:
5479: p_ltt_salary_data(1).selection_mode:=
5480: hr_transaction_api.get_varchar2_value
5481: (p_transaction_step_id => ln_transaction_step_id,
5482: p_name => 'p_selection_mode');
5483:
5484: p_ltt_salary_data(1).quartile:=

Line 5485: hr_transaction_api.get_number_value

5481: (p_transaction_step_id => ln_transaction_step_id,
5482: p_name => 'p_selection_mode');
5483:
5484: p_ltt_salary_data(1).quartile:=
5485: hr_transaction_api.get_number_value
5486: (p_transaction_step_id => ln_transaction_step_id,
5487: p_name => 'p_quartile');
5488:
5489: p_ltt_salary_data(1).comparatio:=

Line 5490: hr_transaction_api.get_number_value

5486: (p_transaction_step_id => ln_transaction_step_id,
5487: p_name => 'p_quartile');
5488:
5489: p_ltt_salary_data(1).comparatio:=
5490: hr_transaction_api.get_number_value
5491: (p_transaction_step_id => ln_transaction_step_id,
5492: p_name => 'p_comparatio');
5493:
5494: p_ltt_salary_data(1).ranking:=

Line 5495: hr_transaction_api.get_number_value

5491: (p_transaction_step_id => ln_transaction_step_id,
5492: p_name => 'p_comparatio');
5493:
5494: p_ltt_salary_data(1).ranking:=
5495: hr_transaction_api.get_number_value
5496: (p_transaction_step_id => ln_transaction_step_id,
5497: p_name => 'p_ranking');
5498:
5499: p_ltt_salary_data(1).multiple_components:=

Line 5500: hr_transaction_api.get_varchar2_value

5496: (p_transaction_step_id => ln_transaction_step_id,
5497: p_name => 'p_ranking');
5498:
5499: p_ltt_salary_data(1).multiple_components:=
5500: hr_transaction_api.get_varchar2_value
5501: (p_transaction_step_id => ln_transaction_step_id,
5502: p_name => 'p_multiple_components');
5503:
5504: p_ltt_salary_data(1).comments:=

Line 5505: hr_transaction_api.get_varchar2_value

5501: (p_transaction_step_id => ln_transaction_step_id,
5502: p_name => 'p_multiple_components');
5503:
5504: p_ltt_salary_data(1).comments:=
5505: hr_transaction_api.get_varchar2_value
5506: (p_transaction_step_id => ln_transaction_step_id,
5507: p_name => 'p_comments');
5508:
5509: p_ltt_salary_data(1).attribute_category :=

Line 5510: hr_transaction_api.get_varchar2_value (

5506: (p_transaction_step_id => ln_transaction_step_id,
5507: p_name => 'p_comments');
5508:
5509: p_ltt_salary_data(1).attribute_category :=
5510: hr_transaction_api.get_varchar2_value (
5511: p_transaction_step_id => ln_transaction_step_id,
5512: p_name => 'p_attribute_category'
5513: );
5514:

Line 5516: hr_transaction_api.get_varchar2_value (

5512: p_name => 'p_attribute_category'
5513: );
5514:
5515: p_ltt_salary_data(1).attribute1 :=
5516: hr_transaction_api.get_varchar2_value (
5517: p_transaction_step_id => ln_transaction_step_id,
5518: p_name => 'p_attribute1'
5519: );
5520:

Line 5522: hr_transaction_api.get_varchar2_value (

5518: p_name => 'p_attribute1'
5519: );
5520:
5521: p_ltt_salary_data(1).attribute2 :=
5522: hr_transaction_api.get_varchar2_value (
5523: p_transaction_step_id => ln_transaction_step_id,
5524: p_name => 'p_attribute2'
5525: );
5526:

Line 5528: hr_transaction_api.get_varchar2_value (

5524: p_name => 'p_attribute2'
5525: );
5526:
5527: p_ltt_salary_data(1).attribute3 :=
5528: hr_transaction_api.get_varchar2_value (
5529: p_transaction_step_id => ln_transaction_step_id,
5530: p_name => 'p_attribute3'
5531: );
5532:

Line 5534: hr_transaction_api.get_varchar2_value (

5530: p_name => 'p_attribute3'
5531: );
5532:
5533: p_ltt_salary_data(1).attribute4 :=
5534: hr_transaction_api.get_varchar2_value (
5535: p_transaction_step_id => ln_transaction_step_id,
5536: p_name => 'p_attribute4'
5537: );
5538:

Line 5541: hr_transaction_api.get_varchar2_value (

5537: );
5538:
5539:
5540: p_ltt_salary_data(1).attribute5 :=
5541: hr_transaction_api.get_varchar2_value (
5542: p_transaction_step_id => ln_transaction_step_id,
5543: p_name => 'p_attribute5'
5544: );
5545:

Line 5547: hr_transaction_api.get_varchar2_value (

5543: p_name => 'p_attribute5'
5544: );
5545:
5546: p_ltt_salary_data(1).attribute6 :=
5547: hr_transaction_api.get_varchar2_value (
5548: p_transaction_step_id => ln_transaction_step_id,
5549: p_name => 'p_attribute6'
5550: );
5551:

Line 5554: hr_transaction_api.get_varchar2_value (

5550: );
5551:
5552:
5553: p_ltt_salary_data(1).attribute7 :=
5554: hr_transaction_api.get_varchar2_value (
5555: p_transaction_step_id => ln_transaction_step_id,
5556: p_name => 'p_attribute7'
5557: );
5558:

Line 5560: hr_transaction_api.get_varchar2_value (

5556: p_name => 'p_attribute7'
5557: );
5558:
5559: p_ltt_salary_data(1).attribute8 :=
5560: hr_transaction_api.get_varchar2_value (
5561: p_transaction_step_id => ln_transaction_step_id,
5562: p_name => 'p_attribute8'
5563: );
5564:

Line 5566: hr_transaction_api.get_varchar2_value (

5562: p_name => 'p_attribute8'
5563: );
5564:
5565: p_ltt_salary_data(1).attribute9 :=
5566: hr_transaction_api.get_varchar2_value (
5567: p_transaction_step_id => ln_transaction_step_id,
5568: p_name => 'p_attribute9'
5569: );
5570:

Line 5572: hr_transaction_api.get_varchar2_value (

5568: p_name => 'p_attribute9'
5569: );
5570:
5571: p_ltt_salary_data(1).attribute10 :=
5572: hr_transaction_api.get_varchar2_value (
5573: p_transaction_step_id => ln_transaction_step_id,
5574: p_name => 'p_attribute10'
5575: );
5576:

Line 5578: hr_transaction_api.get_varchar2_value (

5574: p_name => 'p_attribute10'
5575: );
5576:
5577: p_ltt_salary_data(1).attribute11 :=
5578: hr_transaction_api.get_varchar2_value (
5579: p_transaction_step_id => ln_transaction_step_id,
5580: p_name => 'p_attribute11'
5581: );
5582:

Line 5584: hr_transaction_api.get_varchar2_value (

5580: p_name => 'p_attribute11'
5581: );
5582:
5583: p_ltt_salary_data(1).attribute12 :=
5584: hr_transaction_api.get_varchar2_value (
5585: p_transaction_step_id => ln_transaction_step_id,
5586: p_name => 'p_attribute12'
5587: );
5588:

Line 5590: hr_transaction_api.get_varchar2_value (

5586: p_name => 'p_attribute12'
5587: );
5588:
5589: p_ltt_salary_data(1).attribute13 :=
5590: hr_transaction_api.get_varchar2_value (
5591: p_transaction_step_id => ln_transaction_step_id,
5592: p_name => 'p_attribute13'
5593: );
5594:

Line 5596: hr_transaction_api.get_varchar2_value (

5592: p_name => 'p_attribute13'
5593: );
5594:
5595: p_ltt_salary_data(1).attribute14 :=
5596: hr_transaction_api.get_varchar2_value (
5597: p_transaction_step_id => ln_transaction_step_id,
5598: p_name => 'p_attribute14'
5599: );
5600:

Line 5602: hr_transaction_api.get_varchar2_value (

5598: p_name => 'p_attribute14'
5599: );
5600:
5601: p_ltt_salary_data(1).attribute15 :=
5602: hr_transaction_api.get_varchar2_value (
5603: p_transaction_step_id => ln_transaction_step_id,
5604: p_name => 'p_attribute15'
5605: );
5606:

Line 5608: hr_transaction_api.get_varchar2_value (

5604: p_name => 'p_attribute15'
5605: );
5606:
5607: p_ltt_salary_data(1).attribute16 :=
5608: hr_transaction_api.get_varchar2_value (
5609: p_transaction_step_id => ln_transaction_step_id,
5610: p_name => 'p_attribute16'
5611: );
5612:

Line 5615: hr_transaction_api.get_varchar2_value (

5611: );
5612:
5613:
5614: p_ltt_salary_data(1).attribute17 :=
5615: hr_transaction_api.get_varchar2_value (
5616: p_transaction_step_id => ln_transaction_step_id,
5617: p_name => 'p_attribute17'
5618: );
5619:

Line 5621: hr_transaction_api.get_varchar2_value (

5617: p_name => 'p_attribute17'
5618: );
5619:
5620: p_ltt_salary_data(1).attribute18 :=
5621: hr_transaction_api.get_varchar2_value (
5622: p_transaction_step_id => ln_transaction_step_id,
5623: p_name => 'p_attribute18'
5624: );
5625:

Line 5627: hr_transaction_api.get_varchar2_value (

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

Line 5633: hr_transaction_api.get_varchar2_value (

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

Line 5639: hr_transaction_api.get_number_value (

5635: p_name => 'p_attribute20'
5636: );
5637:
5638: p_ltt_salary_data(1).no_of_components :=
5639: hr_transaction_api.get_number_value (
5640: p_transaction_step_id => ln_transaction_step_id,
5641: p_name => 'p_no_of_components'
5642: );
5643:

Line 5646: hr_transaction_api.get_varchar2_value (

5642: );
5643:
5644: -- 04/12/02 Salary Basis Enhancement Begins
5645: p_ltt_salary_data(1).salary_basis_change_type :=
5646: hr_transaction_api.get_varchar2_value (
5647: p_transaction_step_id => ln_transaction_step_id,
5648: p_name => 'p_salary_basis_change_type'
5649: );
5650:

Line 5652: hr_transaction_api.get_date_value (

5648: p_name => 'p_salary_basis_change_type'
5649: );
5650:
5651: p_ltt_salary_data(1).default_date :=
5652: hr_transaction_api.get_date_value (
5653: p_transaction_step_id => ln_transaction_step_id,
5654: p_name => 'p_default_date'
5655: );
5656:

Line 5658: hr_transaction_api.get_number_value (

5654: p_name => 'p_default_date'
5655: );
5656:
5657: p_ltt_salary_data(1).default_bg_id :=
5658: hr_transaction_api.get_number_value (
5659: p_transaction_step_id => ln_transaction_step_id,
5660: p_name => 'p_default_bg_id'
5661: );
5662:

Line 5664: hr_transaction_api.get_varchar2_value (

5660: p_name => 'p_default_bg_id'
5661: );
5662:
5663: p_ltt_salary_data(1).default_currency :=
5664: hr_transaction_api.get_varchar2_value (
5665: p_transaction_step_id => ln_transaction_step_id,
5666: p_name => 'p_default_currency'
5667: );
5668:

Line 5670: hr_transaction_api.get_varchar2_value (

5666: p_name => 'p_default_currency'
5667: );
5668:
5669: p_ltt_salary_data(1).default_format_string :=
5670: hr_transaction_api.get_varchar2_value (
5671: p_transaction_step_id => ln_transaction_step_id,
5672: p_name => 'p_default_format_string'
5673: );
5674:

Line 5676: hr_transaction_api.get_varchar2_value (

5672: p_name => 'p_default_format_string'
5673: );
5674:
5675: p_ltt_salary_data(1).default_salary_basis_name :=
5676: hr_transaction_api.get_varchar2_value (
5677: p_transaction_step_id => ln_transaction_step_id,
5678: p_name => 'p_default_salary_basis_name'
5679: );
5680:

Line 5682: hr_transaction_api.get_varchar2_value (

5678: p_name => 'p_default_salary_basis_name'
5679: );
5680:
5681: p_ltt_salary_data(1).default_pay_basis_name :=
5682: hr_transaction_api.get_varchar2_value (
5683: p_transaction_step_id => ln_transaction_step_id,
5684: p_name => 'p_default_pay_basis_name'
5685: );
5686:

Line 5688: hr_transaction_api.get_varchar2_value (

5684: p_name => 'p_default_pay_basis_name'
5685: );
5686:
5687: p_ltt_salary_data(1).default_pay_basis :=
5688: hr_transaction_api.get_varchar2_value (
5689: p_transaction_step_id => ln_transaction_step_id,
5690: p_name => 'p_default_pay_basis'
5691: );
5692:

Line 5694: hr_transaction_api.get_number_value (

5690: p_name => 'p_default_pay_basis'
5691: );
5692:
5693: p_ltt_salary_data(1).default_pay_annual_factor :=
5694: hr_transaction_api.get_number_value (
5695: p_transaction_step_id => ln_transaction_step_id,
5696: p_name => 'p_default_pay_annual_factor'
5697: );
5698:

Line 5714: hr_transaction_api.get_varchar2_value (

5710: p_ltt_salary_data(1).curr_ann_eqv_mc := hr_util_misc_ss.get_in_preferred_currency_str((l_factor*p_ltt_salary_data(1).current_salary),lv_tmp_currency,trunc(sysdate));
5711: end if;
5712:
5713: p_ltt_salary_data(1).default_grade :=
5714: hr_transaction_api.get_varchar2_value (
5715: p_transaction_step_id => ln_transaction_step_id,
5716: p_name => 'p_default_grade'
5717: );
5718:

Line 5720: hr_transaction_api.get_number_value (

5716: p_name => 'p_default_grade'
5717: );
5718:
5719: p_ltt_salary_data(1).default_grade_annual_factor :=
5720: hr_transaction_api.get_number_value (
5721: p_transaction_step_id => ln_transaction_step_id,
5722: p_name => 'p_default_grade_annual_factor'
5723: );
5724:

Line 5726: hr_transaction_api.get_number_value (

5722: p_name => 'p_default_grade_annual_factor'
5723: );
5724:
5725: p_ltt_salary_data(1).default_minimum_salary :=
5726: hr_transaction_api.get_number_value (
5727: p_transaction_step_id => ln_transaction_step_id,
5728: p_name => 'p_default_minimum_salary'
5729: );
5730:

Line 5732: hr_transaction_api.get_number_value (

5728: p_name => 'p_default_minimum_salary'
5729: );
5730:
5731: p_ltt_salary_data(1).default_maximum_salary :=
5732: hr_transaction_api.get_number_value (
5733: p_transaction_step_id => ln_transaction_step_id,
5734: p_name => 'p_default_maximum_salary'
5735: );
5736:

Line 5738: hr_transaction_api.get_number_value (

5734: p_name => 'p_default_maximum_salary'
5735: );
5736:
5737: p_ltt_salary_data(1).default_midpoint_salary :=
5738: hr_transaction_api.get_number_value (
5739: p_transaction_step_id => ln_transaction_step_id,
5740: p_name => 'p_default_midpoint_salary'
5741: );
5742:

Line 5744: hr_transaction_api.get_number_value (

5740: p_name => 'p_default_midpoint_salary'
5741: );
5742:
5743: p_ltt_salary_data(1).default_prev_salary :=
5744: hr_transaction_api.get_number_value (
5745: p_transaction_step_id => ln_transaction_step_id,
5746: p_name => 'p_default_prev_salary'
5747: );
5748:

Line 5750: hr_transaction_api.get_date_value (

5746: p_name => 'p_default_prev_salary'
5747: );
5748:
5749: p_ltt_salary_data(1).default_last_change_date :=
5750: hr_transaction_api.get_date_value (
5751: p_transaction_step_id => ln_transaction_step_id,
5752: p_name => 'p_default_last_change_date'
5753: );
5754:

Line 5756: hr_transaction_api.get_number_value (

5752: p_name => 'p_default_last_change_date'
5753: );
5754:
5755: p_ltt_salary_data(1).default_element_entry_id :=
5756: hr_transaction_api.get_number_value (
5757: p_transaction_step_id => ln_transaction_step_id,
5758: p_name => 'p_default_element_entry_id'
5759: );
5760:

Line 5762: hr_transaction_api.get_number_value (

5758: p_name => 'p_default_element_entry_id'
5759: );
5760:
5761: p_ltt_salary_data(1).default_basis_changed :=
5762: hr_transaction_api.get_number_value (
5763: p_transaction_step_id => ln_transaction_step_id,
5764: p_name => 'p_default_basis_changed'
5765: );
5766:

Line 5768: hr_transaction_api.get_varchar2_value (

5764: p_name => 'p_default_basis_changed'
5765: );
5766:
5767: p_ltt_salary_data(1).default_uom :=
5768: hr_transaction_api.get_varchar2_value (
5769: p_transaction_step_id => ln_transaction_step_id,
5770: p_name => 'p_default_uom'
5771: );
5772:

Line 5774: hr_transaction_api.get_varchar2_value (

5770: p_name => 'p_default_uom'
5771: );
5772:
5773: p_ltt_salary_data(1).default_grade_uom :=
5774: hr_transaction_api.get_varchar2_value (
5775: p_transaction_step_id => ln_transaction_step_id,
5776: p_name => 'p_default_grade_uom'
5777: );
5778:

Line 5780: hr_transaction_api.get_number_value (

5776: p_name => 'p_default_grade_uom'
5777: );
5778:
5779: p_ltt_salary_data(1).default_change_amount :=
5780: hr_transaction_api.get_number_value (
5781: p_transaction_step_id => ln_transaction_step_id,
5782: p_name => 'p_default_change_amount'
5783: );
5784:

Line 5786: hr_transaction_api.get_number_value (

5782: p_name => 'p_default_change_amount'
5783: );
5784:
5785: p_ltt_salary_data(1).default_change_percent :=
5786: hr_transaction_api.get_number_value (
5787: p_transaction_step_id => ln_transaction_step_id,
5788: p_name => 'p_default_change_percent'
5789: );
5790:

Line 5792: hr_transaction_api.get_number_value (

5788: p_name => 'p_default_change_percent'
5789: );
5790:
5791: p_ltt_salary_data(1).default_quartile :=
5792: hr_transaction_api.get_number_value (
5793: p_transaction_step_id => ln_transaction_step_id,
5794: p_name => 'p_default_quartile'
5795: );
5796:

Line 5798: hr_transaction_api.get_number_value (

5794: p_name => 'p_default_quartile'
5795: );
5796:
5797: p_ltt_salary_data(1).default_comparatio :=
5798: hr_transaction_api.get_number_value (
5799: p_transaction_step_id => ln_transaction_step_id,
5800: p_name => 'p_default_comparatio'
5801: );
5802:

Line 5804: hr_transaction_api.get_varchar2_value (

5800: p_name => 'p_default_comparatio'
5801: );
5802:
5803: p_ltt_salary_data(1).default_last_pay_change :=
5804: hr_transaction_api.get_varchar2_value (
5805: p_transaction_step_id => ln_transaction_step_id,
5806: p_name => 'p_default_last_pay_change'
5807: );
5808:

Line 5810: hr_transaction_api.get_varchar2_value (

5806: p_name => 'p_default_last_pay_change'
5807: );
5808:
5809: p_ltt_salary_data(1).default_flsa_status :=
5810: hr_transaction_api.get_varchar2_value (
5811: p_transaction_step_id => ln_transaction_step_id,
5812: p_name => 'p_default_flsa_status'
5813: );
5814:

Line 5816: hr_transaction_api.get_varchar2_value (

5812: p_name => 'p_default_flsa_status'
5813: );
5814:
5815: p_ltt_salary_data(1).default_currency_symbol :=
5816: hr_transaction_api.get_varchar2_value (
5817: p_transaction_step_id => ln_transaction_step_id,
5818: p_name => 'p_default_currency_symbol'
5819: );
5820:

Line 5822: hr_transaction_api.get_number_value (

5818: p_name => 'p_default_currency_symbol'
5819: );
5820:
5821: p_ltt_salary_data(1).default_precision :=
5822: hr_transaction_api.get_number_value (
5823: p_transaction_step_id => ln_transaction_step_id,
5824: p_name => 'p_default_precision'
5825: );
5826:

Line 5831: hr_transaction_api.get_number_value

5827: -- 04/12/02 Salary Basis Enhancement Ends'
5828:
5829: -- now get the component records
5830: ln_no_of_components :=
5831: hr_transaction_api.get_number_value
5832: (p_transaction_step_id => ln_transaction_step_id,
5833: p_name => 'p_no_of_components');
5834:
5835: FOR i in 1..ln_no_of_components

Line 5840: hr_transaction_api.get_number_value

5836: LOOP
5837:
5838: --hr_utility.trace(' Retrieving ' || i || ' compoent ');
5839: p_ltt_component(i).change_amount :=
5840: hr_transaction_api.get_number_value
5841: (p_transaction_step_id => ln_transaction_step_id,
5842: p_name => 'p_change_amount'||i);
5843:
5844: if (uom='N') then

Line 5851: hr_transaction_api.get_varchar2_value

5847: 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));
5848: end if;
5849:
5850: p_ltt_component(i).component_reason :=
5851: hr_transaction_api.get_varchar2_value
5852: (p_transaction_step_id => ln_transaction_step_id,
5853: p_name => 'p_component_reason'||i);
5854:
5855: p_ltt_component(i).reason_meaning :=

Line 5856: hr_transaction_api.get_varchar2_value

5852: (p_transaction_step_id => ln_transaction_step_id,
5853: p_name => 'p_component_reason'||i);
5854:
5855: p_ltt_component(i).reason_meaning :=
5856: hr_transaction_api.get_varchar2_value
5857: (p_transaction_step_id => ln_transaction_step_id,
5858: p_name => 'p_reason_meaning'||i);
5859: /*
5860: hr_misc_web.get_lookup_meaning(

Line 5868: hr_transaction_api.get_number_value

5864: hr_utility.trace('reason_meaning ' || p_ltt_component(i).reason_meaning);
5865: */
5866:
5867: p_ltt_component(i).change_percent :=
5868: hr_transaction_api.get_number_value
5869: (p_transaction_step_id => ln_transaction_step_id,
5870: p_name => 'p_change_percent'||i);
5871:
5872: p_ltt_component(i).change_annual :=

Line 5873: hr_transaction_api.get_number_value

5869: (p_transaction_step_id => ln_transaction_step_id,
5870: p_name => 'p_change_percent'||i);
5871:
5872: p_ltt_component(i).change_annual :=
5873: hr_transaction_api.get_number_value
5874: (p_transaction_step_id => ln_transaction_step_id,
5875: p_name => 'p_change_annual'||i);
5876:
5877: p_ltt_component(i).comments :=

Line 5878: hr_transaction_api.get_varchar2_value

5874: (p_transaction_step_id => ln_transaction_step_id,
5875: p_name => 'p_change_annual'||i);
5876:
5877: p_ltt_component(i).comments :=
5878: hr_transaction_api.get_varchar2_value
5879: (p_transaction_step_id => ln_transaction_step_id,
5880: p_name => 'p_comments'||i);
5881:
5882: p_ltt_component(i).approved :=

Line 5883: hr_transaction_api.get_varchar2_value

5879: (p_transaction_step_id => ln_transaction_step_id,
5880: p_name => 'p_comments'||i);
5881:
5882: p_ltt_component(i).approved :=
5883: hr_transaction_api.get_varchar2_value
5884: (p_transaction_step_id => ln_transaction_step_id,
5885: p_name => 'p_approved'||i);
5886:
5887: p_ltt_component(i).attribute_category :=

Line 5888: hr_transaction_api.get_varchar2_value

5884: (p_transaction_step_id => ln_transaction_step_id,
5885: p_name => 'p_approved'||i);
5886:
5887: p_ltt_component(i).attribute_category :=
5888: hr_transaction_api.get_varchar2_value
5889: (p_transaction_step_id => ln_transaction_step_id,
5890: p_name => 'p_cattribute_category'||i);
5891:
5892: p_ltt_component(i).attribute1 :=

Line 5893: hr_transaction_api.get_varchar2_value

5889: (p_transaction_step_id => ln_transaction_step_id,
5890: p_name => 'p_cattribute_category'||i);
5891:
5892: p_ltt_component(i).attribute1 :=
5893: hr_transaction_api.get_varchar2_value
5894: (p_transaction_step_id => ln_transaction_step_id,
5895: p_name => 'p_cattribute1'||i);
5896:
5897: p_ltt_component(i).attribute2:=

Line 5898: hr_transaction_api.get_varchar2_value

5894: (p_transaction_step_id => ln_transaction_step_id,
5895: p_name => 'p_cattribute1'||i);
5896:
5897: p_ltt_component(i).attribute2:=
5898: hr_transaction_api.get_varchar2_value
5899: (p_transaction_step_id => ln_transaction_step_id,
5900: p_name => 'p_cattribute2'||i);
5901:
5902: p_ltt_component(i).attribute3 :=

Line 5903: hr_transaction_api.get_varchar2_value

5899: (p_transaction_step_id => ln_transaction_step_id,
5900: p_name => 'p_cattribute2'||i);
5901:
5902: p_ltt_component(i).attribute3 :=
5903: hr_transaction_api.get_varchar2_value
5904: (p_transaction_step_id => ln_transaction_step_id,
5905: p_name => 'p_cattribute3'||i);
5906:
5907: p_ltt_component(i).attribute4 :=

Line 5908: hr_transaction_api.get_varchar2_value

5904: (p_transaction_step_id => ln_transaction_step_id,
5905: p_name => 'p_cattribute3'||i);
5906:
5907: p_ltt_component(i).attribute4 :=
5908: hr_transaction_api.get_varchar2_value
5909: (p_transaction_step_id => ln_transaction_step_id,
5910: p_name => 'p_cattribute4'||i);
5911:
5912: p_ltt_component(i).attribute5 :=

Line 5913: hr_transaction_api.get_varchar2_value

5909: (p_transaction_step_id => ln_transaction_step_id,
5910: p_name => 'p_cattribute4'||i);
5911:
5912: p_ltt_component(i).attribute5 :=
5913: hr_transaction_api.get_varchar2_value
5914: (p_transaction_step_id => ln_transaction_step_id,
5915: p_name => 'p_cattribute5'||i);
5916:
5917: -- hr_utility.trace('p_cattribute5 ');

Line 5920: hr_transaction_api.get_varchar2_value

5916:
5917: -- hr_utility.trace('p_cattribute5 ');
5918:
5919: p_ltt_component(i).attribute6 :=
5920: hr_transaction_api.get_varchar2_value
5921: (p_transaction_step_id => ln_transaction_step_id,
5922: p_name => 'p_cattribute6'||i);
5923:
5924: p_ltt_component(i).attribute7 :=

Line 5925: hr_transaction_api.get_varchar2_value

5921: (p_transaction_step_id => ln_transaction_step_id,
5922: p_name => 'p_cattribute6'||i);
5923:
5924: p_ltt_component(i).attribute7 :=
5925: hr_transaction_api.get_varchar2_value
5926: (p_transaction_step_id => ln_transaction_step_id,
5927: p_name => 'p_cattribute7'||i);
5928:
5929: -- hr_utility.trace('p_cattribute7 ');

Line 5933: hr_transaction_api.get_varchar2_value

5929: -- hr_utility.trace('p_cattribute7 ');
5930:
5931:
5932: p_ltt_component(i).attribute8 :=
5933: hr_transaction_api.get_varchar2_value
5934: (p_transaction_step_id => ln_transaction_step_id,
5935: p_name => 'p_cattribute8'||i);
5936:
5937: p_ltt_component(i).attribute9 :=

Line 5938: hr_transaction_api.get_varchar2_value

5934: (p_transaction_step_id => ln_transaction_step_id,
5935: p_name => 'p_cattribute8'||i);
5936:
5937: p_ltt_component(i).attribute9 :=
5938: hr_transaction_api.get_varchar2_value
5939: (p_transaction_step_id => ln_transaction_step_id,
5940: p_name => 'p_cattribute9'||i);
5941:
5942: -- hr_utility.trace('p_cattribute9 ');

Line 5945: hr_transaction_api.get_varchar2_value

5941:
5942: -- hr_utility.trace('p_cattribute9 ');
5943:
5944: p_ltt_component(i).attribute10 :=
5945: hr_transaction_api.get_varchar2_value
5946: (p_transaction_step_id => ln_transaction_step_id,
5947: p_name => 'p_cattribute10'||i);
5948:
5949: p_ltt_component(i).attribute11 :=

Line 5950: hr_transaction_api.get_varchar2_value

5946: (p_transaction_step_id => ln_transaction_step_id,
5947: p_name => 'p_cattribute10'||i);
5948:
5949: p_ltt_component(i).attribute11 :=
5950: hr_transaction_api.get_varchar2_value
5951: (p_transaction_step_id => ln_transaction_step_id,
5952: p_name => 'p_cattribute11'||i);
5953:
5954: p_ltt_component(i).attribute12 :=

Line 5955: hr_transaction_api.get_varchar2_value

5951: (p_transaction_step_id => ln_transaction_step_id,
5952: p_name => 'p_cattribute11'||i);
5953:
5954: p_ltt_component(i).attribute12 :=
5955: hr_transaction_api.get_varchar2_value
5956: (p_transaction_step_id => ln_transaction_step_id,
5957: p_name => 'p_cattribute12'||i);
5958:
5959: -- hr_utility.trace('p_cattribute12 ');

Line 5962: hr_transaction_api.get_varchar2_value

5958:
5959: -- hr_utility.trace('p_cattribute12 ');
5960:
5961: p_ltt_component(i).attribute13 :=
5962: hr_transaction_api.get_varchar2_value
5963: (p_transaction_step_id => ln_transaction_step_id,
5964: p_name => 'p_cattribute13'||i);
5965:
5966: p_ltt_component(i).attribute14 :=

Line 5967: hr_transaction_api.get_varchar2_value

5963: (p_transaction_step_id => ln_transaction_step_id,
5964: p_name => 'p_cattribute13'||i);
5965:
5966: p_ltt_component(i).attribute14 :=
5967: hr_transaction_api.get_varchar2_value
5968: (p_transaction_step_id => ln_transaction_step_id,
5969: p_name => 'p_cattribute14'||i);
5970:
5971: -- hr_utility.trace('p_cattribute14 ');

Line 5974: hr_transaction_api.get_varchar2_value

5970:
5971: -- hr_utility.trace('p_cattribute14 ');
5972:
5973: p_ltt_component(i).attribute15 :=
5974: hr_transaction_api.get_varchar2_value
5975: (p_transaction_step_id => ln_transaction_step_id,
5976: p_name => 'p_cattribute15'||i);
5977:
5978: p_ltt_component(i).attribute16 :=

Line 5979: hr_transaction_api.get_varchar2_value

5975: (p_transaction_step_id => ln_transaction_step_id,
5976: p_name => 'p_cattribute15'||i);
5977:
5978: p_ltt_component(i).attribute16 :=
5979: hr_transaction_api.get_varchar2_value
5980: (p_transaction_step_id => ln_transaction_step_id,
5981: p_name => 'p_cattribute16'||i);
5982:
5983: -- hr_utility.trace('p_cattribute16 ');

Line 5986: hr_transaction_api.get_varchar2_value

5982:
5983: -- hr_utility.trace('p_cattribute16 ');
5984:
5985: p_ltt_component(i).attribute17 :=
5986: hr_transaction_api.get_varchar2_value
5987: (p_transaction_step_id => ln_transaction_step_id,
5988: p_name => 'p_cattribute17'||i);
5989:
5990: p_ltt_component(i).attribute18 :=

Line 5991: hr_transaction_api.get_varchar2_value

5987: (p_transaction_step_id => ln_transaction_step_id,
5988: p_name => 'p_cattribute17'||i);
5989:
5990: p_ltt_component(i).attribute18 :=
5991: hr_transaction_api.get_varchar2_value
5992: (p_transaction_step_id => ln_transaction_step_id,
5993: p_name => 'p_cattribute18'||i);
5994:
5995: -- hr_utility.trace('p_cattribute18 ');

Line 5998: hr_transaction_api.get_varchar2_value

5994:
5995: -- hr_utility.trace('p_cattribute18 ');
5996:
5997: p_ltt_component(i).attribute19 :=
5998: hr_transaction_api.get_varchar2_value
5999: (p_transaction_step_id => ln_transaction_step_id,
6000: p_name => 'p_cattribute19'||i);
6001:
6002: p_ltt_component(i).attribute20 :=

Line 6003: hr_transaction_api.get_varchar2_value

5999: (p_transaction_step_id => ln_transaction_step_id,
6000: p_name => 'p_cattribute19'||i);
6001:
6002: p_ltt_component(i).attribute20 :=
6003: hr_transaction_api.get_varchar2_value
6004: (p_transaction_step_id => ln_transaction_step_id,
6005: p_name => 'p_cattribute20'||i);
6006:
6007: -- hr_utility.trace('p_cattribute20 ' || p_ltt_component(i).attribute20);

Line 6270: hr_transaction_api.get_transaction_step_info(

6266: null, null, null, null, null, null, null, null, null )
6267: );
6268:
6269:
6270: hr_transaction_api.get_transaction_step_info(
6271: p_transaction_step_id => p_transaction_step_id
6272: ,p_item_type => lv_item_type
6273: ,p_item_key => lv_item_key
6274: ,p_activity_id => ln_act_id);