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 1648: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),

1644: if(l_public_template_for_pref_evl) THEN
1645: hxc_preference_evaluation.resource_preferences(
1646: p_resource_id => p_resource_id ,
1647: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1648: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1649: p_pref_table => l_pref_table);
1650: ELSE
1651: hxc_preference_evaluation.resource_preferences(
1652: p_resource_id => p_resource_id ,

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

2277: l_index_global := l_index_global + 1;
2278: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE1;
2279: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_1';
2280: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2281: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2282: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2283:
2284:
2285:

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

2278: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE1;
2279: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_1';
2280: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2281: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2282: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2283:
2284:
2285:
2286: END IF;

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

2290: l_index_global := l_index_global + 1;
2291: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE2;
2292: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_2';
2293: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2294: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2295: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2296:
2297: END IF;
2298:

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

2291: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE2;
2292: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_2';
2293: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2294: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2295: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2296:
2297: END IF;
2298:
2299: IF l_pref_table(l_index).ATTRIBUTE3 is not null THEN

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

2301: l_index_global := l_index_global + 1;
2302: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE3;
2303: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_3';
2304: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2305: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2306: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2307:
2308: END IF;
2309:

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

2302: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE3;
2303: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_3';
2304: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2305: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2306: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2307:
2308: END IF;
2309:
2310: IF l_pref_table(l_index).ATTRIBUTE4 is not null THEN

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

2312: l_index_global := l_index_global + 1;
2313: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE4;
2314: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_4';
2315: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2316: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2317: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2318:
2319: END IF;
2320:

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

2313: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE4;
2314: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_4';
2315: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2316: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2317: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2318:
2319: END IF;
2320:
2321: IF l_pref_table(l_index).ATTRIBUTE5 is not null THEN

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

2323: l_index_global := l_index_global + 1;
2324: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE5;
2325: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_5';
2326: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2327: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2328: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2329:
2330: END IF;
2331:

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

2324: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE5;
2325: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_5';
2326: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2327: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2328: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2329:
2330: END IF;
2331:
2332: IF l_pref_table(l_index).ATTRIBUTE6 is not null THEN

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

2334: l_index_global := l_index_global + 1;
2335: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE6;
2336: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_6';
2337: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2338: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2339: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2340:
2341: END IF;
2342:

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

2335: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE6;
2336: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_6';
2337: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2338: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2339: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2340:
2341: END IF;
2342:
2343: IF l_pref_table(l_index).ATTRIBUTE7 is not null THEN

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

2345: l_index_global := l_index_global + 1;
2346: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE7;
2347: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_7';
2348: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2349: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2350: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2351:
2352: END IF;
2353:

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

2346: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE7;
2347: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_7';
2348: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2349: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2350: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2351:
2352: END IF;
2353:
2354: IF l_pref_table(l_index).ATTRIBUTE8 is not null THEN

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

2356: l_index_global := l_index_global + 1;
2357: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE8;
2358: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_8';
2359: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2360: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2361: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2362:
2363: END IF;
2364:

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

2357: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE8;
2358: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_8';
2359: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2360: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2361: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2362:
2363: END IF;
2364:
2365: IF l_pref_table(l_index).ATTRIBUTE9 is not null THEN

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

2367: l_index_global := l_index_global + 1;
2368: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE9;
2369: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_9';
2370: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2371: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2372: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2373:
2374: END IF;
2375:

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

2368: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE9;
2369: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_9';
2370: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2371: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2372: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2373:
2374: END IF;
2375:
2376: IF l_pref_table(l_index).ATTRIBUTE10 is not null THEN

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

2378: l_index_global := l_index_global + 1;
2379: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE10;
2380: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_10';
2381: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2382: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2383: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2384:
2385: END IF;
2386:

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

2379: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE10;
2380: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_10';
2381: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2382: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2383: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2384:
2385: END IF;
2386:
2387: IF l_pref_table(l_index).ATTRIBUTE11 is not null THEN

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

2389: l_index_global := l_index_global + 1;
2390: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE11;
2391: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_11';
2392: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2393: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2394: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2395:
2396: END IF;
2397:

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

2390: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE11;
2391: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_11';
2392: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2393: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2394: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2395:
2396: END IF;
2397:
2398: IF l_pref_table(l_index).ATTRIBUTE12 is not null THEN

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

2400: l_index_global := l_index_global + 1;
2401: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE12;
2402: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_12';
2403: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2404: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2405: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2406:
2407: END IF;
2408:

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

2401: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE12;
2402: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_12';
2403: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2404: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2405: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2406:
2407: END IF;
2408:
2409: IF l_pref_table(l_index).ATTRIBUTE13 is not null THEN

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

2411: l_index_global := l_index_global + 1;
2412: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE13;
2413: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_13';
2414: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2415: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2416: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2417:
2418: END IF;
2419:

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

2412: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE13;
2413: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_13';
2414: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2415: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2416: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2417:
2418: END IF;
2419:
2420: IF l_pref_table(l_index).ATTRIBUTE14 is not null THEN

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

2422: l_index_global := l_index_global + 1;
2423: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE14;
2424: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_14';
2425: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2426: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2427: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2428:
2429: END IF;
2430:

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

2423: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE14;
2424: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_14';
2425: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2426: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2427: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2428:
2429: END IF;
2430:
2431: IF l_pref_table(l_index).ATTRIBUTE15 is not null THEN

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

2433: l_index_global := l_index_global + 1;
2434: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE15;
2435: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_15';
2436: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2437: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2438: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2439:
2440: END IF;
2441:

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

2434: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE15;
2435: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_15';
2436: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2437: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2438: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2439:
2440: END IF;
2441:
2442: IF l_pref_table(l_index).ATTRIBUTE16 is not null THEN

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

2444: l_index_global := l_index_global + 1;
2445: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE16;
2446: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_16';
2447: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2448: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2449: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2450:
2451: END IF;
2452:

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

2445: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE16;
2446: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_16';
2447: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2448: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2449: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2450:
2451: END IF;
2452:
2453: IF l_pref_table(l_index).ATTRIBUTE17 is not null THEN

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

2455: l_index_global := l_index_global + 1;
2456: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE17;
2457: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_17';
2458: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2459: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2460: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2461:
2462: END IF;
2463:

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

2456: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE17;
2457: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_17';
2458: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2459: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2460: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2461:
2462: END IF;
2463:
2464: IF l_pref_table(l_index).ATTRIBUTE18 is not null THEN

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

2466: l_index_global := l_index_global + 1;
2467: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE18;
2468: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_18';
2469: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2470: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2471: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2472:
2473: END IF;
2474:

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

2467: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE18;
2468: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_18';
2469: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2470: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2471: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2472:
2473: END IF;
2474:
2475: IF l_pref_table(l_index).ATTRIBUTE19 is not null THEN

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

2477: l_index_global := l_index_global + 1;
2478: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE19;
2479: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_19';
2480: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2481: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2482: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2483:
2484: END IF;
2485:

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

2478: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE19;
2479: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_19';
2480: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2481: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2482: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2483:
2484: END IF;
2485:
2486: IF l_pref_table(l_index).ATTRIBUTE20 is not null THEN

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

2488: l_index_global := l_index_global + 1;
2489: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE20;
2490: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_20';
2491: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2492: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2493: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2494:
2495: END IF;
2496: END IF;

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

2489: g_alias_def_item(l_index_global).ALIAS_DEFINITION_ID := l_pref_table(l_index).ATTRIBUTE20;
2490: g_alias_def_item(l_index_global).ITEM_ATTRIBUTE_CATEGORY := 'OTL_ALIAS_ITEM_20';
2491: g_alias_def_item(l_index_global).RESOURCE_ID := p_timekeeper_id;
2492: g_alias_def_item(l_index_global).PREF_START_DATE := HR_GENERAL.START_OF_TIME;
2493: g_alias_def_item(l_index_global).PREF_END_DATE := HR_GENERAL.END_OF_TIME;
2494:
2495: END IF;
2496: END IF;
2497:

Line 2632: ' and nvl(t.start_date_active,hr_general.start_of_time) <= fnd_profile.value(''OTL_TK_END_DATE'') '||

2628: ' flex_value_id id_value '||
2629: ' from fnd_flex_values_vl t'||
2630: ' where t.flex_value_set_id = '||p_vset_id||
2631: ' and t.enabled_flag=''Y''' ||
2632: ' and nvl(t.start_date_active,hr_general.start_of_time) <= fnd_profile.value(''OTL_TK_END_DATE'') '||
2633: ' and nvl(t.end_date_active,hr_general.end_of_time) >= fnd_profile.value(''OTL_TK_START_DATE'') ';
2634:
2635:
2636: END IF;

Line 2633: ' and nvl(t.end_date_active,hr_general.end_of_time) >= fnd_profile.value(''OTL_TK_START_DATE'') ';

2629: ' from fnd_flex_values_vl t'||
2630: ' where t.flex_value_set_id = '||p_vset_id||
2631: ' and t.enabled_flag=''Y''' ||
2632: ' and nvl(t.start_date_active,hr_general.start_of_time) <= fnd_profile.value(''OTL_TK_END_DATE'') '||
2633: ' and nvl(t.end_date_active,hr_general.end_of_time) >= fnd_profile.value(''OTL_TK_START_DATE'') ';
2634:
2635:
2636: END IF;
2637: -- test the SQL

Line 3108: 'AND nvl(date_to,hr_general.end_of_time) >= fnd_profile.value(''OTL_TK_START_DATE'') '||

3104:
3105: 'AND ELEMENT.EFFECTIVE_START_DATE <= fnd_profile.value(''OTL_TK_END_DATE'') '||
3106: 'AND ELEMENT.EFFECTIVE_END_DATE >= fnd_profile.value(''OTL_TK_START_DATE'') '||
3107: 'AND date_from <= fnd_profile.value(''OTL_TK_END_DATE'') '||
3108: 'AND nvl(date_to,hr_general.end_of_time) >= fnd_profile.value(''OTL_TK_START_DATE'') '||
3109: 'AND ASGT.EFFECTIVE_START_DATE <= fnd_profile.value(''OTL_TK_END_DATE'') '||
3110: 'AND ASGT.EFFECTIVE_END_DATE >=fnd_profile.value(''OTL_TK_START_DATE'') '||
3111: 'AND LINK.EFFECTIVE_START_DATE <= fnd_profile.value(''OTL_TK_END_DATE'') '||
3112: 'AND LINK.EFFECTIVE_END_DATE >=fnd_profile.value(''OTL_TK_START_DATE'') '||

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

3121: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3122: ' AND fnd_profile.value(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3123: ' ''L'', SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, '||
3124: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3125: ' hr_general.end_of_time), '||
3126: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3127:
3128: ELSIF l_reference_object = 'PAYROLL_ELEMENTS' THEN
3129:

Line 3154: ' and nvl(hav.date_to,hr_general.end_of_time) >=fnd_profile.value(''OTL_TK_START_DATE'') '||

3150: ' AND ELEMENT.EFFECTIVE_END_DATE >= fnd_profile.value(''OTL_TK_START_DATE'') '||
3151: ' and havt.language = USERENV(''LANG'') '||
3152: ' and havt.alias_value_id = hav.alias_value_id '||
3153: ' and hav.date_from <= fnd_profile.value(''OTL_TK_END_DATE'') '||
3154: ' and nvl(hav.date_to,hr_general.end_of_time) >=fnd_profile.value(''OTL_TK_START_DATE'') '||
3155: ' and ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID '||
3156: ' AND ELEMENTTL.LANGUAGE = USERENV(''LANG'') '||
3157: ' AND CLASSIFICATION.CLASSIFICATION_ID = CLASSIFICATIONTL.CLASSIFICATION_ID (+) '||
3158: ' AND DECODE(CLASSIFICATIONTL.CLASSIFICATION_ID,NULL,''1'',CLASSIFICATIONTL.LANGUAGE) = '||

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

3202: ' AND (ELEMENT.PROCESSING_TYPE = ''R'' OR ASGT.PAYROLL_ID IS NOT NULL) '||
3203: ' AND (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NULL '||
3204: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3205: ' AND fnd_profile.value(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3206: ' ''L'', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, hr_general.end_of_time),'||
3207: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3208: ' hr_general.end_of_time), '||
3209: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3210: ELSE

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

3204: ' OR (SERVICE_PERIOD.ACTUAL_TERMINATION_DATE IS NOT NULL '||
3205: ' AND fnd_profile.value(''OTL_TK_START_DATE'') <= DECODE(ELEMENT.POST_TERMINATION_RULE, '||
3206: ' ''L'', NVL(SERVICE_PERIOD.LAST_STANDARD_PROCESS_DATE, hr_general.end_of_time),'||
3207: ' ''F'', NVL(SERVICE_PERIOD.FINAL_PROCESS_DATE, '||
3208: ' hr_general.end_of_time), '||
3209: ' SERVICE_PERIOD.ACTUAL_TERMINATION_DATE))) ';
3210: ELSE
3211:
3212: x_select := 'select havt.alias_value_name Display_Value,'||

Line 3223: ' and nvl(hav.date_to,hr_general.end_of_time) >=fnd_profile.value(''OTL_TK_START_DATE'') ';

3219: ' and had.alias_definition_id = '||p_alias_definition_id||
3220: ' and havt.language = USERENV(''LANG'') '||
3221: ' and havt.alias_value_id = hav.alias_value_id '||
3222: ' and hav.date_from <= fnd_profile.value(''OTL_TK_END_DATE'') '||
3223: ' and nvl(hav.date_to,hr_general.end_of_time) >=fnd_profile.value(''OTL_TK_START_DATE'') ';
3224: END IF;
3225:
3226: ELSE
3227: fnd_message.set_name('HXC', 'HXC_------_INVALID_REFERENCE_OBJECT');