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_OPL_PER_ORGCC dependencies on HRI_CS_PER_ORGCC_CT

Line 18: HRI_CS_PER_ORGCC_CT.organization_id%TYPE

14: -- @@ INDEX BY BINARY_INTEGER;
15: -- @@
16: --
17: TYPE g_organization_id_type IS TABLE OF
18: HRI_CS_PER_ORGCC_CT.organization_id%TYPE
19: INDEX BY BINARY_INTEGER;
20: TYPE g_cost_centre_code_type IS TABLE OF
21: HRI_CS_PER_ORGCC_CT.cost_centre_code%TYPE
22: INDEX BY BINARY_INTEGER;

Line 21: HRI_CS_PER_ORGCC_CT.cost_centre_code%TYPE

17: TYPE g_organization_id_type IS TABLE OF
18: HRI_CS_PER_ORGCC_CT.organization_id%TYPE
19: INDEX BY BINARY_INTEGER;
20: TYPE g_cost_centre_code_type IS TABLE OF
21: HRI_CS_PER_ORGCC_CT.cost_centre_code%TYPE
22: INDEX BY BINARY_INTEGER;
23: TYPE g_cc_mngr_person_id_type IS TABLE OF
24: HRI_CS_PER_ORGCC_CT.cc_mngr_person_id%TYPE
25: INDEX BY BINARY_INTEGER;

Line 24: HRI_CS_PER_ORGCC_CT.cc_mngr_person_id%TYPE

20: TYPE g_cost_centre_code_type IS TABLE OF
21: HRI_CS_PER_ORGCC_CT.cost_centre_code%TYPE
22: INDEX BY BINARY_INTEGER;
23: TYPE g_cc_mngr_person_id_type IS TABLE OF
24: HRI_CS_PER_ORGCC_CT.cc_mngr_person_id%TYPE
25: INDEX BY BINARY_INTEGER;
26: TYPE g_effective_start_date_type IS TABLE OF
27: HRI_CS_PER_ORGCC_CT.effective_start_date%TYPE
28: INDEX BY BINARY_INTEGER;

Line 27: HRI_CS_PER_ORGCC_CT.effective_start_date%TYPE

23: TYPE g_cc_mngr_person_id_type IS TABLE OF
24: HRI_CS_PER_ORGCC_CT.cc_mngr_person_id%TYPE
25: INDEX BY BINARY_INTEGER;
26: TYPE g_effective_start_date_type IS TABLE OF
27: HRI_CS_PER_ORGCC_CT.effective_start_date%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE g_effective_end_date_type IS TABLE OF
30: HRI_CS_PER_ORGCC_CT.effective_end_date%TYPE
31: INDEX BY BINARY_INTEGER;

Line 30: HRI_CS_PER_ORGCC_CT.effective_end_date%TYPE

26: TYPE g_effective_start_date_type IS TABLE OF
27: HRI_CS_PER_ORGCC_CT.effective_start_date%TYPE
28: INDEX BY BINARY_INTEGER;
29: TYPE g_effective_end_date_type IS TABLE OF
30: HRI_CS_PER_ORGCC_CT.effective_end_date%TYPE
31: INDEX BY BINARY_INTEGER;
32: TYPE g_company_code_type IS TABLE OF
33: HRI_CS_PER_ORGCC_CT.company_code%TYPE
34: INDEX BY BINARY_INTEGER;

Line 33: HRI_CS_PER_ORGCC_CT.company_code%TYPE

29: TYPE g_effective_end_date_type IS TABLE OF
30: HRI_CS_PER_ORGCC_CT.effective_end_date%TYPE
31: INDEX BY BINARY_INTEGER;
32: TYPE g_company_code_type IS TABLE OF
33: HRI_CS_PER_ORGCC_CT.company_code%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE g_reporting_name_type IS TABLE OF
36: HRI_CS_PER_ORGCC_CT.reporting_name%TYPE
37: INDEX BY BINARY_INTEGER;

Line 36: HRI_CS_PER_ORGCC_CT.reporting_name%TYPE

32: TYPE g_company_code_type IS TABLE OF
33: HRI_CS_PER_ORGCC_CT.company_code%TYPE
34: INDEX BY BINARY_INTEGER;
35: TYPE g_reporting_name_type IS TABLE OF
36: HRI_CS_PER_ORGCC_CT.reporting_name%TYPE
37: INDEX BY BINARY_INTEGER;
38: TYPE g_last_change_date_type IS TABLE OF
39: HRI_CS_PER_ORGCC_CT.last_change_date%TYPE
40: INDEX BY BINARY_INTEGER;

Line 39: HRI_CS_PER_ORGCC_CT.last_change_date%TYPE

35: TYPE g_reporting_name_type IS TABLE OF
36: HRI_CS_PER_ORGCC_CT.reporting_name%TYPE
37: INDEX BY BINARY_INTEGER;
38: TYPE g_last_change_date_type IS TABLE OF
39: HRI_CS_PER_ORGCC_CT.last_change_date%TYPE
40: INDEX BY BINARY_INTEGER;
41: --
42: -- @@ Code specific to this view/table below ENDS
43: --

Line 84: g_target_table VARCHAR2(30) DEFAULT 'HRI_CS_PER_ORGCC_CT';

80: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date
81: -- @@ change param1/2 to be the concurrent program short name,
82: -- @@ and the target table name respectively.
83: --
84: g_target_table VARCHAR2(30) DEFAULT 'HRI_CS_PER_ORGCC_CT';
85: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRIPORGC';
86: --
87: -- @@ Code specific to this view/table below ENDS
88: --

Line 139: INSERT INTO hri_cs_per_orgcc_ct

135: -- @@ statement below.
136: -- @@ 2/ Prefix each column in the VALUE clause with g_
137: -- @@ 3/ make sure (i) is at the end of each column in the value clause
138: --
139: INSERT INTO hri_cs_per_orgcc_ct
140: (organization_id
141: ,cost_centre_code
142: ,cc_mngr_person_id
143: ,effective_start_date

Line 199: INSERT INTO hri_cs_per_orgcc_ct

195: -- @@ 2/ Prefix each column in the VALUE clause with g_
196: -- @@ 3/ make sure (i) is at the end of each column in the value clause
197: --
198: FORALL i IN 1..p_stored_rows_to_insert
199: INSERT INTO hri_cs_per_orgcc_ct
200: (organization_id
201: ,cost_centre_code
202: ,cc_mngr_person_id
203: ,effective_start_date

Line 254: INSERT INTO hri_cs_per_orgcc_ct

250: --
251: -- Insert completly new rows
252: --
253: -- log('Doing insert.');
254: INSERT INTO hri_cs_per_orgcc_ct
255: (organization_id
256: ,cost_centre_code
257: ,cc_mngr_person_id
258: ,effective_start_date

Line 279: FROM hri_cs_per_orgcc_ct tbl

275: --
276: WHERE TRUNC(last_change_date) BETWEEN g_start_date
277: AND g_end_date
278: AND NOT EXISTS (SELECT 'x'
279: FROM hri_cs_per_orgcc_ct tbl
280: WHERE svw.organization_id = tbl.organization_id
281: AND svw.effective_start_date = tbl.effective_start_date
282: AND svw.effective_end_date = tbl.effective_end_date);
283: -- log('Insert >'||TO_CHAR(sql%rowcount));

Line 289: UPDATE hri_cs_per_orgcc_ct tbl

285: --
286: -- Update changed rows
287: -- Bug 3658494: Query made performant
288: --
289: UPDATE hri_cs_per_orgcc_ct tbl
290: SET (organization_id
291: ,cost_centre_code
292: ,cc_mngr_person_id
293: ,effective_start_date

Line 336: FROM hri_cs_per_orgcc_ct tbl

332: -- Delete rows that no longer exist in the source view.
333: --
334: -- log('Doing delete.');
335: DELETE
336: FROM hri_cs_per_orgcc_ct tbl
337: WHERE NOT EXISTS (SELECT 'x'
338: FROM hri_cs_per_orgcc_v svw
339: WHERE svw.organization_id = tbl.organization_id
340: AND svw.effective_start_date = tbl.effective_start_date

Line 564: FROM hri_cs_per_orgcc_ct;

560: -- @@ target table.
561: --
562: CURSOR csr_recs_exist IS
563: SELECT 'x'
564: FROM hri_cs_per_orgcc_ct;
565: --
566: -- @@ Code specific to this view/table ENDS
567: --
568: l_exists_chr VARCHAR2(1);