APPS.HR_QUA_AWARDS_UTIL_SS dependencies on HR_TRANSACTION_API

Line 136: hr_transaction_api.get_varchar2_value

132: ,p_qua_subjects => l_qua_subjects
133: ,p_qua_attendance => l_qua_attendance);
134:
135: l_selected_person_id := to_number(
136: hr_transaction_api.get_varchar2_value
137: (p_transaction_step_id => p_transaction_step_id
138: ,p_name => 'P_SELECTED_PERSON_ID'));
139:
140: IF l_qualifications(1).delete_flag = 'Y' THEN

Line 1158: hr_transaction_api.get_varchar2_value

1154:
1155: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1156: FOR i IN 1..NVL(l_transaction_step_id.count,0) LOOP
1157: l_qualification_id :=
1158: hr_transaction_api.get_varchar2_value
1159: (p_transaction_step_id => l_transaction_step_id(i)
1160: ,p_name => 'P_QUALIFICATION_ID');
1161: IF l_qualification_id = p_qualification_id THEN
1162: l_pending_found := 'Y';

Line 1361: hr_transaction_api.create_transaction_step

1357: ,p_item_key => p_item_key);
1358:
1359: --create a transaction step for this transaction.
1360:
1361: hr_transaction_api.create_transaction_step
1362: (p_validate => FALSE
1363: ,p_creator_person_id => p_creator_person_id
1364: ,p_transaction_id => l_transaction_id
1365: ,p_api_name => HR_QUA_AWARDS_UTIL_SS.API_NAME

Line 1374: hr_transaction_api.set_varchar2_value

1370:
1371:
1372: --save to transaction table
1373:
1374: hr_transaction_api.set_varchar2_value
1375: (p_transaction_step_id => p_transaction_step_id
1376: ,p_person_id => p_creator_person_id
1377: ,p_name => 'p_mode'
1378: ,p_value => p_mode);

Line 1380: hr_transaction_api.set_varchar2_value

1376: ,p_person_id => p_creator_person_id
1377: ,p_name => 'p_mode'
1378: ,p_value => p_mode);
1379:
1380: hr_transaction_api.set_varchar2_value
1381: (p_transaction_step_id => p_transaction_step_id
1382: ,p_person_id => p_creator_person_id
1383: ,p_name => 'P_SELECTED_PERSON_ID'
1384: ,p_value => p_selected_person_id);

Line 1386: hr_transaction_api.set_varchar2_value

1382: ,p_person_id => p_creator_person_id
1383: ,p_name => 'P_SELECTED_PERSON_ID'
1384: ,p_value => p_selected_person_id);
1385:
1386: hr_transaction_api.set_varchar2_value
1387: (p_transaction_step_id => p_transaction_step_id
1388: ,p_person_id => p_creator_person_id
1389: ,p_name => 'P_PQ_PERSON_ID'
1390: ,p_value => p_qualifications(1).person_id);

Line 1392: hr_transaction_api.set_varchar2_value

1388: ,p_person_id => p_creator_person_id
1389: ,p_name => 'P_PQ_PERSON_ID'
1390: ,p_value => p_qualifications(1).person_id);
1391:
1392: hr_transaction_api.set_varchar2_value
1393: (p_transaction_step_id => p_transaction_step_id
1394: ,p_person_id => p_creator_person_id
1395: ,p_name => 'P_BUSINESS_GROUP_ID'
1396: ,p_value => p_qualifications(1).business_group_id);

Line 1399: hr_transaction_api.set_varchar2_value

1395: ,p_name => 'P_BUSINESS_GROUP_ID'
1396: ,p_value => p_qualifications(1).business_group_id);
1397:
1398:
1399: hr_transaction_api.set_varchar2_value
1400: (p_transaction_step_id => p_transaction_step_id
1401: ,p_person_id => p_creator_person_id
1402: ,p_name => 'P_DELETE_FLAG'
1403: ,p_value => p_qualifications(1).delete_flag);

Line 1405: hr_transaction_api.set_varchar2_value

1401: ,p_person_id => p_creator_person_id
1402: ,p_name => 'P_DELETE_FLAG'
1403: ,p_value => p_qualifications(1).delete_flag);
1404:
1405: hr_transaction_api.set_varchar2_value
1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_person_id => p_creator_person_id
1408: ,p_name => 'P_QUALIFICATION_ID'
1409: ,p_value => p_qualifications(1).qualification_id);

Line 1411: hr_transaction_api.set_varchar2_value

1407: ,p_person_id => p_creator_person_id
1408: ,p_name => 'P_QUALIFICATION_ID'
1409: ,p_value => p_qualifications(1).qualification_id);
1410:
1411: hr_transaction_api.set_varchar2_value
1412: (p_transaction_step_id => p_transaction_step_id
1413: ,p_person_id => p_creator_person_id
1414: ,p_name => 'P_QUALIFICATION_TYPE_ID'
1415: ,p_value => p_qualifications(1).qualification_type_id);

Line 1417: hr_transaction_api.set_varchar2_value

1413: ,p_person_id => p_creator_person_id
1414: ,p_name => 'P_QUALIFICATION_TYPE_ID'
1415: ,p_value => p_qualifications(1).qualification_type_id);
1416:
1417: hr_transaction_api.set_varchar2_value
1418: (p_transaction_step_id => p_transaction_step_id
1419: ,p_person_id => p_creator_person_id
1420: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER'
1421: ,p_value => p_qualifications(1).object_version_number);

Line 1423: hr_transaction_api.set_varchar2_value

1419: ,p_person_id => p_creator_person_id
1420: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER'
1421: ,p_value => p_qualifications(1).object_version_number);
1422:
1423: hr_transaction_api.set_varchar2_value
1424: (p_transaction_step_id => p_transaction_step_id
1425: ,p_person_id => p_creator_person_id
1426: ,p_name => 'P_PQ_TITLE'
1427: ,p_value => p_qualifications(1).title);

Line 1429: hr_transaction_api.set_date_value

1425: ,p_person_id => p_creator_person_id
1426: ,p_name => 'P_PQ_TITLE'
1427: ,p_value => p_qualifications(1).title);
1428:
1429: hr_transaction_api.set_date_value
1430: (p_transaction_step_id => p_transaction_step_id
1431: ,p_person_id => p_creator_person_id
1432: ,p_name => 'P_PQ_START_DATE'
1433: ,p_value => p_qualifications(1).start_date);

Line 1435: hr_transaction_api.set_date_value

1431: ,p_person_id => p_creator_person_id
1432: ,p_name => 'P_PQ_START_DATE'
1433: ,p_value => p_qualifications(1).start_date);
1434:
1435: hr_transaction_api.set_date_value
1436: (p_transaction_step_id => p_transaction_step_id
1437: ,p_person_id => p_creator_person_id
1438: ,p_name => 'P_PQ_END_DATE'
1439: ,p_value => p_qualifications(1).end_date);

Line 1441: hr_transaction_api.set_varchar2_value

1437: ,p_person_id => p_creator_person_id
1438: ,p_name => 'P_PQ_END_DATE'
1439: ,p_value => p_qualifications(1).end_date);
1440:
1441: hr_transaction_api.set_varchar2_value
1442: (p_transaction_step_id => p_transaction_step_id
1443: ,p_person_id => p_creator_person_id
1444: ,p_name => 'P_PQ_STATUS'
1445: ,p_value => p_qualifications(1).status);

Line 1447: hr_transaction_api.set_varchar2_value

1443: ,p_person_id => p_creator_person_id
1444: ,p_name => 'P_PQ_STATUS'
1445: ,p_value => p_qualifications(1).status);
1446:
1447: hr_transaction_api.set_varchar2_value
1448: (p_transaction_step_id => p_transaction_step_id
1449: ,p_person_id => p_creator_person_id
1450: ,p_name => 'P_PQ_GRADE_ATTAINED'
1451: ,p_value => p_qualifications(1).grade_attained);

Line 1453: hr_transaction_api.set_varchar2_value

1449: ,p_person_id => p_creator_person_id
1450: ,p_name => 'P_PQ_GRADE_ATTAINED'
1451: ,p_value => p_qualifications(1).grade_attained);
1452:
1453: hr_transaction_api.set_varchar2_value
1454: (p_transaction_step_id => p_transaction_step_id
1455: ,p_person_id => p_creator_person_id
1456: ,p_name => 'P_PQ_TUITION_METHOD'
1457: ,p_value => p_qualifications(1).tuition_method);

Line 1459: hr_transaction_api.set_varchar2_value

1455: ,p_person_id => p_creator_person_id
1456: ,p_name => 'P_PQ_TUITION_METHOD'
1457: ,p_value => p_qualifications(1).tuition_method);
1458:
1459: hr_transaction_api.set_varchar2_value
1460: (p_transaction_step_id => p_transaction_step_id
1461: ,p_person_id => p_creator_person_id
1462: ,p_name => 'P_PQ_FEE'
1463: ,p_value => p_qualifications(1).fee);

Line 1465: hr_transaction_api.set_varchar2_value

1461: ,p_person_id => p_creator_person_id
1462: ,p_name => 'P_PQ_FEE'
1463: ,p_value => p_qualifications(1).fee);
1464:
1465: hr_transaction_api.set_varchar2_value
1466: (p_transaction_step_id => p_transaction_step_id
1467: ,p_person_id => p_creator_person_id
1468: ,p_name => 'P_PQ_FEE_CURRENCY'
1469: ,p_value => p_qualifications(1).fee_currency);

Line 1471: hr_transaction_api.set_varchar2_value

1467: ,p_person_id => p_creator_person_id
1468: ,p_name => 'P_PQ_FEE_CURRENCY'
1469: ,p_value => p_qualifications(1).fee_currency);
1470:
1471: hr_transaction_api.set_varchar2_value
1472: (p_transaction_step_id => p_transaction_step_id
1473: ,p_person_id => p_creator_person_id
1474: ,p_name => 'P_PQ_REIMBURSEMENT'
1475: ,p_value => p_qualifications(1).reimbursement_arrangements);

Line 1477: hr_transaction_api.set_varchar2_value

1473: ,p_person_id => p_creator_person_id
1474: ,p_name => 'P_PQ_REIMBURSEMENT'
1475: ,p_value => p_qualifications(1).reimbursement_arrangements);
1476:
1477: hr_transaction_api.set_varchar2_value
1478: (p_transaction_step_id => p_transaction_step_id
1479: ,p_person_id => p_creator_person_id
1480: ,p_name => 'P_PQ_COMPLETED_AMOUNT'
1481: ,p_value => p_qualifications(1).training_completed_amount);

Line 1483: hr_transaction_api.set_varchar2_value

1479: ,p_person_id => p_creator_person_id
1480: ,p_name => 'P_PQ_COMPLETED_AMOUNT'
1481: ,p_value => p_qualifications(1).training_completed_amount);
1482:
1483: hr_transaction_api.set_varchar2_value
1484: (p_transaction_step_id => p_transaction_step_id
1485: ,p_person_id => p_creator_person_id
1486: ,p_name => 'P_PQ_COMPLETED_UNITS'
1487: ,p_value => p_qualifications(1).training_completed_units);

Line 1489: hr_transaction_api.set_varchar2_value

1485: ,p_person_id => p_creator_person_id
1486: ,p_name => 'P_PQ_COMPLETED_UNITS'
1487: ,p_value => p_qualifications(1).training_completed_units);
1488:
1489: hr_transaction_api.set_varchar2_value
1490: (p_transaction_step_id => p_transaction_step_id
1491: ,p_person_id => p_creator_person_id
1492: ,p_name => 'P_PQ_TOTAL_AMOUNT'
1493: ,p_value => p_qualifications(1).total_training_amount);

Line 1495: hr_transaction_api.set_varchar2_value

1491: ,p_person_id => p_creator_person_id
1492: ,p_name => 'P_PQ_TOTAL_AMOUNT'
1493: ,p_value => p_qualifications(1).total_training_amount);
1494:
1495: hr_transaction_api.set_varchar2_value
1496: (p_transaction_step_id => p_transaction_step_id
1497: ,p_person_id => p_creator_person_id
1498: ,p_name => 'P_PQ_COMMENTS'
1499: ,p_value => p_qualifications(1).comments);

Line 1501: hr_transaction_api.set_varchar2_value

1497: ,p_person_id => p_creator_person_id
1498: ,p_name => 'P_PQ_COMMENTS'
1499: ,p_value => p_qualifications(1).comments);
1500:
1501: hr_transaction_api.set_varchar2_value
1502: (p_transaction_step_id => p_transaction_step_id
1503: ,p_person_id => p_creator_person_id
1504: ,p_name => 'P_PQ_AWARDING_BODY'
1505: ,p_value => p_qualifications(1).awarding_body);

Line 1507: hr_transaction_api.set_varchar2_value

1503: ,p_person_id => p_creator_person_id
1504: ,p_name => 'P_PQ_AWARDING_BODY'
1505: ,p_value => p_qualifications(1).awarding_body);
1506:
1507: hr_transaction_api.set_varchar2_value
1508: (p_transaction_step_id => p_transaction_step_id
1509: ,p_person_id => p_creator_person_id
1510: ,p_name => 'P_PQ_GROUP_RANKING'
1511: ,p_value => p_qualifications(1).group_ranking);

Line 1513: hr_transaction_api.set_date_value

1509: ,p_person_id => p_creator_person_id
1510: ,p_name => 'P_PQ_GROUP_RANKING'
1511: ,p_value => p_qualifications(1).group_ranking);
1512:
1513: hr_transaction_api.set_date_value
1514: (p_transaction_step_id => p_transaction_step_id
1515: ,p_person_id => p_creator_person_id
1516: ,p_name => 'P_PQ_AWARDED_DATE'
1517: ,p_value => p_qualifications(1).awarded_date);

Line 1519: hr_transaction_api.set_varchar2_value

1515: ,p_person_id => p_creator_person_id
1516: ,p_name => 'P_PQ_AWARDED_DATE'
1517: ,p_value => p_qualifications(1).awarded_date);
1518:
1519: hr_transaction_api.set_varchar2_value
1520: (p_transaction_step_id => p_transaction_step_id
1521: ,p_person_id => p_creator_person_id
1522: ,p_name => 'P_PQ_LICENSE_NUMBER'
1523: ,p_value => p_qualifications(1).license_number);

Line 1525: hr_transaction_api.set_date_value

1521: ,p_person_id => p_creator_person_id
1522: ,p_name => 'P_PQ_LICENSE_NUMBER'
1523: ,p_value => p_qualifications(1).license_number);
1524:
1525: hr_transaction_api.set_date_value
1526: (p_transaction_step_id => p_transaction_step_id
1527: ,p_person_id => p_creator_person_id
1528: ,p_name => 'P_PQ_EXPIRY_DATE'
1529: ,p_value => p_qualifications(1).expiry_date);

Line 1531: hr_transaction_api.set_varchar2_value

1527: ,p_person_id => p_creator_person_id
1528: ,p_name => 'P_PQ_EXPIRY_DATE'
1529: ,p_value => p_qualifications(1).expiry_date);
1530:
1531: hr_transaction_api.set_varchar2_value
1532: (p_transaction_step_id => p_transaction_step_id
1533: ,p_person_id => p_creator_person_id
1534: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'
1535: ,p_value => p_qualifications(1).license_restrictions);

Line 1537: hr_transaction_api.set_varchar2_value

1533: ,p_person_id => p_creator_person_id
1534: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'
1535: ,p_value => p_qualifications(1).license_restrictions);
1536:
1537: hr_transaction_api.set_varchar2_value
1538: (p_transaction_step_id => p_transaction_step_id
1539: ,p_person_id => p_creator_person_id
1540: ,p_name => 'P_PEA_PERSON_ID'
1541: ,p_value => p_qua_attendance(1).person_id);

Line 1543: hr_transaction_api.set_varchar2_value

1539: ,p_person_id => p_creator_person_id
1540: ,p_name => 'P_PEA_PERSON_ID'
1541: ,p_value => p_qua_attendance(1).person_id);
1542:
1543: hr_transaction_api.set_varchar2_value
1544: (p_transaction_step_id => p_transaction_step_id
1545: ,p_person_id => p_creator_person_id
1546: ,p_name => 'P_ESTABLISHMENT_ID'
1547: ,p_value => p_qua_attendance(1).establishment_id);

Line 1549: hr_transaction_api.set_varchar2_value

1545: ,p_person_id => p_creator_person_id
1546: ,p_name => 'P_ESTABLISHMENT_ID'
1547: ,p_value => p_qua_attendance(1).establishment_id);
1548:
1549: hr_transaction_api.set_varchar2_value
1550: (p_transaction_step_id => p_transaction_step_id
1551: ,p_person_id => p_creator_person_id
1552: ,p_name => 'P_PE_NAME'
1553: ,p_value => p_qua_attendance(1).establishment);

Line 1555: hr_transaction_api.set_varchar2_value

1551: ,p_person_id => p_creator_person_id
1552: ,p_name => 'P_PE_NAME'
1553: ,p_value => p_qua_attendance(1).establishment);
1554:
1555: hr_transaction_api.set_varchar2_value
1556: (p_transaction_step_id => p_transaction_step_id
1557: ,p_person_id => p_creator_person_id
1558: ,p_name => 'P_ATTENDANCE_ID'
1559: ,p_value => p_qualifications(1).attendance_id);

Line 1561: hr_transaction_api.set_varchar2_value

1557: ,p_person_id => p_creator_person_id
1558: ,p_name => 'P_ATTENDANCE_ID'
1559: ,p_value => p_qualifications(1).attendance_id);
1560:
1561: hr_transaction_api.set_varchar2_value
1562: (p_transaction_step_id => p_transaction_step_id
1563: ,p_person_id => p_creator_person_id
1564: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER'
1565: ,p_value => p_qua_attendance(1).object_version_number);

Line 1567: hr_transaction_api.set_date_value

1563: ,p_person_id => p_creator_person_id
1564: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER'
1565: ,p_value => p_qua_attendance(1).object_version_number);
1566:
1567: hr_transaction_api.set_date_value
1568: (p_transaction_step_id => p_transaction_step_id
1569: ,p_person_id => p_creator_person_id
1570: ,p_name => 'P_PEA_START_DATE'
1571: ,p_value => p_qua_attendance(1).attended_start_date);

Line 1573: hr_transaction_api.set_date_value

1569: ,p_person_id => p_creator_person_id
1570: ,p_name => 'P_PEA_START_DATE'
1571: ,p_value => p_qua_attendance(1).attended_start_date);
1572:
1573: hr_transaction_api.set_date_value
1574: (p_transaction_step_id => p_transaction_step_id
1575: ,p_person_id => p_creator_person_id
1576: ,p_name => 'P_PEA_END_DATE'
1577: ,p_value => p_qua_attendance(1).attended_end_date);

Line 1579: hr_transaction_api.set_varchar2_value

1575: ,p_person_id => p_creator_person_id
1576: ,p_name => 'P_PEA_END_DATE'
1577: ,p_value => p_qua_attendance(1).attended_end_date);
1578:
1579: hr_transaction_api.set_varchar2_value
1580: (p_transaction_step_id => p_transaction_step_id
1581: ,p_person_id => p_creator_person_id
1582: ,p_name => 'P_PEA_FULL_TIME'
1583: ,p_value => p_qua_attendance(1).full_time);

Line 1585: hr_transaction_api.set_varchar2_value

1581: ,p_person_id => p_creator_person_id
1582: ,p_name => 'P_PEA_FULL_TIME'
1583: ,p_value => p_qua_attendance(1).full_time);
1584:
1585: hr_transaction_api.set_varchar2_value
1586: (p_transaction_step_id => p_transaction_step_id
1587: ,p_person_id => p_creator_person_id
1588: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'
1589: ,p_value => p_qualifications(1).attribute_category);

Line 1591: hr_transaction_api.set_varchar2_value

1587: ,p_person_id => p_creator_person_id
1588: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'
1589: ,p_value => p_qualifications(1).attribute_category);
1590:
1591: hr_transaction_api.set_varchar2_value
1592: (p_transaction_step_id => p_transaction_step_id
1593: ,p_person_id => p_creator_person_id
1594: ,p_name => 'P_PQ_ATTRIBUTE1'
1595: ,p_value => p_qualifications(1).attribute1);

Line 1597: hr_transaction_api.set_varchar2_value

1593: ,p_person_id => p_creator_person_id
1594: ,p_name => 'P_PQ_ATTRIBUTE1'
1595: ,p_value => p_qualifications(1).attribute1);
1596:
1597: hr_transaction_api.set_varchar2_value
1598: (p_transaction_step_id => p_transaction_step_id
1599: ,p_person_id => p_creator_person_id
1600: ,p_name => 'P_PQ_ATTRIBUTE2'
1601: ,p_value => p_qualifications(1).attribute2);

Line 1603: hr_transaction_api.set_varchar2_value

1599: ,p_person_id => p_creator_person_id
1600: ,p_name => 'P_PQ_ATTRIBUTE2'
1601: ,p_value => p_qualifications(1).attribute2);
1602:
1603: hr_transaction_api.set_varchar2_value
1604: (p_transaction_step_id => p_transaction_step_id
1605: ,p_person_id => p_creator_person_id
1606: ,p_name => 'P_PQ_ATTRIBUTE3'
1607: ,p_value => p_qualifications(1).attribute3);

Line 1609: hr_transaction_api.set_varchar2_value

1605: ,p_person_id => p_creator_person_id
1606: ,p_name => 'P_PQ_ATTRIBUTE3'
1607: ,p_value => p_qualifications(1).attribute3);
1608:
1609: hr_transaction_api.set_varchar2_value
1610: (p_transaction_step_id => p_transaction_step_id
1611: ,p_person_id => p_creator_person_id
1612: ,p_name => 'P_PQ_ATTRIBUTE4'
1613: ,p_value => p_qualifications(1).attribute4);

Line 1615: hr_transaction_api.set_varchar2_value

1611: ,p_person_id => p_creator_person_id
1612: ,p_name => 'P_PQ_ATTRIBUTE4'
1613: ,p_value => p_qualifications(1).attribute4);
1614:
1615: hr_transaction_api.set_varchar2_value
1616: (p_transaction_step_id => p_transaction_step_id
1617: ,p_person_id => p_creator_person_id
1618: ,p_name => 'P_PQ_ATTRIBUTE5'
1619: ,p_value => p_qualifications(1).attribute5);

Line 1621: hr_transaction_api.set_varchar2_value

1617: ,p_person_id => p_creator_person_id
1618: ,p_name => 'P_PQ_ATTRIBUTE5'
1619: ,p_value => p_qualifications(1).attribute5);
1620:
1621: hr_transaction_api.set_varchar2_value
1622: (p_transaction_step_id => p_transaction_step_id
1623: ,p_person_id => p_creator_person_id
1624: ,p_name => 'P_PQ_ATTRIBUTE6'
1625: ,p_value => p_qualifications(1).attribute6);

Line 1627: hr_transaction_api.set_varchar2_value

1623: ,p_person_id => p_creator_person_id
1624: ,p_name => 'P_PQ_ATTRIBUTE6'
1625: ,p_value => p_qualifications(1).attribute6);
1626:
1627: hr_transaction_api.set_varchar2_value
1628: (p_transaction_step_id => p_transaction_step_id
1629: ,p_person_id => p_creator_person_id
1630: ,p_name => 'P_PQ_ATTRIBUTE7'
1631: ,p_value => p_qualifications(1).attribute7);

Line 1633: hr_transaction_api.set_varchar2_value

1629: ,p_person_id => p_creator_person_id
1630: ,p_name => 'P_PQ_ATTRIBUTE7'
1631: ,p_value => p_qualifications(1).attribute7);
1632:
1633: hr_transaction_api.set_varchar2_value
1634: (p_transaction_step_id => p_transaction_step_id
1635: ,p_person_id => p_creator_person_id
1636: ,p_name => 'P_PQ_ATTRIBUTE8'
1637: ,p_value => p_qualifications(1).attribute8);

Line 1639: hr_transaction_api.set_varchar2_value

1635: ,p_person_id => p_creator_person_id
1636: ,p_name => 'P_PQ_ATTRIBUTE8'
1637: ,p_value => p_qualifications(1).attribute8);
1638:
1639: hr_transaction_api.set_varchar2_value
1640: (p_transaction_step_id => p_transaction_step_id
1641: ,p_person_id => p_creator_person_id
1642: ,p_name => 'P_PQ_ATTRIBUTE9'
1643: ,p_value => p_qualifications(1).attribute9);

Line 1645: hr_transaction_api.set_varchar2_value

1641: ,p_person_id => p_creator_person_id
1642: ,p_name => 'P_PQ_ATTRIBUTE9'
1643: ,p_value => p_qualifications(1).attribute9);
1644:
1645: hr_transaction_api.set_varchar2_value
1646: (p_transaction_step_id => p_transaction_step_id
1647: ,p_person_id => p_creator_person_id
1648: ,p_name => 'P_PQ_ATTRIBUTE10'
1649: ,p_value => p_qualifications(1).attribute10);

Line 1651: hr_transaction_api.set_varchar2_value

1647: ,p_person_id => p_creator_person_id
1648: ,p_name => 'P_PQ_ATTRIBUTE10'
1649: ,p_value => p_qualifications(1).attribute10);
1650:
1651: hr_transaction_api.set_varchar2_value
1652: (p_transaction_step_id => p_transaction_step_id
1653: ,p_person_id => p_creator_person_id
1654: ,p_name => 'P_PQ_ATTRIBUTE11'
1655: ,p_value => p_qualifications(1).attribute11);

Line 1657: hr_transaction_api.set_varchar2_value

1653: ,p_person_id => p_creator_person_id
1654: ,p_name => 'P_PQ_ATTRIBUTE11'
1655: ,p_value => p_qualifications(1).attribute11);
1656:
1657: hr_transaction_api.set_varchar2_value
1658: (p_transaction_step_id => p_transaction_step_id
1659: ,p_person_id => p_creator_person_id
1660: ,p_name => 'P_PQ_ATTRIBUTE12'
1661: ,p_value => p_qualifications(1).attribute12);

Line 1663: hr_transaction_api.set_varchar2_value

1659: ,p_person_id => p_creator_person_id
1660: ,p_name => 'P_PQ_ATTRIBUTE12'
1661: ,p_value => p_qualifications(1).attribute12);
1662:
1663: hr_transaction_api.set_varchar2_value
1664: (p_transaction_step_id => p_transaction_step_id
1665: ,p_person_id => p_creator_person_id
1666: ,p_name => 'P_PQ_ATTRIBUTE13'
1667: ,p_value => p_qualifications(1).attribute13);

Line 1669: hr_transaction_api.set_varchar2_value

1665: ,p_person_id => p_creator_person_id
1666: ,p_name => 'P_PQ_ATTRIBUTE13'
1667: ,p_value => p_qualifications(1).attribute13);
1668:
1669: hr_transaction_api.set_varchar2_value
1670: (p_transaction_step_id => p_transaction_step_id
1671: ,p_person_id => p_creator_person_id
1672: ,p_name => 'P_PQ_ATTRIBUTE14'
1673: ,p_value => p_qualifications(1).attribute14);

Line 1675: hr_transaction_api.set_varchar2_value

1671: ,p_person_id => p_creator_person_id
1672: ,p_name => 'P_PQ_ATTRIBUTE14'
1673: ,p_value => p_qualifications(1).attribute14);
1674:
1675: hr_transaction_api.set_varchar2_value
1676: (p_transaction_step_id => p_transaction_step_id
1677: ,p_person_id => p_creator_person_id
1678: ,p_name => 'P_PQ_ATTRIBUTE15'
1679: ,p_value => p_qualifications(1).attribute15);

Line 1681: hr_transaction_api.set_varchar2_value

1677: ,p_person_id => p_creator_person_id
1678: ,p_name => 'P_PQ_ATTRIBUTE15'
1679: ,p_value => p_qualifications(1).attribute15);
1680:
1681: hr_transaction_api.set_varchar2_value
1682: (p_transaction_step_id => p_transaction_step_id
1683: ,p_person_id => p_creator_person_id
1684: ,p_name => 'P_PQ_ATTRIBUTE16'
1685: ,p_value => p_qualifications(1).attribute16);

Line 1687: hr_transaction_api.set_varchar2_value

1683: ,p_person_id => p_creator_person_id
1684: ,p_name => 'P_PQ_ATTRIBUTE16'
1685: ,p_value => p_qualifications(1).attribute16);
1686:
1687: hr_transaction_api.set_varchar2_value
1688: (p_transaction_step_id => p_transaction_step_id
1689: ,p_person_id => p_creator_person_id
1690: ,p_name => 'P_PQ_ATTRIBUTE17'
1691: ,p_value => p_qualifications(1).attribute17);

Line 1693: hr_transaction_api.set_varchar2_value

1689: ,p_person_id => p_creator_person_id
1690: ,p_name => 'P_PQ_ATTRIBUTE17'
1691: ,p_value => p_qualifications(1).attribute17);
1692:
1693: hr_transaction_api.set_varchar2_value
1694: (p_transaction_step_id => p_transaction_step_id
1695: ,p_person_id => p_creator_person_id
1696: ,p_name => 'P_PQ_ATTRIBUTE18'
1697: ,p_value => p_qualifications(1).attribute18);

Line 1699: hr_transaction_api.set_varchar2_value

1695: ,p_person_id => p_creator_person_id
1696: ,p_name => 'P_PQ_ATTRIBUTE18'
1697: ,p_value => p_qualifications(1).attribute18);
1698:
1699: hr_transaction_api.set_varchar2_value
1700: (p_transaction_step_id => p_transaction_step_id
1701: ,p_person_id => p_creator_person_id
1702: ,p_name => 'P_PQ_ATTRIBUTE19'
1703: ,p_value => p_qualifications(1).attribute19);

Line 1705: hr_transaction_api.set_varchar2_value

1701: ,p_person_id => p_creator_person_id
1702: ,p_name => 'P_PQ_ATTRIBUTE19'
1703: ,p_value => p_qualifications(1).attribute19);
1704:
1705: hr_transaction_api.set_varchar2_value
1706: (p_transaction_step_id => p_transaction_step_id
1707: ,p_person_id => p_creator_person_id
1708: ,p_name => 'P_PQ_ATTRIBUTE20'
1709: ,p_value => p_qualifications(1).attribute20);

Line 1711: hr_transaction_api.set_varchar2_value

1707: ,p_person_id => p_creator_person_id
1708: ,p_name => 'P_PQ_ATTRIBUTE20'
1709: ,p_value => p_qualifications(1).attribute20);
1710:
1711: hr_transaction_api.set_varchar2_value
1712: (p_transaction_step_id => p_transaction_step_id
1713: ,p_person_id => p_creator_person_id
1714: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'
1715: ,p_value => p_qualifications(1).qua_information_category);

Line 1717: hr_transaction_api.set_varchar2_value

1713: ,p_person_id => p_creator_person_id
1714: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'
1715: ,p_value => p_qualifications(1).qua_information_category);
1716:
1717: hr_transaction_api.set_varchar2_value
1718: (p_transaction_step_id => p_transaction_step_id
1719: ,p_person_id => p_creator_person_id
1720: ,p_name => 'P_PQ_QUA_INFORMATION1'
1721: ,p_value => p_qualifications(1).qua_information1);

Line 1723: hr_transaction_api.set_varchar2_value

1719: ,p_person_id => p_creator_person_id
1720: ,p_name => 'P_PQ_QUA_INFORMATION1'
1721: ,p_value => p_qualifications(1).qua_information1);
1722:
1723: hr_transaction_api.set_varchar2_value
1724: (p_transaction_step_id => p_transaction_step_id
1725: ,p_person_id => p_creator_person_id
1726: ,p_name => 'P_PQ_QUA_INFORMATION2'
1727: ,p_value => p_qualifications(1).qua_information2);

Line 1728: hr_transaction_api.set_varchar2_value

1724: (p_transaction_step_id => p_transaction_step_id
1725: ,p_person_id => p_creator_person_id
1726: ,p_name => 'P_PQ_QUA_INFORMATION2'
1727: ,p_value => p_qualifications(1).qua_information2);
1728: hr_transaction_api.set_varchar2_value
1729: (p_transaction_step_id => p_transaction_step_id
1730: ,p_person_id => p_creator_person_id
1731: ,p_name => 'P_PQ_QUA_INFORMATION3'
1732: ,p_value => p_qualifications(1).qua_information3);

Line 1733: hr_transaction_api.set_varchar2_value

1729: (p_transaction_step_id => p_transaction_step_id
1730: ,p_person_id => p_creator_person_id
1731: ,p_name => 'P_PQ_QUA_INFORMATION3'
1732: ,p_value => p_qualifications(1).qua_information3);
1733: hr_transaction_api.set_varchar2_value
1734: (p_transaction_step_id => p_transaction_step_id
1735: ,p_person_id => p_creator_person_id
1736: ,p_name => 'P_PQ_QUA_INFORMATION4'
1737: ,p_value => p_qualifications(1).qua_information4);

Line 1738: hr_transaction_api.set_varchar2_value

1734: (p_transaction_step_id => p_transaction_step_id
1735: ,p_person_id => p_creator_person_id
1736: ,p_name => 'P_PQ_QUA_INFORMATION4'
1737: ,p_value => p_qualifications(1).qua_information4);
1738: hr_transaction_api.set_varchar2_value
1739: (p_transaction_step_id => p_transaction_step_id
1740: ,p_person_id => p_creator_person_id
1741: ,p_name => 'P_PQ_QUA_INFORMATION5'
1742: ,p_value => p_qualifications(1).qua_information5);

Line 1743: hr_transaction_api.set_varchar2_value

1739: (p_transaction_step_id => p_transaction_step_id
1740: ,p_person_id => p_creator_person_id
1741: ,p_name => 'P_PQ_QUA_INFORMATION5'
1742: ,p_value => p_qualifications(1).qua_information5);
1743: hr_transaction_api.set_varchar2_value
1744: (p_transaction_step_id => p_transaction_step_id
1745: ,p_person_id => p_creator_person_id
1746: ,p_name => 'P_PQ_QUA_INFORMATION6'
1747: ,p_value => p_qualifications(1).qua_information6);

Line 1748: hr_transaction_api.set_varchar2_value

1744: (p_transaction_step_id => p_transaction_step_id
1745: ,p_person_id => p_creator_person_id
1746: ,p_name => 'P_PQ_QUA_INFORMATION6'
1747: ,p_value => p_qualifications(1).qua_information6);
1748: hr_transaction_api.set_varchar2_value
1749: (p_transaction_step_id => p_transaction_step_id
1750: ,p_person_id => p_creator_person_id
1751: ,p_name => 'P_PQ_QUA_INFORMATION7'
1752: ,p_value => p_qualifications(1).qua_information7);

Line 1753: hr_transaction_api.set_varchar2_value

1749: (p_transaction_step_id => p_transaction_step_id
1750: ,p_person_id => p_creator_person_id
1751: ,p_name => 'P_PQ_QUA_INFORMATION7'
1752: ,p_value => p_qualifications(1).qua_information7);
1753: hr_transaction_api.set_varchar2_value
1754: (p_transaction_step_id => p_transaction_step_id
1755: ,p_person_id => p_creator_person_id
1756: ,p_name => 'P_PQ_QUA_INFORMATION8'
1757: ,p_value => p_qualifications(1).qua_information8);

Line 1758: hr_transaction_api.set_varchar2_value

1754: (p_transaction_step_id => p_transaction_step_id
1755: ,p_person_id => p_creator_person_id
1756: ,p_name => 'P_PQ_QUA_INFORMATION8'
1757: ,p_value => p_qualifications(1).qua_information8);
1758: hr_transaction_api.set_varchar2_value
1759: (p_transaction_step_id => p_transaction_step_id
1760: ,p_person_id => p_creator_person_id
1761: ,p_name => 'P_PQ_QUA_INFORMATION9'
1762: ,p_value => p_qualifications(1).qua_information9);

Line 1763: hr_transaction_api.set_varchar2_value

1759: (p_transaction_step_id => p_transaction_step_id
1760: ,p_person_id => p_creator_person_id
1761: ,p_name => 'P_PQ_QUA_INFORMATION9'
1762: ,p_value => p_qualifications(1).qua_information9);
1763: hr_transaction_api.set_varchar2_value
1764: (p_transaction_step_id => p_transaction_step_id
1765: ,p_person_id => p_creator_person_id
1766: ,p_name => 'P_PQ_QUA_INFORMATION10'
1767: ,p_value => p_qualifications(1).qua_information10);

Line 1769: hr_transaction_api.set_varchar2_value

1765: ,p_person_id => p_creator_person_id
1766: ,p_name => 'P_PQ_QUA_INFORMATION10'
1767: ,p_value => p_qualifications(1).qua_information10);
1768:
1769: hr_transaction_api.set_varchar2_value
1770: (p_transaction_step_id => p_transaction_step_id
1771: ,p_person_id => p_creator_person_id
1772: ,p_name => 'P_PQ_QUA_INFORMATION11'
1773: ,p_value => p_qualifications(1).qua_information11);

Line 1774: hr_transaction_api.set_varchar2_value

1770: (p_transaction_step_id => p_transaction_step_id
1771: ,p_person_id => p_creator_person_id
1772: ,p_name => 'P_PQ_QUA_INFORMATION11'
1773: ,p_value => p_qualifications(1).qua_information11);
1774: hr_transaction_api.set_varchar2_value
1775: (p_transaction_step_id => p_transaction_step_id
1776: ,p_person_id => p_creator_person_id
1777: ,p_name => 'P_PQ_QUA_INFORMATION12'
1778: ,p_value => p_qualifications(1).qua_information12);

Line 1779: hr_transaction_api.set_varchar2_value

1775: (p_transaction_step_id => p_transaction_step_id
1776: ,p_person_id => p_creator_person_id
1777: ,p_name => 'P_PQ_QUA_INFORMATION12'
1778: ,p_value => p_qualifications(1).qua_information12);
1779: hr_transaction_api.set_varchar2_value
1780: (p_transaction_step_id => p_transaction_step_id
1781: ,p_person_id => p_creator_person_id
1782: ,p_name => 'P_PQ_QUA_INFORMATION13'
1783: ,p_value => p_qualifications(1).qua_information13);

Line 1784: hr_transaction_api.set_varchar2_value

1780: (p_transaction_step_id => p_transaction_step_id
1781: ,p_person_id => p_creator_person_id
1782: ,p_name => 'P_PQ_QUA_INFORMATION13'
1783: ,p_value => p_qualifications(1).qua_information13);
1784: hr_transaction_api.set_varchar2_value
1785: (p_transaction_step_id => p_transaction_step_id
1786: ,p_person_id => p_creator_person_id
1787: ,p_name => 'P_PQ_QUA_INFORMATION14'
1788: ,p_value => p_qualifications(1).qua_information14);

Line 1789: hr_transaction_api.set_varchar2_value

1785: (p_transaction_step_id => p_transaction_step_id
1786: ,p_person_id => p_creator_person_id
1787: ,p_name => 'P_PQ_QUA_INFORMATION14'
1788: ,p_value => p_qualifications(1).qua_information14);
1789: hr_transaction_api.set_varchar2_value
1790: (p_transaction_step_id => p_transaction_step_id
1791: ,p_person_id => p_creator_person_id
1792: ,p_name => 'P_PQ_QUA_INFORMATION15'
1793: ,p_value => p_qualifications(1).qua_information15);

Line 1794: hr_transaction_api.set_varchar2_value

1790: (p_transaction_step_id => p_transaction_step_id
1791: ,p_person_id => p_creator_person_id
1792: ,p_name => 'P_PQ_QUA_INFORMATION15'
1793: ,p_value => p_qualifications(1).qua_information15);
1794: hr_transaction_api.set_varchar2_value
1795: (p_transaction_step_id => p_transaction_step_id
1796: ,p_person_id => p_creator_person_id
1797: ,p_name => 'P_PQ_QUA_INFORMATION16'
1798: ,p_value => p_qualifications(1).qua_information16);

Line 1799: hr_transaction_api.set_varchar2_value

1795: (p_transaction_step_id => p_transaction_step_id
1796: ,p_person_id => p_creator_person_id
1797: ,p_name => 'P_PQ_QUA_INFORMATION16'
1798: ,p_value => p_qualifications(1).qua_information16);
1799: hr_transaction_api.set_varchar2_value
1800: (p_transaction_step_id => p_transaction_step_id
1801: ,p_person_id => p_creator_person_id
1802: ,p_name => 'P_PQ_QUA_INFORMATION17'
1803: ,p_value => p_qualifications(1).qua_information17);

Line 1804: hr_transaction_api.set_varchar2_value

1800: (p_transaction_step_id => p_transaction_step_id
1801: ,p_person_id => p_creator_person_id
1802: ,p_name => 'P_PQ_QUA_INFORMATION17'
1803: ,p_value => p_qualifications(1).qua_information17);
1804: hr_transaction_api.set_varchar2_value
1805: (p_transaction_step_id => p_transaction_step_id
1806: ,p_person_id => p_creator_person_id
1807: ,p_name => 'P_PQ_QUA_INFORMATION18'
1808: ,p_value => p_qualifications(1).qua_information18);

Line 1809: hr_transaction_api.set_varchar2_value

1805: (p_transaction_step_id => p_transaction_step_id
1806: ,p_person_id => p_creator_person_id
1807: ,p_name => 'P_PQ_QUA_INFORMATION18'
1808: ,p_value => p_qualifications(1).qua_information18);
1809: hr_transaction_api.set_varchar2_value
1810: (p_transaction_step_id => p_transaction_step_id
1811: ,p_person_id => p_creator_person_id
1812: ,p_name => 'P_PQ_QUA_INFORMATION19'
1813: ,p_value => p_qualifications(1).qua_information19);

Line 1814: hr_transaction_api.set_varchar2_value

1810: (p_transaction_step_id => p_transaction_step_id
1811: ,p_person_id => p_creator_person_id
1812: ,p_name => 'P_PQ_QUA_INFORMATION19'
1813: ,p_value => p_qualifications(1).qua_information19);
1814: hr_transaction_api.set_varchar2_value
1815: (p_transaction_step_id => p_transaction_step_id
1816: ,p_person_id => p_creator_person_id
1817: ,p_name => 'P_PQ_QUA_INFORMATION20'
1818: ,p_value => p_qualifications(1).qua_information20);

Line 1820: hr_transaction_api.set_varchar2_value

1816: ,p_person_id => p_creator_person_id
1817: ,p_name => 'P_PQ_QUA_INFORMATION20'
1818: ,p_value => p_qualifications(1).qua_information20);
1819:
1820: hr_transaction_api.set_varchar2_value
1821: (p_transaction_step_id => p_transaction_step_id
1822: ,p_person_id => p_creator_person_id
1823: ,p_name => 'P_PARTY_ID'
1824: ,p_value => p_qualifications(1).party_id);

Line 1826: hr_transaction_api.set_varchar2_value

1822: ,p_person_id => p_creator_person_id
1823: ,p_name => 'P_PARTY_ID'
1824: ,p_value => p_qualifications(1).party_id);
1825:
1826: hr_transaction_api.set_varchar2_value
1827: (p_transaction_step_id => p_transaction_step_id
1828: ,p_person_id => p_creator_person_id
1829: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'
1830: ,p_value => p_qua_attendance(1).attribute_category);

Line 1832: hr_transaction_api.set_varchar2_value

1828: ,p_person_id => p_creator_person_id
1829: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'
1830: ,p_value => p_qua_attendance(1).attribute_category);
1831:
1832: hr_transaction_api.set_varchar2_value
1833: (p_transaction_step_id => p_transaction_step_id
1834: ,p_person_id => p_creator_person_id
1835: ,p_name => 'P_PEA_ATTRIBUTE1'
1836: ,p_value => p_qua_attendance(1).attribute1);

Line 1838: hr_transaction_api.set_varchar2_value

1834: ,p_person_id => p_creator_person_id
1835: ,p_name => 'P_PEA_ATTRIBUTE1'
1836: ,p_value => p_qua_attendance(1).attribute1);
1837:
1838: hr_transaction_api.set_varchar2_value
1839: (p_transaction_step_id => p_transaction_step_id
1840: ,p_person_id => p_creator_person_id
1841: ,p_name => 'P_PEA_ATTRIBUTE2'
1842: ,p_value => p_qua_attendance(1).attribute2);

Line 1844: hr_transaction_api.set_varchar2_value

1840: ,p_person_id => p_creator_person_id
1841: ,p_name => 'P_PEA_ATTRIBUTE2'
1842: ,p_value => p_qua_attendance(1).attribute2);
1843:
1844: hr_transaction_api.set_varchar2_value
1845: (p_transaction_step_id => p_transaction_step_id
1846: ,p_person_id => p_creator_person_id
1847: ,p_name => 'P_PEA_ATTRIBUTE3'
1848: ,p_value => p_qua_attendance(1).attribute3);

Line 1850: hr_transaction_api.set_varchar2_value

1846: ,p_person_id => p_creator_person_id
1847: ,p_name => 'P_PEA_ATTRIBUTE3'
1848: ,p_value => p_qua_attendance(1).attribute3);
1849:
1850: hr_transaction_api.set_varchar2_value
1851: (p_transaction_step_id => p_transaction_step_id
1852: ,p_person_id => p_creator_person_id
1853: ,p_name => 'P_PEA_ATTRIBUTE4'
1854: ,p_value => p_qua_attendance(1).attribute4);

Line 1856: hr_transaction_api.set_varchar2_value

1852: ,p_person_id => p_creator_person_id
1853: ,p_name => 'P_PEA_ATTRIBUTE4'
1854: ,p_value => p_qua_attendance(1).attribute4);
1855:
1856: hr_transaction_api.set_varchar2_value
1857: (p_transaction_step_id => p_transaction_step_id
1858: ,p_person_id => p_creator_person_id
1859: ,p_name => 'P_PEA_ATTRIBUTE5'
1860: ,p_value => p_qua_attendance(1).attribute5);

Line 1862: hr_transaction_api.set_varchar2_value

1858: ,p_person_id => p_creator_person_id
1859: ,p_name => 'P_PEA_ATTRIBUTE5'
1860: ,p_value => p_qua_attendance(1).attribute5);
1861:
1862: hr_transaction_api.set_varchar2_value
1863: (p_transaction_step_id => p_transaction_step_id
1864: ,p_person_id => p_creator_person_id
1865: ,p_name => 'P_PEA_ATTRIBUTE6'
1866: ,p_value => p_qua_attendance(1).attribute6);

Line 1868: hr_transaction_api.set_varchar2_value

1864: ,p_person_id => p_creator_person_id
1865: ,p_name => 'P_PEA_ATTRIBUTE6'
1866: ,p_value => p_qua_attendance(1).attribute6);
1867:
1868: hr_transaction_api.set_varchar2_value
1869: (p_transaction_step_id => p_transaction_step_id
1870: ,p_person_id => p_creator_person_id
1871: ,p_name => 'P_PEA_ATTRIBUTE7'
1872: ,p_value => p_qua_attendance(1).attribute7);

Line 1874: hr_transaction_api.set_varchar2_value

1870: ,p_person_id => p_creator_person_id
1871: ,p_name => 'P_PEA_ATTRIBUTE7'
1872: ,p_value => p_qua_attendance(1).attribute7);
1873:
1874: hr_transaction_api.set_varchar2_value
1875: (p_transaction_step_id => p_transaction_step_id
1876: ,p_person_id => p_creator_person_id
1877: ,p_name => 'P_PEA_ATTRIBUTE8'
1878: ,p_value => p_qua_attendance(1).attribute8);

Line 1880: hr_transaction_api.set_varchar2_value

1876: ,p_person_id => p_creator_person_id
1877: ,p_name => 'P_PEA_ATTRIBUTE8'
1878: ,p_value => p_qua_attendance(1).attribute8);
1879:
1880: hr_transaction_api.set_varchar2_value
1881: (p_transaction_step_id => p_transaction_step_id
1882: ,p_person_id => p_creator_person_id
1883: ,p_name => 'P_PEA_ATTRIBUTE9'
1884: ,p_value => p_qua_attendance(1).attribute9);

Line 1886: hr_transaction_api.set_varchar2_value

1882: ,p_person_id => p_creator_person_id
1883: ,p_name => 'P_PEA_ATTRIBUTE9'
1884: ,p_value => p_qua_attendance(1).attribute9);
1885:
1886: hr_transaction_api.set_varchar2_value
1887: (p_transaction_step_id => p_transaction_step_id
1888: ,p_person_id => p_creator_person_id
1889: ,p_name => 'P_PEA_ATTRIBUTE10'
1890: ,p_value => p_qua_attendance(1).attribute10);

Line 1892: hr_transaction_api.set_varchar2_value

1888: ,p_person_id => p_creator_person_id
1889: ,p_name => 'P_PEA_ATTRIBUTE10'
1890: ,p_value => p_qua_attendance(1).attribute10);
1891:
1892: hr_transaction_api.set_varchar2_value
1893: (p_transaction_step_id => p_transaction_step_id
1894: ,p_person_id => p_creator_person_id
1895: ,p_name => 'P_PEA_ATTRIBUTE11'
1896: ,p_value => p_qua_attendance(1).attribute11);

Line 1898: hr_transaction_api.set_varchar2_value

1894: ,p_person_id => p_creator_person_id
1895: ,p_name => 'P_PEA_ATTRIBUTE11'
1896: ,p_value => p_qua_attendance(1).attribute11);
1897:
1898: hr_transaction_api.set_varchar2_value
1899: (p_transaction_step_id => p_transaction_step_id
1900: ,p_person_id => p_creator_person_id
1901: ,p_name => 'P_PEA_ATTRIBUTE12'
1902: ,p_value => p_qua_attendance(1).attribute12);

Line 1904: hr_transaction_api.set_varchar2_value

1900: ,p_person_id => p_creator_person_id
1901: ,p_name => 'P_PEA_ATTRIBUTE12'
1902: ,p_value => p_qua_attendance(1).attribute12);
1903:
1904: hr_transaction_api.set_varchar2_value
1905: (p_transaction_step_id => p_transaction_step_id
1906: ,p_person_id => p_creator_person_id
1907: ,p_name => 'P_PEA_ATTRIBUTE13'
1908: ,p_value => p_qua_attendance(1).attribute13);

Line 1910: hr_transaction_api.set_varchar2_value

1906: ,p_person_id => p_creator_person_id
1907: ,p_name => 'P_PEA_ATTRIBUTE13'
1908: ,p_value => p_qua_attendance(1).attribute13);
1909:
1910: hr_transaction_api.set_varchar2_value
1911: (p_transaction_step_id => p_transaction_step_id
1912: ,p_person_id => p_creator_person_id
1913: ,p_name => 'P_PEA_ATTRIBUTE14'
1914: ,p_value => p_qua_attendance(1).attribute14);

Line 1916: hr_transaction_api.set_varchar2_value

1912: ,p_person_id => p_creator_person_id
1913: ,p_name => 'P_PEA_ATTRIBUTE14'
1914: ,p_value => p_qua_attendance(1).attribute14);
1915:
1916: hr_transaction_api.set_varchar2_value
1917: (p_transaction_step_id => p_transaction_step_id
1918: ,p_person_id => p_creator_person_id
1919: ,p_name => 'P_PEA_ATTRIBUTE15'
1920: ,p_value => p_qua_attendance(1).attribute15);

Line 1922: hr_transaction_api.set_varchar2_value

1918: ,p_person_id => p_creator_person_id
1919: ,p_name => 'P_PEA_ATTRIBUTE15'
1920: ,p_value => p_qua_attendance(1).attribute15);
1921:
1922: hr_transaction_api.set_varchar2_value
1923: (p_transaction_step_id => p_transaction_step_id
1924: ,p_person_id => p_creator_person_id
1925: ,p_name => 'P_PEA_ATTRIBUTE16'
1926: ,p_value => p_qua_attendance(1).attribute16);

Line 1928: hr_transaction_api.set_varchar2_value

1924: ,p_person_id => p_creator_person_id
1925: ,p_name => 'P_PEA_ATTRIBUTE16'
1926: ,p_value => p_qua_attendance(1).attribute16);
1927:
1928: hr_transaction_api.set_varchar2_value
1929: (p_transaction_step_id => p_transaction_step_id
1930: ,p_person_id => p_creator_person_id
1931: ,p_name => 'P_PEA_ATTRIBUTE17'
1932: ,p_value => p_qua_attendance(1).attribute17);

Line 1934: hr_transaction_api.set_varchar2_value

1930: ,p_person_id => p_creator_person_id
1931: ,p_name => 'P_PEA_ATTRIBUTE17'
1932: ,p_value => p_qua_attendance(1).attribute17);
1933:
1934: hr_transaction_api.set_varchar2_value
1935: (p_transaction_step_id => p_transaction_step_id
1936: ,p_person_id => p_creator_person_id
1937: ,p_name => 'P_PEA_ATTRIBUTE18'
1938: ,p_value => p_qua_attendance(1).attribute18);

Line 1940: hr_transaction_api.set_varchar2_value

1936: ,p_person_id => p_creator_person_id
1937: ,p_name => 'P_PEA_ATTRIBUTE18'
1938: ,p_value => p_qua_attendance(1).attribute18);
1939:
1940: hr_transaction_api.set_varchar2_value
1941: (p_transaction_step_id => p_transaction_step_id
1942: ,p_person_id => p_creator_person_id
1943: ,p_name => 'P_PEA_ATTRIBUTE19'
1944: ,p_value => p_qua_attendance(1).attribute19);

Line 1946: hr_transaction_api.set_varchar2_value

1942: ,p_person_id => p_creator_person_id
1943: ,p_name => 'P_PEA_ATTRIBUTE19'
1944: ,p_value => p_qua_attendance(1).attribute19);
1945:
1946: hr_transaction_api.set_varchar2_value
1947: (p_transaction_step_id => p_transaction_step_id
1948: ,p_person_id => p_creator_person_id
1949: ,p_name => 'P_PEA_ATTRIBUTE20'
1950: ,p_value => p_qua_attendance(1).attribute20);

Line 1954: hr_transaction_api.set_varchar2_value

1950: ,p_value => p_qua_attendance(1).attribute20);
1951:
1952: l_subject_count := NVL(p_qua_subjects.count,0);
1953:
1954: hr_transaction_api.set_varchar2_value
1955: (p_transaction_step_id => p_transaction_step_id
1956: ,p_person_id => p_creator_person_id
1957: ,p_name => 'P_SUBJECT_COUNT'
1958: ,p_value => l_subject_count);

Line 1963: hr_transaction_api.set_varchar2_value

1959:
1960: hr_utility.set_location('Entering For Loop:'||l_proc,10);
1961: FOR i IN 1..l_subject_count LOOP
1962:
1963: hr_transaction_api.set_varchar2_value
1964: (p_transaction_step_id => p_transaction_step_id
1965: ,p_person_id => p_creator_person_id
1966: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i
1967: ,p_value => p_qua_subjects(i).subjects_taken_id);

Line 1969: hr_transaction_api.set_varchar2_value

1965: ,p_person_id => p_creator_person_id
1966: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i
1967: ,p_value => p_qua_subjects(i).subjects_taken_id);
1968:
1969: hr_transaction_api.set_varchar2_value
1970: (p_transaction_step_id => p_transaction_step_id
1971: ,p_person_id => p_creator_person_id
1972: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i
1973: ,p_value => p_qua_subjects(i).object_version_number);

Line 1975: hr_transaction_api.set_varchar2_value

1971: ,p_person_id => p_creator_person_id
1972: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i
1973: ,p_value => p_qua_subjects(i).object_version_number);
1974:
1975: hr_transaction_api.set_varchar2_value
1976: (p_transaction_step_id => p_transaction_step_id
1977: ,p_person_id => p_creator_person_id
1978: ,p_name => 'P_PST_SUBJECT'||i
1979: ,p_value => p_qua_subjects(i).subject);

Line 1981: hr_transaction_api.set_varchar2_value

1977: ,p_person_id => p_creator_person_id
1978: ,p_name => 'P_PST_SUBJECT'||i
1979: ,p_value => p_qua_subjects(i).subject);
1980:
1981: hr_transaction_api.set_varchar2_value
1982: (p_transaction_step_id => p_transaction_step_id
1983: ,p_person_id => p_creator_person_id
1984: ,p_name => 'P_PST_MAJOR'||i
1985: ,p_value => p_qua_subjects(i).major);

Line 1987: hr_transaction_api.set_date_value

1983: ,p_person_id => p_creator_person_id
1984: ,p_name => 'P_PST_MAJOR'||i
1985: ,p_value => p_qua_subjects(i).major);
1986:
1987: hr_transaction_api.set_date_value
1988: (p_transaction_step_id => p_transaction_step_id
1989: ,p_person_id => p_creator_person_id
1990: ,p_name => 'P_PST_START_DATE'||i
1991: ,p_value => p_qua_subjects(i).start_date);

Line 1993: hr_transaction_api.set_date_value

1989: ,p_person_id => p_creator_person_id
1990: ,p_name => 'P_PST_START_DATE'||i
1991: ,p_value => p_qua_subjects(i).start_date);
1992:
1993: hr_transaction_api.set_date_value
1994: (p_transaction_step_id => p_transaction_step_id
1995: ,p_person_id => p_creator_person_id
1996: ,p_name => 'P_PST_END_DATE'||i
1997: ,p_value => p_qua_subjects(i).end_date);

Line 1999: hr_transaction_api.set_varchar2_value

1995: ,p_person_id => p_creator_person_id
1996: ,p_name => 'P_PST_END_DATE'||i
1997: ,p_value => p_qua_subjects(i).end_date);
1998:
1999: hr_transaction_api.set_varchar2_value
2000: (p_transaction_step_id => p_transaction_step_id
2001: ,p_person_id => p_creator_person_id
2002: ,p_name => 'P_PST_SUBJECT_STATUS'||i
2003: ,p_value => p_qua_subjects(i).subject_status);

Line 2005: hr_transaction_api.set_varchar2_value

2001: ,p_person_id => p_creator_person_id
2002: ,p_name => 'P_PST_SUBJECT_STATUS'||i
2003: ,p_value => p_qua_subjects(i).subject_status);
2004:
2005: hr_transaction_api.set_varchar2_value
2006: (p_transaction_step_id => p_transaction_step_id
2007: ,p_person_id => p_creator_person_id
2008: ,p_name => 'P_PST_GRADE_ATTAINED'||i
2009: ,p_value => p_qua_subjects(i).grade_attained);

Line 2011: hr_transaction_api.set_varchar2_value

2007: ,p_person_id => p_creator_person_id
2008: ,p_name => 'P_PST_GRADE_ATTAINED'||i
2009: ,p_value => p_qua_subjects(i).grade_attained);
2010:
2011: hr_transaction_api.set_varchar2_value
2012: (p_transaction_step_id => p_transaction_step_id
2013: ,p_person_id => p_creator_person_id
2014: ,p_name => 'P_PST_DELETE_FLAG'||i
2015: ,p_value => p_qua_subjects(i).delete_flag);

Line 2017: hr_transaction_api.set_varchar2_value

2013: ,p_person_id => p_creator_person_id
2014: ,p_name => 'P_PST_DELETE_FLAG'||i
2015: ,p_value => p_qua_subjects(i).delete_flag);
2016:
2017: hr_transaction_api.set_varchar2_value
2018: (p_transaction_step_id => p_transaction_step_id
2019: ,p_person_id => p_creator_person_id
2020: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i
2021: ,p_value => p_qua_subjects(i).attribute_category);

Line 2023: hr_transaction_api.set_varchar2_value

2019: ,p_person_id => p_creator_person_id
2020: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i
2021: ,p_value => p_qua_subjects(i).attribute_category);
2022:
2023: hr_transaction_api.set_varchar2_value
2024: (p_transaction_step_id => p_transaction_step_id
2025: ,p_person_id => p_creator_person_id
2026: ,p_name => 'P_ATTRIBUTE1_PST'||i
2027: ,p_value => p_qua_subjects(i).attribute1);

Line 2029: hr_transaction_api.set_varchar2_value

2025: ,p_person_id => p_creator_person_id
2026: ,p_name => 'P_ATTRIBUTE1_PST'||i
2027: ,p_value => p_qua_subjects(i).attribute1);
2028:
2029: hr_transaction_api.set_varchar2_value
2030: (p_transaction_step_id => p_transaction_step_id
2031: ,p_person_id => p_creator_person_id
2032: ,p_name => 'P_ATTRIBUTE2_PST'||i
2033: ,p_value => p_qua_subjects(i).attribute2);

Line 2034: hr_transaction_api.set_varchar2_value

2030: (p_transaction_step_id => p_transaction_step_id
2031: ,p_person_id => p_creator_person_id
2032: ,p_name => 'P_ATTRIBUTE2_PST'||i
2033: ,p_value => p_qua_subjects(i).attribute2);
2034: hr_transaction_api.set_varchar2_value
2035: (p_transaction_step_id => p_transaction_step_id
2036: ,p_person_id => p_creator_person_id
2037: ,p_name => 'P_ATTRIBUTE3_PST'||i
2038: ,p_value => p_qua_subjects(i).attribute3);

Line 2039: hr_transaction_api.set_varchar2_value

2035: (p_transaction_step_id => p_transaction_step_id
2036: ,p_person_id => p_creator_person_id
2037: ,p_name => 'P_ATTRIBUTE3_PST'||i
2038: ,p_value => p_qua_subjects(i).attribute3);
2039: hr_transaction_api.set_varchar2_value
2040: (p_transaction_step_id => p_transaction_step_id
2041: ,p_person_id => p_creator_person_id
2042: ,p_name => 'P_ATTRIBUTE4_PST'||i
2043: ,p_value => p_qua_subjects(i).attribute4);

Line 2044: hr_transaction_api.set_varchar2_value

2040: (p_transaction_step_id => p_transaction_step_id
2041: ,p_person_id => p_creator_person_id
2042: ,p_name => 'P_ATTRIBUTE4_PST'||i
2043: ,p_value => p_qua_subjects(i).attribute4);
2044: hr_transaction_api.set_varchar2_value
2045: (p_transaction_step_id => p_transaction_step_id
2046: ,p_person_id => p_creator_person_id
2047: ,p_name => 'P_ATTRIBUTE5_PST'||i
2048: ,p_value => p_qua_subjects(i).attribute5);

Line 2049: hr_transaction_api.set_varchar2_value

2045: (p_transaction_step_id => p_transaction_step_id
2046: ,p_person_id => p_creator_person_id
2047: ,p_name => 'P_ATTRIBUTE5_PST'||i
2048: ,p_value => p_qua_subjects(i).attribute5);
2049: hr_transaction_api.set_varchar2_value
2050: (p_transaction_step_id => p_transaction_step_id
2051: ,p_person_id => p_creator_person_id
2052: ,p_name => 'P_ATTRIBUTE6_PST'||i
2053: ,p_value => p_qua_subjects(i).attribute6);

Line 2054: hr_transaction_api.set_varchar2_value

2050: (p_transaction_step_id => p_transaction_step_id
2051: ,p_person_id => p_creator_person_id
2052: ,p_name => 'P_ATTRIBUTE6_PST'||i
2053: ,p_value => p_qua_subjects(i).attribute6);
2054: hr_transaction_api.set_varchar2_value
2055: (p_transaction_step_id => p_transaction_step_id
2056: ,p_person_id => p_creator_person_id
2057: ,p_name => 'P_ATTRIBUTE7_PST'||i
2058: ,p_value => p_qua_subjects(i).attribute7);

Line 2059: hr_transaction_api.set_varchar2_value

2055: (p_transaction_step_id => p_transaction_step_id
2056: ,p_person_id => p_creator_person_id
2057: ,p_name => 'P_ATTRIBUTE7_PST'||i
2058: ,p_value => p_qua_subjects(i).attribute7);
2059: hr_transaction_api.set_varchar2_value
2060: (p_transaction_step_id => p_transaction_step_id
2061: ,p_person_id => p_creator_person_id
2062: ,p_name => 'P_ATTRIBUTE8_PST'||i
2063: ,p_value => p_qua_subjects(i).attribute8);

Line 2064: hr_transaction_api.set_varchar2_value

2060: (p_transaction_step_id => p_transaction_step_id
2061: ,p_person_id => p_creator_person_id
2062: ,p_name => 'P_ATTRIBUTE8_PST'||i
2063: ,p_value => p_qua_subjects(i).attribute8);
2064: hr_transaction_api.set_varchar2_value
2065: (p_transaction_step_id => p_transaction_step_id
2066: ,p_person_id => p_creator_person_id
2067: ,p_name => 'P_ATTRIBUTE9_PST'||i
2068: ,p_value => p_qua_subjects(i).attribute9);

Line 2069: hr_transaction_api.set_varchar2_value

2065: (p_transaction_step_id => p_transaction_step_id
2066: ,p_person_id => p_creator_person_id
2067: ,p_name => 'P_ATTRIBUTE9_PST'||i
2068: ,p_value => p_qua_subjects(i).attribute9);
2069: hr_transaction_api.set_varchar2_value
2070: (p_transaction_step_id => p_transaction_step_id
2071: ,p_person_id => p_creator_person_id
2072: ,p_name => 'P_ATTRIBUTE10_PST'||i
2073: ,p_value => p_qua_subjects(i).attribute10);

Line 2074: hr_transaction_api.set_varchar2_value

2070: (p_transaction_step_id => p_transaction_step_id
2071: ,p_person_id => p_creator_person_id
2072: ,p_name => 'P_ATTRIBUTE10_PST'||i
2073: ,p_value => p_qua_subjects(i).attribute10);
2074: hr_transaction_api.set_varchar2_value
2075: (p_transaction_step_id => p_transaction_step_id
2076: ,p_person_id => p_creator_person_id
2077: ,p_name => 'P_ATTRIBUTE11_PST'||i
2078: ,p_value => p_qua_subjects(i).attribute11);

Line 2079: hr_transaction_api.set_varchar2_value

2075: (p_transaction_step_id => p_transaction_step_id
2076: ,p_person_id => p_creator_person_id
2077: ,p_name => 'P_ATTRIBUTE11_PST'||i
2078: ,p_value => p_qua_subjects(i).attribute11);
2079: hr_transaction_api.set_varchar2_value
2080: (p_transaction_step_id => p_transaction_step_id
2081: ,p_person_id => p_creator_person_id
2082: ,p_name => 'P_ATTRIBUTE12_PST'||i
2083: ,p_value => p_qua_subjects(i).attribute12);

Line 2084: hr_transaction_api.set_varchar2_value

2080: (p_transaction_step_id => p_transaction_step_id
2081: ,p_person_id => p_creator_person_id
2082: ,p_name => 'P_ATTRIBUTE12_PST'||i
2083: ,p_value => p_qua_subjects(i).attribute12);
2084: hr_transaction_api.set_varchar2_value
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_person_id => p_creator_person_id
2087: ,p_name => 'P_ATTRIBUTE13_PST'||i
2088: ,p_value => p_qua_subjects(i).attribute13);

Line 2089: hr_transaction_api.set_varchar2_value

2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_person_id => p_creator_person_id
2087: ,p_name => 'P_ATTRIBUTE13_PST'||i
2088: ,p_value => p_qua_subjects(i).attribute13);
2089: hr_transaction_api.set_varchar2_value
2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_person_id => p_creator_person_id
2092: ,p_name => 'P_ATTRIBUTE14_PST'||i
2093: ,p_value => p_qua_subjects(i).attribute14);

Line 2094: hr_transaction_api.set_varchar2_value

2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_person_id => p_creator_person_id
2092: ,p_name => 'P_ATTRIBUTE14_PST'||i
2093: ,p_value => p_qua_subjects(i).attribute14);
2094: hr_transaction_api.set_varchar2_value
2095: (p_transaction_step_id => p_transaction_step_id
2096: ,p_person_id => p_creator_person_id
2097: ,p_name => 'P_ATTRIBUTE15_PST'||i
2098: ,p_value => p_qua_subjects(i).attribute15);

Line 2099: hr_transaction_api.set_varchar2_value

2095: (p_transaction_step_id => p_transaction_step_id
2096: ,p_person_id => p_creator_person_id
2097: ,p_name => 'P_ATTRIBUTE15_PST'||i
2098: ,p_value => p_qua_subjects(i).attribute15);
2099: hr_transaction_api.set_varchar2_value
2100: (p_transaction_step_id => p_transaction_step_id
2101: ,p_person_id => p_creator_person_id
2102: ,p_name => 'P_ATTRIBUTE16_PST'||i
2103: ,p_value => p_qua_subjects(i).attribute16);

Line 2104: hr_transaction_api.set_varchar2_value

2100: (p_transaction_step_id => p_transaction_step_id
2101: ,p_person_id => p_creator_person_id
2102: ,p_name => 'P_ATTRIBUTE16_PST'||i
2103: ,p_value => p_qua_subjects(i).attribute16);
2104: hr_transaction_api.set_varchar2_value
2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_person_id => p_creator_person_id
2107: ,p_name => 'P_ATTRIBUTE17_PST'||i
2108: ,p_value => p_qua_subjects(i).attribute17);

Line 2109: hr_transaction_api.set_varchar2_value

2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_person_id => p_creator_person_id
2107: ,p_name => 'P_ATTRIBUTE17_PST'||i
2108: ,p_value => p_qua_subjects(i).attribute17);
2109: hr_transaction_api.set_varchar2_value
2110: (p_transaction_step_id => p_transaction_step_id
2111: ,p_person_id => p_creator_person_id
2112: ,p_name => 'P_ATTRIBUTE18_PST'||i
2113: ,p_value => p_qua_subjects(i).attribute18);

Line 2114: hr_transaction_api.set_varchar2_value

2110: (p_transaction_step_id => p_transaction_step_id
2111: ,p_person_id => p_creator_person_id
2112: ,p_name => 'P_ATTRIBUTE18_PST'||i
2113: ,p_value => p_qua_subjects(i).attribute18);
2114: hr_transaction_api.set_varchar2_value
2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_person_id => p_creator_person_id
2117: ,p_name => 'P_ATTRIBUTE19_PST'||i
2118: ,p_value => p_qua_subjects(i).attribute19);

Line 2119: hr_transaction_api.set_varchar2_value

2115: (p_transaction_step_id => p_transaction_step_id
2116: ,p_person_id => p_creator_person_id
2117: ,p_name => 'P_ATTRIBUTE19_PST'||i
2118: ,p_value => p_qua_subjects(i).attribute19);
2119: hr_transaction_api.set_varchar2_value
2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_person_id => p_creator_person_id
2122: ,p_name => 'P_ATTRIBUTE20_PST'||i
2123: ,p_value => p_qua_subjects(i).attribute20);

Line 2124: hr_transaction_api.set_varchar2_value

2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_person_id => p_creator_person_id
2122: ,p_name => 'P_ATTRIBUTE20_PST'||i
2123: ,p_value => p_qua_subjects(i).attribute20);
2124: hr_transaction_api.set_varchar2_value
2125: (p_transaction_step_id => p_transaction_step_id
2126: ,p_person_id => p_creator_person_id
2127: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i
2128: ,p_value => p_qua_subjects(i).sub_information_category);

Line 2129: hr_transaction_api.set_varchar2_value

2125: (p_transaction_step_id => p_transaction_step_id
2126: ,p_person_id => p_creator_person_id
2127: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i
2128: ,p_value => p_qua_subjects(i).sub_information_category);
2129: hr_transaction_api.set_varchar2_value
2130: (p_transaction_step_id => p_transaction_step_id
2131: ,p_person_id => p_creator_person_id
2132: ,p_name => 'P_SUB_INFORMATION1_PST'||i
2133: ,p_value => p_qua_subjects(i).sub_information1);

Line 2134: hr_transaction_api.set_varchar2_value

2130: (p_transaction_step_id => p_transaction_step_id
2131: ,p_person_id => p_creator_person_id
2132: ,p_name => 'P_SUB_INFORMATION1_PST'||i
2133: ,p_value => p_qua_subjects(i).sub_information1);
2134: hr_transaction_api.set_varchar2_value
2135: (p_transaction_step_id => p_transaction_step_id
2136: ,p_person_id => p_creator_person_id
2137: ,p_name => 'P_SUB_INFORMATION2_PST'||i
2138: ,p_value => p_qua_subjects(i).sub_information2);

Line 2139: hr_transaction_api.set_varchar2_value

2135: (p_transaction_step_id => p_transaction_step_id
2136: ,p_person_id => p_creator_person_id
2137: ,p_name => 'P_SUB_INFORMATION2_PST'||i
2138: ,p_value => p_qua_subjects(i).sub_information2);
2139: hr_transaction_api.set_varchar2_value
2140: (p_transaction_step_id => p_transaction_step_id
2141: ,p_person_id => p_creator_person_id
2142: ,p_name => 'P_SUB_INFORMATION3_PST'||i
2143: ,p_value => p_qua_subjects(i).sub_information3);

Line 2144: hr_transaction_api.set_varchar2_value

2140: (p_transaction_step_id => p_transaction_step_id
2141: ,p_person_id => p_creator_person_id
2142: ,p_name => 'P_SUB_INFORMATION3_PST'||i
2143: ,p_value => p_qua_subjects(i).sub_information3);
2144: hr_transaction_api.set_varchar2_value
2145: (p_transaction_step_id => p_transaction_step_id
2146: ,p_person_id => p_creator_person_id
2147: ,p_name => 'P_SUB_INFORMATION4_PST'||i
2148: ,p_value => p_qua_subjects(i).sub_information4);

Line 2149: hr_transaction_api.set_varchar2_value

2145: (p_transaction_step_id => p_transaction_step_id
2146: ,p_person_id => p_creator_person_id
2147: ,p_name => 'P_SUB_INFORMATION4_PST'||i
2148: ,p_value => p_qua_subjects(i).sub_information4);
2149: hr_transaction_api.set_varchar2_value
2150: (p_transaction_step_id => p_transaction_step_id
2151: ,p_person_id => p_creator_person_id
2152: ,p_name => 'P_SUB_INFORMATION5_PST'||i
2153: ,p_value => p_qua_subjects(i).sub_information5);

Line 2154: hr_transaction_api.set_varchar2_value

2150: (p_transaction_step_id => p_transaction_step_id
2151: ,p_person_id => p_creator_person_id
2152: ,p_name => 'P_SUB_INFORMATION5_PST'||i
2153: ,p_value => p_qua_subjects(i).sub_information5);
2154: hr_transaction_api.set_varchar2_value
2155: (p_transaction_step_id => p_transaction_step_id
2156: ,p_person_id => p_creator_person_id
2157: ,p_name => 'P_SUB_INFORMATION6_PST'||i
2158: ,p_value => p_qua_subjects(i).sub_information6);

Line 2159: hr_transaction_api.set_varchar2_value

2155: (p_transaction_step_id => p_transaction_step_id
2156: ,p_person_id => p_creator_person_id
2157: ,p_name => 'P_SUB_INFORMATION6_PST'||i
2158: ,p_value => p_qua_subjects(i).sub_information6);
2159: hr_transaction_api.set_varchar2_value
2160: (p_transaction_step_id => p_transaction_step_id
2161: ,p_person_id => p_creator_person_id
2162: ,p_name => 'P_SUB_INFORMATION7_PST'||i
2163: ,p_value => p_qua_subjects(i).sub_information7);

Line 2164: hr_transaction_api.set_varchar2_value

2160: (p_transaction_step_id => p_transaction_step_id
2161: ,p_person_id => p_creator_person_id
2162: ,p_name => 'P_SUB_INFORMATION7_PST'||i
2163: ,p_value => p_qua_subjects(i).sub_information7);
2164: hr_transaction_api.set_varchar2_value
2165: (p_transaction_step_id => p_transaction_step_id
2166: ,p_person_id => p_creator_person_id
2167: ,p_name => 'P_SUB_INFORMATION8_PST'||i
2168: ,p_value => p_qua_subjects(i).sub_information8);

Line 2169: hr_transaction_api.set_varchar2_value

2165: (p_transaction_step_id => p_transaction_step_id
2166: ,p_person_id => p_creator_person_id
2167: ,p_name => 'P_SUB_INFORMATION8_PST'||i
2168: ,p_value => p_qua_subjects(i).sub_information8);
2169: hr_transaction_api.set_varchar2_value
2170: (p_transaction_step_id => p_transaction_step_id
2171: ,p_person_id => p_creator_person_id
2172: ,p_name => 'P_SUB_INFORMATION9_PST'||i
2173: ,p_value => p_qua_subjects(i).sub_information9);

Line 2174: hr_transaction_api.set_varchar2_value

2170: (p_transaction_step_id => p_transaction_step_id
2171: ,p_person_id => p_creator_person_id
2172: ,p_name => 'P_SUB_INFORMATION9_PST'||i
2173: ,p_value => p_qua_subjects(i).sub_information9);
2174: hr_transaction_api.set_varchar2_value
2175: (p_transaction_step_id => p_transaction_step_id
2176: ,p_person_id => p_creator_person_id
2177: ,p_name => 'P_SUB_INFORMATION10_PST'||i
2178: ,p_value => p_qua_subjects(i).sub_information10);

Line 2179: hr_transaction_api.set_varchar2_value

2175: (p_transaction_step_id => p_transaction_step_id
2176: ,p_person_id => p_creator_person_id
2177: ,p_name => 'P_SUB_INFORMATION10_PST'||i
2178: ,p_value => p_qua_subjects(i).sub_information10);
2179: hr_transaction_api.set_varchar2_value
2180: (p_transaction_step_id => p_transaction_step_id
2181: ,p_person_id => p_creator_person_id
2182: ,p_name => 'P_SUB_INFORMATION11_PST'||i
2183: ,p_value => p_qua_subjects(i).sub_information11);

Line 2184: hr_transaction_api.set_varchar2_value

2180: (p_transaction_step_id => p_transaction_step_id
2181: ,p_person_id => p_creator_person_id
2182: ,p_name => 'P_SUB_INFORMATION11_PST'||i
2183: ,p_value => p_qua_subjects(i).sub_information11);
2184: hr_transaction_api.set_varchar2_value
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_person_id => p_creator_person_id
2187: ,p_name => 'P_SUB_INFORMATION12_PST'||i
2188: ,p_value => p_qua_subjects(i).sub_information12);

Line 2189: hr_transaction_api.set_varchar2_value

2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_person_id => p_creator_person_id
2187: ,p_name => 'P_SUB_INFORMATION12_PST'||i
2188: ,p_value => p_qua_subjects(i).sub_information12);
2189: hr_transaction_api.set_varchar2_value
2190: (p_transaction_step_id => p_transaction_step_id
2191: ,p_person_id => p_creator_person_id
2192: ,p_name => 'P_SUB_INFORMATION13_PST'||i
2193: ,p_value => p_qua_subjects(i).sub_information13);

Line 2194: hr_transaction_api.set_varchar2_value

2190: (p_transaction_step_id => p_transaction_step_id
2191: ,p_person_id => p_creator_person_id
2192: ,p_name => 'P_SUB_INFORMATION13_PST'||i
2193: ,p_value => p_qua_subjects(i).sub_information13);
2194: hr_transaction_api.set_varchar2_value
2195: (p_transaction_step_id => p_transaction_step_id
2196: ,p_person_id => p_creator_person_id
2197: ,p_name => 'P_SUB_INFORMATION14_PST'||i
2198: ,p_value => p_qua_subjects(i).sub_information14);

Line 2199: hr_transaction_api.set_varchar2_value

2195: (p_transaction_step_id => p_transaction_step_id
2196: ,p_person_id => p_creator_person_id
2197: ,p_name => 'P_SUB_INFORMATION14_PST'||i
2198: ,p_value => p_qua_subjects(i).sub_information14);
2199: hr_transaction_api.set_varchar2_value
2200: (p_transaction_step_id => p_transaction_step_id
2201: ,p_person_id => p_creator_person_id
2202: ,p_name => 'P_SUB_INFORMATION15_PST'||i
2203: ,p_value => p_qua_subjects(i).sub_information15);

Line 2204: hr_transaction_api.set_varchar2_value

2200: (p_transaction_step_id => p_transaction_step_id
2201: ,p_person_id => p_creator_person_id
2202: ,p_name => 'P_SUB_INFORMATION15_PST'||i
2203: ,p_value => p_qua_subjects(i).sub_information15);
2204: hr_transaction_api.set_varchar2_value
2205: (p_transaction_step_id => p_transaction_step_id
2206: ,p_person_id => p_creator_person_id
2207: ,p_name => 'P_SUB_INFORMATION16_PST'||i
2208: ,p_value => p_qua_subjects(i).sub_information16);

Line 2209: hr_transaction_api.set_varchar2_value

2205: (p_transaction_step_id => p_transaction_step_id
2206: ,p_person_id => p_creator_person_id
2207: ,p_name => 'P_SUB_INFORMATION16_PST'||i
2208: ,p_value => p_qua_subjects(i).sub_information16);
2209: hr_transaction_api.set_varchar2_value
2210: (p_transaction_step_id => p_transaction_step_id
2211: ,p_person_id => p_creator_person_id
2212: ,p_name => 'P_SUB_INFORMATION17_PST'||i
2213: ,p_value => p_qua_subjects(i).sub_information17);

Line 2214: hr_transaction_api.set_varchar2_value

2210: (p_transaction_step_id => p_transaction_step_id
2211: ,p_person_id => p_creator_person_id
2212: ,p_name => 'P_SUB_INFORMATION17_PST'||i
2213: ,p_value => p_qua_subjects(i).sub_information17);
2214: hr_transaction_api.set_varchar2_value
2215: (p_transaction_step_id => p_transaction_step_id
2216: ,p_person_id => p_creator_person_id
2217: ,p_name => 'P_SUB_INFORMATION18_PST'||i
2218: ,p_value => p_qua_subjects(i).sub_information18);

Line 2219: hr_transaction_api.set_varchar2_value

2215: (p_transaction_step_id => p_transaction_step_id
2216: ,p_person_id => p_creator_person_id
2217: ,p_name => 'P_SUB_INFORMATION18_PST'||i
2218: ,p_value => p_qua_subjects(i).sub_information18);
2219: hr_transaction_api.set_varchar2_value
2220: (p_transaction_step_id => p_transaction_step_id
2221: ,p_person_id => p_creator_person_id
2222: ,p_name => 'P_SUB_INFORMATION19_PST'||i
2223: ,p_value => p_qua_subjects(i).sub_information19);

Line 2224: hr_transaction_api.set_varchar2_value

2220: (p_transaction_step_id => p_transaction_step_id
2221: ,p_person_id => p_creator_person_id
2222: ,p_name => 'P_SUB_INFORMATION19_PST'||i
2223: ,p_value => p_qua_subjects(i).sub_information19);
2224: hr_transaction_api.set_varchar2_value
2225: (p_transaction_step_id => p_transaction_step_id
2226: ,p_person_id => p_creator_person_id
2227: ,p_name => 'P_SUB_INFORMATION20_PST'||i
2228: ,p_value => p_qua_subjects(i).sub_information20);

Line 2233: hr_transaction_api.set_varchar2_value

2229:
2230: END LOOP;
2231: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
2232:
2233: hr_transaction_api.set_varchar2_value
2234: (p_transaction_step_id => p_transaction_step_id
2235: ,p_person_id => p_creator_person_id
2236: ,p_name => 'P_REVIEW_PROC_CALL'
2237: ,p_value => p_proc_call);

Line 2239: hr_transaction_api.set_varchar2_value

2235: ,p_person_id => p_creator_person_id
2236: ,p_name => 'P_REVIEW_PROC_CALL'
2237: ,p_value => p_proc_call);
2238:
2239: hr_transaction_api.set_varchar2_value
2240: (p_transaction_step_id => p_transaction_step_id
2241: ,p_person_id => p_creator_person_id
2242: ,p_name => 'P_REVIEW_ACTID'
2243: ,p_value => p_actid);

Line 3436: hr_transaction_api.get_varchar2_value

3432: BEGIN
3433:
3434: hr_utility.set_location('Entering:'||l_proc, 5);
3435: p_mode :=
3436: hr_transaction_api.get_varchar2_value
3437: (p_transaction_step_id => p_transaction_step_id
3438: ,p_name => 'P_MODE');
3439:
3440: l_subject_count := to_number(

Line 3441: hr_transaction_api.get_varchar2_value

3437: (p_transaction_step_id => p_transaction_step_id
3438: ,p_name => 'P_MODE');
3439:
3440: l_subject_count := to_number(
3441: hr_transaction_api.get_varchar2_value
3442: (p_transaction_step_id => p_transaction_step_id
3443: ,p_name => 'P_SUBJECT_COUNT'));
3444:
3445: p_qua_attendance := SSHR_QUA_ATTENDANCE_TAB_TYP();

Line 3451: to_number(hr_transaction_api.get_varchar2_value

3447: hr_utility.set_location('Entering For Loop:'||l_proc,10);
3448: FOR i IN 1..NVL(l_attendance_count,0) LOOP
3449: p_qua_attendance.extend;
3450: p_qua_attendance(i) := SSHR_QUA_ATTENDANCE_OBJ_TYP(
3451: to_number(hr_transaction_api.get_varchar2_value
3452: (p_transaction_step_id => p_transaction_step_id
3453: ,p_name => 'P_ATTENDANCE_ID')),
3454: hr_transaction_api.get_date_value
3455: (p_transaction_step_id => p_transaction_step_id

Line 3454: hr_transaction_api.get_date_value

3450: p_qua_attendance(i) := SSHR_QUA_ATTENDANCE_OBJ_TYP(
3451: to_number(hr_transaction_api.get_varchar2_value
3452: (p_transaction_step_id => p_transaction_step_id
3453: ,p_name => 'P_ATTENDANCE_ID')),
3454: hr_transaction_api.get_date_value
3455: (p_transaction_step_id => p_transaction_step_id
3456: ,p_name => 'P_PEA_START_DATE'),
3457: to_number(hr_transaction_api.get_varchar2_value
3458: (p_transaction_step_id => p_transaction_step_id

Line 3457: to_number(hr_transaction_api.get_varchar2_value

3453: ,p_name => 'P_ATTENDANCE_ID')),
3454: hr_transaction_api.get_date_value
3455: (p_transaction_step_id => p_transaction_step_id
3456: ,p_name => 'P_PEA_START_DATE'),
3457: to_number(hr_transaction_api.get_varchar2_value
3458: (p_transaction_step_id => p_transaction_step_id
3459: ,p_name => 'P_PEA_PERSON_ID')),
3460: hr_transaction_api.get_varchar2_value
3461: (p_transaction_step_id => p_transaction_step_id

Line 3460: hr_transaction_api.get_varchar2_value

3456: ,p_name => 'P_PEA_START_DATE'),
3457: to_number(hr_transaction_api.get_varchar2_value
3458: (p_transaction_step_id => p_transaction_step_id
3459: ,p_name => 'P_PEA_PERSON_ID')),
3460: hr_transaction_api.get_varchar2_value
3461: (p_transaction_step_id => p_transaction_step_id
3462: ,p_name => 'P_PEA_FULL_TIME'),
3463: hr_transaction_api.get_date_value
3464: (p_transaction_step_id => p_transaction_step_id

Line 3463: hr_transaction_api.get_date_value

3459: ,p_name => 'P_PEA_PERSON_ID')),
3460: hr_transaction_api.get_varchar2_value
3461: (p_transaction_step_id => p_transaction_step_id
3462: ,p_name => 'P_PEA_FULL_TIME'),
3463: hr_transaction_api.get_date_value
3464: (p_transaction_step_id => p_transaction_step_id
3465: ,p_name => 'P_PEA_END_DATE'),
3466: to_number(hr_transaction_api.get_varchar2_value
3467: (p_transaction_step_id => p_transaction_step_id

Line 3466: to_number(hr_transaction_api.get_varchar2_value

3462: ,p_name => 'P_PEA_FULL_TIME'),
3463: hr_transaction_api.get_date_value
3464: (p_transaction_step_id => p_transaction_step_id
3465: ,p_name => 'P_PEA_END_DATE'),
3466: to_number(hr_transaction_api.get_varchar2_value
3467: (p_transaction_step_id => p_transaction_step_id
3468: ,p_name => 'P_ESTABLISHMENT_ID')),
3469: to_number(hr_transaction_api.get_varchar2_value
3470: (p_transaction_step_id => p_transaction_step_id

Line 3469: to_number(hr_transaction_api.get_varchar2_value

3465: ,p_name => 'P_PEA_END_DATE'),
3466: to_number(hr_transaction_api.get_varchar2_value
3467: (p_transaction_step_id => p_transaction_step_id
3468: ,p_name => 'P_ESTABLISHMENT_ID')),
3469: to_number(hr_transaction_api.get_varchar2_value
3470: (p_transaction_step_id => p_transaction_step_id
3471: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER')),
3472: hr_transaction_api.get_varchar2_value
3473: (p_transaction_step_id => p_transaction_step_id

Line 3472: hr_transaction_api.get_varchar2_value

3468: ,p_name => 'P_ESTABLISHMENT_ID')),
3469: to_number(hr_transaction_api.get_varchar2_value
3470: (p_transaction_step_id => p_transaction_step_id
3471: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER')),
3472: hr_transaction_api.get_varchar2_value
3473: (p_transaction_step_id => p_transaction_step_id
3474: ,p_name => 'P_BUSINESS_GROUP_ID'),
3475: hr_transaction_api.get_varchar2_value
3476: (p_transaction_step_id => p_transaction_step_id

Line 3475: hr_transaction_api.get_varchar2_value

3471: ,p_name => 'P_PEA_OBJECT_VERSION_NUMBER')),
3472: hr_transaction_api.get_varchar2_value
3473: (p_transaction_step_id => p_transaction_step_id
3474: ,p_name => 'P_BUSINESS_GROUP_ID'),
3475: hr_transaction_api.get_varchar2_value
3476: (p_transaction_step_id => p_transaction_step_id
3477: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'),
3478: hr_transaction_api.get_varchar2_value
3479: (p_transaction_step_id => p_transaction_step_id

Line 3478: hr_transaction_api.get_varchar2_value

3474: ,p_name => 'P_BUSINESS_GROUP_ID'),
3475: hr_transaction_api.get_varchar2_value
3476: (p_transaction_step_id => p_transaction_step_id
3477: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'),
3478: hr_transaction_api.get_varchar2_value
3479: (p_transaction_step_id => p_transaction_step_id
3480: ,p_name => 'P_PEA_ATTRIBUTE1'),
3481: hr_transaction_api.get_varchar2_value
3482: (p_transaction_step_id => p_transaction_step_id

Line 3481: hr_transaction_api.get_varchar2_value

3477: ,p_name => 'P_PEA_ATTRIBUTE_CATEGORY'),
3478: hr_transaction_api.get_varchar2_value
3479: (p_transaction_step_id => p_transaction_step_id
3480: ,p_name => 'P_PEA_ATTRIBUTE1'),
3481: hr_transaction_api.get_varchar2_value
3482: (p_transaction_step_id => p_transaction_step_id
3483: ,p_name => 'P_PEA_ATTRIBUTE2'),
3484: hr_transaction_api.get_varchar2_value
3485: (p_transaction_step_id => p_transaction_step_id

Line 3484: hr_transaction_api.get_varchar2_value

3480: ,p_name => 'P_PEA_ATTRIBUTE1'),
3481: hr_transaction_api.get_varchar2_value
3482: (p_transaction_step_id => p_transaction_step_id
3483: ,p_name => 'P_PEA_ATTRIBUTE2'),
3484: hr_transaction_api.get_varchar2_value
3485: (p_transaction_step_id => p_transaction_step_id
3486: ,p_name => 'P_PEA_ATTRIBUTE3'),
3487: hr_transaction_api.get_varchar2_value
3488: (p_transaction_step_id => p_transaction_step_id

Line 3487: hr_transaction_api.get_varchar2_value

3483: ,p_name => 'P_PEA_ATTRIBUTE2'),
3484: hr_transaction_api.get_varchar2_value
3485: (p_transaction_step_id => p_transaction_step_id
3486: ,p_name => 'P_PEA_ATTRIBUTE3'),
3487: hr_transaction_api.get_varchar2_value
3488: (p_transaction_step_id => p_transaction_step_id
3489: ,p_name => 'P_PEA_ATTRIBUTE4'),
3490: hr_transaction_api.get_varchar2_value
3491: (p_transaction_step_id => p_transaction_step_id

Line 3490: hr_transaction_api.get_varchar2_value

3486: ,p_name => 'P_PEA_ATTRIBUTE3'),
3487: hr_transaction_api.get_varchar2_value
3488: (p_transaction_step_id => p_transaction_step_id
3489: ,p_name => 'P_PEA_ATTRIBUTE4'),
3490: hr_transaction_api.get_varchar2_value
3491: (p_transaction_step_id => p_transaction_step_id
3492: ,p_name => 'P_PEA_ATTRIBUTE5'),
3493: hr_transaction_api.get_varchar2_value
3494: (p_transaction_step_id => p_transaction_step_id

Line 3493: hr_transaction_api.get_varchar2_value

3489: ,p_name => 'P_PEA_ATTRIBUTE4'),
3490: hr_transaction_api.get_varchar2_value
3491: (p_transaction_step_id => p_transaction_step_id
3492: ,p_name => 'P_PEA_ATTRIBUTE5'),
3493: hr_transaction_api.get_varchar2_value
3494: (p_transaction_step_id => p_transaction_step_id
3495: ,p_name => 'P_PEA_ATTRIBUTE6'),
3496: hr_transaction_api.get_varchar2_value
3497: (p_transaction_step_id => p_transaction_step_id

Line 3496: hr_transaction_api.get_varchar2_value

3492: ,p_name => 'P_PEA_ATTRIBUTE5'),
3493: hr_transaction_api.get_varchar2_value
3494: (p_transaction_step_id => p_transaction_step_id
3495: ,p_name => 'P_PEA_ATTRIBUTE6'),
3496: hr_transaction_api.get_varchar2_value
3497: (p_transaction_step_id => p_transaction_step_id
3498: ,p_name => 'P_PEA_ATTRIBUTE7'),
3499: hr_transaction_api.get_varchar2_value
3500: (p_transaction_step_id => p_transaction_step_id

Line 3499: hr_transaction_api.get_varchar2_value

3495: ,p_name => 'P_PEA_ATTRIBUTE6'),
3496: hr_transaction_api.get_varchar2_value
3497: (p_transaction_step_id => p_transaction_step_id
3498: ,p_name => 'P_PEA_ATTRIBUTE7'),
3499: hr_transaction_api.get_varchar2_value
3500: (p_transaction_step_id => p_transaction_step_id
3501: ,p_name => 'P_PEA_ATTRIBUTE8'),
3502: hr_transaction_api.get_varchar2_value
3503: (p_transaction_step_id => p_transaction_step_id

Line 3502: hr_transaction_api.get_varchar2_value

3498: ,p_name => 'P_PEA_ATTRIBUTE7'),
3499: hr_transaction_api.get_varchar2_value
3500: (p_transaction_step_id => p_transaction_step_id
3501: ,p_name => 'P_PEA_ATTRIBUTE8'),
3502: hr_transaction_api.get_varchar2_value
3503: (p_transaction_step_id => p_transaction_step_id
3504: ,p_name => 'P_PEA_ATTRIBUTE9'),
3505: hr_transaction_api.get_varchar2_value
3506: (p_transaction_step_id => p_transaction_step_id

Line 3505: hr_transaction_api.get_varchar2_value

3501: ,p_name => 'P_PEA_ATTRIBUTE8'),
3502: hr_transaction_api.get_varchar2_value
3503: (p_transaction_step_id => p_transaction_step_id
3504: ,p_name => 'P_PEA_ATTRIBUTE9'),
3505: hr_transaction_api.get_varchar2_value
3506: (p_transaction_step_id => p_transaction_step_id
3507: ,p_name => 'P_PEA_ATTRIBUTE10'),
3508: hr_transaction_api.get_varchar2_value
3509: (p_transaction_step_id => p_transaction_step_id

Line 3508: hr_transaction_api.get_varchar2_value

3504: ,p_name => 'P_PEA_ATTRIBUTE9'),
3505: hr_transaction_api.get_varchar2_value
3506: (p_transaction_step_id => p_transaction_step_id
3507: ,p_name => 'P_PEA_ATTRIBUTE10'),
3508: hr_transaction_api.get_varchar2_value
3509: (p_transaction_step_id => p_transaction_step_id
3510: ,p_name => 'P_PEA_ATTRIBUTE11'),
3511: hr_transaction_api.get_varchar2_value
3512: (p_transaction_step_id => p_transaction_step_id

Line 3511: hr_transaction_api.get_varchar2_value

3507: ,p_name => 'P_PEA_ATTRIBUTE10'),
3508: hr_transaction_api.get_varchar2_value
3509: (p_transaction_step_id => p_transaction_step_id
3510: ,p_name => 'P_PEA_ATTRIBUTE11'),
3511: hr_transaction_api.get_varchar2_value
3512: (p_transaction_step_id => p_transaction_step_id
3513: ,p_name => 'P_PEA_ATTRIBUTE12'),
3514: hr_transaction_api.get_varchar2_value
3515: (p_transaction_step_id => p_transaction_step_id

Line 3514: hr_transaction_api.get_varchar2_value

3510: ,p_name => 'P_PEA_ATTRIBUTE11'),
3511: hr_transaction_api.get_varchar2_value
3512: (p_transaction_step_id => p_transaction_step_id
3513: ,p_name => 'P_PEA_ATTRIBUTE12'),
3514: hr_transaction_api.get_varchar2_value
3515: (p_transaction_step_id => p_transaction_step_id
3516: ,p_name => 'P_PEA_ATTRIBUTE13'),
3517: hr_transaction_api.get_varchar2_value
3518: (p_transaction_step_id => p_transaction_step_id

Line 3517: hr_transaction_api.get_varchar2_value

3513: ,p_name => 'P_PEA_ATTRIBUTE12'),
3514: hr_transaction_api.get_varchar2_value
3515: (p_transaction_step_id => p_transaction_step_id
3516: ,p_name => 'P_PEA_ATTRIBUTE13'),
3517: hr_transaction_api.get_varchar2_value
3518: (p_transaction_step_id => p_transaction_step_id
3519: ,p_name => 'P_PEA_ATTRIBUTE14'),
3520: hr_transaction_api.get_varchar2_value
3521: (p_transaction_step_id => p_transaction_step_id

Line 3520: hr_transaction_api.get_varchar2_value

3516: ,p_name => 'P_PEA_ATTRIBUTE13'),
3517: hr_transaction_api.get_varchar2_value
3518: (p_transaction_step_id => p_transaction_step_id
3519: ,p_name => 'P_PEA_ATTRIBUTE14'),
3520: hr_transaction_api.get_varchar2_value
3521: (p_transaction_step_id => p_transaction_step_id
3522: ,p_name => 'P_PEA_ATTRIBUTE15'),
3523: hr_transaction_api.get_varchar2_value
3524: (p_transaction_step_id => p_transaction_step_id

Line 3523: hr_transaction_api.get_varchar2_value

3519: ,p_name => 'P_PEA_ATTRIBUTE14'),
3520: hr_transaction_api.get_varchar2_value
3521: (p_transaction_step_id => p_transaction_step_id
3522: ,p_name => 'P_PEA_ATTRIBUTE15'),
3523: hr_transaction_api.get_varchar2_value
3524: (p_transaction_step_id => p_transaction_step_id
3525: ,p_name => 'P_PEA_ATTRIBUTE16'),
3526: hr_transaction_api.get_varchar2_value
3527: (p_transaction_step_id => p_transaction_step_id

Line 3526: hr_transaction_api.get_varchar2_value

3522: ,p_name => 'P_PEA_ATTRIBUTE15'),
3523: hr_transaction_api.get_varchar2_value
3524: (p_transaction_step_id => p_transaction_step_id
3525: ,p_name => 'P_PEA_ATTRIBUTE16'),
3526: hr_transaction_api.get_varchar2_value
3527: (p_transaction_step_id => p_transaction_step_id
3528: ,p_name => 'P_PEA_ATTRIBUTE17'),
3529: hr_transaction_api.get_varchar2_value
3530: (p_transaction_step_id => p_transaction_step_id

Line 3529: hr_transaction_api.get_varchar2_value

3525: ,p_name => 'P_PEA_ATTRIBUTE16'),
3526: hr_transaction_api.get_varchar2_value
3527: (p_transaction_step_id => p_transaction_step_id
3528: ,p_name => 'P_PEA_ATTRIBUTE17'),
3529: hr_transaction_api.get_varchar2_value
3530: (p_transaction_step_id => p_transaction_step_id
3531: ,p_name => 'P_PEA_ATTRIBUTE18'),
3532: hr_transaction_api.get_varchar2_value
3533: (p_transaction_step_id => p_transaction_step_id

Line 3532: hr_transaction_api.get_varchar2_value

3528: ,p_name => 'P_PEA_ATTRIBUTE17'),
3529: hr_transaction_api.get_varchar2_value
3530: (p_transaction_step_id => p_transaction_step_id
3531: ,p_name => 'P_PEA_ATTRIBUTE18'),
3532: hr_transaction_api.get_varchar2_value
3533: (p_transaction_step_id => p_transaction_step_id
3534: ,p_name => 'P_PEA_ATTRIBUTE19'),
3535: hr_transaction_api.get_varchar2_value
3536: (p_transaction_step_id => p_transaction_step_id

Line 3535: hr_transaction_api.get_varchar2_value

3531: ,p_name => 'P_PEA_ATTRIBUTE18'),
3532: hr_transaction_api.get_varchar2_value
3533: (p_transaction_step_id => p_transaction_step_id
3534: ,p_name => 'P_PEA_ATTRIBUTE19'),
3535: hr_transaction_api.get_varchar2_value
3536: (p_transaction_step_id => p_transaction_step_id
3537: ,p_name => 'P_PEA_ATTRIBUTE20'),
3538: hr_transaction_api.get_varchar2_value
3539: (p_transaction_step_id => p_transaction_step_id

Line 3538: hr_transaction_api.get_varchar2_value

3534: ,p_name => 'P_PEA_ATTRIBUTE19'),
3535: hr_transaction_api.get_varchar2_value
3536: (p_transaction_step_id => p_transaction_step_id
3537: ,p_name => 'P_PEA_ATTRIBUTE20'),
3538: hr_transaction_api.get_varchar2_value
3539: (p_transaction_step_id => p_transaction_step_id
3540: ,p_name => 'P_PE_NAME'),
3541: to_number(hr_transaction_api.get_varchar2_value
3542: (p_transaction_step_id => p_transaction_step_id

Line 3541: to_number(hr_transaction_api.get_varchar2_value

3537: ,p_name => 'P_PEA_ATTRIBUTE20'),
3538: hr_transaction_api.get_varchar2_value
3539: (p_transaction_step_id => p_transaction_step_id
3540: ,p_name => 'P_PE_NAME'),
3541: to_number(hr_transaction_api.get_varchar2_value
3542: (p_transaction_step_id => p_transaction_step_id
3543: ,p_name => 'P_PARTY_ID'))
3544: );
3545: END LOOP;

Line 3554: to_number(hr_transaction_api.get_varchar2_value

3550: hr_utility.set_location('Entering For Loop:'||l_proc,20);
3551: FOR i IN 1..NVL(l_qua_count,0) LOOP
3552: p_qualifications.extend;
3553: p_qualifications(i) := SSHR_QUA_OBJ_TYP(
3554: to_number(hr_transaction_api.get_varchar2_value
3555: (p_transaction_step_id => p_transaction_step_id
3556: ,p_name => 'P_QUALIFICATION_ID')),
3557: hr_transaction_api.get_varchar2_value
3558: (p_transaction_step_id => p_transaction_step_id

Line 3557: hr_transaction_api.get_varchar2_value

3553: p_qualifications(i) := SSHR_QUA_OBJ_TYP(
3554: to_number(hr_transaction_api.get_varchar2_value
3555: (p_transaction_step_id => p_transaction_step_id
3556: ,p_name => 'P_QUALIFICATION_ID')),
3557: hr_transaction_api.get_varchar2_value
3558: (p_transaction_step_id => p_transaction_step_id
3559: ,p_name => 'P_DELETE_FLAG'),
3560: to_number(hr_transaction_api.get_varchar2_value
3561: (p_transaction_step_id => p_transaction_step_id

Line 3560: to_number(hr_transaction_api.get_varchar2_value

3556: ,p_name => 'P_QUALIFICATION_ID')),
3557: hr_transaction_api.get_varchar2_value
3558: (p_transaction_step_id => p_transaction_step_id
3559: ,p_name => 'P_DELETE_FLAG'),
3560: to_number(hr_transaction_api.get_varchar2_value
3561: (p_transaction_step_id => p_transaction_step_id
3562: ,p_name => 'P_BUSINESS_GROUP_ID')),
3563: to_number(hr_transaction_api.get_varchar2_value
3564: (p_transaction_step_id => p_transaction_step_id

Line 3563: to_number(hr_transaction_api.get_varchar2_value

3559: ,p_name => 'P_DELETE_FLAG'),
3560: to_number(hr_transaction_api.get_varchar2_value
3561: (p_transaction_step_id => p_transaction_step_id
3562: ,p_name => 'P_BUSINESS_GROUP_ID')),
3563: to_number(hr_transaction_api.get_varchar2_value
3564: (p_transaction_step_id => p_transaction_step_id
3565: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER')),
3566: to_number(hr_transaction_api.get_varchar2_value
3567: (p_transaction_step_id => p_transaction_step_id

Line 3566: to_number(hr_transaction_api.get_varchar2_value

3562: ,p_name => 'P_BUSINESS_GROUP_ID')),
3563: to_number(hr_transaction_api.get_varchar2_value
3564: (p_transaction_step_id => p_transaction_step_id
3565: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER')),
3566: to_number(hr_transaction_api.get_varchar2_value
3567: (p_transaction_step_id => p_transaction_step_id
3568: ,p_name => 'P_PQ_PERSON_ID')),
3569: hr_transaction_api.get_varchar2_value
3570: (p_transaction_step_id => p_transaction_step_id

Line 3569: hr_transaction_api.get_varchar2_value

3565: ,p_name => 'P_PQ_OBJECT_VERSION_NUMBER')),
3566: to_number(hr_transaction_api.get_varchar2_value
3567: (p_transaction_step_id => p_transaction_step_id
3568: ,p_name => 'P_PQ_PERSON_ID')),
3569: hr_transaction_api.get_varchar2_value
3570: (p_transaction_step_id => p_transaction_step_id
3571: ,p_name => 'P_PQ_TITLE'),
3572: hr_transaction_api.get_varchar2_value
3573: (p_transaction_step_id => p_transaction_step_id

Line 3572: hr_transaction_api.get_varchar2_value

3568: ,p_name => 'P_PQ_PERSON_ID')),
3569: hr_transaction_api.get_varchar2_value
3570: (p_transaction_step_id => p_transaction_step_id
3571: ,p_name => 'P_PQ_TITLE'),
3572: hr_transaction_api.get_varchar2_value
3573: (p_transaction_step_id => p_transaction_step_id
3574: ,p_name => 'P_PQ_GRADE_ATTAINED'),
3575: hr_transaction_api.get_varchar2_value
3576: (p_transaction_step_id => p_transaction_step_id

Line 3575: hr_transaction_api.get_varchar2_value

3571: ,p_name => 'P_PQ_TITLE'),
3572: hr_transaction_api.get_varchar2_value
3573: (p_transaction_step_id => p_transaction_step_id
3574: ,p_name => 'P_PQ_GRADE_ATTAINED'),
3575: hr_transaction_api.get_varchar2_value
3576: (p_transaction_step_id => p_transaction_step_id
3577: ,p_name => 'P_PQ_STATUS'),
3578: hr_transaction_api.get_date_value
3579: (p_transaction_step_id => p_transaction_step_id

Line 3578: hr_transaction_api.get_date_value

3574: ,p_name => 'P_PQ_GRADE_ATTAINED'),
3575: hr_transaction_api.get_varchar2_value
3576: (p_transaction_step_id => p_transaction_step_id
3577: ,p_name => 'P_PQ_STATUS'),
3578: hr_transaction_api.get_date_value
3579: (p_transaction_step_id => p_transaction_step_id
3580: ,p_name => 'P_PQ_AWARDED_DATE'),
3581: to_number(hr_transaction_api.get_varchar2_value
3582: (p_transaction_step_id => p_transaction_step_id

Line 3581: to_number(hr_transaction_api.get_varchar2_value

3577: ,p_name => 'P_PQ_STATUS'),
3578: hr_transaction_api.get_date_value
3579: (p_transaction_step_id => p_transaction_step_id
3580: ,p_name => 'P_PQ_AWARDED_DATE'),
3581: to_number(hr_transaction_api.get_varchar2_value
3582: (p_transaction_step_id => p_transaction_step_id
3583: ,p_name => 'P_PQ_FEE')),
3584: hr_transaction_api.get_varchar2_value
3585: (p_transaction_step_id => p_transaction_step_id

Line 3584: hr_transaction_api.get_varchar2_value

3580: ,p_name => 'P_PQ_AWARDED_DATE'),
3581: to_number(hr_transaction_api.get_varchar2_value
3582: (p_transaction_step_id => p_transaction_step_id
3583: ,p_name => 'P_PQ_FEE')),
3584: hr_transaction_api.get_varchar2_value
3585: (p_transaction_step_id => p_transaction_step_id
3586: ,p_name => 'P_PQ_FEE_CURRENCY'),
3587: to_number(hr_transaction_api.get_varchar2_value
3588: (p_transaction_step_id => p_transaction_step_id

Line 3587: to_number(hr_transaction_api.get_varchar2_value

3583: ,p_name => 'P_PQ_FEE')),
3584: hr_transaction_api.get_varchar2_value
3585: (p_transaction_step_id => p_transaction_step_id
3586: ,p_name => 'P_PQ_FEE_CURRENCY'),
3587: to_number(hr_transaction_api.get_varchar2_value
3588: (p_transaction_step_id => p_transaction_step_id
3589: ,p_name => 'P_PQ_COMPLETED_AMOUNT')),
3590: hr_transaction_api.get_varchar2_value
3591: (p_transaction_step_id => p_transaction_step_id

Line 3590: hr_transaction_api.get_varchar2_value

3586: ,p_name => 'P_PQ_FEE_CURRENCY'),
3587: to_number(hr_transaction_api.get_varchar2_value
3588: (p_transaction_step_id => p_transaction_step_id
3589: ,p_name => 'P_PQ_COMPLETED_AMOUNT')),
3590: hr_transaction_api.get_varchar2_value
3591: (p_transaction_step_id => p_transaction_step_id
3592: ,p_name => 'P_PQ_REIMBURSEMENT'),
3593: hr_transaction_api.get_varchar2_value
3594: (p_transaction_step_id => p_transaction_step_id

Line 3593: hr_transaction_api.get_varchar2_value

3589: ,p_name => 'P_PQ_COMPLETED_AMOUNT')),
3590: hr_transaction_api.get_varchar2_value
3591: (p_transaction_step_id => p_transaction_step_id
3592: ,p_name => 'P_PQ_REIMBURSEMENT'),
3593: hr_transaction_api.get_varchar2_value
3594: (p_transaction_step_id => p_transaction_step_id
3595: ,p_name => 'P_PQ_COMPLETED_UNITS'),
3596: to_number(hr_transaction_api.get_varchar2_value
3597: (p_transaction_step_id => p_transaction_step_id

Line 3596: to_number(hr_transaction_api.get_varchar2_value

3592: ,p_name => 'P_PQ_REIMBURSEMENT'),
3593: hr_transaction_api.get_varchar2_value
3594: (p_transaction_step_id => p_transaction_step_id
3595: ,p_name => 'P_PQ_COMPLETED_UNITS'),
3596: to_number(hr_transaction_api.get_varchar2_value
3597: (p_transaction_step_id => p_transaction_step_id
3598: ,p_name => 'P_PQ_TOTAL_AMOUNT')),
3599: hr_transaction_api.get_date_value
3600: (p_transaction_step_id => p_transaction_step_id

Line 3599: hr_transaction_api.get_date_value

3595: ,p_name => 'P_PQ_COMPLETED_UNITS'),
3596: to_number(hr_transaction_api.get_varchar2_value
3597: (p_transaction_step_id => p_transaction_step_id
3598: ,p_name => 'P_PQ_TOTAL_AMOUNT')),
3599: hr_transaction_api.get_date_value
3600: (p_transaction_step_id => p_transaction_step_id
3601: ,p_name => 'P_PQ_START_DATE'),
3602: hr_transaction_api.get_date_value
3603: (p_transaction_step_id => p_transaction_step_id

Line 3602: hr_transaction_api.get_date_value

3598: ,p_name => 'P_PQ_TOTAL_AMOUNT')),
3599: hr_transaction_api.get_date_value
3600: (p_transaction_step_id => p_transaction_step_id
3601: ,p_name => 'P_PQ_START_DATE'),
3602: hr_transaction_api.get_date_value
3603: (p_transaction_step_id => p_transaction_step_id
3604: ,p_name => 'P_PQ_END_DATE'),
3605: hr_transaction_api.get_varchar2_value
3606: (p_transaction_step_id => p_transaction_step_id

Line 3605: hr_transaction_api.get_varchar2_value

3601: ,p_name => 'P_PQ_START_DATE'),
3602: hr_transaction_api.get_date_value
3603: (p_transaction_step_id => p_transaction_step_id
3604: ,p_name => 'P_PQ_END_DATE'),
3605: hr_transaction_api.get_varchar2_value
3606: (p_transaction_step_id => p_transaction_step_id
3607: ,p_name => 'P_PQ_LICENSE_NUMBER'),
3608: hr_transaction_api.get_date_value
3609: (p_transaction_step_id => p_transaction_step_id

Line 3608: hr_transaction_api.get_date_value

3604: ,p_name => 'P_PQ_END_DATE'),
3605: hr_transaction_api.get_varchar2_value
3606: (p_transaction_step_id => p_transaction_step_id
3607: ,p_name => 'P_PQ_LICENSE_NUMBER'),
3608: hr_transaction_api.get_date_value
3609: (p_transaction_step_id => p_transaction_step_id
3610: ,p_name => 'P_PQ_EXPIRY_DATE'),
3611: hr_transaction_api.get_varchar2_value
3612: (p_transaction_step_id => p_transaction_step_id

Line 3611: hr_transaction_api.get_varchar2_value

3607: ,p_name => 'P_PQ_LICENSE_NUMBER'),
3608: hr_transaction_api.get_date_value
3609: (p_transaction_step_id => p_transaction_step_id
3610: ,p_name => 'P_PQ_EXPIRY_DATE'),
3611: hr_transaction_api.get_varchar2_value
3612: (p_transaction_step_id => p_transaction_step_id
3613: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'),
3614: null, --PROJECTED_COMPLETION_DATE
3615: hr_transaction_api.get_varchar2_value

Line 3615: hr_transaction_api.get_varchar2_value

3611: hr_transaction_api.get_varchar2_value
3612: (p_transaction_step_id => p_transaction_step_id
3613: ,p_name => 'P_PQ_LICENSE_RESTRICTIONS'),
3614: null, --PROJECTED_COMPLETION_DATE
3615: hr_transaction_api.get_varchar2_value
3616: (p_transaction_step_id => p_transaction_step_id
3617: ,p_name => 'P_PQ_AWARDING_BODY'),
3618: hr_transaction_api.get_varchar2_value
3619: (p_transaction_step_id => p_transaction_step_id

Line 3618: hr_transaction_api.get_varchar2_value

3614: null, --PROJECTED_COMPLETION_DATE
3615: hr_transaction_api.get_varchar2_value
3616: (p_transaction_step_id => p_transaction_step_id
3617: ,p_name => 'P_PQ_AWARDING_BODY'),
3618: hr_transaction_api.get_varchar2_value
3619: (p_transaction_step_id => p_transaction_step_id
3620: ,p_name => 'P_PQ_TUITION_METHOD'),
3621: hr_transaction_api.get_varchar2_value
3622: (p_transaction_step_id => p_transaction_step_id

Line 3621: hr_transaction_api.get_varchar2_value

3617: ,p_name => 'P_PQ_AWARDING_BODY'),
3618: hr_transaction_api.get_varchar2_value
3619: (p_transaction_step_id => p_transaction_step_id
3620: ,p_name => 'P_PQ_TUITION_METHOD'),
3621: hr_transaction_api.get_varchar2_value
3622: (p_transaction_step_id => p_transaction_step_id
3623: ,p_name => 'P_PQ_GROUP_RANKING'),
3624: hr_transaction_api.get_varchar2_value
3625: (p_transaction_step_id => p_transaction_step_id

Line 3624: hr_transaction_api.get_varchar2_value

3620: ,p_name => 'P_PQ_TUITION_METHOD'),
3621: hr_transaction_api.get_varchar2_value
3622: (p_transaction_step_id => p_transaction_step_id
3623: ,p_name => 'P_PQ_GROUP_RANKING'),
3624: hr_transaction_api.get_varchar2_value
3625: (p_transaction_step_id => p_transaction_step_id
3626: ,p_name => 'P_PQ_COMMENTS'),
3627: to_number(hr_transaction_api.get_varchar2_value
3628: (p_transaction_step_id => p_transaction_step_id

Line 3627: to_number(hr_transaction_api.get_varchar2_value

3623: ,p_name => 'P_PQ_GROUP_RANKING'),
3624: hr_transaction_api.get_varchar2_value
3625: (p_transaction_step_id => p_transaction_step_id
3626: ,p_name => 'P_PQ_COMMENTS'),
3627: to_number(hr_transaction_api.get_varchar2_value
3628: (p_transaction_step_id => p_transaction_step_id
3629: ,p_name => 'P_QUALIFICATION_TYPE_ID')),
3630: to_number(hr_transaction_api.get_varchar2_value
3631: (p_transaction_step_id => p_transaction_step_id

Line 3630: to_number(hr_transaction_api.get_varchar2_value

3626: ,p_name => 'P_PQ_COMMENTS'),
3627: to_number(hr_transaction_api.get_varchar2_value
3628: (p_transaction_step_id => p_transaction_step_id
3629: ,p_name => 'P_QUALIFICATION_TYPE_ID')),
3630: to_number(hr_transaction_api.get_varchar2_value
3631: (p_transaction_step_id => p_transaction_step_id
3632: ,p_name => 'P_ATTENDANCE_ID')),
3633: hr_transaction_api.get_varchar2_value
3634: (p_transaction_step_id => p_transaction_step_id

Line 3633: hr_transaction_api.get_varchar2_value

3629: ,p_name => 'P_QUALIFICATION_TYPE_ID')),
3630: to_number(hr_transaction_api.get_varchar2_value
3631: (p_transaction_step_id => p_transaction_step_id
3632: ,p_name => 'P_ATTENDANCE_ID')),
3633: hr_transaction_api.get_varchar2_value
3634: (p_transaction_step_id => p_transaction_step_id
3635: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'),
3636: hr_transaction_api.get_varchar2_value
3637: (p_transaction_step_id => p_transaction_step_id

Line 3636: hr_transaction_api.get_varchar2_value

3632: ,p_name => 'P_ATTENDANCE_ID')),
3633: hr_transaction_api.get_varchar2_value
3634: (p_transaction_step_id => p_transaction_step_id
3635: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'),
3636: hr_transaction_api.get_varchar2_value
3637: (p_transaction_step_id => p_transaction_step_id
3638: ,p_name => 'P_PQ_ATTRIBUTE1'),
3639: hr_transaction_api.get_varchar2_value
3640: (p_transaction_step_id => p_transaction_step_id

Line 3639: hr_transaction_api.get_varchar2_value

3635: ,p_name => 'P_PQ_ATTRIBUTE_CATEGORY'),
3636: hr_transaction_api.get_varchar2_value
3637: (p_transaction_step_id => p_transaction_step_id
3638: ,p_name => 'P_PQ_ATTRIBUTE1'),
3639: hr_transaction_api.get_varchar2_value
3640: (p_transaction_step_id => p_transaction_step_id
3641: ,p_name => 'P_PQ_ATTRIBUTE2'),
3642: hr_transaction_api.get_varchar2_value
3643: (p_transaction_step_id => p_transaction_step_id

Line 3642: hr_transaction_api.get_varchar2_value

3638: ,p_name => 'P_PQ_ATTRIBUTE1'),
3639: hr_transaction_api.get_varchar2_value
3640: (p_transaction_step_id => p_transaction_step_id
3641: ,p_name => 'P_PQ_ATTRIBUTE2'),
3642: hr_transaction_api.get_varchar2_value
3643: (p_transaction_step_id => p_transaction_step_id
3644: ,p_name => 'P_PQ_ATTRIBUTE3'),
3645: hr_transaction_api.get_varchar2_value
3646: (p_transaction_step_id => p_transaction_step_id

Line 3645: hr_transaction_api.get_varchar2_value

3641: ,p_name => 'P_PQ_ATTRIBUTE2'),
3642: hr_transaction_api.get_varchar2_value
3643: (p_transaction_step_id => p_transaction_step_id
3644: ,p_name => 'P_PQ_ATTRIBUTE3'),
3645: hr_transaction_api.get_varchar2_value
3646: (p_transaction_step_id => p_transaction_step_id
3647: ,p_name => 'P_PQ_ATTRIBUTE4'),
3648: hr_transaction_api.get_varchar2_value
3649: (p_transaction_step_id => p_transaction_step_id

Line 3648: hr_transaction_api.get_varchar2_value

3644: ,p_name => 'P_PQ_ATTRIBUTE3'),
3645: hr_transaction_api.get_varchar2_value
3646: (p_transaction_step_id => p_transaction_step_id
3647: ,p_name => 'P_PQ_ATTRIBUTE4'),
3648: hr_transaction_api.get_varchar2_value
3649: (p_transaction_step_id => p_transaction_step_id
3650: ,p_name => 'P_PQ_ATTRIBUTE5'),
3651: hr_transaction_api.get_varchar2_value
3652: (p_transaction_step_id => p_transaction_step_id

Line 3651: hr_transaction_api.get_varchar2_value

3647: ,p_name => 'P_PQ_ATTRIBUTE4'),
3648: hr_transaction_api.get_varchar2_value
3649: (p_transaction_step_id => p_transaction_step_id
3650: ,p_name => 'P_PQ_ATTRIBUTE5'),
3651: hr_transaction_api.get_varchar2_value
3652: (p_transaction_step_id => p_transaction_step_id
3653: ,p_name => 'P_PQ_ATTRIBUTE6'),
3654: hr_transaction_api.get_varchar2_value
3655: (p_transaction_step_id => p_transaction_step_id

Line 3654: hr_transaction_api.get_varchar2_value

3650: ,p_name => 'P_PQ_ATTRIBUTE5'),
3651: hr_transaction_api.get_varchar2_value
3652: (p_transaction_step_id => p_transaction_step_id
3653: ,p_name => 'P_PQ_ATTRIBUTE6'),
3654: hr_transaction_api.get_varchar2_value
3655: (p_transaction_step_id => p_transaction_step_id
3656: ,p_name => 'P_PQ_ATTRIBUTE7'),
3657: hr_transaction_api.get_varchar2_value
3658: (p_transaction_step_id => p_transaction_step_id

Line 3657: hr_transaction_api.get_varchar2_value

3653: ,p_name => 'P_PQ_ATTRIBUTE6'),
3654: hr_transaction_api.get_varchar2_value
3655: (p_transaction_step_id => p_transaction_step_id
3656: ,p_name => 'P_PQ_ATTRIBUTE7'),
3657: hr_transaction_api.get_varchar2_value
3658: (p_transaction_step_id => p_transaction_step_id
3659: ,p_name => 'P_PQ_ATTRIBUTE8'),
3660: hr_transaction_api.get_varchar2_value
3661: (p_transaction_step_id => p_transaction_step_id

Line 3660: hr_transaction_api.get_varchar2_value

3656: ,p_name => 'P_PQ_ATTRIBUTE7'),
3657: hr_transaction_api.get_varchar2_value
3658: (p_transaction_step_id => p_transaction_step_id
3659: ,p_name => 'P_PQ_ATTRIBUTE8'),
3660: hr_transaction_api.get_varchar2_value
3661: (p_transaction_step_id => p_transaction_step_id
3662: ,p_name => 'P_PQ_ATTRIBUTE9'),
3663: hr_transaction_api.get_varchar2_value
3664: (p_transaction_step_id => p_transaction_step_id

Line 3663: hr_transaction_api.get_varchar2_value

3659: ,p_name => 'P_PQ_ATTRIBUTE8'),
3660: hr_transaction_api.get_varchar2_value
3661: (p_transaction_step_id => p_transaction_step_id
3662: ,p_name => 'P_PQ_ATTRIBUTE9'),
3663: hr_transaction_api.get_varchar2_value
3664: (p_transaction_step_id => p_transaction_step_id
3665: ,p_name => 'P_PQ_ATTRIBUTE10'),
3666: hr_transaction_api.get_varchar2_value
3667: (p_transaction_step_id => p_transaction_step_id

Line 3666: hr_transaction_api.get_varchar2_value

3662: ,p_name => 'P_PQ_ATTRIBUTE9'),
3663: hr_transaction_api.get_varchar2_value
3664: (p_transaction_step_id => p_transaction_step_id
3665: ,p_name => 'P_PQ_ATTRIBUTE10'),
3666: hr_transaction_api.get_varchar2_value
3667: (p_transaction_step_id => p_transaction_step_id
3668: ,p_name => 'P_PQ_ATTRIBUTE11'),
3669: hr_transaction_api.get_varchar2_value
3670: (p_transaction_step_id => p_transaction_step_id

Line 3669: hr_transaction_api.get_varchar2_value

3665: ,p_name => 'P_PQ_ATTRIBUTE10'),
3666: hr_transaction_api.get_varchar2_value
3667: (p_transaction_step_id => p_transaction_step_id
3668: ,p_name => 'P_PQ_ATTRIBUTE11'),
3669: hr_transaction_api.get_varchar2_value
3670: (p_transaction_step_id => p_transaction_step_id
3671: ,p_name => 'P_PQ_ATTRIBUTE12'),
3672: hr_transaction_api.get_varchar2_value
3673: (p_transaction_step_id => p_transaction_step_id

Line 3672: hr_transaction_api.get_varchar2_value

3668: ,p_name => 'P_PQ_ATTRIBUTE11'),
3669: hr_transaction_api.get_varchar2_value
3670: (p_transaction_step_id => p_transaction_step_id
3671: ,p_name => 'P_PQ_ATTRIBUTE12'),
3672: hr_transaction_api.get_varchar2_value
3673: (p_transaction_step_id => p_transaction_step_id
3674: ,p_name => 'P_PQ_ATTRIBUTE13'),
3675: hr_transaction_api.get_varchar2_value
3676: (p_transaction_step_id => p_transaction_step_id

Line 3675: hr_transaction_api.get_varchar2_value

3671: ,p_name => 'P_PQ_ATTRIBUTE12'),
3672: hr_transaction_api.get_varchar2_value
3673: (p_transaction_step_id => p_transaction_step_id
3674: ,p_name => 'P_PQ_ATTRIBUTE13'),
3675: hr_transaction_api.get_varchar2_value
3676: (p_transaction_step_id => p_transaction_step_id
3677: ,p_name => 'P_PQ_ATTRIBUTE14'),
3678: hr_transaction_api.get_varchar2_value
3679: (p_transaction_step_id => p_transaction_step_id

Line 3678: hr_transaction_api.get_varchar2_value

3674: ,p_name => 'P_PQ_ATTRIBUTE13'),
3675: hr_transaction_api.get_varchar2_value
3676: (p_transaction_step_id => p_transaction_step_id
3677: ,p_name => 'P_PQ_ATTRIBUTE14'),
3678: hr_transaction_api.get_varchar2_value
3679: (p_transaction_step_id => p_transaction_step_id
3680: ,p_name => 'P_PQ_ATTRIBUTE15'),
3681: hr_transaction_api.get_varchar2_value
3682: (p_transaction_step_id => p_transaction_step_id

Line 3681: hr_transaction_api.get_varchar2_value

3677: ,p_name => 'P_PQ_ATTRIBUTE14'),
3678: hr_transaction_api.get_varchar2_value
3679: (p_transaction_step_id => p_transaction_step_id
3680: ,p_name => 'P_PQ_ATTRIBUTE15'),
3681: hr_transaction_api.get_varchar2_value
3682: (p_transaction_step_id => p_transaction_step_id
3683: ,p_name => 'P_PQ_ATTRIBUTE16'),
3684: hr_transaction_api.get_varchar2_value
3685: (p_transaction_step_id => p_transaction_step_id

Line 3684: hr_transaction_api.get_varchar2_value

3680: ,p_name => 'P_PQ_ATTRIBUTE15'),
3681: hr_transaction_api.get_varchar2_value
3682: (p_transaction_step_id => p_transaction_step_id
3683: ,p_name => 'P_PQ_ATTRIBUTE16'),
3684: hr_transaction_api.get_varchar2_value
3685: (p_transaction_step_id => p_transaction_step_id
3686: ,p_name => 'P_PQ_ATTRIBUTE17'),
3687: hr_transaction_api.get_varchar2_value
3688: (p_transaction_step_id => p_transaction_step_id

Line 3687: hr_transaction_api.get_varchar2_value

3683: ,p_name => 'P_PQ_ATTRIBUTE16'),
3684: hr_transaction_api.get_varchar2_value
3685: (p_transaction_step_id => p_transaction_step_id
3686: ,p_name => 'P_PQ_ATTRIBUTE17'),
3687: hr_transaction_api.get_varchar2_value
3688: (p_transaction_step_id => p_transaction_step_id
3689: ,p_name => 'P_PQ_ATTRIBUTE18'),
3690: hr_transaction_api.get_varchar2_value
3691: (p_transaction_step_id => p_transaction_step_id

Line 3690: hr_transaction_api.get_varchar2_value

3686: ,p_name => 'P_PQ_ATTRIBUTE17'),
3687: hr_transaction_api.get_varchar2_value
3688: (p_transaction_step_id => p_transaction_step_id
3689: ,p_name => 'P_PQ_ATTRIBUTE18'),
3690: hr_transaction_api.get_varchar2_value
3691: (p_transaction_step_id => p_transaction_step_id
3692: ,p_name => 'P_PQ_ATTRIBUTE19'),
3693: hr_transaction_api.get_varchar2_value
3694: (p_transaction_step_id => p_transaction_step_id

Line 3693: hr_transaction_api.get_varchar2_value

3689: ,p_name => 'P_PQ_ATTRIBUTE18'),
3690: hr_transaction_api.get_varchar2_value
3691: (p_transaction_step_id => p_transaction_step_id
3692: ,p_name => 'P_PQ_ATTRIBUTE19'),
3693: hr_transaction_api.get_varchar2_value
3694: (p_transaction_step_id => p_transaction_step_id
3695: ,p_name => 'P_PQ_ATTRIBUTE20'),
3696: hr_transaction_api.get_varchar2_value
3697: (p_transaction_step_id => p_transaction_step_id

Line 3696: hr_transaction_api.get_varchar2_value

3692: ,p_name => 'P_PQ_ATTRIBUTE19'),
3693: hr_transaction_api.get_varchar2_value
3694: (p_transaction_step_id => p_transaction_step_id
3695: ,p_name => 'P_PQ_ATTRIBUTE20'),
3696: hr_transaction_api.get_varchar2_value
3697: (p_transaction_step_id => p_transaction_step_id
3698: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'),
3699: hr_transaction_api.get_varchar2_value
3700: (p_transaction_step_id => p_transaction_step_id

Line 3699: hr_transaction_api.get_varchar2_value

3695: ,p_name => 'P_PQ_ATTRIBUTE20'),
3696: hr_transaction_api.get_varchar2_value
3697: (p_transaction_step_id => p_transaction_step_id
3698: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'),
3699: hr_transaction_api.get_varchar2_value
3700: (p_transaction_step_id => p_transaction_step_id
3701: ,p_name => 'P_PQ_QUA_INFORMATION1'),
3702: hr_transaction_api.get_varchar2_value
3703: (p_transaction_step_id => p_transaction_step_id

Line 3702: hr_transaction_api.get_varchar2_value

3698: ,p_name => 'P_PQ_QUA_INFORMATION_CATEGORY'),
3699: hr_transaction_api.get_varchar2_value
3700: (p_transaction_step_id => p_transaction_step_id
3701: ,p_name => 'P_PQ_QUA_INFORMATION1'),
3702: hr_transaction_api.get_varchar2_value
3703: (p_transaction_step_id => p_transaction_step_id
3704: ,p_name => 'P_PQ_QUA_INFORMATION2'),
3705: hr_transaction_api.get_varchar2_value
3706: (p_transaction_step_id => p_transaction_step_id

Line 3705: hr_transaction_api.get_varchar2_value

3701: ,p_name => 'P_PQ_QUA_INFORMATION1'),
3702: hr_transaction_api.get_varchar2_value
3703: (p_transaction_step_id => p_transaction_step_id
3704: ,p_name => 'P_PQ_QUA_INFORMATION2'),
3705: hr_transaction_api.get_varchar2_value
3706: (p_transaction_step_id => p_transaction_step_id
3707: ,p_name => 'P_PQ_QUA_INFORMATION3'),
3708: hr_transaction_api.get_varchar2_value
3709: (p_transaction_step_id => p_transaction_step_id

Line 3708: hr_transaction_api.get_varchar2_value

3704: ,p_name => 'P_PQ_QUA_INFORMATION2'),
3705: hr_transaction_api.get_varchar2_value
3706: (p_transaction_step_id => p_transaction_step_id
3707: ,p_name => 'P_PQ_QUA_INFORMATION3'),
3708: hr_transaction_api.get_varchar2_value
3709: (p_transaction_step_id => p_transaction_step_id
3710: ,p_name => 'P_PQ_QUA_INFORMATION4'),
3711: hr_transaction_api.get_varchar2_value
3712: (p_transaction_step_id => p_transaction_step_id

Line 3711: hr_transaction_api.get_varchar2_value

3707: ,p_name => 'P_PQ_QUA_INFORMATION3'),
3708: hr_transaction_api.get_varchar2_value
3709: (p_transaction_step_id => p_transaction_step_id
3710: ,p_name => 'P_PQ_QUA_INFORMATION4'),
3711: hr_transaction_api.get_varchar2_value
3712: (p_transaction_step_id => p_transaction_step_id
3713: ,p_name => 'P_PQ_QUA_INFORMATION5'),
3714: hr_transaction_api.get_varchar2_value
3715: (p_transaction_step_id => p_transaction_step_id

Line 3714: hr_transaction_api.get_varchar2_value

3710: ,p_name => 'P_PQ_QUA_INFORMATION4'),
3711: hr_transaction_api.get_varchar2_value
3712: (p_transaction_step_id => p_transaction_step_id
3713: ,p_name => 'P_PQ_QUA_INFORMATION5'),
3714: hr_transaction_api.get_varchar2_value
3715: (p_transaction_step_id => p_transaction_step_id
3716: ,p_name => 'P_PQ_QUA_INFORMATION6'),
3717: hr_transaction_api.get_varchar2_value
3718: (p_transaction_step_id => p_transaction_step_id

Line 3717: hr_transaction_api.get_varchar2_value

3713: ,p_name => 'P_PQ_QUA_INFORMATION5'),
3714: hr_transaction_api.get_varchar2_value
3715: (p_transaction_step_id => p_transaction_step_id
3716: ,p_name => 'P_PQ_QUA_INFORMATION6'),
3717: hr_transaction_api.get_varchar2_value
3718: (p_transaction_step_id => p_transaction_step_id
3719: ,p_name => 'P_PQ_QUA_INFORMATION7'),
3720: hr_transaction_api.get_varchar2_value
3721: (p_transaction_step_id => p_transaction_step_id

Line 3720: hr_transaction_api.get_varchar2_value

3716: ,p_name => 'P_PQ_QUA_INFORMATION6'),
3717: hr_transaction_api.get_varchar2_value
3718: (p_transaction_step_id => p_transaction_step_id
3719: ,p_name => 'P_PQ_QUA_INFORMATION7'),
3720: hr_transaction_api.get_varchar2_value
3721: (p_transaction_step_id => p_transaction_step_id
3722: ,p_name => 'P_PQ_QUA_INFORMATION8'),
3723: hr_transaction_api.get_varchar2_value
3724: (p_transaction_step_id => p_transaction_step_id

Line 3723: hr_transaction_api.get_varchar2_value

3719: ,p_name => 'P_PQ_QUA_INFORMATION7'),
3720: hr_transaction_api.get_varchar2_value
3721: (p_transaction_step_id => p_transaction_step_id
3722: ,p_name => 'P_PQ_QUA_INFORMATION8'),
3723: hr_transaction_api.get_varchar2_value
3724: (p_transaction_step_id => p_transaction_step_id
3725: ,p_name => 'P_PQ_QUA_INFORMATION9'),
3726: hr_transaction_api.get_varchar2_value
3727: (p_transaction_step_id => p_transaction_step_id

Line 3726: hr_transaction_api.get_varchar2_value

3722: ,p_name => 'P_PQ_QUA_INFORMATION8'),
3723: hr_transaction_api.get_varchar2_value
3724: (p_transaction_step_id => p_transaction_step_id
3725: ,p_name => 'P_PQ_QUA_INFORMATION9'),
3726: hr_transaction_api.get_varchar2_value
3727: (p_transaction_step_id => p_transaction_step_id
3728: ,p_name => 'P_PQ_QUA_INFORMATION10'),
3729: hr_transaction_api.get_varchar2_value
3730: (p_transaction_step_id => p_transaction_step_id

Line 3729: hr_transaction_api.get_varchar2_value

3725: ,p_name => 'P_PQ_QUA_INFORMATION9'),
3726: hr_transaction_api.get_varchar2_value
3727: (p_transaction_step_id => p_transaction_step_id
3728: ,p_name => 'P_PQ_QUA_INFORMATION10'),
3729: hr_transaction_api.get_varchar2_value
3730: (p_transaction_step_id => p_transaction_step_id
3731: ,p_name => 'P_PQ_QUA_INFORMATION11'),
3732: hr_transaction_api.get_varchar2_value
3733: (p_transaction_step_id => p_transaction_step_id

Line 3732: hr_transaction_api.get_varchar2_value

3728: ,p_name => 'P_PQ_QUA_INFORMATION10'),
3729: hr_transaction_api.get_varchar2_value
3730: (p_transaction_step_id => p_transaction_step_id
3731: ,p_name => 'P_PQ_QUA_INFORMATION11'),
3732: hr_transaction_api.get_varchar2_value
3733: (p_transaction_step_id => p_transaction_step_id
3734: ,p_name => 'P_PQ_QUA_INFORMATION12'),
3735: hr_transaction_api.get_varchar2_value
3736: (p_transaction_step_id => p_transaction_step_id

Line 3735: hr_transaction_api.get_varchar2_value

3731: ,p_name => 'P_PQ_QUA_INFORMATION11'),
3732: hr_transaction_api.get_varchar2_value
3733: (p_transaction_step_id => p_transaction_step_id
3734: ,p_name => 'P_PQ_QUA_INFORMATION12'),
3735: hr_transaction_api.get_varchar2_value
3736: (p_transaction_step_id => p_transaction_step_id
3737: ,p_name => 'P_PQ_QUA_INFORMATION13'),
3738: hr_transaction_api.get_varchar2_value
3739: (p_transaction_step_id => p_transaction_step_id

Line 3738: hr_transaction_api.get_varchar2_value

3734: ,p_name => 'P_PQ_QUA_INFORMATION12'),
3735: hr_transaction_api.get_varchar2_value
3736: (p_transaction_step_id => p_transaction_step_id
3737: ,p_name => 'P_PQ_QUA_INFORMATION13'),
3738: hr_transaction_api.get_varchar2_value
3739: (p_transaction_step_id => p_transaction_step_id
3740: ,p_name => 'P_PQ_QUA_INFORMATION14'),
3741: hr_transaction_api.get_varchar2_value
3742: (p_transaction_step_id => p_transaction_step_id

Line 3741: hr_transaction_api.get_varchar2_value

3737: ,p_name => 'P_PQ_QUA_INFORMATION13'),
3738: hr_transaction_api.get_varchar2_value
3739: (p_transaction_step_id => p_transaction_step_id
3740: ,p_name => 'P_PQ_QUA_INFORMATION14'),
3741: hr_transaction_api.get_varchar2_value
3742: (p_transaction_step_id => p_transaction_step_id
3743: ,p_name => 'P_PQ_QUA_INFORMATION15'),
3744: hr_transaction_api.get_varchar2_value
3745: (p_transaction_step_id => p_transaction_step_id

Line 3744: hr_transaction_api.get_varchar2_value

3740: ,p_name => 'P_PQ_QUA_INFORMATION14'),
3741: hr_transaction_api.get_varchar2_value
3742: (p_transaction_step_id => p_transaction_step_id
3743: ,p_name => 'P_PQ_QUA_INFORMATION15'),
3744: hr_transaction_api.get_varchar2_value
3745: (p_transaction_step_id => p_transaction_step_id
3746: ,p_name => 'P_PQ_QUA_INFORMATION16'),
3747: hr_transaction_api.get_varchar2_value
3748: (p_transaction_step_id => p_transaction_step_id

Line 3747: hr_transaction_api.get_varchar2_value

3743: ,p_name => 'P_PQ_QUA_INFORMATION15'),
3744: hr_transaction_api.get_varchar2_value
3745: (p_transaction_step_id => p_transaction_step_id
3746: ,p_name => 'P_PQ_QUA_INFORMATION16'),
3747: hr_transaction_api.get_varchar2_value
3748: (p_transaction_step_id => p_transaction_step_id
3749: ,p_name => 'P_PQ_QUA_INFORMATION17'),
3750: hr_transaction_api.get_varchar2_value
3751: (p_transaction_step_id => p_transaction_step_id

Line 3750: hr_transaction_api.get_varchar2_value

3746: ,p_name => 'P_PQ_QUA_INFORMATION16'),
3747: hr_transaction_api.get_varchar2_value
3748: (p_transaction_step_id => p_transaction_step_id
3749: ,p_name => 'P_PQ_QUA_INFORMATION17'),
3750: hr_transaction_api.get_varchar2_value
3751: (p_transaction_step_id => p_transaction_step_id
3752: ,p_name => 'P_PQ_QUA_INFORMATION18'),
3753: hr_transaction_api.get_varchar2_value
3754: (p_transaction_step_id => p_transaction_step_id

Line 3753: hr_transaction_api.get_varchar2_value

3749: ,p_name => 'P_PQ_QUA_INFORMATION17'),
3750: hr_transaction_api.get_varchar2_value
3751: (p_transaction_step_id => p_transaction_step_id
3752: ,p_name => 'P_PQ_QUA_INFORMATION18'),
3753: hr_transaction_api.get_varchar2_value
3754: (p_transaction_step_id => p_transaction_step_id
3755: ,p_name => 'P_PQ_QUA_INFORMATION19'),
3756: hr_transaction_api.get_varchar2_value
3757: (p_transaction_step_id => p_transaction_step_id

Line 3756: hr_transaction_api.get_varchar2_value

3752: ,p_name => 'P_PQ_QUA_INFORMATION18'),
3753: hr_transaction_api.get_varchar2_value
3754: (p_transaction_step_id => p_transaction_step_id
3755: ,p_name => 'P_PQ_QUA_INFORMATION19'),
3756: hr_transaction_api.get_varchar2_value
3757: (p_transaction_step_id => p_transaction_step_id
3758: ,p_name => 'P_PQ_QUA_INFORMATION20'),
3759: null,null,null,null,
3760: /*hr_transaction_api.get_varchar2_value

Line 3760: /*hr_transaction_api.get_varchar2_value

3756: hr_transaction_api.get_varchar2_value
3757: (p_transaction_step_id => p_transaction_step_id
3758: ,p_name => 'P_PQ_QUA_INFORMATION20'),
3759: null,null,null,null,
3760: /*hr_transaction_api.get_varchar2_value
3761: (p_transaction_step_id => p_transaction_step_id
3762: ,p_name => 'P_PQ_PROFESSIONAL_BODY_NAME'),
3763: hr_transaction_api.get_varchar2_value
3764: (p_transaction_step_id => p_transaction_step_id

Line 3763: hr_transaction_api.get_varchar2_value

3759: null,null,null,null,
3760: /*hr_transaction_api.get_varchar2_value
3761: (p_transaction_step_id => p_transaction_step_id
3762: ,p_name => 'P_PQ_PROFESSIONAL_BODY_NAME'),
3763: hr_transaction_api.get_varchar2_value
3764: (p_transaction_step_id => p_transaction_step_id
3765: ,p_name => 'P_PQ_MEMBERSHIP_NUMBER'),
3766: hr_transaction_api.get_varchar2_value
3767: (p_transaction_step_id => p_transaction_step_id

Line 3766: hr_transaction_api.get_varchar2_value

3762: ,p_name => 'P_PQ_PROFESSIONAL_BODY_NAME'),
3763: hr_transaction_api.get_varchar2_value
3764: (p_transaction_step_id => p_transaction_step_id
3765: ,p_name => 'P_PQ_MEMBERSHIP_NUMBER'),
3766: hr_transaction_api.get_varchar2_value
3767: (p_transaction_step_id => p_transaction_step_id
3768: ,p_name => 'P_PQ_MEMBERSHIP_CATEGORY'),
3769: hr_transaction_api.get_varchar2_value
3770: (p_transaction_step_id => p_transaction_step_id

Line 3769: hr_transaction_api.get_varchar2_value

3765: ,p_name => 'P_PQ_MEMBERSHIP_NUMBER'),
3766: hr_transaction_api.get_varchar2_value
3767: (p_transaction_step_id => p_transaction_step_id
3768: ,p_name => 'P_PQ_MEMBERSHIP_CATEGORY'),
3769: hr_transaction_api.get_varchar2_value
3770: (p_transaction_step_id => p_transaction_step_id
3771: ,p_name => 'P_PQ_SUBS_PAYMENT_METHOD'),*/
3772: hr_transaction_api.get_number_value
3773: (p_transaction_step_id => p_transaction_step_id

Line 3772: hr_transaction_api.get_number_value

3768: ,p_name => 'P_PQ_MEMBERSHIP_CATEGORY'),
3769: hr_transaction_api.get_varchar2_value
3770: (p_transaction_step_id => p_transaction_step_id
3771: ,p_name => 'P_PQ_SUBS_PAYMENT_METHOD'),*/
3772: hr_transaction_api.get_number_value
3773: (p_transaction_step_id => p_transaction_step_id
3774: ,p_name => 'P_PARTY_ID')
3775: );
3776: END LOOP;

Line 3788: to_number(hr_transaction_api.get_varchar2_value

3784: FOR i IN 1..NVL(l_subject_count,0) LOOP
3785: p_qua_subjects.extend;
3786: p_qua_subjects(i) := SSHR_QUA_SUBJECT_OBJ_TYP(
3787:
3788: to_number(hr_transaction_api.get_varchar2_value
3789: (p_transaction_step_id => p_transaction_step_id
3790: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i)),
3791:
3792: hr_transaction_api.get_varchar2_value

Line 3792: hr_transaction_api.get_varchar2_value

3788: to_number(hr_transaction_api.get_varchar2_value
3789: (p_transaction_step_id => p_transaction_step_id
3790: ,p_name => 'P_SUBJECTS_TAKEN_ID'||i)),
3791:
3792: hr_transaction_api.get_varchar2_value
3793: (p_transaction_step_id => p_transaction_step_id
3794: ,p_name => 'P_PST_DELETE_FLAG'||i),
3795:
3796: hr_transaction_api.get_date_value

Line 3796: hr_transaction_api.get_date_value

3792: hr_transaction_api.get_varchar2_value
3793: (p_transaction_step_id => p_transaction_step_id
3794: ,p_name => 'P_PST_DELETE_FLAG'||i),
3795:
3796: hr_transaction_api.get_date_value
3797: (p_transaction_step_id => p_transaction_step_id
3798: ,p_name => 'P_PST_START_DATE'||i),
3799:
3800: hr_transaction_api.get_varchar2_value

Line 3800: hr_transaction_api.get_varchar2_value

3796: hr_transaction_api.get_date_value
3797: (p_transaction_step_id => p_transaction_step_id
3798: ,p_name => 'P_PST_START_DATE'||i),
3799:
3800: hr_transaction_api.get_varchar2_value
3801: (p_transaction_step_id => p_transaction_step_id
3802: ,p_name => 'P_PST_MAJOR'||i),
3803: hr_transaction_api.get_varchar2_value
3804: (p_transaction_step_id => p_transaction_step_id

Line 3803: hr_transaction_api.get_varchar2_value

3799:
3800: hr_transaction_api.get_varchar2_value
3801: (p_transaction_step_id => p_transaction_step_id
3802: ,p_name => 'P_PST_MAJOR'||i),
3803: hr_transaction_api.get_varchar2_value
3804: (p_transaction_step_id => p_transaction_step_id
3805: ,p_name => 'P_PST_SUBJECT_STATUS'||i),
3806:
3807: hr_transaction_api.get_varchar2_value

Line 3807: hr_transaction_api.get_varchar2_value

3803: hr_transaction_api.get_varchar2_value
3804: (p_transaction_step_id => p_transaction_step_id
3805: ,p_name => 'P_PST_SUBJECT_STATUS'||i),
3806:
3807: hr_transaction_api.get_varchar2_value
3808: (p_transaction_step_id => p_transaction_step_id
3809: ,p_name => 'P_PST_SUBJECT'||i),
3810:
3811: hr_transaction_api.get_varchar2_value

Line 3811: hr_transaction_api.get_varchar2_value

3807: hr_transaction_api.get_varchar2_value
3808: (p_transaction_step_id => p_transaction_step_id
3809: ,p_name => 'P_PST_SUBJECT'||i),
3810:
3811: hr_transaction_api.get_varchar2_value
3812: (p_transaction_step_id => p_transaction_step_id
3813: ,p_name => 'P_PST_GRADE_ATTAINED'||i),
3814:
3815: hr_transaction_api.get_date_value

Line 3815: hr_transaction_api.get_date_value

3811: hr_transaction_api.get_varchar2_value
3812: (p_transaction_step_id => p_transaction_step_id
3813: ,p_name => 'P_PST_GRADE_ATTAINED'||i),
3814:
3815: hr_transaction_api.get_date_value
3816: (p_transaction_step_id => p_transaction_step_id
3817: ,p_name => 'P_PST_END_DATE'||i),
3818:
3819: hr_transaction_api.get_number_value

Line 3819: hr_transaction_api.get_number_value

3815: hr_transaction_api.get_date_value
3816: (p_transaction_step_id => p_transaction_step_id
3817: ,p_name => 'P_PST_END_DATE'||i),
3818:
3819: hr_transaction_api.get_number_value
3820: (p_transaction_step_id => p_transaction_step_id
3821: ,p_name => 'P_QUALIFICATION_ID'),
3822:
3823: to_number(hr_transaction_api.get_varchar2_value

Line 3823: to_number(hr_transaction_api.get_varchar2_value

3819: hr_transaction_api.get_number_value
3820: (p_transaction_step_id => p_transaction_step_id
3821: ,p_name => 'P_QUALIFICATION_ID'),
3822:
3823: to_number(hr_transaction_api.get_varchar2_value
3824: (p_transaction_step_id => p_transaction_step_id
3825: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i)),
3826:
3827: hr_transaction_api.get_varchar2_value

Line 3827: hr_transaction_api.get_varchar2_value

3823: to_number(hr_transaction_api.get_varchar2_value
3824: (p_transaction_step_id => p_transaction_step_id
3825: ,p_name => 'P_PST_OBJECT_VERSION_NUMBER'||i)),
3826:
3827: hr_transaction_api.get_varchar2_value
3828: (p_transaction_step_id => p_transaction_step_id
3829: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i),
3830:
3831: hr_transaction_api.get_varchar2_value

Line 3831: hr_transaction_api.get_varchar2_value

3827: hr_transaction_api.get_varchar2_value
3828: (p_transaction_step_id => p_transaction_step_id
3829: ,p_name => 'P_PST_ATTRIBUTE_CATEGORY'||i),
3830:
3831: hr_transaction_api.get_varchar2_value
3832: (p_transaction_step_id => p_transaction_step_id
3833: ,p_name => 'P_ATTRIBUTE1_PST'||i),
3834:
3835: hr_transaction_api.get_varchar2_value

Line 3835: hr_transaction_api.get_varchar2_value

3831: hr_transaction_api.get_varchar2_value
3832: (p_transaction_step_id => p_transaction_step_id
3833: ,p_name => 'P_ATTRIBUTE1_PST'||i),
3834:
3835: hr_transaction_api.get_varchar2_value
3836: (p_transaction_step_id => p_transaction_step_id
3837: ,p_name => 'P_ATTRIBUTE2_PST'||i),
3838:
3839: hr_transaction_api.get_varchar2_value

Line 3839: hr_transaction_api.get_varchar2_value

3835: hr_transaction_api.get_varchar2_value
3836: (p_transaction_step_id => p_transaction_step_id
3837: ,p_name => 'P_ATTRIBUTE2_PST'||i),
3838:
3839: hr_transaction_api.get_varchar2_value
3840: (p_transaction_step_id => p_transaction_step_id
3841: ,p_name => 'P_ATTRIBUTE3_PST'||i),
3842:
3843: hr_transaction_api.get_varchar2_value

Line 3843: hr_transaction_api.get_varchar2_value

3839: hr_transaction_api.get_varchar2_value
3840: (p_transaction_step_id => p_transaction_step_id
3841: ,p_name => 'P_ATTRIBUTE3_PST'||i),
3842:
3843: hr_transaction_api.get_varchar2_value
3844: (p_transaction_step_id => p_transaction_step_id
3845: ,p_name => 'P_ATTRIBUTE4_PST'||i),
3846:
3847: hr_transaction_api.get_varchar2_value

Line 3847: hr_transaction_api.get_varchar2_value

3843: hr_transaction_api.get_varchar2_value
3844: (p_transaction_step_id => p_transaction_step_id
3845: ,p_name => 'P_ATTRIBUTE4_PST'||i),
3846:
3847: hr_transaction_api.get_varchar2_value
3848: (p_transaction_step_id => p_transaction_step_id
3849: ,p_name => 'P_ATTRIBUTE5_PST'||i),
3850:
3851: hr_transaction_api.get_varchar2_value

Line 3851: hr_transaction_api.get_varchar2_value

3847: hr_transaction_api.get_varchar2_value
3848: (p_transaction_step_id => p_transaction_step_id
3849: ,p_name => 'P_ATTRIBUTE5_PST'||i),
3850:
3851: hr_transaction_api.get_varchar2_value
3852: (p_transaction_step_id => p_transaction_step_id
3853: ,p_name => 'P_ATTRIBUTE6_PST'||i),
3854:
3855: hr_transaction_api.get_varchar2_value

Line 3855: hr_transaction_api.get_varchar2_value

3851: hr_transaction_api.get_varchar2_value
3852: (p_transaction_step_id => p_transaction_step_id
3853: ,p_name => 'P_ATTRIBUTE6_PST'||i),
3854:
3855: hr_transaction_api.get_varchar2_value
3856: (p_transaction_step_id => p_transaction_step_id
3857: ,p_name => 'P_ATTRIBUTE7_PST'||i),
3858:
3859: hr_transaction_api.get_varchar2_value

Line 3859: hr_transaction_api.get_varchar2_value

3855: hr_transaction_api.get_varchar2_value
3856: (p_transaction_step_id => p_transaction_step_id
3857: ,p_name => 'P_ATTRIBUTE7_PST'||i),
3858:
3859: hr_transaction_api.get_varchar2_value
3860: (p_transaction_step_id => p_transaction_step_id
3861: ,p_name => 'P_ATTRIBUTE8_PST'||i),
3862:
3863: hr_transaction_api.get_varchar2_value

Line 3863: hr_transaction_api.get_varchar2_value

3859: hr_transaction_api.get_varchar2_value
3860: (p_transaction_step_id => p_transaction_step_id
3861: ,p_name => 'P_ATTRIBUTE8_PST'||i),
3862:
3863: hr_transaction_api.get_varchar2_value
3864: (p_transaction_step_id => p_transaction_step_id
3865: ,p_name => 'P_ATTRIBUTE9_PST'||i),
3866:
3867: hr_transaction_api.get_varchar2_value

Line 3867: hr_transaction_api.get_varchar2_value

3863: hr_transaction_api.get_varchar2_value
3864: (p_transaction_step_id => p_transaction_step_id
3865: ,p_name => 'P_ATTRIBUTE9_PST'||i),
3866:
3867: hr_transaction_api.get_varchar2_value
3868: (p_transaction_step_id => p_transaction_step_id
3869: ,p_name => 'P_ATTRIBUTE10_PST'||i),
3870:
3871: hr_transaction_api.get_varchar2_value

Line 3871: hr_transaction_api.get_varchar2_value

3867: hr_transaction_api.get_varchar2_value
3868: (p_transaction_step_id => p_transaction_step_id
3869: ,p_name => 'P_ATTRIBUTE10_PST'||i),
3870:
3871: hr_transaction_api.get_varchar2_value
3872: (p_transaction_step_id => p_transaction_step_id
3873: ,p_name => 'P_ATTRIBUTE11_PST'||i),
3874:
3875: hr_transaction_api.get_varchar2_value

Line 3875: hr_transaction_api.get_varchar2_value

3871: hr_transaction_api.get_varchar2_value
3872: (p_transaction_step_id => p_transaction_step_id
3873: ,p_name => 'P_ATTRIBUTE11_PST'||i),
3874:
3875: hr_transaction_api.get_varchar2_value
3876: (p_transaction_step_id => p_transaction_step_id
3877: ,p_name => 'P_ATTRIBUTE12_PST'||i),
3878:
3879: hr_transaction_api.get_varchar2_value

Line 3879: hr_transaction_api.get_varchar2_value

3875: hr_transaction_api.get_varchar2_value
3876: (p_transaction_step_id => p_transaction_step_id
3877: ,p_name => 'P_ATTRIBUTE12_PST'||i),
3878:
3879: hr_transaction_api.get_varchar2_value
3880: (p_transaction_step_id => p_transaction_step_id
3881: ,p_name => 'P_ATTRIBUTE13_PST'||i),
3882:
3883: hr_transaction_api.get_varchar2_value

Line 3883: hr_transaction_api.get_varchar2_value

3879: hr_transaction_api.get_varchar2_value
3880: (p_transaction_step_id => p_transaction_step_id
3881: ,p_name => 'P_ATTRIBUTE13_PST'||i),
3882:
3883: hr_transaction_api.get_varchar2_value
3884: (p_transaction_step_id => p_transaction_step_id
3885: ,p_name => 'P_ATTRIBUTE14_PST'||i),
3886:
3887: hr_transaction_api.get_varchar2_value

Line 3887: hr_transaction_api.get_varchar2_value

3883: hr_transaction_api.get_varchar2_value
3884: (p_transaction_step_id => p_transaction_step_id
3885: ,p_name => 'P_ATTRIBUTE14_PST'||i),
3886:
3887: hr_transaction_api.get_varchar2_value
3888: (p_transaction_step_id => p_transaction_step_id
3889: ,p_name => 'P_ATTRIBUTE15_PST'||i),
3890:
3891: hr_transaction_api.get_varchar2_value

Line 3891: hr_transaction_api.get_varchar2_value

3887: hr_transaction_api.get_varchar2_value
3888: (p_transaction_step_id => p_transaction_step_id
3889: ,p_name => 'P_ATTRIBUTE15_PST'||i),
3890:
3891: hr_transaction_api.get_varchar2_value
3892: (p_transaction_step_id => p_transaction_step_id
3893: ,p_name => 'P_ATTRIBUTE16_PST'||i),
3894:
3895: hr_transaction_api.get_varchar2_value

Line 3895: hr_transaction_api.get_varchar2_value

3891: hr_transaction_api.get_varchar2_value
3892: (p_transaction_step_id => p_transaction_step_id
3893: ,p_name => 'P_ATTRIBUTE16_PST'||i),
3894:
3895: hr_transaction_api.get_varchar2_value
3896: (p_transaction_step_id => p_transaction_step_id
3897: ,p_name => 'P_ATTRIBUTE17_PST'||i),
3898:
3899: hr_transaction_api.get_varchar2_value

Line 3899: hr_transaction_api.get_varchar2_value

3895: hr_transaction_api.get_varchar2_value
3896: (p_transaction_step_id => p_transaction_step_id
3897: ,p_name => 'P_ATTRIBUTE17_PST'||i),
3898:
3899: hr_transaction_api.get_varchar2_value
3900: (p_transaction_step_id => p_transaction_step_id
3901: ,p_name => 'P_ATTRIBUTE18_PST'||i),
3902:
3903: hr_transaction_api.get_varchar2_value

Line 3903: hr_transaction_api.get_varchar2_value

3899: hr_transaction_api.get_varchar2_value
3900: (p_transaction_step_id => p_transaction_step_id
3901: ,p_name => 'P_ATTRIBUTE18_PST'||i),
3902:
3903: hr_transaction_api.get_varchar2_value
3904: (p_transaction_step_id => p_transaction_step_id
3905: ,p_name => 'P_ATTRIBUTE19_PST'||i),
3906:
3907: hr_transaction_api.get_varchar2_value

Line 3907: hr_transaction_api.get_varchar2_value

3903: hr_transaction_api.get_varchar2_value
3904: (p_transaction_step_id => p_transaction_step_id
3905: ,p_name => 'P_ATTRIBUTE19_PST'||i),
3906:
3907: hr_transaction_api.get_varchar2_value
3908: (p_transaction_step_id => p_transaction_step_id
3909: ,p_name => 'P_ATTRIBUTE20_PST'||i),
3910:
3911: hr_transaction_api.get_varchar2_value

Line 3911: hr_transaction_api.get_varchar2_value

3907: hr_transaction_api.get_varchar2_value
3908: (p_transaction_step_id => p_transaction_step_id
3909: ,p_name => 'P_ATTRIBUTE20_PST'||i),
3910:
3911: hr_transaction_api.get_varchar2_value
3912: (p_transaction_step_id => p_transaction_step_id
3913: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i),
3914:
3915: hr_transaction_api.get_varchar2_value

Line 3915: hr_transaction_api.get_varchar2_value

3911: hr_transaction_api.get_varchar2_value
3912: (p_transaction_step_id => p_transaction_step_id
3913: ,p_name => 'P_SUB_INFORMATION_CATEGORY'||i),
3914:
3915: hr_transaction_api.get_varchar2_value
3916: (p_transaction_step_id => p_transaction_step_id
3917: ,p_name => 'P_SUB_INFORMATION1_PST'||i),
3918:
3919: hr_transaction_api.get_varchar2_value

Line 3919: hr_transaction_api.get_varchar2_value

3915: hr_transaction_api.get_varchar2_value
3916: (p_transaction_step_id => p_transaction_step_id
3917: ,p_name => 'P_SUB_INFORMATION1_PST'||i),
3918:
3919: hr_transaction_api.get_varchar2_value
3920: (p_transaction_step_id => p_transaction_step_id
3921: ,p_name => 'P_SUB_INFORMATION2_PST'||i),
3922:
3923: hr_transaction_api.get_varchar2_value

Line 3923: hr_transaction_api.get_varchar2_value

3919: hr_transaction_api.get_varchar2_value
3920: (p_transaction_step_id => p_transaction_step_id
3921: ,p_name => 'P_SUB_INFORMATION2_PST'||i),
3922:
3923: hr_transaction_api.get_varchar2_value
3924: (p_transaction_step_id => p_transaction_step_id
3925: ,p_name => 'P_SUB_INFORMATION3_PST'||i),
3926:
3927: hr_transaction_api.get_varchar2_value

Line 3927: hr_transaction_api.get_varchar2_value

3923: hr_transaction_api.get_varchar2_value
3924: (p_transaction_step_id => p_transaction_step_id
3925: ,p_name => 'P_SUB_INFORMATION3_PST'||i),
3926:
3927: hr_transaction_api.get_varchar2_value
3928: (p_transaction_step_id => p_transaction_step_id
3929: ,p_name => 'P_SUB_INFORMATION4_PST'||i),
3930:
3931: hr_transaction_api.get_varchar2_value

Line 3931: hr_transaction_api.get_varchar2_value

3927: hr_transaction_api.get_varchar2_value
3928: (p_transaction_step_id => p_transaction_step_id
3929: ,p_name => 'P_SUB_INFORMATION4_PST'||i),
3930:
3931: hr_transaction_api.get_varchar2_value
3932: (p_transaction_step_id => p_transaction_step_id
3933: ,p_name => 'P_SUB_INFORMATION5_PST'||i),
3934:
3935: hr_transaction_api.get_varchar2_value

Line 3935: hr_transaction_api.get_varchar2_value

3931: hr_transaction_api.get_varchar2_value
3932: (p_transaction_step_id => p_transaction_step_id
3933: ,p_name => 'P_SUB_INFORMATION5_PST'||i),
3934:
3935: hr_transaction_api.get_varchar2_value
3936: (p_transaction_step_id => p_transaction_step_id
3937: ,p_name => 'P_SUB_INFORMATION6_PST'||i),
3938:
3939: hr_transaction_api.get_varchar2_value

Line 3939: hr_transaction_api.get_varchar2_value

3935: hr_transaction_api.get_varchar2_value
3936: (p_transaction_step_id => p_transaction_step_id
3937: ,p_name => 'P_SUB_INFORMATION6_PST'||i),
3938:
3939: hr_transaction_api.get_varchar2_value
3940: (p_transaction_step_id => p_transaction_step_id
3941: ,p_name => 'P_SUB_INFORMATION7_PST'||i),
3942:
3943: hr_transaction_api.get_varchar2_value

Line 3943: hr_transaction_api.get_varchar2_value

3939: hr_transaction_api.get_varchar2_value
3940: (p_transaction_step_id => p_transaction_step_id
3941: ,p_name => 'P_SUB_INFORMATION7_PST'||i),
3942:
3943: hr_transaction_api.get_varchar2_value
3944: (p_transaction_step_id => p_transaction_step_id
3945: ,p_name => 'P_SUB_INFORMATION8_PST'||i),
3946:
3947: hr_transaction_api.get_varchar2_value

Line 3947: hr_transaction_api.get_varchar2_value

3943: hr_transaction_api.get_varchar2_value
3944: (p_transaction_step_id => p_transaction_step_id
3945: ,p_name => 'P_SUB_INFORMATION8_PST'||i),
3946:
3947: hr_transaction_api.get_varchar2_value
3948: (p_transaction_step_id => p_transaction_step_id
3949: ,p_name => 'P_SUB_INFORMATION9_PST'||i),
3950:
3951: hr_transaction_api.get_varchar2_value

Line 3951: hr_transaction_api.get_varchar2_value

3947: hr_transaction_api.get_varchar2_value
3948: (p_transaction_step_id => p_transaction_step_id
3949: ,p_name => 'P_SUB_INFORMATION9_PST'||i),
3950:
3951: hr_transaction_api.get_varchar2_value
3952: (p_transaction_step_id => p_transaction_step_id
3953: ,p_name => 'P_SUB_INFORMATION10_PST'||i),
3954:
3955: hr_transaction_api.get_varchar2_value

Line 3955: hr_transaction_api.get_varchar2_value

3951: hr_transaction_api.get_varchar2_value
3952: (p_transaction_step_id => p_transaction_step_id
3953: ,p_name => 'P_SUB_INFORMATION10_PST'||i),
3954:
3955: hr_transaction_api.get_varchar2_value
3956: (p_transaction_step_id => p_transaction_step_id
3957: ,p_name => 'P_SUB_INFORMATION11_PST'||i),
3958:
3959: hr_transaction_api.get_varchar2_value

Line 3959: hr_transaction_api.get_varchar2_value

3955: hr_transaction_api.get_varchar2_value
3956: (p_transaction_step_id => p_transaction_step_id
3957: ,p_name => 'P_SUB_INFORMATION11_PST'||i),
3958:
3959: hr_transaction_api.get_varchar2_value
3960: (p_transaction_step_id => p_transaction_step_id
3961: ,p_name => 'P_SUB_INFORMATION12_PST'||i),
3962:
3963: hr_transaction_api.get_varchar2_value

Line 3963: hr_transaction_api.get_varchar2_value

3959: hr_transaction_api.get_varchar2_value
3960: (p_transaction_step_id => p_transaction_step_id
3961: ,p_name => 'P_SUB_INFORMATION12_PST'||i),
3962:
3963: hr_transaction_api.get_varchar2_value
3964: (p_transaction_step_id => p_transaction_step_id
3965: ,p_name => 'P_SUB_INFORMATION13_PST'||i),
3966:
3967: hr_transaction_api.get_varchar2_value

Line 3967: hr_transaction_api.get_varchar2_value

3963: hr_transaction_api.get_varchar2_value
3964: (p_transaction_step_id => p_transaction_step_id
3965: ,p_name => 'P_SUB_INFORMATION13_PST'||i),
3966:
3967: hr_transaction_api.get_varchar2_value
3968: (p_transaction_step_id => p_transaction_step_id
3969: ,p_name => 'P_SUB_INFORMATION14_PST'||i),
3970:
3971: hr_transaction_api.get_varchar2_value

Line 3971: hr_transaction_api.get_varchar2_value

3967: hr_transaction_api.get_varchar2_value
3968: (p_transaction_step_id => p_transaction_step_id
3969: ,p_name => 'P_SUB_INFORMATION14_PST'||i),
3970:
3971: hr_transaction_api.get_varchar2_value
3972: (p_transaction_step_id => p_transaction_step_id
3973: ,p_name => 'P_SUB_INFORMATION15_PST'||i),
3974:
3975: hr_transaction_api.get_varchar2_value

Line 3975: hr_transaction_api.get_varchar2_value

3971: hr_transaction_api.get_varchar2_value
3972: (p_transaction_step_id => p_transaction_step_id
3973: ,p_name => 'P_SUB_INFORMATION15_PST'||i),
3974:
3975: hr_transaction_api.get_varchar2_value
3976: (p_transaction_step_id => p_transaction_step_id
3977: ,p_name => 'P_SUB_INFORMATION16_PST'||i),
3978:
3979: hr_transaction_api.get_varchar2_value

Line 3979: hr_transaction_api.get_varchar2_value

3975: hr_transaction_api.get_varchar2_value
3976: (p_transaction_step_id => p_transaction_step_id
3977: ,p_name => 'P_SUB_INFORMATION16_PST'||i),
3978:
3979: hr_transaction_api.get_varchar2_value
3980: (p_transaction_step_id => p_transaction_step_id
3981: ,p_name => 'P_SUB_INFORMATION17_PST'||i),
3982:
3983: hr_transaction_api.get_varchar2_value

Line 3983: hr_transaction_api.get_varchar2_value

3979: hr_transaction_api.get_varchar2_value
3980: (p_transaction_step_id => p_transaction_step_id
3981: ,p_name => 'P_SUB_INFORMATION17_PST'||i),
3982:
3983: hr_transaction_api.get_varchar2_value
3984: (p_transaction_step_id => p_transaction_step_id
3985: ,p_name => 'P_SUB_INFORMATION18_PST'||i),
3986:
3987: hr_transaction_api.get_varchar2_value

Line 3987: hr_transaction_api.get_varchar2_value

3983: hr_transaction_api.get_varchar2_value
3984: (p_transaction_step_id => p_transaction_step_id
3985: ,p_name => 'P_SUB_INFORMATION18_PST'||i),
3986:
3987: hr_transaction_api.get_varchar2_value
3988: (p_transaction_step_id => p_transaction_step_id
3989: ,p_name => 'P_SUB_INFORMATION19_PST'||i),
3990:
3991: hr_transaction_api.get_varchar2_value

Line 3991: hr_transaction_api.get_varchar2_value

3987: hr_transaction_api.get_varchar2_value
3988: (p_transaction_step_id => p_transaction_step_id
3989: ,p_name => 'P_SUB_INFORMATION19_PST'||i),
3990:
3991: hr_transaction_api.get_varchar2_value
3992: (p_transaction_step_id => p_transaction_step_id
3993: ,p_name => 'P_SUB_INFORMATION20_PST'||i)
3994: );
3995:

Line 4039: hr_transaction_api.get_varchar2_value

4035: Begin
4036:
4037: hr_utility.set_location('Entering:'||l_proc, 5);
4038: l_qualification_id :=
4039: hr_transaction_api.get_varchar2_value
4040: (p_transaction_step_id => p_transaction_step_id
4041: ,p_name => 'p_qualification_id');
4042:
4043: hr_utility.set_location('Exiting:'||l_proc, 15);