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
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
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.
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
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:
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
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