[Home] [Help]
1: PACKAGE BODY hxc_timekeeper_process AS
2: /* $Header: hxctksta.pkb 120.12.12010000.3 2008/09/08 12:57:27 pvelugul ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: PROCEDURE timekeeper_query (
359: /*ADVICE(451): NUMBER has no precision [315] */
360: := 0;
361: tc_start DATE;
362: tc_end DATE;
363: emp_qry_tc_info hxc_timekeeper_utilities.emptctab;
364: l_add_index_day NUMBER
365: /*ADVICE(457): NUMBER has no precision [315] */
366: := 0;
367: l_resource_tc_table t_resource_tc_table;
364: l_add_index_day NUMBER
365: /*ADVICE(457): NUMBER has no precision [315] */
366: := 0;
367: l_resource_tc_table t_resource_tc_table;
368: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
369: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
370: l_emp_start_date DATE;
371: l_emp_terminate_date DATE;
372: l_row_id ROWID
365: /*ADVICE(457): NUMBER has no precision [315] */
366: := 0;
367: l_resource_tc_table t_resource_tc_table;
368: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
369: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
370: l_emp_start_date DATE;
371: l_emp_terminate_date DATE;
372: l_row_id ROWID
373: /*ADVICE(464): Use of ROWID [113] */
740: l_emp_edits := NULL;
741: l_audit_enabled := NULL;
742:
743: BEGIN
744: hxc_timekeeper_utilities.get_emp_pref (
745: resource_info.person_id,
746: l_emp_negpref,
747: l_emp_recpref,
748: l_emp_appstyle,
784:
785: emp_qry_tc_info.DELETE;
786: --populate emp_qry_tc_info table with saved timecards in that period
787:
788: hxc_timekeeper_utilities.populate_query_tc_tab (
789: resource_info.person_id,
790: p_start_period,
791: p_end_period,
792: emp_qry_tc_info
999:
1000: -- Get the data actually stored in the database.
1001:
1002:
1003: hxc_timekeeper_utilities.create_attribute_structure (
1004: p_timecard_id => l_timecard_id,
1005: p_timecard_ovn => l_timecard_ovn,
1006: p_resource_id => resource_info.person_id,
1007: p_start_period => tc_start,
1952:
1953: l_found_hours_type := FALSE;
1954:
1955: --IF g_debbug THEN
1956: --hxc_timekeeper_utilities.dump_buffer_table(l_buffer_info);
1957: --END IF;
1958: if g_debug then
1959: hr_utility.trace ('101 -- Normal Query procedure ');
1960: end if;
4228: /*ADVICE(3652): Initialization to NULL is superfluous [417] */
4229:
4230: att_seg_tab hxc_alias_utility.t_alias_att_info;
4231: spemp_tc_list hxc_timecard_utilities.periods;
4232: spemp_tc_info hxc_timekeeper_utilities.emptctab;
4233: sp_index NUMBER
4234: /*ADVICE(3658): NUMBER has no precision [315] */
4235: := 0;
4236: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
4232: spemp_tc_info hxc_timekeeper_utilities.emptctab;
4233: sp_index NUMBER
4234: /*ADVICE(3658): NUMBER has no precision [315] */
4235: := 0;
4236: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
4237: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
4238: l_mid_save VARCHAR2 (5) := 'N';
4239: l_comment_made_null BOOLEAN := FALSE;
4240: l_row_locked_id ROWID
4233: sp_index NUMBER
4234: /*ADVICE(3658): NUMBER has no precision [315] */
4235: := 0;
4236: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
4237: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
4238: l_mid_save VARCHAR2 (5) := 'N';
4239: l_comment_made_null BOOLEAN := FALSE;
4240: l_row_locked_id ROWID
4241: /*ADVICE(3665): Use of ROWID [113] */
4311: EXIT WHEN (NOT l_resource_tc_table.EXISTS (l_resource_id));
4312: -- empty the timecard and attribute table
4313:
4314: -- get the timecards which fit between the range selected.
4315: hxc_timekeeper_utilities.populate_tc_tab (l_resource_id, p_start_period, p_end_period, spemp_tc_info);
4316: -- Remove the timecards which totally dosnt fit in the period
4317: /* changes done by senthil for emp terminate enhancement*/
4318: /*Changed By Mithun for CWK Terminate Bug*/
4319: OPEN c_emp_terminateinfo (p_resource_id => l_resource_id);
4325: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
4326: close c_tc_in_term_period_exists;
4327: end if;
4328: if l_tc_in_term_status <> 'Y' then
4329: hxc_timekeeper_utilities.split_timecard (
4330: l_resource_id,
4331: p_start_period,
4332: p_end_period,
4333: spemp_tc_info,
4494: l_timecard.DELETE;
4495: l_attributes.DELETE;
4496: ELSE
4497: --delete the timecard as no detail is active
4498: hxc_timekeeper.delete_timecard (p_timecard_id => l_timecard_id, p_messages => l_messages);
4499: END IF;
4500: ELSE
4501: l_timecard_id := NULL;
4502: l_tc_status := NULL;
4514: -- my_debug.print_timecard('100', l_timecard);
4515: -- my_debug.print_attributes('200', l_attributes);
4516: --
4517:
4518: hxc_timekeeper.save_timecard (
4519: p_blocks => l_timecard,
4520: p_attributes => l_attributes,
4521: p_messages => l_messages,
4522: p_timecard_id => l_timecard_id,
4727:
4728: g_tk_finish_process := TRUE;
4729: --END IF;
4730:
4731: hxc_timekeeper_utilities.convert_type_to_message_table (l_messages, p_messages);
4732: /* bug fix for 5229954 */
4733: hxc_timekeeper_utilities.populate_detail_temp(1);
4734: /* end of fix for 5229954 */
4735: COMMIT;
4729: --END IF;
4730:
4731: hxc_timekeeper_utilities.convert_type_to_message_table (l_messages, p_messages);
4732: /* bug fix for 5229954 */
4733: hxc_timekeeper_utilities.populate_detail_temp(1);
4734: /* end of fix for 5229954 */
4735: COMMIT;
4736: END;
4737:
4779: p_stop_time IN DATE,
4780: p_trx_id IN NUMBER,
4781: p_submit_id OUT NOCOPY NUMBER,
4782: p_insert OUT NOCOPY BOOLEAN,
4783: p_submit_emp OUT NOCOPY hxc_timekeeper_process.tk_submit_tab,
4784: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
4785: ) IS
4786: CURSOR crs_max_submit IS
4787: SELECT MAX (submission_id)
4835: p_process_locker_type => 'PUI_TIMEKEEPER_ACTION',
4836: p_transaction_lock_id => p_trx_id,
4837: p_released_success => l_success
4838: );
4839: hxc_timekeeper_process.add_remove_lock (
4840: p_resource_id => g_submit_table (l_index).resource_id,
4841: p_start_period => p_start_time,
4842: p_end_period => p_stop_time + g_one_day,
4843: p_timecard_id => NULL,
4856: p_messages => p_messages,
4857: p_row_lock_id => l_row_id,
4858: p_locked_success => l_tc_lock_boolean
4859: );
4860: hxc_timekeeper_process.add_remove_lock (
4861: p_resource_id => g_submit_table (l_index).resource_id,
4862: p_start_period => p_start_time,
4863: p_end_period => p_stop_time + g_one_day,
4864: p_timecard_id => NULL,
5019: l_empnumber VARCHAR2 (30);
5020: l_empname VARCHAR2 (240);
5021: l_enddate DATE;
5022: spemp_tc_list hxc_timecard_utilities.periods;
5023: spemp_tc_info hxc_timekeeper_utilities.emptctab;
5024: sp_index NUMBER
5025: /*ADVICE(4378): NUMBER has no precision [315] */
5026: := 0;
5027: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
5023: spemp_tc_info hxc_timekeeper_utilities.emptctab;
5024: sp_index NUMBER
5025: /*ADVICE(4378): NUMBER has no precision [315] */
5026: := 0;
5027: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
5028: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
5029: l_process_lock_type VARCHAR2 (80) := hxc_lock_util.c_pui_timekeeper_action;
5030: l_messages hxc_message_table_type := hxc_message_table_type ();
5031: l_row_id ROWID
5024: sp_index NUMBER
5025: /*ADVICE(4378): NUMBER has no precision [315] */
5026: := 0;
5027: l_timecard_index_info hxc_timekeeper_process.t_timecard_index_info;
5028: l_attribute_index_info hxc_timekeeper_process.t_attribute_index_info;
5029: l_process_lock_type VARCHAR2 (80) := hxc_lock_util.c_pui_timekeeper_action;
5030: l_messages hxc_message_table_type := hxc_message_table_type ();
5031: l_row_id ROWID
5032: /*ADVICE(4385): Use of ROWID [113] */
5077:
5078: mo_global.init('HXC');
5079: mo_global.set_policy_context ( 'S', l_operating_unit_id );
5080: End;
5081: hxc_timekeeper_utilities.populate_tc_tab (
5082: c_resource.resource_id,
5083: fnd_date.canonical_to_date (p_start_period),
5084: fnd_date.canonical_to_date (p_end_period),
5085: spemp_tc_info
5094: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
5095: close c_tc_in_term_period_exists;
5096: end if;
5097: if l_tc_in_term_status <> 'Y' then
5098: hxc_timekeeper_utilities.split_timecard (
5099: c_resource.resource_id,
5100: fnd_date.canonical_to_date (p_start_period),
5101: fnd_date.canonical_to_date (p_end_period),
5102: spemp_tc_info,
5251: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, 'TK_TCARD_CLA', 4, SYSDATE);
5252: l_tk_audit_enabled :=
5253: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, 'TK_TCARD_CLA', 1, SYSDATE);
5254:
5255: hxc_timekeeper.submit_timecard (
5256: p_blocks => l_timecard,
5257: p_attributes => l_attributes,
5258: p_messages => p_messages,
5259: p_timecard_id => l_timecard_id,
5329: p_approval_style_id OUT NOCOPY NUMBER,
5330: p_approval_status OUT NOCOPY VARCHAR2,
5331: p_comment_text IN VARCHAR2,
5332: p_timecard_status OUT NOCOPY VARCHAR2,
5333: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
5334: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
5335: p_timecard_id OUT NOCOPY NUMBER
5336: ) IS
5337: CURSOR c_timecard_info (
5330: p_approval_status OUT NOCOPY VARCHAR2,
5331: p_comment_text IN VARCHAR2,
5332: p_timecard_status OUT NOCOPY VARCHAR2,
5333: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
5334: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
5335: p_timecard_id OUT NOCOPY NUMBER
5336: ) IS
5337: CURSOR c_timecard_info (
5338: p_resource_id
5511: l_audit_enabled := NULL;
5512:
5513: -- let's get the resource preference
5514: -- we need to reset the approval style all the time.
5515: hxc_timekeeper_utilities.get_emp_pref (
5516: p_resource_id => p_resource_id,
5517: neg_pref => l_emp_negpref,
5518: recpref => l_emp_recpref,
5519: appstyle => l_emp_appstyle,
5552:
5553: g_negative_index := g_negative_index - 1;
5554:
5555: --
5556: hxc_timekeeper_utilities.add_attribute (
5557: p_attribute => p_attributes,
5558: p_attribute_id => g_negative_index,
5559: p_tbb_id => l_timecard_id,
5560: p_tbb_ovn => l_timecard_ovn,
5580: hxc_timecard_search_pkg.get_timecard_status_code (l_timecard_id, l_timecard_ovn);
5581: p_timecard_status := l_timecard_status;
5582: END IF;
5583:
5584: hxc_timekeeper_utilities.create_attribute_structure (
5585: p_timecard_id => l_timecard_id,
5586: p_timecard_ovn => l_timecard_ovn,
5587: p_resource_id => p_resource_id,
5588: p_start_period => p_start_period,
5601: else
5602: l_timecard_changed:='Y';
5603: end if;
5604: /* end of fix for 5398047 */
5605: hxc_timekeeper_utilities.add_block (
5606: p_timecard => p_timecard,
5607: p_timecard_id => l_timecard_id,
5608: p_ovn => l_timecard_ovn,
5609: p_parent_id => NULL,
5666: else
5667: l_day_changed:='Y';
5668: end if;
5669: /* end of fix for 5398047 */
5670: hxc_timekeeper_utilities.add_block (
5671: p_timecard => p_timecard,
5672: p_timecard_id => l_day_id,
5673: p_ovn => l_day_ovn,
5674: p_parent_id => l_timecard_id,
5691: -- add the detail now
5692: IF l_day_id > 0 THEN
5693: FOR detail_info IN c_detail_info (p_resource_id, l_day_id, l_day_ovn) LOOP
5694: -- add the detail
5695: hxc_timekeeper_utilities.add_block (
5696: p_timecard => p_timecard,
5697: p_timecard_id => detail_info.detail_id,
5698: p_ovn => detail_info.detail_ovn,
5699: p_parent_id => l_day_id,
5739: p_tc_frdt IN DATE,
5740: p_tc_todt
5741: /*ADVICE(5021): Unreferenced parameter [552] */
5742: IN DATE,
5743: p_insert_detail IN hxc_timekeeper_process.t_time_info,
5744: p_timecard IN OUT NOCOPY hxc_block_table_type,
5745: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
5746: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
5747: p_approval_style_id IN NUMBER,
5742: IN DATE,
5743: p_insert_detail IN hxc_timekeeper_process.t_time_info,
5744: p_timecard IN OUT NOCOPY hxc_block_table_type,
5745: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
5746: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
5747: p_approval_style_id IN NUMBER,
5748: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
5749: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
5750: p_timecard_id IN NUMBER,
5744: p_timecard IN OUT NOCOPY hxc_block_table_type,
5745: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
5746: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
5747: p_approval_style_id IN NUMBER,
5748: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
5749: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
5750: p_timecard_id IN NUMBER,
5751: p_mid_save IN OUT NOCOPY VARCHAR2,
5752: p_comment_made_null IN OUT NOCOPY BOOLEAN,
5745: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
5746: p_day_id_info_table IN hxc_timekeeper_process.t_day_id_info_table,
5747: p_approval_style_id IN NUMBER,
5748: p_attribute_index_info IN OUT NOCOPY hxc_timekeeper_process.t_attribute_index_info,
5749: p_timecard_index_info IN OUT NOCOPY hxc_timekeeper_process.t_timecard_index_info,
5750: p_timecard_id IN NUMBER,
5751: p_mid_save IN OUT NOCOPY VARCHAR2,
5752: p_comment_made_null IN OUT NOCOPY BOOLEAN,
5753: p_row_lock_id OUT NOCOPY ROWID,
6022: -- end 2789497
6023:
6024: -- get the attribute category as base for Details
6025: valid_att_cat :=
6026: hxc_timekeeper_utilities.get_tk_dff_attrname (
6027: p_tkid => p_timekeeper_id,
6028: p_insert_detail => p_insert_detail,
6029: p_base_dff => hxc_timekeeper_process.g_base_att,
6030: p_att_tab => p_att_tab
6025: valid_att_cat :=
6026: hxc_timekeeper_utilities.get_tk_dff_attrname (
6027: p_tkid => p_timekeeper_id,
6028: p_insert_detail => p_insert_detail,
6029: p_base_dff => hxc_timekeeper_process.g_base_att,
6030: p_att_tab => p_att_tab
6031: );
6032: if g_debug then
6033: hr_utility.TRACE ('Attribute category is '|| valid_att_cat);
6150: l_detail_old_att_30 := NULL;
6151:
6152: -- find the detail information for the current day
6153:
6154: hxc_timekeeper_utilities.manage_timeinfo (
6155: p_day_counter => (l_add_index_day + l_index_day),
6156: p_insert_detail => p_insert_detail,
6157: p_measure => l_measure,
6158: p_detail_id => l_detail_id,
6542: IF l_detail_time_in > l_detail_time_out THEN
6543: l_detail_time_out := l_detail_time_out + 1;
6544: END IF;
6545:
6546: hxc_timekeeper_utilities.add_block (
6547: p_timecard => p_timecard,
6548: p_timecard_id => l_detail_id,
6549: p_ovn => l_detail_ovn,
6550: p_parent_id => p_day_id_info_table (l_index_day).day_id,
6567: -- add the attribute information.
6568:
6569: FOR l_index_attribute IN 1 .. 20 LOOP
6570:
6571: hxc_timekeeper_utilities.manage_attributes (
6572: p_attribute_number => l_index_attribute,
6573: p_insert_data_details => p_insert_detail,
6574: p_old_value => l_old_attribute_value,
6575: p_new_value => l_new_attribute_value
6577:
6578: IF (l_new_attribute_value IS NOT NULL)
6579: AND p_att_tab.EXISTS (l_index_attribute) THEN --2786991
6580:
6581: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
6582:
6583: hxc_timekeeper_utilities.add_attribute (
6584: p_attribute => p_attributes,
6585: p_attribute_id => hxc_timekeeper_process.g_negative_index,
6579: AND p_att_tab.EXISTS (l_index_attribute) THEN --2786991
6580:
6581: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
6582:
6583: hxc_timekeeper_utilities.add_attribute (
6584: p_attribute => p_attributes,
6585: p_attribute_id => hxc_timekeeper_process.g_negative_index,
6586: p_tbb_id => l_detail_id,
6587: p_tbb_ovn => l_detail_ovn,
6581: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
6582:
6583: hxc_timekeeper_utilities.add_attribute (
6584: p_attribute => p_attributes,
6585: p_attribute_id => hxc_timekeeper_process.g_negative_index,
6586: p_tbb_id => l_detail_id,
6587: p_tbb_ovn => l_detail_ovn,
6588: p_blk_type => 'OTL_ALIAS_ITEM_' || l_index_attribute,
6589: p_blk_id => NULL,
6607: -- add the dff detail
6608: g_negative_index := g_negative_index - 1;
6609: l_attribute_index := g_negative_index;
6610:
6611: hxc_timekeeper_utilities.add_dff_attribute (
6612: p_attribute => p_attributes,
6613: p_attribute_id => g_negative_index,
6614: p_tbb_id => l_detail_id,
6615: p_tbb_ovn => l_detail_ovn,
6662: -- g_negative_index := g_negative_index;
6663: -- the above statement can be mutually exclusive..check out
6664:
6665: l_attribute_index := g_negative_index;
6666: hxc_timekeeper_utilities.add_dff_attribute (
6667: p_attribute => p_attributes,
6668: p_attribute_id => g_negative_index,
6669: p_tbb_id => l_detail_id,
6670: p_tbb_ovn => l_detail_ovn,
6725: -- work on the attribute information.
6726:
6727: FOR l_index_attribute IN 1 .. 20 LOOP
6728:
6729: hxc_timekeeper_utilities.manage_attributes (
6730: p_attribute_number => l_index_attribute,
6731: p_insert_data_details => p_insert_detail,
6732: p_old_value => l_old_attribute_value,
6733: p_new_value => l_new_attribute_value
6742: OR (l_new_attribute_value is null and l_old_attribute_value is not null)
6743: OR (l_new_attribute_value is not null and l_old_attribute_value is null))
6744: THEN --2786991
6745: --IF NVL (l_new_attribute_value, -1) <> NVL (l_old_attribute_value, -1) THEN
6746: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
6747:
6748:
6749: if g_debug then
6750: hr_utility.trace('l_detail_changed1 '||l_detail_changed);
6756: hr_utility.trace('l_detail_changed1 '||l_detail_changed);
6757: end if;
6758: END IF;
6759:
6760: hxc_timekeeper_utilities.add_attribute (
6761: p_attribute => p_attributes,
6762: p_attribute_id => g_negative_index,
6763: p_tbb_id => l_detail_id,
6764: p_tbb_ovn => l_detail_ovn,
6790: hr_utility.trace('l_detail_changed 3'||l_detail_changed);
6791: end if;
6792:
6793:
6794: hxc_timekeeper_utilities.add_block (
6795: p_timecard => p_timecard,
6796: p_timecard_id => l_detail_id,
6797: p_ovn => l_detail_ovn,
6798: p_parent_id => p_day_id_info_table (l_index_day).day_id,
6838: ELSE
6839: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
6840: END IF;
6841:
6842: hxc_timekeeper_utilities.add_dff_attribute (
6843: p_attribute => p_attributes,
6844: p_attribute_id => l_attribute_index,
6845: p_tbb_id => l_detail_id,
6846: p_tbb_ovn => l_detail_ovn,
6915: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
6916: END IF;
6917:
6918:
6919: hxc_timekeeper_utilities.add_dff_attribute (
6920: p_attribute => p_attributes,
6921: p_attribute_id => l_attribute_index,
6922: p_tbb_id => l_detail_id,
6923: p_tbb_ovn => l_detail_ovn,
6982: IF l_detail_time_in > l_detail_time_out THEN
6983: l_detail_time_out := l_detail_time_out + 1;
6984: END IF;
6985:
6986: hxc_timekeeper_utilities.add_block (
6987: p_timecard => p_timecard,
6988: p_timecard_id => l_detail_id,
6989: p_ovn => l_detail_ovn,
6990: p_parent_id => p_day_id_info_table (l_index_day).day_id,
7004: p_timecard_index_info => p_timecard_index_info
7005: );
7006:
7007: FOR l_index_attribute IN 1 .. 20 LOOP
7008: hxc_timekeeper_utilities.manage_attributes (
7009: p_attribute_number => l_index_attribute,
7010: p_insert_data_details => p_insert_detail,
7011: p_old_value => l_old_attribute_value,
7012: p_new_value => l_new_attribute_value
7013: );
7014:
7015: IF l_new_attribute_value IS NOT NULL AND p_att_tab.EXISTS (l_index_attribute) THEN --2786991
7016:
7017: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
7018: hxc_timekeeper_utilities.add_attribute (
7019: p_attribute => p_attributes,
7020: p_attribute_id => g_negative_index,
7021: p_tbb_id => l_detail_id,
7014:
7015: IF l_new_attribute_value IS NOT NULL AND p_att_tab.EXISTS (l_index_attribute) THEN --2786991
7016:
7017: hxc_timekeeper_process.g_negative_index := hxc_timekeeper_process.g_negative_index - 1;
7018: hxc_timekeeper_utilities.add_attribute (
7019: p_attribute => p_attributes,
7020: p_attribute_id => g_negative_index,
7021: p_tbb_id => l_detail_id,
7022: p_tbb_ovn => l_detail_ovn,
7042: l_attribute_index := g_negative_index;
7043: if g_debug then
7044: hr_utility.trace(l_attribute_index);
7045: end if;
7046: hxc_timekeeper_utilities.add_dff_attribute (
7047: p_attribute => p_attributes,
7048: p_attribute_id => g_negative_index,
7049: p_tbb_id => l_detail_id,
7050: p_tbb_ovn => l_detail_ovn,
7092: end if;
7093: g_negative_index := g_negative_index - 1;
7094: l_attribute_index := g_negative_index;
7095:
7096: hxc_timekeeper_utilities.add_dff_attribute (
7097: p_attribute => p_attributes,
7098: p_attribute_id => g_negative_index,
7099: p_tbb_id => l_detail_id,
7100: p_tbb_ovn => l_detail_ovn,
7138:
7139: ELSIF (l_measure IS NULL OR (l_detail_time_in IS NULL AND l_detail_time_out IS NULL))
7140: AND (l_detail_id IS NOT NULL AND l_detail_id > 0) THEN
7141: -- terminate the block the detail information with the new measure
7142: hxc_timekeeper_utilities.add_block (
7143: p_timecard => p_timecard,
7144: p_timecard_id => l_detail_id,
7145: p_ovn => l_detail_ovn,
7146: p_parent_id => p_day_id_info_table (l_index_day).day_id,
7182: ELSE
7183: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
7184: END IF;
7185:
7186: hxc_timekeeper_utilities.add_dff_attribute (
7187: p_attribute => p_attributes,
7188: p_attribute_id => l_attribute_index,
7189: p_tbb_id => l_detail_id,
7190: p_tbb_ovn => l_detail_ovn,
7230:
7231: ELSIF l_action = 'DELETE' THEN
7232: IF l_detail_id IS NOT NULL AND l_detail_id > 0 THEN
7233: -- terminate the block
7234: hxc_timekeeper_utilities.add_block (
7235: p_timecard => p_timecard,
7236: p_timecard_id => l_detail_id,
7237: p_ovn => l_detail_ovn,
7238: p_parent_id => p_day_id_info_table (l_index_day).day_id,
7274: ELSE
7275: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
7276: END IF;
7277:
7278: hxc_timekeeper_utilities.add_dff_attribute (
7279: p_attribute => p_attributes,
7280: p_attribute_id => l_attribute_index,
7281: p_tbb_id => l_detail_id,
7282: p_tbb_ovn => l_detail_ovn,