DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_WRAPPER dependencies on STANDARD

Line 556: /* Wallace: remove alter cache size to be compilant with standard.

552: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s increment by 2';
553: execute immediate 'alter sequence ' || l_schema || '.hz_party_usg_assignments_s increment by 2';
554:
555: /* Alter sequence only for batch mode */
556: /* Wallace: remove alter cache size to be compilant with standard.
557: alter cache size before run instead
558: IF P_BATCH_MODE_FLAG = 'Y' THEN
559: execute immediate 'alter sequence ' || l_schema || '.hz_code_assignments_s cache 20000';
560: execute immediate 'alter sequence ' || l_schema || '.hz_contact_numbers_s cache 20000';