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_REC_VAC dependencies on HRI_MB_REC_VACANCY_CT

Line 19: hri_mb_rec_vacancy_ct.pos_position_fk%TYPE

15: -- @@
16: --
17:
18: TYPE g_pos_position_type IS TABLE OF
19: hri_mb_rec_vacancy_ct.pos_position_fk%TYPE
20: INDEX BY BINARY_INTEGER;
21:
22: TYPE g_rvac_vacncy_type IS TABLE OF
23: hri_mb_rec_vacancy_ct.rvac_vacncy_fk%TYPE

Line 23: hri_mb_rec_vacancy_ct.rvac_vacncy_fk%TYPE

19: hri_mb_rec_vacancy_ct.pos_position_fk%TYPE
20: INDEX BY BINARY_INTEGER;
21:
22: TYPE g_rvac_vacncy_type IS TABLE OF
23: hri_mb_rec_vacancy_ct.rvac_vacncy_fk%TYPE
24: INDEX BY BINARY_INTEGER;
25:
26: TYPE g_org_organztn_type IS TABLE OF
27: hri_mb_rec_vacancy_ct.org_organztn_fk%TYPE

Line 27: hri_mb_rec_vacancy_ct.org_organztn_fk%TYPE

23: hri_mb_rec_vacancy_ct.rvac_vacncy_fk%TYPE
24: INDEX BY BINARY_INTEGER;
25:
26: TYPE g_org_organztn_type IS TABLE OF
27: hri_mb_rec_vacancy_ct.org_organztn_fk%TYPE
28: INDEX BY BINARY_INTEGER;
29:
30: TYPE g_org_organztn_mrgd_type IS TABLE OF
31: hri_mb_rec_vacancy_ct.org_organztn_mrgd_fk%TYPE

Line 31: hri_mb_rec_vacancy_ct.org_organztn_mrgd_fk%TYPE

27: hri_mb_rec_vacancy_ct.org_organztn_fk%TYPE
28: INDEX BY BINARY_INTEGER;
29:
30: TYPE g_org_organztn_mrgd_type IS TABLE OF
31: hri_mb_rec_vacancy_ct.org_organztn_mrgd_fk%TYPE
32: INDEX BY BINARY_INTEGER;
33:
34: TYPE g_geo_location_type IS TABLE OF
35: hri_mb_rec_vacancy_ct.geo_location_fk%TYPE

Line 35: hri_mb_rec_vacancy_ct.geo_location_fk%TYPE

31: hri_mb_rec_vacancy_ct.org_organztn_mrgd_fk%TYPE
32: INDEX BY BINARY_INTEGER;
33:
34: TYPE g_geo_location_type IS TABLE OF
35: hri_mb_rec_vacancy_ct.geo_location_fk%TYPE
36: INDEX BY BINARY_INTEGER;
37:
38: TYPE g_job_job_type IS TABLE OF
39: hri_mb_rec_vacancy_ct.job_job_fk%TYPE

Line 39: hri_mb_rec_vacancy_ct.job_job_fk%TYPE

35: hri_mb_rec_vacancy_ct.geo_location_fk%TYPE
36: INDEX BY BINARY_INTEGER;
37:
38: TYPE g_job_job_type IS TABLE OF
39: hri_mb_rec_vacancy_ct.job_job_fk%TYPE
40: INDEX BY BINARY_INTEGER;
41:
42: TYPE g_grd_grade_type IS TABLE OF
43: hri_mb_rec_vacancy_ct.grd_grade_fk%TYPE

Line 43: hri_mb_rec_vacancy_ct.grd_grade_fk%TYPE

39: hri_mb_rec_vacancy_ct.job_job_fk%TYPE
40: INDEX BY BINARY_INTEGER;
41:
42: TYPE g_grd_grade_type IS TABLE OF
43: hri_mb_rec_vacancy_ct.grd_grade_fk%TYPE
44: INDEX BY BINARY_INTEGER;
45:
46: TYPE g_time_day_vac_end_type IS TABLE OF
47: hri_mb_rec_vacancy_ct.time_day_vac_end_fk%TYPE

Line 47: hri_mb_rec_vacancy_ct.time_day_vac_end_fk%TYPE

43: hri_mb_rec_vacancy_ct.grd_grade_fk%TYPE
44: INDEX BY BINARY_INTEGER;
45:
46: TYPE g_time_day_vac_end_type IS TABLE OF
47: hri_mb_rec_vacancy_ct.time_day_vac_end_fk%TYPE
48: INDEX BY BINARY_INTEGER;
49:
50: TYPE g_per_person_recr_type IS TABLE OF
51: hri_mb_rec_vacancy_ct.per_person_recr_fk%TYPE

Line 51: hri_mb_rec_vacancy_ct.per_person_recr_fk%TYPE

47: hri_mb_rec_vacancy_ct.time_day_vac_end_fk%TYPE
48: INDEX BY BINARY_INTEGER;
49:
50: TYPE g_per_person_recr_type IS TABLE OF
51: hri_mb_rec_vacancy_ct.per_person_recr_fk%TYPE
52: INDEX BY BINARY_INTEGER;
53:
54: TYPE g_per_person_rmgr_type IS TABLE OF
55: hri_mb_rec_vacancy_ct.per_person_rmgr_fk%TYPE

Line 55: hri_mb_rec_vacancy_ct.per_person_rmgr_fk%TYPE

51: hri_mb_rec_vacancy_ct.per_person_recr_fk%TYPE
52: INDEX BY BINARY_INTEGER;
53:
54: TYPE g_per_person_rmgr_type IS TABLE OF
55: hri_mb_rec_vacancy_ct.per_person_rmgr_fk%TYPE
56: INDEX BY BINARY_INTEGER;
57:
58: TYPE g_per_person_rsed_type IS TABLE OF
59: hri_mb_rec_vacancy_ct.per_person_rsed_fk%TYPE

Line 59: hri_mb_rec_vacancy_ct.per_person_rsed_fk%TYPE

55: hri_mb_rec_vacancy_ct.per_person_rmgr_fk%TYPE
56: INDEX BY BINARY_INTEGER;
57:
58: TYPE g_per_person_rsed_type IS TABLE OF
59: hri_mb_rec_vacancy_ct.per_person_rsed_fk%TYPE
60: INDEX BY BINARY_INTEGER;
61:
62: TYPE g_per_person_mrgd_type IS TABLE OF
63: hri_mb_rec_vacancy_ct.per_person_mrgd_fk%TYPE

Line 63: hri_mb_rec_vacancy_ct.per_person_mrgd_fk%TYPE

59: hri_mb_rec_vacancy_ct.per_person_rsed_fk%TYPE
60: INDEX BY BINARY_INTEGER;
61:
62: TYPE g_per_person_mrgd_type IS TABLE OF
63: hri_mb_rec_vacancy_ct.per_person_mrgd_fk%TYPE
64: INDEX BY BINARY_INTEGER;
65:
66: TYPE g_time_day_vac_strt_type IS TABLE OF
67: hri_mb_rec_vacancy_ct.time_day_vac_strt_fk%TYPE

Line 67: hri_mb_rec_vacancy_ct.time_day_vac_strt_fk%TYPE

63: hri_mb_rec_vacancy_ct.per_person_mrgd_fk%TYPE
64: INDEX BY BINARY_INTEGER;
65:
66: TYPE g_time_day_vac_strt_type IS TABLE OF
67: hri_mb_rec_vacancy_ct.time_day_vac_strt_fk%TYPE
68: INDEX BY BINARY_INTEGER;
69:
70: TYPE g_number_of_openings_type IS TABLE OF
71: hri_mb_rec_vacancy_ct.number_of_openings%TYPE

Line 71: hri_mb_rec_vacancy_ct.number_of_openings%TYPE

67: hri_mb_rec_vacancy_ct.time_day_vac_strt_fk%TYPE
68: INDEX BY BINARY_INTEGER;
69:
70: TYPE g_number_of_openings_type IS TABLE OF
71: hri_mb_rec_vacancy_ct.number_of_openings%TYPE
72: INDEX BY BINARY_INTEGER;
73:
74: TYPE g_budget_measurement_val_type IS TABLE OF
75: hri_mb_rec_vacancy_ct.budget_measurement_value%TYPE

Line 75: hri_mb_rec_vacancy_ct.budget_measurement_value%TYPE

71: hri_mb_rec_vacancy_ct.number_of_openings%TYPE
72: INDEX BY BINARY_INTEGER;
73:
74: TYPE g_budget_measurement_val_type IS TABLE OF
75: hri_mb_rec_vacancy_ct.budget_measurement_value%TYPE
76: INDEX BY BINARY_INTEGER;
77:
78: TYPE g_adt_business_grp_id_type IS TABLE OF
79: hri_mb_rec_vacancy_ct.adt_business_group_id%TYPE

Line 79: hri_mb_rec_vacancy_ct.adt_business_group_id%TYPE

75: hri_mb_rec_vacancy_ct.budget_measurement_value%TYPE
76: INDEX BY BINARY_INTEGER;
77:
78: TYPE g_adt_business_grp_id_type IS TABLE OF
79: hri_mb_rec_vacancy_ct.adt_business_group_id%TYPE
80: INDEX BY BINARY_INTEGER;
81:
82: TYPE g_adt_vac_status_code_type IS TABLE OF
83: hri_mb_rec_vacancy_ct.adt_vacancy_status_code%TYPE

Line 83: hri_mb_rec_vacancy_ct.adt_vacancy_status_code%TYPE

79: hri_mb_rec_vacancy_ct.adt_business_group_id%TYPE
80: INDEX BY BINARY_INTEGER;
81:
82: TYPE g_adt_vac_status_code_type IS TABLE OF
83: hri_mb_rec_vacancy_ct.adt_vacancy_status_code%TYPE
84: INDEX BY BINARY_INTEGER;
85:
86: TYPE g_adt_budget_type_code_type IS TABLE OF
87: hri_mb_rec_vacancy_ct.adt_budget_type_code%TYPE

Line 87: hri_mb_rec_vacancy_ct.adt_budget_type_code%TYPE

83: hri_mb_rec_vacancy_ct.adt_vacancy_status_code%TYPE
84: INDEX BY BINARY_INTEGER;
85:
86: TYPE g_adt_budget_type_code_type IS TABLE OF
87: hri_mb_rec_vacancy_ct.adt_budget_type_code%TYPE
88: INDEX BY BINARY_INTEGER;
89:
90: TYPE g_adt_vac_cat_code_type IS TABLE OF
91: hri_mb_rec_vacancy_ct.adt_vacancy_category_code%TYPE

Line 91: hri_mb_rec_vacancy_ct.adt_vacancy_category_code%TYPE

87: hri_mb_rec_vacancy_ct.adt_budget_type_code%TYPE
88: INDEX BY BINARY_INTEGER;
89:
90: TYPE g_adt_vac_cat_code_type IS TABLE OF
91: hri_mb_rec_vacancy_ct.adt_vacancy_category_code%TYPE
92: INDEX BY BINARY_INTEGER;
93:
94: TYPE g_sysdate_type IS TABLE OF
95: hri_mb_rec_vacancy_ct.CREATION_DATE %TYPE

Line 95: hri_mb_rec_vacancy_ct.CREATION_DATE %TYPE

91: hri_mb_rec_vacancy_ct.adt_vacancy_category_code%TYPE
92: INDEX BY BINARY_INTEGER;
93:
94: TYPE g_sysdate_type IS TABLE OF
95: hri_mb_rec_vacancy_ct.CREATION_DATE %TYPE
96: INDEX BY BINARY_INTEGER;
97:
98: TYPE g_user_id_type IS TABLE OF
99: hri_mb_rec_vacancy_ct.LAST_UPDATED_BY %TYPE

Line 99: hri_mb_rec_vacancy_ct.LAST_UPDATED_BY %TYPE

95: hri_mb_rec_vacancy_ct.CREATION_DATE %TYPE
96: INDEX BY BINARY_INTEGER;
97:
98: TYPE g_user_id_type IS TABLE OF
99: hri_mb_rec_vacancy_ct.LAST_UPDATED_BY %TYPE
100: INDEX BY BINARY_INTEGER;
101:
102:
103: --

Line 161: g_target_table VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';

157: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date
158: -- @@ change param1/2 to be the concurrent program short name,
159: -- @@ and the target table name respectively.
160: --
161: g_target_table VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';
162: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';
163: --
164: -- @@ Code specific to this view/table below ENDS
165: --

Line 162: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';

158: -- @@ change param1/2 to be the concurrent program short name,
159: -- @@ and the target table name respectively.
160: --
161: g_target_table VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';
162: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';
163: --
164: -- @@ Code specific to this view/table below ENDS
165: --
166: -- constants that hold the value that indicates to full refresh or not.

Line 233: INSERT INTO hri_mb_rec_vacancy_ct

229: -- @@ statement below.
230: -- @@ 2/ Prefix each column in the VALUE clause with g_
231: -- @@ 3/ make sure (i) is at the end of each column in the value clause
232: --
233: INSERT INTO hri_mb_rec_vacancy_ct
234: (pos_position_fk
235: ,rvac_vacncy_fk
236: ,org_organztn_fk
237: ,org_organztn_mrgd_fk

Line 329: INSERT INTO hri_mb_rec_vacancy_ct

325: -- @@ 2/ Prefix each column in the VALUE clause with g_
326: -- @@ 3/ make sure (i) is at the end of each column in the value clause
327: --
328: FORALL i IN 1..p_stored_rows_to_insert
329: INSERT INTO hri_mb_rec_vacancy_ct
330: (pos_position_fk
331: ,rvac_vacncy_fk
332: ,org_organztn_fk
333: ,org_organztn_mrgd_fk

Line 421: INSERT INTO hri_mb_rec_vacancy_ct

417: -- Insert completly new rows
418: --
419: -- log('Doing insert.');
420:
421: INSERT INTO hri_mb_rec_vacancy_ct
422: (pos_position_fk
423: ,rvac_vacncy_fk
424: ,org_organztn_fk
425: ,org_organztn_mrgd_fk

Line 485: FROM hri_mb_rec_vacancy_ct tbl

481: ,per_requisitions req
482: WHERE vac.last_update_date BETWEEN g_start_date AND g_end_date
483: AND vac.requisition_id = req.requisition_id
484: AND NOT EXISTS (SELECT 'x'
485: FROM hri_mb_rec_vacancy_ct tbl
486: WHERE vac.vacancy_id = tbl.rvac_vacncy_fk);
487:
488:
489:

Line 494: UPDATE hri_mb_rec_vacancy_ct tbl

490: -- log('Insert >'||TO_CHAR(sql%rowcount));
491: -- log('Doing update.');
492: --
493:
494: UPDATE hri_mb_rec_vacancy_ct tbl
495: SET (pos_position_fk
496: ,rvac_vacncy_fk
497: ,org_organztn_fk
498: ,org_organztn_mrgd_fk

Line 574: FROM hri_mb_rec_vacancy_ct tbl

570: --
571: -- log('Doing delete.');
572:
573: DELETE
574: FROM hri_mb_rec_vacancy_ct tbl
575: WHERE tbl.rvac_vacncy_fk > 0
576: AND NOT EXISTS
577: (SELECT 'x'
578: FROM per_all_vacancies vac

Line 666: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_VACANCY_CT_WHO DISABLE');

662: -- log('truncateed ...');
663:
664: --Disable WHO TRIGGERS on table prior to full refresh
665:
666: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_VACANCY_CT_WHO DISABLE');
667:
668: -- Drop all the INDEXES on the table
669: hri_utl_ddl.log_and_drop_indexes
670: (p_application_short_name => 'HRI',

Line 671: p_table_name => 'HRI_MB_REC_VACANCY_CT',

667:
668: -- Drop all the INDEXES on the table
669: hri_utl_ddl.log_and_drop_indexes
670: (p_application_short_name => 'HRI',
671: p_table_name => 'HRI_MB_REC_VACANCY_CT',
672: p_table_owner => g_schema);
673:
674:
675: --Disable INDEX on table prior to full refresh

Line 782: insert into hri_mb_rec_vacancy_ct

778: CLOSE source_view_csr;
779: --
780: -- Insert an Unassigned Row.
781: --
782: insert into hri_mb_rec_vacancy_ct
783: ( time_day_vac_strt_fk
784: ,vac_strt_date
785: ,time_day_vac_end_fk
786: ,per_person_recr_fk

Line 839: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_VACANCY_CT_WHO ENABLE');

835:
836:
837: --Enable WHO TRIGGERS
838:
839: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_REC_VACANCY_CT_WHO ENABLE');
840:
841: --Enable INDEX
842:
843: hri_utl_ddl.recreate_indexes

Line 845: p_table_name => 'HRI_MB_REC_VACANCY_CT',

841: --Enable INDEX
842:
843: hri_utl_ddl.recreate_indexes
844: (p_application_short_name => 'HRI',
845: p_table_name => 'HRI_MB_REC_VACANCY_CT',
846: p_table_owner => g_schema);
847:
848: -- log('End ...');
849: EXCEPTION

Line 930: FROM hri_mb_rec_vacancy_ct;

926: -- @@ target table.
927: --
928: CURSOR csr_recs_exist IS
929: SELECT 'x'
930: FROM hri_mb_rec_vacancy_ct;
931: --
932: -- @@ Code specific to this view/table ENDS
933: --
934: l_exists_chr VARCHAR2(1);

Line 1118: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');

1114: -- Set parameters
1115: --
1116: l_full_refresh := hri_oltp_conc_param.get_parameter_value
1117: (p_parameter_name => 'FULL_REFRESH',
1118: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');
1119: --
1120: -- Set the refresh start date
1121: --
1122: IF (l_full_refresh = 'Y') THEN

Line 1125: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');

1121: --
1122: IF (l_full_refresh = 'Y') THEN
1123: l_start_date := hri_oltp_conc_param.get_parameter_value
1124: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1125: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');
1126: ELSE
1127: l_start_date := fnd_date.date_to_canonical
1128: (fnd_date.displaydt_to_date
1129: (hri_bpl_conc_log.get_last_collect_to_date

Line 1130: ('HRI_MB_REC_VACANCY_CT','HRI_MB_REC_VACANCY_CT')));

1126: ELSE
1127: l_start_date := fnd_date.date_to_canonical
1128: (fnd_date.displaydt_to_date
1129: (hri_bpl_conc_log.get_last_collect_to_date
1130: ('HRI_MB_REC_VACANCY_CT','HRI_MB_REC_VACANCY_CT')));
1131: END IF;
1132:
1133: load(p_chunk_size => to_number(null),
1134: p_start_date => l_start_date,