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_UNPAID_TEMPLATE dependencies on FND_NUMBER

Line 737: ,x_lookup_code => fnd_number.number_to_canonical(

733: x_rowid => l_rowid
734: ,x_lookup_type => p_lookup_type
735: ,x_security_group_id => p_security_group_id
736: ,x_view_application_id => 3
737: ,x_lookup_code => fnd_number.number_to_canonical(
738: p_lookup_values(i).abs_type_id)
739: ,x_tag => NULL
740: ,x_attribute_category => NULL
741: ,x_attribute1 => NULL

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

958:
959: CURSOR csr_chk_primary_exists is
960: SELECT 'X'
961: FROM pay_element_type_extra_info
962: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)
963: AND eei_information16 = 'Y'
964: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
965: AND rownum = 1;
966:

Line 1314: l_eei_information9 := fnd_number.number_to_canonical

1310: IF g_debug THEN
1311: debug(l_proc_name, l_proc_step);
1312: END IF;
1313:
1314: l_eei_information9 := fnd_number.number_to_canonical
1315: (p_abs_ent_sick_leaves);
1316:
1317: l_proc_step := 150;
1318: IF g_debug THEN

Line 1329: l_eei_information10 := fnd_number.number_to_canonical

1325:
1326: IF p_abs_ent_holidays IS NOT NULL THEN
1327:
1328: -- Store the user_table_id for this udt name
1329: l_eei_information10 := fnd_number.number_to_canonical
1330: (p_abs_ent_holidays);
1331:
1332: ELSE -- create the udt
1333:

Line 1365: fnd_number.number_to_canonical(

1361: l_udt_rows.DELETE;
1362:
1363:
1364: l_eei_information10 :=
1365: fnd_number.number_to_canonical(
1366: create_udt (
1367: p_udt_type => l_udt_type
1368: ,p_udt_cols => l_udt_cols
1369: ,p_udt_rows => l_udt_rows

Line 1441: ,p_eei_information1 => fnd_number.number_to_canonical(p_plan_id)

1437: pay_element_extra_info_api.create_element_extra_info
1438: (p_element_type_id => l_eei_element_type_id
1439: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1440: ,P_EEI_INFORMATION_CATEGORY => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1441: ,p_eei_information1 => fnd_number.number_to_canonical(p_plan_id)
1442: ,p_eei_information2 => p_plan_description
1443: ,p_eei_information8 => p_abs_days
1444: ,p_eei_information9 => l_eei_information9
1445: ,p_eei_information10 => l_eei_information10

Line 1483: ,p_eei_information1 => fnd_number.number_to_canonical(p_plan_id)

1479: pay_element_extra_info_api.create_element_extra_info
1480: (p_element_type_id => l_eei_element_type_id
1481: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1482: ,P_EEI_INFORMATION_CATEGORY => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1483: ,p_eei_information1 => fnd_number.number_to_canonical(p_plan_id)
1484: ,p_eei_information2 => p_plan_description
1485: ,p_eei_information8 => p_abs_days
1486: ,p_eei_information9 => l_eei_information9
1487: ,p_eei_information10 => l_eei_information10

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

1650:
1651: -- Check whether this lookup code is already added to
1652: -- the collection
1653:
1654: l_number := fnd_number.canonical_to_number(l_lookup_code);
1655:
1656: IF NOT l_lookup_collection.EXISTS(l_number) THEN
1657:
1658: l_lookup_collection(l_number) := l_number;

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

1747: debug(l_proc_name, l_proc_step);
1748: END IF;
1749:
1750:
1751: IF NOT p_lookup_collection.EXISTS(fnd_number.canonical_to_number(
1752: l_lookup_code)) THEN
1753: fnd_lookup_values_pkg.delete_row
1754: (x_lookup_type => 'PQP_GAP_ABSENCE_TYPES_LIST'
1755: ,x_security_group_id => p_security_group_id

Line 1995: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt

1991:
1992: CURSOR csr_get_eei_info (c_element_type_id number)
1993: IS
1994: SELECT element_type_extra_info_id
1995: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt
1996: ,fnd_number.canonical_to_number(eei_information10) calendar_udt
1997: ,eei_information18 lookup_type
1998: FROM pay_element_type_extra_info petei
1999: WHERE element_type_id = c_element_type_id ;

Line 1996: ,fnd_number.canonical_to_number(eei_information10) calendar_udt

1992: CURSOR csr_get_eei_info (c_element_type_id number)
1993: IS
1994: SELECT element_type_extra_info_id
1995: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt
1996: ,fnd_number.canonical_to_number(eei_information10) calendar_udt
1997: ,eei_information18 lookup_type
1998: FROM pay_element_type_extra_info petei
1999: WHERE element_type_id = c_element_type_id ;
2000:

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

2001: CURSOR csr_chk_eei_for_entudt (c_udt_id number)
2002: IS
2003: SELECT 'X'
2004: FROM pay_element_type_extra_info
2005: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2006: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)
2007: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2008: AND rownum = 1;
2009:

Line 2006: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)

2002: IS
2003: SELECT 'X'
2004: FROM pay_element_type_extra_info
2005: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2006: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)
2007: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2008: AND rownum = 1;
2009:
2010: CURSOR csr_chk_eei_for_caludt (c_udt_id number)

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

2010: CURSOR csr_chk_eei_for_caludt (c_udt_id number)
2011: IS
2012: SELECT 'X'
2013: FROM pay_element_type_extra_info
2014: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2015: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)
2016: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2017: AND rownum = 1;
2018:

Line 2015: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)

2011: IS
2012: SELECT 'X'
2013: FROM pay_element_type_extra_info
2014: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2015: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)
2016: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2017: AND rownum = 1;
2018:
2019: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)

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

2019: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)
2020: IS
2021: SELECT 'X'
2022: FROM pay_element_type_extra_info
2023: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2024: AND eei_information18 = c_lookup_type
2025: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2026: AND rownum = 1;
2027:

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

2044: AND ptco.template_id = pset.template_id -- For the base element
2045: AND ptco.shadow_object_id = pset.element_type_id -- find the core element
2046: AND ptco.core_object_type = 'ET'
2047: AND ptco.core_object_id = peei.element_type_id -- For the core element
2048: AND peei.eei_information1 = fnd_number.number_to_canonical(p_plan_id)
2049: AND peei.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO';
2050: -- find the eei info
2051:
2052: CURSOR csr_get_template_id (p_template_name IN VARCHAR2) is