DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE_S

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,