eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_APL_TIME dependencies on HRI_TIME_BANDS

Line 61: l_band_to_split hri_time_bands%rowtype; -- band to split

57: p_band_min_month_comp IN NUMBER,
58: p_band_min_year_comp IN NUMBER) IS
59:
60: l_band_min_value NUMBER; -- minimum value of band to insert
61: l_band_to_split hri_time_bands%rowtype; -- band to split
62:
63: l_max_value NUMBER;
64: l_max_day NUMBER;
65: l_max_week NUMBER;

Line 74: FROM hri_time_bands

70: /* Picks out the band to split (the band which the given minimum value */
71: /* falls into) */
72: CURSOR split_cur(v_band_min_value IN NUMBER) IS
73: SELECT *
74: FROM hri_time_bands
75: WHERE type = p_type
76: AND v_band_min_value > band_min_value
77: AND (v_band_min_value < band_max_value
78: OR band_max_value IS NULL);

Line 108: UPDATE hri_time_bands

104: CLOSE split_cur;
105: /* Otherwise split the existing band */
106: ELSE
107: /* Increment the band sequence for higher bands */
108: UPDATE hri_time_bands
109: SET band_sequence = band_sequence + 1
110: WHERE band_sequence > l_band_to_split.band_sequence
111: AND type = p_type;
112:

Line 114: INSERT INTO hri_time_bands

110: WHERE band_sequence > l_band_to_split.band_sequence
111: AND type = p_type;
112:
113: /* Insert a new band with the new minimum and the existing maximum */
114: INSERT INTO hri_time_bands
115: (type
116: ,band_min_value
117: ,band_max_value
118: ,band_sequence

Line 142: UPDATE hri_time_bands

138: ,l_band_to_split.band_max_month_comp
139: ,l_band_to_split.band_max_year_comp);
140:
141: /* Update the band with the existing minimum to end at the new minimum */
142: UPDATE hri_time_bands
143: SET band_max_value = l_band_min_value,
144: band_max_year_comp = p_band_min_year_comp,
145: band_max_month_comp = p_band_min_month_comp,
146: band_max_week_comp = p_band_min_week_comp,

Line 169: l_band_to_delete hri_time_bands%rowtype; -- band to remove

165: p_band_min_month_comp IN NUMBER,
166: p_band_min_year_comp IN NUMBER) IS
167:
168: l_band_min_value NUMBER; -- minimum value of band to remove
169: l_band_to_delete hri_time_bands%rowtype; -- band to remove
170: l_band_to_grow hri_time_bands%rowtype; -- band to remove
171:
172: /* Selects information from band to be deleted */
173: CURSOR delete_cur IS

Line 170: l_band_to_grow hri_time_bands%rowtype; -- band to remove

166: p_band_min_year_comp IN NUMBER) IS
167:
168: l_band_min_value NUMBER; -- minimum value of band to remove
169: l_band_to_delete hri_time_bands%rowtype; -- band to remove
170: l_band_to_grow hri_time_bands%rowtype; -- band to remove
171:
172: /* Selects information from band to be deleted */
173: CURSOR delete_cur IS
174: SELECT *

Line 175: FROM hri_time_bands

171:
172: /* Selects information from band to be deleted */
173: CURSOR delete_cur IS
174: SELECT *
175: FROM hri_time_bands
176: WHERE type = p_type
177: AND band_min_day_comp = p_band_min_day_comp
178: AND band_min_week_comp = p_band_min_week_comp
179: AND band_min_month_comp = p_band_min_month_comp

Line 185: FROM hri_time_bands

181:
182: /* Selects information from band to be extended */
183: CURSOR grow_cur IS
184: SELECT *
185: FROM hri_time_bands
186: WHERE type = p_type
187: AND band_max_day_comp = p_band_min_day_comp
188: AND band_max_week_comp = p_band_min_week_comp
189: AND band_max_month_comp = p_band_min_month_comp

Line 214: DELETE FROM hri_time_bands

210: /* Check the bands are consecutive */
211: IF (l_band_to_delete.band_min_value = l_band_to_grow.band_max_value) THEN
212:
213: /* Delete the given band */
214: DELETE FROM hri_time_bands
215: WHERE band_min_value = l_band_to_delete.band_min_value
216: AND type = p_type;
217:
218: /* Decrement the sequence number of higher bands */

Line 219: UPDATE hri_time_bands

215: WHERE band_min_value = l_band_to_delete.band_min_value
216: AND type = p_type;
217:
218: /* Decrement the sequence number of higher bands */
219: UPDATE hri_time_bands
220: SET band_sequence = band_sequence - 1
221: WHERE band_sequence > l_band_to_delete.band_sequence
222: AND type = p_type;
223:

Line 226: UPDATE hri_time_bands

222: AND type = p_type;
223:
224: /* Set the maximum value of the band preceeding the deleted band */
225: /* to the maximum value of the deleted band */
226: UPDATE hri_time_bands
227: SET band_max_value = l_band_to_delete.band_max_value,
228: band_max_year_comp = l_band_to_delete.band_max_year_comp,
229: band_max_month_comp = l_band_to_delete.band_max_month_comp,
230: band_max_week_comp = l_band_to_delete.band_max_week_comp,

Line 257: FROM hri_time_bands

253: band_min_day_comp
254: ,band_min_week_comp
255: ,band_min_month_comp
256: ,band_min_year_comp
257: FROM hri_time_bands
258: WHERE type = p_type
259: AND band_min_value > 0;
260:
261: BEGIN

Line 307: FROM hri_time_bands

303:
304: /* Selects the number of bands for the given type that have been customized */
305: CURSOR customized_bands_csr IS
306: SELECT count(*)
307: FROM hri_time_bands
308: WHERE type = p_type
309: AND fnd_load_util.owner_name(last_updated_by) <> 'ORACLE';
310:
311: BEGIN

Line 325: DELETE FROM hri_time_bands

321: /* If the banding type has not been customized, process the seeded type */
322: IF (l_rows_customized = 0) THEN
323:
324: /* Delete all overlapping bands */
325: DELETE FROM hri_time_bands
326: WHERE type = p_type
327: AND ((p_band_min <= band_min_value AND
328: (band_min_value < p_band_max OR p_band_max IS NULL))
329: OR (band_min_value <= p_band_min AND

Line 334: INSERT INTO hri_time_bands

330: (p_band_min < band_max_value OR band_max_value IS NULL))
331: OR band_sequence = p_band_sequence);
332:
333: /* Insert seeded band */
334: INSERT INTO hri_time_bands
335: ( type
336: , band_min_value
337: , band_max_value
338: , band_sequence