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.PY_FI_TAX_CARD dependencies on PAY_ELEMENT_ENTRIES_F

Line 361: -- insert records into pay_element_entries_f and pay_element_entry_values_f

357: end if;
358: if g_debug then
359: hr_utility.set_location('Entering:'|| l_proc, 4);
360: end if;
361: -- insert records into pay_element_entries_f and pay_element_entry_values_f
362: pay_element_entry_api.create_element_entry
363: (p_effective_date => p_effective_date
364: ,p_business_group_id => p_business_group_id
365: ,p_assignment_id => p_assignment_id

Line 508: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,

504: where session_id = userenv('sessionid')
505: and effective_date = p_effective_date;
506: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
507:
508: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
509: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
510: l_element_name IN pay_element_types_f.element_name%TYPE,
511: l_effective_date IN VARCHAR2) IS
512: SELECT pee.element_entry_id,pee.OBJECT_VERSION_NUMBER EE_OVN

Line 515: pay_element_entries_f pee

511: l_effective_date IN VARCHAR2) IS
512: SELECT pee.element_entry_id,pee.OBJECT_VERSION_NUMBER EE_OVN
513: FROM pay_element_types_f pet ,
514: pay_element_links_f pel ,
515: pay_element_entries_f pee
516: WHERE pet.element_name = l_element_name
517: AND pet.legislation_code = 'FI'
518: AND pet.business_group_id IS NULL
519: AND fnd_date.chardate_to_date(l_effective_date)

Line 584: -- insert records into pay_element_entries_f and pay_element_entry_values_f

580:
581: if g_debug then
582: hr_utility.set_location('Entering:'|| l_proc, 4);
583: end if;
584: -- insert records into pay_element_entries_f and pay_element_entry_values_f
585: OPEN cIsElementAttached(p_assignment_id , p_business_group_id , 'Tax' , p_effective_date);
586: FETCH cIsElementAttached INTO lrIsElementAttached;
587: IF cIsElementAttached%NOTFOUND THEN
588:

Line 1102: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1098: --declarations here
1099: l_start_date DATE;
1100: l_end_date DATE;
1101: l_warning BOOLEAN;
1102: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1103: l_ovn pay_element_entries_f.object_version_number%TYPE;
1104:
1105: l_proc varchar2(72) := g_package||'update_taxcard';
1106: BEGIN

Line 1103: l_ovn pay_element_entries_f.object_version_number%TYPE;

1099: l_start_date DATE;
1100: l_end_date DATE;
1101: l_warning BOOLEAN;
1102: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1103: l_ovn pay_element_entries_f.object_version_number%TYPE;
1104:
1105: l_proc varchar2(72) := g_package||'update_taxcard';
1106: BEGIN
1107: if g_debug then

Line 1118: -- insert records into pay_element_entries_f and pay_element_entry_values_f

1114: --'Tax Card',p_effective_date);
1115:
1116: l_element_entry_id := p_element_entry_id_tc;
1117:
1118: -- insert records into pay_element_entries_f and pay_element_entry_values_f
1119: pay_element_entry_api.update_element_entry
1120: (p_validate => FALSE
1121: ,p_object_version_number => l_ovn
1122: ,p_update_warning => l_warning

Line 1295: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1291: --declarations here
1292: l_start_date DATE;
1293: l_end_date DATE;
1294: l_warning BOOLEAN;
1295: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1296: l_ovn pay_element_entries_f.object_version_number%TYPE;
1297:
1298: l_proc varchar2(72) := g_package||'update_tax';
1299: BEGIN

Line 1296: l_ovn pay_element_entries_f.object_version_number%TYPE;

1292: l_start_date DATE;
1293: l_end_date DATE;
1294: l_warning BOOLEAN;
1295: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1296: l_ovn pay_element_entries_f.object_version_number%TYPE;
1297:
1298: l_proc varchar2(72) := g_package||'update_tax';
1299: BEGIN
1300: if g_debug then

Line 1309: -- insert records into pay_element_entries_f and pay_element_entry_values_f

1305: --l_element_entry_id := find_element_entry_id(p_assignment_id, p_business_group_id,
1306: -- 'Tax',p_effective_date);
1307: l_element_entry_id := p_element_entry_id_t;
1308:
1309: -- insert records into pay_element_entries_f and pay_element_entry_values_f
1310: pay_element_entry_api.update_element_entry
1311: (p_validate => FALSE
1312: ,p_object_version_number => l_ovn
1313: ,p_update_warning => l_warning

Line 1431: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,

1427: -- Private. For Internal Development Use only.
1428: --
1429: -- {End Of Comments}
1430: FUNCTION find_element_entry_id (
1431: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1432: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,
1433: p_element_name IN pay_element_types_f.element_name%TYPE,
1434: p_effective_date IN VARCHAR2) RETURN pay_element_entries_f.element_entry_id%TYPE IS
1435:

Line 1434: p_effective_date IN VARCHAR2) RETURN pay_element_entries_f.element_entry_id%TYPE IS

1430: FUNCTION find_element_entry_id (
1431: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1432: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,
1433: p_element_name IN pay_element_types_f.element_name%TYPE,
1434: p_effective_date IN VARCHAR2) RETURN pay_element_entries_f.element_entry_id%TYPE IS
1435:
1436: --declarations here
1437: l_attached_flag BOOLEAN;
1438: l_csr_result pay_element_entries_f.element_entry_id%TYPE;

Line 1438: l_csr_result pay_element_entries_f.element_entry_id%TYPE;

1434: p_effective_date IN VARCHAR2) RETURN pay_element_entries_f.element_entry_id%TYPE IS
1435:
1436: --declarations here
1437: l_attached_flag BOOLEAN;
1438: l_csr_result pay_element_entries_f.element_entry_id%TYPE;
1439: CURSOR cGetElementEntryId(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
1440: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
1441: l_element_name IN pay_element_types_f.element_name%TYPE,
1442: l_effective_date IN VARCHAR2) IS

Line 1439: CURSOR cGetElementEntryId(l_asgid IN pay_element_entries_f.assignment_id%TYPE,

1435:
1436: --declarations here
1437: l_attached_flag BOOLEAN;
1438: l_csr_result pay_element_entries_f.element_entry_id%TYPE;
1439: CURSOR cGetElementEntryId(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
1440: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
1441: l_element_name IN pay_element_types_f.element_name%TYPE,
1442: l_effective_date IN VARCHAR2) IS
1443: SELECT pee.element_entry_id

Line 1446: pay_element_entries_f pee

1442: l_effective_date IN VARCHAR2) IS
1443: SELECT pee.element_entry_id
1444: FROM pay_element_types_f pet ,
1445: pay_element_links_f pel ,
1446: pay_element_entries_f pee
1447: WHERE pet.element_name = l_element_name
1448: AND pet.legislation_code = 'FI'
1449: AND pet.business_group_id IS NULL
1450: AND fnd_date.canonical_to_date(l_effective_date)

Line 1495: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,

1491: -- Private. For Internal Development Use only.
1492: --
1493: -- {End Of Comments}
1494: FUNCTION is_element_started_today (
1495: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1496: p_element_name IN pay_element_types_f.element_name%TYPE,
1497: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1498:
1499: --declarations here

Line 1502: from pay_element_entries_f pee,

1498:
1499: --declarations here
1500: Cursor cElementStartedToday(c_effective_date VARCHAR2, c_element_name pay_element_types_f.element_name%TYPE , c_asg_id per_all_assignments_f.assignment_id%TYPE) IS
1501: select pee.element_entry_id
1502: from pay_element_entries_f pee,
1503: pay_element_types_f pet
1504: where pee.element_type_id = pet.element_type_id
1505: and pet.element_name = c_element_name
1506: and c_effective_date between pet.effective_start_date and pet.effective_end_date

Line 1510: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1506: and c_effective_date between pet.effective_start_date and pet.effective_end_date
1507: and pee.assignment_id = c_asg_id
1508: and c_effective_date between pee.effective_start_date and pee.effective_end_date
1509: and pee.effective_start_date = c_effective_date;
1510: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1511: BEGIN
1512: open cElementStartedToday(p_effective_date,p_element_name,p_assignment_id);
1513: fetch cElementStartedToday into l_element_entry_id;
1514: IF cElementStartedToday%NOTFOUND THEN

Line 1604: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,

1600: -- Private. For Internal Development Use only.
1601: --
1602: -- {End Of Comments}
1603: FUNCTION is_element_attached (
1604: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1605: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,
1606: p_element_name IN pay_element_types_f.element_name%TYPE,
1607: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1608:

Line 1611: l_csr_result pay_element_entries_f.element_entry_id%TYPE;

1607: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1608:
1609: --declarations here
1610: l_attached_flag BOOLEAN;
1611: l_csr_result pay_element_entries_f.element_entry_id%TYPE;
1612: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
1613: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
1614: l_element_name IN pay_element_types_f.element_name%TYPE,
1615: l_effective_date IN VARCHAR2) IS

Line 1612: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,

1608:
1609: --declarations here
1610: l_attached_flag BOOLEAN;
1611: l_csr_result pay_element_entries_f.element_entry_id%TYPE;
1612: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
1613: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
1614: l_element_name IN pay_element_types_f.element_name%TYPE,
1615: l_effective_date IN VARCHAR2) IS
1616: SELECT pee.element_entry_id

Line 1619: pay_element_entries_f pee

1615: l_effective_date IN VARCHAR2) IS
1616: SELECT pee.element_entry_id
1617: FROM pay_element_types_f pet ,
1618: pay_element_links_f pel ,
1619: pay_element_entries_f pee
1620: WHERE pet.element_name = l_element_name
1621: AND pet.legislation_code = 'FI'
1622: AND pet.business_group_id IS NULL
1623: AND fnd_date.chardate_to_date(l_effective_date)

Line 1652: -- This API returns the DT modes for pay_element_entries_f for a given

1648: -- ----------------------------------------------------------------------------
1649: -- {Start Of Comments}
1650: --
1651: -- Description:
1652: -- This API returns the DT modes for pay_element_entries_f for a given
1653: -- element_entry_id (base key value) on a specified date
1654: --
1655: -- Prerequisites:
1656: -- The element_entry (p_base_key_value) must exist as of the effective date

Line 1717: ,p_base_table_name => 'pay_element_entries_f'

1713: -- Call the corresponding datetrack api
1714: --
1715: dt_api.find_dt_upd_modes_and_dates(
1716: p_effective_date => p_effective_date
1717: ,p_base_table_name => 'pay_element_entries_f'
1718: ,p_base_key_column => 'ELEMENT_ENTRY_ID'
1719: ,p_base_key_value => p_base_key_value
1720: ,p_correction => p_correction
1721: ,p_update => p_update