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 897: hr_transaction_api.create_transaction(

893: -- If there are no error messages then insert values into transaction table
894:
895: IF x_transaction_id is NULL THEN
896:
897: hr_transaction_api.create_transaction(
898: p_validate =>false
899: ,p_creator_person_id =>x_login_person_id
900: ,p_transaction_privilege =>'PRIVATE'
901: ,p_product_code =>'PQP'

Line 928: hr_transaction_api.create_transaction_step

924: ,aname => 'TRANSACTION_ID'
925: ,avalue => l_transaction_id);
926: x_transaction_id := l_transaction_id;
927: --Create transaction steps
928: hr_transaction_api.create_transaction_step
929: (p_validate =>false
930: ,p_creator_person_id =>x_login_person_id
931: ,p_transaction_id =>l_transaction_id
932: ,p_api_name =>l_api_name

Line 942: hr_transaction_api.update_transaction

938: ,p_object_version_number =>l_ovn
939: );
940: ELSE
941: IF x_transaction_step_id IS NOT NULL THEN
942: hr_transaction_api.update_transaction
943: (p_transaction_id =>x_transaction_id
944: ,p_status =>x_status
945: );
946: DELETE from hr_api_transaction_values

Line 953: hr_transaction_api.create_transaction_step

949: ELSE
950: l_transaction_step_id := x_transaction_step_id;
951: l_transaction_id := x_transaction_id;
952:
953: hr_transaction_api.create_transaction_step
954: (p_validate =>false
955: ,p_creator_person_id =>x_login_person_id
956: ,p_transaction_id =>l_transaction_id
957: ,p_api_name =>l_api_name

Line 972: hr_transaction_api.set_varchar2_value

968: END IF;
969: FOR i in 1..l_trans_tbl.count
970: LOOP
971: IF l_trans_tbl(i).param_data_type ='VARCHAR2' THEN
972: hr_transaction_api.set_varchar2_value
973: (p_transaction_step_id => l_transaction_step_id
974: ,p_person_id => x_person_id
975: ,p_name => l_trans_tbl (i).param_name
976: ,p_value => l_trans_tbl (i).param_value

Line 980: hr_transaction_api.set_date_value

976: ,p_value => l_trans_tbl (i).param_value
977: );
978:
979: ELSIF l_trans_tbl(i).param_data_type ='DATE' THEN
980: hr_transaction_api.set_date_value
981: (
982: p_transaction_step_id => l_transaction_step_id
983: ,p_person_id => x_person_id
984: ,p_name => l_trans_tbl (i).param_name

Line 991: hr_transaction_api.set_number_value

987: -- ,p_original_value );
988:
989:
990: ELSIF l_trans_tbl(i).param_data_type ='NUMBER' THEN
991: hr_transaction_api.set_number_value
992: (
993: p_transaction_step_id => l_transaction_step_id
994: ,p_person_id => x_person_id
995: ,p_name =>l_trans_tbl (i).param_name

Line 1056: l_person_id := hr_transaction_api.get_number_value (

1052: l_mileage_claim_element NUMBER;
1053: l_confirmation_number NUMBER;
1054: l_element_entry_date DATE;
1055: BEGIN
1056: l_person_id := hr_transaction_api.get_number_value (
1057: p_transaction_step_id => p_transaction_step_id,
1058: p_name =>'P_PERSON_ID' );
1059:
1060: l_effective_date := hr_transaction_api.get_date_value (

Line 1060: l_effective_date := hr_transaction_api.get_date_value (

1056: l_person_id := hr_transaction_api.get_number_value (
1057: p_transaction_step_id => p_transaction_step_id,
1058: p_name =>'P_PERSON_ID' );
1059:
1060: l_effective_date := hr_transaction_api.get_date_value (
1061: p_transaction_step_id => p_transaction_step_id,
1062: p_name =>'P_EFFECTIVE_DATE' );
1063: l_assignment_id :=hr_transaction_api.get_number_value (
1064: p_transaction_step_id => p_transaction_step_id,

Line 1063: l_assignment_id :=hr_transaction_api.get_number_value (

1059:
1060: l_effective_date := hr_transaction_api.get_date_value (
1061: p_transaction_step_id => p_transaction_step_id,
1062: p_name =>'P_EFFECTIVE_DATE' );
1063: l_assignment_id :=hr_transaction_api.get_number_value (
1064: p_transaction_step_id => p_transaction_step_id,
1065: p_name =>'P_ASSIGNMENT_ID' );
1066:
1067: l_business_group_id :=hr_transaction_api.get_number_value (

Line 1067: l_business_group_id :=hr_transaction_api.get_number_value (

1063: l_assignment_id :=hr_transaction_api.get_number_value (
1064: p_transaction_step_id => p_transaction_step_id,
1065: p_name =>'P_ASSIGNMENT_ID' );
1066:
1067: l_business_group_id :=hr_transaction_api.get_number_value (
1068: p_transaction_step_id => p_transaction_step_id,
1069: p_name =>'P_BUSINESS_GROUP_ID' );
1070: l_element_entry_id :=hr_transaction_api.get_number_value (
1071: p_transaction_step_id => p_transaction_step_id,

Line 1070: l_element_entry_id :=hr_transaction_api.get_number_value (

1066:
1067: l_business_group_id :=hr_transaction_api.get_number_value (
1068: p_transaction_step_id => p_transaction_step_id,
1069: p_name =>'P_BUSINESS_GROUP_ID' );
1070: l_element_entry_id :=hr_transaction_api.get_number_value (
1071: p_transaction_step_id => p_transaction_step_id,
1072: p_name =>'P_ELEMENT_ENTRY_ID' );
1073:
1074:

Line 1139: l_person_id := hr_transaction_api.get_number_value (

1135: --
1136:
1137:
1138:
1139: l_person_id := hr_transaction_api.get_number_value (
1140: p_transaction_step_id => p_transaction_step_id,
1141: p_name =>'P_PERSON_ID' );
1142:
1143: l_assignment_id := hr_transaction_api.get_number_value (

Line 1143: l_assignment_id := hr_transaction_api.get_number_value (

1139: l_person_id := hr_transaction_api.get_number_value (
1140: p_transaction_step_id => p_transaction_step_id,
1141: p_name =>'P_PERSON_ID' );
1142:
1143: l_assignment_id := hr_transaction_api.get_number_value (
1144: p_transaction_step_id => p_transaction_step_id,
1145: p_name =>'P_ASSIGNMENT_ID' );
1146:
1147:

Line 1148: l_effective_date := hr_transaction_api.get_date_value (

1144: p_transaction_step_id => p_transaction_step_id,
1145: p_name =>'P_ASSIGNMENT_ID' );
1146:
1147:
1148: l_effective_date := hr_transaction_api.get_date_value (
1149: p_transaction_step_id => p_transaction_step_id,
1150: p_name =>'P_EFFECTIVE_DATE' );
1151:
1152: l_registration_number := hr_transaction_api.get_varchar2_value (

Line 1152: l_registration_number := hr_transaction_api.get_varchar2_value (

1148: l_effective_date := hr_transaction_api.get_date_value (
1149: p_transaction_step_id => p_transaction_step_id,
1150: p_name =>'P_EFFECTIVE_DATE' );
1151:
1152: l_registration_number := hr_transaction_api.get_varchar2_value (
1153: p_transaction_step_id => p_transaction_step_id,
1154: p_name =>'P_REGISTRATION_NUMBER' );
1155:
1156: l_vehicle_type := hr_transaction_api.get_varchar2_value (

Line 1156: l_vehicle_type := hr_transaction_api.get_varchar2_value (

1152: l_registration_number := hr_transaction_api.get_varchar2_value (
1153: p_transaction_step_id => p_transaction_step_id,
1154: p_name =>'P_REGISTRATION_NUMBER' );
1155:
1156: l_vehicle_type := hr_transaction_api.get_varchar2_value (
1157: p_transaction_step_id => p_transaction_step_id,
1158: p_name =>'P_VEHICLE_TYPE' );
1159:
1160: l_business_group_id := hr_transaction_api.get_number_value (

Line 1160: l_business_group_id := hr_transaction_api.get_number_value (

1156: l_vehicle_type := hr_transaction_api.get_varchar2_value (
1157: p_transaction_step_id => p_transaction_step_id,
1158: p_name =>'P_VEHICLE_TYPE' );
1159:
1160: l_business_group_id := hr_transaction_api.get_number_value (
1161: p_transaction_step_id => p_transaction_step_id,
1162: p_name =>'P_BUSINESS_GROUP_ID');
1163:
1164:

Line 1165: l_engine_capacity := hr_transaction_api.get_varchar2_value (

1161: p_transaction_step_id => p_transaction_step_id,
1162: p_name =>'P_BUSINESS_GROUP_ID');
1163:
1164:
1165: l_engine_capacity := hr_transaction_api.get_varchar2_value (
1166: p_transaction_step_id => p_transaction_step_id,
1167: p_name =>'P_ENGINE_CAPACITY');
1168:
1169:

Line 1171: l_start_date := hr_transaction_api.get_date_value (

1167: p_name =>'P_ENGINE_CAPACITY');
1168:
1169:
1170:
1171: l_start_date := hr_transaction_api.get_date_value (
1172: p_transaction_step_id => p_transaction_step_id,
1173: p_name =>'P_START_DATE');
1174:
1175:

Line 1176: l_end_date := hr_transaction_api.get_date_value (

1172: p_transaction_step_id => p_transaction_step_id,
1173: p_name =>'P_START_DATE');
1174:
1175:
1176: l_end_date := hr_transaction_api.get_date_value (
1177: p_transaction_step_id => p_transaction_step_id,
1178: p_name =>'P_END_DATE');
1179:
1180: l_claimed_mileage := hr_transaction_api.get_varchar2_value (

Line 1180: l_claimed_mileage := hr_transaction_api.get_varchar2_value (

1176: l_end_date := hr_transaction_api.get_date_value (
1177: p_transaction_step_id => p_transaction_step_id,
1178: p_name =>'P_END_DATE');
1179:
1180: l_claimed_mileage := hr_transaction_api.get_varchar2_value (
1181: p_transaction_step_id => p_transaction_step_id,
1182: p_name =>'P_CLAIMED_MILEAGE');
1183:
1184: l_actual_mileage := hr_transaction_api.get_varchar2_value (

Line 1184: l_actual_mileage := hr_transaction_api.get_varchar2_value (

1180: l_claimed_mileage := hr_transaction_api.get_varchar2_value (
1181: p_transaction_step_id => p_transaction_step_id,
1182: p_name =>'P_CLAIMED_MILEAGE');
1183:
1184: l_actual_mileage := hr_transaction_api.get_varchar2_value (
1185: p_transaction_step_id => p_transaction_step_id,
1186: p_name =>'P_ACTUAL_MILEAGE');
1187:
1188:

Line 1189: l_claimed_mileage_o := hr_transaction_api.get_varchar2_value (

1185: p_transaction_step_id => p_transaction_step_id,
1186: p_name =>'P_ACTUAL_MILEAGE');
1187:
1188:
1189: l_claimed_mileage_o := hr_transaction_api.get_varchar2_value (
1190: p_transaction_step_id => p_transaction_step_id,
1191: p_name =>'P_CLAIMED_MILEAGE_O');
1192:
1193: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (

Line 1193: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (

1189: l_claimed_mileage_o := hr_transaction_api.get_varchar2_value (
1190: p_transaction_step_id => p_transaction_step_id,
1191: p_name =>'P_CLAIMED_MILEAGE_O');
1192:
1193: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (
1194: p_transaction_step_id => p_transaction_step_id,
1195: p_name =>'P_ACTUAL_MILEAGE_O');
1196:
1197: l_fuel_type := hr_transaction_api.get_varchar2_value (

Line 1197: l_fuel_type := hr_transaction_api.get_varchar2_value (

1193: l_actual_mileage_o := hr_transaction_api.get_varchar2_value (
1194: p_transaction_step_id => p_transaction_step_id,
1195: p_name =>'P_ACTUAL_MILEAGE_O');
1196:
1197: l_fuel_type := hr_transaction_api.get_varchar2_value (
1198: p_transaction_step_id => p_transaction_step_id,
1199: p_name =>'P_FUEL_TYPE');
1200:
1201: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (

Line 1201: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (

1197: l_fuel_type := hr_transaction_api.get_varchar2_value (
1198: p_transaction_step_id => p_transaction_step_id,
1199: p_name =>'P_FUEL_TYPE');
1200:
1201: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (
1202: p_transaction_step_id => p_transaction_step_id,
1203: p_name =>'P_FISCAL_RATINGS' );
1204:
1205: l_ownership := hr_transaction_api.get_varchar2_value (

Line 1205: l_ownership := hr_transaction_api.get_varchar2_value (

1201: l_fiscal_ratings := hr_transaction_api.get_varchar2_value (
1202: p_transaction_step_id => p_transaction_step_id,
1203: p_name =>'P_FISCAL_RATINGS' );
1204:
1205: l_ownership := hr_transaction_api.get_varchar2_value (
1206: p_transaction_step_id => p_transaction_step_id,
1207: p_name =>'P_OWNERSHIP');
1208:
1209: l_usage_type := hr_transaction_api.get_varchar2_value (

Line 1209: l_usage_type := hr_transaction_api.get_varchar2_value (

1205: l_ownership := hr_transaction_api.get_varchar2_value (
1206: p_transaction_step_id => p_transaction_step_id,
1207: p_name =>'P_OWNERSHIP');
1208:
1209: l_usage_type := hr_transaction_api.get_varchar2_value (
1210: p_transaction_step_id => p_transaction_step_id,
1211: p_name =>'P_USAGE_TYPE');
1212:
1213:

Line 1214: l_no_of_passengers := hr_transaction_api.get_varchar2_value (

1210: p_transaction_step_id => p_transaction_step_id,
1211: p_name =>'P_USAGE_TYPE');
1212:
1213:
1214: l_no_of_passengers := hr_transaction_api.get_varchar2_value (
1215: p_transaction_step_id => p_transaction_step_id,
1216: p_name =>'P_NO_OF_PASSENGERS');
1217:
1218:

Line 1219: l_purpose := hr_transaction_api.get_varchar2_value (

1215: p_transaction_step_id => p_transaction_step_id,
1216: p_name =>'P_NO_OF_PASSENGERS');
1217:
1218:
1219: l_purpose := hr_transaction_api.get_varchar2_value (
1220: p_transaction_step_id => p_transaction_step_id,
1221: p_name =>'P_PURPOSE');
1222:
1223:

Line 1224: l_element_entry_id := hr_transaction_api.get_number_value (

1220: p_transaction_step_id => p_transaction_step_id,
1221: p_name =>'P_PURPOSE');
1222:
1223:
1224: l_element_entry_id := hr_transaction_api.get_number_value (
1225: p_transaction_step_id => p_transaction_step_id,
1226: p_name =>'P_ELEMENT_ENTRY_ID');
1227: create_vehicle_mileage_claims
1228: (