eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on HR_TRANSACTION_API

Line 102: hr_transaction_api.create_transaction_step

98: END IF;
99: --
100: -- Create a transaction step
101: --
102: hr_transaction_api.create_transaction_step
103: (p_validate => false
104: ,p_creator_person_id => nvl(p_login_person_id, p_parent_id)
105: ,p_transaction_id => l_transaction_id
106: ,p_api_name => g_package || '.PROCESS_API'

Line 1284: hr_transaction_api.get_transaction_step_info

1280: -----------------------------------------------------------------------------
1281: -- For a given item key, there could be multiple transaction steps saved.
1282:
1283: hr_utility.set_location('Entering:'||l_proc, 5);
1284: hr_transaction_api.get_transaction_step_info
1285: (p_item_type => p_item_type
1286: ,p_item_key => p_item_key
1287: ,p_activity_id => p_activity_id
1288: ,p_transaction_step_id => l_trans_step_ids

Line 1296: -- in hr_transaction_api.get_transaction_step_info.

1292: --
1293: -- ---------------------------------------------------------------------
1294: -- NOTE:We need to adjust the index which referrences l_trans_step_ids
1295: -- by 1 because that table was created with the index starts at 0
1296: -- in hr_transaction_api.get_transaction_step_info.
1297: -- ---------------------------------------------------------------------
1298: --
1299: ln_index := 0;
1300:

Line 1315: l_dummy := hr_transaction_api.get_number_Value

1311: -- determine whether the step is of phone or not use a
1312: -- direct cursor.
1313: --
1314: /*
1315: l_dummy := hr_transaction_api.get_number_Value
1316: (p_transaction_step_id =>
1317: l_trans_step_ids(ln_index)
1318: ,p_name => 'P_PHONE_ID');
1319: */

Line 1378: p_person_id := hr_transaction_api.get_number_value

1374:
1375:
1376: --
1377: hr_utility.set_location('Entering:'||l_proc, 5);
1378: p_person_id := hr_transaction_api.get_number_value
1379: (p_transaction_step_id => p_transaction_step_id
1380: ,p_name => 'P_PERSON_ID');
1381: --
1382: l_phone_id := hr_transaction_api.get_number_value

Line 1382: l_phone_id := hr_transaction_api.get_number_value

1378: p_person_id := hr_transaction_api.get_number_value
1379: (p_transaction_step_id => p_transaction_step_id
1380: ,p_name => 'P_PERSON_ID');
1381: --
1382: l_phone_id := hr_transaction_api.get_number_value
1383: (p_transaction_step_id => p_transaction_step_id
1384: ,p_name => 'P_PHONE_ID');
1385: --
1386: l_phone_type := hr_transaction_api.get_varchar2_value

Line 1386: l_phone_type := hr_transaction_api.get_varchar2_value

1382: l_phone_id := hr_transaction_api.get_number_value
1383: (p_transaction_step_id => p_transaction_step_id
1384: ,p_name => 'P_PHONE_ID');
1385: --
1386: l_phone_type := hr_transaction_api.get_varchar2_value
1387: (p_transaction_step_id => p_transaction_step_id
1388: ,p_name => 'P_PHONE_TYPE');
1389: --
1390: l_phone_type_meaning := hr_transaction_api.get_varchar2_Value

Line 1390: l_phone_type_meaning := hr_transaction_api.get_varchar2_Value

1386: l_phone_type := hr_transaction_api.get_varchar2_value
1387: (p_transaction_step_id => p_transaction_step_id
1388: ,p_name => 'P_PHONE_TYPE');
1389: --
1390: l_phone_type_meaning := hr_transaction_api.get_varchar2_Value
1391: (p_transaction_step_id => p_transaction_step_id
1392: ,p_name => 'P_PHONE_TYPE_MEANING');
1393: --
1394: l_phone_number := hr_transaction_api.get_varchar2_value

Line 1394: l_phone_number := hr_transaction_api.get_varchar2_value

1390: l_phone_type_meaning := hr_transaction_api.get_varchar2_Value
1391: (p_transaction_step_id => p_transaction_step_id
1392: ,p_name => 'P_PHONE_TYPE_MEANING');
1393: --
1394: l_phone_number := hr_transaction_api.get_varchar2_value
1395: (p_transaction_step_id => p_transaction_step_id
1396: ,p_name => 'P_PHONE_NUMBER');
1397: --
1398: l_object_version_number := hr_transaction_api.get_number_value

Line 1398: l_object_version_number := hr_transaction_api.get_number_value

1394: l_phone_number := hr_transaction_api.get_varchar2_value
1395: (p_transaction_step_id => p_transaction_step_id
1396: ,p_name => 'P_PHONE_NUMBER');
1397: --
1398: l_object_version_number := hr_transaction_api.get_number_value
1399: (p_transaction_step_id => p_transaction_step_id
1400: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1401: --
1402: --StartRegistration

Line 1405: l_contact_set := hr_transaction_api.get_varchar2_value

1401: --
1402: --StartRegistration
1403: --
1404: begin
1405: l_contact_set := hr_transaction_api.get_varchar2_value
1406: (p_transaction_step_id => p_transaction_step_id
1407: ,p_name => 'P_CONTACT_SET');
1408: exception
1409: when others then

Line 1471: hr_transaction_api.get_transaction_step_info

1467: -----------------------------------------------------------------------------
1468: -- For a given item key, there could be multiple transaction steps saved.
1469:
1470: hr_utility.set_location('Entering:'||l_proc, 5);
1471: hr_transaction_api.get_transaction_step_info
1472: (p_item_type => p_item_type
1473: ,p_item_key => p_item_key
1474: ,p_activity_id => p_activity_id
1475: ,p_transaction_step_id => l_trans_step_ids

Line 1483: -- in hr_transaction_api.get_transaction_step_info.

1479: --
1480: -- ---------------------------------------------------------------------
1481: -- NOTE:We need to adjust the index which referrences l_trans_step_ids
1482: -- by 1 because that table was created with the index starts at 0
1483: -- in hr_transaction_api.get_transaction_step_info.
1484: -- ---------------------------------------------------------------------
1485: --
1486: ln_index := 0;
1487:

Line 1499: p_person_id := hr_transaction_api.get_number_value

1495: BEGIN
1496: FOR l_rec in csr_hatv(l_trans_step_ids(ln_index), 'P_PHONE_ID')
1497: LOOP
1498: ----
1499: p_person_id := hr_transaction_api.get_number_value
1500: (p_transaction_step_id => l_trans_step_ids(ln_index)
1501: ,p_name => 'P_PERSON_ID');
1502: --
1503: p_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value

Line 1503: p_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value

1499: p_person_id := hr_transaction_api.get_number_value
1500: (p_transaction_step_id => l_trans_step_ids(ln_index)
1501: ,p_name => 'P_PERSON_ID');
1502: --
1503: p_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value
1504: (p_transaction_step_id => l_trans_step_ids(ln_index)
1505: ,p_name => 'P_PHONE_ID'), 0));
1506: --
1507: p_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value

Line 1507: p_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value

1503: p_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value
1504: (p_transaction_step_id => l_trans_step_ids(ln_index)
1505: ,p_name => 'P_PHONE_ID'), 0));
1506: --
1507: p_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value
1508: (p_transaction_step_id => l_trans_step_ids(ln_index)
1509: ,p_name => 'P_PHONE_TYPE');
1510: --
1511: p_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value

Line 1511: p_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value

1507: p_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value
1508: (p_transaction_step_id => l_trans_step_ids(ln_index)
1509: ,p_name => 'P_PHONE_TYPE');
1510: --
1511: p_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value
1512: (p_transaction_step_id => l_trans_step_ids(ln_index)
1513: ,p_name => 'P_PHONE_TYPE_MEANING');
1514: --
1515: p_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value

Line 1515: p_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value

1511: p_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value
1512: (p_transaction_step_id => l_trans_step_ids(ln_index)
1513: ,p_name => 'P_PHONE_TYPE_MEANING');
1514: --
1515: p_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value
1516: (p_transaction_step_id => l_trans_step_ids(ln_index)
1517: ,p_name => 'P_PHONE_NUMBER');
1518: --
1519: p_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value

Line 1519: p_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value

1515: p_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value
1516: (p_transaction_step_id => l_trans_step_ids(ln_index)
1517: ,p_name => 'P_PHONE_NUMBER');
1518: --
1519: p_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value
1520: (p_transaction_step_id => l_trans_step_ids(ln_index)
1521: ,p_name => 'P_OBJECT_VERSION_NUMBER'), 0));
1522:
1523: p_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value

Line 1523: p_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value

1519: p_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value
1520: (p_transaction_step_id => l_trans_step_ids(ln_index)
1521: ,p_name => 'P_OBJECT_VERSION_NUMBER'), 0));
1522:
1523: p_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value
1524: (p_transaction_step_id => l_trans_step_ids(ln_index)
1525: ,p_name => 'P_ATTRIBUTE_CATEGORY');
1526: --
1527: p_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value

Line 1527: p_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value

1523: p_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value
1524: (p_transaction_step_id => l_trans_step_ids(ln_index)
1525: ,p_name => 'P_ATTRIBUTE_CATEGORY');
1526: --
1527: p_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value
1528: (p_transaction_step_id => l_trans_step_ids(ln_index)
1529: ,p_name => 'P_ATTRIBUTE1');
1530: --
1531: p_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value

Line 1531: p_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value

1527: p_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value
1528: (p_transaction_step_id => l_trans_step_ids(ln_index)
1529: ,p_name => 'P_ATTRIBUTE1');
1530: --
1531: p_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value
1532: (p_transaction_step_id => l_trans_step_ids(ln_index)
1533: ,p_name => 'P_ATTRIBUTE2');
1534: --
1535: p_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value

Line 1535: p_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value

1531: p_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value
1532: (p_transaction_step_id => l_trans_step_ids(ln_index)
1533: ,p_name => 'P_ATTRIBUTE2');
1534: --
1535: p_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value
1536: (p_transaction_step_id => l_trans_step_ids(ln_index)
1537: ,p_name => 'P_ATTRIBUTE3');
1538: --
1539: p_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value

Line 1539: p_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value

1535: p_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value
1536: (p_transaction_step_id => l_trans_step_ids(ln_index)
1537: ,p_name => 'P_ATTRIBUTE3');
1538: --
1539: p_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value
1540: (p_transaction_step_id => l_trans_step_ids(ln_index)
1541: ,p_name => 'P_ATTRIBUTE4');
1542: --
1543: p_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value

Line 1543: p_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value

1539: p_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value
1540: (p_transaction_step_id => l_trans_step_ids(ln_index)
1541: ,p_name => 'P_ATTRIBUTE4');
1542: --
1543: p_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value
1544: (p_transaction_step_id => l_trans_step_ids(ln_index)
1545: ,p_name => 'P_ATTRIBUTE5');
1546: --
1547: p_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value

Line 1547: p_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value

1543: p_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value
1544: (p_transaction_step_id => l_trans_step_ids(ln_index)
1545: ,p_name => 'P_ATTRIBUTE5');
1546: --
1547: p_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value
1548: (p_transaction_step_id => l_trans_step_ids(ln_index)
1549: ,p_name => 'P_ATTRIBUTE6');
1550: --
1551: p_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value

Line 1551: p_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value

1547: p_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value
1548: (p_transaction_step_id => l_trans_step_ids(ln_index)
1549: ,p_name => 'P_ATTRIBUTE6');
1550: --
1551: p_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value
1552: (p_transaction_step_id => l_trans_step_ids(ln_index)
1553: ,p_name => 'P_ATTRIBUTE7');
1554: --
1555: p_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value

Line 1555: p_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value

1551: p_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value
1552: (p_transaction_step_id => l_trans_step_ids(ln_index)
1553: ,p_name => 'P_ATTRIBUTE7');
1554: --
1555: p_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value
1556: (p_transaction_step_id => l_trans_step_ids(ln_index)
1557: ,p_name => 'P_ATTRIBUTE8');
1558: --
1559: p_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value

Line 1559: p_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value

1555: p_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value
1556: (p_transaction_step_id => l_trans_step_ids(ln_index)
1557: ,p_name => 'P_ATTRIBUTE8');
1558: --
1559: p_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value
1560: (p_transaction_step_id => l_trans_step_ids(ln_index)
1561: ,p_name => 'P_ATTRIBUTE9');
1562: --
1563: p_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value

Line 1563: p_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value

1559: p_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value
1560: (p_transaction_step_id => l_trans_step_ids(ln_index)
1561: ,p_name => 'P_ATTRIBUTE9');
1562: --
1563: p_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value
1564: (p_transaction_step_id => l_trans_step_ids(ln_index)
1565: ,p_name => 'P_ATTRIBUTE10');
1566: --
1567: p_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value

Line 1567: p_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value

1563: p_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value
1564: (p_transaction_step_id => l_trans_step_ids(ln_index)
1565: ,p_name => 'P_ATTRIBUTE10');
1566: --
1567: p_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value
1568: (p_transaction_step_id => l_trans_step_ids(ln_index)
1569: ,p_name => 'P_ATTRIBUTE11');
1570: --
1571: p_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value

Line 1571: p_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value

1567: p_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value
1568: (p_transaction_step_id => l_trans_step_ids(ln_index)
1569: ,p_name => 'P_ATTRIBUTE11');
1570: --
1571: p_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value
1572: (p_transaction_step_id => l_trans_step_ids(ln_index)
1573: ,p_name => 'P_ATTRIBUTE12');
1574: --
1575: p_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value

Line 1575: p_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value

1571: p_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value
1572: (p_transaction_step_id => l_trans_step_ids(ln_index)
1573: ,p_name => 'P_ATTRIBUTE12');
1574: --
1575: p_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value
1576: (p_transaction_step_id => l_trans_step_ids(ln_index)
1577: ,p_name => 'P_ATTRIBUTE13');
1578: --
1579: p_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value

Line 1579: p_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value

1575: p_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value
1576: (p_transaction_step_id => l_trans_step_ids(ln_index)
1577: ,p_name => 'P_ATTRIBUTE13');
1578: --
1579: p_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value
1580: (p_transaction_step_id => l_trans_step_ids(ln_index)
1581: ,p_name => 'P_ATTRIBUTE14');
1582: --
1583: p_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value

Line 1583: p_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value

1579: p_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value
1580: (p_transaction_step_id => l_trans_step_ids(ln_index)
1581: ,p_name => 'P_ATTRIBUTE14');
1582: --
1583: p_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value
1584: (p_transaction_step_id => l_trans_step_ids(ln_index)
1585: ,p_name => 'P_ATTRIBUTE15');
1586: --
1587: p_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value

Line 1587: p_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value

1583: p_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value
1584: (p_transaction_step_id => l_trans_step_ids(ln_index)
1585: ,p_name => 'P_ATTRIBUTE15');
1586: --
1587: p_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value
1588: (p_transaction_step_id => l_trans_step_ids(ln_index)
1589: ,p_name => 'P_ATTRIBUTE16');
1590: --
1591: p_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value

Line 1591: p_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value

1587: p_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value
1588: (p_transaction_step_id => l_trans_step_ids(ln_index)
1589: ,p_name => 'P_ATTRIBUTE16');
1590: --
1591: p_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value
1592: (p_transaction_step_id => l_trans_step_ids(ln_index)
1593: ,p_name => 'P_ATTRIBUTE17');
1594: --
1595: p_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value

Line 1595: p_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value

1591: p_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value
1592: (p_transaction_step_id => l_trans_step_ids(ln_index)
1593: ,p_name => 'P_ATTRIBUTE17');
1594: --
1595: p_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value
1596: (p_transaction_step_id => l_trans_step_ids(ln_index)
1597: ,p_name => 'P_ATTRIBUTE18');
1598: --
1599: p_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value

Line 1599: p_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value

1595: p_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value
1596: (p_transaction_step_id => l_trans_step_ids(ln_index)
1597: ,p_name => 'P_ATTRIBUTE18');
1598: --
1599: p_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value
1600: (p_transaction_step_id => l_trans_step_ids(ln_index)
1601: ,p_name => 'P_ATTRIBUTE19');
1602: --
1603: p_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value

Line 1603: p_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value

1599: p_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value
1600: (p_transaction_step_id => l_trans_step_ids(ln_index)
1601: ,p_name => 'P_ATTRIBUTE19');
1602: --
1603: p_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value
1604: (p_transaction_step_id => l_trans_step_ids(ln_index)
1605: ,p_name => 'P_ATTRIBUTE20');
1606: --
1607: p_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value

Line 1607: p_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value

1603: p_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value
1604: (p_transaction_step_id => l_trans_step_ids(ln_index)
1605: ,p_name => 'P_ATTRIBUTE20');
1606: --
1607: p_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value
1608: (p_transaction_step_id => l_trans_step_ids(ln_index)
1609: ,p_name => 'P_ATTRIBUTE21');
1610: --
1611: p_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value

Line 1611: p_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value

1607: p_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value
1608: (p_transaction_step_id => l_trans_step_ids(ln_index)
1609: ,p_name => 'P_ATTRIBUTE21');
1610: --
1611: p_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value
1612: (p_transaction_step_id => l_trans_step_ids(ln_index)
1613: ,p_name => 'P_ATTRIBUTE22');
1614: --
1615: p_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value

Line 1615: p_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value

1611: p_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value
1612: (p_transaction_step_id => l_trans_step_ids(ln_index)
1613: ,p_name => 'P_ATTRIBUTE22');
1614: --
1615: p_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value
1616: (p_transaction_step_id => l_trans_step_ids(ln_index)
1617: ,p_name => 'P_ATTRIBUTE23');
1618: --
1619: p_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value

Line 1619: p_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value

1615: p_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value
1616: (p_transaction_step_id => l_trans_step_ids(ln_index)
1617: ,p_name => 'P_ATTRIBUTE23');
1618: --
1619: p_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value
1620: (p_transaction_step_id => l_trans_step_ids(ln_index)
1621: ,p_name => 'P_ATTRIBUTE24');
1622: --
1623: p_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value

Line 1623: p_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value

1619: p_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value
1620: (p_transaction_step_id => l_trans_step_ids(ln_index)
1621: ,p_name => 'P_ATTRIBUTE24');
1622: --
1623: p_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value
1624: (p_transaction_step_id => l_trans_step_ids(ln_index)
1625: ,p_name => 'P_ATTRIBUTE25');
1626: --
1627: p_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value

Line 1627: p_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value

1623: p_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value
1624: (p_transaction_step_id => l_trans_step_ids(ln_index)
1625: ,p_name => 'P_ATTRIBUTE25');
1626: --
1627: p_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value
1628: (p_transaction_step_id => l_trans_step_ids(ln_index)
1629: ,p_name => 'P_ATTRIBUTE26');
1630: --
1631: p_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value

Line 1631: p_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value

1627: p_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value
1628: (p_transaction_step_id => l_trans_step_ids(ln_index)
1629: ,p_name => 'P_ATTRIBUTE26');
1630: --
1631: p_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value
1632: (p_transaction_step_id => l_trans_step_ids(ln_index)
1633: ,p_name => 'P_ATTRIBUTE27');
1634: --
1635: p_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value

Line 1635: p_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value

1631: p_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value
1632: (p_transaction_step_id => l_trans_step_ids(ln_index)
1633: ,p_name => 'P_ATTRIBUTE27');
1634: --
1635: p_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value
1636: (p_transaction_step_id => l_trans_step_ids(ln_index)
1637: ,p_name => 'P_ATTRIBUTE28');
1638: --
1639: p_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value

Line 1639: p_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value

1635: p_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value
1636: (p_transaction_step_id => l_trans_step_ids(ln_index)
1637: ,p_name => 'P_ATTRIBUTE28');
1638: --
1639: p_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value
1640: (p_transaction_step_id => l_trans_step_ids(ln_index)
1641: ,p_name => 'P_ATTRIBUTE29');
1642: --
1643: p_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value

Line 1643: p_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value

1639: p_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value
1640: (p_transaction_step_id => l_trans_step_ids(ln_index)
1641: ,p_name => 'P_ATTRIBUTE29');
1642: --
1643: p_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value
1644: (p_transaction_step_id => l_trans_step_ids(ln_index)
1645: ,p_name => 'P_ATTRIBUTE30');
1646: --
1647: p_phone_numbers_details(i).parent_id := hr_transaction_api.get_number_value

Line 1647: p_phone_numbers_details(i).parent_id := hr_transaction_api.get_number_value

1643: p_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value
1644: (p_transaction_step_id => l_trans_step_ids(ln_index)
1645: ,p_name => 'P_ATTRIBUTE30');
1646: --
1647: p_phone_numbers_details(i).parent_id := hr_transaction_api.get_number_value
1648: (p_transaction_step_id => l_trans_step_ids(ln_index)
1649: ,p_name => 'P_PERSON_ID');
1650:
1651: i := i + 1;

Line 1711: hr_transaction_api.get_transaction_step_info

1707: -----------------------------------------------------------------------------
1708: -- For a given item key, there could be multiple transaction steps saved.
1709:
1710: hr_utility.set_location('Entering:'||l_proc, 5);
1711: hr_transaction_api.get_transaction_step_info
1712: (p_item_type => p_item_type
1713: ,p_item_key => p_item_key
1714: ,p_activity_id => p_activity_id
1715: ,p_transaction_step_id => l_trans_step_ids

Line 1723: -- in hr_transaction_api.get_transaction_step_info.

1719: --
1720: -- ---------------------------------------------------------------------
1721: -- NOTE:We need to adjust the index which referrences l_trans_step_ids
1722: -- by 1 because that table was created with the index starts at 0
1723: -- in hr_transaction_api.get_transaction_step_info.
1724: -- ---------------------------------------------------------------------
1725: --
1726: ln_index := 0;
1727:

Line 1739: p_person_id := hr_transaction_api.get_number_value

1735: BEGIN
1736: FOR l_rec in csr_hatv(l_trans_step_ids(ln_index), 'P_PHONE_ID')
1737: LOOP
1738: ----
1739: p_person_id := hr_transaction_api.get_number_value
1740: (p_transaction_step_id => l_trans_step_ids(ln_index)
1741: ,p_name => 'P_PERSON_ID');
1742: --
1743: p_con_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value

Line 1743: p_con_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value

1739: p_person_id := hr_transaction_api.get_number_value
1740: (p_transaction_step_id => l_trans_step_ids(ln_index)
1741: ,p_name => 'P_PERSON_ID');
1742: --
1743: p_con_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value
1744: (p_transaction_step_id => l_trans_step_ids(ln_index)
1745: ,p_name => 'P_PHONE_ID'), 0));
1746: --
1747: p_con_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value

Line 1747: p_con_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value

1743: p_con_phone_numbers_details(i).phone_id := to_char(nvl(hr_transaction_api.get_number_value
1744: (p_transaction_step_id => l_trans_step_ids(ln_index)
1745: ,p_name => 'P_PHONE_ID'), 0));
1746: --
1747: p_con_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value
1748: (p_transaction_step_id => l_trans_step_ids(ln_index)
1749: ,p_name => 'P_PHONE_TYPE');
1750: --
1751: p_con_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value

Line 1751: p_con_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value

1747: p_con_phone_numbers_details(i).phone_type := hr_transaction_api.get_varchar2_value
1748: (p_transaction_step_id => l_trans_step_ids(ln_index)
1749: ,p_name => 'P_PHONE_TYPE');
1750: --
1751: p_con_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value
1752: (p_transaction_step_id => l_trans_step_ids(ln_index)
1753: ,p_name => 'P_PHONE_TYPE_MEANING');
1754: --
1755: p_con_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value

Line 1755: p_con_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value

1751: p_con_phone_numbers_details(i).phone_type_meaning := hr_transaction_api.get_varchar2_Value
1752: (p_transaction_step_id => l_trans_step_ids(ln_index)
1753: ,p_name => 'P_PHONE_TYPE_MEANING');
1754: --
1755: p_con_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value
1756: (p_transaction_step_id => l_trans_step_ids(ln_index)
1757: ,p_name => 'P_PHONE_NUMBER');
1758: --
1759: p_con_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value

Line 1759: p_con_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value

1755: p_con_phone_numbers_details(i).phone_number := hr_transaction_api.get_varchar2_value
1756: (p_transaction_step_id => l_trans_step_ids(ln_index)
1757: ,p_name => 'P_PHONE_NUMBER');
1758: --
1759: p_con_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value
1760: (p_transaction_step_id => l_trans_step_ids(ln_index)
1761: ,p_name => 'P_OBJECT_VERSION_NUMBER'), 0));
1762:
1763: p_con_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value

Line 1763: p_con_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value

1759: p_con_phone_numbers_details(i).object_version_number := to_char(nvl(hr_transaction_api.get_number_value
1760: (p_transaction_step_id => l_trans_step_ids(ln_index)
1761: ,p_name => 'P_OBJECT_VERSION_NUMBER'), 0));
1762:
1763: p_con_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value
1764: (p_transaction_step_id => l_trans_step_ids(ln_index)
1765: ,p_name => 'P_ATTRIBUTE_CATEGORY');
1766: --
1767: p_con_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value

Line 1767: p_con_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value

1763: p_con_phone_numbers_details(i).attribute_category := hr_transaction_api.get_varchar2_Value
1764: (p_transaction_step_id => l_trans_step_ids(ln_index)
1765: ,p_name => 'P_ATTRIBUTE_CATEGORY');
1766: --
1767: p_con_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value
1768: (p_transaction_step_id => l_trans_step_ids(ln_index)
1769: ,p_name => 'P_ATTRIBUTE1');
1770: --
1771: p_con_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value

Line 1771: p_con_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value

1767: p_con_phone_numbers_details(i).attribute1 := hr_transaction_api.get_varchar2_Value
1768: (p_transaction_step_id => l_trans_step_ids(ln_index)
1769: ,p_name => 'P_ATTRIBUTE1');
1770: --
1771: p_con_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value
1772: (p_transaction_step_id => l_trans_step_ids(ln_index)
1773: ,p_name => 'P_ATTRIBUTE2');
1774: --
1775: p_con_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value

Line 1775: p_con_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value

1771: p_con_phone_numbers_details(i).attribute2 := hr_transaction_api.get_varchar2_Value
1772: (p_transaction_step_id => l_trans_step_ids(ln_index)
1773: ,p_name => 'P_ATTRIBUTE2');
1774: --
1775: p_con_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value
1776: (p_transaction_step_id => l_trans_step_ids(ln_index)
1777: ,p_name => 'P_ATTRIBUTE3');
1778: --
1779: p_con_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value

Line 1779: p_con_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value

1775: p_con_phone_numbers_details(i).attribute3 := hr_transaction_api.get_varchar2_Value
1776: (p_transaction_step_id => l_trans_step_ids(ln_index)
1777: ,p_name => 'P_ATTRIBUTE3');
1778: --
1779: p_con_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value
1780: (p_transaction_step_id => l_trans_step_ids(ln_index)
1781: ,p_name => 'P_ATTRIBUTE4');
1782: --
1783: p_con_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value

Line 1783: p_con_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value

1779: p_con_phone_numbers_details(i).attribute4 := hr_transaction_api.get_varchar2_Value
1780: (p_transaction_step_id => l_trans_step_ids(ln_index)
1781: ,p_name => 'P_ATTRIBUTE4');
1782: --
1783: p_con_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value
1784: (p_transaction_step_id => l_trans_step_ids(ln_index)
1785: ,p_name => 'P_ATTRIBUTE5');
1786: --
1787: p_con_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value

Line 1787: p_con_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value

1783: p_con_phone_numbers_details(i).attribute5 := hr_transaction_api.get_varchar2_Value
1784: (p_transaction_step_id => l_trans_step_ids(ln_index)
1785: ,p_name => 'P_ATTRIBUTE5');
1786: --
1787: p_con_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value
1788: (p_transaction_step_id => l_trans_step_ids(ln_index)
1789: ,p_name => 'P_ATTRIBUTE6');
1790: --
1791: p_con_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value

Line 1791: p_con_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value

1787: p_con_phone_numbers_details(i).attribute6 := hr_transaction_api.get_varchar2_Value
1788: (p_transaction_step_id => l_trans_step_ids(ln_index)
1789: ,p_name => 'P_ATTRIBUTE6');
1790: --
1791: p_con_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value
1792: (p_transaction_step_id => l_trans_step_ids(ln_index)
1793: ,p_name => 'P_ATTRIBUTE7');
1794: --
1795: p_con_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value

Line 1795: p_con_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value

1791: p_con_phone_numbers_details(i).attribute7 := hr_transaction_api.get_varchar2_Value
1792: (p_transaction_step_id => l_trans_step_ids(ln_index)
1793: ,p_name => 'P_ATTRIBUTE7');
1794: --
1795: p_con_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value
1796: (p_transaction_step_id => l_trans_step_ids(ln_index)
1797: ,p_name => 'P_ATTRIBUTE8');
1798: --
1799: p_con_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value

Line 1799: p_con_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value

1795: p_con_phone_numbers_details(i).attribute8 := hr_transaction_api.get_varchar2_Value
1796: (p_transaction_step_id => l_trans_step_ids(ln_index)
1797: ,p_name => 'P_ATTRIBUTE8');
1798: --
1799: p_con_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value
1800: (p_transaction_step_id => l_trans_step_ids(ln_index)
1801: ,p_name => 'P_ATTRIBUTE9');
1802: --
1803: p_con_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value

Line 1803: p_con_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value

1799: p_con_phone_numbers_details(i).attribute9 := hr_transaction_api.get_varchar2_Value
1800: (p_transaction_step_id => l_trans_step_ids(ln_index)
1801: ,p_name => 'P_ATTRIBUTE9');
1802: --
1803: p_con_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value
1804: (p_transaction_step_id => l_trans_step_ids(ln_index)
1805: ,p_name => 'P_ATTRIBUTE10');
1806: --
1807: p_con_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value

Line 1807: p_con_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value

1803: p_con_phone_numbers_details(i).attribute10 := hr_transaction_api.get_varchar2_Value
1804: (p_transaction_step_id => l_trans_step_ids(ln_index)
1805: ,p_name => 'P_ATTRIBUTE10');
1806: --
1807: p_con_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value
1808: (p_transaction_step_id => l_trans_step_ids(ln_index)
1809: ,p_name => 'P_ATTRIBUTE11');
1810: --
1811: p_con_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value

Line 1811: p_con_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value

1807: p_con_phone_numbers_details(i).attribute11 := hr_transaction_api.get_varchar2_Value
1808: (p_transaction_step_id => l_trans_step_ids(ln_index)
1809: ,p_name => 'P_ATTRIBUTE11');
1810: --
1811: p_con_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value
1812: (p_transaction_step_id => l_trans_step_ids(ln_index)
1813: ,p_name => 'P_ATTRIBUTE12');
1814: --
1815: p_con_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value

Line 1815: p_con_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value

1811: p_con_phone_numbers_details(i).attribute12 := hr_transaction_api.get_varchar2_Value
1812: (p_transaction_step_id => l_trans_step_ids(ln_index)
1813: ,p_name => 'P_ATTRIBUTE12');
1814: --
1815: p_con_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value
1816: (p_transaction_step_id => l_trans_step_ids(ln_index)
1817: ,p_name => 'P_ATTRIBUTE13');
1818: --
1819: p_con_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value

Line 1819: p_con_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value

1815: p_con_phone_numbers_details(i).attribute13 := hr_transaction_api.get_varchar2_Value
1816: (p_transaction_step_id => l_trans_step_ids(ln_index)
1817: ,p_name => 'P_ATTRIBUTE13');
1818: --
1819: p_con_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value
1820: (p_transaction_step_id => l_trans_step_ids(ln_index)
1821: ,p_name => 'P_ATTRIBUTE14');
1822: --
1823: p_con_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value

Line 1823: p_con_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value

1819: p_con_phone_numbers_details(i).attribute14 := hr_transaction_api.get_varchar2_Value
1820: (p_transaction_step_id => l_trans_step_ids(ln_index)
1821: ,p_name => 'P_ATTRIBUTE14');
1822: --
1823: p_con_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value
1824: (p_transaction_step_id => l_trans_step_ids(ln_index)
1825: ,p_name => 'P_ATTRIBUTE15');
1826: --
1827: p_con_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value

Line 1827: p_con_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value

1823: p_con_phone_numbers_details(i).attribute15 := hr_transaction_api.get_varchar2_Value
1824: (p_transaction_step_id => l_trans_step_ids(ln_index)
1825: ,p_name => 'P_ATTRIBUTE15');
1826: --
1827: p_con_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value
1828: (p_transaction_step_id => l_trans_step_ids(ln_index)
1829: ,p_name => 'P_ATTRIBUTE16');
1830: --
1831: p_con_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value

Line 1831: p_con_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value

1827: p_con_phone_numbers_details(i).attribute16 := hr_transaction_api.get_varchar2_Value
1828: (p_transaction_step_id => l_trans_step_ids(ln_index)
1829: ,p_name => 'P_ATTRIBUTE16');
1830: --
1831: p_con_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value
1832: (p_transaction_step_id => l_trans_step_ids(ln_index)
1833: ,p_name => 'P_ATTRIBUTE17');
1834: --
1835: p_con_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value

Line 1835: p_con_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value

1831: p_con_phone_numbers_details(i).attribute17 := hr_transaction_api.get_varchar2_Value
1832: (p_transaction_step_id => l_trans_step_ids(ln_index)
1833: ,p_name => 'P_ATTRIBUTE17');
1834: --
1835: p_con_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value
1836: (p_transaction_step_id => l_trans_step_ids(ln_index)
1837: ,p_name => 'P_ATTRIBUTE18');
1838: --
1839: p_con_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value

Line 1839: p_con_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value

1835: p_con_phone_numbers_details(i).attribute18 := hr_transaction_api.get_varchar2_Value
1836: (p_transaction_step_id => l_trans_step_ids(ln_index)
1837: ,p_name => 'P_ATTRIBUTE18');
1838: --
1839: p_con_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value
1840: (p_transaction_step_id => l_trans_step_ids(ln_index)
1841: ,p_name => 'P_ATTRIBUTE19');
1842: --
1843: p_con_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value

Line 1843: p_con_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value

1839: p_con_phone_numbers_details(i).attribute19 := hr_transaction_api.get_varchar2_Value
1840: (p_transaction_step_id => l_trans_step_ids(ln_index)
1841: ,p_name => 'P_ATTRIBUTE19');
1842: --
1843: p_con_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value
1844: (p_transaction_step_id => l_trans_step_ids(ln_index)
1845: ,p_name => 'P_ATTRIBUTE20');
1846: --
1847: p_con_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value

Line 1847: p_con_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value

1843: p_con_phone_numbers_details(i).attribute20 := hr_transaction_api.get_varchar2_Value
1844: (p_transaction_step_id => l_trans_step_ids(ln_index)
1845: ,p_name => 'P_ATTRIBUTE20');
1846: --
1847: p_con_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value
1848: (p_transaction_step_id => l_trans_step_ids(ln_index)
1849: ,p_name => 'P_ATTRIBUTE21');
1850: --
1851: p_con_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value

Line 1851: p_con_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value

1847: p_con_phone_numbers_details(i).attribute21 := hr_transaction_api.get_varchar2_Value
1848: (p_transaction_step_id => l_trans_step_ids(ln_index)
1849: ,p_name => 'P_ATTRIBUTE21');
1850: --
1851: p_con_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value
1852: (p_transaction_step_id => l_trans_step_ids(ln_index)
1853: ,p_name => 'P_ATTRIBUTE22');
1854: --
1855: p_con_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value

Line 1855: p_con_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value

1851: p_con_phone_numbers_details(i).attribute22 := hr_transaction_api.get_varchar2_Value
1852: (p_transaction_step_id => l_trans_step_ids(ln_index)
1853: ,p_name => 'P_ATTRIBUTE22');
1854: --
1855: p_con_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value
1856: (p_transaction_step_id => l_trans_step_ids(ln_index)
1857: ,p_name => 'P_ATTRIBUTE23');
1858: --
1859: p_con_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value

Line 1859: p_con_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value

1855: p_con_phone_numbers_details(i).attribute23 := hr_transaction_api.get_varchar2_Value
1856: (p_transaction_step_id => l_trans_step_ids(ln_index)
1857: ,p_name => 'P_ATTRIBUTE23');
1858: --
1859: p_con_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value
1860: (p_transaction_step_id => l_trans_step_ids(ln_index)
1861: ,p_name => 'P_ATTRIBUTE24');
1862: --
1863: p_con_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value

Line 1863: p_con_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value

1859: p_con_phone_numbers_details(i).attribute24 := hr_transaction_api.get_varchar2_Value
1860: (p_transaction_step_id => l_trans_step_ids(ln_index)
1861: ,p_name => 'P_ATTRIBUTE24');
1862: --
1863: p_con_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value
1864: (p_transaction_step_id => l_trans_step_ids(ln_index)
1865: ,p_name => 'P_ATTRIBUTE25');
1866: --
1867: p_con_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value

Line 1867: p_con_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value

1863: p_con_phone_numbers_details(i).attribute25 := hr_transaction_api.get_varchar2_Value
1864: (p_transaction_step_id => l_trans_step_ids(ln_index)
1865: ,p_name => 'P_ATTRIBUTE25');
1866: --
1867: p_con_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value
1868: (p_transaction_step_id => l_trans_step_ids(ln_index)
1869: ,p_name => 'P_ATTRIBUTE26');
1870: --
1871: p_con_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value

Line 1871: p_con_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value

1867: p_con_phone_numbers_details(i).attribute26 := hr_transaction_api.get_varchar2_Value
1868: (p_transaction_step_id => l_trans_step_ids(ln_index)
1869: ,p_name => 'P_ATTRIBUTE26');
1870: --
1871: p_con_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value
1872: (p_transaction_step_id => l_trans_step_ids(ln_index)
1873: ,p_name => 'P_ATTRIBUTE27');
1874: --
1875: p_con_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value

Line 1875: p_con_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value

1871: p_con_phone_numbers_details(i).attribute27 := hr_transaction_api.get_varchar2_Value
1872: (p_transaction_step_id => l_trans_step_ids(ln_index)
1873: ,p_name => 'P_ATTRIBUTE27');
1874: --
1875: p_con_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value
1876: (p_transaction_step_id => l_trans_step_ids(ln_index)
1877: ,p_name => 'P_ATTRIBUTE28');
1878: --
1879: p_con_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value

Line 1879: p_con_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value

1875: p_con_phone_numbers_details(i).attribute28 := hr_transaction_api.get_varchar2_Value
1876: (p_transaction_step_id => l_trans_step_ids(ln_index)
1877: ,p_name => 'P_ATTRIBUTE28');
1878: --
1879: p_con_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value
1880: (p_transaction_step_id => l_trans_step_ids(ln_index)
1881: ,p_name => 'P_ATTRIBUTE29');
1882: --
1883: p_con_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value

Line 1883: p_con_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value

1879: p_con_phone_numbers_details(i).attribute29 := hr_transaction_api.get_varchar2_Value
1880: (p_transaction_step_id => l_trans_step_ids(ln_index)
1881: ,p_name => 'P_ATTRIBUTE29');
1882: --
1883: p_con_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value
1884: (p_transaction_step_id => l_trans_step_ids(ln_index)
1885: ,p_name => 'P_ATTRIBUTE30');
1886: --
1887: p_con_phone_numbers_details(i).parent_id := hr_transaction_api.get_number_value

Line 1887: p_con_phone_numbers_details(i).parent_id := hr_transaction_api.get_number_value

1883: p_con_phone_numbers_details(i).attribute30 := hr_transaction_api.get_varchar2_Value
1884: (p_transaction_step_id => l_trans_step_ids(ln_index)
1885: ,p_name => 'P_ATTRIBUTE30');
1886: --
1887: p_con_phone_numbers_details(i).parent_id := hr_transaction_api.get_number_value
1888: (p_transaction_step_id => l_trans_step_ids(ln_index)
1889: ,p_name => 'P_PERSON_ID');
1890:
1891: --bug#3542613

Line 1892: p_con_phone_numbers_details(i).contact_set := hr_transaction_api.get_varchar2_Value

1888: (p_transaction_step_id => l_trans_step_ids(ln_index)
1889: ,p_name => 'P_PERSON_ID');
1890:
1891: --bug#3542613
1892: p_con_phone_numbers_details(i).contact_set := hr_transaction_api.get_varchar2_Value
1893: (p_transaction_step_id => l_trans_step_ids(ln_index)
1894: ,p_name => 'P_CONTACT_SET');
1895:
1896: i := i + 1;

Line 1968: hr_transaction_api.get_number_Value

1964: (p_transaction_step_id => p_transaction_step_id),g_date_format);
1965: end if;
1966:
1967: l_person_id :=
1968: hr_transaction_api.get_number_Value
1969: (p_transaction_step_id =>
1970: p_transaction_step_id
1971: ,p_name => 'P_PERSON_ID');
1972:

Line 1975: hr_transaction_api.get_varchar2_Value

1971: ,p_name => 'P_PERSON_ID');
1972:
1973: savepoint process_phones;
1974: l_phone_number :=
1975: hr_transaction_api.get_varchar2_Value
1976: (p_transaction_step_id =>
1977: p_transaction_step_id
1978: ,p_name => 'P_PHONE_NUMBER');
1979: l_phone_ovn :=

Line 1980: hr_transaction_api.get_number_Value

1976: (p_transaction_step_id =>
1977: p_transaction_step_id
1978: ,p_name => 'P_PHONE_NUMBER');
1979: l_phone_ovn :=
1980: hr_transaction_api.get_number_Value
1981: (p_transaction_step_id =>
1982: p_transaction_step_id
1983: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1984: l_phone_type :=

Line 1985: hr_transaction_api.get_varchar2_Value

1981: (p_transaction_step_id =>
1982: p_transaction_step_id
1983: ,p_name => 'P_OBJECT_VERSION_NUMBER');
1984: l_phone_type :=
1985: hr_transaction_api.get_varchar2_Value
1986: (p_transaction_step_id =>
1987: p_transaction_step_id
1988: ,p_name => 'P_PHONE_TYPE');
1989: l_phone_id :=

Line 1990: hr_transaction_api.get_number_Value

1986: (p_transaction_step_id =>
1987: p_transaction_step_id
1988: ,p_name => 'P_PHONE_TYPE');
1989: l_phone_id :=
1990: hr_transaction_api.get_number_Value
1991: (p_transaction_step_id =>
1992: p_transaction_step_id
1993: ,p_name => 'P_PHONE_ID');
1994: IF l_phone_id IS NULL THEN

Line 2009: hr_transaction_api.get_varchar2_Value

2005: --
2006: -- StartRegistration
2007: hr_utility.set_location('l_person_id is null or l_person_id < 0:'||l_proc,25);
2008: l_per_or_contact :=
2009: hr_transaction_api.get_varchar2_Value
2010: (p_transaction_step_id =>
2011: p_transaction_step_id
2012: ,p_name => 'P_PER_OR_CONTACT');
2013: --

Line 2056: ,p_attribute_category => hr_transaction_api.get_varchar2_value

2052: ,p_effective_date => l_effective_date
2053: ,p_parent_id => l_person_id
2054: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2055: ,p_date_from => l_Effective_date
2056: ,p_attribute_category => hr_transaction_api.get_varchar2_value
2057: (p_transaction_step_id => p_transaction_step_id
2058: ,p_name => 'P_ATTRIBUTE_CATEGORY')
2059: ,p_attribute1 => hr_transaction_api.get_varchar2_value
2060: (p_transaction_step_id => p_transaction_step_id

Line 2059: ,p_attribute1 => hr_transaction_api.get_varchar2_value

2055: ,p_date_from => l_Effective_date
2056: ,p_attribute_category => hr_transaction_api.get_varchar2_value
2057: (p_transaction_step_id => p_transaction_step_id
2058: ,p_name => 'P_ATTRIBUTE_CATEGORY')
2059: ,p_attribute1 => hr_transaction_api.get_varchar2_value
2060: (p_transaction_step_id => p_transaction_step_id
2061: ,p_name => 'P_ATTRIBUTE1')
2062: ,p_attribute2 => hr_transaction_api.get_varchar2_value
2063: (p_transaction_step_id => p_transaction_step_id

Line 2062: ,p_attribute2 => hr_transaction_api.get_varchar2_value

2058: ,p_name => 'P_ATTRIBUTE_CATEGORY')
2059: ,p_attribute1 => hr_transaction_api.get_varchar2_value
2060: (p_transaction_step_id => p_transaction_step_id
2061: ,p_name => 'P_ATTRIBUTE1')
2062: ,p_attribute2 => hr_transaction_api.get_varchar2_value
2063: (p_transaction_step_id => p_transaction_step_id
2064: ,p_name => 'P_ATTRIBUTE2')
2065: ,p_attribute3 => hr_transaction_api.get_varchar2_value
2066: (p_transaction_step_id => p_transaction_step_id

Line 2065: ,p_attribute3 => hr_transaction_api.get_varchar2_value

2061: ,p_name => 'P_ATTRIBUTE1')
2062: ,p_attribute2 => hr_transaction_api.get_varchar2_value
2063: (p_transaction_step_id => p_transaction_step_id
2064: ,p_name => 'P_ATTRIBUTE2')
2065: ,p_attribute3 => hr_transaction_api.get_varchar2_value
2066: (p_transaction_step_id => p_transaction_step_id
2067: ,p_name => 'P_ATTRIBUTE3')
2068: ,p_attribute4 => hr_transaction_api.get_varchar2_value
2069: (p_transaction_step_id => p_transaction_step_id

Line 2068: ,p_attribute4 => hr_transaction_api.get_varchar2_value

2064: ,p_name => 'P_ATTRIBUTE2')
2065: ,p_attribute3 => hr_transaction_api.get_varchar2_value
2066: (p_transaction_step_id => p_transaction_step_id
2067: ,p_name => 'P_ATTRIBUTE3')
2068: ,p_attribute4 => hr_transaction_api.get_varchar2_value
2069: (p_transaction_step_id => p_transaction_step_id
2070: ,p_name => 'P_ATTRIBUTE4')
2071: ,p_attribute5 => hr_transaction_api.get_varchar2_value
2072: (p_transaction_step_id => p_transaction_step_id

Line 2071: ,p_attribute5 => hr_transaction_api.get_varchar2_value

2067: ,p_name => 'P_ATTRIBUTE3')
2068: ,p_attribute4 => hr_transaction_api.get_varchar2_value
2069: (p_transaction_step_id => p_transaction_step_id
2070: ,p_name => 'P_ATTRIBUTE4')
2071: ,p_attribute5 => hr_transaction_api.get_varchar2_value
2072: (p_transaction_step_id => p_transaction_step_id
2073: ,p_name => 'P_ATTRIBUTE5')
2074: ,p_attribute6 => hr_transaction_api.get_varchar2_value
2075: (p_transaction_step_id => p_transaction_step_id

Line 2074: ,p_attribute6 => hr_transaction_api.get_varchar2_value

2070: ,p_name => 'P_ATTRIBUTE4')
2071: ,p_attribute5 => hr_transaction_api.get_varchar2_value
2072: (p_transaction_step_id => p_transaction_step_id
2073: ,p_name => 'P_ATTRIBUTE5')
2074: ,p_attribute6 => hr_transaction_api.get_varchar2_value
2075: (p_transaction_step_id => p_transaction_step_id
2076: ,p_name => 'P_ATTRIBUTE6')
2077: ,p_attribute7 => hr_transaction_api.get_varchar2_value
2078: (p_transaction_step_id => p_transaction_step_id

Line 2077: ,p_attribute7 => hr_transaction_api.get_varchar2_value

2073: ,p_name => 'P_ATTRIBUTE5')
2074: ,p_attribute6 => hr_transaction_api.get_varchar2_value
2075: (p_transaction_step_id => p_transaction_step_id
2076: ,p_name => 'P_ATTRIBUTE6')
2077: ,p_attribute7 => hr_transaction_api.get_varchar2_value
2078: (p_transaction_step_id => p_transaction_step_id
2079: ,p_name => 'P_ATTRIBUTE7')
2080: ,p_attribute8 => hr_transaction_api.get_varchar2_value
2081: (p_transaction_step_id => p_transaction_step_id

Line 2080: ,p_attribute8 => hr_transaction_api.get_varchar2_value

2076: ,p_name => 'P_ATTRIBUTE6')
2077: ,p_attribute7 => hr_transaction_api.get_varchar2_value
2078: (p_transaction_step_id => p_transaction_step_id
2079: ,p_name => 'P_ATTRIBUTE7')
2080: ,p_attribute8 => hr_transaction_api.get_varchar2_value
2081: (p_transaction_step_id => p_transaction_step_id
2082: ,p_name => 'P_ATTRIBUTE8')
2083: ,p_attribute9 => hr_transaction_api.get_varchar2_value
2084: (p_transaction_step_id => p_transaction_step_id

Line 2083: ,p_attribute9 => hr_transaction_api.get_varchar2_value

2079: ,p_name => 'P_ATTRIBUTE7')
2080: ,p_attribute8 => hr_transaction_api.get_varchar2_value
2081: (p_transaction_step_id => p_transaction_step_id
2082: ,p_name => 'P_ATTRIBUTE8')
2083: ,p_attribute9 => hr_transaction_api.get_varchar2_value
2084: (p_transaction_step_id => p_transaction_step_id
2085: ,p_name => 'P_ATTRIBUTE9')
2086: ,p_attribute10 => hr_transaction_api.get_varchar2_value
2087: (p_transaction_step_id => p_transaction_step_id

Line 2086: ,p_attribute10 => hr_transaction_api.get_varchar2_value

2082: ,p_name => 'P_ATTRIBUTE8')
2083: ,p_attribute9 => hr_transaction_api.get_varchar2_value
2084: (p_transaction_step_id => p_transaction_step_id
2085: ,p_name => 'P_ATTRIBUTE9')
2086: ,p_attribute10 => hr_transaction_api.get_varchar2_value
2087: (p_transaction_step_id => p_transaction_step_id
2088: ,p_name => 'P_ATTRIBUTE10')
2089: ,p_attribute11 => hr_transaction_api.get_varchar2_value
2090: (p_transaction_step_id => p_transaction_step_id

Line 2089: ,p_attribute11 => hr_transaction_api.get_varchar2_value

2085: ,p_name => 'P_ATTRIBUTE9')
2086: ,p_attribute10 => hr_transaction_api.get_varchar2_value
2087: (p_transaction_step_id => p_transaction_step_id
2088: ,p_name => 'P_ATTRIBUTE10')
2089: ,p_attribute11 => hr_transaction_api.get_varchar2_value
2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_name => 'P_ATTRIBUTE11')
2092: ,p_attribute12 => hr_transaction_api.get_varchar2_value
2093: (p_transaction_step_id => p_transaction_step_id

Line 2092: ,p_attribute12 => hr_transaction_api.get_varchar2_value

2088: ,p_name => 'P_ATTRIBUTE10')
2089: ,p_attribute11 => hr_transaction_api.get_varchar2_value
2090: (p_transaction_step_id => p_transaction_step_id
2091: ,p_name => 'P_ATTRIBUTE11')
2092: ,p_attribute12 => hr_transaction_api.get_varchar2_value
2093: (p_transaction_step_id => p_transaction_step_id
2094: ,p_name => 'P_ATTRIBUTE12')
2095: ,p_attribute13 => hr_transaction_api.get_varchar2_value
2096: (p_transaction_step_id => p_transaction_step_id

Line 2095: ,p_attribute13 => hr_transaction_api.get_varchar2_value

2091: ,p_name => 'P_ATTRIBUTE11')
2092: ,p_attribute12 => hr_transaction_api.get_varchar2_value
2093: (p_transaction_step_id => p_transaction_step_id
2094: ,p_name => 'P_ATTRIBUTE12')
2095: ,p_attribute13 => hr_transaction_api.get_varchar2_value
2096: (p_transaction_step_id => p_transaction_step_id
2097: ,p_name => 'P_ATTRIBUTE13')
2098: ,p_attribute14 => hr_transaction_api.get_varchar2_value
2099: (p_transaction_step_id => p_transaction_step_id

Line 2098: ,p_attribute14 => hr_transaction_api.get_varchar2_value

2094: ,p_name => 'P_ATTRIBUTE12')
2095: ,p_attribute13 => hr_transaction_api.get_varchar2_value
2096: (p_transaction_step_id => p_transaction_step_id
2097: ,p_name => 'P_ATTRIBUTE13')
2098: ,p_attribute14 => hr_transaction_api.get_varchar2_value
2099: (p_transaction_step_id => p_transaction_step_id
2100: ,p_name => 'P_ATTRIBUTE14')
2101: ,p_attribute15 => hr_transaction_api.get_varchar2_value
2102: (p_transaction_step_id => p_transaction_step_id

Line 2101: ,p_attribute15 => hr_transaction_api.get_varchar2_value

2097: ,p_name => 'P_ATTRIBUTE13')
2098: ,p_attribute14 => hr_transaction_api.get_varchar2_value
2099: (p_transaction_step_id => p_transaction_step_id
2100: ,p_name => 'P_ATTRIBUTE14')
2101: ,p_attribute15 => hr_transaction_api.get_varchar2_value
2102: (p_transaction_step_id => p_transaction_step_id
2103: ,p_name => 'P_ATTRIBUTE15')
2104: ,p_attribute16 => hr_transaction_api.get_varchar2_value
2105: (p_transaction_step_id => p_transaction_step_id

Line 2104: ,p_attribute16 => hr_transaction_api.get_varchar2_value

2100: ,p_name => 'P_ATTRIBUTE14')
2101: ,p_attribute15 => hr_transaction_api.get_varchar2_value
2102: (p_transaction_step_id => p_transaction_step_id
2103: ,p_name => 'P_ATTRIBUTE15')
2104: ,p_attribute16 => hr_transaction_api.get_varchar2_value
2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_name => 'P_ATTRIBUTE16')
2107: ,p_attribute17 => hr_transaction_api.get_varchar2_value
2108: (p_transaction_step_id => p_transaction_step_id

Line 2107: ,p_attribute17 => hr_transaction_api.get_varchar2_value

2103: ,p_name => 'P_ATTRIBUTE15')
2104: ,p_attribute16 => hr_transaction_api.get_varchar2_value
2105: (p_transaction_step_id => p_transaction_step_id
2106: ,p_name => 'P_ATTRIBUTE16')
2107: ,p_attribute17 => hr_transaction_api.get_varchar2_value
2108: (p_transaction_step_id => p_transaction_step_id
2109: ,p_name => 'P_ATTRIBUTE17')
2110: ,p_attribute18 => hr_transaction_api.get_varchar2_value
2111: (p_transaction_step_id => p_transaction_step_id

Line 2110: ,p_attribute18 => hr_transaction_api.get_varchar2_value

2106: ,p_name => 'P_ATTRIBUTE16')
2107: ,p_attribute17 => hr_transaction_api.get_varchar2_value
2108: (p_transaction_step_id => p_transaction_step_id
2109: ,p_name => 'P_ATTRIBUTE17')
2110: ,p_attribute18 => hr_transaction_api.get_varchar2_value
2111: (p_transaction_step_id => p_transaction_step_id
2112: ,p_name => 'P_ATTRIBUTE18')
2113: ,p_attribute19 => hr_transaction_api.get_varchar2_value
2114: (p_transaction_step_id => p_transaction_step_id

Line 2113: ,p_attribute19 => hr_transaction_api.get_varchar2_value

2109: ,p_name => 'P_ATTRIBUTE17')
2110: ,p_attribute18 => hr_transaction_api.get_varchar2_value
2111: (p_transaction_step_id => p_transaction_step_id
2112: ,p_name => 'P_ATTRIBUTE18')
2113: ,p_attribute19 => hr_transaction_api.get_varchar2_value
2114: (p_transaction_step_id => p_transaction_step_id
2115: ,p_name => 'P_ATTRIBUTE19')
2116: ,p_attribute20 => hr_transaction_api.get_varchar2_value
2117: (p_transaction_step_id => p_transaction_step_id

Line 2116: ,p_attribute20 => hr_transaction_api.get_varchar2_value

2112: ,p_name => 'P_ATTRIBUTE18')
2113: ,p_attribute19 => hr_transaction_api.get_varchar2_value
2114: (p_transaction_step_id => p_transaction_step_id
2115: ,p_name => 'P_ATTRIBUTE19')
2116: ,p_attribute20 => hr_transaction_api.get_varchar2_value
2117: (p_transaction_step_id => p_transaction_step_id
2118: ,p_name => 'P_ATTRIBUTE20')
2119: ,p_attribute21 => hr_transaction_api.get_varchar2_value
2120: (p_transaction_step_id => p_transaction_step_id

Line 2119: ,p_attribute21 => hr_transaction_api.get_varchar2_value

2115: ,p_name => 'P_ATTRIBUTE19')
2116: ,p_attribute20 => hr_transaction_api.get_varchar2_value
2117: (p_transaction_step_id => p_transaction_step_id
2118: ,p_name => 'P_ATTRIBUTE20')
2119: ,p_attribute21 => hr_transaction_api.get_varchar2_value
2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_name => 'P_ATTRIBUTE21')
2122: ,p_attribute22 => hr_transaction_api.get_varchar2_value
2123: (p_transaction_step_id => p_transaction_step_id

Line 2122: ,p_attribute22 => hr_transaction_api.get_varchar2_value

2118: ,p_name => 'P_ATTRIBUTE20')
2119: ,p_attribute21 => hr_transaction_api.get_varchar2_value
2120: (p_transaction_step_id => p_transaction_step_id
2121: ,p_name => 'P_ATTRIBUTE21')
2122: ,p_attribute22 => hr_transaction_api.get_varchar2_value
2123: (p_transaction_step_id => p_transaction_step_id
2124: ,p_name => 'P_ATTRIBUTE22')
2125: ,p_attribute23 => hr_transaction_api.get_varchar2_value
2126: (p_transaction_step_id => p_transaction_step_id

Line 2125: ,p_attribute23 => hr_transaction_api.get_varchar2_value

2121: ,p_name => 'P_ATTRIBUTE21')
2122: ,p_attribute22 => hr_transaction_api.get_varchar2_value
2123: (p_transaction_step_id => p_transaction_step_id
2124: ,p_name => 'P_ATTRIBUTE22')
2125: ,p_attribute23 => hr_transaction_api.get_varchar2_value
2126: (p_transaction_step_id => p_transaction_step_id
2127: ,p_name => 'P_ATTRIBUTE23')
2128: ,p_attribute24 => hr_transaction_api.get_varchar2_value
2129: (p_transaction_step_id => p_transaction_step_id

Line 2128: ,p_attribute24 => hr_transaction_api.get_varchar2_value

2124: ,p_name => 'P_ATTRIBUTE22')
2125: ,p_attribute23 => hr_transaction_api.get_varchar2_value
2126: (p_transaction_step_id => p_transaction_step_id
2127: ,p_name => 'P_ATTRIBUTE23')
2128: ,p_attribute24 => hr_transaction_api.get_varchar2_value
2129: (p_transaction_step_id => p_transaction_step_id
2130: ,p_name => 'P_ATTRIBUTE24')
2131: ,p_attribute25 => hr_transaction_api.get_varchar2_value
2132: (p_transaction_step_id => p_transaction_step_id

Line 2131: ,p_attribute25 => hr_transaction_api.get_varchar2_value

2127: ,p_name => 'P_ATTRIBUTE23')
2128: ,p_attribute24 => hr_transaction_api.get_varchar2_value
2129: (p_transaction_step_id => p_transaction_step_id
2130: ,p_name => 'P_ATTRIBUTE24')
2131: ,p_attribute25 => hr_transaction_api.get_varchar2_value
2132: (p_transaction_step_id => p_transaction_step_id
2133: ,p_name => 'P_ATTRIBUTE25')
2134: ,p_attribute26 => hr_transaction_api.get_varchar2_value
2135: (p_transaction_step_id => p_transaction_step_id

Line 2134: ,p_attribute26 => hr_transaction_api.get_varchar2_value

2130: ,p_name => 'P_ATTRIBUTE24')
2131: ,p_attribute25 => hr_transaction_api.get_varchar2_value
2132: (p_transaction_step_id => p_transaction_step_id
2133: ,p_name => 'P_ATTRIBUTE25')
2134: ,p_attribute26 => hr_transaction_api.get_varchar2_value
2135: (p_transaction_step_id => p_transaction_step_id
2136: ,p_name => 'P_ATTRIBUTE26')
2137: ,p_attribute27 => hr_transaction_api.get_varchar2_value
2138: (p_transaction_step_id => p_transaction_step_id

Line 2137: ,p_attribute27 => hr_transaction_api.get_varchar2_value

2133: ,p_name => 'P_ATTRIBUTE25')
2134: ,p_attribute26 => hr_transaction_api.get_varchar2_value
2135: (p_transaction_step_id => p_transaction_step_id
2136: ,p_name => 'P_ATTRIBUTE26')
2137: ,p_attribute27 => hr_transaction_api.get_varchar2_value
2138: (p_transaction_step_id => p_transaction_step_id
2139: ,p_name => 'P_ATTRIBUTE27')
2140: ,p_attribute28 => hr_transaction_api.get_varchar2_value
2141: (p_transaction_step_id => p_transaction_step_id

Line 2140: ,p_attribute28 => hr_transaction_api.get_varchar2_value

2136: ,p_name => 'P_ATTRIBUTE26')
2137: ,p_attribute27 => hr_transaction_api.get_varchar2_value
2138: (p_transaction_step_id => p_transaction_step_id
2139: ,p_name => 'P_ATTRIBUTE27')
2140: ,p_attribute28 => hr_transaction_api.get_varchar2_value
2141: (p_transaction_step_id => p_transaction_step_id
2142: ,p_name => 'P_ATTRIBUTE28')
2143: ,p_attribute29 => hr_transaction_api.get_varchar2_value
2144: (p_transaction_step_id => p_transaction_step_id

Line 2143: ,p_attribute29 => hr_transaction_api.get_varchar2_value

2139: ,p_name => 'P_ATTRIBUTE27')
2140: ,p_attribute28 => hr_transaction_api.get_varchar2_value
2141: (p_transaction_step_id => p_transaction_step_id
2142: ,p_name => 'P_ATTRIBUTE28')
2143: ,p_attribute29 => hr_transaction_api.get_varchar2_value
2144: (p_transaction_step_id => p_transaction_step_id
2145: ,p_name => 'P_ATTRIBUTE29')
2146: ,p_attribute30 => hr_transaction_api.get_varchar2_value
2147: (p_transaction_step_id => p_transaction_step_id

Line 2146: ,p_attribute30 => hr_transaction_api.get_varchar2_value

2142: ,p_name => 'P_ATTRIBUTE28')
2143: ,p_attribute29 => hr_transaction_api.get_varchar2_value
2144: (p_transaction_step_id => p_transaction_step_id
2145: ,p_name => 'P_ATTRIBUTE29')
2146: ,p_attribute30 => hr_transaction_api.get_varchar2_value
2147: (p_transaction_step_id => p_transaction_step_id
2148: ,p_name => 'P_ATTRIBUTE30'));
2149: ELSIF l_phone_type = 'DELETE' THEN
2150: -- Delete the existing phone nuber.

Line 2166: ,p_attribute_category => hr_transaction_api.get_varchar2_value

2162: ,p_phone_number => l_phone_number
2163: ,p_phone_type => l_phone_type
2164: ,p_object_version_number => l_phone_ovn
2165: ,p_effective_date => l_effective_date
2166: ,p_attribute_category => hr_transaction_api.get_varchar2_value
2167: (p_transaction_step_id => p_transaction_step_id
2168: ,p_name => 'P_ATTRIBUTE_CATEGORY')
2169: ,p_attribute1 => hr_transaction_api.get_varchar2_value
2170: (p_transaction_step_id => p_transaction_step_id

Line 2169: ,p_attribute1 => hr_transaction_api.get_varchar2_value

2165: ,p_effective_date => l_effective_date
2166: ,p_attribute_category => hr_transaction_api.get_varchar2_value
2167: (p_transaction_step_id => p_transaction_step_id
2168: ,p_name => 'P_ATTRIBUTE_CATEGORY')
2169: ,p_attribute1 => hr_transaction_api.get_varchar2_value
2170: (p_transaction_step_id => p_transaction_step_id
2171: ,p_name => 'P_ATTRIBUTE1')
2172: ,p_attribute2 => hr_transaction_api.get_varchar2_value
2173: (p_transaction_step_id => p_transaction_step_id

Line 2172: ,p_attribute2 => hr_transaction_api.get_varchar2_value

2168: ,p_name => 'P_ATTRIBUTE_CATEGORY')
2169: ,p_attribute1 => hr_transaction_api.get_varchar2_value
2170: (p_transaction_step_id => p_transaction_step_id
2171: ,p_name => 'P_ATTRIBUTE1')
2172: ,p_attribute2 => hr_transaction_api.get_varchar2_value
2173: (p_transaction_step_id => p_transaction_step_id
2174: ,p_name => 'P_ATTRIBUTE2')
2175: ,p_attribute3 => hr_transaction_api.get_varchar2_value
2176: (p_transaction_step_id => p_transaction_step_id

Line 2175: ,p_attribute3 => hr_transaction_api.get_varchar2_value

2171: ,p_name => 'P_ATTRIBUTE1')
2172: ,p_attribute2 => hr_transaction_api.get_varchar2_value
2173: (p_transaction_step_id => p_transaction_step_id
2174: ,p_name => 'P_ATTRIBUTE2')
2175: ,p_attribute3 => hr_transaction_api.get_varchar2_value
2176: (p_transaction_step_id => p_transaction_step_id
2177: ,p_name => 'P_ATTRIBUTE3')
2178: ,p_attribute4 => hr_transaction_api.get_varchar2_value
2179: (p_transaction_step_id => p_transaction_step_id

Line 2178: ,p_attribute4 => hr_transaction_api.get_varchar2_value

2174: ,p_name => 'P_ATTRIBUTE2')
2175: ,p_attribute3 => hr_transaction_api.get_varchar2_value
2176: (p_transaction_step_id => p_transaction_step_id
2177: ,p_name => 'P_ATTRIBUTE3')
2178: ,p_attribute4 => hr_transaction_api.get_varchar2_value
2179: (p_transaction_step_id => p_transaction_step_id
2180: ,p_name => 'P_ATTRIBUTE4')
2181: ,p_attribute5 => hr_transaction_api.get_varchar2_value
2182: (p_transaction_step_id => p_transaction_step_id

Line 2181: ,p_attribute5 => hr_transaction_api.get_varchar2_value

2177: ,p_name => 'P_ATTRIBUTE3')
2178: ,p_attribute4 => hr_transaction_api.get_varchar2_value
2179: (p_transaction_step_id => p_transaction_step_id
2180: ,p_name => 'P_ATTRIBUTE4')
2181: ,p_attribute5 => hr_transaction_api.get_varchar2_value
2182: (p_transaction_step_id => p_transaction_step_id
2183: ,p_name => 'P_ATTRIBUTE5')
2184: ,p_attribute6 => hr_transaction_api.get_varchar2_value
2185: (p_transaction_step_id => p_transaction_step_id

Line 2184: ,p_attribute6 => hr_transaction_api.get_varchar2_value

2180: ,p_name => 'P_ATTRIBUTE4')
2181: ,p_attribute5 => hr_transaction_api.get_varchar2_value
2182: (p_transaction_step_id => p_transaction_step_id
2183: ,p_name => 'P_ATTRIBUTE5')
2184: ,p_attribute6 => hr_transaction_api.get_varchar2_value
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_name => 'P_ATTRIBUTE6')
2187: ,p_attribute7 => hr_transaction_api.get_varchar2_value
2188: (p_transaction_step_id => p_transaction_step_id

Line 2187: ,p_attribute7 => hr_transaction_api.get_varchar2_value

2183: ,p_name => 'P_ATTRIBUTE5')
2184: ,p_attribute6 => hr_transaction_api.get_varchar2_value
2185: (p_transaction_step_id => p_transaction_step_id
2186: ,p_name => 'P_ATTRIBUTE6')
2187: ,p_attribute7 => hr_transaction_api.get_varchar2_value
2188: (p_transaction_step_id => p_transaction_step_id
2189: ,p_name => 'P_ATTRIBUTE7')
2190: ,p_attribute8 => hr_transaction_api.get_varchar2_value
2191: (p_transaction_step_id => p_transaction_step_id

Line 2190: ,p_attribute8 => hr_transaction_api.get_varchar2_value

2186: ,p_name => 'P_ATTRIBUTE6')
2187: ,p_attribute7 => hr_transaction_api.get_varchar2_value
2188: (p_transaction_step_id => p_transaction_step_id
2189: ,p_name => 'P_ATTRIBUTE7')
2190: ,p_attribute8 => hr_transaction_api.get_varchar2_value
2191: (p_transaction_step_id => p_transaction_step_id
2192: ,p_name => 'P_ATTRIBUTE8')
2193: ,p_attribute9 => hr_transaction_api.get_varchar2_value
2194: (p_transaction_step_id => p_transaction_step_id

Line 2193: ,p_attribute9 => hr_transaction_api.get_varchar2_value

2189: ,p_name => 'P_ATTRIBUTE7')
2190: ,p_attribute8 => hr_transaction_api.get_varchar2_value
2191: (p_transaction_step_id => p_transaction_step_id
2192: ,p_name => 'P_ATTRIBUTE8')
2193: ,p_attribute9 => hr_transaction_api.get_varchar2_value
2194: (p_transaction_step_id => p_transaction_step_id
2195: ,p_name => 'P_ATTRIBUTE9')
2196: ,p_attribute10 => hr_transaction_api.get_varchar2_value
2197: (p_transaction_step_id => p_transaction_step_id

Line 2196: ,p_attribute10 => hr_transaction_api.get_varchar2_value

2192: ,p_name => 'P_ATTRIBUTE8')
2193: ,p_attribute9 => hr_transaction_api.get_varchar2_value
2194: (p_transaction_step_id => p_transaction_step_id
2195: ,p_name => 'P_ATTRIBUTE9')
2196: ,p_attribute10 => hr_transaction_api.get_varchar2_value
2197: (p_transaction_step_id => p_transaction_step_id
2198: ,p_name => 'P_ATTRIBUTE10')
2199: ,p_attribute11 => hr_transaction_api.get_varchar2_value
2200: (p_transaction_step_id => p_transaction_step_id

Line 2199: ,p_attribute11 => hr_transaction_api.get_varchar2_value

2195: ,p_name => 'P_ATTRIBUTE9')
2196: ,p_attribute10 => hr_transaction_api.get_varchar2_value
2197: (p_transaction_step_id => p_transaction_step_id
2198: ,p_name => 'P_ATTRIBUTE10')
2199: ,p_attribute11 => hr_transaction_api.get_varchar2_value
2200: (p_transaction_step_id => p_transaction_step_id
2201: ,p_name => 'P_ATTRIBUTE11')
2202: ,p_attribute12 => hr_transaction_api.get_varchar2_value
2203: (p_transaction_step_id => p_transaction_step_id

Line 2202: ,p_attribute12 => hr_transaction_api.get_varchar2_value

2198: ,p_name => 'P_ATTRIBUTE10')
2199: ,p_attribute11 => hr_transaction_api.get_varchar2_value
2200: (p_transaction_step_id => p_transaction_step_id
2201: ,p_name => 'P_ATTRIBUTE11')
2202: ,p_attribute12 => hr_transaction_api.get_varchar2_value
2203: (p_transaction_step_id => p_transaction_step_id
2204: ,p_name => 'P_ATTRIBUTE12')
2205: ,p_attribute13 => hr_transaction_api.get_varchar2_value
2206: (p_transaction_step_id => p_transaction_step_id

Line 2205: ,p_attribute13 => hr_transaction_api.get_varchar2_value

2201: ,p_name => 'P_ATTRIBUTE11')
2202: ,p_attribute12 => hr_transaction_api.get_varchar2_value
2203: (p_transaction_step_id => p_transaction_step_id
2204: ,p_name => 'P_ATTRIBUTE12')
2205: ,p_attribute13 => hr_transaction_api.get_varchar2_value
2206: (p_transaction_step_id => p_transaction_step_id
2207: ,p_name => 'P_ATTRIBUTE13')
2208: ,p_attribute14 => hr_transaction_api.get_varchar2_value
2209: (p_transaction_step_id => p_transaction_step_id

Line 2208: ,p_attribute14 => hr_transaction_api.get_varchar2_value

2204: ,p_name => 'P_ATTRIBUTE12')
2205: ,p_attribute13 => hr_transaction_api.get_varchar2_value
2206: (p_transaction_step_id => p_transaction_step_id
2207: ,p_name => 'P_ATTRIBUTE13')
2208: ,p_attribute14 => hr_transaction_api.get_varchar2_value
2209: (p_transaction_step_id => p_transaction_step_id
2210: ,p_name => 'P_ATTRIBUTE14')
2211: ,p_attribute15 => hr_transaction_api.get_varchar2_value
2212: (p_transaction_step_id => p_transaction_step_id

Line 2211: ,p_attribute15 => hr_transaction_api.get_varchar2_value

2207: ,p_name => 'P_ATTRIBUTE13')
2208: ,p_attribute14 => hr_transaction_api.get_varchar2_value
2209: (p_transaction_step_id => p_transaction_step_id
2210: ,p_name => 'P_ATTRIBUTE14')
2211: ,p_attribute15 => hr_transaction_api.get_varchar2_value
2212: (p_transaction_step_id => p_transaction_step_id
2213: ,p_name => 'P_ATTRIBUTE15')
2214: ,p_attribute16 => hr_transaction_api.get_varchar2_value
2215: (p_transaction_step_id => p_transaction_step_id

Line 2214: ,p_attribute16 => hr_transaction_api.get_varchar2_value

2210: ,p_name => 'P_ATTRIBUTE14')
2211: ,p_attribute15 => hr_transaction_api.get_varchar2_value
2212: (p_transaction_step_id => p_transaction_step_id
2213: ,p_name => 'P_ATTRIBUTE15')
2214: ,p_attribute16 => hr_transaction_api.get_varchar2_value
2215: (p_transaction_step_id => p_transaction_step_id
2216: ,p_name => 'P_ATTRIBUTE16')
2217: ,p_attribute17 => hr_transaction_api.get_varchar2_value
2218: (p_transaction_step_id => p_transaction_step_id

Line 2217: ,p_attribute17 => hr_transaction_api.get_varchar2_value

2213: ,p_name => 'P_ATTRIBUTE15')
2214: ,p_attribute16 => hr_transaction_api.get_varchar2_value
2215: (p_transaction_step_id => p_transaction_step_id
2216: ,p_name => 'P_ATTRIBUTE16')
2217: ,p_attribute17 => hr_transaction_api.get_varchar2_value
2218: (p_transaction_step_id => p_transaction_step_id
2219: ,p_name => 'P_ATTRIBUTE17')
2220: ,p_attribute18 => hr_transaction_api.get_varchar2_value
2221: (p_transaction_step_id => p_transaction_step_id

Line 2220: ,p_attribute18 => hr_transaction_api.get_varchar2_value

2216: ,p_name => 'P_ATTRIBUTE16')
2217: ,p_attribute17 => hr_transaction_api.get_varchar2_value
2218: (p_transaction_step_id => p_transaction_step_id
2219: ,p_name => 'P_ATTRIBUTE17')
2220: ,p_attribute18 => hr_transaction_api.get_varchar2_value
2221: (p_transaction_step_id => p_transaction_step_id
2222: ,p_name => 'P_ATTRIBUTE18')
2223: ,p_attribute19 => hr_transaction_api.get_varchar2_value
2224: (p_transaction_step_id => p_transaction_step_id

Line 2223: ,p_attribute19 => hr_transaction_api.get_varchar2_value

2219: ,p_name => 'P_ATTRIBUTE17')
2220: ,p_attribute18 => hr_transaction_api.get_varchar2_value
2221: (p_transaction_step_id => p_transaction_step_id
2222: ,p_name => 'P_ATTRIBUTE18')
2223: ,p_attribute19 => hr_transaction_api.get_varchar2_value
2224: (p_transaction_step_id => p_transaction_step_id
2225: ,p_name => 'P_ATTRIBUTE19')
2226: ,p_attribute20 => hr_transaction_api.get_varchar2_value
2227: (p_transaction_step_id => p_transaction_step_id

Line 2226: ,p_attribute20 => hr_transaction_api.get_varchar2_value

2222: ,p_name => 'P_ATTRIBUTE18')
2223: ,p_attribute19 => hr_transaction_api.get_varchar2_value
2224: (p_transaction_step_id => p_transaction_step_id
2225: ,p_name => 'P_ATTRIBUTE19')
2226: ,p_attribute20 => hr_transaction_api.get_varchar2_value
2227: (p_transaction_step_id => p_transaction_step_id
2228: ,p_name => 'P_ATTRIBUTE20')
2229: ,p_attribute21 => hr_transaction_api.get_varchar2_value
2230: (p_transaction_step_id => p_transaction_step_id

Line 2229: ,p_attribute21 => hr_transaction_api.get_varchar2_value

2225: ,p_name => 'P_ATTRIBUTE19')
2226: ,p_attribute20 => hr_transaction_api.get_varchar2_value
2227: (p_transaction_step_id => p_transaction_step_id
2228: ,p_name => 'P_ATTRIBUTE20')
2229: ,p_attribute21 => hr_transaction_api.get_varchar2_value
2230: (p_transaction_step_id => p_transaction_step_id
2231: ,p_name => 'P_ATTRIBUTE21')
2232: ,p_attribute22 => hr_transaction_api.get_varchar2_value
2233: (p_transaction_step_id => p_transaction_step_id

Line 2232: ,p_attribute22 => hr_transaction_api.get_varchar2_value

2228: ,p_name => 'P_ATTRIBUTE20')
2229: ,p_attribute21 => hr_transaction_api.get_varchar2_value
2230: (p_transaction_step_id => p_transaction_step_id
2231: ,p_name => 'P_ATTRIBUTE21')
2232: ,p_attribute22 => hr_transaction_api.get_varchar2_value
2233: (p_transaction_step_id => p_transaction_step_id
2234: ,p_name => 'P_ATTRIBUTE22')
2235: ,p_attribute23 => hr_transaction_api.get_varchar2_value
2236: (p_transaction_step_id => p_transaction_step_id

Line 2235: ,p_attribute23 => hr_transaction_api.get_varchar2_value

2231: ,p_name => 'P_ATTRIBUTE21')
2232: ,p_attribute22 => hr_transaction_api.get_varchar2_value
2233: (p_transaction_step_id => p_transaction_step_id
2234: ,p_name => 'P_ATTRIBUTE22')
2235: ,p_attribute23 => hr_transaction_api.get_varchar2_value
2236: (p_transaction_step_id => p_transaction_step_id
2237: ,p_name => 'P_ATTRIBUTE23')
2238: ,p_attribute24 => hr_transaction_api.get_varchar2_value
2239: (p_transaction_step_id => p_transaction_step_id

Line 2238: ,p_attribute24 => hr_transaction_api.get_varchar2_value

2234: ,p_name => 'P_ATTRIBUTE22')
2235: ,p_attribute23 => hr_transaction_api.get_varchar2_value
2236: (p_transaction_step_id => p_transaction_step_id
2237: ,p_name => 'P_ATTRIBUTE23')
2238: ,p_attribute24 => hr_transaction_api.get_varchar2_value
2239: (p_transaction_step_id => p_transaction_step_id
2240: ,p_name => 'P_ATTRIBUTE24')
2241: ,p_attribute25 => hr_transaction_api.get_varchar2_value
2242: (p_transaction_step_id => p_transaction_step_id

Line 2241: ,p_attribute25 => hr_transaction_api.get_varchar2_value

2237: ,p_name => 'P_ATTRIBUTE23')
2238: ,p_attribute24 => hr_transaction_api.get_varchar2_value
2239: (p_transaction_step_id => p_transaction_step_id
2240: ,p_name => 'P_ATTRIBUTE24')
2241: ,p_attribute25 => hr_transaction_api.get_varchar2_value
2242: (p_transaction_step_id => p_transaction_step_id
2243: ,p_name => 'P_ATTRIBUTE25')
2244: ,p_attribute26 => hr_transaction_api.get_varchar2_value
2245: (p_transaction_step_id => p_transaction_step_id

Line 2244: ,p_attribute26 => hr_transaction_api.get_varchar2_value

2240: ,p_name => 'P_ATTRIBUTE24')
2241: ,p_attribute25 => hr_transaction_api.get_varchar2_value
2242: (p_transaction_step_id => p_transaction_step_id
2243: ,p_name => 'P_ATTRIBUTE25')
2244: ,p_attribute26 => hr_transaction_api.get_varchar2_value
2245: (p_transaction_step_id => p_transaction_step_id
2246: ,p_name => 'P_ATTRIBUTE26')
2247: ,p_attribute27 => hr_transaction_api.get_varchar2_value
2248: (p_transaction_step_id => p_transaction_step_id

Line 2247: ,p_attribute27 => hr_transaction_api.get_varchar2_value

2243: ,p_name => 'P_ATTRIBUTE25')
2244: ,p_attribute26 => hr_transaction_api.get_varchar2_value
2245: (p_transaction_step_id => p_transaction_step_id
2246: ,p_name => 'P_ATTRIBUTE26')
2247: ,p_attribute27 => hr_transaction_api.get_varchar2_value
2248: (p_transaction_step_id => p_transaction_step_id
2249: ,p_name => 'P_ATTRIBUTE27')
2250: ,p_attribute28 => hr_transaction_api.get_varchar2_value
2251: (p_transaction_step_id => p_transaction_step_id

Line 2250: ,p_attribute28 => hr_transaction_api.get_varchar2_value

2246: ,p_name => 'P_ATTRIBUTE26')
2247: ,p_attribute27 => hr_transaction_api.get_varchar2_value
2248: (p_transaction_step_id => p_transaction_step_id
2249: ,p_name => 'P_ATTRIBUTE27')
2250: ,p_attribute28 => hr_transaction_api.get_varchar2_value
2251: (p_transaction_step_id => p_transaction_step_id
2252: ,p_name => 'P_ATTRIBUTE28')
2253: ,p_attribute29 => hr_transaction_api.get_varchar2_value
2254: (p_transaction_step_id => p_transaction_step_id

Line 2253: ,p_attribute29 => hr_transaction_api.get_varchar2_value

2249: ,p_name => 'P_ATTRIBUTE27')
2250: ,p_attribute28 => hr_transaction_api.get_varchar2_value
2251: (p_transaction_step_id => p_transaction_step_id
2252: ,p_name => 'P_ATTRIBUTE28')
2253: ,p_attribute29 => hr_transaction_api.get_varchar2_value
2254: (p_transaction_step_id => p_transaction_step_id
2255: ,p_name => 'P_ATTRIBUTE29')
2256: ,p_attribute30 => hr_transaction_api.get_varchar2_value
2257: (p_transaction_step_id => p_transaction_step_id

Line 2256: ,p_attribute30 => hr_transaction_api.get_varchar2_value

2252: ,p_name => 'P_ATTRIBUTE28')
2253: ,p_attribute29 => hr_transaction_api.get_varchar2_value
2254: (p_transaction_step_id => p_transaction_step_id
2255: ,p_name => 'P_ATTRIBUTE29')
2256: ,p_attribute30 => hr_transaction_api.get_varchar2_value
2257: (p_transaction_step_id => p_transaction_step_id
2258: ,p_name => 'P_ATTRIBUTE30'));
2259: END IF; -- If it's a new of existing phone number ?
2260: