APPS.CSD_WIP_JOB_PVT dependencies on DUAL

Line 579: x_job_name From Dual;

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

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

960: -- wip_job_schedule_interface have the same group_id , so that one WIP Mass Load
961: -- request can process all the records
962:
963: if (l_default_ro_item = 'N') then
964: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
965:
966: else
967: OPEN c_repair_line_info(p_repair_line_id);
968: FETCH c_repair_line_info into

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

1005:
1006: IF p_x_job_bill_routing_tbl.COUNT = 0 THEN
1007:
1008: if (l_default_ro_item = 'Y') then
1009: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
1010: End if;
1011:
1012: p_x_job_bill_routing_tbl(0).group_id := l_group_id;
1013:

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

1141:
1142: LOOP
1143:
1144: if (l_default_ro_item = 'Y') then
1145: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_group_id FROM dual;
1146: End if;
1147:
1148: p_x_job_bill_routing_tbl(rt_ctr).group_id := l_group_id;
1149:

Line 1922: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;

1918:
1919:
1920: -- Get the Group_id to be used for WIP Create Job,
1921:
1922: SELECT wip_job_schedule_interface_s.NEXTVAL INTO l_job_header_rec.group_id FROM dual;
1923:
1924: l_job_header_rec.interface_id := l_job_header_rec.group_id;
1925:
1926: generate_job_name ( p_job_prefix =>l_job_prefix,