[Home] [Help]
1: PACKAGE BODY hxc_us_time_definitions_hook AS
2: /* $Header: hxcusottd.pkb 120.2 2006/10/05 20:18:55 asasthan noship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : HXC_US_TIME_DEFINITIONS_HOOK
21: File Name : hxcusottd.pkb
22:
23: Description : The package is called from the following places:
24: 1. After Insert Row Handler User Hook Call on
123: ln_duration_in_days;
124: CLOSE c_recurring_period_name;
125: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
126: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
127: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
128: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
129: hr_utility.set_message_token(801,
130: 'ERROR_TEXT',
131: 'Error while inserting a row in pay_time_definitions'
178: END IF;
179: CLOSE c_check_recurring_id;
180: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
181: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
182: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
183: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
184: hr_utility.set_message_token(801,
185: 'ERROR_TEXT',
186: 'Error while inserting a row in pay_time_definitions'
195:
196:
197: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
198: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
199: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
200: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
201: hr_utility.set_message_token(801,
202: 'ERROR_TEXT',
203: 'Error while inserting a row in pay_time_definitions'
266: hr_utility.TRACE ('Leaving UPDATE_TIME_DEF_RECURRING');
267:
268: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
269: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
270: 'hxc_us_time_definitions_hook.update_time_def_recurring');
271: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
272: hr_utility.set_message_token(801,
273: 'ERROR_TEXT',
274: 'Error while updating a row in pay_time_definitions'
406: hr_utility.TRACE ('Leaving STATUS_OTL_TIME_DEF');
407:
408: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
409: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
410: 'hxc_us_time_definitions_hook.status_otl_time_def');
411: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
412: hr_utility.set_message_token(801,
413: 'ERROR_TEXT',
414: 'Error while updating a row in pay_time_definitions'
434: p_attribute2 IN VARCHAR2 DEFAULT NULL,
435: p_attribute3 IN VARCHAR2 DEFAULT NULL
436: ) IS
437: BEGIN
438: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.INSERT_USER_HOOK_HIERARCHY');
439:
440: IF ( p_attribute_category = 'TC_W_RULES_EVALUATION' AND
441: p_attribute2 IS NOT NULL AND
442: p_attribute3 IS NOT NULL
448: ELSE
449: NULL;
450: END IF;
451:
452: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.INSERT_USER_HOOK_HIERARCHY');
453: END insert_user_hook_hierarchy;
454:
455: ------------------------INSERT_USER_HOOK_HIERARCHY ENDS HERE-------------------
456:
470: p_attribute3 IN VARCHAR2 DEFAULT NULL
471: ) IS
472:
473: BEGIN
474: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_HIERARCHY');
475:
476: IF ( p_attribute_category = 'TC_W_RULES_EVALUATION' AND
477: p_attribute2 IS NOT NULL AND
478: p_attribute3 IS NOT NULL
484: ELSE
485: NULL;
486: END IF;
487:
488: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_HIERARCHY');
489: END update_user_hook_hierarchy;
490:
491: -------------------------UPDATE_USER_HOOK_HIERARCHY ENDS HERE------------------
492:
500: p_recurring_period_id IN NUMBER
501: ,p_name IN VARCHAR2
502: ) IS
503: BEGIN
504: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_RECURRING');
505:
506: g_from_otl := 'Y';
507: update_time_def_recurring ( p_recurring_period_id => p_recurring_period_id
508: ,p_name => p_name
507: update_time_def_recurring ( p_recurring_period_id => p_recurring_period_id
508: ,p_name => p_name
509: );
510:
511: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_RECURRING');
512: END update_user_hook_recurring;
513:
514: -----------------------UPDATE_USER_HOOK_RECURRING SECTION ENDS HERE------------
515:
537:
538: c_check_recurring_sql VARCHAR2(10000);
539:
540: BEGIN
541: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');
542:
543: IF g_from_otl IS NULL THEN
544: g_from_otl := 'N';
545: END IF;
582: END IF;
583: CLOSE c_check_recurring;
584: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
585: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
586: 'hxc_us_time_definitions_hook.status_otl_time_def');
587: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
588: hr_utility.set_message_token(801,
589: 'ERROR_TEXT',
590: 'Error while updating a row in pay_time_definitions'
592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
593: hr_utility.raise_error;
594: END;
595: END IF;
596: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');
597: END update_user_hook_timedef;
598:
599: -----------------------------UPDATE_USER_HOOK_TIMEDEF ENDS HERE----------------
600:
600:
601: --BEGIN
602: --hr_utility.trace_on(NULL,'rd_hxcusottd');
603:
604: END hxc_us_time_definitions_hook;