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_ABS_RETRIEVAL_PKG dependencies on HXC_ABS_RETRIEVAL_PKG

Line 1: PACKAGE BODY hxc_abs_retrieval_pkg AS

1: PACKAGE BODY hxc_abs_retrieval_pkg AS
2: /* $Header: hxcabsret.pkb 120.24.12020000.2 2012/07/04 09:11:13 amnaraya ship $ */
3:
4: g_package varchar2(30) := 'hxc_abs_retrieval_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;

Line 4: g_package varchar2(30) := 'hxc_abs_retrieval_pkg.';

1: PACKAGE BODY hxc_abs_retrieval_pkg AS
2: /* $Header: hxcabsret.pkb 120.24.12020000.2 2012/07/04 09:11:13 amnaraya ship $ */
3:
4: g_package varchar2(30) := 'hxc_abs_retrieval_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: g_resource_id NUMBER := NULL;
8: g_tc_start DATE := NULL;

Line 14: g_all_id_tab hxc_abs_retrieval_pkg.NUMTAB;

10: g_tc_status VARCHAR2 (10) := NULL;
11:
12: g_abs_integ_enabled VARCHAR2 (1) := 'N';
13: g_abs_prepop_edit VARCHAR2 (1) := 'N';
14: g_all_id_tab hxc_abs_retrieval_pkg.NUMTAB;
15: g_all_ovn_tab hxc_abs_retrieval_pkg.NUMTAB;
16: g_success_create_msg VARCHAR2 (100):= 'This absence detail was successfully created in Absences module';
17: g_success_delete_msg VARCHAR2 (100):= 'This absence detail was successfully deleted in Absences module';
18: g_fail_create_msg VARCHAR2 (50) := ' (Online Retrieval Failed)';

Line 15: g_all_ovn_tab hxc_abs_retrieval_pkg.NUMTAB;

11:
12: g_abs_integ_enabled VARCHAR2 (1) := 'N';
13: g_abs_prepop_edit VARCHAR2 (1) := 'N';
14: g_all_id_tab hxc_abs_retrieval_pkg.NUMTAB;
15: g_all_ovn_tab hxc_abs_retrieval_pkg.NUMTAB;
16: g_success_create_msg VARCHAR2 (100):= 'This absence detail was successfully created in Absences module';
17: g_success_delete_msg VARCHAR2 (100):= 'This absence detail was successfully deleted in Absences module';
18: g_fail_create_msg VARCHAR2 (50) := ' (Online Retrieval Failed)';
19: g_business_group_id NUMBER := NULL;

Line 175: l_id_tab hxc_abs_retrieval_pkg.NUMTAB;

171: all_abs_tab t_absences;
172: l_tbb_ix NUMBER := 0;
173: abs_ix BINARY_INTEGER;
174: l_cost_segment t_cost_attributes;
175: l_id_tab hxc_abs_retrieval_pkg.NUMTAB;
176: l_ovn_tab hxc_abs_retrieval_pkg.NUMTAB;
177:
178: l_prepop_delete_absences t_delete_absences;
179: l_ret_delete_absences t_delete_absences;

Line 176: l_ovn_tab hxc_abs_retrieval_pkg.NUMTAB;

172: l_tbb_ix NUMBER := 0;
173: abs_ix BINARY_INTEGER;
174: l_cost_segment t_cost_attributes;
175: l_id_tab hxc_abs_retrieval_pkg.NUMTAB;
176: l_ovn_tab hxc_abs_retrieval_pkg.NUMTAB;
177:
178: l_prepop_delete_absences t_delete_absences;
179: l_ret_delete_absences t_delete_absences;
180: l_edited_days t_edited_days;

Line 1288: p_absences IN hxc_abs_retrieval_pkg.t_absences,

1284:
1285: -- Procedure to Create Absences in HR module and update HXC_ABS_CO_DETAILS with the latest absence info.
1286:
1287: PROCEDURE create_absences (
1288: p_absences IN hxc_abs_retrieval_pkg.t_absences,
1289: p_uom IN VARCHAR2
1290: )
1291: AS
1292: CURSOR get_create_abs_details (c_tbb_id NUMBER)

Line 1574: p_absences IN hxc_abs_retrieval_pkg.t_absences_details,

1570: -- After prepopulation, if 3-jan-2009 and 7-jan-2009 only are deleted/updated, then delete the single absence entry in HR and
1571: -- recreate absences for the remaining untouched days
1572:
1573: PROCEDURE recreate_absences (
1574: p_absences IN hxc_abs_retrieval_pkg.t_absences_details,
1575: p_uom IN VARCHAR2,
1576: p_old_absence_attendance_id IN NUMBER
1577: )
1578: AS

Line 1714: p_edited_days IN hxc_abs_retrieval_pkg.t_edited_days,

1710:
1711: -- delete absences from HR for updated/modified TC absences details
1712: PROCEDURE delete_absences (
1713: p_absence_attendance_id IN NUMBER,
1714: p_edited_days IN hxc_abs_retrieval_pkg.t_edited_days,
1715: p_uom IN VARCHAR2
1716: )
1717: AS
1718: CURSOR get_absences_details_cur

Line 2332: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,

2328:
2329:
2330: -- Create Transaction detail records for successfully retrieved absences
2331: PROCEDURE create_transactions (
2332: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,
2333: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,
2334: p_status IN VARCHAR2 DEFAULT NULL,
2335: p_description IN VARCHAR2 DEFAULT NULL
2336: )

Line 2333: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,

2329:
2330: -- Create Transaction detail records for successfully retrieved absences
2331: PROCEDURE create_transactions (
2332: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,
2333: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,
2334: p_status IN VARCHAR2 DEFAULT NULL,
2335: p_description IN VARCHAR2 DEFAULT NULL
2336: )
2337: IS

Line 2414: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,

2410:
2411:
2412:
2413: PROCEDURE insert_audit_details (
2414: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,
2415: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,
2416: p_status IN VARCHAR2 DEFAULT NULL,
2417: p_description IN VARCHAR2 DEFAULT NULL,
2418: p_transaction_id IN hxc_transactions.transaction_id%TYPE

Line 2415: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,

2411:
2412:
2413: PROCEDURE insert_audit_details (
2414: p_tbb_id IN hxc_abs_retrieval_pkg.NUMTAB,
2415: p_tbb_ovn IN hxc_abs_retrieval_pkg.NUMTAB,
2416: p_status IN VARCHAR2 DEFAULT NULL,
2417: p_description IN VARCHAR2 DEFAULT NULL,
2418: p_transaction_id IN hxc_transactions.transaction_id%TYPE
2419: )

Line 2562: p_cost_attributes IN OUT NOCOPY hxc_abs_retrieval_pkg.t_cost_attributes

2558:
2559:
2560:
2561: PROCEDURE populate_cost_keyflex (
2562: p_cost_attributes IN OUT NOCOPY hxc_abs_retrieval_pkg.t_cost_attributes
2563: )
2564: IS
2565: sql_stmt VARCHAR2 (300);
2566: l_proc VARCHAR2(100);

Line 2798: END hxc_abs_retrieval_pkg;

2794: END get_retrieval_rule;
2795:
2796:
2797:
2798: END hxc_abs_retrieval_pkg;
2799: