APPS.CSD_WIP_JOB_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE_S

Line 970: --SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

966: -- Get the Group_id to be used for WIP Mass Load, All the records inserted into
967: -- wip_job_schedule_interface have the same group_id , so that one WIP Mass Load
968: -- request can process all the records
969: --if (l_default_ro_item = 'N') then
970: --SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
971:
972: if (l_default_ro_item = 'Y') then
973: OPEN c_repair_line_info(p_repair_line_id);
974: FETCH c_repair_line_info into

Line 1016: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

1012:
1013: IF p_x_job_bill_routing_tbl.COUNT = 0 THEN
1014:
1015: -- if (l_default_ro_item = 'Y') then
1016: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
1017: -- End if;
1018:
1019: p_x_job_bill_routing_tbl(0).group_id := l_group_id;
1020:

Line 1174: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

1170:
1171: LOOP
1172:
1173: --if (l_default_ro_item = 'Y') then
1174: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
1175: --End if;
1176:
1177: p_x_job_bill_routing_tbl(rt_ctr).group_id := l_group_id;
1178:

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 2091: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

2087:
2088:
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:

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 2731: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

2727: END IF;
2728:
2729: IF l_group_id = 0
2730: THEN
2731: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
2732: END IF;
2733:
2734: l_job_header_tbl(l_job_header_index).group_id := l_group_id;
2735: l_job_header_index := l_job_header_index + 1;

Line 2786: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;

2782: px_job_names(i) := lx_job_name;
2783:
2784: IF l_group_id = 0
2785: THEN
2786: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
2787: END IF;
2788:
2789: l_job_header_tbl(l_job_header_index).group_id := l_group_id;
2790: l_job_header_index := l_job_header_index + 1;