959: p_error_message out nocopy long
960: --
961: )is
962: --
963: l_effective_start_date pay_element_entries_f.effective_start_date%type;
964: l_effective_end_date pay_element_entries_f.effective_end_date%type;
965: l_element_entry_id pay_element_entries_f.element_entry_id%type;
966: l_object_version_number pay_element_entries_f.object_version_number%type;
967: --
960: --
961: )is
962: --
963: l_effective_start_date pay_element_entries_f.effective_start_date%type;
964: l_effective_end_date pay_element_entries_f.effective_end_date%type;
965: l_element_entry_id pay_element_entries_f.element_entry_id%type;
966: l_object_version_number pay_element_entries_f.object_version_number%type;
967: --
968: l_create_warning boolean;
961: )is
962: --
963: l_effective_start_date pay_element_entries_f.effective_start_date%type;
964: l_effective_end_date pay_element_entries_f.effective_end_date%type;
965: l_element_entry_id pay_element_entries_f.element_entry_id%type;
966: l_object_version_number pay_element_entries_f.object_version_number%type;
967: --
968: l_create_warning boolean;
969: --
962: --
963: l_effective_start_date pay_element_entries_f.effective_start_date%type;
964: l_effective_end_date pay_element_entries_f.effective_end_date%type;
965: l_element_entry_id pay_element_entries_f.element_entry_id%type;
966: l_object_version_number pay_element_entries_f.object_version_number%type;
967: --
968: l_create_warning boolean;
969: --
970: begin
1118: p_error_message out nocopy long
1119: --
1120: )is
1121: --
1122: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1123: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1124: --
1125: l_update_warning boolean;
1126: --
1119: --
1120: )is
1121: --
1122: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1123: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1124: --
1125: l_update_warning boolean;
1126: --
1127: begin
1276: p_error_message out nocopy long
1277: --
1278: )is
1279: --
1280: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1281: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1282: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1283: l_object_version_number pay_element_entries_f.object_version_number%type;
1284: --
1277: --
1278: )is
1279: --
1280: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1281: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1282: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1283: l_object_version_number pay_element_entries_f.object_version_number%type;
1284: --
1285: l_create_warning boolean;
1278: )is
1279: --
1280: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1281: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1282: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1283: l_object_version_number pay_element_entries_f.object_version_number%type;
1284: --
1285: l_create_warning boolean;
1286: --
1279: --
1280: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1281: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1282: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1283: l_object_version_number pay_element_entries_f.object_version_number%type;
1284: --
1285: l_create_warning boolean;
1286: --
1287: begin
1438: p_error_message out nocopy long
1439: --
1440: )is
1441: --
1442: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1443: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1444: --
1445: l_update_warning boolean;
1446: --
1439: --
1440: )is
1441: --
1442: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1443: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1444: --
1445: l_update_warning boolean;
1446: --
1447: begin
1543: p_error_message out nocopy long
1544: --
1545: )is
1546: --
1547: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1548: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1549: --
1550: l_warning boolean;
1551: --
1544: --
1545: )is
1546: --
1547: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1548: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1549: --
1550: l_warning boolean;
1551: --
1552: begin
1589: --
1590: l_tran_tab hr_transaction_ss.transaction_data;
1591: --
1592: -- for return values from out parameters
1593: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1594: l_object_version_number pay_element_entries_f.object_version_number%type;
1595: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1596: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1597: --
1590: l_tran_tab hr_transaction_ss.transaction_data;
1591: --
1592: -- for return values from out parameters
1593: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1594: l_object_version_number pay_element_entries_f.object_version_number%type;
1595: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1596: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1597: --
1598: type tran_rec is record
1591: --
1592: -- for return values from out parameters
1593: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1594: l_object_version_number pay_element_entries_f.object_version_number%type;
1595: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1596: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1597: --
1598: type tran_rec is record
1599: (
1592: -- for return values from out parameters
1593: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1594: l_object_version_number pay_element_entries_f.object_version_number%type;
1595: l_effective_start_date pay_element_entries_f.effective_start_date%type;
1596: l_effective_end_date pay_element_entries_f.effective_end_date%type;
1597: --
1598: type tran_rec is record
1599: (
1600: commutation_type varchar2(30), -- 'TRAIN' or 'CAR'
1601: action_type varchar2(30), -- 'INSERT' or 'UPDATE' or 'DELETE'
1602: effective_date date,
1603: date_track_option varchar2(30),
1604: --
1605: element_entry_id pay_element_entries_f.element_entry_id%type,
1606: business_group_id pay_element_links_f.business_group_id%type,
1607: assignment_id pay_element_entries_f.assignment_id%type,
1608: element_link_id pay_element_entries_f.element_link_id%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1603: date_track_option varchar2(30),
1604: --
1605: element_entry_id pay_element_entries_f.element_entry_id%type,
1606: business_group_id pay_element_links_f.business_group_id%type,
1607: assignment_id pay_element_entries_f.assignment_id%type,
1608: element_link_id pay_element_entries_f.element_link_id%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1604: --
1605: element_entry_id pay_element_entries_f.element_entry_id%type,
1606: business_group_id pay_element_links_f.business_group_id%type,
1607: assignment_id pay_element_entries_f.assignment_id%type,
1608: element_link_id pay_element_entries_f.element_link_id%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1605: element_entry_id pay_element_entries_f.element_entry_id%type,
1606: business_group_id pay_element_links_f.business_group_id%type,
1607: assignment_id pay_element_entries_f.assignment_id%type,
1608: element_link_id pay_element_entries_f.element_link_id%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1606: business_group_id pay_element_links_f.business_group_id%type,
1607: assignment_id pay_element_entries_f.assignment_id%type,
1608: element_link_id pay_element_entries_f.element_link_id%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1608: element_link_id pay_element_entries_f.element_link_id%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1609: entry_type pay_element_entries_f.entry_type%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1610: object_version_number pay_element_entries_f.object_version_number%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1611: --
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1612: attribute_category pay_element_entries_f.attribute_category%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1613: attribute1 pay_element_entries_f.attribute1%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1614: attribute2 pay_element_entries_f.attribute2%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1615: attribute3 pay_element_entries_f.attribute3%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1616: attribute4 pay_element_entries_f.attribute4%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1617: attribute5 pay_element_entries_f.attribute5%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1618: attribute6 pay_element_entries_f.attribute6%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1619: attribute7 pay_element_entries_f.attribute7%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1620: attribute8 pay_element_entries_f.attribute8%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1621: attribute9 pay_element_entries_f.attribute9%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1622: attribute10 pay_element_entries_f.attribute10%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1623: attribute11 pay_element_entries_f.attribute11%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1631: attribute19 pay_element_entries_f.attribute19%type,
1624: attribute12 pay_element_entries_f.attribute12%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1631: attribute19 pay_element_entries_f.attribute19%type,
1632: attribute20 pay_element_entries_f.attribute20%type,
1625: attribute13 pay_element_entries_f.attribute13%type,
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1631: attribute19 pay_element_entries_f.attribute19%type,
1632: attribute20 pay_element_entries_f.attribute20%type,
1633: --
1626: attribute14 pay_element_entries_f.attribute14%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1631: attribute19 pay_element_entries_f.attribute19%type,
1632: attribute20 pay_element_entries_f.attribute20%type,
1633: --
1634: input_value_id1 pay_element_entry_values_f.input_value_id%type,
1627: attribute15 pay_element_entries_f.attribute15%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1631: attribute19 pay_element_entries_f.attribute19%type,
1632: attribute20 pay_element_entries_f.attribute20%type,
1633: --
1634: input_value_id1 pay_element_entry_values_f.input_value_id%type,
1635: input_value_id2 pay_element_entry_values_f.input_value_id%type,
1628: attribute16 pay_element_entries_f.attribute16%type,
1629: attribute17 pay_element_entries_f.attribute17%type,
1630: attribute18 pay_element_entries_f.attribute18%type,
1631: attribute19 pay_element_entries_f.attribute19%type,
1632: attribute20 pay_element_entries_f.attribute20%type,
1633: --
1634: input_value_id1 pay_element_entry_values_f.input_value_id%type,
1635: input_value_id2 pay_element_entry_values_f.input_value_id%type,
1636: input_value_id3 pay_element_entry_values_f.input_value_id%type,