[Home] [Help]
PACKAGE: APPS.HXC_TIMECARD
Source
1 PACKAGE hxc_timecard AUTHID CURRENT_USER AS
2 /* $Header: hxctimecard.pkh 120.6 2008/03/14 11:13:08 bbayragi noship $ */
3
4 Type block_list is table of number index by binary_integer;
5
6 Type transaction_record is record
7 (transaction_detail_id hxc_transaction_details.transaction_detail_id%type
8 ,time_building_block_id hxc_time_building_blocks.time_building_block_id%type
9 ,object_version_number hxc_time_building_blocks.object_version_number%type
10 ,data_set_id hxc_time_building_blocks.data_set_id%type
11 ,status hxc_transaction_details.status%TYPE
12 ,exception_desc hxc_transaction_details.exception_description%TYPE
13 );
14
15 Type transaction_info is table of transaction_record index by binary_integer;
16
17 c_yes CONSTANT VARCHAR2(1) := 'Y';
18 c_no CONSTANT VARCHAR2(2) := 'N';
19 c_submit CONSTANT VARCHAR2(6) := 'SUBMIT';
20 c_save CONSTANT VARCHAR2(4) := 'SAVE';
21 c_audit CONSTANT VARCHAR2(5) := 'AUDIT';
22 c_delete CONSTANT VARCHAR2(6) := 'DELETE';
23 c_error CONSTANT VARCHAR2(5) := 'ERROR';
24 c_confirmation CONSTANT VARCHAR2(12):= 'CONFIRMATION';
25 c_information CONSTANT VARCHAR2(11):= 'INFORMATION';
26 c_warning CONSTANT VARCHAR2(7) := 'WARNING';
27 c_exception CONSTANT VARCHAR2(9) := 'EXCEPTION';
28 c_business_message CONSTANT VARCHAR2(16):= 'BUSINESS_MESSAGE';
29 c_pte CONSTANT VARCHAR2(3) := 'PTE';
30 c_hxc CONSTANT VARCHAR2(3) := 'HXC';
31 c_timecard_scope CONSTANT VARCHAR2(8) := 'TIMECARD';
32 c_template_scope CONSTANT VARCHAR2(17):= 'TIMECARD_TEMPLATE';
33 c_day_scope CONSTANT VARCHAR2(3) := 'DAY';
34 c_detail_scope CONSTANT VARCHAR2(6) := 'DETAIL';
35 c_process CONSTANT VARCHAR2(1) := 'Y';
36 c_trans_error CONSTANT VARCHAR2(6) := 'ERRORS';
37 c_trans_success CONSTANT VARCHAR2(7) := 'SUCCESS';
38 c_template_attribute CONSTANT VARCHAR2(9) := 'TEMPLATES';
39 c_layout_attribute CONSTANT VARCHAR2(6) := 'LAYOUT';
40 c_reason_attribute CONSTANT VARCHAR2(6) := 'REASON';
41 c_security_attribute CONSTANT VARCHAR2(8) := 'SECURITY';
42 c_alias_context_prefix CONSTANT VARCHAR2(5) := 'ALIAS';
43 c_person_resource CONSTANT VARCHAR2(6) := 'PERSON';
44 c_assignment_resource CONSTANT VARCHAR2(10):= 'ASSIGNMENT';
45 c_measure_type CONSTANT VARCHAR2(7) := 'MEASURE';
46 c_range_type CONSTANT VARCHAR2(5) := 'RANGE';
47 c_working_status CONSTANT VARCHAR2(7) := 'WORKING';
48 c_submitted_status CONSTANT VARCHAR2(9) := 'SUBMITTED';
49 c_approved_status CONSTANT VARCHAR2(8) := 'APPROVED';
50 c_rejected_status CONSTANT VARCHAR2(8) := 'REJECTED';
51 c_nondelete CONSTANT VARCHAR2(9) := 'NONDELETE';
52 c_blk_extent CONSTANT VARCHAR2(3) := 'BLK'; --Bug#2873563
53 c_blk_children_extent CONSTANT VARCHAR2(16):= 'BLK_AND_CHILDREN'; --Bug#2873563
54 c_hxcempitemtype CONSTANT VARCHAR2(6) := 'HXCEMP';
55 c_hxcapprovalprocess CONSTANT VARCHAR2(12):= 'HXC_APPROVAL';
56 c_hxcnotifyprocess CONSTANT VARCHAR2(16):= 'HXC_APPLY_NOTIFY';
57 c_public_template CONSTANT VARCHAR2(6) := 'PUBLIC';
58 c_private_template CONSTANT VARCHAR2(7) := 'PRIVATE';
59
60 -- New constants added for period choice lists
61 c_more_period_indicator CONSTANT VARCHAR2(1) := '#';
62 c_existing_period_indicator CONSTANT VARCHAR2(1) := '~';
63 c_archived_period_indicator CONSTANT VARCHAR2(1) := '!';
64
65 Procedure create_timecard
66 (p_validate in varchar2
67 ,p_blocks in hxc_block_table_type
68 ,p_attributes in hxc_attribute_table_type
69 ,p_deposit_mode in varchar2
70 ,p_template in varchar2
71 ,p_item_type in wf_items.item_type%type
72 ,p_approval_prc in wf_process_activities.process_name%type
73 ,p_lock_rowid in rowid
74 ,p_cla_save in varchar2 default 'NO'
75 ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
76 ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
77 ,p_messages out nocopy hxc_message_table_type
78 );
79
80 Function load_blocks
81 (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
82 ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
83 ,p_load_mode in varchar2 default c_nondelete
84 ) return hxc_block_table_type;
85
86 Function load_attributes
87 (p_blocks in hxc_block_table_type)
88 return hxc_attribute_table_type;
89
90 Procedure delete_timecard
91 (p_mode in varchar2
92 ,p_template in varchar2
93 ,p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
94 ,p_timecard_ok in out nocopy varchar2
95 );
96
97 -- Added for DA Enhancement
98 Procedure delete_null_entries
99 (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
100 ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
101 );
102
103
104 END HXC_TIMECARD;