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.PAY_CONTINUOUS_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 1975: /* name : PER_ALL_ASSIGNMENTS_F_aru

1971: --
1972: /* Used generator to build this procedure, but removed some of that table values.
1973: */
1974: /* PER_ALL_ASSIGNMENTS */
1975: /* name : PER_ALL_ASSIGNMENTS_F_aru
1976: purpose : This is procedure that records any updates
1977: on assignments.
1978: */
1979: procedure PER_ALL_ASSIGNMENTS_F_aru(

Line 1979: procedure PER_ALL_ASSIGNMENTS_F_aru(

1975: /* name : PER_ALL_ASSIGNMENTS_F_aru
1976: purpose : This is procedure that records any updates
1977: on assignments.
1978: */
1979: procedure PER_ALL_ASSIGNMENTS_F_aru(
1980: p_business_group_id in number,
1981: p_legislation_code in varchar2,
1982: p_effective_date in date,
1983: p_old_APPLICATION_ID in NUMBER,

Line 2173: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 10);

2169: )
2170: is
2171: --
2172: begin
2173: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 10);
2174: /* If the continuous calc is overriden then do nothing */
2175: if (g_override_cc = TRUE) then
2176: return;
2177: end if;

Line 2185: 'PER_ALL_ASSIGNMENTS_F',

2181: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
2182: --
2183: pay_continuous_calc.event_update(p_business_group_id,
2184: p_legislation_code,
2185: 'PER_ALL_ASSIGNMENTS_F',
2186: 'APPLICATION_ID',
2187: p_old_APPLICATION_ID,
2188: p_new_APPLICATION_ID,
2189: p_effective_date

Line 2193: 'PER_ALL_ASSIGNMENTS_F',

2189: p_effective_date
2190: );
2191: pay_continuous_calc.event_update(p_business_group_id,
2192: p_legislation_code,
2193: 'PER_ALL_ASSIGNMENTS_F',
2194: 'ASSIGNMENT_ID',
2195: p_old_ASSIGNMENT_ID,
2196: p_new_ASSIGNMENT_ID,
2197: p_effective_date

Line 2201: 'PER_ALL_ASSIGNMENTS_F',

2197: p_effective_date
2198: );
2199: pay_continuous_calc.event_update(p_business_group_id,
2200: p_legislation_code,
2201: 'PER_ALL_ASSIGNMENTS_F',
2202: 'ASSIGNMENT_NUMBER',
2203: p_old_ASSIGNMENT_NUMBER,
2204: p_new_ASSIGNMENT_NUMBER,
2205: p_effective_date

Line 2209: 'PER_ALL_ASSIGNMENTS_F',

2205: p_effective_date
2206: );
2207: pay_continuous_calc.event_update(p_business_group_id,
2208: p_legislation_code,
2209: 'PER_ALL_ASSIGNMENTS_F',
2210: 'ASSIGNMENT_SEQUENCE',
2211: p_old_ASSIGNMENT_SEQUENCE,
2212: p_new_ASSIGNMENT_SEQUENCE,
2213: p_effective_date

Line 2217: 'PER_ALL_ASSIGNMENTS_F',

2213: p_effective_date
2214: );
2215: pay_continuous_calc.event_update(p_business_group_id,
2216: p_legislation_code,
2217: 'PER_ALL_ASSIGNMENTS_F',
2218: 'ASSIGNMENT_STATUS_TYPE_ID',
2219: p_old_ASSIGNMENT_STATUS_TYPE_I,
2220: p_new_ASSIGNMENT_STATUS_TYPE_I,
2221: p_effective_date

Line 2225: 'PER_ALL_ASSIGNMENTS_F',

2221: p_effective_date
2222: );
2223: pay_continuous_calc.event_update(p_business_group_id,
2224: p_legislation_code,
2225: 'PER_ALL_ASSIGNMENTS_F',
2226: 'ASSIGNMENT_TYPE',
2227: p_old_ASSIGNMENT_TYPE,
2228: p_new_ASSIGNMENT_TYPE,
2229: p_effective_date

Line 2233: 'PER_ALL_ASSIGNMENTS_F',

2229: p_effective_date
2230: );
2231: pay_continuous_calc.event_update(p_business_group_id,
2232: p_legislation_code,
2233: 'PER_ALL_ASSIGNMENTS_F',
2234: 'ASS_ATTRIBUTE1',
2235: p_old_ASS_ATTRIBUTE1,
2236: p_new_ASS_ATTRIBUTE1,
2237: p_effective_date

Line 2241: 'PER_ALL_ASSIGNMENTS_F',

2237: p_effective_date
2238: );
2239: pay_continuous_calc.event_update(p_business_group_id,
2240: p_legislation_code,
2241: 'PER_ALL_ASSIGNMENTS_F',
2242: 'ASS_ATTRIBUTE10',
2243: p_old_ASS_ATTRIBUTE10,
2244: p_new_ASS_ATTRIBUTE10,
2245: p_effective_date

Line 2249: 'PER_ALL_ASSIGNMENTS_F',

2245: p_effective_date
2246: );
2247: pay_continuous_calc.event_update(p_business_group_id,
2248: p_legislation_code,
2249: 'PER_ALL_ASSIGNMENTS_F',
2250: 'ASS_ATTRIBUTE11',
2251: p_old_ASS_ATTRIBUTE11,
2252: p_new_ASS_ATTRIBUTE11,
2253: p_effective_date

Line 2257: 'PER_ALL_ASSIGNMENTS_F',

2253: p_effective_date
2254: );
2255: pay_continuous_calc.event_update(p_business_group_id,
2256: p_legislation_code,
2257: 'PER_ALL_ASSIGNMENTS_F',
2258: 'ASS_ATTRIBUTE12',
2259: p_old_ASS_ATTRIBUTE12,
2260: p_new_ASS_ATTRIBUTE12,
2261: p_effective_date

Line 2265: 'PER_ALL_ASSIGNMENTS_F',

2261: p_effective_date
2262: );
2263: pay_continuous_calc.event_update(p_business_group_id,
2264: p_legislation_code,
2265: 'PER_ALL_ASSIGNMENTS_F',
2266: 'ASS_ATTRIBUTE13',
2267: p_old_ASS_ATTRIBUTE13,
2268: p_new_ASS_ATTRIBUTE13,
2269: p_effective_date

Line 2273: 'PER_ALL_ASSIGNMENTS_F',

2269: p_effective_date
2270: );
2271: pay_continuous_calc.event_update(p_business_group_id,
2272: p_legislation_code,
2273: 'PER_ALL_ASSIGNMENTS_F',
2274: 'ASS_ATTRIBUTE14',
2275: p_old_ASS_ATTRIBUTE14,
2276: p_new_ASS_ATTRIBUTE14,
2277: p_effective_date

Line 2281: 'PER_ALL_ASSIGNMENTS_F',

2277: p_effective_date
2278: );
2279: pay_continuous_calc.event_update(p_business_group_id,
2280: p_legislation_code,
2281: 'PER_ALL_ASSIGNMENTS_F',
2282: 'ASS_ATTRIBUTE15',
2283: p_old_ASS_ATTRIBUTE15,
2284: p_new_ASS_ATTRIBUTE15,
2285: p_effective_date

Line 2289: 'PER_ALL_ASSIGNMENTS_F',

2285: p_effective_date
2286: );
2287: pay_continuous_calc.event_update(p_business_group_id,
2288: p_legislation_code,
2289: 'PER_ALL_ASSIGNMENTS_F',
2290: 'ASS_ATTRIBUTE16',
2291: p_old_ASS_ATTRIBUTE16,
2292: p_new_ASS_ATTRIBUTE16,
2293: p_effective_date

Line 2297: 'PER_ALL_ASSIGNMENTS_F',

2293: p_effective_date
2294: );
2295: pay_continuous_calc.event_update(p_business_group_id,
2296: p_legislation_code,
2297: 'PER_ALL_ASSIGNMENTS_F',
2298: 'ASS_ATTRIBUTE17',
2299: p_old_ASS_ATTRIBUTE17,
2300: p_new_ASS_ATTRIBUTE17,
2301: p_effective_date

Line 2305: 'PER_ALL_ASSIGNMENTS_F',

2301: p_effective_date
2302: );
2303: pay_continuous_calc.event_update(p_business_group_id,
2304: p_legislation_code,
2305: 'PER_ALL_ASSIGNMENTS_F',
2306: 'ASS_ATTRIBUTE18',
2307: p_old_ASS_ATTRIBUTE18,
2308: p_new_ASS_ATTRIBUTE18,
2309: p_effective_date

Line 2313: 'PER_ALL_ASSIGNMENTS_F',

2309: p_effective_date
2310: );
2311: pay_continuous_calc.event_update(p_business_group_id,
2312: p_legislation_code,
2313: 'PER_ALL_ASSIGNMENTS_F',
2314: 'ASS_ATTRIBUTE19',
2315: p_old_ASS_ATTRIBUTE19,
2316: p_new_ASS_ATTRIBUTE19,
2317: p_effective_date

Line 2321: 'PER_ALL_ASSIGNMENTS_F',

2317: p_effective_date
2318: );
2319: pay_continuous_calc.event_update(p_business_group_id,
2320: p_legislation_code,
2321: 'PER_ALL_ASSIGNMENTS_F',
2322: 'ASS_ATTRIBUTE2',
2323: p_old_ASS_ATTRIBUTE2,
2324: p_new_ASS_ATTRIBUTE2,
2325: p_effective_date

Line 2329: 'PER_ALL_ASSIGNMENTS_F',

2325: p_effective_date
2326: );
2327: pay_continuous_calc.event_update(p_business_group_id,
2328: p_legislation_code,
2329: 'PER_ALL_ASSIGNMENTS_F',
2330: 'ASS_ATTRIBUTE20',
2331: p_old_ASS_ATTRIBUTE20,
2332: p_new_ASS_ATTRIBUTE20,
2333: p_effective_date

Line 2337: 'PER_ALL_ASSIGNMENTS_F',

2333: p_effective_date
2334: );
2335: pay_continuous_calc.event_update(p_business_group_id,
2336: p_legislation_code,
2337: 'PER_ALL_ASSIGNMENTS_F',
2338: 'ASS_ATTRIBUTE21',
2339: p_old_ASS_ATTRIBUTE21,
2340: p_new_ASS_ATTRIBUTE21,
2341: p_effective_date

Line 2345: 'PER_ALL_ASSIGNMENTS_F',

2341: p_effective_date
2342: );
2343: pay_continuous_calc.event_update(p_business_group_id,
2344: p_legislation_code,
2345: 'PER_ALL_ASSIGNMENTS_F',
2346: 'ASS_ATTRIBUTE22',
2347: p_old_ASS_ATTRIBUTE22,
2348: p_new_ASS_ATTRIBUTE22,
2349: p_effective_date

Line 2353: 'PER_ALL_ASSIGNMENTS_F',

2349: p_effective_date
2350: );
2351: pay_continuous_calc.event_update(p_business_group_id,
2352: p_legislation_code,
2353: 'PER_ALL_ASSIGNMENTS_F',
2354: 'ASS_ATTRIBUTE23',
2355: p_old_ASS_ATTRIBUTE23,
2356: p_new_ASS_ATTRIBUTE23,
2357: p_effective_date

Line 2361: 'PER_ALL_ASSIGNMENTS_F',

2357: p_effective_date
2358: );
2359: pay_continuous_calc.event_update(p_business_group_id,
2360: p_legislation_code,
2361: 'PER_ALL_ASSIGNMENTS_F',
2362: 'ASS_ATTRIBUTE24',
2363: p_old_ASS_ATTRIBUTE24,
2364: p_new_ASS_ATTRIBUTE24,
2365: p_effective_date

Line 2369: 'PER_ALL_ASSIGNMENTS_F',

2365: p_effective_date
2366: );
2367: pay_continuous_calc.event_update(p_business_group_id,
2368: p_legislation_code,
2369: 'PER_ALL_ASSIGNMENTS_F',
2370: 'ASS_ATTRIBUTE25',
2371: p_old_ASS_ATTRIBUTE25,
2372: p_new_ASS_ATTRIBUTE25,
2373: p_effective_date

Line 2377: 'PER_ALL_ASSIGNMENTS_F',

2373: p_effective_date
2374: );
2375: pay_continuous_calc.event_update(p_business_group_id,
2376: p_legislation_code,
2377: 'PER_ALL_ASSIGNMENTS_F',
2378: 'ASS_ATTRIBUTE26',
2379: p_old_ASS_ATTRIBUTE26,
2380: p_new_ASS_ATTRIBUTE26,
2381: p_effective_date

Line 2385: 'PER_ALL_ASSIGNMENTS_F',

2381: p_effective_date
2382: );
2383: pay_continuous_calc.event_update(p_business_group_id,
2384: p_legislation_code,
2385: 'PER_ALL_ASSIGNMENTS_F',
2386: 'ASS_ATTRIBUTE27',
2387: p_old_ASS_ATTRIBUTE27,
2388: p_new_ASS_ATTRIBUTE27,
2389: p_effective_date

Line 2393: 'PER_ALL_ASSIGNMENTS_F',

2389: p_effective_date
2390: );
2391: pay_continuous_calc.event_update(p_business_group_id,
2392: p_legislation_code,
2393: 'PER_ALL_ASSIGNMENTS_F',
2394: 'ASS_ATTRIBUTE28',
2395: p_old_ASS_ATTRIBUTE28,
2396: p_new_ASS_ATTRIBUTE28,
2397: p_effective_date

Line 2401: 'PER_ALL_ASSIGNMENTS_F',

2397: p_effective_date
2398: );
2399: pay_continuous_calc.event_update(p_business_group_id,
2400: p_legislation_code,
2401: 'PER_ALL_ASSIGNMENTS_F',
2402: 'ASS_ATTRIBUTE29',
2403: p_old_ASS_ATTRIBUTE29,
2404: p_new_ASS_ATTRIBUTE29,
2405: p_effective_date

Line 2409: 'PER_ALL_ASSIGNMENTS_F',

2405: p_effective_date
2406: );
2407: pay_continuous_calc.event_update(p_business_group_id,
2408: p_legislation_code,
2409: 'PER_ALL_ASSIGNMENTS_F',
2410: 'ASS_ATTRIBUTE3',
2411: p_old_ASS_ATTRIBUTE3,
2412: p_new_ASS_ATTRIBUTE3,
2413: p_effective_date

Line 2417: 'PER_ALL_ASSIGNMENTS_F',

2413: p_effective_date
2414: );
2415: pay_continuous_calc.event_update(p_business_group_id,
2416: p_legislation_code,
2417: 'PER_ALL_ASSIGNMENTS_F',
2418: 'ASS_ATTRIBUTE30',
2419: p_old_ASS_ATTRIBUTE30,
2420: p_new_ASS_ATTRIBUTE30,
2421: p_effective_date

Line 2425: 'PER_ALL_ASSIGNMENTS_F',

2421: p_effective_date
2422: );
2423: pay_continuous_calc.event_update(p_business_group_id,
2424: p_legislation_code,
2425: 'PER_ALL_ASSIGNMENTS_F',
2426: 'ASS_ATTRIBUTE4',
2427: p_old_ASS_ATTRIBUTE4,
2428: p_new_ASS_ATTRIBUTE4,
2429: p_effective_date

Line 2433: 'PER_ALL_ASSIGNMENTS_F',

2429: p_effective_date
2430: );
2431: pay_continuous_calc.event_update(p_business_group_id,
2432: p_legislation_code,
2433: 'PER_ALL_ASSIGNMENTS_F',
2434: 'ASS_ATTRIBUTE5',
2435: p_old_ASS_ATTRIBUTE5,
2436: p_new_ASS_ATTRIBUTE5,
2437: p_effective_date

Line 2441: 'PER_ALL_ASSIGNMENTS_F',

2437: p_effective_date
2438: );
2439: pay_continuous_calc.event_update(p_business_group_id,
2440: p_legislation_code,
2441: 'PER_ALL_ASSIGNMENTS_F',
2442: 'ASS_ATTRIBUTE6',
2443: p_old_ASS_ATTRIBUTE6,
2444: p_new_ASS_ATTRIBUTE6,
2445: p_effective_date

Line 2449: 'PER_ALL_ASSIGNMENTS_F',

2445: p_effective_date
2446: );
2447: pay_continuous_calc.event_update(p_business_group_id,
2448: p_legislation_code,
2449: 'PER_ALL_ASSIGNMENTS_F',
2450: 'ASS_ATTRIBUTE7',
2451: p_old_ASS_ATTRIBUTE7,
2452: p_new_ASS_ATTRIBUTE7,
2453: p_effective_date

Line 2457: 'PER_ALL_ASSIGNMENTS_F',

2453: p_effective_date
2454: );
2455: pay_continuous_calc.event_update(p_business_group_id,
2456: p_legislation_code,
2457: 'PER_ALL_ASSIGNMENTS_F',
2458: 'ASS_ATTRIBUTE8',
2459: p_old_ASS_ATTRIBUTE8,
2460: p_new_ASS_ATTRIBUTE8,
2461: p_effective_date

Line 2465: 'PER_ALL_ASSIGNMENTS_F',

2461: p_effective_date
2462: );
2463: pay_continuous_calc.event_update(p_business_group_id,
2464: p_legislation_code,
2465: 'PER_ALL_ASSIGNMENTS_F',
2466: 'ASS_ATTRIBUTE9',
2467: p_old_ASS_ATTRIBUTE9,
2468: p_new_ASS_ATTRIBUTE9,
2469: p_effective_date

Line 2473: 'PER_ALL_ASSIGNMENTS_F',

2469: p_effective_date
2470: );
2471: pay_continuous_calc.event_update(p_business_group_id,
2472: p_legislation_code,
2473: 'PER_ALL_ASSIGNMENTS_F',
2474: 'ASS_ATTRIBUTE_CATEGORY',
2475: p_old_ASS_ATTRIBUTE_CATEGORY,
2476: p_new_ASS_ATTRIBUTE_CATEGORY,
2477: p_effective_date

Line 2481: 'PER_ALL_ASSIGNMENTS_F',

2477: p_effective_date
2478: );
2479: pay_continuous_calc.event_update(p_business_group_id,
2480: p_legislation_code,
2481: 'PER_ALL_ASSIGNMENTS_F',
2482: 'BARGAINING_UNIT_CODE',
2483: p_old_BARGAINING_UNIT_CODE,
2484: p_new_BARGAINING_UNIT_CODE,
2485: p_effective_date

Line 2489: 'PER_ALL_ASSIGNMENTS_F',

2485: p_effective_date
2486: );
2487: pay_continuous_calc.event_update(p_business_group_id,
2488: p_legislation_code,
2489: 'PER_ALL_ASSIGNMENTS_F',
2490: 'BUSINESS_GROUP_ID',
2491: p_old_BUSINESS_GROUP_ID,
2492: p_new_BUSINESS_GROUP_ID,
2493: p_effective_date

Line 2497: 'PER_ALL_ASSIGNMENTS_F',

2493: p_effective_date
2494: );
2495: pay_continuous_calc.event_update(p_business_group_id,
2496: p_legislation_code,
2497: 'PER_ALL_ASSIGNMENTS_F',
2498: 'CAGR_GRADE_DEF_ID',
2499: p_old_CAGR_GRADE_DEF_ID,
2500: p_new_CAGR_GRADE_DEF_ID,
2501: p_effective_date

Line 2505: 'PER_ALL_ASSIGNMENTS_F',

2501: p_effective_date
2502: );
2503: pay_continuous_calc.event_update(p_business_group_id,
2504: p_legislation_code,
2505: 'PER_ALL_ASSIGNMENTS_F',
2506: 'CAGR_ID_FLEX_NUM',
2507: p_old_CAGR_ID_FLEX_NUM,
2508: p_new_CAGR_ID_FLEX_NUM,
2509: p_effective_date

Line 2513: 'PER_ALL_ASSIGNMENTS_F',

2509: p_effective_date
2510: );
2511: pay_continuous_calc.event_update(p_business_group_id,
2512: p_legislation_code,
2513: 'PER_ALL_ASSIGNMENTS_F',
2514: 'CHANGE_REASON',
2515: p_old_CHANGE_REASON,
2516: p_new_CHANGE_REASON,
2517: p_effective_date

Line 2521: 'PER_ALL_ASSIGNMENTS_F',

2517: p_effective_date
2518: );
2519: pay_continuous_calc.event_update(p_business_group_id,
2520: p_legislation_code,
2521: 'PER_ALL_ASSIGNMENTS_F',
2522: 'COLLECTIVE_AGREEMENT_ID',
2523: p_old_COLLECTIVE_AGREEMENT_ID,
2524: p_new_COLLECTIVE_AGREEMENT_ID,
2525: p_effective_date

Line 2529: 'PER_ALL_ASSIGNMENTS_F',

2525: p_effective_date
2526: );
2527: pay_continuous_calc.event_update(p_business_group_id,
2528: p_legislation_code,
2529: 'PER_ALL_ASSIGNMENTS_F',
2530: 'COMMENT_ID',
2531: p_old_COMMENT_ID,
2532: p_new_COMMENT_ID,
2533: p_effective_date

Line 2537: 'PER_ALL_ASSIGNMENTS_F',

2533: p_effective_date
2534: );
2535: pay_continuous_calc.event_update(p_business_group_id,
2536: p_legislation_code,
2537: 'PER_ALL_ASSIGNMENTS_F',
2538: 'CONTRACT_ID',
2539: p_old_CONTRACT_ID,
2540: p_new_CONTRACT_ID,
2541: p_effective_date

Line 2545: 'PER_ALL_ASSIGNMENTS_F',

2541: p_effective_date
2542: );
2543: pay_continuous_calc.event_update(p_business_group_id,
2544: p_legislation_code,
2545: 'PER_ALL_ASSIGNMENTS_F',
2546: 'DATE_PROBATION_END',
2547: p_old_DATE_PROBATION_END,
2548: p_new_DATE_PROBATION_END,
2549: p_effective_date

Line 2553: 'PER_ALL_ASSIGNMENTS_F',

2549: p_effective_date
2550: );
2551: pay_continuous_calc.event_update(p_business_group_id,
2552: p_legislation_code,
2553: 'PER_ALL_ASSIGNMENTS_F',
2554: 'DEFAULT_CODE_COMB_ID',
2555: p_old_DEFAULT_CODE_COMB_ID,
2556: p_new_DEFAULT_CODE_COMB_ID,
2557: p_effective_date

Line 2561: 'PER_ALL_ASSIGNMENTS_F',

2557: p_effective_date
2558: );
2559: pay_continuous_calc.event_update(p_business_group_id,
2560: p_legislation_code,
2561: 'PER_ALL_ASSIGNMENTS_F',
2562: 'EMPLOYMENT_CATEGORY',
2563: p_old_EMPLOYMENT_CATEGORY,
2564: p_new_EMPLOYMENT_CATEGORY,
2565: p_effective_date

Line 2569: 'PER_ALL_ASSIGNMENTS_F',

2565: p_effective_date
2566: );
2567: pay_continuous_calc.event_update(p_business_group_id,
2568: p_legislation_code,
2569: 'PER_ALL_ASSIGNMENTS_F',
2570: 'ESTABLISHMENT_ID',
2571: p_old_ESTABLISHMENT_ID,
2572: p_new_ESTABLISHMENT_ID,
2573: p_effective_date

Line 2577: 'PER_ALL_ASSIGNMENTS_F',

2573: p_effective_date
2574: );
2575: pay_continuous_calc.event_update(p_business_group_id,
2576: p_legislation_code,
2577: 'PER_ALL_ASSIGNMENTS_F',
2578: 'FREQUENCY',
2579: p_old_FREQUENCY,
2580: p_new_FREQUENCY,
2581: p_effective_date

Line 2585: 'PER_ALL_ASSIGNMENTS_F',

2581: p_effective_date
2582: );
2583: pay_continuous_calc.event_update(p_business_group_id,
2584: p_legislation_code,
2585: 'PER_ALL_ASSIGNMENTS_F',
2586: 'GRADE_ID',
2587: p_old_GRADE_ID,
2588: p_new_GRADE_ID,
2589: p_effective_date

Line 2593: 'PER_ALL_ASSIGNMENTS_F',

2589: p_effective_date
2590: );
2591: pay_continuous_calc.event_update(p_business_group_id,
2592: p_legislation_code,
2593: 'PER_ALL_ASSIGNMENTS_F',
2594: 'HOURLY_SALARIED_CODE',
2595: p_old_HOURLY_SALARIED_CODE,
2596: p_new_HOURLY_SALARIED_CODE,
2597: p_effective_date

Line 2601: 'PER_ALL_ASSIGNMENTS_F',

2597: p_effective_date
2598: );
2599: pay_continuous_calc.event_update(p_business_group_id,
2600: p_legislation_code,
2601: 'PER_ALL_ASSIGNMENTS_F',
2602: 'INTERNAL_ADDRESS_LINE',
2603: p_old_INTERNAL_ADDRESS_LINE,
2604: p_new_INTERNAL_ADDRESS_LINE,
2605: p_effective_date

Line 2609: 'PER_ALL_ASSIGNMENTS_F',

2605: p_effective_date
2606: );
2607: pay_continuous_calc.event_update(p_business_group_id,
2608: p_legislation_code,
2609: 'PER_ALL_ASSIGNMENTS_F',
2610: 'JOB_ID',
2611: p_old_JOB_ID,
2612: p_new_JOB_ID,
2613: p_effective_date

Line 2617: 'PER_ALL_ASSIGNMENTS_F',

2613: p_effective_date
2614: );
2615: pay_continuous_calc.event_update(p_business_group_id,
2616: p_legislation_code,
2617: 'PER_ALL_ASSIGNMENTS_F',
2618: 'LABOUR_UNION_MEMBER_FLAG',
2619: p_old_LABOUR_UNION_MEMBER_FLAG,
2620: p_new_LABOUR_UNION_MEMBER_FLAG,
2621: p_effective_date

Line 2625: 'PER_ALL_ASSIGNMENTS_F',

2621: p_effective_date
2622: );
2623: pay_continuous_calc.event_update(p_business_group_id,
2624: p_legislation_code,
2625: 'PER_ALL_ASSIGNMENTS_F',
2626: 'LOCATION_ID',
2627: p_old_LOCATION_ID,
2628: p_new_LOCATION_ID,
2629: p_effective_date

Line 2633: 'PER_ALL_ASSIGNMENTS_F',

2629: p_effective_date
2630: );
2631: pay_continuous_calc.event_update(p_business_group_id,
2632: p_legislation_code,
2633: 'PER_ALL_ASSIGNMENTS_F',
2634: 'MANAGER_FLAG',
2635: p_old_MANAGER_FLAG,
2636: p_new_MANAGER_FLAG,
2637: p_effective_date

Line 2641: 'PER_ALL_ASSIGNMENTS_F',

2637: p_effective_date
2638: );
2639: pay_continuous_calc.event_update(p_business_group_id,
2640: p_legislation_code,
2641: 'PER_ALL_ASSIGNMENTS_F',
2642: 'NORMAL_HOURS',
2643: p_old_NORMAL_HOURS,
2644: p_new_NORMAL_HOURS,
2645: p_effective_date

Line 2649: 'PER_ALL_ASSIGNMENTS_F',

2645: p_effective_date
2646: );
2647: pay_continuous_calc.event_update(p_business_group_id,
2648: p_legislation_code,
2649: 'PER_ALL_ASSIGNMENTS_F',
2650: 'ORGANIZATION_ID',
2651: p_old_ORGANIZATION_ID,
2652: p_new_ORGANIZATION_ID,
2653: p_effective_date

Line 2657: 'PER_ALL_ASSIGNMENTS_F',

2653: p_effective_date
2654: );
2655: pay_continuous_calc.event_update(p_business_group_id,
2656: p_legislation_code,
2657: 'PER_ALL_ASSIGNMENTS_F',
2658: 'PAYROLL_ID',
2659: p_old_PAYROLL_ID,
2660: p_new_PAYROLL_ID,
2661: p_effective_date

Line 2665: 'PER_ALL_ASSIGNMENTS_F',

2661: p_effective_date
2662: );
2663: pay_continuous_calc.event_update(p_business_group_id,
2664: p_legislation_code,
2665: 'PER_ALL_ASSIGNMENTS_F',
2666: 'PAY_BASIS_ID',
2667: p_old_PAY_BASIS_ID,
2668: p_new_PAY_BASIS_ID,
2669: p_effective_date

Line 2673: 'PER_ALL_ASSIGNMENTS_F',

2669: p_effective_date
2670: );
2671: pay_continuous_calc.event_update(p_business_group_id,
2672: p_legislation_code,
2673: 'PER_ALL_ASSIGNMENTS_F',
2674: 'PEOPLE_GROUP_ID',
2675: p_old_PEOPLE_GROUP_ID,
2676: p_new_PEOPLE_GROUP_ID,
2677: p_effective_date

Line 2681: 'PER_ALL_ASSIGNMENTS_F',

2677: p_effective_date
2678: );
2679: pay_continuous_calc.event_update(p_business_group_id,
2680: p_legislation_code,
2681: 'PER_ALL_ASSIGNMENTS_F',
2682: 'PERF_REVIEW_PERIOD',
2683: p_old_PERF_REVIEW_PERIOD,
2684: p_new_PERF_REVIEW_PERIOD,
2685: p_effective_date

Line 2689: 'PER_ALL_ASSIGNMENTS_F',

2685: p_effective_date
2686: );
2687: pay_continuous_calc.event_update(p_business_group_id,
2688: p_legislation_code,
2689: 'PER_ALL_ASSIGNMENTS_F',
2690: 'PERF_REVIEW_PERIOD_FREQUENCY',
2691: p_old_PERF_REVIEW_PERIOD_FREQU,
2692: p_new_PERF_REVIEW_PERIOD_FREQU,
2693: p_effective_date

Line 2697: 'PER_ALL_ASSIGNMENTS_F',

2693: p_effective_date
2694: );
2695: pay_continuous_calc.event_update(p_business_group_id,
2696: p_legislation_code,
2697: 'PER_ALL_ASSIGNMENTS_F',
2698: 'PERIOD_OF_SERVICE_ID',
2699: p_old_PERIOD_OF_SERVICE_ID,
2700: p_new_PERIOD_OF_SERVICE_ID,
2701: p_effective_date

Line 2705: 'PER_ALL_ASSIGNMENTS_F',

2701: p_effective_date
2702: );
2703: pay_continuous_calc.event_update(p_business_group_id,
2704: p_legislation_code,
2705: 'PER_ALL_ASSIGNMENTS_F',
2706: 'PERSON_ID',
2707: p_old_PERSON_ID,
2708: p_new_PERSON_ID,
2709: p_effective_date

Line 2713: 'PER_ALL_ASSIGNMENTS_F',

2709: p_effective_date
2710: );
2711: pay_continuous_calc.event_update(p_business_group_id,
2712: p_legislation_code,
2713: 'PER_ALL_ASSIGNMENTS_F',
2714: 'PERSON_REFERRED_BY_ID',
2715: p_old_PERSON_REFERRED_BY_ID,
2716: p_new_PERSON_REFERRED_BY_ID,
2717: p_effective_date

Line 2721: 'PER_ALL_ASSIGNMENTS_F',

2717: p_effective_date
2718: );
2719: pay_continuous_calc.event_update(p_business_group_id,
2720: p_legislation_code,
2721: 'PER_ALL_ASSIGNMENTS_F',
2722: 'POSITION_ID',
2723: p_old_POSITION_ID,
2724: p_new_POSITION_ID,
2725: p_effective_date

Line 2729: 'PER_ALL_ASSIGNMENTS_F',

2725: p_effective_date
2726: );
2727: pay_continuous_calc.event_update(p_business_group_id,
2728: p_legislation_code,
2729: 'PER_ALL_ASSIGNMENTS_F',
2730: 'PRIMARY_FLAG',
2731: p_old_PRIMARY_FLAG,
2732: p_new_PRIMARY_FLAG,
2733: p_effective_date

Line 2737: 'PER_ALL_ASSIGNMENTS_F',

2733: p_effective_date
2734: );
2735: pay_continuous_calc.event_update(p_business_group_id,
2736: p_legislation_code,
2737: 'PER_ALL_ASSIGNMENTS_F',
2738: 'PROBATION_PERIOD',
2739: p_old_PROBATION_PERIOD,
2740: p_new_PROBATION_PERIOD,
2741: p_effective_date

Line 2745: 'PER_ALL_ASSIGNMENTS_F',

2741: p_effective_date
2742: );
2743: pay_continuous_calc.event_update(p_business_group_id,
2744: p_legislation_code,
2745: 'PER_ALL_ASSIGNMENTS_F',
2746: 'PROBATION_UNIT',
2747: p_old_PROBATION_UNIT,
2748: p_new_PROBATION_UNIT,
2749: p_effective_date

Line 2753: 'PER_ALL_ASSIGNMENTS_F',

2749: p_effective_date
2750: );
2751: pay_continuous_calc.event_update(p_business_group_id,
2752: p_legislation_code,
2753: 'PER_ALL_ASSIGNMENTS_F',
2754: 'PROGRAM_APPLICATION_ID',
2755: p_old_PROGRAM_APPLICATION_ID,
2756: p_new_PROGRAM_APPLICATION_ID,
2757: p_effective_date

Line 2761: 'PER_ALL_ASSIGNMENTS_F',

2757: p_effective_date
2758: );
2759: pay_continuous_calc.event_update(p_business_group_id,
2760: p_legislation_code,
2761: 'PER_ALL_ASSIGNMENTS_F',
2762: 'PROGRAM_ID',
2763: p_old_PROGRAM_ID,
2764: p_new_PROGRAM_ID,
2765: p_effective_date

Line 2769: 'PER_ALL_ASSIGNMENTS_F',

2765: p_effective_date
2766: );
2767: pay_continuous_calc.event_update(p_business_group_id,
2768: p_legislation_code,
2769: 'PER_ALL_ASSIGNMENTS_F',
2770: 'PROGRAM_UPDATE_DATE',
2771: p_old_PROGRAM_UPDATE_DATE,
2772: p_new_PROGRAM_UPDATE_DATE,
2773: p_effective_date

Line 2777: 'PER_ALL_ASSIGNMENTS_F',

2773: p_effective_date
2774: );
2775: pay_continuous_calc.event_update(p_business_group_id,
2776: p_legislation_code,
2777: 'PER_ALL_ASSIGNMENTS_F',
2778: 'RECRUITER_ID',
2779: p_old_RECRUITER_ID,
2780: p_new_RECRUITER_ID,
2781: p_effective_date

Line 2785: 'PER_ALL_ASSIGNMENTS_F',

2781: p_effective_date
2782: );
2783: pay_continuous_calc.event_update(p_business_group_id,
2784: p_legislation_code,
2785: 'PER_ALL_ASSIGNMENTS_F',
2786: 'RECRUITMENT_ACTIVITY_ID',
2787: p_old_RECRUITMENT_ACTIVITY_ID,
2788: p_new_RECRUITMENT_ACTIVITY_ID,
2789: p_effective_date

Line 2793: 'PER_ALL_ASSIGNMENTS_F',

2789: p_effective_date
2790: );
2791: pay_continuous_calc.event_update(p_business_group_id,
2792: p_legislation_code,
2793: 'PER_ALL_ASSIGNMENTS_F',
2794: 'REQUEST_ID',
2795: p_old_REQUEST_ID,
2796: p_new_REQUEST_ID,
2797: p_effective_date

Line 2801: 'PER_ALL_ASSIGNMENTS_F',

2797: p_effective_date
2798: );
2799: pay_continuous_calc.event_update(p_business_group_id,
2800: p_legislation_code,
2801: 'PER_ALL_ASSIGNMENTS_F',
2802: 'SAL_REVIEW_PERIOD',
2803: p_old_SAL_REVIEW_PERIOD,
2804: p_new_SAL_REVIEW_PERIOD,
2805: p_effective_date

Line 2809: 'PER_ALL_ASSIGNMENTS_F',

2805: p_effective_date
2806: );
2807: pay_continuous_calc.event_update(p_business_group_id,
2808: p_legislation_code,
2809: 'PER_ALL_ASSIGNMENTS_F',
2810: 'SAL_REVIEW_PERIOD_FREQUENCY',
2811: p_old_SAL_REVIEW_PERIOD_FREQUE,
2812: p_new_SAL_REVIEW_PERIOD_FREQUE,
2813: p_effective_date

Line 2817: 'PER_ALL_ASSIGNMENTS_F',

2813: p_effective_date
2814: );
2815: pay_continuous_calc.event_update(p_business_group_id,
2816: p_legislation_code,
2817: 'PER_ALL_ASSIGNMENTS_F',
2818: 'SET_OF_BOOKS_ID',
2819: p_old_SET_OF_BOOKS_ID,
2820: p_new_SET_OF_BOOKS_ID,
2821: p_effective_date

Line 2825: 'PER_ALL_ASSIGNMENTS_F',

2821: p_effective_date
2822: );
2823: pay_continuous_calc.event_update(p_business_group_id,
2824: p_legislation_code,
2825: 'PER_ALL_ASSIGNMENTS_F',
2826: 'SOFT_CODING_KEYFLEX_ID',
2827: p_old_SOFT_CODING_KEYFLEX_ID,
2828: p_new_SOFT_CODING_KEYFLEX_ID,
2829: p_effective_date

Line 2833: 'PER_ALL_ASSIGNMENTS_F',

2829: p_effective_date
2830: );
2831: pay_continuous_calc.event_update(p_business_group_id,
2832: p_legislation_code,
2833: 'PER_ALL_ASSIGNMENTS_F',
2834: 'SOURCE_ORGANIZATION_ID',
2835: p_old_SOURCE_ORGANIZATION_ID,
2836: p_new_SOURCE_ORGANIZATION_ID,
2837: p_effective_date

Line 2841: 'PER_ALL_ASSIGNMENTS_F',

2837: p_effective_date
2838: );
2839: pay_continuous_calc.event_update(p_business_group_id,
2840: p_legislation_code,
2841: 'PER_ALL_ASSIGNMENTS_F',
2842: 'SOURCE_TYPE',
2843: p_old_SOURCE_TYPE,
2844: p_new_SOURCE_TYPE,
2845: p_effective_date

Line 2849: 'PER_ALL_ASSIGNMENTS_F',

2845: p_effective_date
2846: );
2847: pay_continuous_calc.event_update(p_business_group_id,
2848: p_legislation_code,
2849: 'PER_ALL_ASSIGNMENTS_F',
2850: 'SPECIAL_CEILING_STEP_ID',
2851: p_old_SPECIAL_CEILING_STEP_ID,
2852: p_new_SPECIAL_CEILING_STEP_ID,
2853: p_effective_date

Line 2857: 'PER_ALL_ASSIGNMENTS_F',

2853: p_effective_date
2854: );
2855: pay_continuous_calc.event_update(p_business_group_id,
2856: p_legislation_code,
2857: 'PER_ALL_ASSIGNMENTS_F',
2858: 'SUPERVISOR_ID',
2859: p_old_SUPERVISOR_ID,
2860: p_new_SUPERVISOR_ID,
2861: p_effective_date

Line 2865: 'PER_ALL_ASSIGNMENTS_F',

2861: p_effective_date
2862: );
2863: pay_continuous_calc.event_update(p_business_group_id,
2864: p_legislation_code,
2865: 'PER_ALL_ASSIGNMENTS_F',
2866: 'TIME_NORMAL_FINISH',
2867: p_old_TIME_NORMAL_FINISH,
2868: p_new_TIME_NORMAL_FINISH,
2869: p_effective_date

Line 2873: 'PER_ALL_ASSIGNMENTS_F',

2869: p_effective_date
2870: );
2871: pay_continuous_calc.event_update(p_business_group_id,
2872: p_legislation_code,
2873: 'PER_ALL_ASSIGNMENTS_F',
2874: 'TIME_NORMAL_START',
2875: p_old_TIME_NORMAL_START,
2876: p_new_TIME_NORMAL_START,
2877: p_effective_date

Line 2881: 'PER_ALL_ASSIGNMENTS_F',

2877: p_effective_date
2878: );
2879: pay_continuous_calc.event_update(p_business_group_id,
2880: p_legislation_code,
2881: 'PER_ALL_ASSIGNMENTS_F',
2882: 'TITLE',
2883: p_old_TITLE,
2884: p_new_TITLE,
2885: p_effective_date

Line 2889: 'PER_ALL_ASSIGNMENTS_F',

2885: p_effective_date
2886: );
2887: pay_continuous_calc.event_update(p_business_group_id,
2888: p_legislation_code,
2889: 'PER_ALL_ASSIGNMENTS_F',
2890: 'VACANCY_ID',
2891: p_old_VACANCY_ID,
2892: p_new_VACANCY_ID,
2893: p_effective_date

Line 2897: 'PER_ALL_ASSIGNMENTS_F',

2893: p_effective_date
2894: );
2895: pay_continuous_calc.event_update(p_business_group_id,
2896: p_legislation_code,
2897: 'PER_ALL_ASSIGNMENTS_F',
2898: 'PROJECTED_ASSIGNMENT_END',
2899: p_old_PROJECTED_ASSIGNMENT_END,
2900: p_new_PROJECTED_ASSIGNMENT_END,
2901: p_effective_date

Line 2907: 'PER_ALL_ASSIGNMENTS_F',

2903: else
2904: /* OK it must be a date track change */
2905: pay_continuous_calc.event_update(p_business_group_id,
2906: p_legislation_code,
2907: 'PER_ALL_ASSIGNMENTS_F',
2908: 'EFFECTIVE_END_DATE',
2909: p_old_EFFECTIVE_END_DATE,
2910: p_new_EFFECTIVE_END_DATE,
2911: p_new_effective_end_date,

Line 2917: 'PER_ALL_ASSIGNMENTS_F',

2913: p_new_effective_end_date)
2914: );
2915: pay_continuous_calc.event_update(p_business_group_id,
2916: p_legislation_code,
2917: 'PER_ALL_ASSIGNMENTS_F',
2918: 'EFFECTIVE_START_DATE',
2919: p_old_EFFECTIVE_START_DATE,
2920: p_new_EFFECTIVE_START_DATE,
2921: p_new_effective_start_date,

Line 2952: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);

2948: end loop;
2949: end if;
2950: pay_continuous_calc.g_event_list.sz := 0;
2951: end;
2952: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);
2953: --
2954: end PER_ALL_ASSIGNMENTS_F_aru;
2955: --
2956: /* PER_ALL_ASSIGNMENTS_F_ari */

Line 2954: end PER_ALL_ASSIGNMENTS_F_aru;

2950: pay_continuous_calc.g_event_list.sz := 0;
2951: end;
2952: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);
2953: --
2954: end PER_ALL_ASSIGNMENTS_F_aru;
2955: --
2956: /* PER_ALL_ASSIGNMENTS_F_ari */
2957: /* name : PER_ALL_ASSIGNMENTS_F_ari
2958: purpose : This is procedure that records any insert

Line 2956: /* PER_ALL_ASSIGNMENTS_F_ari */

2952: hr_utility.set_location('pay_continuous_calc.PER_ALL_ASSIGNMENTS_F_aru', 50);
2953: --
2954: end PER_ALL_ASSIGNMENTS_F_aru;
2955: --
2956: /* PER_ALL_ASSIGNMENTS_F_ari */
2957: /* name : PER_ALL_ASSIGNMENTS_F_ari
2958: purpose : This is procedure that records any insert
2959: on assignments.
2960: */

Line 2957: /* name : PER_ALL_ASSIGNMENTS_F_ari

2953: --
2954: end PER_ALL_ASSIGNMENTS_F_aru;
2955: --
2956: /* PER_ALL_ASSIGNMENTS_F_ari */
2957: /* name : PER_ALL_ASSIGNMENTS_F_ari
2958: purpose : This is procedure that records any insert
2959: on assignments.
2960: */
2961: procedure PER_ALL_ASSIGNMENTS_F_ari(

Line 2961: procedure PER_ALL_ASSIGNMENTS_F_ari(

2957: /* name : PER_ALL_ASSIGNMENTS_F_ari
2958: purpose : This is procedure that records any insert
2959: on assignments.
2960: */
2961: procedure PER_ALL_ASSIGNMENTS_F_ari(
2962: p_business_group_id in number,
2963: p_legislation_code in varchar2,
2964: p_assignment_id in number,
2965: p_effective_start_date in date

Line 2970: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ari';

2966: )
2967: is
2968: l_process_event_id number;
2969: l_object_version_number number;
2970: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ari';
2971: begin
2972: hr_utility.set_location(l_proc, 10);
2973: /* If the continuous calc is overriden then do nothing */
2974: if (g_override_cc = TRUE) then

Line 2980: 'PER_ALL_ASSIGNMENTS_F',

2976: end if;
2977: --
2978: pay_continuous_calc.event_update(p_business_group_id,
2979: p_legislation_code,
2980: 'PER_ALL_ASSIGNMENTS_F',
2981: NULL,
2982: NULL,
2983: NULL,
2984: p_effective_start_date,

Line 3014: end per_all_assignments_f_ari;

3010: end if;
3011: pay_continuous_calc.g_event_list.sz := 0;
3012: end;
3013: hr_utility.set_location(l_proc, 900);
3014: end per_all_assignments_f_ari;
3015: --
3016: /* name : per_all_assignments_f_ard
3017: purpose : This is procedure that records any deletes
3018: on assignments.

Line 3016: /* name : per_all_assignments_f_ard

3012: end;
3013: hr_utility.set_location(l_proc, 900);
3014: end per_all_assignments_f_ari;
3015: --
3016: /* name : per_all_assignments_f_ard
3017: purpose : This is procedure that records any deletes
3018: on assignments.
3019: */
3020: procedure per_all_assignments_f_ard(

Line 3020: procedure per_all_assignments_f_ard(

3016: /* name : per_all_assignments_f_ard
3017: purpose : This is procedure that records any deletes
3018: on assignments.
3019: */
3020: procedure per_all_assignments_f_ard(
3021: p_business_group_id in number,
3022: p_legislation_code in varchar2,
3023: p_assignment_id in number,
3024: p_effective_start_date in date

Line 3029: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ard';

3025: )
3026: is
3027: l_process_event_id number;
3028: l_object_version_number number;
3029: l_proc varchar2(240) := g_package||'.per_all_assignments_f_ard';
3030: begin
3031: hr_utility.set_location(l_proc, 10);
3032: /* If the continuous calc is overriden then do nothing */
3033: if (g_override_cc = TRUE) then

Line 3039: 'PER_ALL_ASSIGNMENTS_F',

3035: end if;
3036: --
3037: pay_continuous_calc.event_update(p_business_group_id,
3038: p_legislation_code,
3039: 'PER_ALL_ASSIGNMENTS_F',
3040: NULL,
3041: NULL,
3042: NULL,
3043: p_effective_start_date,

Line 3073: END per_all_assignments_f_ard;

3069: end if;
3070: pay_continuous_calc.g_event_list.sz := 0;
3071: end;
3072: hr_utility.set_location(l_proc, 900);
3073: END per_all_assignments_f_ard;
3074:
3075:
3076: /* PAY_PERSONAL_PAYMENT_METHODS_F */
3077: /* name : PER_ALL_payment_methods_ari

Line 12387: from per_all_assignments_f

12383: IS
12384: --
12385: cursor asgcur (p_person_id number) is
12386: select distinct assignment_id
12387: from per_all_assignments_f
12388: where person_id = p_person_id;
12389: --
12390: l_process_event_id number;
12391: l_object_version_number number;