2128: -- Standard Start of API savepoint
2129: SAVEPOINT populate_results_savepoint;
2130:
2131: -- Convert the dates for the varchar2 parameters passed in from concurrent program
2132: p_start_date := fnd_date.canonical_to_date(pp_start_date);
2133: p_end_date := fnd_date.canonical_to_date(pp_end_date);
2134:
2135: SELECT cn_sca_logical_batches_s.NEXTVAL
2136: INTO l_create_logical_batch_id
2129: SAVEPOINT populate_results_savepoint;
2130:
2131: -- Convert the dates for the varchar2 parameters passed in from concurrent program
2132: p_start_date := fnd_date.canonical_to_date(pp_start_date);
2133: p_end_date := fnd_date.canonical_to_date(pp_end_date);
2134:
2135: SELECT cn_sca_logical_batches_s.NEXTVAL
2136: INTO l_create_logical_batch_id
2137: FROM sys.dual;
2366: p_org_id := mo_global.get_current_org_id();
2367:
2368: -- Convert the dates for the varchar2 parameters passed in from concurrent program
2369:
2370: p_start_date := fnd_date.canonical_to_date(pp_start_date);
2371: p_end_date := fnd_date.canonical_to_date(pp_end_date);
2372:
2373: --+
2374: --+ Call begin_batch to get process_audit_id for debug log file
2367:
2368: -- Convert the dates for the varchar2 parameters passed in from concurrent program
2369:
2370: p_start_date := fnd_date.canonical_to_date(pp_start_date);
2371: p_end_date := fnd_date.canonical_to_date(pp_end_date);
2372:
2373: --+
2374: --+ Call begin_batch to get process_audit_id for debug log file
2375: --+