APPS.PQP_SS_VEHICLE_MILEAGE_CLAIMS dependencies on HR_TRANSACTION_API

Line 163: hr_transaction_api.get_number_Value

159: csr ref_cursor;
160: BEGIN
161: OPEN csr FOR
162: SELECT
163: hr_transaction_api.get_number_Value
164: (p_transaction_step_id, 'P_LOGIN_PERSON_ID') login_person_id
165: ,hr_transaction_api.get_number_Value
166: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
167: ,hr_transaction_api.get_number_Value

Line 165: ,hr_transaction_api.get_number_Value

161: OPEN csr FOR
162: SELECT
163: hr_transaction_api.get_number_Value
164: (p_transaction_step_id, 'P_LOGIN_PERSON_ID') login_person_id
165: ,hr_transaction_api.get_number_Value
166: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
167: ,hr_transaction_api.get_number_Value
168: (p_transaction_step_id, 'P_ASSIGNMENT_ID') assignment_id
169: ,hr_transaction_api.get_number_Value

Line 167: ,hr_transaction_api.get_number_Value

163: hr_transaction_api.get_number_Value
164: (p_transaction_step_id, 'P_LOGIN_PERSON_ID') login_person_id
165: ,hr_transaction_api.get_number_Value
166: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
167: ,hr_transaction_api.get_number_Value
168: (p_transaction_step_id, 'P_ASSIGNMENT_ID') assignment_id
169: ,hr_transaction_api.get_number_Value
170: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
171: ,hr_transaction_api.get_number_Value

Line 169: ,hr_transaction_api.get_number_Value

165: ,hr_transaction_api.get_number_Value
166: (p_transaction_step_id, 'P_PERSON_ID' ) person_id
167: ,hr_transaction_api.get_number_Value
168: (p_transaction_step_id, 'P_ASSIGNMENT_ID') assignment_id
169: ,hr_transaction_api.get_number_Value
170: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
171: ,hr_transaction_api.get_number_Value
172: (p_transaction_step_id, 'P_ITEM_KEY') item_key
173: ,hr_transaction_api.get_number_Value

Line 171: ,hr_transaction_api.get_number_Value

167: ,hr_transaction_api.get_number_Value
168: (p_transaction_step_id, 'P_ASSIGNMENT_ID') assignment_id
169: ,hr_transaction_api.get_number_Value
170: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
171: ,hr_transaction_api.get_number_Value
172: (p_transaction_step_id, 'P_ITEM_KEY') item_key
173: ,hr_transaction_api.get_number_Value
174: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
175: ,hr_transaction_api.get_varchar2_Value

Line 173: ,hr_transaction_api.get_number_Value

169: ,hr_transaction_api.get_number_Value
170: (p_transaction_step_id ,'P_ITEM_TYPE') item_type
171: ,hr_transaction_api.get_number_Value
172: (p_transaction_step_id, 'P_ITEM_KEY') item_key
173: ,hr_transaction_api.get_number_Value
174: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
175: ,hr_transaction_api.get_varchar2_Value
176: (p_transaction_step_id, 'P_REGISTRATION_NUMBER' ) registration_number
177: ,hr_transaction_api.get_varchar2_Value

Line 175: ,hr_transaction_api.get_varchar2_Value

171: ,hr_transaction_api.get_number_Value
172: (p_transaction_step_id, 'P_ITEM_KEY') item_key
173: ,hr_transaction_api.get_number_Value
174: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
175: ,hr_transaction_api.get_varchar2_Value
176: (p_transaction_step_id, 'P_REGISTRATION_NUMBER' ) registration_number
177: ,hr_transaction_api.get_varchar2_Value
178: (p_transaction_step_id, 'P_OWNERSHIP') ownership
179: ,hr_transaction_api.get_varchar2_Value

Line 177: ,hr_transaction_api.get_varchar2_Value

173: ,hr_transaction_api.get_number_Value
174: (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
175: ,hr_transaction_api.get_varchar2_Value
176: (p_transaction_step_id, 'P_REGISTRATION_NUMBER' ) registration_number
177: ,hr_transaction_api.get_varchar2_Value
178: (p_transaction_step_id, 'P_OWNERSHIP') ownership
179: ,hr_transaction_api.get_varchar2_Value
180: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
181: ,hr_transaction_api.get_date_Value

Line 179: ,hr_transaction_api.get_varchar2_Value

175: ,hr_transaction_api.get_varchar2_Value
176: (p_transaction_step_id, 'P_REGISTRATION_NUMBER' ) registration_number
177: ,hr_transaction_api.get_varchar2_Value
178: (p_transaction_step_id, 'P_OWNERSHIP') ownership
179: ,hr_transaction_api.get_varchar2_Value
180: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
181: ,hr_transaction_api.get_date_Value
182: (p_transaction_step_id, 'P_START_DATE') start_date
183: ,hr_transaction_api.get_date_Value

Line 181: ,hr_transaction_api.get_date_Value

177: ,hr_transaction_api.get_varchar2_Value
178: (p_transaction_step_id, 'P_OWNERSHIP') ownership
179: ,hr_transaction_api.get_varchar2_Value
180: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
181: ,hr_transaction_api.get_date_Value
182: (p_transaction_step_id, 'P_START_DATE') start_date
183: ,hr_transaction_api.get_date_Value
184: (p_transaction_step_id, 'P_END_DATE' ) end_date
185: ,hr_transaction_api.get_varchar2_Value

Line 183: ,hr_transaction_api.get_date_Value

179: ,hr_transaction_api.get_varchar2_Value
180: (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
181: ,hr_transaction_api.get_date_Value
182: (p_transaction_step_id, 'P_START_DATE') start_date
183: ,hr_transaction_api.get_date_Value
184: (p_transaction_step_id, 'P_END_DATE' ) end_date
185: ,hr_transaction_api.get_varchar2_Value
186: (p_transaction_step_id, 'P_CLAIMED_MILEAGE' ) claimed_mileage
187: ,hr_transaction_api.get_varchar2_Value

Line 185: ,hr_transaction_api.get_varchar2_Value

181: ,hr_transaction_api.get_date_Value
182: (p_transaction_step_id, 'P_START_DATE') start_date
183: ,hr_transaction_api.get_date_Value
184: (p_transaction_step_id, 'P_END_DATE' ) end_date
185: ,hr_transaction_api.get_varchar2_Value
186: (p_transaction_step_id, 'P_CLAIMED_MILEAGE' ) claimed_mileage
187: ,hr_transaction_api.get_varchar2_Value
188: (p_transaction_step_id, 'P_ACTUAL_MILEAGE' ) actual_mileage
189: ,hr_transaction_api.get_number_Value

Line 187: ,hr_transaction_api.get_varchar2_Value

183: ,hr_transaction_api.get_date_Value
184: (p_transaction_step_id, 'P_END_DATE' ) end_date
185: ,hr_transaction_api.get_varchar2_Value
186: (p_transaction_step_id, 'P_CLAIMED_MILEAGE' ) claimed_mileage
187: ,hr_transaction_api.get_varchar2_Value
188: (p_transaction_step_id, 'P_ACTUAL_MILEAGE' ) actual_mileage
189: ,hr_transaction_api.get_number_Value
190: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
191: ,hr_transaction_api.get_varchar2_Value

Line 189: ,hr_transaction_api.get_number_Value

185: ,hr_transaction_api.get_varchar2_Value
186: (p_transaction_step_id, 'P_CLAIMED_MILEAGE' ) claimed_mileage
187: ,hr_transaction_api.get_varchar2_Value
188: (p_transaction_step_id, 'P_ACTUAL_MILEAGE' ) actual_mileage
189: ,hr_transaction_api.get_number_Value
190: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
191: ,hr_transaction_api.get_varchar2_Value
192: (p_transaction_step_id, 'P_ENGINE_CAPACITY' ) engine_capacity
193: ,hr_transaction_api.get_varchar2_Value

Line 191: ,hr_transaction_api.get_varchar2_Value

187: ,hr_transaction_api.get_varchar2_Value
188: (p_transaction_step_id, 'P_ACTUAL_MILEAGE' ) actual_mileage
189: ,hr_transaction_api.get_number_Value
190: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
191: ,hr_transaction_api.get_varchar2_Value
192: (p_transaction_step_id, 'P_ENGINE_CAPACITY' ) engine_capacity
193: ,hr_transaction_api.get_varchar2_Value
194: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
195: ,hr_transaction_api.get_varchar2_Value

Line 193: ,hr_transaction_api.get_varchar2_Value

189: ,hr_transaction_api.get_number_Value
190: (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
191: ,hr_transaction_api.get_varchar2_Value
192: (p_transaction_step_id, 'P_ENGINE_CAPACITY' ) engine_capacity
193: ,hr_transaction_api.get_varchar2_Value
194: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
195: ,hr_transaction_api.get_varchar2_Value
196: (p_transaction_step_id, 'P_FISCAL_RATINGS') fiscal_ratings
197: ,hr_transaction_api.get_varchar2_Value

Line 195: ,hr_transaction_api.get_varchar2_Value

191: ,hr_transaction_api.get_varchar2_Value
192: (p_transaction_step_id, 'P_ENGINE_CAPACITY' ) engine_capacity
193: ,hr_transaction_api.get_varchar2_Value
194: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
195: ,hr_transaction_api.get_varchar2_Value
196: (p_transaction_step_id, 'P_FISCAL_RATINGS') fiscal_ratings
197: ,hr_transaction_api.get_varchar2_Value
198: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
199: ,hr_transaction_api.get_varchar2_Value

Line 197: ,hr_transaction_api.get_varchar2_Value

193: ,hr_transaction_api.get_varchar2_Value
194: (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
195: ,hr_transaction_api.get_varchar2_Value
196: (p_transaction_step_id, 'P_FISCAL_RATINGS') fiscal_ratings
197: ,hr_transaction_api.get_varchar2_Value
198: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
199: ,hr_transaction_api.get_varchar2_Value
200: (p_transaction_step_id, 'P_NO_OF_PASSENGERS') no_of_passengers
201: ,hr_transaction_api.get_varchar2_Value

Line 199: ,hr_transaction_api.get_varchar2_Value

195: ,hr_transaction_api.get_varchar2_Value
196: (p_transaction_step_id, 'P_FISCAL_RATINGS') fiscal_ratings
197: ,hr_transaction_api.get_varchar2_Value
198: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
199: ,hr_transaction_api.get_varchar2_Value
200: (p_transaction_step_id, 'P_NO_OF_PASSENGERS') no_of_passengers
201: ,hr_transaction_api.get_varchar2_Value
202: (p_transaction_step_id, 'P_PURPOSE') purpose
203: ,hr_transaction_api.get_number_Value

Line 201: ,hr_transaction_api.get_varchar2_Value

197: ,hr_transaction_api.get_varchar2_Value
198: (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
199: ,hr_transaction_api.get_varchar2_Value
200: (p_transaction_step_id, 'P_NO_OF_PASSENGERS') no_of_passengers
201: ,hr_transaction_api.get_varchar2_Value
202: (p_transaction_step_id, 'P_PURPOSE') purpose
203: ,hr_transaction_api.get_number_Value
204: (p_transaction_step_id, 'P_ELEMENT_ENTRY_ID') element_entry_id
205: ,hr_transaction_api.get_number_Value

Line 203: ,hr_transaction_api.get_number_Value

199: ,hr_transaction_api.get_varchar2_Value
200: (p_transaction_step_id, 'P_NO_OF_PASSENGERS') no_of_passengers
201: ,hr_transaction_api.get_varchar2_Value
202: (p_transaction_step_id, 'P_PURPOSE') purpose
203: ,hr_transaction_api.get_number_Value
204: (p_transaction_step_id, 'P_ELEMENT_ENTRY_ID') element_entry_id
205: ,hr_transaction_api.get_number_Value
206: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
207: ,hr_transaction_api.get_date_Value

Line 205: ,hr_transaction_api.get_number_Value

201: ,hr_transaction_api.get_varchar2_Value
202: (p_transaction_step_id, 'P_PURPOSE') purpose
203: ,hr_transaction_api.get_number_Value
204: (p_transaction_step_id, 'P_ELEMENT_ENTRY_ID') element_entry_id
205: ,hr_transaction_api.get_number_Value
206: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
207: ,hr_transaction_api.get_date_Value
208: (p_transaction_step_id, 'P_EFFECTIVE_DATE') p_effective_date
209: FROM dual;

Line 207: ,hr_transaction_api.get_date_Value

203: ,hr_transaction_api.get_number_Value
204: (p_transaction_step_id, 'P_ELEMENT_ENTRY_ID') element_entry_id
205: ,hr_transaction_api.get_number_Value
206: (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
207: ,hr_transaction_api.get_date_Value
208: (p_transaction_step_id, 'P_EFFECTIVE_DATE') p_effective_date
209: FROM dual;
210:
211: RETURN csr;

Line 556: hr_transaction_api.create_transaction(

552: l_trans_tbl(l_count).param_value := x_element_entry_id;
553: l_trans_tbl(l_count).param_data_type := 'NUMBER';
554:
555: IF x_transaction_id is NULl THEN
556: hr_transaction_api.create_transaction(
557: p_validate => false
558: ,p_creator_person_id => x_login_person_id
559: ,p_transaction_privilege => 'PRIVATE'
560: ,p_product_code => 'PQP'

Line 581: hr_transaction_api.create_transaction_step

577: ,p_transaction_id => l_transaction_id
578: );
579: x_transaction_id := l_transaction_id;
580: --Create transaction steps
581: hr_transaction_api.create_transaction_step
582: (p_validate => false
583: ,p_creator_person_id => x_login_person_id
584: ,p_transaction_id => l_transaction_id
585: ,p_api_name => l_api_name

Line 602: hr_transaction_api.set_varchar2_value

598:
599: FOR i in 1..l_trans_tbl.count
600: LOOP
601: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
602: hr_transaction_api.set_varchar2_value
603: (p_transaction_step_id => l_transaction_step_id
604: ,p_person_id => x_person_id
605: ,p_name => l_trans_tbl (i).param_name
606: ,p_value => l_trans_tbl (i).param_value

Line 610: hr_transaction_api.set_date_value

606: ,p_value => l_trans_tbl (i).param_value
607: );
608:
609: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
610: hr_transaction_api.set_date_value
611: (
612: p_transaction_step_id => l_transaction_step_id
613: ,p_person_id => x_person_id
614: ,p_name => l_trans_tbl (i).param_name

Line 618: hr_transaction_api.set_number_value

614: ,p_name => l_trans_tbl (i).param_name
615: ,p_value => fnd_date.displaydate_to_date
616: (l_trans_tbl (i).param_value ) );
617: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
618: hr_transaction_api.set_number_value
619: (
620: p_transaction_step_id => l_transaction_step_id
621: ,p_person_id => x_person_id
622: ,p_name =>l_trans_tbl (i).param_name

Line 883: hr_transaction_api.create_transaction(

879: -- If there are no error messages then insert values into transaction table
880:
881: IF x_transaction_id is NULL THEN
882:
883: hr_transaction_api.create_transaction(
884: p_validate =>false
885: ,p_creator_person_id =>x_login_person_id
886: ,p_transaction_privilege =>'PRIVATE'
887: ,p_product_code =>'PQP'

Line 914: hr_transaction_api.create_transaction_step

910: ,aname => 'TRANSACTION_ID'
911: ,avalue => l_transaction_id);
912: x_transaction_id := l_transaction_id;
913: --Create transaction steps
914: hr_transaction_api.create_transaction_step
915: (p_validate =>false
916: ,p_creator_person_id =>x_login_person_id
917: ,p_transaction_id =>l_transaction_id
918: ,p_api_name =>l_api_name

Line 928: hr_transaction_api.update_transaction

924: ,p_object_version_number =>l_ovn
925: );
926: ELSE
927: IF x_transaction_step_id IS NOT NULL THEN
928: hr_transaction_api.update_transaction
929: (p_transaction_id =>x_transaction_id
930: ,p_status =>x_status
931: );
932: DELETE from hr_api_transaction_values

Line 939: hr_transaction_api.create_transaction_step

935: ELSE
936: l_transaction_step_id := x_transaction_step_id;
937: l_transaction_id := x_transaction_id;
938:
939: hr_transaction_api.create_transaction_step
940: (p_validate =>false
941: ,p_creator_person_id =>x_login_person_id
942: ,p_transaction_id =>l_transaction_id
943: ,p_api_name =>l_api_name

Line 958: hr_transaction_api.set_varchar2_value

954: END IF;
955: FOR i in 1..l_trans_tbl.count
956: LOOP
957: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
958: hr_transaction_api.set_varchar2_value
959: (p_transaction_step_id => l_transaction_step_id
960: ,p_person_id => x_person_id
961: ,p_name => l_trans_tbl (i).param_name
962: ,p_value => l_trans_tbl (i).param_value

Line 966: hr_transaction_api.set_date_value

962: ,p_value => l_trans_tbl (i).param_value
963: );
964:
965: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
966: hr_transaction_api.set_date_value
967: (
968: p_transaction_step_id => l_transaction_step_id
969: ,p_person_id => x_person_id
970: ,p_name => l_trans_tbl (i).param_name

Line 977: hr_transaction_api.set_number_value

973: -- ,p_original_value );
974:
975:
976: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
977: hr_transaction_api.set_number_value
978: (
979: p_transaction_step_id => l_transaction_step_id
980: ,p_person_id => x_person_id
981: ,p_name =>l_trans_tbl (i).param_name

Line 1042: l_person_id := hr_transaction_api.get_number_value (

1038: l_mileage_claim_element NUMBER;
1039: l_confirmation_number NUMBER;
1040: l_element_entry_date DATE;
1041: BEGIN
1042: l_person_id := hr_transaction_api.get_number_value (
1043: p_transaction_step_id => p_transaction_step_id,
1044: p_name =>'P_PERSON_ID' );
1045:
1046: l_effective_date := hr_transaction_api.get_date_value (

Line 1046: l_effective_date := hr_transaction_api.get_date_value (

1042: l_person_id := hr_transaction_api.get_number_value (
1043: p_transaction_step_id => p_transaction_step_id,
1044: p_name =>'P_PERSON_ID' );
1045:
1046: l_effective_date := hr_transaction_api.get_date_value (
1047: p_transaction_step_id => p_transaction_step_id,
1048: p_name =>'P_EFFECTIVE_DATE' );
1049: l_assignment_id :=hr_transaction_api.get_number_value (
1050: p_transaction_step_id => p_transaction_step_id,

Line 1049: l_assignment_id :=hr_transaction_api.get_number_value (

1045:
1046: l_effective_date := hr_transaction_api.get_date_value (
1047: p_transaction_step_id => p_transaction_step_id,
1048: p_name =>'P_EFFECTIVE_DATE' );
1049: l_assignment_id :=hr_transaction_api.get_number_value (
1050: p_transaction_step_id => p_transaction_step_id,
1051: p_name =>'P_ASSIGNMENT_ID' );
1052:
1053: l_business_group_id :=hr_transaction_api.get_number_value (

Line 1053: l_business_group_id :=hr_transaction_api.get_number_value (

1049: l_assignment_id :=hr_transaction_api.get_number_value (
1050: p_transaction_step_id => p_transaction_step_id,
1051: p_name =>'P_ASSIGNMENT_ID' );
1052:
1053: l_business_group_id :=hr_transaction_api.get_number_value (
1054: p_transaction_step_id => p_transaction_step_id,
1055: p_name =>'P_BUSINESS_GROUP_ID' );
1056: l_element_entry_id :=hr_transaction_api.get_number_value (
1057: p_transaction_step_id => p_transaction_step_id,

Line 1056: l_element_entry_id :=hr_transaction_api.get_number_value (

1052:
1053: l_business_group_id :=hr_transaction_api.get_number_value (
1054: p_transaction_step_id => p_transaction_step_id,
1055: p_name =>'P_BUSINESS_GROUP_ID' );
1056: l_element_entry_id :=hr_transaction_api.get_number_value (
1057: p_transaction_step_id => p_transaction_step_id,
1058: p_name =>'P_ELEMENT_ENTRY_ID' );
1059:
1060:

Line 1125: l_person_id := hr_transaction_api.get_number_value (

1121: --
1122:
1123:
1124:
1125: l_person_id := hr_transaction_api.get_number_value (
1126: p_transaction_step_id => p_transaction_step_id,
1127: p_name =>'P_PERSON_ID' );
1128:
1129: l_assignment_id := hr_transaction_api.get_number_value (

Line 1129: l_assignment_id := hr_transaction_api.get_number_value (

1125: l_person_id := hr_transaction_api.get_number_value (
1126: p_transaction_step_id => p_transaction_step_id,
1127: p_name =>'P_PERSON_ID' );
1128:
1129: l_assignment_id := hr_transaction_api.get_number_value (
1130: p_transaction_step_id => p_transaction_step_id,
1131: p_name =>'P_ASSIGNMENT_ID' );
1132:
1133:

Line 1134: l_effective_date := hr_transaction_api.get_date_value (

1130: p_transaction_step_id => p_transaction_step_id,
1131: p_name =>'P_ASSIGNMENT_ID' );
1132:
1133:
1134: l_effective_date := hr_transaction_api.get_date_value (
1135: p_transaction_step_id => p_transaction_step_id,
1136: p_name =>'P_EFFECTIVE_DATE' );
1137:
1138: l_registration_number := hr_transaction_api.get_varchar2_value (

Line 1138: l_registration_number := hr_transaction_api.get_varchar2_value (

1134: l_effective_date := hr_transaction_api.get_date_value (
1135: p_transaction_step_id => p_transaction_step_id,
1136: p_name =>'P_EFFECTIVE_DATE' );
1137:
1138: l_registration_number := hr_transaction_api.get_varchar2_value (
1139: p_transaction_step_id => p_transaction_step_id,
1140: p_name =>'P_REGISTRATION_NUMBER' );
1141:
1142: l_vehicle_type := hr_transaction_api.get_varchar2_value (

Line 1142: l_vehicle_type := hr_transaction_api.get_varchar2_value (

1138: l_registration_number := hr_transaction_api.get_varchar2_value (
1139: p_transaction_step_id => p_transaction_step_id,
1140: p_name =>'P_REGISTRATION_NUMBER' );
1141:
1142: l_vehicle_type := hr_transaction_api.get_varchar2_value (
1143: p_transaction_step_id => p_transaction_step_id,
1144: p_name =>'P_VEHICLE_TYPE' );
1145:
1146: l_business_group_id := hr_transaction_api.get_number_value (

Line 1146: l_business_group_id := hr_transaction_api.get_number_value (

1142: l_vehicle_type := hr_transaction_api.get_varchar2_value (
1143: p_transaction_step_id => p_transaction_step_id,
1144: p_name =>'P_VEHICLE_TYPE' );
1145:
1146: l_business_group_id := hr_transaction_api.get_number_value (
1147: p_transaction_step_id => p_transaction_step_id,
1148: p_name =>'P_BUSINESS_GROUP_ID');
1149:
1150:

Line 1151: l_engine_capacity := hr_transaction_api.get_varchar2_value (

1147: p_transaction_step_id => p_transaction_step_id,
1148: p_name =>'P_BUSINESS_GROUP_ID');
1149:
1150:
1151: l_engine_capacity := hr_transaction_api.get_varchar2_value (
1152: p_transaction_step_id => p_transaction_step_id,
1153: p_name =>'P_ENGINE_CAPACITY');
1154:
1155:

Line 1157: l_start_date := hr_transaction_api.get_date_value (

1153: p_name =>'P_ENGINE_CAPACITY');
1154:
1155:
1156:
1157: l_start_date := hr_transaction_api.get_date_value (
1158: p_transaction_step_id => p_transaction_step_id,
1159: p_name =>'P_START_DATE');
1160:
1161:

Line 1162: l_end_date := hr_transaction_api.get_date_value (

1158: p_transaction_step_id => p_transaction_step_id,
1159: p_name =>'P_START_DATE');
1160:
1161:
1162: l_end_date := hr_transaction_api.get_date_value (
1163: p_transaction_step_id => p_transaction_step_id,
1164: p_name =>'P_END_DATE');
1165:
1166: l_claimed_mileage := hr_transaction_api.get_varchar2_value (

Line 1166: l_claimed_mileage := hr_transaction_api.get_varchar2_value (

1162: l_end_date := hr_transaction_api.get_date_value (
1163: p_transaction_step_id => p_transaction_step_id,
1164: p_name =>'P_END_DATE');
1165:
1166: l_claimed_mileage := hr_transaction_api.get_varchar2_value (
1167: p_transaction_step_id => p_transaction_step_id,
1168: p_name =>'P_CLAIMED_MILEAGE');
1169:
1170: l_actual_mileage := hr_transaction_api.get_varchar2_value (

Line 1170: l_actual_mileage := hr_transaction_api.get_varchar2_value (

1166: l_claimed_mileage := hr_transaction_api.get_varchar2_value (
1167: p_transaction_step_id => p_transaction_step_id,
1168: p_name =>'P_CLAIMED_MILEAGE');
1169:
1170: l_actual_mileage := hr_transaction_api.get_varchar2_value (
1171: p_transaction_step_id => p_transaction_step_id,
1172: p_name =>'P_ACTUAL_MILEAGE');
1173:
1174:

Line 1175: l_claimed_mileage_o := hr_transaction_api.get_varchar2_value (

1171: p_transaction_step_id => p_transaction_step_id,
1172: p_name =>'P_ACTUAL_MILEAGE');
1173:
1174:
1175: l_claimed_mileage_o := hr_transaction_api.get_varchar2_value (
1176: p_transaction_step_id => p_transaction_step_id,
1177: p_name =>'P_CLAIMED_MILEAGE_O');
1178:
1179: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (

Line 1179: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (

1175: l_claimed_mileage_o := hr_transaction_api.get_varchar2_value (
1176: p_transaction_step_id => p_transaction_step_id,
1177: p_name =>'P_CLAIMED_MILEAGE_O');
1178:
1179: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (
1180: p_transaction_step_id => p_transaction_step_id,
1181: p_name =>'P_ACTUAL_MILEAGE_O');
1182:
1183: l_fuel_type := hr_transaction_api.get_varchar2_value (

Line 1183: l_fuel_type := hr_transaction_api.get_varchar2_value (

1179: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (
1180: p_transaction_step_id => p_transaction_step_id,
1181: p_name =>'P_ACTUAL_MILEAGE_O');
1182:
1183: l_fuel_type := hr_transaction_api.get_varchar2_value (
1184: p_transaction_step_id => p_transaction_step_id,
1185: p_name =>'P_FUEL_TYPE');
1186:
1187: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (

Line 1187: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (

1183: l_fuel_type := hr_transaction_api.get_varchar2_value (
1184: p_transaction_step_id => p_transaction_step_id,
1185: p_name =>'P_FUEL_TYPE');
1186:
1187: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (
1188: p_transaction_step_id => p_transaction_step_id,
1189: p_name =>'P_FISCAL_RATINGS' );
1190:
1191: l_ownership := hr_transaction_api.get_varchar2_value (

Line 1191: l_ownership := hr_transaction_api.get_varchar2_value (

1187: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (
1188: p_transaction_step_id => p_transaction_step_id,
1189: p_name =>'P_FISCAL_RATINGS' );
1190:
1191: l_ownership := hr_transaction_api.get_varchar2_value (
1192: p_transaction_step_id => p_transaction_step_id,
1193: p_name =>'P_OWNERSHIP');
1194:
1195: l_usage_type := hr_transaction_api.get_varchar2_value (

Line 1195: l_usage_type := hr_transaction_api.get_varchar2_value (

1191: l_ownership := hr_transaction_api.get_varchar2_value (
1192: p_transaction_step_id => p_transaction_step_id,
1193: p_name =>'P_OWNERSHIP');
1194:
1195: l_usage_type := hr_transaction_api.get_varchar2_value (
1196: p_transaction_step_id => p_transaction_step_id,
1197: p_name =>'P_USAGE_TYPE');
1198:
1199:

Line 1200: l_no_of_passengers := hr_transaction_api.get_varchar2_value (

1196: p_transaction_step_id => p_transaction_step_id,
1197: p_name =>'P_USAGE_TYPE');
1198:
1199:
1200: l_no_of_passengers := hr_transaction_api.get_varchar2_value (
1201: p_transaction_step_id => p_transaction_step_id,
1202: p_name =>'P_NO_OF_PASSENGERS');
1203:
1204:

Line 1205: l_purpose := hr_transaction_api.get_varchar2_value (

1201: p_transaction_step_id => p_transaction_step_id,
1202: p_name =>'P_NO_OF_PASSENGERS');
1203:
1204:
1205: l_purpose := hr_transaction_api.get_varchar2_value (
1206: p_transaction_step_id => p_transaction_step_id,
1207: p_name =>'P_PURPOSE');
1208:
1209:

Line 1210: l_element_entry_id := hr_transaction_api.get_number_value (

1206: p_transaction_step_id => p_transaction_step_id,
1207: p_name =>'P_PURPOSE');
1208:
1209:
1210: l_element_entry_id := hr_transaction_api.get_number_value (
1211: p_transaction_step_id => p_transaction_step_id,
1212: p_name =>'P_ELEMENT_ENTRY_ID');
1213: create_vehicle_mileage_claims
1214: (