1 PACKAGE hxt_hxc_retrieval_process AUTHID CURRENT_USER AS
2 /* $Header: hxthcrtp.pkh 120.4.12020000.1 2012/06/27 09:55:44 appldev ship $ */
3
4 --
5 g_full_name VARCHAR2(240);
6 g_messages hxc_self_service_time_deposit.message_table;
7 --
8 g_otm_messages hxc_self_service_time_deposit.message_table;
9
10 -- Bug 7557568
11 -- Added the following record type to process deleted details.
12 TYPE DETAIL_REC IS RECORD
13 ( detail_bb_id NUMBER,
14 detail_bb_ovn NUMBER,
15 parent_id NUMBER,
16 parent_ovn NUMBER,
17 type VARCHAR2(50),
18 measure NUMBER,
19 start_time DATE,
20 new VARCHAR2(10),
21 date_to DATE);
22
23 TYPE DETAIL_TAB IS TABLE OF DETAIL_REC INDEX BY VARCHAR2(30);
24
25 g_detail_tab DETAIL_TAB;
26
27 -- Bug 8486310
28 -- Added the following types and variables to store the alternate
29 -- name identifiers and alias defns respectively.
30 TYPE VARCHARTAB IS TABLE OF VARCHAR2(500) INDEX BY VARCHAR2(50);
31 g_an_id VARCHARTAB;
32 g_alias_id NUMBER;
33
34 PROCEDURE synchronize_deletes_in_otlr
35 (p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
36 ,p_time_att_info IN hxc_self_Service_time_deposit.app_attributes_info
37 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
38 ,p_timecard_source IN VARCHAR -- added for 5137310
39 );
40
41 PROCEDURE otm_validate_process
42 (p_operation IN VARCHAR2
43 ,p_time_building_blocks IN OUT NOCOPY VARCHAR2
44 ,p_time_attributes IN OUT NOCOPY VARCHAR2
45 ,p_messages IN OUT NOCOPY VARCHAR2);
46 --
47 PROCEDURE validate_timecard
48 (p_operation IN VARCHAR2
49 ,p_time_building_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
50 ,p_time_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
51 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE);
52 --
53 Procedure otlr_validation_required
54 (p_operation in varchar2
55 ,p_otm_explosion in varchar2
56 ,p_otm_rtr_id in number
57 ,p_app_set_id in number
58 ,p_timecard_id in number
59 ,p_timecard_ovn in number
60 ,p_time_building_blocks in hxc_self_service_time_deposit.timecard_info
61 ,p_time_att_info in hxc_self_Service_time_deposit.app_attributes_info
62 ,p_messages in out nocopy hxc_self_service_time_deposit.message_table
63 );
64 --
65 PROCEDURE otlr_review_details(
66 p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
67 ,p_time_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
68 ,p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.MESSAGE_TABLE
69 ,p_detail_build_blocks IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info
70 ,p_detail_attributes IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info);
71 --
72 FUNCTION build_attributes(
73 p_detail_attributes IN HXC_SELF_SERVICE_TIME_DEPOSIT.app_attributes_info
74 )
75 RETURN HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info;
76 --
77
78 -- Bug 8486310
79 -- Added new procedure to save Alt Name Identifiers.
80 PROCEDURE save_an_ids(p_element IN VARCHAR2) ;
81
82 -- Bug 7557568
83 -- Added the following function to check if a detail is deleted
84 -- after a SAVE.
85 PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
86 p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table );
87
88
89
90 END hxt_hxc_retrieval_process;
91
[Home] [Help]