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 PAY_TIME_DEFINITIONS

Line 33: I. The package Creates/Updates rows in pay_time_definitions

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
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

Line 36: II. The package Updates a row in pay_time_definitions as and

32:
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: -----------

Line 131: 'Error while inserting a row in pay_time_definitions'

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'
132: );
133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
134: hr_utility.raise_error;
135: END;

Line 152: 'SELECT /+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) /

148: );
149:
150:
151: c_check_recurring_id_sql :=
152: 'SELECT /*+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) */
153: ''Y''
154: FROM pay_time_definitions ptd
155: WHERE ptd.creator_type = ''OTL_W''
156: and ptd.creator_id = '|| p_attribute3;

Line 154: FROM pay_time_definitions ptd

150:
151: c_check_recurring_id_sql :=
152: 'SELECT /*+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) */
153: ''Y''
154: FROM pay_time_definitions ptd
155: WHERE ptd.creator_type = ''OTL_W''
156: and ptd.creator_id = '|| p_attribute3;
157:
158: BEGIN

Line 159: -- Cursor to check if a row exists in pay_time_definitions

155: WHERE ptd.creator_type = ''OTL_W''
156: and ptd.creator_id = '|| p_attribute3;
157:
158: BEGIN
159: -- Cursor to check if a row exists in pay_time_definitions
160: OPEN c_check_recurring_id FOR c_check_recurring_id_sql;
161: FETCH c_check_recurring_id INTO lv_td_exist;
162:
163: IF c_check_recurring_id%NOTFOUND THEN

Line 186: 'Error while inserting a row in pay_time_definitions'

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'
187: );
188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
189: hr_utility.raise_error;
190: END;

Line 188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

184: hr_utility.set_message_token(801,
185: 'ERROR_TEXT',
186: 'Error while inserting a row in pay_time_definitions'
187: );
188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
189: hr_utility.raise_error;
190: END;
191: END IF;
192:

Line 203: 'Error while inserting a row in pay_time_definitions'

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'
204: );
205: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RETRIEVAL_RULE_COMPS_V, '||
206: 'HXC_RETRIEVAL_RULES_V'
207: );

Line 223: ld_start_date pay_time_definitions.start_date%TYPE;

219: p_recurring_period_id IN NUMBER
220: ,p_name IN VARCHAR2
221: ) IS
222:
223: ld_start_date pay_time_definitions.start_date%TYPE;
224: ln_time_definition_id NUMBER;
225: ln_ovn NUMBER;
226:
227: TYPE RefCurType IS REF CURSOR;

Line 237: 'SELECT /+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) /

233: BEGIN
234: hr_utility.TRACE('Entering UPDATE_TIME_DEF_RECURRING');
235:
236: c_check_recurring_id_sql :=
237: 'SELECT /*+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) */
238: ptd.time_definition_id,
239: ptd.start_date,
240: ptd.object_version_number
241: FROM pay_time_definitions ptd

Line 241: FROM pay_time_definitions ptd

237: 'SELECT /*+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) */
238: ptd.time_definition_id,
239: ptd.start_date,
240: ptd.object_version_number
241: FROM pay_time_definitions ptd
242: WHERE ptd.creator_type = ''OTL_W''
243: AND ptd.creator_id = '|| p_recurring_period_id;
244:
245: -- Cursor to check if a row exists in pay_time_definitions

Line 245: -- Cursor to check if a row exists in pay_time_definitions

241: FROM pay_time_definitions ptd
242: WHERE ptd.creator_type = ''OTL_W''
243: AND ptd.creator_id = '|| p_recurring_period_id;
244:
245: -- Cursor to check if a row exists in pay_time_definitions
246: OPEN c_check_recurring_id FOR c_check_recurring_id_sql;
247: FETCH c_check_recurring_id INTO ln_time_definition_id,
248: ld_start_date,
249: ln_ovn;

Line 274: 'Error while updating a row in pay_time_definitions'

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'
275: );
276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
277: hr_utility.raise_error;
278: END update_time_def_recurring;

Line 276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

272: hr_utility.set_message_token(801,
273: 'ERROR_TEXT',
274: 'Error while updating a row in pay_time_definitions'
275: );
276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
277: hr_utility.raise_error;
278: END update_time_def_recurring;
279:
280: /******************************************************************************

Line 297: lv_def_name pay_time_definitions.definition_name%TYPE;

293:
294:
295:
296: ln_is_error NUMBER;
297: lv_def_name pay_time_definitions.definition_name%TYPE;
298: lv_period_type pay_time_definitions.period_type%TYPE;
299: ld_start_date pay_time_definitions.start_date%TYPE;
300: ld_pd_td_id pay_time_definitions.period_time_definition_id%TYPE;
301:

Line 298: lv_period_type pay_time_definitions.period_type%TYPE;

294:
295:
296: ln_is_error NUMBER;
297: lv_def_name pay_time_definitions.definition_name%TYPE;
298: lv_period_type pay_time_definitions.period_type%TYPE;
299: ld_start_date pay_time_definitions.start_date%TYPE;
300: ld_pd_td_id pay_time_definitions.period_time_definition_id%TYPE;
301:
302: TYPE RefCurType is REF CURSOR;

Line 299: ld_start_date pay_time_definitions.start_date%TYPE;

295:
296: ln_is_error NUMBER;
297: lv_def_name pay_time_definitions.definition_name%TYPE;
298: lv_period_type pay_time_definitions.period_type%TYPE;
299: ld_start_date pay_time_definitions.start_date%TYPE;
300: ld_pd_td_id pay_time_definitions.period_time_definition_id%TYPE;
301:
302: TYPE RefCurType is REF CURSOR;
303: c_get_timedef_detail RefCurType;

Line 300: ld_pd_td_id pay_time_definitions.period_time_definition_id%TYPE;

296: ln_is_error NUMBER;
297: lv_def_name pay_time_definitions.definition_name%TYPE;
298: lv_period_type pay_time_definitions.period_type%TYPE;
299: ld_start_date pay_time_definitions.start_date%TYPE;
300: ld_pd_td_id pay_time_definitions.period_time_definition_id%TYPE;
301:
302: TYPE RefCurType is REF CURSOR;
303: c_get_timedef_detail RefCurType;
304:

Line 319: FROM pay_time_definitions

315: 'SELECT definition_name
316: ,period_type
317: ,start_date
318: ,period_time_definition_id
319: FROM pay_time_definitions
320: WHERE time_definition_id = ' || p_time_definition_id;
321:
322: -- Cursor to get time_definition details
323: OPEN c_get_timedef_detail FOR c_get_timedef_detail_sql;

Line 414: 'Error while updating a row in pay_time_definitions'

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'
415: );
416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
417: hr_utility.raise_error;
418:

Line 416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

412: hr_utility.set_message_token(801,
413: 'ERROR_TEXT',
414: 'Error while updating a row in pay_time_definitions'
415: );
416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
417: hr_utility.raise_error;
418:
419: END status_otl_time_def;
420:

Line 427: pay_time_definitions if it does not already exist.

423: Name : INSERT_USER_HOOK_HIERARCHY
424: Scope : GLOBAL
425: Description : This procedure is called by AFTER INSERT Row Level handler
426: User Hook of HXC_PREF_HIERARCHIES to insert a row in
427: pay_time_definitions if it does not already exist.
428: ******************************************************************************/
429: PROCEDURE insert_user_hook_hierarchy (
430: p_business_group_id IN NUMBER,
431: p_legislation_code IN VARCHAR2 DEFAULT NULL,

Line 462: pay_time_definitions if it does not already exist.

458: Name : UPDATE_USER_HOOK_HIERARCHY
459: Scope : GLOBAL
460: Description : This procedure is called by AFTER UPDATE Row Level handler
461: User Hook of HXC_PREF_HIERARCHIES to insert a row in
462: pay_time_definitions if it does not already exist.
463: ******************************************************************************/
464: PROCEDURE update_user_hook_hierarchy (
465: p_business_group_id IN NUMBER,
466: p_legislation_code IN VARCHAR2 DEFAULT NULL,

Line 590: 'Error while updating a row in pay_time_definitions'

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'
591: );
592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
593: hr_utility.raise_error;
594: END;