APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 8: (time_building_block_id hxc_time_building_blocks.time_building_block_id%type

4: c_normal_mode CONSTANT VARCHAR2(6) := 'NORMAL';
5: c_migration_mode CONSTANT VARCHAR2(9) := 'MIGRATION';
6:
7: type detail is record
8: (time_building_block_id hxc_time_building_blocks.time_building_block_id%type
9: ,time_building_block_ovn hxc_time_building_blocks.object_version_number%type
10: ,creation_date hxc_time_building_blocks.creation_date%type
11: );
12:

Line 9: ,time_building_block_ovn hxc_time_building_blocks.object_version_number%type

5: c_migration_mode CONSTANT VARCHAR2(9) := 'MIGRATION';
6:
7: type detail is record
8: (time_building_block_id hxc_time_building_blocks.time_building_block_id%type
9: ,time_building_block_ovn hxc_time_building_blocks.object_version_number%type
10: ,creation_date hxc_time_building_blocks.creation_date%type
11: );
12:
13: type details is table of detail index by binary_integer;

Line 10: ,creation_date hxc_time_building_blocks.creation_date%type

6:
7: type detail is record
8: (time_building_block_id hxc_time_building_blocks.time_building_block_id%type
9: ,time_building_block_ovn hxc_time_building_blocks.object_version_number%type
10: ,creation_date hxc_time_building_blocks.creation_date%type
11: );
12:
13: type details is table of detail index by binary_integer;
14:

Line 16: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

12:
13: type details is table of detail index by binary_integer;
14:
15: procedure get_recorded_hours
16: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
17: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
18: ,p_hours out nocopy number
19: ,p_details out nocopy details
20: );

Line 17: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

13: type details is table of detail index by binary_integer;
14:
15: procedure get_recorded_hours
16: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
17: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
18: ,p_hours out nocopy number
19: ,p_details out nocopy details
20: );
21:

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

18: ,p_hours out nocopy number
19: ,p_details out nocopy details
20: );
21:
22: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
23: ,p_mode in varchar2 default 'NORMAL'
24: ,p_attribute_category in varchar2 default null
25: ,p_attribute1 in varchar2 default null
26: ,p_attribute2 in varchar2 default null

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

59: ,p_tk_audit_process_name in varchar2
60: ,p_tk_audit_item_key in varchar2
61: );
62:
63: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
64: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
65: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
66: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
67: );

Line 69: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);

65: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
66: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
67: );
68:
69: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
70:
71: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
72:
73: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);

Line 71: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);

67: );
68:
69: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
70:
71: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
72:
73: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
74:
75: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);

Line 73: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);

69: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
70:
71: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
72:
73: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
74:
75: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
76:
77:

Line 75: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);

71: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
72:
73: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
74:
75: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type);
76:
77:
78: -- Bug 9747820
79: -- Added the following data types and procedure to process Transferred_to column