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_TIMECARD_SUMMARY_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 7: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

3:
4: g_check_for_reasons varchar2(1) := null;
5:
6: function get_migration_apr_status
7: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
8: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
9: ) return varchar2 is
10:
11: begin

Line 8: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

4: g_check_for_reasons varchar2(1) := null;
5:
6: function get_migration_apr_status
7: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
8: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
9: ) return varchar2 is
10:
11: begin
12:

Line 18: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

14:
15: end get_migration_apr_status;
16:
17: procedure get_recorded_hours
18: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
19: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
20: ,p_hours out nocopy number
21: ,p_details out nocopy details
22: ) is

Line 19: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

15: end get_migration_apr_status;
16:
17: procedure get_recorded_hours
18: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
19: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
20: ,p_hours out nocopy number
21: ,p_details out nocopy details
22: ) is
23:

Line 24: cursor c_detail_info(p_id in hxc_time_building_blocks.time_building_block_id%type

20: ,p_hours out nocopy number
21: ,p_details out nocopy details
22: ) is
23:
24: cursor c_detail_info(p_id in hxc_time_building_blocks.time_building_block_id%type
25: ,p_ovn in hxc_time_building_blocks.object_version_number%type
26: ) is
27: select details.time_building_block_id
28: ,details.object_version_number

Line 25: ,p_ovn in hxc_time_building_blocks.object_version_number%type

21: ,p_details out nocopy details
22: ) is
23:
24: cursor c_detail_info(p_id in hxc_time_building_blocks.time_building_block_id%type
25: ,p_ovn in hxc_time_building_blocks.object_version_number%type
26: ) is
27: select details.time_building_block_id
28: ,details.object_version_number
29: ,details.start_time

Line 34: from hxc_time_building_blocks days, hxc_time_building_blocks details

30: ,details.stop_time
31: ,details.measure
32: ,details.type
33: ,details.creation_date
34: from hxc_time_building_blocks days, hxc_time_building_blocks details
35: where days.parent_building_block_id = p_id
36: and days.parent_building_block_ovn = p_ovn
37: and details.parent_building_block_id = days.time_building_block_id
38: and details.parent_building_block_ovn = days.object_version_number

Line 43: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,

39: and days.date_to = hr_general.end_of_time
40: and details.date_to = hr_general.end_of_time;
41:
42: CURSOR c_tc_resource_id(
43: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
44: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
45: ) IS
46: SELECT tbb.resource_id
47: FROM hxc_time_building_blocks tbb

Line 44: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

40: and details.date_to = hr_general.end_of_time;
41:
42: CURSOR c_tc_resource_id(
43: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
44: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
45: ) IS
46: SELECT tbb.resource_id
47: FROM hxc_time_building_blocks tbb
48: WHERE tbb.time_building_block_id = p_timecard_id

Line 47: FROM hxc_time_building_blocks tbb

43: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
44: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
45: ) IS
46: SELECT tbb.resource_id
47: FROM hxc_time_building_blocks tbb
48: WHERE tbb.time_building_block_id = p_timecard_id
49: AND tbb.object_version_number = p_timecard_ovn;
50:
51: /* Bug fix for 5526281 */

Line 52: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,

48: WHERE tbb.time_building_block_id = p_timecard_id
49: AND tbb.object_version_number = p_timecard_ovn;
50:
51: /* Bug fix for 5526281 */
52: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
53: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
54: ) IS
55: SELECT tbb.start_time,tbb.stop_time
56: FROM hxc_time_building_blocks tbb

Line 53: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

49: AND tbb.object_version_number = p_timecard_ovn;
50:
51: /* Bug fix for 5526281 */
52: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
53: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
54: ) IS
55: SELECT tbb.start_time,tbb.stop_time
56: FROM hxc_time_building_blocks tbb
57: WHERE tbb.time_building_block_id = p_timecard_id

Line 56: FROM hxc_time_building_blocks tbb

52: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
53: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
54: ) IS
55: SELECT tbb.start_time,tbb.stop_time
56: FROM hxc_time_building_blocks tbb
57: WHERE tbb.time_building_block_id = p_timecard_id
58: AND tbb.object_version_number = p_timecard_ovn;
59:
60: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

Line 60: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

56: FROM hxc_time_building_blocks tbb
57: WHERE tbb.time_building_block_id = p_timecard_id
58: AND tbb.object_version_number = p_timecard_ovn;
59:
60: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
61: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
62: /* end of bug fix for 5526281 */
63:
64: l_index number :=1;

Line 155: (p_id in hxc_time_building_blocks.time_building_block_id%type

151:
152: function get_has_reasons(p_details in details) return varchar2 is
153:
154: cursor c_reasons
155: (p_id in hxc_time_building_blocks.time_building_block_id%type
156: ) is
157: select 'Y'
158: from hxc_time_attribute_usages tau, hxc_time_attributes ta
159: where tau.time_building_block_id = p_id

Line 209: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

205: return l_submission_date;
206:
207: end get_submission_date;
208:
209: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
210: ,p_mode in varchar2 default 'NORMAL'
211: ,p_attribute_category in varchar2 default null
212: ,p_attribute1 in varchar2 default null
213: ,p_attribute2 in varchar2 default null

Line 250: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is

246: ,p_tk_audit_process_name in varchar2
247: ,p_tk_audit_item_key in varchar2
248: ) is
249:
250: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
251: select resource_id
252: ,start_time
253: ,stop_time
254: ,object_version_number

Line 258: from hxc_time_building_blocks

254: ,object_version_number
255: ,approval_status
256: ,creation_date
257: ,data_set_id
258: from hxc_time_building_blocks
259: where time_building_block_id = p_id
260: and date_to = hr_general.end_of_time
261: and scope = 'TIMECARD';
262:

Line 268: l_approval_status hxc_time_building_blocks.approval_status%type;

264: select 'Y'
265: from hxc_time_attributes
266: where attribute_category = hxc_timecard.c_reason_attribute;
267:
268: l_approval_status hxc_time_building_blocks.approval_status%type;
269: l_resource_id hxc_time_building_blocks.resource_id%type;
270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;

Line 269: l_resource_id hxc_time_building_blocks.resource_id%type;

265: from hxc_time_attributes
266: where attribute_category = hxc_timecard.c_reason_attribute;
267:
268: l_approval_status hxc_time_building_blocks.approval_status%type;
269: l_resource_id hxc_time_building_blocks.resource_id%type;
270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;

Line 270: l_start_time hxc_time_building_blocks.start_time%type;

266: where attribute_category = hxc_timecard.c_reason_attribute;
267:
268: l_approval_status hxc_time_building_blocks.approval_status%type;
269: l_resource_id hxc_time_building_blocks.resource_id%type;
270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;
274: l_ovn hxc_time_building_blocks.object_version_number%type;

Line 271: l_stop_time hxc_time_building_blocks.stop_time%type;

267:
268: l_approval_status hxc_time_building_blocks.approval_status%type;
269: l_resource_id hxc_time_building_blocks.resource_id%type;
270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;
274: l_ovn hxc_time_building_blocks.object_version_number%type;
275: l_has_reasons varchar2(1);

Line 272: l_submission_date hxc_time_building_blocks.creation_date%type;

268: l_approval_status hxc_time_building_blocks.approval_status%type;
269: l_resource_id hxc_time_building_blocks.resource_id%type;
270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;
274: l_ovn hxc_time_building_blocks.object_version_number%type;
275: l_has_reasons varchar2(1);
276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;

Line 273: l_creation_date hxc_time_building_blocks.creation_date%type;

269: l_resource_id hxc_time_building_blocks.resource_id%type;
270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;
274: l_ovn hxc_time_building_blocks.object_version_number%type;
275: l_has_reasons varchar2(1);
276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
277: l_details details;

Line 274: l_ovn hxc_time_building_blocks.object_version_number%type;

270: l_start_time hxc_time_building_blocks.start_time%type;
271: l_stop_time hxc_time_building_blocks.stop_time%type;
272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;
274: l_ovn hxc_time_building_blocks.object_version_number%type;
275: l_has_reasons varchar2(1);
276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
277: l_details details;
278: l_data_set_id hxc_time_building_blocks.data_set_id%type;

Line 278: l_data_set_id hxc_time_building_blocks.data_set_id%type;

274: l_ovn hxc_time_building_blocks.object_version_number%type;
275: l_has_reasons varchar2(1);
276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
277: l_details details;
278: l_data_set_id hxc_time_building_blocks.data_set_id%type;
279:
280: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
281: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
282: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;

Line 471: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

467: end if;
468:
469: End insert_summary_row;
470:
471: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
472: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
473: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
474: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
475: ) is

Line 524: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

520:
521:
522: End update_summary_row;
523:
524: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
525:
526: Begin
527:
528: delete from hxc_timecard_summary where timecard_id = p_timecard_id;

Line 537: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

533: FND_MESSAGE.raise_error;
534:
535: End delete_summary_row;
536:
537: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
538:
539: Begin
540:
541: update hxc_timecard_summary

Line 547: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

543: where timecard_id = p_timecard_id;
544:
545: End reject_timecard;
546:
547: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
548:
549: Begin
550:
551: update hxc_timecard_summary

Line 557: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

553: where timecard_id = p_timecard_id;
554:
555: End approve_timecard;
556:
557: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
558:
559: Begin
560:
561: update hxc_timecard_summary