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;