[Home] [Help]
PACKAGE: APPS.HXC_TIMECARD_DEPOSIT_COMMON
Source
1 PACKAGE hxc_timecard_deposit_common AUTHID CURRENT_USER AS
2 /* $Header: hxctcdpcommon.pkh 115.0 2003/04/23 18:59:51 jdupont noship $ */
3
4
5 c_yes CONSTANT VARCHAR2(1) := 'Y';
6 c_no CONSTANT VARCHAR2(2) := 'N';
7 c_submit CONSTANT VARCHAR2(6) := 'SUBMIT';
8 c_save CONSTANT VARCHAR2(4) := 'SAVE';
9 c_audit CONSTANT VARCHAR2(5) := 'AUDIT';
10 c_delete CONSTANT VARCHAR2(6) := 'DELETE';
11 c_error CONSTANT VARCHAR2(5) := 'ERROR';
12 c_confirmation CONSTANT VARCHAR2(12) := 'CONFIRMATION';
13 c_information CONSTANT VARCHAR2(11) := 'INFORMATION';
14 c_warning CONSTANT VARCHAR2(7) := 'WARNING';
15 c_exception CONSTANT VARCHAR2(9) := 'EXCEPTION';
16 c_hxc CONSTANT VARCHAR2(3) := 'HXC';
17 c_timecard_scope CONSTANT VARCHAR2(8) := 'TIMECARD';
18 c_template_scope CONSTANT VARCHAR2(17):= 'TIMECARD_TEMPLATE';
19 c_day_scope CONSTANT VARCHAR2(3) := 'DAY';
20 c_detail_scope CONSTANT VARCHAR2(6) := 'DETAIL';
21 c_process CONSTANT VARCHAR2(1) := 'Y';
22 c_trans_error CONSTANT VARCHAR2(6) := 'ERRORS';
23 c_trans_success CONSTANT VARCHAR2(7) := 'SUCCESS';
24 c_template_attribute CONSTANT VARCHAR2(9) := 'TEMPLATES';
25 c_layout_attribute CONSTANT VARCHAR2(6) := 'LAYOUT';
26 c_reason_attribute CONSTANT VARCHAR2(6) := 'REASON';
27 c_alias_context_prefix CONSTANT VARCHAR2(5) := 'ALIAS';
28 c_person_resource CONSTANT VARCHAR2(6) := 'PERSON';
29 c_assignment_resource CONSTANT VARCHAR2(10) := 'ASSIGNMENT';
30 c_measure_type CONSTANT VARCHAR2(7) := 'MEASURE';
31 c_range_type CONSTANT VARCHAR2(5) := 'RANGE';
32 c_working_status CONSTANT VARCHAR2(7) := 'WORKING';
33 c_submitted_status CONSTANT VARCHAR2(9) := 'SUBMITTED';
34 c_approved_status CONSTANT VARCHAR2(8) := 'APPROVED';
35 c_rejected_status CONSTANT VARCHAR2(8) := 'REJECTED';
36 c_public_template CONSTANT VARCHAR2(8) := 'PUBLIC';
37 c_private_template CONSTANT VARCHAR2(8) := 'PRIVATE';
38 c_hxcempitemtype CONSTANT VARCHAR2(8) := 'HXCEMP';
39 c_hxcapprovalprocess CONSTANT VARCHAR2(12) := 'HXC_APPROVAL';
40
41
42 Procedure alias_translation
43 (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
44 ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
45 ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
46 );
47 /*
48 Procedure validate_setup
49 (p_deposit_mode in varchar2
50 ,p_blocks in out nocopy hxc_block_table_type
51 ,p_attributes in out nocopy hxc_attribute_table_type
52 ,p_messages in out nocopy hxc_message_table_type
53 ) ;
54 */
55
56 Function load_blocks
57 (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
58 ,p_timecard_ovn in out nocopy hxc_time_building_blocks.object_version_number%type
59 ) return hxc_block_table_type;
60
61 Function load_attributes
62 (p_blocks in out nocopy hxc_block_table_type)
63 return hxc_attribute_table_type;
64
65 Procedure delete_timecard
66 (p_mode in varchar2
67 ,p_template in varchar2
68 ,p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
69 );
70
71 END hxc_timecard_deposit_common;