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.HZ_IMP_LOAD_WRAPPER dependencies on FND_STATS

Line 3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');

3940: -- Analyze interface tables
3941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze all interface tables ' ||
3942: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');

Line 3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');

3941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze all interface tables ' ||
3942: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');

Line 3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');

3942: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');

Line 3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');

3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');

Line 3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');

3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');

Line 3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');

3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');

Line 3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');

3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');

Line 3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');

3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;

Line 3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');

3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;
3956:

Line 3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');

3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;
3956:
3957: /* Stage 1 preprocess before calling parties matching */

Line 3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');

3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;
3956:
3957: /* Stage 1 preprocess before calling parties matching */
3958: IF P_RERUN_FLAG = 'U' OR P_RERUN_FLAG = 'L' THEN

Line 4037: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_SG', percent=>10, degree=>4);

4033: IF P_BATCH_MODE_FLAG = 'Y' THEN
4034: -- Analyze parties staging after matching
4035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze party staging table ' ||
4036: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4037: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_SG', percent=>10, degree=>4);
4038: END IF;
4039:
4040: elsif (stage=3) then
4041: FND_FILE.PUT_LINE(FND_FILE.LOG, '****** Finished processing stage 2 ');

Line 4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);

4046: IF P_BATCH_MODE_FLAG = 'Y' THEN
4047: -- Analyze staging table after matching
4048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze other entity staging tables ' ||
4049: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);

Line 4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);

4047: -- Analyze staging table after matching
4048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze other entity staging tables ' ||
4049: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);

Line 4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);

4048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Analyze other entity staging tables ' ||
4049: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);

Line 4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);

4049: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);

Line 4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);

4050: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_SG', percent=>5, degree=>4);
4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);

Line 4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);

4051: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_SG', percent=>5, degree=>4);
4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);

Line 4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);

4052: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_SG', percent=>5, degree=>4);
4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);

Line 4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);

4053: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_SG', percent=>5, degree=>4);
4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;

Line 4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);

4054: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_SG', percent=>5, degree=>4);
4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:

Line 4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);

4055: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_SG', percent=>5, degree=>4);
4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:
4063: -- get the start error_id sequence number

Line 4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);

4056: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_SG', percent=>5, degree=>4);
4057: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_SG', percent=>5, degree=>4);
4058: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_SG', percent=>5, degree=>4);
4059: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_SG', percent=>5, degree=>4);
4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:
4063: -- get the start error_id sequence number
4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;