[Home] [Help]
1: PACKAGE BODY PAY_US_ELEMENT_ENTRY_HOOK AS
2: /* $Header: pyuseehd.pkb 120.2 2006/04/04 23:59:10 rdhingra noship $ */
3: /*
4: ******************************************************************
5: * *
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
90:
91: ln_daily_rate number;
92: ln_no_of_days number;
93: BEGIN
94: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
95:
96: -- Initialization Code
97: ln_daily_rate := 0;
98:
100: ln_no_of_days := p_end_date - p_start_date + 1;
101: ln_daily_rate := round((nvl(p_inp_value,0)/ln_no_of_days),2);
102:
103: hr_utility.trace('DAILY AMOUNT = ' || ln_daily_rate);
104: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.GET_DAILY_AMOUNT');
105: return ln_daily_rate ;
106:
107: EXCEPTION
108: WHEN OTHERS THEN
191: ld_rec_ele_start_date DATE;
192: ld_rec_ele_end_date DATE;
193:
194: BEGIN
195: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CHECK_AUGMENT_ELEM');
196:
197: ln_count := 0;
198: ld_rec_ele_end_date := NULL;
199: ld_rec_ele_start_date := NULL;
404: ln_ele_entry_id NUMBER;
405: ld_del_start_date DATE;
406:
407: BEGIN
408: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
409: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
410: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
411:
412: open c_get_ele_entry_id(p_element_entry_id
424: p_session_date => ld_del_start_date,
425: p_element_entry_id => ln_ele_entry_id);
426: end loop;
427: close c_get_ele_entry_id;
428: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_DEPENDENT_ENTRIES');
429: return;
430:
431: EXCEPTION
432: --
551: ld_link_eff_end_date date;
552: ld_dummy_start_date date;
553:
554: BEGIN
555: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.POPULATE_ELE_LINK');
556: hr_utility.trace('p_assignment_id = ' || p_assignment_id);
557: hr_utility.trace('p_start_date = ' || p_start_date);
558: hr_utility.trace('p_end_date = ' || p_end_date);
559: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
766:
767:
768: BEGIN
769:
770: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
771: hr_utility.trace('P_ELEMENT_ENTRY_ID = ' ||p_element_entry_id);
772: hr_utility.trace('P_EFFECTIVE_START_DATE = ' || p_effective_start_date);
773: hr_utility.trace('P_EFFECTIVE_END_DATE = ' || p_effective_end_date);
774: hr_utility.trace('P_ASSIGNMENT_ID = ' || p_assignment_id);
988: gd_end_date_tbl.delete;
989: gn_link_id_tbl.delete;
990: gn_ele_ent_num := NULL;
991: gn_daily_amount := NULL;
992: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY');
993: return;
994:
995: EXCEPTION
996: --
1080: ld_eff_start_date DATE;
1081: ld_eff_end_date DATE;
1082:
1083: BEGIN
1084: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1085:
1086: -- Initialization Code
1087: lv_state_code := NULL;
1088: lv_county_code := NULL;
1191: end if; -- if lv_city_code <> '0000'
1192: end if; -- if lv_county_code <> '000'
1193: end if; -- if lv_state_code <> '00'
1194: end if; -- if lv_jurisdiction_code
1195: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.CREATE_TAX_RECORDS');
1196: return;
1197: END CREATE_TAX_RECORDS;
1198:
1199: /******************************************************************************
1750: ,p_entry_type in varchar2
1751: ,p_entry_information_category in varchar2) IS
1752: BEGIN
1753:
1754: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1755: -- Call CREATE_RECUR_ELEM_ENTRY
1756: -- The package has the check built in for identifying Augment Elements
1757: CREATE_RECUR_ELEM_ENTRY(p_element_entry_id
1758: ,p_effective_start_date
1785: ,p_original_entry_id
1786: ,p_creator_type
1787: ,p_entry_type
1788: ,p_entry_information_category);
1789: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.INSERT_USER_HOOK');
1790: return;
1791: END INSERT_USER_HOOK;
1792:
1793: -----------------------------INSERT SECTION ENDS HERE--------------------------
1891: l_entry_value_tbl hr_entry.varchar2_table;
1892:
1893: BEGIN
1894:
1895: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
1896:
1897: -- Initialization
1898: ld_rec_ele_start_date := hr_api.g_date;
1899: ld_rec_ele_end_date := hr_api.g_date;
2011: end if; -- if l_elem_entry_id_tbl.count()
2012:
2013: -- Recreating New recurring element entries
2014: hr_utility.trace('Creating New Recurring Element Entries');
2015: PAY_US_ELEMENT_ENTRY_HOOK.CREATE_RECUR_ELEM_ENTRY(
2016: p_element_entry_id
2017: ,p_effective_start_date
2018: ,p_effective_end_date
2019: ,p_assignment_id_o
2058: end loop; -- for lvar in l_elem_entry_id_tb
2059: end if; -- if l_elem_entry_id_tbl.count()
2060: end if; -- if (ld_rec_ele_start_date <>
2061:
2062: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_RECUR_ELEM_ENTRY');
2063: return;
2064: EXCEPTION
2065: --
2066: WHEN others THEN
2227: l_entry_value_tbl hr_entry.varchar2_table;
2228:
2229: BEGIN
2230:
2231: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2232:
2233: ln_count := 0;
2234: lvar := 0;
2235: lb_mop_up_flag := FALSE;
2376: end if; -- if c_check_mop_up_exists%FOUND
2377:
2378: end if;
2379:
2380: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_PREMIUM_MOP_UP_ELEMENT');
2381: return;
2382:
2383: END UPDATE_PREMIUM_MOP_UP_ELEMENT;
2384:
2399: ,p_creator_type_o in varchar2
2400: ,p_entry_type_o in varchar2
2401: ,p_entry_information_category_o in varchar2) IS
2402: BEGIN
2403: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2404:
2405: -- Update the Recurring Element Entry associated with
2406: -- the Augment element
2407: UPDATE_RECUR_ELEM_ENTRY(p_element_entry_id
2439: ,p_creator_type_o
2440: ,p_entry_type_o
2441: ,p_entry_information_category_o);
2442:
2443: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.UPDATE_USER_HOOK');
2444: return;
2445: END UPDATE_USER_HOOK;
2446:
2447: -----------------------------UPDATE SECTION ENDS HERE--------------------------
2481: lb_prem_flag boolean;
2482:
2483: BEGIN
2484: hr_utility.trace
2485: ('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2486:
2487: ld_end_of_time := fnd_date.canonical_to_date('4712/12/31');
2488:
2489: lb_prem_flag := CHECK_PREMIUM_ELEM(p_element_entry_id
2519: close c_get_entry_end_date;
2520: end if; -- if lb_prem_flag
2521:
2522: hr_utility.trace
2523: ('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_PREM_MOP_UP_ELE_ENTRY');
2524: return;
2525: END DELETE_PREM_MOP_UP_ELE_ENTRY;
2526:
2527: /******************************************************************************
2549:
2550: lv_exists varchar2(10);
2551:
2552: BEGIN
2553: hr_utility.trace('Entering PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2554:
2555: -- Check if the Element Entry was Purged. If yes delete the associated
2556: -- 'FL' creator type elements.
2557: -- We do not have any way to check the type of element once it is deleted
2576:
2577: end if; -- if c_chk_elem_entry_exists%NOTFOUND
2578: close c_chk_elem_entry_exists;
2579:
2580: hr_utility.trace('Leaving PAY_US_ELEMENT_ENTRY_HOOK.DELETE_USER_HOOK');
2581: return;
2582: END DELETE_USER_HOOK;
2583:
2584: -----------------------------DELETE SECTION ENDS HERE--------------------------
2582: END DELETE_USER_HOOK;
2583:
2584: -----------------------------DELETE SECTION ENDS HERE--------------------------
2585:
2586: END PAY_US_ELEMENT_ENTRY_HOOK;