1 PACKAGE HZ_IMP_LOAD_BATCH_COUNTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLBCS.pls 120.5 2005/10/30 04:20:14 appldev noship $*/
3
4 /*
5 pre_import_counts() is being called from
6 hz_imp_batch_summary_v2pub.activate_batch ()
7 This will calculate the counts from 11 interface tables.
8 */
9
10 PROCEDURE pre_import_counts
11 ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
12 P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE);
13
14 /*
15 post_import_counts() is being called from
16 HZ_IMP_LOAD_WRAPPER package.
17 This will calculate various counts like number of inserted, updated,
18 errored entities. This is called after stage 3 is complete i.e.,
19 all the entities DML is complete.
20 */
21
22 PROCEDURE post_import_counts
23 ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
24 P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE,
25 P_BATCH_MODE_FLAG IN VARCHAR2,
26 P_REQUEST_ID IN NUMBER,
27 P_RERUN_FLAG IN VARCHAR2); -- N for First Run any other value is rerun
28
29 /*
30 what_if_import_counts() is being called from
31 HZ_IMP_LOAD_STAGE2 package.
32 This will calculate the potential new and unique counts per entity.
33 */
34
35 PROCEDURE what_if_import_counts
36 ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
37 P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE);
38
39 END HZ_IMP_LOAD_BATCH_COUNTS_PKG; -- Package spec