[Home] [Help]
367: --Else, for each job having assembly same as resulting job and reservation exists, call transfer_reservation ( ) to transfer reservations to new resulting job.
368: --If any starting job has reservation and assembly is different from rep-job,
369: --write to WIE 'Note: One or more Starting jobs with an assembly different from that of the representative job are reserved against sales order.
370: --Merge transaction will result in deletion of the reservations of these starting jobs.'
371: update wip_discrete_jobs
372: set net_quantity = start_quantity
373: where wip_entity_id = p_resulting_jobs_tbl(l_rj_index).wip_entity_id;
374:
375: For l_counter in p_starting_jobs_tbl.first.. p_starting_jobs_tbl.last loop
531: End if;
532: End if;
533: End loop;
534:
535: update wip_discrete_jobs
536: set net_quantity = p_resulting_jobs_tbl(l_rj_index).net_quantity
537: where wip_entity_id = p_resulting_jobs_tbl(l_rj_index).wip_entity_id;
538:
539: l_rsvd_qty := check_reservation_quantity(
803:
804: BEGIN
805: select status_type
806: into l_status_type
807: from wip_discrete_jobs
808: where wip_entity_id = p_wip_entity_id
809: and organization_id = p_org_id;
810:
811: update wip_discrete_jobs
807: from wip_discrete_jobs
808: where wip_entity_id = p_wip_entity_id
809: and organization_id = p_org_id;
810:
811: update wip_discrete_jobs
812: set status_type = 3
813: where wip_entity_id = p_wip_entity_id
814: and organization_id = p_org_id;
815: EXCEPTION
895:
896: -- Added for Bug 5286219. Restoring back the status type of the job to original
897: -- status before it was updated to Released for trf the reservation.
898:
899: update wip_discrete_jobs
900: set status_type = l_status_type
901: where wip_entity_id = p_wip_entity_id
902: and organization_id = p_org_id;
903: