[Home] [Help]
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;
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;
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,
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:
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;
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,
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,
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
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
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,
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
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
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,