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_US_ELEMENT_ENTRY_HOOK dependencies on PAY_US_ELEMENT_ENTRY_HOOK

Line 1: PACKAGE BODY PAY_US_ELEMENT_ENTRY_HOOK AS

1: PACKAGE BODY PAY_US_ELEMENT_ENTRY_HOOK AS
2: /* $Header: pyuseehd.pkb 120.7.12020000.2 2013/04/04 09:10:39 pracagra ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : PAY_US_ELEMENT_ENTRY_HOOK

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : PAY_US_ELEMENT_ENTRY_HOOK
21: File Name : pyuseehd.pkb
22:
23: Description : This package is called from the AFTER INSERT/UPDATE/DELETE
24: User Hooks. The following are the functionalities present

Line 110: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');

106:
107: ln_daily_rate number;
108: ln_no_of_days number;
109: BEGIN
110: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
111:
112: -- Initialization Code
113: ln_daily_rate := 0;
114:

Line 120: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');

116: ln_no_of_days := p_end_date - p_start_date + 1;
117: ln_daily_rate := round((nvl(p_inp_value,0)/ln_no_of_days),2);
118:
119: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);
120: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
121: return ln_daily_rate ;
122:
123: EXCEPTION
124: WHEN OTHERS THEN

Line 211: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CHECK_AUGMENT_ELEM');

207: ld_rec_ele_start_date DATE;
208: ld_rec_ele_end_date DATE;
209:
210: BEGIN
211: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CHECK_AUGMENT_ELEM');
212:
213: ln_count := 0;
214: ld_rec_ele_end_date := NULL;
215: ld_rec_ele_start_date := NULL;

Line 424: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');

420: ln_ele_entry_id NUMBER;
421: ld_del_start_date DATE;
422:
423: BEGIN
424: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
425: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
426: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
427:
428: open c_get_ele_entry_id(p_element_entry_id

Line 444: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');

440: p_session_date => ld_del_start_date,
441: p_element_entry_id => ln_ele_entry_id);
442: end loop;
443: close c_get_ele_entry_id;
444: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
445: return;
446:
447: EXCEPTION
448: --

Line 583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');

579: ld_link_eff_end_date date;
580: ld_dummy_start_date date;
581:
582: BEGIN
583: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
584: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
585: hr_utility.trace('p_start_date = ' || p_start_date);
586: hr_utility.trace('p_end_date = ' || p_end_date);
587: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

Line 798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');

794:
795:
796: BEGIN
797:
798: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
799: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
800: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
801: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
802: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);

Line 1020: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');

1016: gd_end_date_tbl.delete;
1017: gn_link_id_tbl.delete;
1018: gn_ele_ent_num := NULL;
1019: gn_daily_amount := NULL;
1020: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
1021: return;
1022:
1023: EXCEPTION
1024: --

Line 1125: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

1121: l_fed_effective_start_date DATE;
1122: l_fed_effective_end_date DATE;
1123:
1124: BEGIN
1125: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1126:
1127: IF hr_general.chk_maintain_tax_records = 'Y' THEN
1128:
1129: -- Initialization Code

Line 1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

1271: end if; -- if lv_city_code <> '0000'
1272: end if; -- if lv_county_code <> '000'
1273: end if; -- if lv_state_code <> '00'
1274: end if; -- if lv_jurisdiction_code
1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1276: ELSE
1277: /* hr_general.chk_maintain_tax_records = 'N' */
1278: hr_utility.trace(' hr_general.chk_maintain_tax_records = N ');
1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

Line 1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');

1275: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1276: ELSE
1277: /* hr_general.chk_maintain_tax_records = 'N' */
1278: hr_utility.trace(' hr_general.chk_maintain_tax_records = N ');
1279: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1280: NULL;
1281: END IF;
1282: return;
1283: END CREATE_TAX_RECORDS;

Line 1852: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');

1848: ,p_entry_type in varchar2
1849: ,p_entry_information_category in varchar2) IS
1850: BEGIN
1851:
1852: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1853: -- Call CREATE_RECUR_ELEM_ENTRY
1854: -- The package has the check built in for identifying Augment Elements
1855: CREATE_RECUR_ELEM_ENTRY(p_element_entry_id
1856: ,p_effective_start_date

Line 1887: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');

1883: ,p_original_entry_id
1884: ,p_creator_type
1885: ,p_entry_type
1886: ,p_entry_information_category);
1887: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1888: return;
1889: END INSERT_USER_HOOK;
1890:
1891: -----------------------------INSERT SECTION ENDS HERE--------------------------

Line 1993: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');

1989: l_entry_value_tbl hr_entry.varchar2_table;
1990:
1991: BEGIN
1992:
1993: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
1994:
1995: -- Initialization
1996: ld_rec_ele_start_date := hr_api.g_date;
1997: ld_rec_ele_end_date := hr_api.g_date;

Line 2113: PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY(

2109: end if; -- if l_elem_entry_id_tbl.count()
2110:
2111: -- Recreating New recurring element entries
2112: hr_utility.trace('Creating New Recurring Element Entries');
2113: PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY(
2114: p_element_entry_id
2115: ,p_effective_start_date
2116: ,p_effective_end_date
2117: ,p_assignment_id_o

Line 2160: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');

2156: end loop; -- for lvar in l_elem_entry_id_tb
2157: end if; -- if l_elem_entry_id_tbl.count()
2158: end if; -- if (ld_rec_ele_start_date <>
2159:
2160: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
2161: return;
2162: EXCEPTION
2163: --
2164: WHEN others THEN

Line 2329: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');

2325: l_entry_value_tbl hr_entry.varchar2_table;
2326:
2327: BEGIN
2328:
2329: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2330:
2331: ln_count := 0;
2332: lvar := 0;
2333: lb_mop_up_flag := FALSE;

Line 2478: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');

2474: end if; -- if c_check_mop_up_exists%FOUND
2475:
2476: end if;
2477:
2478: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2479: return;
2480:
2481: END UPDATE_PREMIUM_MOP_UP_ELEMENT;
2482:

Line 2501: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');

2497: ,p_creator_type_o in varchar2
2498: ,p_entry_type_o in varchar2
2499: ,p_entry_information_category_o in varchar2) IS
2500: BEGIN
2501: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2502:
2503: -- Update the Recurring Element Entry associated with
2504: -- the Augment element
2505: UPDATE_RECUR_ELEM_ENTRY(p_element_entry_id

Line 2541: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');

2537: ,p_creator_type_o
2538: ,p_entry_type_o
2539: ,p_entry_information_category_o);
2540:
2541: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2542: return;
2543: END UPDATE_USER_HOOK;
2544:
2545: -----------------------------UPDATE SECTION ENDS HERE--------------------------

Line 2583: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');

2579: lb_prem_flag boolean;
2580:
2581: BEGIN
2582: hr_utility.trace
2583: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2584:
2585: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');
2586:
2587: lb_prem_flag := CHECK_PREMIUM_ELEM(p_element_entry_id

Line 2621: ('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');

2617: close c_get_entry_end_date;
2618: end if; -- if lb_prem_flag
2619:
2620: hr_utility.trace
2621: ('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2622: return;
2623: END DELETE_PREM_MOP_UP_ELE_ENTRY;
2624:
2625: /******************************************************************************

Line 2651: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');

2647:
2648: lv_exists varchar2(10);
2649:
2650: BEGIN
2651: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2652:
2653: -- Check if the Element Entry was Purged. If yes delete the associated
2654: -- 'FL' creator type elements.
2655: -- We do not have any way to check the type of element once it is deleted

Line 2678: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');

2674:
2675: end if; -- if c_chk_elem_entry_exists%NOTFOUND
2676: close c_chk_elem_entry_exists;
2677:
2678: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2679: return;
2680: END DELETE_USER_HOOK;
2681:
2682: -----------------------------DELETE SECTION ENDS HERE--------------------------

Line 2684: END PAY_US_ELEMENT_ENTRY_HOOK;

2680: END DELETE_USER_HOOK;
2681:
2682: -----------------------------DELETE SECTION ENDS HERE--------------------------
2683:
2684: END PAY_US_ELEMENT_ENTRY_HOOK;