6528:
6529: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
6530:
6531: -- nnadig bug 9263438
6532: -- interface id should use sequence number from wip_interface_s
6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.
6534: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
6535: --l_job_header_rec.interface_id := l_job_header_rec.group_id;
6536:
6529: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
6530:
6531: -- nnadig bug 9263438
6532: -- interface id should use sequence number from wip_interface_s
6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.
6534: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
6535: --l_job_header_rec.interface_id := l_job_header_rec.group_id;
6536:
6537: generate_job_name ( p_job_prefix =>l_job_prefix,
6530:
6531: -- nnadig bug 9263438
6532: -- interface id should use sequence number from wip_interface_s
6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.
6534: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
6535: --l_job_header_rec.interface_id := l_job_header_rec.group_id;
6536:
6537: generate_job_name ( p_job_prefix =>l_job_prefix,
6538: p_organization_id => l_job_header_rec.organization_id,
7332: -- Get the Group_id to be used for WIP Create Job,
7333: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
7334:
7335: -- nnadig: bug 9263438
7336: -- interface id should use sequence number from wip_interface_s
7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.
7338: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
7339:
7340:
7333: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
7334:
7335: -- nnadig: bug 9263438
7336: -- interface id should use sequence number from wip_interface_s
7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.
7338: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
7339:
7340:
7341: --l_job_header_rec.interface_id := l_job_header_rec.group_id;
7334:
7335: -- nnadig: bug 9263438
7336: -- interface id should use sequence number from wip_interface_s
7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.
7338: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
7339:
7340:
7341: --l_job_header_rec.interface_id := l_job_header_rec.group_id;
7342: