DBA Data[Home] [Help]

APPS.PQP_GENERIC_EIT_SS dependencies on HR_TRANSACTION_API

Line 907: hr_transaction_api.create_transaction(

903: --
904: END LOOP;
905:
906: IF l_transaction_id is NULL THEN
907: hr_transaction_api.create_transaction(
908: p_validate =>false
909: ,p_creator_person_id =>p_login_person_id
910: ,p_transaction_privilege =>'PRIVATE'
911: ,p_product_code =>'PQP'

Line 938: hr_transaction_api.create_transaction_step

934: ,aname => 'TRANSACTION_ID'
935: ,avalue => l_transaction_id);
936: -- x_transaction_id := l_transaction_id;
937: --Create transaction steps
938: hr_transaction_api.create_transaction_step
939: (p_validate =>false
940: ,p_creator_person_id =>p_login_person_id
941: ,p_transaction_id =>l_transaction_id
942: ,p_api_name =>l_api_name

Line 953: hr_transaction_api.update_transaction

949: );
950: ELSE
951: IF p_transaction_step_id IS NOT NULL AND
952: p_transaction_step_id <>0 THEN
953: hr_transaction_api.update_transaction
954: (p_transaction_id =>l_transaction_id
955: ,p_status =>p_status
956: );
957: DELETE from hr_api_transaction_values

Line 966: hr_transaction_api.create_transaction_step

962:
963: --l_transaction_step_id := p_transaction_step_id;
964: l_transaction_step_id:=NULL;
965:
966: hr_transaction_api.create_transaction_step
967: (p_validate =>false
968: ,p_creator_person_id =>p_login_person_id
969: ,p_transaction_id =>l_transaction_id
970: ,p_api_name =>l_api_name

Line 985: hr_transaction_api.set_varchar2_value

981: END IF;
982: FOR i in 1..l_transaction_table.count
983: LOOP
984: IF l_transaction_table(i).param_data_type ='VARCHAR2' THEN
985: hr_transaction_api.set_varchar2_value
986: (p_transaction_step_id => l_transaction_step_id
987: ,p_person_id => p_person_id
988: ,p_name => l_transaction_table(i).param_name
989: ,p_value => l_transaction_table(i).param_value

Line 993: hr_transaction_api.set_date_value

989: ,p_value => l_transaction_table(i).param_value
990: );
991:
992: ELSIF l_transaction_table(i).param_data_type ='DATE' THEN
993: hr_transaction_api.set_date_value
994: (
995: p_transaction_step_id => l_transaction_step_id
996: ,p_person_id => p_person_id
997: ,p_name => l_transaction_table (i).param_name

Line 1004: hr_transaction_api.set_number_value

1000: -- ,p_original_value );
1001:
1002:
1003: ELSIF l_transaction_table(i).param_data_type ='NUMBER' THEN
1004: hr_transaction_api.set_number_value
1005: (
1006: p_transaction_step_id => l_transaction_step_id
1007: ,p_person_id => p_person_id
1008: ,p_name =>l_transaction_table (i).param_name

Line 1076: hr_transaction_api.get_transaction_step_info

1072: -- clicks the Back button on the Review page to go back to the Update page
1073: -- to make further changes or to correct errors.
1074: -----------------------------------------------------------------------------
1075:
1076: hr_transaction_api.get_transaction_step_info
1077: (p_item_type => p_item_type
1078: ,p_item_key => p_item_key
1079: ,p_activity_id => p_activity_id
1080: ,p_transaction_step_id => l_trans_step_id

Line 1158: p_effective_date := hr_transaction_api.get_date_value

1154:
1155: BEGIN
1156:
1157:
1158: p_effective_date := hr_transaction_api.get_date_value
1159: (p_transaction_step_id => p_transaction_step_id
1160: ,p_name => 'P_EFFECTIVE_DATE');
1161:
1162: p_person_id := hr_transaction_api.get_number_value

Line 1162: p_person_id := hr_transaction_api.get_number_value

1158: p_effective_date := hr_transaction_api.get_date_value
1159: (p_transaction_step_id => p_transaction_step_id
1160: ,p_name => 'P_EFFECTIVE_DATE');
1161:
1162: p_person_id := hr_transaction_api.get_number_value
1163: (p_transaction_step_id => p_transaction_step_id
1164: ,p_name => 'P_PERSON_ID');
1165:
1166: p_login_person_id := hr_transaction_api.get_number_value

Line 1166: p_login_person_id := hr_transaction_api.get_number_value

1162: p_person_id := hr_transaction_api.get_number_value
1163: (p_transaction_step_id => p_transaction_step_id
1164: ,p_name => 'P_PERSON_ID');
1165:
1166: p_login_person_id := hr_transaction_api.get_number_value
1167: (p_transaction_step_id => p_transaction_step_id
1168: ,p_name => 'P_LOGIN_PERSON_ID');
1169:
1170: p_assignment_id := hr_transaction_api.get_number_value

Line 1170: p_assignment_id := hr_transaction_api.get_number_value

1166: p_login_person_id := hr_transaction_api.get_number_value
1167: (p_transaction_step_id => p_transaction_step_id
1168: ,p_name => 'P_LOGIN_PERSON_ID');
1169:
1170: p_assignment_id := hr_transaction_api.get_number_value
1171: (p_transaction_step_id => p_transaction_step_id
1172: ,p_name => 'P_ASSIGNMENT_ID');
1173:
1174: p_business_group_id := hr_transaction_api.get_number_value

Line 1174: p_business_group_id := hr_transaction_api.get_number_value

1170: p_assignment_id := hr_transaction_api.get_number_value
1171: (p_transaction_step_id => p_transaction_step_id
1172: ,p_name => 'P_ASSIGNMENT_ID');
1173:
1174: p_business_group_id := hr_transaction_api.get_number_value
1175: (p_transaction_step_id => p_transaction_step_id
1176: ,p_name => 'P_BUSINESS_GROUP_ID');
1177:
1178: p_eit_type := hr_transaction_api.get_varchar2_value

Line 1178: p_eit_type := hr_transaction_api.get_varchar2_value

1174: p_business_group_id := hr_transaction_api.get_number_value
1175: (p_transaction_step_id => p_transaction_step_id
1176: ,p_name => 'P_BUSINESS_GROUP_ID');
1177:
1178: p_eit_type := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id
1180: ,p_name => 'P_EIT_TYPE');
1181:
1182: p_eit_type_id := hr_transaction_api.get_number_value

Line 1182: p_eit_type_id := hr_transaction_api.get_number_value

1178: p_eit_type := hr_transaction_api.get_varchar2_value
1179: (p_transaction_step_id => p_transaction_step_id
1180: ,p_name => 'P_EIT_TYPE');
1181:
1182: p_eit_type_id := hr_transaction_api.get_number_value
1183: (p_transaction_step_id => p_transaction_step_id
1184: ,p_name => 'P_EIT_TYPE_ID');
1185:
1186: p_key_id := hr_transaction_api.get_varchar2_value

Line 1186: p_key_id := hr_transaction_api.get_varchar2_value

1182: p_eit_type_id := hr_transaction_api.get_number_value
1183: (p_transaction_step_id => p_transaction_step_id
1184: ,p_name => 'P_EIT_TYPE_ID');
1185:
1186: p_key_id := hr_transaction_api.get_varchar2_value
1187: (p_transaction_step_id => p_transaction_step_id
1188: ,p_name => 'P_KEY_ID');
1189:
1190: p_eit_number := hr_transaction_api.get_number_value

Line 1190: p_eit_number := hr_transaction_api.get_number_value

1186: p_key_id := hr_transaction_api.get_varchar2_value
1187: (p_transaction_step_id => p_transaction_step_id
1188: ,p_name => 'P_KEY_ID');
1189:
1190: p_eit_number := hr_transaction_api.get_number_value
1191: (p_transaction_step_id => p_transaction_step_id
1192: ,p_name => 'P_EIT_NUMBER');
1193:
1194: p_active_view := hr_transaction_api.get_varchar2_value

Line 1194: p_active_view := hr_transaction_api.get_varchar2_value

1190: p_eit_number := hr_transaction_api.get_number_value
1191: (p_transaction_step_id => p_transaction_step_id
1192: ,p_name => 'P_EIT_NUMBER');
1193:
1194: p_active_view := hr_transaction_api.get_varchar2_value
1195: (p_transaction_step_id => p_transaction_step_id
1196: ,p_name => 'P_ACTIVE_VIEW');
1197:
1198: p_active_row_id := hr_transaction_api.get_number_value

Line 1198: p_active_row_id := hr_transaction_api.get_number_value

1194: p_active_view := hr_transaction_api.get_varchar2_value
1195: (p_transaction_step_id => p_transaction_step_id
1196: ,p_name => 'P_ACTIVE_VIEW');
1197:
1198: p_active_row_id := hr_transaction_api.get_number_value
1199: (p_transaction_step_id => p_transaction_step_id
1200: ,p_name => 'P_ACTIVE_ROW_ID');
1201:
1202:

Line 1216: hr_transaction_api.get_varchar2_value

1212: --
1213: l_eit_table(i) := HR_EIT_STRUCTURE_TYPE
1214: (
1215: -- action
1216: hr_transaction_api.get_varchar2_value
1217: (p_transaction_step_id => p_transaction_step_id
1218: ,p_name => 'P_ACTION_'||i)
1219:
1220: -- extra info id

Line 1221: ,hr_transaction_api.get_number_value

1217: (p_transaction_step_id => p_transaction_step_id
1218: ,p_name => 'P_ACTION_'||i)
1219:
1220: -- extra info id
1221: ,hr_transaction_api.get_number_value
1222: (p_transaction_step_id => p_transaction_step_id
1223: ,p_name => 'P_EXTRA_INFO_ID_'||i)
1224:
1225: --object_version_number

Line 1226: ,hr_transaction_api.get_number_value

1222: (p_transaction_step_id => p_transaction_step_id
1223: ,p_name => 'P_EXTRA_INFO_ID_'||i)
1224:
1225: --object_version_number
1226: ,hr_transaction_api.get_number_value
1227: (p_transaction_step_id => p_transaction_step_id
1228: ,p_name => 'P_OBJECT_VERSION_NUMBER_'||i)
1229:
1230: --information_type

Line 1231: ,hr_transaction_api.get_varchar2_value

1227: (p_transaction_step_id => p_transaction_step_id
1228: ,p_name => 'P_OBJECT_VERSION_NUMBER_'||i)
1229:
1230: --information_type
1231: ,hr_transaction_api.get_varchar2_value
1232: (p_transaction_step_id => p_transaction_step_id
1233: ,p_name => 'P_INFORMATION_TYPE_'||i)
1234:
1235: --attribute_category

Line 1236: ,hr_transaction_api.get_varchar2_value

1232: (p_transaction_step_id => p_transaction_step_id
1233: ,p_name => 'P_INFORMATION_TYPE_'||i)
1234:
1235: --attribute_category
1236: ,hr_transaction_api.get_varchar2_value
1237: (p_transaction_step_id => p_transaction_step_id
1238: ,p_name => 'P_ATTRIBUTE_CATEGORY_'||i)
1239:
1240: --attribute1

Line 1241: ,hr_transaction_api.get_varchar2_value

1237: (p_transaction_step_id => p_transaction_step_id
1238: ,p_name => 'P_ATTRIBUTE_CATEGORY_'||i)
1239:
1240: --attribute1
1241: ,hr_transaction_api.get_varchar2_value
1242: (p_transaction_step_id => p_transaction_step_id
1243: ,p_name => 'P_ATTRIBUTE1_'||i)
1244:
1245: --attribute2

Line 1246: ,hr_transaction_api.get_varchar2_value

1242: (p_transaction_step_id => p_transaction_step_id
1243: ,p_name => 'P_ATTRIBUTE1_'||i)
1244:
1245: --attribute2
1246: ,hr_transaction_api.get_varchar2_value
1247: (p_transaction_step_id => p_transaction_step_id
1248: ,p_name => 'P_ATTRIBUTE2_'||i)
1249:
1250: --attribute3

Line 1251: ,hr_transaction_api.get_varchar2_value

1247: (p_transaction_step_id => p_transaction_step_id
1248: ,p_name => 'P_ATTRIBUTE2_'||i)
1249:
1250: --attribute3
1251: ,hr_transaction_api.get_varchar2_value
1252: (p_transaction_step_id => p_transaction_step_id
1253: ,p_name => 'P_ATTRIBUTE3_'||i)
1254:
1255: --attribute4

Line 1256: ,hr_transaction_api.get_varchar2_value

1252: (p_transaction_step_id => p_transaction_step_id
1253: ,p_name => 'P_ATTRIBUTE3_'||i)
1254:
1255: --attribute4
1256: ,hr_transaction_api.get_varchar2_value
1257: (p_transaction_step_id => p_transaction_step_id
1258: ,p_name => 'P_ATTRIBUTE4_'||i)
1259:
1260: --attribute5

Line 1261: ,hr_transaction_api.get_varchar2_value

1257: (p_transaction_step_id => p_transaction_step_id
1258: ,p_name => 'P_ATTRIBUTE4_'||i)
1259:
1260: --attribute5
1261: ,hr_transaction_api.get_varchar2_value
1262: (p_transaction_step_id => p_transaction_step_id
1263: ,p_name => 'P_ATTRIBUTE5_'||i)
1264:
1265: --attribute6

Line 1266: ,hr_transaction_api.get_varchar2_value

1262: (p_transaction_step_id => p_transaction_step_id
1263: ,p_name => 'P_ATTRIBUTE5_'||i)
1264:
1265: --attribute6
1266: ,hr_transaction_api.get_varchar2_value
1267: (p_transaction_step_id => p_transaction_step_id
1268: ,p_name => 'P_ATTRIBUTE6_'||i)
1269:
1270: --attribute7

Line 1271: ,hr_transaction_api.get_varchar2_value

1267: (p_transaction_step_id => p_transaction_step_id
1268: ,p_name => 'P_ATTRIBUTE6_'||i)
1269:
1270: --attribute7
1271: ,hr_transaction_api.get_varchar2_value
1272: (p_transaction_step_id => p_transaction_step_id
1273: ,p_name => 'P_ATTRIBUTE7_'||i)
1274:
1275: --attribute8

Line 1276: ,hr_transaction_api.get_varchar2_value

1272: (p_transaction_step_id => p_transaction_step_id
1273: ,p_name => 'P_ATTRIBUTE7_'||i)
1274:
1275: --attribute8
1276: ,hr_transaction_api.get_varchar2_value
1277: (p_transaction_step_id => p_transaction_step_id
1278: ,p_name => 'P_ATTRIBUTE8_'||i)
1279:
1280: --attribute9

Line 1281: ,hr_transaction_api.get_varchar2_value

1277: (p_transaction_step_id => p_transaction_step_id
1278: ,p_name => 'P_ATTRIBUTE8_'||i)
1279:
1280: --attribute9
1281: ,hr_transaction_api.get_varchar2_value
1282: (p_transaction_step_id => p_transaction_step_id
1283: ,p_name => 'P_ATTRIBUTE9_'||i)
1284:
1285: --attribute10

Line 1286: ,hr_transaction_api.get_varchar2_value

1282: (p_transaction_step_id => p_transaction_step_id
1283: ,p_name => 'P_ATTRIBUTE9_'||i)
1284:
1285: --attribute10
1286: ,hr_transaction_api.get_varchar2_value
1287: (p_transaction_step_id => p_transaction_step_id
1288: ,p_name => 'P_ATTRIBUTE10_'||i)
1289:
1290: --attribute11

Line 1291: ,hr_transaction_api.get_varchar2_value

1287: (p_transaction_step_id => p_transaction_step_id
1288: ,p_name => 'P_ATTRIBUTE10_'||i)
1289:
1290: --attribute11
1291: ,hr_transaction_api.get_varchar2_value
1292: (p_transaction_step_id => p_transaction_step_id
1293: ,p_name => 'P_ATTRIBUTE11_'||i)
1294:
1295: --attribute12

Line 1296: ,hr_transaction_api.get_varchar2_value

1292: (p_transaction_step_id => p_transaction_step_id
1293: ,p_name => 'P_ATTRIBUTE11_'||i)
1294:
1295: --attribute12
1296: ,hr_transaction_api.get_varchar2_value
1297: (p_transaction_step_id => p_transaction_step_id
1298: ,p_name => 'P_ATTRIBUTE12_'||i)
1299:
1300: --attribute13

Line 1301: ,hr_transaction_api.get_varchar2_value

1297: (p_transaction_step_id => p_transaction_step_id
1298: ,p_name => 'P_ATTRIBUTE12_'||i)
1299:
1300: --attribute13
1301: ,hr_transaction_api.get_varchar2_value
1302: (p_transaction_step_id => p_transaction_step_id
1303: ,p_name => 'P_ATTRIBUTE13_'||i)
1304:
1305: --attribute14

Line 1306: ,hr_transaction_api.get_varchar2_value

1302: (p_transaction_step_id => p_transaction_step_id
1303: ,p_name => 'P_ATTRIBUTE13_'||i)
1304:
1305: --attribute14
1306: ,hr_transaction_api.get_varchar2_value
1307: (p_transaction_step_id => p_transaction_step_id
1308: ,p_name => 'P_ATTRIBUTE14_'||i)
1309:
1310: --attribute15

Line 1311: ,hr_transaction_api.get_varchar2_value

1307: (p_transaction_step_id => p_transaction_step_id
1308: ,p_name => 'P_ATTRIBUTE14_'||i)
1309:
1310: --attribute15
1311: ,hr_transaction_api.get_varchar2_value
1312: (p_transaction_step_id => p_transaction_step_id
1313: ,p_name => 'P_ATTRIBUTE15_'||i)
1314:
1315: --attribute16

Line 1316: ,hr_transaction_api.get_varchar2_value

1312: (p_transaction_step_id => p_transaction_step_id
1313: ,p_name => 'P_ATTRIBUTE15_'||i)
1314:
1315: --attribute16
1316: ,hr_transaction_api.get_varchar2_value
1317: (p_transaction_step_id => p_transaction_step_id
1318: ,p_name => 'P_ATTRIBUTE16_'||i)
1319:
1320: --attribute17

Line 1321: ,hr_transaction_api.get_varchar2_value

1317: (p_transaction_step_id => p_transaction_step_id
1318: ,p_name => 'P_ATTRIBUTE16_'||i)
1319:
1320: --attribute17
1321: ,hr_transaction_api.get_varchar2_value
1322: (p_transaction_step_id => p_transaction_step_id
1323: ,p_name => 'P_ATTRIBUTE17_'||i)
1324:
1325: --attribute18

Line 1326: ,hr_transaction_api.get_varchar2_value

1322: (p_transaction_step_id => p_transaction_step_id
1323: ,p_name => 'P_ATTRIBUTE17_'||i)
1324:
1325: --attribute18
1326: ,hr_transaction_api.get_varchar2_value
1327: (p_transaction_step_id => p_transaction_step_id
1328: ,p_name => 'P_ATTRIBUTE18_'||i)
1329:
1330: --attribute19

Line 1331: ,hr_transaction_api.get_varchar2_value

1327: (p_transaction_step_id => p_transaction_step_id
1328: ,p_name => 'P_ATTRIBUTE18_'||i)
1329:
1330: --attribute19
1331: ,hr_transaction_api.get_varchar2_value
1332: (p_transaction_step_id => p_transaction_step_id
1333: ,p_name => 'P_ATTRIBUTE19_'||i)
1334:
1335: --attribute20

Line 1336: ,hr_transaction_api.get_varchar2_value

1332: (p_transaction_step_id => p_transaction_step_id
1333: ,p_name => 'P_ATTRIBUTE19_'||i)
1334:
1335: --attribute20
1336: ,hr_transaction_api.get_varchar2_value
1337: (p_transaction_step_id => p_transaction_step_id
1338: ,p_name => 'P_ATTRIBUTE20_'||i)
1339:
1340: --information_category

Line 1341: ,hr_transaction_api.get_varchar2_value

1337: (p_transaction_step_id => p_transaction_step_id
1338: ,p_name => 'P_ATTRIBUTE20_'||i)
1339:
1340: --information_category
1341: ,hr_transaction_api.get_varchar2_value
1342: (p_transaction_step_id => p_transaction_step_id
1343: ,p_name => 'P_INFORMATION_CATEGORY_'||i)
1344:
1345: --information1

Line 1346: ,hr_transaction_api.get_varchar2_value

1342: (p_transaction_step_id => p_transaction_step_id
1343: ,p_name => 'P_INFORMATION_CATEGORY_'||i)
1344:
1345: --information1
1346: ,hr_transaction_api.get_varchar2_value
1347: (p_transaction_step_id => p_transaction_step_id
1348: ,p_name => 'P_INFORMATION1_'||i)
1349:
1350: --information2

Line 1351: ,hr_transaction_api.get_varchar2_value

1347: (p_transaction_step_id => p_transaction_step_id
1348: ,p_name => 'P_INFORMATION1_'||i)
1349:
1350: --information2
1351: ,hr_transaction_api.get_varchar2_value
1352: (p_transaction_step_id => p_transaction_step_id
1353: ,p_name => 'P_INFORMATION2_'||i)
1354:
1355: --information3

Line 1356: ,hr_transaction_api.get_varchar2_value

1352: (p_transaction_step_id => p_transaction_step_id
1353: ,p_name => 'P_INFORMATION2_'||i)
1354:
1355: --information3
1356: ,hr_transaction_api.get_varchar2_value
1357: (p_transaction_step_id => p_transaction_step_id
1358: ,p_name => 'P_INFORMATION3_'||i)
1359:
1360: --information4

Line 1361: ,hr_transaction_api.get_varchar2_value

1357: (p_transaction_step_id => p_transaction_step_id
1358: ,p_name => 'P_INFORMATION3_'||i)
1359:
1360: --information4
1361: ,hr_transaction_api.get_varchar2_value
1362: (p_transaction_step_id => p_transaction_step_id
1363: ,p_name => 'P_INFORMATION4_'||i)
1364:
1365: --information5

Line 1366: ,hr_transaction_api.get_varchar2_value

1362: (p_transaction_step_id => p_transaction_step_id
1363: ,p_name => 'P_INFORMATION4_'||i)
1364:
1365: --information5
1366: ,hr_transaction_api.get_varchar2_value
1367: (p_transaction_step_id => p_transaction_step_id
1368: ,p_name => 'P_INFORMATION5_'||i)
1369:
1370: --information6

Line 1371: ,hr_transaction_api.get_varchar2_value

1367: (p_transaction_step_id => p_transaction_step_id
1368: ,p_name => 'P_INFORMATION5_'||i)
1369:
1370: --information6
1371: ,hr_transaction_api.get_varchar2_value
1372: (p_transaction_step_id => p_transaction_step_id
1373: ,p_name => 'P_INFORMATION6_'||i)
1374:
1375: --information7

Line 1376: ,hr_transaction_api.get_varchar2_value

1372: (p_transaction_step_id => p_transaction_step_id
1373: ,p_name => 'P_INFORMATION6_'||i)
1374:
1375: --information7
1376: ,hr_transaction_api.get_varchar2_value
1377: (p_transaction_step_id => p_transaction_step_id
1378: ,p_name => 'P_INFORMATION7_'||i)
1379:
1380: --information8

Line 1381: ,hr_transaction_api.get_varchar2_value

1377: (p_transaction_step_id => p_transaction_step_id
1378: ,p_name => 'P_INFORMATION7_'||i)
1379:
1380: --information8
1381: ,hr_transaction_api.get_varchar2_value
1382: (p_transaction_step_id => p_transaction_step_id
1383: ,p_name => 'P_INFORMATION8_'||i)
1384:
1385: --information9

Line 1386: ,hr_transaction_api.get_varchar2_value

1382: (p_transaction_step_id => p_transaction_step_id
1383: ,p_name => 'P_INFORMATION8_'||i)
1384:
1385: --information9
1386: ,hr_transaction_api.get_varchar2_value
1387: (p_transaction_step_id => p_transaction_step_id
1388: ,p_name => 'P_INFORMATION9_'||i)
1389:
1390: --information10

Line 1391: ,hr_transaction_api.get_varchar2_value

1387: (p_transaction_step_id => p_transaction_step_id
1388: ,p_name => 'P_INFORMATION9_'||i)
1389:
1390: --information10
1391: ,hr_transaction_api.get_varchar2_value
1392: (p_transaction_step_id => p_transaction_step_id
1393: ,p_name => 'P_INFORMATION10_'||i)
1394:
1395: --information11

Line 1396: ,hr_transaction_api.get_varchar2_value

1392: (p_transaction_step_id => p_transaction_step_id
1393: ,p_name => 'P_INFORMATION10_'||i)
1394:
1395: --information11
1396: ,hr_transaction_api.get_varchar2_value
1397: (p_transaction_step_id => p_transaction_step_id
1398: ,p_name => 'P_INFORMATION11_'||i)
1399:
1400: --information12

Line 1401: ,hr_transaction_api.get_varchar2_value

1397: (p_transaction_step_id => p_transaction_step_id
1398: ,p_name => 'P_INFORMATION11_'||i)
1399:
1400: --information12
1401: ,hr_transaction_api.get_varchar2_value
1402: (p_transaction_step_id => p_transaction_step_id
1403: ,p_name => 'P_INFORMATION12_'||i)
1404:
1405: --information13

Line 1406: ,hr_transaction_api.get_varchar2_value

1402: (p_transaction_step_id => p_transaction_step_id
1403: ,p_name => 'P_INFORMATION12_'||i)
1404:
1405: --information13
1406: ,hr_transaction_api.get_varchar2_value
1407: (p_transaction_step_id => p_transaction_step_id
1408: ,p_name => 'P_INFORMATION13_'||i)
1409:
1410: --information14

Line 1411: ,hr_transaction_api.get_varchar2_value

1407: (p_transaction_step_id => p_transaction_step_id
1408: ,p_name => 'P_INFORMATION13_'||i)
1409:
1410: --information14
1411: ,hr_transaction_api.get_varchar2_value
1412: (p_transaction_step_id => p_transaction_step_id
1413: ,p_name => 'P_INFORMATION14_'||i)
1414:
1415: --information15

Line 1416: ,hr_transaction_api.get_varchar2_value

1412: (p_transaction_step_id => p_transaction_step_id
1413: ,p_name => 'P_INFORMATION14_'||i)
1414:
1415: --information15
1416: ,hr_transaction_api.get_varchar2_value
1417: (p_transaction_step_id => p_transaction_step_id
1418: ,p_name => 'P_INFORMATION15_'||i)
1419:
1420: --information16

Line 1421: ,hr_transaction_api.get_varchar2_value

1417: (p_transaction_step_id => p_transaction_step_id
1418: ,p_name => 'P_INFORMATION15_'||i)
1419:
1420: --information16
1421: ,hr_transaction_api.get_varchar2_value
1422: (p_transaction_step_id => p_transaction_step_id
1423: ,p_name => 'P_INFORMATION16_'||i)
1424:
1425: --information17

Line 1426: ,hr_transaction_api.get_varchar2_value

1422: (p_transaction_step_id => p_transaction_step_id
1423: ,p_name => 'P_INFORMATION16_'||i)
1424:
1425: --information17
1426: ,hr_transaction_api.get_varchar2_value
1427: (p_transaction_step_id => p_transaction_step_id
1428: ,p_name => 'P_INFORMATION17_'||i)
1429:
1430: --information18

Line 1431: ,hr_transaction_api.get_varchar2_value

1427: (p_transaction_step_id => p_transaction_step_id
1428: ,p_name => 'P_INFORMATION17_'||i)
1429:
1430: --information18
1431: ,hr_transaction_api.get_varchar2_value
1432: (p_transaction_step_id => p_transaction_step_id
1433: ,p_name => 'P_INFORMATION18_'||i)
1434:
1435: --information19

Line 1436: ,hr_transaction_api.get_varchar2_value

1432: (p_transaction_step_id => p_transaction_step_id
1433: ,p_name => 'P_INFORMATION18_'||i)
1434:
1435: --information19
1436: ,hr_transaction_api.get_varchar2_value
1437: (p_transaction_step_id => p_transaction_step_id
1438: ,p_name => 'P_INFORMATION19_'||i)
1439:
1440: --information20

Line 1441: ,hr_transaction_api.get_varchar2_value

1437: (p_transaction_step_id => p_transaction_step_id
1438: ,p_name => 'P_INFORMATION19_'||i)
1439:
1440: --information20
1441: ,hr_transaction_api.get_varchar2_value
1442: (p_transaction_step_id => p_transaction_step_id
1443: ,p_name => 'P_INFORMATION20_'||i)
1444:
1445: --information21

Line 1446: ,hr_transaction_api.get_varchar2_value

1442: (p_transaction_step_id => p_transaction_step_id
1443: ,p_name => 'P_INFORMATION20_'||i)
1444:
1445: --information21
1446: ,hr_transaction_api.get_varchar2_value
1447: (p_transaction_step_id => p_transaction_step_id
1448: ,p_name => 'P_INFORMATION21_'||i)
1449:
1450: --information22

Line 1451: ,hr_transaction_api.get_varchar2_value

1447: (p_transaction_step_id => p_transaction_step_id
1448: ,p_name => 'P_INFORMATION21_'||i)
1449:
1450: --information22
1451: ,hr_transaction_api.get_varchar2_value
1452: (p_transaction_step_id => p_transaction_step_id
1453: ,p_name => 'P_INFORMATION22_'||i)
1454:
1455: --information23

Line 1456: ,hr_transaction_api.get_varchar2_value

1452: (p_transaction_step_id => p_transaction_step_id
1453: ,p_name => 'P_INFORMATION22_'||i)
1454:
1455: --information23
1456: ,hr_transaction_api.get_varchar2_value
1457: (p_transaction_step_id => p_transaction_step_id
1458: ,p_name => 'P_INFORMATION23_'||i)
1459:
1460: --information24

Line 1461: ,hr_transaction_api.get_varchar2_value

1457: (p_transaction_step_id => p_transaction_step_id
1458: ,p_name => 'P_INFORMATION23_'||i)
1459:
1460: --information24
1461: ,hr_transaction_api.get_varchar2_value
1462: (p_transaction_step_id => p_transaction_step_id
1463: ,p_name => 'P_INFORMATION24_'||i)
1464:
1465: --information25

Line 1466: ,hr_transaction_api.get_varchar2_value

1462: (p_transaction_step_id => p_transaction_step_id
1463: ,p_name => 'P_INFORMATION24_'||i)
1464:
1465: --information25
1466: ,hr_transaction_api.get_varchar2_value
1467: (p_transaction_step_id => p_transaction_step_id
1468: ,p_name => 'P_INFORMATION25_'||i)
1469:
1470: --information26

Line 1471: ,hr_transaction_api.get_varchar2_value

1467: (p_transaction_step_id => p_transaction_step_id
1468: ,p_name => 'P_INFORMATION25_'||i)
1469:
1470: --information26
1471: ,hr_transaction_api.get_varchar2_value
1472: (p_transaction_step_id => p_transaction_step_id
1473: ,p_name => 'P_INFORMATION26_'||i)
1474:
1475: --information27

Line 1476: ,hr_transaction_api.get_varchar2_value

1472: (p_transaction_step_id => p_transaction_step_id
1473: ,p_name => 'P_INFORMATION26_'||i)
1474:
1475: --information27
1476: ,hr_transaction_api.get_varchar2_value
1477: (p_transaction_step_id => p_transaction_step_id
1478: ,p_name => 'P_INFORMATION27_'||i)
1479:
1480: --information28

Line 1481: ,hr_transaction_api.get_varchar2_value

1477: (p_transaction_step_id => p_transaction_step_id
1478: ,p_name => 'P_INFORMATION27_'||i)
1479:
1480: --information28
1481: ,hr_transaction_api.get_varchar2_value
1482: (p_transaction_step_id => p_transaction_step_id
1483: ,p_name => 'P_INFORMATION28_'||i)
1484:
1485: --information29

Line 1486: ,hr_transaction_api.get_varchar2_value

1482: (p_transaction_step_id => p_transaction_step_id
1483: ,p_name => 'P_INFORMATION28_'||i)
1484:
1485: --information29
1486: ,hr_transaction_api.get_varchar2_value
1487: (p_transaction_step_id => p_transaction_step_id
1488: ,p_name => 'P_INFORMATION29_'||i)
1489:
1490: --information30

Line 1491: ,hr_transaction_api.get_varchar2_value

1487: (p_transaction_step_id => p_transaction_step_id
1488: ,p_name => 'P_INFORMATION29_'||i)
1489:
1490: --information30
1491: ,hr_transaction_api.get_varchar2_value
1492: (p_transaction_step_id => p_transaction_step_id
1493: ,p_name => 'P_INFORMATION30_'||i));
1494:
1495: END LOOP;