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.HXC_ALIAS_UTILITY dependencies on HR_GENERAL

Line 1964: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),

1960: if(l_public_template_for_pref_evl) THEN
1961: hxc_preference_evaluation.resource_preferences(
1962: p_resource_id => p_resource_id ,
1963: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1964: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1965: p_pref_table => l_pref_table);
1966: ELSE
1967: hxc_preference_evaluation.resource_preferences(
1968: p_resource_id => p_resource_id ,

Line 2597: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2593: l_index_global := l_index_global + 1;
2594: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE1;
2595: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_1';
2596: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2597: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2598: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2599:
2600:
2601:

Line 2598: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2594: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE1;
2595: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_1';
2596: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2597: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2598: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2599:
2600:
2601:
2602: END IF;

Line 2610: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2606: l_index_global := l_index_global + 1;
2607: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE2;
2608: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_2';
2609: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2610: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2611: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2612:
2613: END IF;
2614:

Line 2611: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2607: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE2;
2608: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_2';
2609: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2610: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2611: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2612:
2613: END IF;
2614:
2615: IF l_pref_table(l_index).ATTRIBUTE3 is not null THEN

Line 2621: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2617: l_index_global := l_index_global + 1;
2618: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE3;
2619: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_3';
2620: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2621: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2622: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2623:
2624: END IF;
2625:

Line 2622: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2618: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE3;
2619: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_3';
2620: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2621: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2622: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2623:
2624: END IF;
2625:
2626: IF l_pref_table(l_index).ATTRIBUTE4 is not null THEN

Line 2632: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2628: l_index_global := l_index_global + 1;
2629: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE4;
2630: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_4';
2631: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2632: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2633: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2634:
2635: END IF;
2636:

Line 2633: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2629: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE4;
2630: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_4';
2631: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2632: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2633: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2634:
2635: END IF;
2636:
2637: IF l_pref_table(l_index).ATTRIBUTE5 is not null THEN

Line 2643: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2639: l_index_global := l_index_global + 1;
2640: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE5;
2641: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_5';
2642: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2643: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2644: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2645:
2646: END IF;
2647:

Line 2644: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2640: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE5;
2641: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_5';
2642: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2643: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2644: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2645:
2646: END IF;
2647:
2648: IF l_pref_table(l_index).ATTRIBUTE6 is not null THEN

Line 2654: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2650: l_index_global := l_index_global + 1;
2651: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE6;
2652: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_6';
2653: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2654: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2655: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2656:
2657: END IF;
2658:

Line 2655: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2651: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE6;
2652: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_6';
2653: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2654: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2655: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2656:
2657: END IF;
2658:
2659: IF l_pref_table(l_index).ATTRIBUTE7 is not null THEN

Line 2665: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2661: l_index_global := l_index_global + 1;
2662: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE7;
2663: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_7';
2664: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2665: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2666: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2667:
2668: END IF;
2669:

Line 2666: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2662: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE7;
2663: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_7';
2664: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2665: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2666: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2667:
2668: END IF;
2669:
2670: IF l_pref_table(l_index).ATTRIBUTE8 is not null THEN

Line 2676: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2672: l_index_global := l_index_global + 1;
2673: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE8;
2674: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_8';
2675: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2676: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2677: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2678:
2679: END IF;
2680:

Line 2677: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2673: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE8;
2674: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_8';
2675: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2676: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2677: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2678:
2679: END IF;
2680:
2681: IF l_pref_table(l_index).ATTRIBUTE9 is not null THEN

Line 2687: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2683: l_index_global := l_index_global + 1;
2684: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE9;
2685: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_9';
2686: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2687: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2688: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2689:
2690: END IF;
2691:

Line 2688: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2684: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE9;
2685: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_9';
2686: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2687: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2688: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2689:
2690: END IF;
2691:
2692: IF l_pref_table(l_index).ATTRIBUTE10 is not null THEN

Line 2698: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2694: l_index_global := l_index_global + 1;
2695: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE10;
2696: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_10';
2697: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2698: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2699: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2700:
2701: END IF;
2702:

Line 2699: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2695: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE10;
2696: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_10';
2697: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2698: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2699: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2700:
2701: END IF;
2702:
2703: IF l_pref_table(l_index).ATTRIBUTE11 is not null THEN

Line 2709: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2705: l_index_global := l_index_global + 1;
2706: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE11;
2707: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_11';
2708: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2709: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2710: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2711:
2712: END IF;
2713:

Line 2710: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2706: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE11;
2707: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_11';
2708: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2709: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2710: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2711:
2712: END IF;
2713:
2714: IF l_pref_table(l_index).ATTRIBUTE12 is not null THEN

Line 2720: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2716: l_index_global := l_index_global + 1;
2717: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE12;
2718: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_12';
2719: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2720: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2721: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2722:
2723: END IF;
2724:

Line 2721: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2717: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE12;
2718: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_12';
2719: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2720: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2721: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2722:
2723: END IF;
2724:
2725: IF l_pref_table(l_index).ATTRIBUTE13 is not null THEN

Line 2731: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2727: l_index_global := l_index_global + 1;
2728: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE13;
2729: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_13';
2730: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2731: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2732: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2733:
2734: END IF;
2735:

Line 2732: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2728: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE13;
2729: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_13';
2730: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2731: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2732: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2733:
2734: END IF;
2735:
2736: IF l_pref_table(l_index).ATTRIBUTE14 is not null THEN

Line 2742: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2738: l_index_global := l_index_global + 1;
2739: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE14;
2740: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_14';
2741: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2742: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2743: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2744:
2745: END IF;
2746:

Line 2743: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2739: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE14;
2740: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_14';
2741: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2742: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2743: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2744:
2745: END IF;
2746:
2747: IF l_pref_table(l_index).ATTRIBUTE15 is not null THEN

Line 2753: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2749: l_index_global := l_index_global + 1;
2750: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE15;
2751: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_15';
2752: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2753: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2754: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2755:
2756: END IF;
2757:

Line 2754: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2750: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE15;
2751: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_15';
2752: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2753: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2754: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2755:
2756: END IF;
2757:
2758: IF l_pref_table(l_index).ATTRIBUTE16 is not null THEN

Line 2764: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2760: l_index_global := l_index_global + 1;
2761: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE16;
2762: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_16';
2763: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2764: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2765: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2766:
2767: END IF;
2768:

Line 2765: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2761: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE16;
2762: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_16';
2763: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2764: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2765: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2766:
2767: END IF;
2768:
2769: IF l_pref_table(l_index).ATTRIBUTE17 is not null THEN

Line 2775: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2771: l_index_global := l_index_global + 1;
2772: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE17;
2773: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_17';
2774: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2775: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2776: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2777:
2778: END IF;
2779:

Line 2776: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2772: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE17;
2773: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_17';
2774: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2775: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2776: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2777:
2778: END IF;
2779:
2780: IF l_pref_table(l_index).ATTRIBUTE18 is not null THEN

Line 2786: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2782: l_index_global := l_index_global + 1;
2783: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE18;
2784: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_18';
2785: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2786: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2787: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2788:
2789: END IF;
2790:

Line 2787: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2783: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE18;
2784: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_18';
2785: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2786: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2787: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2788:
2789: END IF;
2790:
2791: IF l_pref_table(l_index).ATTRIBUTE19 is not null THEN

Line 2797: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2793: l_index_global := l_index_global + 1;
2794: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE19;
2795: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_19';
2796: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2797: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2798: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2799:
2800: END IF;
2801:

Line 2798: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2794: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE19;
2795: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_19';
2796: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2797: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2798: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2799:
2800: END IF;
2801:
2802: IF l_pref_table(l_index).ATTRIBUTE20 is not null THEN

Line 2808: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;

2804: l_index_global := l_index_global + 1;
2805: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE20;
2806: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_20';
2807: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2808: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2809: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2810:
2811: END IF;
2812: END IF;

Line 2809: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;

2805: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE20;
2806: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_20';
2807: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2808: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2809: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2810:
2811: END IF;
2812: END IF;
2813:

Line 2948: ' and nvl(t.start_date_active,hr_general.start_of_time) <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||

2944: ' flex_value_id id_value '||
2945: ' from fnd_flex_values_vl t'||
2946: ' where t.flex_value_set_id = '||p_vset_id||
2947: ' and t.enabled_flag=''Y''' ||
2948: ' and nvl(t.start_date_active,hr_general.start_of_time) <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
2949: ' and nvl(t.end_date_active,hr_general.end_of_time) >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') ';
2950:
2951:
2952: END IF;

Line 2949: ' and nvl(t.end_date_active,hr_general.end_of_time) >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') ';

2945: ' from fnd_flex_values_vl t'||
2946: ' where t.flex_value_set_id = '||p_vset_id||
2947: ' and t.enabled_flag=''Y''' ||
2948: ' and nvl(t.start_date_active,hr_general.start_of_time) <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
2949: ' and nvl(t.end_date_active,hr_general.end_of_time) >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') ';
2950:
2951:
2952: END IF;
2953: -- test the SQL

Line 3424: 'AND nvl(date_to,hr_general.end_of_time) >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||

3420:
3421: 'AND ELEMENT.EFFECTIVE_START_DATE <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
3422: 'AND ELEMENT.EFFECTIVE_END_DATE >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||
3423: 'AND date_from <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
3424: 'AND nvl(date_to,hr_general.end_of_time) >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||
3425: 'AND ASGT.EFFECTIVE_START_DATE <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
3426: 'AND ASGT.EFFECTIVE_END_DATE >=FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||
3427: 'AND LINK.EFFECTIVE_START_DATE <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
3428: 'AND LINK.EFFECTIVE_END_DATE >=FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||

Line 3441: ' hr_general.end_of_time), '||

3437: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3438: ' AND FND_PROFILE.VALUE(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3439: ' ''L'', SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, '||
3440: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3441: ' hr_general.end_of_time), '||
3442: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3443:
3444: ELSIF l_reference_object = 'PAYROLL_ELEMENTS' THEN
3445:

Line 3470: ' and nvl(hav.date_to,hr_general.end_of_time) >=FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||

3466: ' AND ELEMENT.EFFECTIVE_END_DATE >= FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||
3467: ' and havt.language = USERENV(''LANG'') '||
3468: ' and havt.alias_value_id = hav.alias_value_id '||
3469: ' and hav.date_from <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
3470: ' and nvl(hav.date_to,hr_general.end_of_time) >=FND_PROFILE.VALUE(''OTL_TK_START_DATE'') '||
3471: ' and ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID '||
3472: ' AND ELEMENTTL.LANGUAGE = USERENV(''LANG'') '||
3473: ' AND CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID (+) '||
3474: ' AND DECODE(CLASSIFICATIONTL.CLASSIFICATION_ID,NULL,''1'',CLASSIFICATIONTL.LANGUAGE) = '||

Line 3522: ' ''L'', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, hr_general.end_of_time),'||

3518: ' AND (ELEMENT.PROCESSING_TYPE = ''R'' OR ASGT.PAYROLL_ID IS NOT NULL) '||
3519: ' AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL '||
3520: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3521: ' AND FND_PROFILE.VALUE(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3522: ' ''L'', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, hr_general.end_of_time),'||
3523: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3524: ' hr_general.end_of_time), '||
3525: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3526: ELSE

Line 3524: ' hr_general.end_of_time), '||

3520: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3521: ' AND FND_PROFILE.VALUE(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3522: ' ''L'', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, hr_general.end_of_time),'||
3523: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3524: ' hr_general.end_of_time), '||
3525: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3526: ELSE
3527:
3528: x_select := 'select havt.alias_value_name Display_Value,'||

Line 3539: ' and nvl(hav.date_to,hr_general.end_of_time) >=FND_PROFILE.VALUE(''OTL_TK_START_DATE'') ';

3535: ' and had.alias_definition_id = '||p_alias_definition_id||
3536: ' and havt.language = USERENV(''LANG'') '||
3537: ' and havt.alias_value_id = hav.alias_value_id '||
3538: ' and hav.date_from <= FND_PROFILE.VALUE(''OTL_TK_END_DATE'') '||
3539: ' and nvl(hav.date_to,hr_general.end_of_time) >=FND_PROFILE.VALUE(''OTL_TK_START_DATE'') ';
3540: END IF;
3541:
3542: ELSE
3543: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');