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_PERSON dependencies on HRI_CS_PER_PERSON_CT

Line 20: IS TABLE OF hri_cs_per_person_ct.per_work_phone%TYPE

16: --
17:
18:
19: TYPE g_per_work_phone_type
20: IS TABLE OF hri_cs_per_person_ct.per_work_phone%TYPE
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE g_per_work_location_type
24: IS TABLE OF hri_cs_per_person_ct.per_work_location%TYPE

Line 24: IS TABLE OF hri_cs_per_person_ct.per_work_location%TYPE

20: IS TABLE OF hri_cs_per_person_ct.per_work_phone%TYPE
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE g_per_work_location_type
24: IS TABLE OF hri_cs_per_person_ct.per_work_location%TYPE
25: INDEX BY BINARY_INTEGER;
26:
27: TYPE g_adt_ppf_person_id_type
28: IS TABLE OF hri_cs_per_person_ct.adt_ppf_person_id%TYPE

Line 28: IS TABLE OF hri_cs_per_person_ct.adt_ppf_person_id%TYPE

24: IS TABLE OF hri_cs_per_person_ct.per_work_location%TYPE
25: INDEX BY BINARY_INTEGER;
26:
27: TYPE g_adt_ppf_person_id_type
28: IS TABLE OF hri_cs_per_person_ct.adt_ppf_person_id%TYPE
29: INDEX BY BINARY_INTEGER;
30:
31: TYPE g_adt_ppf_eff_start_date_type
32: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_start_date%TYPE

Line 32: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_start_date%TYPE

28: IS TABLE OF hri_cs_per_person_ct.adt_ppf_person_id%TYPE
29: INDEX BY BINARY_INTEGER;
30:
31: TYPE g_adt_ppf_eff_start_date_type
32: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_start_date%TYPE
33: INDEX BY BINARY_INTEGER;
34:
35: TYPE g_adt_ppf_eff_end_date_type
36: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_end_date%TYPE

Line 36: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_end_date%TYPE

32: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_start_date%TYPE
33: INDEX BY BINARY_INTEGER;
34:
35: TYPE g_adt_ppf_eff_end_date_type
36: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_end_date%TYPE
37: INDEX BY BINARY_INTEGER;
38:
39: TYPE g_per_buyer_flag_code_type
40: IS TABLE OF hri_cs_per_person_ct.per_buyer_flag_code%TYPE

Line 40: IS TABLE OF hri_cs_per_person_ct.per_buyer_flag_code%TYPE

36: IS TABLE OF hri_cs_per_person_ct.adt_ppf_effctv_end_date%TYPE
37: INDEX BY BINARY_INTEGER;
38:
39: TYPE g_per_buyer_flag_code_type
40: IS TABLE OF hri_cs_per_person_ct.per_buyer_flag_code%TYPE
41: INDEX BY BINARY_INTEGER;
42:
43: TYPE g_per_date_of_birth_type
44: IS TABLE OF hri_cs_per_person_ct.per_date_of_birth%TYPE

Line 44: IS TABLE OF hri_cs_per_person_ct.per_date_of_birth%TYPE

40: IS TABLE OF hri_cs_per_person_ct.per_buyer_flag_code%TYPE
41: INDEX BY BINARY_INTEGER;
42:
43: TYPE g_per_date_of_birth_type
44: IS TABLE OF hri_cs_per_person_ct.per_date_of_birth%TYPE
45: INDEX BY BINARY_INTEGER;
46:
47: TYPE g_per_middle_names_type
48: IS TABLE OF hri_cs_per_person_ct.per_middle_names%TYPE

Line 48: IS TABLE OF hri_cs_per_person_ct.per_middle_names%TYPE

44: IS TABLE OF hri_cs_per_person_ct.per_date_of_birth%TYPE
45: INDEX BY BINARY_INTEGER;
46:
47: TYPE g_per_middle_names_type
48: IS TABLE OF hri_cs_per_person_ct.per_middle_names%TYPE
49: INDEX BY BINARY_INTEGER;
50:
51: TYPE g_per_known_as_type
52: IS TABLE OF hri_cs_per_person_ct.per_known_as%TYPE

Line 52: IS TABLE OF hri_cs_per_person_ct.per_known_as%TYPE

48: IS TABLE OF hri_cs_per_person_ct.per_middle_names%TYPE
49: INDEX BY BINARY_INTEGER;
50:
51: TYPE g_per_known_as_type
52: IS TABLE OF hri_cs_per_person_ct.per_known_as%TYPE
53: INDEX BY BINARY_INTEGER;
54:
55: TYPE g_per_honors_type
56: IS TABLE OF hri_cs_per_person_ct.per_honors%TYPE

Line 56: IS TABLE OF hri_cs_per_person_ct.per_honors%TYPE

52: IS TABLE OF hri_cs_per_person_ct.per_known_as%TYPE
53: INDEX BY BINARY_INTEGER;
54:
55: TYPE g_per_honors_type
56: IS TABLE OF hri_cs_per_person_ct.per_honors%TYPE
57: INDEX BY BINARY_INTEGER;
58:
59: TYPE g_per_pre_name_adjunct_type
60: IS TABLE OF hri_cs_per_person_ct.per_pre_name_adjunct%TYPE

Line 60: IS TABLE OF hri_cs_per_person_ct.per_pre_name_adjunct%TYPE

56: IS TABLE OF hri_cs_per_person_ct.per_honors%TYPE
57: INDEX BY BINARY_INTEGER;
58:
59: TYPE g_per_pre_name_adjunct_type
60: IS TABLE OF hri_cs_per_person_ct.per_pre_name_adjunct%TYPE
61: INDEX BY BINARY_INTEGER;
62:
63: TYPE g_per_apl_number_type
64: IS TABLE OF hri_cs_per_person_ct.per_apl_number%TYPE

Line 64: IS TABLE OF hri_cs_per_person_ct.per_apl_number%TYPE

60: IS TABLE OF hri_cs_per_person_ct.per_pre_name_adjunct%TYPE
61: INDEX BY BINARY_INTEGER;
62:
63: TYPE g_per_apl_number_type
64: IS TABLE OF hri_cs_per_person_ct.per_apl_number%TYPE
65: INDEX BY BINARY_INTEGER;
66:
67: TYPE g_per_emp_number_type
68: IS TABLE OF hri_cs_per_person_ct.per_emp_number%TYPE

Line 68: IS TABLE OF hri_cs_per_person_ct.per_emp_number%TYPE

64: IS TABLE OF hri_cs_per_person_ct.per_apl_number%TYPE
65: INDEX BY BINARY_INTEGER;
66:
67: TYPE g_per_emp_number_type
68: IS TABLE OF hri_cs_per_person_ct.per_emp_number%TYPE
69: INDEX BY BINARY_INTEGER;
70:
71: TYPE g_per_cwk_number_type
72: IS TABLE OF hri_cs_per_person_ct.per_cwk_number%TYPE

Line 72: IS TABLE OF hri_cs_per_person_ct.per_cwk_number%TYPE

68: IS TABLE OF hri_cs_per_person_ct.per_emp_number%TYPE
69: INDEX BY BINARY_INTEGER;
70:
71: TYPE g_per_cwk_number_type
72: IS TABLE OF hri_cs_per_person_ct.per_cwk_number%TYPE
73: INDEX BY BINARY_INTEGER;
74:
75: TYPE g_per_apl_flag_crnt_code_type
76: IS TABLE OF hri_cs_per_person_ct.per_apl_flag_crnt_code%TYPE

Line 76: IS TABLE OF hri_cs_per_person_ct.per_apl_flag_crnt_code%TYPE

72: IS TABLE OF hri_cs_per_person_ct.per_cwk_number%TYPE
73: INDEX BY BINARY_INTEGER;
74:
75: TYPE g_per_apl_flag_crnt_code_type
76: IS TABLE OF hri_cs_per_person_ct.per_apl_flag_crnt_code%TYPE
77: INDEX BY BINARY_INTEGER;
78:
79:
80: TYPE g_per_emp_flag_crnt_code_type

Line 81: IS TABLE OF hri_cs_per_person_ct.per_emp_flag_crnt_code%TYPE

77: INDEX BY BINARY_INTEGER;
78:
79:
80: TYPE g_per_emp_flag_crnt_code_type
81: IS TABLE OF hri_cs_per_person_ct.per_emp_flag_crnt_code%TYPE
82: INDEX BY BINARY_INTEGER;
83:
84:
85: TYPE g_per_cwk_flag_crnt_code_type

Line 86: IS TABLE OF hri_cs_per_person_ct.per_cwk_flag_crnt_code%TYPE

82: INDEX BY BINARY_INTEGER;
83:
84:
85: TYPE g_per_cwk_flag_crnt_code_type
86: IS TABLE OF hri_cs_per_person_ct.per_cwk_flag_crnt_code%TYPE
87: INDEX BY BINARY_INTEGER;
88:
89: TYPE g_per_person_name_lcl_type
90: IS TABLE OF hri_cs_per_person_ct.per_person_name_lcl%TYPE

Line 90: IS TABLE OF hri_cs_per_person_ct.per_person_name_lcl%TYPE

86: IS TABLE OF hri_cs_per_person_ct.per_cwk_flag_crnt_code%TYPE
87: INDEX BY BINARY_INTEGER;
88:
89: TYPE g_per_person_name_lcl_type
90: IS TABLE OF hri_cs_per_person_ct.per_person_name_lcl%TYPE
91: INDEX BY BINARY_INTEGER;
92:
93: TYPE g_per_first_name_type
94: IS TABLE OF hri_cs_per_person_ct.per_first_name%TYPE

Line 94: IS TABLE OF hri_cs_per_person_ct.per_first_name%TYPE

90: IS TABLE OF hri_cs_per_person_ct.per_person_name_lcl%TYPE
91: INDEX BY BINARY_INTEGER;
92:
93: TYPE g_per_first_name_type
94: IS TABLE OF hri_cs_per_person_ct.per_first_name%TYPE
95: INDEX BY BINARY_INTEGER;
96:
97: TYPE g_per_place_of_birth_type
98: IS TABLE OF hri_cs_per_person_ct.per_place_of_birth%TYPE

Line 98: IS TABLE OF hri_cs_per_person_ct.per_place_of_birth%TYPE

94: IS TABLE OF hri_cs_per_person_ct.per_first_name%TYPE
95: INDEX BY BINARY_INTEGER;
96:
97: TYPE g_per_place_of_birth_type
98: IS TABLE OF hri_cs_per_person_ct.per_place_of_birth%TYPE
99: INDEX BY BINARY_INTEGER;
100:
101: TYPE g_per_last_name_prev_type
102: IS TABLE OF hri_cs_per_person_ct.per_last_name_prev%TYPE

Line 102: IS TABLE OF hri_cs_per_person_ct.per_last_name_prev%TYPE

98: IS TABLE OF hri_cs_per_person_ct.per_place_of_birth%TYPE
99: INDEX BY BINARY_INTEGER;
100:
101: TYPE g_per_last_name_prev_type
102: IS TABLE OF hri_cs_per_person_ct.per_last_name_prev%TYPE
103: INDEX BY BINARY_INTEGER;
104:
105: TYPE g_per_order_by_type
106: IS TABLE OF hri_cs_per_person_ct.per_order_by%TYPE

Line 106: IS TABLE OF hri_cs_per_person_ct.per_order_by%TYPE

102: IS TABLE OF hri_cs_per_person_ct.per_last_name_prev%TYPE
103: INDEX BY BINARY_INTEGER;
104:
105: TYPE g_per_order_by_type
106: IS TABLE OF hri_cs_per_person_ct.per_order_by%TYPE
107: INDEX BY BINARY_INTEGER;
108:
109: TYPE g_per_person_name_gbl_type
110: IS TABLE OF hri_cs_per_person_ct.per_person_name_gbl%TYPE

Line 110: IS TABLE OF hri_cs_per_person_ct.per_person_name_gbl%TYPE

106: IS TABLE OF hri_cs_per_person_ct.per_order_by%TYPE
107: INDEX BY BINARY_INTEGER;
108:
109: TYPE g_per_person_name_gbl_type
110: IS TABLE OF hri_cs_per_person_ct.per_person_name_gbl%TYPE
111: INDEX BY BINARY_INTEGER;
112:
113: TYPE g_per_last_name_type
114: IS TABLE OF hri_cs_per_person_ct.per_last_name%TYPE

Line 114: IS TABLE OF hri_cs_per_person_ct.per_last_name%TYPE

110: IS TABLE OF hri_cs_per_person_ct.per_person_name_gbl%TYPE
111: INDEX BY BINARY_INTEGER;
112:
113: TYPE g_per_last_name_type
114: IS TABLE OF hri_cs_per_person_ct.per_last_name%TYPE
115: INDEX BY BINARY_INTEGER;
116:
117: TYPE g_per_wrkr_crnt_flag_code_type
118: IS TABLE OF hri_cs_per_person_ct.per_worker_crnt_flag_code%TYPE

Line 118: IS TABLE OF hri_cs_per_person_ct.per_worker_crnt_flag_code%TYPE

114: IS TABLE OF hri_cs_per_person_ct.per_last_name%TYPE
115: INDEX BY BINARY_INTEGER;
116:
117: TYPE g_per_wrkr_crnt_flag_code_type
118: IS TABLE OF hri_cs_per_person_ct.per_worker_crnt_flag_code%TYPE
119: INDEX BY BINARY_INTEGER;
120:
121: TYPE g_per_country_of_birth_type
122: IS TABLE OF hri_cs_per_person_ct.per_country_of_birth%TYPE

Line 122: IS TABLE OF hri_cs_per_person_ct.per_country_of_birth%TYPE

118: IS TABLE OF hri_cs_per_person_ct.per_worker_crnt_flag_code%TYPE
119: INDEX BY BINARY_INTEGER;
120:
121: TYPE g_per_country_of_birth_type
122: IS TABLE OF hri_cs_per_person_ct.per_country_of_birth%TYPE
123: INDEX BY BINARY_INTEGER;
124:
125: TYPE g_per_date_of_death_type
126: IS TABLE OF hri_cs_per_person_ct.per_date_of_death%TYPE

Line 126: IS TABLE OF hri_cs_per_person_ct.per_date_of_death%TYPE

122: IS TABLE OF hri_cs_per_person_ct.per_country_of_birth%TYPE
123: INDEX BY BINARY_INTEGER;
124:
125: TYPE g_per_date_of_death_type
126: IS TABLE OF hri_cs_per_person_ct.per_date_of_death%TYPE
127: INDEX BY BINARY_INTEGER;
128:
129: TYPE g_per_work_email_type
130: IS TABLE OF hri_cs_per_person_ct.per_work_email%TYPE

Line 130: IS TABLE OF hri_cs_per_person_ct.per_work_email%TYPE

126: IS TABLE OF hri_cs_per_person_ct.per_date_of_death%TYPE
127: INDEX BY BINARY_INTEGER;
128:
129: TYPE g_per_work_email_type
130: IS TABLE OF hri_cs_per_person_ct.per_work_email%TYPE
131: INDEX BY BINARY_INTEGER;
132:
133: TYPE g_per_title_type
134: IS TABLE OF hri_cs_per_person_ct.per_title%TYPE

Line 134: IS TABLE OF hri_cs_per_person_ct.per_title%TYPE

130: IS TABLE OF hri_cs_per_person_ct.per_work_email%TYPE
131: INDEX BY BINARY_INTEGER;
132:
133: TYPE g_per_title_type
134: IS TABLE OF hri_cs_per_person_ct.per_title%TYPE
135: INDEX BY BINARY_INTEGER;
136:
137: TYPE g_per_suffix_type
138: IS TABLE OF hri_cs_per_person_ct.per_suffix%TYPE

Line 138: IS TABLE OF hri_cs_per_person_ct.per_suffix%TYPE

134: IS TABLE OF hri_cs_per_person_ct.per_title%TYPE
135: INDEX BY BINARY_INTEGER;
136:
137: TYPE g_per_suffix_type
138: IS TABLE OF hri_cs_per_person_ct.per_suffix%TYPE
139: INDEX BY BINARY_INTEGER;
140:
141: TYPE g_per_person_name_type
142: IS TABLE OF hri_cs_per_person_ct.per_person_name%TYPE

Line 142: IS TABLE OF hri_cs_per_person_ct.per_person_name%TYPE

138: IS TABLE OF hri_cs_per_person_ct.per_suffix%TYPE
139: INDEX BY BINARY_INTEGER;
140:
141: TYPE g_per_person_name_type
142: IS TABLE OF hri_cs_per_person_ct.per_person_name%TYPE
143: INDEX BY BINARY_INTEGER;
144:
145: TYPE g_per_person_pk_type
146: IS TABLE OF hri_cs_per_person_ct.per_person_pk%TYPE

Line 146: IS TABLE OF hri_cs_per_person_ct.per_person_pk%TYPE

142: IS TABLE OF hri_cs_per_person_ct.per_person_name%TYPE
143: INDEX BY BINARY_INTEGER;
144:
145: TYPE g_per_person_pk_type
146: IS TABLE OF hri_cs_per_person_ct.per_person_pk%TYPE
147: INDEX BY BINARY_INTEGER;
148:
149: TYPE g_per_marital_status_crnt_type
150: IS TABLE OF hri_cs_per_person_ct.per_marital_status_crnt%TYPE

Line 150: IS TABLE OF hri_cs_per_person_ct.per_marital_status_crnt%TYPE

146: IS TABLE OF hri_cs_per_person_ct.per_person_pk%TYPE
147: INDEX BY BINARY_INTEGER;
148:
149: TYPE g_per_marital_status_crnt_type
150: IS TABLE OF hri_cs_per_person_ct.per_marital_status_crnt%TYPE
151: INDEX BY BINARY_INTEGER;
152:
153: TYPE g_per_gender_crnt_type
154: IS TABLE OF hri_cs_per_person_ct.per_gender_crnt%TYPE

Line 154: IS TABLE OF hri_cs_per_person_ct.per_gender_crnt%TYPE

150: IS TABLE OF hri_cs_per_person_ct.per_marital_status_crnt%TYPE
151: INDEX BY BINARY_INTEGER;
152:
153: TYPE g_per_gender_crnt_type
154: IS TABLE OF hri_cs_per_person_ct.per_gender_crnt%TYPE
155: INDEX BY BINARY_INTEGER;
156:
157:
158:

Line 231: g_target_table VARCHAR2(30) DEFAULT 'hri_cs_per_person_ct';

227: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date
228: -- @@ change param1/2 to be the concurrent program short name,
229: -- @@ and the target table name respectively.
230: --
231: g_target_table VARCHAR2(30) DEFAULT 'hri_cs_per_person_ct';
232: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRI_CS_PER_PERSON_CT';
233: --
234: -- @@ Code specific to this view/table below ENDS
235: --

Line 232: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRI_CS_PER_PERSON_CT';

228: -- @@ change param1/2 to be the concurrent program short name,
229: -- @@ and the target table name respectively.
230: --
231: g_target_table VARCHAR2(30) DEFAULT 'hri_cs_per_person_ct';
232: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRI_CS_PER_PERSON_CT';
233: --
234: -- @@ Code specific to this view/table below ENDS
235: --
236: -- constants that hold the value that indicates to full refresh or not.

Line 311: INSERT INTO hri_cs_per_person_ct(

307: -- @@ 2/ Prefix each column in the VALUE clause with g_
308: -- @@ 3/ make sure (i) is at the end of each column in the value clause
309: --
310:
311: INSERT INTO hri_cs_per_person_ct(
312: per_work_phone
313: ,per_work_location
314: ,adt_ppf_person_id
315: ,adt_ppf_effctv_start_date

Line 422: INSERT INTO hri_cs_per_person_ct(

418: -- @@ 2/ Prefix each column in the VALUE clause with g_
419: -- @@ 3/ make sure (i) is at the end of each column in the value clause
420: --
421: FORALL i IN 1..p_stored_rows_to_insert
422: INSERT INTO hri_cs_per_person_ct(
423: per_work_phone
424: ,per_work_location
425: ,adt_ppf_person_id
426: ,adt_ppf_effctv_start_date

Line 532: INSERT INTO hri_cs_per_person_ct(

528: -- Insert completly new rows
529: --
530: -- log('Doing insert.');
531:
532: INSERT INTO hri_cs_per_person_ct(
533: per_work_phone
534: ,per_work_location
535: ,adt_ppf_person_id
536: ,adt_ppf_effctv_start_date

Line 617: FROM hri_cs_per_person_ct tbl

613: ,po_agents poa
614: WHERE per.person_id = poa.agent_id(+)
615: AND TRUNC(sysdate) between per.effective_start_date and per.effective_end_date
616: AND NOT EXISTS (SELECT 'x'
617: FROM hri_cs_per_person_ct tbl
618: WHERE per.person_id = tbl.per_person_pk
619: );
620:
621: -- log('Insert >'||TO_CHAR(sql%rowcount));

Line 630: UPDATE hri_cs_per_person_ct tbl

626: --Nos of DB writes is limited to the rows changed only.
627: --------------------------------------------------------
628:
629:
630: UPDATE hri_cs_per_person_ct tbl
631: SET (per_buyer_flag_code) = (decode(tbl.per_buyer_flag_code, 'Y', 'N', 'Y'))
632: WHERE tbl.per_person_pk in
633: (SELECT ct.per_person_pk person_id
634: FROM (SELECT tbl.per_person_pk,

Line 647: FROM hri_cs_per_person_ct tbl, po_agents poa

643: )
644: then 'Y'
645: else 'N'
646: end buyer_flag
647: FROM hri_cs_per_person_ct tbl, po_agents poa
648: WHERE tbl.per_person_pk = poa.agent_id(+)
649: )ct
650: WHERE ct.buyer_flag <> ct.collected_flag
651: );

Line 656: UPDATE hri_cs_per_person_ct tbl

652:
653:
654: -- Update CT with PAPF attribs
655:
656: UPDATE hri_cs_per_person_ct tbl
657: SET ( per_work_phone
658: ,per_work_location
659: ,adt_ppf_person_id
660: ,adt_ppf_effctv_start_date

Line 744: FROM hri_cs_per_person_ct tbl

740: -- log('Doing delete.');
741:
742:
743: DELETE
744: FROM hri_cs_per_person_ct tbl
745: WHERE NOT EXISTS (SELECT 'x'
746: FROM per_all_people_f per
747: WHERE per.person_id = tbl.per_person_pk
748: AND TRUNC(sysdate) BETWEEN

Line 859: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_PER_PERSON_CT_WHO DISABLE');

855:
856:
857: --Disable WHO TRIGGERS on table prior to full refresh
858:
859: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_PER_PERSON_CT_WHO DISABLE');
860:
861: -- Drop all the INDEXES on the table
862: hri_utl_ddl.log_and_drop_indexes
863: (p_application_short_name => 'HRI',

Line 864: p_table_name => 'HRI_CS_PER_PERSON_CT',

860:
861: -- Drop all the INDEXES on the table
862: hri_utl_ddl.log_and_drop_indexes
863: (p_application_short_name => 'HRI',
864: p_table_name => 'HRI_CS_PER_PERSON_CT',
865: p_table_owner => g_schema);
866:
867:
868:

Line 873: insert into hri_cs_per_person_ct(

869: --
870: --Create an Unassigned row
871: --
872:
873: insert into hri_cs_per_person_ct(
874: PER_PERSON_PK
875: ,PER_PERSON_NAME
876: ,PER_ORDER_BY
877: ,PER_PERSON_NAME_GBL

Line 1056: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_PER_PERSON_CT_WHO ENABLE');

1052: CLOSE source_view_csr;
1053:
1054: --Enable WHO TRIGGERS
1055:
1056: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_PER_PERSON_CT_WHO ENABLE');
1057:
1058: --Enable INDEX
1059:
1060: hri_utl_ddl.recreate_indexes

Line 1062: p_table_name => 'HRI_CS_PER_PERSON_CT',

1058: --Enable INDEX
1059:
1060: hri_utl_ddl.recreate_indexes
1061: (p_application_short_name => 'HRI',
1062: p_table_name => 'HRI_CS_PER_PERSON_CT',
1063: p_table_owner => g_schema);
1064:
1065: --
1066: -- log('End ...');

Line 1150: FROM hri_cs_per_person_ct;

1146: -- @@ target table.
1147: --
1148: CURSOR csr_recs_exist IS
1149: SELECT 'x'
1150: FROM hri_cs_per_person_ct;
1151: --
1152: -- @@ Code specific to this view/table ENDS
1153: --
1154: l_exists_chr VARCHAR2(1);