DBA Data[Home] [Help]

APPS.PAY_JP_PROCESS_CMI_SS dependencies on PAY_ELEMENT_ENTRIES_F

Line 963: l_effective_start_date pay_element_entries_f.effective_start_date%type;

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: --

Line 964: l_effective_end_date pay_element_entries_f.effective_end_date%type;

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;

Line 965: l_element_entry_id pay_element_entries_f.element_entry_id%type;

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: --

Line 966: l_object_version_number pay_element_entries_f.object_version_number%type;

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

Line 1122: l_effective_start_date pay_element_entries_f.effective_start_date%type;

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: --

Line 1123: l_effective_end_date pay_element_entries_f.effective_end_date%type;

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

Line 1280: l_effective_start_date pay_element_entries_f.effective_start_date%type;

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: --

Line 1281: l_effective_end_date pay_element_entries_f.effective_end_date%type;

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;

Line 1282: l_element_entry_id pay_element_entries_f.element_entry_id%type;

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: --

Line 1283: l_object_version_number pay_element_entries_f.object_version_number%type;

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

Line 1442: l_effective_start_date pay_element_entries_f.effective_start_date%type;

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: --

Line 1443: l_effective_end_date pay_element_entries_f.effective_end_date%type;

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

Line 1547: l_effective_start_date pay_element_entries_f.effective_start_date%type;

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: --

Line 1548: l_effective_end_date pay_element_entries_f.effective_end_date%type;

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

Line 1593: l_element_entry_id pay_element_entries_f.element_entry_id%type;

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: --

Line 1594: l_object_version_number pay_element_entries_f.object_version_number%type;

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

Line 1595: l_effective_start_date pay_element_entries_f.effective_start_date%type;

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: (

Line 1596: l_effective_end_date pay_element_entries_f.effective_end_date%type;

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'

Line 1605: element_entry_id pay_element_entries_f.element_entry_id%type,

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,

Line 1607: assignment_id pay_element_entries_f.assignment_id%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: --

Line 1608: element_link_id pay_element_entries_f.element_link_id%type,

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,

Line 1609: entry_type pay_element_entries_f.entry_type%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,

Line 1610: object_version_number pay_element_entries_f.object_version_number%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,

Line 1612: attribute_category pay_element_entries_f.attribute_category%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,

Line 1613: attribute1 pay_element_entries_f.attribute1%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,

Line 1614: attribute2 pay_element_entries_f.attribute2%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,

Line 1615: attribute3 pay_element_entries_f.attribute3%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,

Line 1616: attribute4 pay_element_entries_f.attribute4%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,

Line 1617: attribute5 pay_element_entries_f.attribute5%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,

Line 1618: attribute6 pay_element_entries_f.attribute6%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,

Line 1619: attribute7 pay_element_entries_f.attribute7%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,

Line 1620: attribute8 pay_element_entries_f.attribute8%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,

Line 1621: attribute9 pay_element_entries_f.attribute9%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,

Line 1622: attribute10 pay_element_entries_f.attribute10%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,

Line 1623: attribute11 pay_element_entries_f.attribute11%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,

Line 1624: attribute12 pay_element_entries_f.attribute12%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,

Line 1625: attribute13 pay_element_entries_f.attribute13%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,

Line 1626: attribute14 pay_element_entries_f.attribute14%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,

Line 1627: attribute15 pay_element_entries_f.attribute15%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,

Line 1628: attribute16 pay_element_entries_f.attribute16%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,

Line 1629: attribute17 pay_element_entries_f.attribute17%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: --

Line 1630: attribute18 pay_element_entries_f.attribute18%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: --
1634: input_value_id1 pay_element_entry_values_f.input_value_id%type,

Line 1631: attribute19 pay_element_entries_f.attribute19%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,

Line 1632: attribute20 pay_element_entries_f.attribute20%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,