APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_TRX_HEADERS_ALL

Line 164: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ

160: /* Fetch the summary id and transaction id from respective tables */
161: CURSOR summ_id_cur (p_var_rent_id NUMBER) IS
162: SELECT /*+ leading(trx) */
163: summ.var_rent_summ_id, trx.trx_header_id
164: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ
165: WHERE trx.grp_date_id = summ.grp_date_id
166: AND trx.var_rent_id = p_var_rent_id;
167:
168: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE

Line 168: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE

164: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ
165: WHERE trx.grp_date_id = summ.grp_date_id
166: AND trx.var_rent_id = p_var_rent_id;
167:
168: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE
169: INDEX BY BINARY_INTEGER;
170:
171: TYPE trx_id_tab_type IS TABLE OF pn_var_trx_headers_all.trx_header_id%TYPE
172: INDEX BY BINARY_INTEGER;

Line 171: TYPE trx_id_tab_type IS TABLE OF pn_var_trx_headers_all.trx_header_id%TYPE

167:
168: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE
169: INDEX BY BINARY_INTEGER;
170:
171: TYPE trx_id_tab_type IS TABLE OF pn_var_trx_headers_all.trx_header_id%TYPE
172: INDEX BY BINARY_INTEGER;
173:
174: l_summ_id_tab summ_id_tab_type;
175: l_trx_id_tab trx_id_tab_type;

Line 212: UPDATE pn_var_trx_headers_all

208: FETCH summ_id_cur BULK COLLECT INTO l_summ_id_tab,l_trx_id_tab;
209: CLOSE summ_id_cur;
210:
211: FORALL i IN 1.. l_trx_id_tab.COUNT
212: UPDATE pn_var_trx_headers_all
213: SET var_rent_summ_id = l_summ_id_tab(i)
214: WHERE trx_header_id = l_trx_id_tab(i);
215:
216: END LOOP;