[Home] [Help]
PACKAGE: APPS.HXC_TIMECARD_SUMMARY_PKG
Source
1 package hxc_timecard_summary_pkg AUTHID CURRENT_USER as
2 /* $Header: hxctcsum.pkh 120.1 2010/05/26 08:07:59 asrajago ship $ */
3
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
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
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
27 ,p_attribute3 in varchar2 default null
28 ,p_attribute4 in varchar2 default null
29 ,p_attribute5 in varchar2 default null
30 ,p_attribute6 in varchar2 default null
31 ,p_attribute7 in varchar2 default null
32 ,p_attribute8 in varchar2 default null
33 ,p_attribute9 in varchar2 default null
34 ,p_attribute10 in varchar2 default null
35 ,p_attribute11 in varchar2 default null
36 ,p_attribute12 in varchar2 default null
37 ,p_attribute13 in varchar2 default null
38 ,p_attribute14 in varchar2 default null
39 ,p_attribute15 in varchar2 default null
40 ,p_attribute16 in varchar2 default null
41 ,p_attribute17 in varchar2 default null
42 ,p_attribute18 in varchar2 default null
43 ,p_attribute19 in varchar2 default null
44 ,p_attribute20 in varchar2 default null
45 ,p_attribute21 in varchar2 default null
46 ,p_attribute22 in varchar2 default null
47 ,p_attribute23 in varchar2 default null
48 ,p_attribute24 in varchar2 default null
49 ,p_attribute25 in varchar2 default null
50 ,p_attribute26 in varchar2 default null
51 ,p_attribute27 in varchar2 default null
52 ,p_attribute28 in varchar2 default null
53 ,p_attribute29 in varchar2 default null
54 ,p_attribute30 in varchar2 default null
55 ,p_approval_item_type in varchar2
56 ,p_approval_process_name in varchar2
57 ,p_approval_item_key in varchar2
58 ,p_tk_audit_item_type in varchar2
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 );
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);
76
77
78 -- Bug 9747820
79 -- Added the following data types and procedure to process Transferred_to column
80 -- Procedure is called from Generic Retrieval
81
82 TYPE VARCHARTABLE IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
83
84 g_recipient_name VARCHARTABLE;
85
86 PROCEDURE update_transferred_to( p_timecard_id IN NUMBER,
87 p_timecard_ovn IN NUMBER,
88 p_process_id IN NUMBER );
89
90
91 end hxc_timecard_summary_pkg;