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_US_TIME_DEFINITIONS_HOOK dependencies on HXC_RECURRING_PERIODS

Line 29: HXC_RECURRING_PERIODS

25: HXC_PREF_HIERARCHIES
26: 2. After Update Row Handler User Hook Call on
27: HXC_PREF_HIERARCHIES
28: 3. After Update Row Handler User Hook Call on
29: HXC_RECURRING_PERIODS
30: 4. Before Process Business Process User Hook Call
31: on UPDATE_TIME_DEFINITION
32:
33: I. The package Creates/Updates rows in pay_time_definitions

Line 37: when a row is updated in HXC_RECURRING_PERIODS

33: I. The package Creates/Updates rows in pay_time_definitions
34: and per_time_periods as and when rows are created/updated
35: in HXC_PREF_HIERARCHIES
36: II. The package Updates a row in pay_time_definitions as and
37: when a row is updated in HXC_RECURRING_PERIODS
38:
39: Change List
40: -----------
41: Name Date Version Bug Text

Line 71: lv_name hxc_recurring_periods.NAME%TYPE;

67: ) IS
68:
69: lv_td_exist VARCHAR2 (1);
70: lv_payroll VARCHAR2(1);
71: lv_name hxc_recurring_periods.NAME%TYPE;
72: lv_period_type hxc_recurring_periods.period_type%TYPE;
73: ld_start_date hxc_recurring_periods.start_date%TYPE;
74: ld_period_start hxc_recurring_periods.start_date%TYPE;
75: ld_period_end hxc_recurring_periods.end_date%TYPE;

Line 72: lv_period_type hxc_recurring_periods.period_type%TYPE;

68:
69: lv_td_exist VARCHAR2 (1);
70: lv_payroll VARCHAR2(1);
71: lv_name hxc_recurring_periods.NAME%TYPE;
72: lv_period_type hxc_recurring_periods.period_type%TYPE;
73: ld_start_date hxc_recurring_periods.start_date%TYPE;
74: ld_period_start hxc_recurring_periods.start_date%TYPE;
75: ld_period_end hxc_recurring_periods.end_date%TYPE;
76: ln_duration_in_days hxc_recurring_periods.DURATION_IN_DAYS%TYPE;

Line 73: ld_start_date hxc_recurring_periods.start_date%TYPE;

69: lv_td_exist VARCHAR2 (1);
70: lv_payroll VARCHAR2(1);
71: lv_name hxc_recurring_periods.NAME%TYPE;
72: lv_period_type hxc_recurring_periods.period_type%TYPE;
73: ld_start_date hxc_recurring_periods.start_date%TYPE;
74: ld_period_start hxc_recurring_periods.start_date%TYPE;
75: ld_period_end hxc_recurring_periods.end_date%TYPE;
76: ln_duration_in_days hxc_recurring_periods.DURATION_IN_DAYS%TYPE;
77: ln_tot_years NUMBER := 5;

Line 74: ld_period_start hxc_recurring_periods.start_date%TYPE;

70: lv_payroll VARCHAR2(1);
71: lv_name hxc_recurring_periods.NAME%TYPE;
72: lv_period_type hxc_recurring_periods.period_type%TYPE;
73: ld_start_date hxc_recurring_periods.start_date%TYPE;
74: ld_period_start hxc_recurring_periods.start_date%TYPE;
75: ld_period_end hxc_recurring_periods.end_date%TYPE;
76: ln_duration_in_days hxc_recurring_periods.DURATION_IN_DAYS%TYPE;
77: ln_tot_years NUMBER := 5;
78: ln_time_definition_id NUMBER;

Line 75: ld_period_end hxc_recurring_periods.end_date%TYPE;

71: lv_name hxc_recurring_periods.NAME%TYPE;
72: lv_period_type hxc_recurring_periods.period_type%TYPE;
73: ld_start_date hxc_recurring_periods.start_date%TYPE;
74: ld_period_start hxc_recurring_periods.start_date%TYPE;
75: ld_period_end hxc_recurring_periods.end_date%TYPE;
76: ln_duration_in_days hxc_recurring_periods.DURATION_IN_DAYS%TYPE;
77: ln_tot_years NUMBER := 5;
78: ln_time_definition_id NUMBER;
79: ln_ovn NUMBER;

Line 76: ln_duration_in_days hxc_recurring_periods.DURATION_IN_DAYS%TYPE;

72: lv_period_type hxc_recurring_periods.period_type%TYPE;
73: ld_start_date hxc_recurring_periods.start_date%TYPE;
74: ld_period_start hxc_recurring_periods.start_date%TYPE;
75: ld_period_end hxc_recurring_periods.end_date%TYPE;
76: ln_duration_in_days hxc_recurring_periods.DURATION_IN_DAYS%TYPE;
77: ln_tot_years NUMBER := 5;
78: ln_time_definition_id NUMBER;
79: ln_ovn NUMBER;
80:

Line 114: FROM hxc_recurring_periods

110: 'SELECT NAME,
111: period_type,
112: start_date,
113: duration_in_days
114: FROM hxc_recurring_periods
115: WHERE recurring_period_id = '|| p_attribute3;
116:
117: BEGIN
118: -- Cursor which is used to fetch the recurring period related info

Line 133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');

129: hr_utility.set_message_token(801,
130: 'ERROR_TEXT',
131: 'Error while inserting a row in pay_time_definitions'
132: );
133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
134: hr_utility.raise_error;
135: END;
136:
137:

Line 497: User Hook of HXC_RECURRING_PERIODS_API.

493: /***************************************************************************
494: Name : UPDATE_USER_HOOK_RECURRING
495: Scope : GLOBAL
496: Description : This procedure is called by AFTER UPDATE Row Level handler
497: User Hook of HXC_RECURRING_PERIODS_API.
498: ******************************************************************************/
499: PROCEDURE update_user_hook_recurring (
500: p_recurring_period_id IN NUMBER
501: ,p_name IN VARCHAR2

Line 556: FROM hxc_recurring_periods

552: BEGIN
553:
554: c_check_recurring_sql :=
555: 'SELECT ''Y''
556: FROM hxc_recurring_periods
557: WHERE recurring_period_id = ' || p_creator_id;
558:
559: -- Cursor to check whether a recurring period exist
560: OPEN c_check_recurring FOR c_check_recurring_sql;

Line 592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');

588: hr_utility.set_message_token(801,
589: 'ERROR_TEXT',
590: 'Error while updating a row in pay_time_definitions'
591: );
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');