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.PN_SOI_VOL_IMPORT dependencies on PN_VAR_VOL_ARCH_ALL

Line 17: -- pn_var_vol_arch_all and pn_var_deduct_arch_all.

13: -- reporttype and insert into pn_var_vol_hist_all
14: -- 15-JAN-07 Prabhakar o Modified the import_vol_hist procedure to update the
15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.
16: -- Before updating, the old records will be inserted into
17: -- pn_var_vol_arch_all and pn_var_deduct_arch_all.
18: -- 12-mar-07 Shabda o After we have updated volume history. We set the
19: -- pn_var_lines_all.sales-Vol_update_flag to Y for
20: -- all lines which might have been updated. Bug 5915771
21: -------------------------------------------------------------------------------

Line 753: INSERT INTO PN_VAR_VOL_ARCH_ALL(

749: l_reporting_date <> v_lines.reporting_date THEN
750:
751:
752: PN_SOI_VOL_IMPORT.g_org_id := l_org_id;
753: INSERT INTO PN_VAR_VOL_ARCH_ALL(
754: VOL_ARCH_ID
755: ,LAST_UPDATE_DATE
756: ,LAST_UPDATED_BY
757: ,CREATION_DATE