[Home] [Help]
PACKAGE: APPS.HXC_LOCK_UTIL
Source
1 PACKAGE HXC_LOCK_UTIL AS
2 /* $Header: hxclockutil.pkh 120.1 2005/07/25 13:41:09 jdupont noship $ */
3
4 c_self_service CONSTANT VARCHAR2(20) := 'SELF_SERVICE';
5 c_pui CONSTANT VARCHAR2(20) := 'PUI';
6 c_plsql CONSTANT VARCHAR2(20) := 'PLSQL';
7 c_timecard_action CONSTANT VARCHAR2(20) := 'TIMECARD_ACTION';
8 c_timecard_view CONSTANT VARCHAR2(20) := 'TIMECARD_VIEW';
9 c_approval_action CONSTANT VARCHAR2(20) := 'APPROVAL_ACTION';
10 c_timekeeper_action CONSTANT VARCHAR2(20) := 'TIMEKEEPER_ACTION';
11 c_pa_retrieval_action CONSTANT VARCHAR2(20) := 'PA_RETRIEVAL_ACTION';
12 c_pay_retrieval_action CONSTANT VARCHAR2(20) := 'PAY_RETRIEVAL_ACTION';
13 c_eam_retrieval_action CONSTANT VARCHAR2(20) := 'EAM_RETRIEVAL_ACTION';
14 c_po_retrieval_action CONSTANT VARCHAR2(20) := 'PO_RETRIEVAL_ACTION';
15 c_deposit_action CONSTANT VARCHAR2(20) := 'DEPOSIT_ACTION';
16 c_coa_action CONSTANT VARCHAR2(20) := 'COA_ACTION';
17 c_ar_action CONSTANT VARCHAR2(30) := 'ARCHIVE_RESTORE_ACTION';
18
19
20 c_ss_timecard_action CONSTANT VARCHAR2(18) := 'SS_TIMECARD_ACTION';
21 c_ss_timecard_view CONSTANT VARCHAR2(16) := 'SS_TIMECARD_VIEW';
22 c_ss_approval_action CONSTANT VARCHAR2(18) := 'SS_APPROVAL_ACTION';
23
24 c_pui_timekeeper_action CONSTANT VARCHAR2(21) := 'PUI_TIMEKEEPER_ACTION';
25
26 c_plsql_pay_retrieval_action CONSTANT VARCHAR2(80) := 'PLSQL_PAY_RETRIEVAL_ACTION';
27 c_plsql_pa_retrieval_action CONSTANT VARCHAR2(80) := 'PLSQL_PA_RETRIEVAL_ACTION';
28 c_plsql_eam_retrieval_action CONSTANT VARCHAR2(80) := 'PLSQL_EAM_RETRIEVAL_ACTION';
29 c_plsql_po_retrieval_action CONSTANT VARCHAR2(80) := 'PLSQL_PO_RETRIEVAL_ACTION';
30
31 c_plsql_deposit_action CONSTANT VARCHAR2(20) := 'PLSQL_DEPOSIT_ACTION';
32 c_plsql_coa_action CONSTANT VARCHAR2(20) := 'PLSQL_COA_ACTION';
33 c_plsql_ar_action CONSTANT VARCHAR2(35) := 'PLSQL_ARCHIVE_RESTORE_ACTION';
34
35
36 c_ss_expiration_time CONSTANT NUMBER := 10;
37 c_plsql_retrieval_time CONSTANT NUMBER := 60;
38 c_pui_timekeeper_save_time CONSTANT NUMBER := 30;
39 c_pui_timekeeper_submit_time CONSTANT NUMBER := 60;
40 c_plsql_ar_time CONSTANT NUMBER := 60;
41
42 -- ----------------------------------------------------------------------------
43 -- |---------------------------< check_parameters > ----------------------|
44 -- ----------------------------------------------------------------------------
45 -- if p_row_id is not null then
46 -- the message table will be populated
47 PROCEDURE check_parameters
48 (p_process_locker_type IN VARCHAR2
49 ,p_resource_id IN OUT NOCOPY NUMBER
50 ,p_start_time IN OUT NOCOPY DATE
51 ,p_stop_time IN OUT NOCOPY DATE
52 ,p_time_building_block_id IN NUMBER
53 ,p_time_building_block_ovn IN NUMBER
54 ,p_time_scope IN OUT NOCOPY VARCHAR2
55 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
56 ,p_passed_check OUT NOCOPY BOOLEAN
57 );
58
59 -- ----------------------------------------------------------------------------
60 -- |---------------------------< check_grant > ----------------------|
61 -- ----------------------------------------------------------------------------
62 PROCEDURE check_grant(p_locker_type_owner_id IN NUMBER
63 ,p_locker_type_requestor_id IN NUMBER
64 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
65 ,p_grant_lock OUT NOCOPY VARCHAR2);
66 /*
67 -- ----------------------------------------------------------------------------
68 -- |---------------------------< validate_lock > ----------------------|
69 -- ----------------------------------------------------------------------------
70 PROCEDURE validate_lock
71 (p_locker_type_owner_id IN OUT NOCOPY NUMBER
72 ,p_locker_type_requestor_id IN OUT NOCOPY NUMBER
73 ,p_lock_date IN OUT NOCOPY DATE
74 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
75 ,p_valid_lock IN OUT NOCOPY BOOLEAN);
76 */
77 -- ----------------------------------------------------------------------------
78 -- |---------------------------< insert_lock > ----------------------|
79 -- ----------------------------------------------------------------------------
80
81 PROCEDURE insert_lock (p_locker_type_id IN NUMBER
82 ,p_resource_id IN NUMBER
83 ,p_start_time IN DATE
84 ,p_stop_time IN DATE
85 ,p_time_building_block_id IN NUMBER
86 ,p_time_building_block_ovn IN NUMBER
87 ,p_transaction_lock_id IN NUMBER
88 ,p_expiration_time IN NUMBER
89 ,p_row_lock_id IN OUT NOCOPY ROWID);
90
91 -- ----------------------------------------------------------------------------
92 -- |---------------------------< delete_lock > ----------------------|
93 -- ----------------------------------------------------------------------------
94
95 PROCEDURE delete_lock(p_rowid IN ROWID
96 ,p_locker_type_id IN NUMBER
97 ,p_process_locker_type IN VARCHAR2
98 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE);
99
100
101 -- ----------------------------------------------------------------------------
102 -- |------------------------< delete_transaction_lock > ----------------------|
103 -- ----------------------------------------------------------------------------
104 PROCEDURE delete_transaction_lock
105 (p_transaction_lock_id IN NUMBER
106 ,p_process_locker_type IN VARCHAR2
107 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE);
108
109 --PROCEDURE delete_lock(p_rowid IN ROWID);
110 -- ----------------------------------------------------------------------------
111 -- |---------------------------< get_locker_type_req_id > ----------------------|
112 -- ----------------------------------------------------------------------------
113 FUNCTION get_locker_type_req_id
114 (p_process_locker_type IN VARCHAR
115 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
116 RETURN NUMBER;
117
118 -- ----------------------------------------------------------------------------
119 -- |---------------------------< checking_lock > ----------------------|
120 -- ----------------------------------------------------------------------------
121 PROCEDURE check_row_lock
122 (p_locker_type_requestor_id IN NUMBER
123 ,p_process_locker_type IN VARCHAR2
124 ,p_resource_id IN NUMBER
125 ,p_time_building_block_id IN NUMBER
126 ,p_time_building_block_ovn IN NUMBER
127 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
128 ,p_row_locked OUT NOCOPY BOOLEAN);
129 -- ----------------------------------------------------------------------------
130 -- |---------------------------< delete_tbb_lock > ----------------------|
131 -- ----------------------------------------------------------------------------
132
133 PROCEDURE delete_tbb_lock (p_locker_type_id IN NUMBER
134 ,p_time_building_block_id IN NUMBER
135 ,p_time_building_block_ovn IN NUMBER);
136
137 -- ----------------------------------------------------------------------------
138 -- |---------------------------< delete_period_lock > ----------------------|
139 -- ----------------------------------------------------------------------------
140
141 PROCEDURE delete_period_lock
142 (p_locker_type_id IN NUMBER
143 ,p_resource_id IN NUMBER
144 ,p_start_time IN DATE
145 ,p_stop_time IN DATE);
146
147
148 -- ----------------------------------------------------------------------------
149 -- |---------------------------< check_date_lock > ----------------------|
150 -- ----------------------------------------------------------------------------
151 PROCEDURE check_date_lock
152 (p_locker_type_requestor_id IN NUMBER
153 ,p_locker_type_owner_id IN NUMBER
154 ,p_process_locker_type IN VARCHAR2
155 ,p_lock_date IN DATE
156 ,p_lock_start_time IN DATE
157 ,p_lock_stop_time IN DATE
158 ,p_start_time IN DATE
159 ,p_stop_time IN DATE
160 ,p_time_building_block_id IN NUMBER
161 ,p_time_building_block_ovn IN NUMBER
162 ,p_resource_id IN NUMBER
163 ,p_process_id IN NUMBER
164 ,p_attribute2 IN VARCHAR2
165 ,p_rowid IN ROWID
166 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
167 ,p_row_locked OUT NOCOPY BOOLEAN) ;
168
169
170 END HXC_LOCK_UTIL;