APPS.CSD_WIP_JOB_PVT dependencies on DUAL

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 584: x_job_name From Dual;

580: -- generate the Job Name by appending a sequence generated number to the passed in
581: -- job_prefix
582:
583: Select p_job_prefix || TO_CHAR( CSD_JOB_NAME_S.NEXTVAL ) into
584: x_job_name From Dual;
585:
586:
587: -- Check if the job name generated is unique for the specified organization,
588: -- if not loop around till a unique job name is generated

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 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 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,

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;