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

Line 127: WHERE ucol.user_table_id = p_user_tbl_id --fnd_number.canonical_to_number(l_eei_information9)

123: ,NULL
124: ,p_entit -- -999999 -999999 Band1
125: FROM pay_user_columns ucol
126: ,pay_user_rows_f urws
127: WHERE ucol.user_table_id = p_user_tbl_id --fnd_number.canonical_to_number(l_eei_information9)
128: AND ucol.user_column_name = p_band -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
129: AND urws.user_table_id = ucol.user_table_id
130: AND urws.row_low_range_or_name = p_lower -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'
131: AND SYSDATE BETWEEN urws.effective_start_date

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

880:
881: CURSOR csr_chk_primary_exists is
882: SELECT 'X'
883: FROM pay_element_type_extra_info
884: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)
885: AND eei_information16 = 'Y'
886: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
887: AND rownum = 1;
888:

Line 1633: ,x_lookup_code => fnd_number.number_to_canonical(

1629: x_rowid => l_rowid
1630: ,x_lookup_type => p_lookup_type
1631: ,x_security_group_id => p_security_group_id
1632: ,x_view_application_id => 3
1633: ,x_lookup_code => fnd_number.number_to_canonical(
1634: p_lookup_values(i).abs_type_id)
1635: ,x_tag => NULL
1636: ,x_attribute_category => NULL
1637: ,x_attribute1 => NULL

Line 1793: ,x_lookup_code => fnd_number.number_to_canonical(

1789: x_rowid => l_rowid
1790: ,x_lookup_type => p_lookup_type
1791: ,x_security_group_id => p_security_group_id
1792: ,x_view_application_id => 3
1793: ,x_lookup_code => fnd_number.number_to_canonical(
1794: p_lookup_values(i).plan_type_id)
1795: ,x_tag => NULL
1796: ,x_attribute_category => NULL
1797: ,x_attribute1 => NULL

Line 2621: l_eei_information9 := fnd_number.number_to_canonical

2617: -- l_udt_rows(1).row_high_range := '-1';
2618: -- l_udt_rows(1).business_group_id := NULL;
2619: -- l_udt_rows(1).legislation_code := 'GB';
2620:
2621: l_eei_information9 := fnd_number.number_to_canonical
2622: (create_udt (p_udt_type => l_udt_type
2623: ,p_udt_cols => l_udt_cols
2624: ,p_udt_rows => l_udt_rows
2625: )

Line 2678: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)

2674: ,NULL
2675: ,'100' -- -999999 -999999 Band1
2676: FROM pay_user_columns ucol
2677: ,pay_user_rows_f urws
2678: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2679: AND ucol.user_column_name = 'Band1' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2680: AND urws.user_table_id = ucol.user_table_id
2681: AND urws.row_low_range_or_name = '-999999' -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'
2682: AND SYSDATE BETWEEN urws.effective_start_date

Line 2709: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)

2705: ,NULL
2706: ,'50' -- -999999 -999999 Band2
2707: FROM pay_user_columns ucol
2708: ,pay_user_rows_f urws
2709: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2710: AND ucol.user_column_name = 'Band2' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2711: AND urws.user_table_id = ucol.user_table_id
2712: AND urws.row_low_range_or_name = '-999999' -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'
2713: AND SYSDATE BETWEEN urws.effective_start_date

Line 2741: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)

2737: ,NULL
2738: ,'182' -- 0 999999 Band1
2739: FROM pay_user_columns ucol
2740: ,pay_user_rows_f urws
2741: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2742: AND ucol.user_column_name = 'Band1' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2743: AND urws.user_table_id = ucol.user_table_id
2744: AND urws.row_low_range_or_name = '0' -- bad bad refer lookup code 'PQP_GAP_ENTITLEMENT_ROWS'.'GB_GAP_PERCENTAGE_ROW'
2745: AND SYSDATE BETWEEN urws.effective_start_date

Line 2773: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)

2769: ,NULL
2770: ,'183' -- 0 999999 Band2
2771: FROM pay_user_columns ucol
2772: ,pay_user_rows_f urws
2773: WHERE ucol.user_table_id = fnd_number.canonical_to_number(l_eei_information9)
2774: AND ucol.user_column_name = 'Band2' -- bad bad refer 'PQP_GAP_ENTITLEMENT_BANDS'.'BAND1'
2775: AND urws.user_table_id = ucol.user_table_id
2776: AND urws.row_low_range_or_name = '0' -- bad bad refer a variable set in prev section when creating this row
2777: AND SYSDATE BETWEEN urws.effective_start_date

Line 2814: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2810: p_bg_id =>p_bg_id
2811: ,p_band =>'Band1'
2812: ,p_entit =>'100'
2813: ,p_lower =>'-999999'
2814: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2815: );
2816:
2817: create_udt_entry(
2818: p_bg_id =>p_bg_id

Line 2822: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2818: p_bg_id =>p_bg_id
2819: ,p_band =>'Band2'
2820: ,p_entit =>'50'
2821: ,p_lower =>'-999999'
2822: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2823: );
2824:
2825: create_udt_entry(
2826: p_bg_id =>p_bg_id

Line 2830: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2826: p_bg_id =>p_bg_id
2827: ,p_band =>'Band1'
2828: ,p_entit =>'26'
2829: ,p_lower =>'0'
2830: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2831: );
2832:
2833:
2834: create_udt_entry(

Line 2839: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2835: p_bg_id =>p_bg_id
2836: ,p_band =>'Band1'
2837: ,p_entit =>'26'
2838: ,p_lower =>'4'
2839: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2840: );
2841:
2842: create_udt_entry(
2843: p_bg_id =>p_bg_id

Line 2847: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2843: p_bg_id =>p_bg_id
2844: ,p_band =>'Band2'
2845: ,p_entit =>'52'
2846: ,p_lower =>'4'
2847: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2848: );
2849:
2850: create_udt_entry(
2851: p_bg_id =>p_bg_id

Line 2855: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2851: p_bg_id =>p_bg_id
2852: ,p_band =>'Band1'
2853: ,p_entit =>'52'
2854: ,p_lower =>'12'
2855: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2856: );
2857:
2858: create_udt_entry(
2859: p_bg_id =>p_bg_id

Line 2863: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2859: p_bg_id =>p_bg_id
2860: ,p_band =>'Band2'
2861: ,p_entit =>'52'
2862: ,p_lower =>'12'
2863: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2864: );
2865:
2866: create_udt_entry(
2867: p_bg_id =>p_bg_id

Line 2871: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2867: p_bg_id =>p_bg_id
2868: ,p_band =>'Band1'
2869: ,p_entit =>'104'
2870: ,p_lower =>'24'
2871: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2872: );
2873:
2874: create_udt_entry(
2875: p_bg_id =>p_bg_id

Line 2879: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2875: p_bg_id =>p_bg_id
2876: ,p_band =>'Band2'
2877: ,p_entit =>'104'
2878: ,p_lower =>'24'
2879: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2880: );
2881:
2882: create_udt_entry(
2883: p_bg_id =>p_bg_id

Line 2887: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2883: p_bg_id =>p_bg_id
2884: ,p_band =>'Band1'
2885: ,p_entit =>'130'
2886: ,p_lower =>'36'
2887: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2888: );
2889:
2890: create_udt_entry(
2891: p_bg_id =>p_bg_id

Line 2895: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2891: p_bg_id =>p_bg_id
2892: ,p_band =>'Band2'
2893: ,p_entit =>'130'
2894: ,p_lower =>'36'
2895: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2896: );
2897:
2898: create_udt_entry(
2899: p_bg_id =>p_bg_id

Line 2903: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2899: p_bg_id =>p_bg_id
2900: ,p_band =>'Band1'
2901: ,p_entit =>'156'
2902: ,p_lower =>'60'
2903: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2904: );
2905:
2906: create_udt_entry(
2907: p_bg_id =>p_bg_id

Line 2911: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)

2907: p_bg_id =>p_bg_id
2908: ,p_band =>'Band2'
2909: ,p_entit =>'156'
2910: ,p_lower =>'60'
2911: ,p_user_tbl_id => fnd_number.canonical_to_number(l_eei_information9)
2912: );
2913:
2914:
2915:

Line 2924: l_eei_information9 := fnd_number.number_to_canonical

2920:
2921: ELSE
2922:
2923: -- Store the user_table_id for this udt name
2924: l_eei_information9 := fnd_number.number_to_canonical
2925: (p_abs_ent_sick_leaves);
2926:
2927: END IF; -- End if of p_abs_ent_sick_leaves null check ...
2928:

Line 2941: l_eei_information10 := fnd_number.number_to_canonical

2937:
2938: IF p_abs_ent_holidays IS NOT NULL THEN
2939:
2940: -- Store the user_table_id for this udt name
2941: l_eei_information10 := fnd_number.number_to_canonical
2942: (p_abs_ent_holidays);
2943:
2944: ELSE -- create the udt
2945:

Line 2976: l_eei_information10 := fnd_number.number_to_canonical(

2972:
2973: l_udt_rows.DELETE;
2974:
2975:
2976: l_eei_information10 := fnd_number.number_to_canonical(
2977: create_udt (p_udt_type => l_udt_type
2978: ,p_udt_cols => l_udt_cols
2979: ,p_udt_rows => l_udt_rows
2980: ) );

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

3055: pay_element_extra_info_api.create_element_extra_info
3056: (p_element_type_id => l_eei_element_type_id
3057: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3058: ,P_EEI_INFORMATION_CATEGORY => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3059: ,p_eei_information1 => fnd_number.number_to_canonical(p_plan_id)
3060: ,p_eei_information2 => p_plan_description
3061: ,p_eei_information3 => p_sch_cal_type
3062: ,p_eei_information4 => p_sch_cal_duration
3063: ,p_eei_information5 => p_sch_cal_uom

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

3104: pay_element_extra_info_api.create_element_extra_info
3105: (p_element_type_id => l_eei_element_type_id
3106: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3107: ,P_EEI_INFORMATION_CATEGORY => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3108: ,p_eei_information1 => fnd_number.number_to_canonical(p_plan_id)
3109: ,p_eei_information2 => p_plan_description
3110: ,p_eei_information3 => p_sch_cal_type
3111: ,p_eei_information4 => p_sch_cal_duration
3112: ,p_eei_information5 => p_sch_cal_uom

Line 3280: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt

3276:
3277: CURSOR csr_get_eei_info (c_element_type_id number)
3278: IS
3279: SELECT element_type_extra_info_id
3280: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt
3281: ,fnd_number.canonical_to_number(eei_information10) calendar_udt
3282: ,eei_information18 lookup_type
3283: ,eei_information24 plan_type_lookup
3284: FROM pay_element_type_extra_info petei

Line 3281: ,fnd_number.canonical_to_number(eei_information10) calendar_udt

3277: CURSOR csr_get_eei_info (c_element_type_id number)
3278: IS
3279: SELECT element_type_extra_info_id
3280: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt
3281: ,fnd_number.canonical_to_number(eei_information10) calendar_udt
3282: ,eei_information18 lookup_type
3283: ,eei_information24 plan_type_lookup
3284: FROM pay_element_type_extra_info petei
3285: WHERE element_type_id = c_element_type_id ;

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

3287: CURSOR csr_chk_eei_for_entudt (c_udt_id number)
3288: IS
3289: SELECT 'X'
3290: FROM pay_element_type_extra_info
3291: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3292: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)
3293: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3294: AND rownum = 1;
3295:

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

3288: IS
3289: SELECT 'X'
3290: FROM pay_element_type_extra_info
3291: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3292: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)
3293: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3294: AND rownum = 1;
3295:
3296: CURSOR csr_chk_eei_for_caludt (c_udt_id number)

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

3296: CURSOR csr_chk_eei_for_caludt (c_udt_id number)
3297: IS
3298: SELECT 'X'
3299: FROM pay_element_type_extra_info
3300: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3301: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)
3302: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3303: AND rownum = 1;
3304:

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

3297: IS
3298: SELECT 'X'
3299: FROM pay_element_type_extra_info
3300: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3301: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)
3302: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3303: AND rownum = 1;
3304:
3305: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)

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

3305: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)
3306: IS
3307: SELECT 'X'
3308: FROM pay_element_type_extra_info
3309: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3310: AND eei_information18 = c_lookup_type
3311: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3312: AND rownum = 1;
3313:

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

3331: AND ptco.template_id = pset.template_id -- For the base element
3332: AND ptco.shadow_object_id = pset.element_type_id -- find the core element
3333: AND ptco.core_object_type = 'ET'
3334: AND ptco.core_object_id = peei.element_type_id -- For the core element
3335: AND peei.eei_information1 = fnd_number.number_to_canonical(p_plan_id)
3336: AND peei.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO';
3337: -- find the eei info
3338:
3339: CURSOR csr_get_template_id (p_template_name IN VARCHAR2) is

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

3453:
3454: -- Check whether this lookup code is already added to
3455: -- the collection
3456:
3457: l_number := fnd_number.canonical_to_number(l_lookup_code);
3458:
3459: IF NOT l_lookup_collection.EXISTS(l_number) THEN
3460:
3461: l_lookup_collection(l_number) := l_number;

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

3559: -- Added p_delete_gap_entry cehck, to use the same function to delete
3560: -- any lookup.
3561: IF p_delete_gap_entry THEN
3562:
3563: IF NOT p_lookup_collection.EXISTS(fnd_number.canonical_to_number(
3564: l_lookup_code)) THEN
3565: fnd_lookup_values_pkg.delete_row
3566: (x_lookup_type => 'PQP_GAP_ABSENCE_TYPES_LIST'
3567: ,x_security_group_id => p_security_group_id

Line 4242: OPEN csr_chk_uniq_value (fnd_number.number_to_canonical(

4238: END IF;
4239:
4240: -- Check whether this lookup code already exists
4241:
4242: OPEN csr_chk_uniq_value (fnd_number.number_to_canonical(
4243: p_lookup_values(i).abs_type_id));
4244: FETCH csr_chk_uniq_value INTO l_exists;
4245:
4246: IF csr_chk_uniq_value%NOTFOUND THEN

Line 4279: ,x_lookup_code => fnd_number.number_to_canonical(

4275: x_rowid => l_rowid
4276: ,x_lookup_type => p_lookup_type
4277: ,x_security_group_id => p_security_group_id
4278: ,x_view_application_id => 3
4279: ,x_lookup_code => fnd_number.number_to_canonical(
4280: p_lookup_values(i).abs_type_id)
4281: ,x_tag => NULL
4282: ,x_attribute_category => NULL
4283: ,x_attribute1 => NULL