[Home] [Help]
377: /*ADVICE(451): NUMBER has no precision [315] */
378: := 0;
379: tc_start DATE;
380: tc_end DATE;
381: emp_qry_tc_info hxc_timekeeper_utilities.emptctab;
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;
777: l_emp_edits := NULL;
778: l_audit_enabled := NULL;
779:
780: BEGIN
781: hxc_timekeeper_utilities.get_emp_pref (
782: resource_info.person_id,
783: l_emp_negpref,
784: l_emp_recpref,
785: l_emp_appstyle,
835:
836: emp_qry_tc_info.DELETE;
837: --populate emp_qry_tc_info table with saved timecards in that period
838:
839: hxc_timekeeper_utilities.populate_query_tc_tab (
840: resource_info.person_id,
841: p_start_period,
842: p_end_period,
843: emp_qry_tc_info
1055:
1056: -- Get the data actually stored in the database.
1057:
1058:
1059: hxc_timekeeper_utilities.create_attribute_structure (
1060: p_timecard_id => l_timecard_id,
1061: p_timecard_ovn => l_timecard_ovn,
1062: p_resource_id => resource_info.person_id,
1063: p_start_period => tc_start,
2084:
2085: l_found_hours_type := FALSE;
2086:
2087: --IF g_debbug THEN
2088: --hxc_timekeeper_utilities.dump_buffer_table(l_buffer_info);
2089: --END IF;
2090: if g_debug then
2091: hr_utility.trace ('101 -- Normal Query procedure ');
2092: end if;
3306:
3307: if l_row_lock_id is not null then
3308:
3309:
3310: l_pref_date:= hxc_timekeeper_utilities.get_pref_eval_date( p_resource_id => resource_info.person_id,
3311: p_tc_start_date => p_start_period,
3312: p_tc_end_date => p_end_period );
3313:
3314:
3372: hr_utility.trace('p_tc_start = '|| p_start_period);
3373: hr_utility.trace('p_tc_end = '|| p_end_period);
3374: end if;
3375:
3376: hxc_timekeeper_utilities.PRE_POPULATE_ABSENCE_DETAILS
3377: (p_timekeeper_id => p_timekeeper_id ,
3378: p_start_period => l_abs_tc_start ,
3379: p_end_period => l_abs_tc_end + g_one_day ,
3380: p_tc_start => p_start_period,
3811: -- Change End
3812:
3813: -- Checking for notification excpetion
3814: -- Then we need to leap frog this employee
3815: if hxc_timekeeper_utilities.g_exception_detected = 'Y' then
3816: hxc_timekeeper_utilities.g_exception_detected:= 'N';
3817: raise l_abs_pending_appr_notif;
3818: end if;
3819:
3812:
3813: -- Checking for notification excpetion
3814: -- Then we need to leap frog this employee
3815: if hxc_timekeeper_utilities.g_exception_detected = 'Y' then
3816: hxc_timekeeper_utilities.g_exception_detected:= 'N';
3817: raise l_abs_pending_appr_notif;
3818: end if;
3819:
3820: if l_row_lock_id is null
3884: g_query_exception_tab(resource_info.person_id).Employee_full_name:=
3885: resource_info.full_name;
3886: g_query_exception_tab(resource_info.person_id).employee_number:=
3887: resource_info.employee_number;
3888: if hxc_timekeeper_utilities.g_abs_message_string =
3889: 'HXC_ABS_PEND_APPR_DELETE' then
3890: g_query_exception_tab(resource_info.person_id).Message:=
3891: 'HXC_TK_ABS_PEND_APPR_DELETE';
3892: elsif hxc_timekeeper_utilities.g_abs_message_string =
3888: if hxc_timekeeper_utilities.g_abs_message_string =
3889: 'HXC_ABS_PEND_APPR_DELETE' then
3890: g_query_exception_tab(resource_info.person_id).Message:=
3891: 'HXC_TK_ABS_PEND_APPR_DELETE';
3892: elsif hxc_timekeeper_utilities.g_abs_message_string =
3893: 'HXC_ABS_PEND_APPR_ERROR' then
3894: g_query_exception_tab(resource_info.person_id).Message:=
3895: 'HXC_TK_ABS_PEND_APPR_ERROR';
3896: end if;
5224: /*ADVICE(3652): Initialization to NULL is superfluous [417] */
5225:
5226: att_seg_tab hxc_alias_utility.t_alias_att_info;
5227: spemp_tc_list hxc_timecard_utilities.periods;
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;
5327: no usage of the same detail id is ensured.
5328:
5329: */
5330: -- Change start
5331: hxc_timekeeper_utilities.populate_prepop_detail_id_info
5332: (p_timekeeper_data_rec => g_timekeeper_data(l_tk_table_index),
5333: p_tk_prepop_detail_id_tab => g_tk_prepop_detail_id_tab);
5334: -- Change end
5335:
5378: EXIT WHEN (NOT l_resource_tc_table.EXISTS (l_resource_id));
5379: -- empty the timecard and attribute table
5380:
5381: -- get the timecards which fit between the range selected.
5382: hxc_timekeeper_utilities.populate_tc_tab (l_resource_id, p_start_period, p_end_period, spemp_tc_info);
5383: -- Remove the timecards which totally dosnt fit in the period
5384: /* changes done by senthil for emp terminate enhancement*/
5385: /*Changed By Mithun for CWK Terminate Bug*/
5386: OPEN c_emp_terminateinfo (p_resource_id => l_resource_id);
5392: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
5393: close c_tc_in_term_period_exists;
5394: end if;
5395: if l_tc_in_term_status <> 'Y' then
5396: hxc_timekeeper_utilities.split_timecard (
5397: l_resource_id,
5398: p_start_period,
5399: p_end_period,
5400: spemp_tc_info,
6079:
6080: g_tk_finish_process := TRUE;
6081: --END IF;
6082:
6083: hxc_timekeeper_utilities.convert_type_to_message_table (l_messages, p_messages);
6084: /* bug fix for 5229954 */
6085: hxc_timekeeper_utilities.populate_detail_temp(1);
6086: /* end of fix for 5229954 */
6087: COMMIT;
6081: --END IF;
6082:
6083: hxc_timekeeper_utilities.convert_type_to_message_table (l_messages, p_messages);
6084: /* bug fix for 5229954 */
6085: hxc_timekeeper_utilities.populate_detail_temp(1);
6086: /* end of fix for 5229954 */
6087: COMMIT;
6088: END;
6089:
6371: l_empnumber VARCHAR2 (30);
6372: l_empname VARCHAR2 (240);
6373: l_enddate DATE;
6374: spemp_tc_list hxc_timecard_utilities.periods;
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;
6429:
6430: mo_global.init('HXC');
6431: mo_global.set_policy_context ( 'S', l_operating_unit_id );
6432: End;
6433: hxc_timekeeper_utilities.populate_tc_tab (
6434: c_resource.resource_id,
6435: fnd_date.canonical_to_date (p_start_period),
6436: fnd_date.canonical_to_date (p_end_period),
6437: spemp_tc_info
6446: FETCH c_tc_in_term_period_exists into l_tc_in_term_status;
6447: close c_tc_in_term_period_exists;
6448: end if;
6449: if l_tc_in_term_status <> 'Y' then
6450: hxc_timekeeper_utilities.split_timecard (
6451: c_resource.resource_id,
6452: fnd_date.canonical_to_date (p_start_period),
6453: fnd_date.canonical_to_date (p_end_period),
6454: spemp_tc_info,
6868: l_audit_enabled := NULL;
6869:
6870: -- let's get the resource preference
6871: -- we need to reset the approval style all the time.
6872: hxc_timekeeper_utilities.get_emp_pref (
6873: p_resource_id => p_resource_id,
6874: neg_pref => l_emp_negpref,
6875: recpref => l_emp_recpref,
6876: appstyle => l_emp_appstyle,
6965: if g_debug then
6966: hr_utility.trace('g_negative_index = '||g_negative_index);
6967: end if;
6968: --
6969: hxc_timekeeper_utilities.add_attribute (
6970: p_attribute => p_attributes,
6971: p_attribute_id => g_negative_index,
6972: p_tbb_id => l_timecard_id,
6973: p_tbb_ovn => l_timecard_ovn,
6998: hxc_timecard_search_pkg.get_timecard_status_code (l_timecard_id, l_timecard_ovn);
6999: p_timecard_status := l_timecard_status;
7000: END IF;
7001:
7002: hxc_timekeeper_utilities.create_attribute_structure (
7003: p_timecard_id => l_timecard_id,
7004: p_timecard_ovn => l_timecard_ovn,
7005: p_resource_id => p_resource_id,
7006: p_start_period => p_start_period,
7023: if g_debug then
7024: hr_utility.trace('before add_block for TIMECARD');
7025: end if;
7026:
7027: hxc_timekeeper_utilities.add_block (
7028: p_timecard => p_timecard,
7029: p_timecard_id => l_timecard_id,
7030: p_ovn => l_timecard_ovn,
7031: p_parent_id => NULL,
7134: else
7135: l_day_changed:='Y';
7136: end if;
7137: /* end of fix for 5398047 */
7138: hxc_timekeeper_utilities.add_block (
7139: p_timecard => p_timecard,
7140: p_timecard_id => l_day_id,
7141: p_ovn => l_day_ovn,
7142: p_parent_id => l_timecard_id,
7159: -- add the detail now
7160: IF l_day_id > 0 THEN
7161: FOR detail_info IN c_detail_info (p_resource_id, l_day_id, l_day_ovn) LOOP
7162: -- add the detail
7163: hxc_timekeeper_utilities.add_block (
7164: p_timecard => p_timecard,
7165: p_timecard_id => detail_info.detail_id,
7166: p_ovn => detail_info.detail_ovn,
7167: p_parent_id => l_day_id,
7500: -- end 2789497
7501:
7502: -- get the attribute category as base for Details
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
7628: l_detail_old_att_30 := NULL;
7629:
7630: -- find the detail information for the current day
7631:
7632: hxc_timekeeper_utilities.manage_timeinfo (
7633: p_day_counter => (l_add_index_day + l_index_day),
7634: p_insert_detail => p_insert_detail,
7635: p_measure => l_measure,
7636: p_detail_id => l_detail_id,
8042: IF l_detail_time_in > l_detail_time_out THEN
8043: l_detail_time_out := l_detail_time_out + 1;
8044: END IF;
8045:
8046: hxc_timekeeper_utilities.add_block (
8047: p_timecard => p_timecard,
8048: p_timecard_id => l_detail_id,
8049: p_ovn => l_detail_ovn,
8050: p_parent_id => p_day_id_info_table (l_index_day).day_id,
8067: -- add the attribute information.
8068:
8069: FOR l_index_attribute IN 1 .. 20 LOOP
8070:
8071: hxc_timekeeper_utilities.manage_attributes (
8072: p_attribute_number => l_index_attribute,
8073: p_insert_data_details => p_insert_detail,
8074: p_old_value => l_old_attribute_value,
8075: p_new_value => l_new_attribute_value
8101: EXIT WHEN l_found = 'Y';
8102: END LOOP;
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,
8151:
8152:
8153: l_attribute_index := g_negative_index;
8154:
8155: hxc_timekeeper_utilities.add_dff_attribute (
8156: p_attribute => p_attributes,
8157: p_attribute_id => g_negative_index,
8158: p_tbb_id => l_detail_id,
8159: p_tbb_ovn => l_detail_ovn,
8228: -- g_negative_index := g_negative_index;
8229: -- the above statement can be mutually exclusive..check out
8230:
8231: l_attribute_index := g_negative_index;
8232: hxc_timekeeper_utilities.add_dff_attribute (
8233: p_attribute => p_attributes,
8234: p_attribute_id => g_negative_index,
8235: p_tbb_id => l_detail_id,
8236: p_tbb_ovn => l_detail_ovn,
8294: -- work on the attribute information.
8295:
8296: FOR l_index_attribute IN 1 .. 20 LOOP
8297:
8298: hxc_timekeeper_utilities.manage_attributes (
8299: p_attribute_number => l_index_attribute,
8300: p_insert_data_details => p_insert_detail,
8301: p_old_value => l_old_attribute_value,
8302: p_new_value => l_new_attribute_value
8346: hr_utility.trace('l_detail_changed1 '||l_detail_changed);
8347: end if;
8348: END IF;
8349:
8350: hxc_timekeeper_utilities.add_attribute (
8351: p_attribute => p_attributes,
8352: p_attribute_id => g_negative_index,
8353: p_tbb_id => l_detail_id,
8354: p_tbb_ovn => l_detail_ovn,
8380: hr_utility.trace('l_detail_changed 3'||l_detail_changed);
8381: end if;
8382:
8383:
8384: hxc_timekeeper_utilities.add_block (
8385: p_timecard => p_timecard,
8386: p_timecard_id => l_detail_id,
8387: p_ovn => l_detail_ovn,
8388: p_parent_id => p_day_id_info_table (l_index_day).day_id,
8450: ELSE
8451: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
8452: END IF;
8453:
8454: hxc_timekeeper_utilities.add_dff_attribute (
8455: p_attribute => p_attributes,
8456: p_attribute_id => l_attribute_index,
8457: p_tbb_id => l_detail_id,
8458: p_tbb_ovn => l_detail_ovn,
8549: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
8550: END IF;
8551:
8552:
8553: hxc_timekeeper_utilities.add_dff_attribute (
8554: p_attribute => p_attributes,
8555: p_attribute_id => l_attribute_index,
8556: p_tbb_id => l_detail_id,
8557: p_tbb_ovn => l_detail_ovn,
8669: if g_debug then
8670: hr_utility.trace('before add_block');
8671: end if;
8672:
8673: hxc_timekeeper_utilities.add_block (
8674: p_timecard => p_timecard,
8675: p_timecard_id => l_detail_id,
8676: p_ovn => l_detail_ovn,
8677: p_parent_id => p_day_id_info_table (l_index_day).day_id,
8695: hr_utility.trace('after add_block');
8696: end if;
8697:
8698: FOR l_index_attribute IN 1 .. 20 LOOP
8699: hxc_timekeeper_utilities.manage_attributes (
8700: p_attribute_number => l_index_attribute,
8701: p_insert_data_details => p_insert_detail,
8702: p_old_value => l_old_attribute_value,
8703: p_new_value => l_new_attribute_value
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,
8742: p_attribute_id => g_negative_index,
8743: p_tbb_id => l_detail_id,
8744: p_tbb_ovn => l_detail_ovn,
8790: l_attribute_index := g_negative_index;
8791: if g_debug then
8792: hr_utility.trace(l_attribute_index);
8793: end if;
8794: hxc_timekeeper_utilities.add_dff_attribute (
8795: p_attribute => p_attributes,
8796: p_attribute_id => g_negative_index,
8797: p_tbb_id => l_detail_id,
8798: p_tbb_ovn => l_detail_ovn,
8861: END LOOP;
8862:
8863: l_attribute_index := g_negative_index;
8864:
8865: hxc_timekeeper_utilities.add_dff_attribute (
8866: p_attribute => p_attributes,
8867: p_attribute_id => g_negative_index,
8868: p_tbb_id => l_detail_id,
8869: p_tbb_ovn => l_detail_ovn,
8912: if g_debug then
8913: hr_utility.trace('SVG - 3');
8914: end if;
8915:
8916: hxc_timekeeper_utilities.add_block (
8917: p_timecard => p_timecard,
8918: p_timecard_id => l_detail_id,
8919: p_ovn => l_detail_ovn,
8920: p_parent_id => p_day_id_info_table (l_index_day).day_id,
8977: ELSE
8978: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
8979: END IF;
8980:
8981: hxc_timekeeper_utilities.add_dff_attribute (
8982: p_attribute => p_attributes,
8983: p_attribute_id => l_attribute_index,
8984: p_tbb_id => l_detail_id,
8985: p_tbb_ovn => l_detail_ovn,
9031: hr_utility.trace('SVG - 5');
9032: end if;
9033:
9034:
9035: hxc_timekeeper_utilities.add_block (
9036: p_timecard => p_timecard,
9037: p_timecard_id => l_detail_id,
9038: p_ovn => l_detail_ovn,
9039: p_parent_id => p_day_id_info_table (l_index_day).day_id,
9096: ELSE
9097: l_attribute_index := p_attributes (l_attribute_index).time_attribute_id;
9098: END IF;
9099:
9100: hxc_timekeeper_utilities.add_dff_attribute (
9101: p_attribute => p_attributes,
9102: p_attribute_id => l_attribute_index,
9103: p_tbb_id => l_detail_id,
9104: p_tbb_ovn => l_detail_ovn,