DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on WIP_INTERFACE_S

Line 100: -- nnadig: bug 9263438 - Use wip_interface_s for interface_id, not sequence from group_id

96: l_job_header_rec.load_type := l_non_standard_load_type;
97:
98: l_job_header_rec.group_id := p_group_id;
99:
100: -- nnadig: bug 9263438 - Use wip_interface_s for interface_id, not sequence from group_id
101: -- According to wip_job_schedule_interface documentation, interface ID should be NULL
102: -- and will be populated by WIP later. However, for defaulting material, CreateOneJob
103: -- is used which requires an interface ID, so we will generate an interface ID for this
104: -- case only and pass it back to the calling procedure to use.

Line 107: SELECT wip_interface_s.NEXTVAL INTO x_interface_id FROM dual;

103: -- is used which requires an interface ID, so we will generate an interface ID for this
104: -- case only and pass it back to the calling procedure to use.
105:
106: -- end nnadig: bug 9263438
107: SELECT wip_interface_s.NEXTVAL INTO x_interface_id FROM dual;
108: l_job_header_rec.interface_id := x_interface_id;
109: -- end nnadig: bug 9263438
110:
111:

Line 1945: Use wip_interface_s for interface_id instead of wip_job_schedule_interface_s

1941: -- to the WIP API. When successfully finished, the procedure will return WIP Entity ID and Job Name
1942: -- to the calling routine.
1943: Code change history:
1944: -- 4/2/2010 120.13.12010000.3 nnadig: Bug fix 9263438,
1945: Use wip_interface_s for interface_id instead of wip_job_schedule_interface_s
1946: ***************/
1947: PROCEDURE create_job_from_estimate(
1948: p_api_version_number IN NUMBER,
1949: p_init_msg_list IN VARCHAR2 ,

Line 2093: -- Bug 9263438: Use wip_interface_s for interface_id instead of wip_job_schedule_interface_s

2089: -- Get the Group_id to be used for WIP Create Job,
2090:
2091: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
2092:
2093: -- Bug 9263438: Use wip_interface_s for interface_id instead of wip_job_schedule_interface_s
2094: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
2095:
2096:
2097: generate_job_name ( p_job_prefix =>l_job_prefix,

Line 2094: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;

2090:
2091: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
2092:
2093: -- Bug 9263438: Use wip_interface_s for interface_id instead of wip_job_schedule_interface_s
2094: SELECT wip_interface_s.NEXTVAL INTO l_job_header_rec.interface_id FROM dual;
2095:
2096:
2097: generate_job_name ( p_job_prefix =>l_job_prefix,
2098: p_organization_id => l_job_header_rec.organization_id,