APPS.AD_PATCH_HISTORY_PKG dependencies on AD_PTCH_HST_EXE_COP_TMP

Line 15: Inserts into AD_PTCH_HST_EXE_COP_TMP records of 2 kinds (viz. executed

11: NAME:
12: Procedure bld_execs_and_copy_acts_list():
13:
14: DESCRIPTION:
15: Inserts into AD_PTCH_HST_EXE_COP_TMP records of 2 kinds (viz. executed
16: copy actions and all non-copy actions) in patches that have been uploaded
17: from applptch.txt
18:
19: COLUMNS THAT MAY NEED EXPLANATION:

Line 63: l_str := 'insert into ad_ptch_hst_exe_cop_tmp '||

59: (p_min_run_date date)
60: is
61: l_str varchar2(2000);
62: begin
63: l_str := 'insert into ad_ptch_hst_exe_cop_tmp '||
64: '( '||
65: 'row_id, action, appl_top_id, run_date, '||
66: 'file_id, file_version_id, max_copy_date '||
67: ') '||

Line 140: from ad_ptch_hst_exe_cop_tmp

136: (p_min_run_date date)
137: is
138: cursor c_actions is
139: select rowidtochar(row_id)
140: from ad_ptch_hst_exe_cop_tmp
141: where max_copy_date is not null
142: and (action <> 1 or max_copy_date <> run_date);
143:
144: type T_ROWID is varray(1000) of varchar2(18);

Line 181: INDEX (AD_PTCH_HST_EXE_COP_TMP AD_PTCH_HST_EXE_COP_TMP_U1)

177: set prba.onsite_file_version_id =
178: (
179: select
180: /*+ USE_NL(E)
181: INDEX (AD_PTCH_HST_EXE_COP_TMP AD_PTCH_HST_EXE_COP_TMP_U1)
182: INDEX(AD_PTCH_HST_EXE_COP_TMP AD_PTCH_HST_EXE_COP_TMP_N1)
183: */
184: distinct c.file_version_id
185: -- The "distinct" isn't really necessary. The values should

Line 182: INDEX(AD_PTCH_HST_EXE_COP_TMP AD_PTCH_HST_EXE_COP_TMP_N1)

178: (
179: select
180: /*+ USE_NL(E)
181: INDEX (AD_PTCH_HST_EXE_COP_TMP AD_PTCH_HST_EXE_COP_TMP_U1)
182: INDEX(AD_PTCH_HST_EXE_COP_TMP AD_PTCH_HST_EXE_COP_TMP_N1)
183: */
184: distinct c.file_version_id
185: -- The "distinct" isn't really necessary. The values should
186: -- be the same. The distinct is just to throw up an error

Line 188: from ad_ptch_hst_exe_cop_tmp c, ad_ptch_hst_exe_cop_tmp e

184: distinct c.file_version_id
185: -- The "distinct" isn't really necessary. The values should
186: -- be the same. The distinct is just to throw up an error
187: -- if they aren't the same.
188: from ad_ptch_hst_exe_cop_tmp c, ad_ptch_hst_exe_cop_tmp e
189: where e.row_id = chartorowid(l_rowid(l_row))
190: and e.appl_top_id = c.appl_top_id
191: and e.file_id = c.file_id
192: and c.action = 1