DBA Data[Home] [Help]

APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_TRX_PKG

Line 190: pn_var_trx_pkg.populate_transactions(p_var_rent_id => p_var_rent_id);

186:
187: l_summ_id_tab.DELETE;
188: l_trx_id_tab.DELETE;
189:
190: pn_var_trx_pkg.populate_transactions(p_var_rent_id => p_var_rent_id);
191: pn_var_trx_pkg.populate_sales(p_var_rent_id => p_var_rent_id);
192:
193: IF var_rent_rec.invoice_on = 'FORECASTED' THEN
194:

Line 191: pn_var_trx_pkg.populate_sales(p_var_rent_id => p_var_rent_id);

187: l_summ_id_tab.DELETE;
188: l_trx_id_tab.DELETE;
189:
190: pn_var_trx_pkg.populate_transactions(p_var_rent_id => p_var_rent_id);
191: pn_var_trx_pkg.populate_sales(p_var_rent_id => p_var_rent_id);
192:
193: IF var_rent_rec.invoice_on = 'FORECASTED' THEN
194:
195: /* after populating the sales, sales_vol_update_flag becomes NULL.

Line 201: pn_var_trx_pkg.populate_sales_for(p_var_rent_id => p_var_rent_id);

197: UPDATE pn_var_lines_all
198: SET sales_vol_update_flag = 'Y'
199: WHERE var_rent_id = p_var_rent_id;
200:
201: pn_var_trx_pkg.populate_sales_for(p_var_rent_id => p_var_rent_id);
202:
203: END IF;
204:
205: /* Fetch the mapping of trx headers and summary records */