1 Package hxc_elp_utils AUTHID CURRENT_USER as
2 /* $Header: hxcelputl.pkh 115.2 2003/04/28 13:56:40 ksethi noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' hxc_elp_utils.'; -- Global package name
9
10
11 -- global PL/SQL records and tables
12
13
14 -- ----------------------------------------------------------------------------
15 -- |------------------------< set_time_bb_appl_set_id >-----------------------|
16 -- ----------------------------------------------------------------------------
17 --
18 -- Description:
19 --
20 -- This will be called from the deposit wrapper,
21 -- in case Entry Level Processing is being used.
22 -- This will update the global timecard with the
23 -- application set id that needs to be populated
24 -- with each and evey time builiding block.
25 -- Prerequisites:
26 --
27 -- Process time entry and entry level processing data has been setup for the
28 -- resource.
29 --
30 -- In Parameters:
31 -- Name Reqd Type Description
32 --
33 -- p_time_building_blocks Yes g_timecard Global timecard object
34 -- p_time_attributes Yes g_attributes Global attributes object
35 -- p_messages Yes g_messages Global messages table
36 -- p_pte_terg_id Yes number PTE MME id set at the user pref level
37 -- p_application_set_id Yes number Applcaiton set id set at the user pref level
38 --
39 -- Post Success:
40 --
41 -- g_timecard is populated with the appropriate
42 -- application set id along with each time building block
43 --
44 -- Post Failure:
45 --
46 -- an application error is raised
47 --
48 -- Access Status:
49 -- Public.
50 --
51 PROCEDURE set_time_bb_appl_set_id
52 (P_TIME_BUILDING_BLOCKS IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
53 ,P_TIME_ATTRIBUTES IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
54 ,P_MESSAGES IN OUT NOCOPY hxc_self_service_time_deposit.message_table
55 ,P_PTE_TERG_ID IN number
56 ,P_APPLICATION_SET_ID IN number
57 );
58
59
60 -- ----------------------------------------------------------------------------
61 -- |------------------------< build_elp_objects >-----------------------------|
62 -- ----------------------------------------------------------------------------
63 --
64 -- Description:
65 --
66 -- This will be called from the deposit wrapper,
67 -- in case Entry Level Processing is being used.
68 -- The procedure will return two new filtered timecard and attributes
69 -- table, based on the current application set validation
70 --
71 -- Prerequisites:
72 --
73 -- Process time entry and entry level processing data has been setup for the
74 -- resource and application set id is populated with all time building blocks.
75 --
76 -- In Parameters:
77 -- Name Reqd Type Description
78 --
79 -- p_time_building_blocks Yes g_timecard ELP timecard object
80 -- p_time_attributes Yes g_attributes ELP attributes object
81 -- p_time_recipient_id Yes number Time recipient id
82 --
83 -- Post Success:
84 --
85 -- A filtered g_time_building_block is populated which
86 -- is then used for the application set validation.
87 --
88 -- Post Failure:
89 --
90 -- an application error is raised
91 --
92 -- Access Status:
93 -- Public.
94 --
95 FUNCTION build_elp_objects
96 (P_ELP_TIME_BUILDING_BLOCKS HXC_BLOCK_TABLE_TYPE
97 ,P_ELP_TIME_ATTRIBUTES HXC_ATTRIBUTE_TABLE_TYPE
98 ,P_TIME_RECIPIENT_ID number
99 ) RETURN HXC_BLOCK_TABLE_TYPE;
100
101
102 -- ----------------------------------------------------------------------------
103 -- |------------------------< set_time_bb_appl_set_tk >-----------------------|
104 -- ----------------------------------------------------------------------------
105 --
106 -- Description:
107 --
108 -- This will be called from the TimeKeeper deposit wrapper,
109 -- irrespective of ELP being used or not,
110 -- This will update the global timecard with the
111 -- application set id with the one at the user preference
112 -- with each and evey time builiding block.
113 -- Prerequisites:
114 --
115 -- None
116 --
117 -- In Parameters:
118 -- Name Reqd Type Description
119 --
120 -- p_time_building_blocks Yes g_timecard Global timecard object
121 -- p_application_set_id Yes number Applcaiton set id set at the user pref level
122 --
123 -- Post Success:
124 --
125 -- g_timecard is populated with the
126 -- application set id along with each time building block
127 --
128 -- Post Failure:
129 --
130 -- an application error is raised
131 --
132 -- Access Status:
133 -- Public.
134 --
135 PROCEDURE set_time_bb_appl_set_tk
136 (P_TIME_BUILDING_BLOCKS IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
137 ,P_APPLICATION_SET_ID IN number
138 );
139
140 end hxc_elp_utils;