APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 9: hz_imp_batch_summary_v2pub.activate_batch().

5: These are the counts of each entity before running
6: the dataload process. This procedure also initializes
7: the post count columns to zero.
8: This procedure is called from
9: hz_imp_batch_summary_v2pub.activate_batch().
10: The above API is called from teh last stage of DNB adapter.
11: */
12:
13: PROCEDURE pre_import_counts

Line 14: ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,

10: The above API is called from teh last stage of DNB adapter.
11: */
12:
13: PROCEDURE pre_import_counts
14: ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
15: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE) IS
16: -- Declare the variables
17: l_ADDRESSUSES_IN_BATCH NUMBER;
18: l_ADDRESSES_IN_BATCH NUMBER;

Line 15: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE) IS

11: */
12:
13: PROCEDURE pre_import_counts
14: ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
15: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE) IS
16: -- Declare the variables
17: l_ADDRESSUSES_IN_BATCH NUMBER;
18: l_ADDRESSES_IN_BATCH NUMBER;
19: l_FINNUMBERS_IN_BATCH NUMBER;

Line 88: UPDATE HZ_IMP_BATCH_SUMMARY SET

84: l_CREDITRATINGS_IN_BATCH +
85: l_FINREPORTS_IN_BATCH +
86: l_PARTIES_IN_BATCH ;
87:
88: UPDATE HZ_IMP_BATCH_SUMMARY SET
89: ADDRESSUSES_IN_BATCH = l_ADDRESSUSES_IN_BATCH,
90: ADDRESSES_IN_BATCH = l_ADDRESSES_IN_BATCH,
91: FINNUMBERS_IN_BATCH = l_FINNUMBERS_IN_BATCH,
92: CODEASSIGNS_IN_BATCH = l_CODEASSIGNS_IN_BATCH,

Line 153: (P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,

149: This procedure is called from within the dataload process.
150: */
151:
152: procedure post_import_counts
153: (P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
154: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE,
155: P_BATCH_MODE_FLAG in VARCHAR2,
156: P_REQUEST_ID IN NUMBER,
157: P_RERUN_FLAG IN VARCHAR2) IS -- N for First Run any other value is rerun

Line 154: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE,

150: */
151:
152: procedure post_import_counts
153: (P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
154: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE,
155: P_BATCH_MODE_FLAG in VARCHAR2,
156: P_REQUEST_ID IN NUMBER,
157: P_RERUN_FLAG IN VARCHAR2) IS -- N for First Run any other value is rerun
158:

Line 476: update hz_imp_batch_summary set

472: and batch_mode_flag=p_batch_mode_flag;
473: END IF;
474: END IF;
475:
476: update hz_imp_batch_summary set
477: addressuses_inserted = addressuses_inserted + l_addressuses_inserted,
478: addressuses_updated = addressuses_updated + l_addressuses_updated,
479: addressuses_imported = addressuses_imported + l_addressuses_inserted + l_addressuses_updated,
480: addresses_inserted = addresses_inserted + l_addresses_inserted,

Line 560: UPDATE HZ_IMP_BATCH_SUMMARY SET

556: -- with all the counts. Also, initializing the merge counts to zero so that
557: -- if and when DQM populates them, the merge counts will have appropriate values
558: -- otherwise, they will show zeros.
559:
560: UPDATE HZ_IMP_BATCH_SUMMARY SET
561: ADDRESSUSES_INSERTED = ADDRESSUSES_INSERTED + l_ADDRESSUSES_INSERTED,
562: ADDRESSUSES_UPDATED = ADDRESSUSES_UPDATED + l_ADDRESSUSES_UPDATED,
563: ADDRESSUSES_IMPORTED = ADDRESSUSES_IMPORTED + l_ADDRESSUSES_IMPORTED,
564: ADDRESSES_INSERTED = ADDRESSES_INSERTED + l_ADDRESSES_INSERTED,

Line 616: ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,

612: when teh what_IF option is chosen.
613: */
614:
615: PROCEDURE what_if_import_counts
616: ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
617: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE) IS
618: -- Declare the variables
619: l_NEW_UNIQUE_ADDRESSUSES NUMBER;
620: l_NEW_UNIQUE_ADDRESSES NUMBER;

Line 617: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE) IS

613: */
614:
615: PROCEDURE what_if_import_counts
616: ( P_BATCH_ID IN HZ_IMP_BATCH_SUMMARY.BATCH_ID%TYPE,
617: P_ORIGINAL_SYSTEM IN HZ_IMP_BATCH_SUMMARY.ORIGINAL_SYSTEM%TYPE) IS
618: -- Declare the variables
619: l_NEW_UNIQUE_ADDRESSUSES NUMBER;
620: l_NEW_UNIQUE_ADDRESSES NUMBER;
621: l_NEW_UNIQUE_FINNUMBERS NUMBER;

Line 874: UPDATE HZ_IMP_BATCH_SUMMARY SET

870: l_REMOVED_FINREPORTS +
871: l_REMOVED_PARTIES ;
872:
873: -- update stmt
874: UPDATE HZ_IMP_BATCH_SUMMARY SET
875: NEW_UNIQUE_ADDRESSUSES = l_NEW_UNIQUE_ADDRESSUSES,
876: NEW_UNIQUE_ADDRESSES = l_NEW_UNIQUE_ADDRESSES,
877: NEW_UNIQUE_FINNUMBERS = l_NEW_UNIQUE_FINNUMBERS,
878: NEW_UNIQUE_CODEASSIGNS = l_NEW_UNIQUE_CODEASSIGNS,