APPS.HRI_OPL_PERIOD_OF_WORK dependencies on HRI_CS_POW_BAND_CT

Line 6: -- Record Type for populating table hri_cs_pow_band_ct

2: /* $Header: hriopow.pkb 120.2 2005/06/21 22:23:44 anmajumd noship $ */
3: --
4: -- Global variables
5: --
6: -- Record Type for populating table hri_cs_pow_band_ct
7: --
8: TYPE g_pow_band_record IS RECORD
9: (set_bucket_id NUMBER
10: ,set_bucket_custom_id NUMBER

Line 19: -- Table type for populating the table hri_cs_pow_band_ct

15: ,band_range_high NUMBER
16: ,wkth_wktyp_sk_fk VARCHAR2(240)
17: );
18: --
19: -- Table type for populating the table hri_cs_pow_band_ct
20: --
21: TYPE g_pow_band_tab_type IS TABLE OF g_pow_band_record INDEX BY BINARY_INTEGER;
22: --
23: -- Record type to hold pow cursor values

Line 297: -- Inserts the records in table hri_cs_pow_band_ct

293: END collect_records;
294:
295: --
296: -- ----------------------------------------------------------------------------
297: -- Inserts the records in table hri_cs_pow_band_ct
298: -- ----------------------------------------------------------------------------
299: --
300: PROCEDURE insert_records(p_pow_band_tab_type IN g_pow_band_tab_type) IS
301: --

Line 309: INSERT INTO HRI_CS_POW_BAND_CT

305: BEGIN
306: --
307: FOR i in p_pow_band_tab_type.FIRST..p_pow_band_tab_type.LAST LOOP
308: --
309: INSERT INTO HRI_CS_POW_BAND_CT
310: (
311: pow_band_sk_pk
312: ,set_bucket_id
313: ,set_bucket_custom_id

Line 327: (hri_cs_pow_band_ct_s.nextval

323: ,last_updated_by
324: ,last_update_login
325: )
326: VALUES
327: (hri_cs_pow_band_ct_s.nextval
328: ,p_pow_band_tab_type(i).set_bucket_id
329: ,p_pow_band_tab_type(i).set_bucket_custom_id
330: ,p_pow_band_tab_type(i).set_short_name
331: ,p_pow_band_tab_type(i).set_uom

Line 361: -- Truncate the table hri_cs_pow_band_ct

357: --
358: BEGIN
359: --
360: --
361: -- Truncate the table hri_cs_pow_band_ct
362: --
363: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_hri_schema)) THEN
364: --
365: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_hri_schema || '.HRI_CS_POW_BAND_CT';

Line 365: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_hri_schema || '.HRI_CS_POW_BAND_CT';

361: -- Truncate the table hri_cs_pow_band_ct
362: --
363: IF (fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_hri_schema)) THEN
364: --
365: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_hri_schema || '.HRI_CS_POW_BAND_CT';
366: --
367: END IF;
368: --
369: