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_TIMEKEEPER_PROCESS dependencies on HXC_TIMEKEEPER_PROCESS

Line 1: PACKAGE BODY hxc_timekeeper_process AS

1: PACKAGE BODY hxc_timekeeper_process AS
2: /* $Header: hxctksta.pkb 120.28.12020000.3 2012/07/04 09:37:29 amnaraya ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: PROCEDURE timekeeper_query (

Line 267: t_tk_abs_tab hxc_timekeeper_process.t_tk_abs_tab_type;

263:
264: -- change start
265:
266: l_table_counter_tmp NUMBER; -- SVG CHANGE
267: t_tk_abs_tab hxc_timekeeper_process.t_tk_abs_tab_type;
268: l_pref_table hxc_preference_evaluation.t_pref_table;
269: l_pref_index NUMBER;
270: l_pref_date DATE;
271: l_abs_tc_start DATE;

Line 386: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;

382: l_add_index_day NUMBER
383: /*ADVICE(457): NUMBER has no precision [315] */
384: := 0;
385: l_resource_tc_table t_resource_tc_table;
386: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
387: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
388: l_emp_start_date DATE;
389: l_emp_terminate_date DATE;
390: l_row_id ROWID

Line 387: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;

383: /*ADVICE(457): NUMBER has no precision [315] */
384: := 0;
385: l_resource_tc_table t_resource_tc_table;
386: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
387: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
388: l_emp_start_date DATE;
389: l_emp_terminate_date DATE;
390: l_row_id ROWID
391: /*ADVICE(464): Use of ROWID [113] */

Line 5232: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;

5228: spemp_tc_info hxc_timekeeper_utilities.emptctab;
5229: sp_index NUMBER
5230: /*ADVICE(3658): NUMBER has no precision [315] */
5231: := 0;
5232: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
5233: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
5234: l_mid_save VARCHAR2 (5) := 'N';
5235: l_comment_made_null BOOLEAN := FALSE;
5236: l_row_locked_id ROWID

Line 5233: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;

5229: sp_index NUMBER
5230: /*ADVICE(3658): NUMBER has no precision [315] */
5231: := 0;
5232: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
5233: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
5234: l_mid_save VARCHAR2 (5) := 'N';
5235: l_comment_made_null BOOLEAN := FALSE;
5236: l_row_locked_id ROWID
5237: /*ADVICE(3665): Use of ROWID [113] */

Line 6135: p_submit_emp OUT NOCOPY hxc_timekeeper_process.tk_submit_tab,

6131: p_stop_time IN DATE,
6132: p_trx_id IN NUMBER,
6133: p_submit_id OUT NOCOPY NUMBER,
6134: p_insert OUT NOCOPY BOOLEAN,
6135: p_submit_emp OUT NOCOPY hxc_timekeeper_process.tk_submit_tab,
6136: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
6137: ) IS
6138: CURSOR crs_max_submit IS
6139: SELECT MAX (submission_id)

Line 6191: hxc_timekeeper_process.add_remove_lock (

6187: p_process_locker_type => 'PUI_TIMEKEEPER_ACTION',
6188: p_transaction_lock_id => p_trx_id,
6189: p_released_success => l_success
6190: );
6191: hxc_timekeeper_process.add_remove_lock (
6192: p_resource_id => g_submit_table (l_index).resource_id,
6193: p_start_period => p_start_time,
6194: p_end_period => p_stop_time + g_one_day,
6195: p_timecard_id => NULL,

Line 6212: hxc_timekeeper_process.add_remove_lock (

6208: p_messages => p_messages,
6209: p_row_lock_id => l_row_id,
6210: p_locked_success => l_tc_lock_boolean
6211: );
6212: hxc_timekeeper_process.add_remove_lock (
6213: p_resource_id => g_submit_table (l_index).resource_id,
6214: p_start_period => p_start_time,
6215: p_end_period => p_stop_time + g_one_day,
6216: p_timecard_id => NULL,

Line 6379: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;

6375: spemp_tc_info hxc_timekeeper_utilities.emptctab;
6376: sp_index NUMBER
6377: /*ADVICE(4378): NUMBER has no precision [315] */
6378: := 0;
6379: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
6380: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
6381: l_process_lock_type VARCHAR2 (80) := hxc_lock_util.c_pui_timekeeper_action;
6382: l_messages hxc_message_table_type := hxc_message_table_type ();
6383: l_row_id ROWID

Line 6380: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;

6376: sp_index NUMBER
6377: /*ADVICE(4378): NUMBER has no precision [315] */
6378: := 0;
6379: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
6380: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
6381: l_process_lock_type VARCHAR2 (80) := hxc_lock_util.c_pui_timekeeper_action;
6382: l_messages hxc_message_table_type := hxc_message_table_type ();
6383: l_row_id ROWID
6384: /*ADVICE(4385): Use of ROWID [113] */

Line 6685: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,

6681: p_approval_style_id OUT NOCOPY NUMBER,
6682: p_approval_status OUT NOCOPY VARCHAR2,
6683: p_comment_text IN VARCHAR2,
6684: p_timecard_status OUT NOCOPY VARCHAR2,
6685: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
6686: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
6687: p_timecard_id OUT NOCOPY NUMBER
6688: ) IS
6689: CURSOR c_timecard_info (

Line 6686: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,

6682: p_approval_status OUT NOCOPY VARCHAR2,
6683: p_comment_text IN VARCHAR2,
6684: p_timecard_status OUT NOCOPY VARCHAR2,
6685: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
6686: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
6687: p_timecard_id OUT NOCOPY NUMBER
6688: ) IS
6689: CURSOR c_timecard_info (
6690: p_resource_id

Line 7211: p_insert_detail IN hxc_timekeeper_process.t_time_info,

7207: p_tc_frdt IN DATE,
7208: p_tc_todt
7209: /*ADVICE(5021): Unreferenced parameter [552] */
7210: IN DATE,
7211: p_insert_detail IN hxc_timekeeper_process.t_time_info,
7212: p_timecard IN OUT NOCOPY hxc_block_table_type,
7213: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
7214: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
7215: p_approval_style_id IN NUMBER,

Line 7214: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,

7210: IN DATE,
7211: p_insert_detail IN hxc_timekeeper_process.t_time_info,
7212: p_timecard IN OUT NOCOPY hxc_block_table_type,
7213: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
7214: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
7215: p_approval_style_id IN NUMBER,
7216: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
7217: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
7218: p_timecard_id IN NUMBER,

Line 7216: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,

7212: p_timecard IN OUT NOCOPY hxc_block_table_type,
7213: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
7214: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
7215: p_approval_style_id IN NUMBER,
7216: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
7217: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
7218: p_timecard_id IN NUMBER,
7219: p_mid_save IN OUT NOCOPY VARCHAR2,
7220: p_comment_made_null IN OUT NOCOPY BOOLEAN,

Line 7217: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,

7213: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
7214: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
7215: p_approval_style_id IN NUMBER,
7216: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
7217: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
7218: p_timecard_id IN NUMBER,
7219: p_mid_save IN OUT NOCOPY VARCHAR2,
7220: p_comment_made_null IN OUT NOCOPY BOOLEAN,
7221: p_row_lock_id OUT NOCOPY ROWID,

Line 7507: p_base_dff => hxc_timekeeper_process.g_base_att,

7503: valid_att_cat :=
7504: hxc_timekeeper_utilities.get_tk_dff_attrname (
7505: p_tkid => p_timekeeper_id,
7506: p_insert_detail => p_insert_detail,
7507: p_base_dff => hxc_timekeeper_process.g_base_att,
7508: p_att_tab => p_att_tab
7509: );
7510: if g_debug then
7511: hr_utility.TRACE ('Attribute category is '|| valid_att_cat);

Line 8081: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;

8077:
8078: IF (l_new_attribute_value IS NOT NULL)
8079: AND p_att_tab.EXISTS (l_index_attribute) THEN --2786991
8080:
8081: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8082:
8083: /*Bug 9014012*/
8084:
8085: l_found:= 'N';

Line 8088: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;

8084:
8085: l_found:= 'N';
8086:
8087: LOOP
8088: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8089: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8090:
8091: hxc_timekeeper_process.g_negative_index:=
8092: hxc_timekeeper_process.g_negative_index - 1;

Line 8091: hxc_timekeeper_process.g_negative_index:=

8087: LOOP
8088: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8089: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8090:
8091: hxc_timekeeper_process.g_negative_index:=
8092: hxc_timekeeper_process.g_negative_index - 1;
8093: l_found:= 'N';
8094:
8095: else

Line 8092: hxc_timekeeper_process.g_negative_index - 1;

8088: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8089: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8090:
8091: hxc_timekeeper_process.g_negative_index:=
8092: hxc_timekeeper_process.g_negative_index - 1;
8093: l_found:= 'N';
8094:
8095: else
8096:

Line 8107: p_attribute_id => hxc_timekeeper_process.g_negative_index,

8103:
8104:
8105: hxc_timekeeper_utilities.add_attribute (
8106: p_attribute => p_attributes,
8107: p_attribute_id => hxc_timekeeper_process.g_negative_index,
8108: p_tbb_id => l_detail_id,
8109: p_tbb_ovn => l_detail_ovn,
8110: p_blk_type => 'OTL_ALIAS_ITEM_' || l_index_attribute,
8111: p_blk_id => NULL,

Line 8315: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;

8311: OR (l_new_attribute_value is null and l_old_attribute_value is not null)
8312: OR (l_new_attribute_value is not null and l_old_attribute_value is null))
8313: THEN --2786991
8314: --IF NVL (l_new_attribute_value, -1) <> NVL (l_old_attribute_value, -1) THEN
8315: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8316:
8317: /*Bug 9014012*/
8318:
8319: l_found:= 'N';

Line 8322: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;

8318:
8319: l_found:= 'N';
8320:
8321: LOOP
8322: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8323: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8324:
8325: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8326: l_found:= 'N';

Line 8325: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;

8321: LOOP
8322: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8323: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8324:
8325: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8326: l_found:= 'N';
8327:
8328: else
8329:

Line 8712: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;

8708: end if;
8709:
8710: IF l_new_attribute_value IS NOT NULL AND p_att_tab.EXISTS (l_index_attribute) THEN --2786991
8711:
8712: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8713:
8714: /*Bug 9014012*/
8715:
8716: l_found:= 'N';

Line 8719: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;

8715:
8716: l_found:= 'N';
8717:
8718: LOOP
8719: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8720: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8721:
8722: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8723: l_found:= 'N';

Line 8722: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;

8718: LOOP
8719: l_tmp_index:= hxc_timekeeper_process.g_negative_index * -1;
8720: if g_tk_prepop_detail_id_tab.EXISTS(l_tmp_index) then
8721:
8722: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
8723: l_found:= 'N';
8724:
8725: else
8726:

Line 8737: hr_utility.trace('g_negative_index = '||hxc_timekeeper_process.g_negative_index);

8733:
8734:
8735: if g_debug then
8736: hr_utility.trace('before add attribute');
8737: hr_utility.trace('g_negative_index = '||hxc_timekeeper_process.g_negative_index);
8738: end if;
8739:
8740: hxc_timekeeper_utilities.add_attribute (
8741: p_attribute => p_attributes,