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.PQP_GB_OMP_TEMPLATE dependencies on FND_NUMBER

Line 225: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)

221:
222: CURSOR csr_chk_primary_exists is
223: SELECT 'X'
224: FROM pay_element_type_extra_info
225: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)
226: AND eei_information17 = 'Y'
227: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
228: AND rownum = 1;
229:

Line 749: ,x_lookup_code => fnd_number.number_to_canonical(

745: x_rowid => l_rowid
746: ,x_lookup_type => p_lookup_type
747: ,x_security_group_id => p_security_group_id
748: ,x_view_application_id => 3
749: ,x_lookup_code => fnd_number.number_to_canonical(
750: p_lookup_values(i).abs_type_id)
751: ,x_tag => NULL
752: ,x_attribute_category => NULL
753: ,x_attribute1 => NULL

Line 905: OPEN csr_chk_uniq_value (fnd_number.number_to_canonical(

901:
902: hr_utility.set_location(l_proc_name, 50);
903: -- Check whether this lookup code already exists
904:
905: OPEN csr_chk_uniq_value (fnd_number.number_to_canonical(
906: p_lookup_values(i).abs_type_id));
907: FETCH csr_chk_uniq_value INTO l_exists;
908:
909: IF csr_chk_uniq_value%NOTFOUND THEN

Line 934: ,x_lookup_code => fnd_number.number_to_canonical(

930: x_rowid => l_rowid
931: ,x_lookup_type => p_lookup_type
932: ,x_security_group_id => p_security_group_id
933: ,x_view_application_id => 3
934: ,x_lookup_code => fnd_number.number_to_canonical(
935: p_lookup_values(i).abs_type_id)
936: ,x_tag => NULL
937: ,x_attribute_category => NULL
938: ,x_attribute1 => NULL

Line 1427: l_eei_information11 := fnd_number.number_to_canonical

1423: l_udt_rows(2).row_high_range := '-888888';
1424: l_udt_rows(2).business_group_id := NULL;
1425: l_udt_rows(2).legislation_code := 'GB';
1426:
1427: l_eei_information11 := fnd_number.number_to_canonical
1428: (create_udt (p_udt_type => l_udt_type
1429: ,p_udt_cols => l_udt_cols
1430: ,p_udt_rows => l_udt_rows
1431: )

Line 1437: l_eei_information11 := fnd_number.number_to_canonical

1433:
1434: ELSE
1435:
1436: -- Store the user_table_id for this udt name
1437: l_eei_information11 := fnd_number.number_to_canonical
1438: (p_maternity_abse_ent_udt);
1439:
1440: END IF; -- End if of p_maternity_abse_ent_udt null check ...
1441:

Line 1452: l_eei_information12 := fnd_number.number_to_canonical

1448: l_eei_information12 := NULL;
1449: -- Use Existing UDT
1450: ELSIF p_holidays_udt <> -1 THEN
1451: -- Store the user_table_id for this udt name
1452: l_eei_information12 := fnd_number.number_to_canonical
1453: (p_holidays_udt);
1454: END IF;
1455:
1456: ELSE -- create the udt

Line 1475: l_eei_information12 := fnd_number.number_to_canonical(

1471: l_udt_cols(1).legislation_code := 'GB';
1472:
1473: l_udt_rows.DELETE;
1474:
1475: l_eei_information12 := fnd_number.number_to_canonical(
1476: create_udt (p_udt_type => l_udt_type
1477: ,p_udt_cols => l_udt_cols
1478: ,p_udt_rows => l_udt_rows
1479: ) );

Line 1527: fnd_number.number_to_canonical(p_plan_id)

1523: (p_element_type_id => l_eei_element_type_id
1524: ,p_information_type => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1525: ,P_EEI_INFORMATION_CATEGORY => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1526: ,p_eei_information1 =>
1527: fnd_number.number_to_canonical(p_plan_id)
1528: ,p_eei_information2 => p_plan_description
1529: ,p_eei_information3 => p_los_calc
1530: ,p_eei_information4 => p_los_calc_duration
1531: ,p_eei_information5 => p_los_calc_uom

Line 1561: fnd_number.number_to_canonical(p_plan_id)

1557: (p_element_type_id => l_eei_element_type_id
1558: ,p_information_type => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1559: ,P_EEI_INFORMATION_CATEGORY => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1560: ,p_eei_information1 =>
1561: fnd_number.number_to_canonical(p_plan_id)
1562: ,p_eei_information2 => p_plan_description
1563: ,p_eei_information3 => p_los_calc
1564: ,p_eei_information4 => p_los_calc_duration
1565: ,p_eei_information5 => p_los_calc_uom

Line 1677: ,fnd_number.canonical_to_number(eei_information11) entitlement_udt

1673: AND pet.core_object_type = 'ET';
1674:
1675: CURSOR csr_get_eei_info (c_element_type_id number) IS
1676: SELECT element_type_extra_info_id
1677: ,fnd_number.canonical_to_number(eei_information11) entitlement_udt
1678: ,fnd_number.canonical_to_number(eei_information12) calendar_udt
1679: ,eei_information20 lookup_type
1680: FROM pay_element_type_extra_info petei
1681: WHERE element_type_id = c_element_type_id ;

Line 1678: ,fnd_number.canonical_to_number(eei_information12) calendar_udt

1674:
1675: CURSOR csr_get_eei_info (c_element_type_id number) IS
1676: SELECT element_type_extra_info_id
1677: ,fnd_number.canonical_to_number(eei_information11) entitlement_udt
1678: ,fnd_number.canonical_to_number(eei_information12) calendar_udt
1679: ,eei_information20 lookup_type
1680: FROM pay_element_type_extra_info petei
1681: WHERE element_type_id = c_element_type_id ;
1682:

Line 1686: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)

1682:
1683: CURSOR csr_chk_eei_for_entudt (c_udt_id number) IS
1684: SELECT 'x'
1685: FROM pay_element_type_extra_info
1686: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1687: AND eei_information11 = fnd_number.number_to_canonical(c_udt_id)
1688: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1689: AND rownum = 1;
1690:

Line 1687: AND eei_information11 = fnd_number.number_to_canonical(c_udt_id)

1683: CURSOR csr_chk_eei_for_entudt (c_udt_id number) IS
1684: SELECT 'x'
1685: FROM pay_element_type_extra_info
1686: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1687: AND eei_information11 = fnd_number.number_to_canonical(c_udt_id)
1688: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1689: AND rownum = 1;
1690:
1691: CURSOR csr_chk_eei_for_caludt (c_udt_id number) IS

Line 1694: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)

1690:
1691: CURSOR csr_chk_eei_for_caludt (c_udt_id number) IS
1692: SELECT 'x'
1693: FROM pay_element_type_extra_info
1694: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1695: AND eei_information12 = fnd_number.number_to_canonical(c_udt_id)
1696: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1697: AND rownum = 1;
1698:

Line 1695: AND eei_information12 = fnd_number.number_to_canonical(c_udt_id)

1691: CURSOR csr_chk_eei_for_caludt (c_udt_id number) IS
1692: SELECT 'x'
1693: FROM pay_element_type_extra_info
1694: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1695: AND eei_information12 = fnd_number.number_to_canonical(c_udt_id)
1696: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1697: AND rownum = 1;
1698:
1699: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)

Line 1703: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)

1699: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)
1700: IS
1701: SELECT 'x'
1702: FROM pay_element_type_extra_info
1703: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1704: AND eei_information20 = c_lookup_type
1705: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1706: AND rownum = 1;
1707:

Line 1728: AND peei.eei_information1 = fnd_number.number_to_canonical(p_plan_id)

1724: AND ptco.template_id = pset.template_id -- For the base element
1725: AND ptco.shadow_object_id = pset.element_type_id -- find the core element
1726: AND ptco.core_object_type = 'ET'
1727: AND ptco.core_object_id = peei.element_type_id -- For the core element
1728: AND peei.eei_information1 = fnd_number.number_to_canonical(p_plan_id)
1729: AND peei.information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO';
1730: -- find the eei info
1731:
1732: CURSOR csr_get_template_id (p_template_name IN VARCHAR2) is

Line 1834: l_number := fnd_number.canonical_to_number(l_lookup_code);

1830:
1831: -- Check whether this lookup code is already added to
1832: -- the collection
1833:
1834: l_number := fnd_number.canonical_to_number(l_lookup_code);
1835:
1836: IF NOT l_lookup_collection.EXISTS(l_number) THEN
1837:
1838: l_lookup_collection(l_number) := l_number;

Line 1927: IF NOT p_lookup_collection.EXISTS(fnd_number.canonical_to_number(

1923: -- from PQP_GAP_ABSENCE_TYPES_LIST lookup type
1924:
1925: hr_utility.set_location (l_proc_name, 25);
1926:
1927: IF NOT p_lookup_collection.EXISTS(fnd_number.canonical_to_number(
1928: l_lookup_code)) THEN
1929: fnd_lookup_values_pkg.delete_row
1930: (x_lookup_type => 'PQP_GAP_ABSENCE_TYPES_LIST'
1931: ,x_security_group_id => p_security_group_id