DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_INTERFACE_S

Line 6532: -- interface id should use sequence number from wip_interface_s

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:

Line 6533: -- wip_job_schedule_interface_s is for wjsi.group_id, and wip_interface_s is for wjsi.interface_id.

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,

Line 6534: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_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,
6538: p_organization_id => l_job_header_rec.organization_id,

Line 7336: -- interface id should use sequence number from wip_interface_s

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:

Line 7337: -- wip_job_schedule_interface_s is for wjsi.group_id, wip_interface_s is for wjsi.interface_id.

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;

Line 7338: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_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;
7342: