1780: END IF;
1781: END IF; -- insert_alloc_child check
1782:
1783: IF(l_rs_txn.oc_pri_qty <> 0 AND
1784: po_code_release_grp.Current_Release >=
1785: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
1786:
1787: SELECT propagate_job_change_to_po
1788: INTO l_propagate_job_change_to_po
1781: END IF; -- insert_alloc_child check
1782:
1783: IF(l_rs_txn.oc_pri_qty <> 0 AND
1784: po_code_release_grp.Current_Release >=
1785: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
1786:
1787: SELECT propagate_job_change_to_po
1788: INTO l_propagate_job_change_to_po
1789: FROM wip_parameters
2514: END IF; -- insert_alloc_child check
2515:
2516: -- Increase PO/requisition quantity if overmove
2517: IF(l_dj_txn.oc_pri_qty <> 0 AND
2518: po_code_release_grp.Current_Release >=
2519: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
2520:
2521: SELECT propagate_job_change_to_po
2522: INTO l_propagate_job_change_to_po
2515:
2516: -- Increase PO/requisition quantity if overmove
2517: IF(l_dj_txn.oc_pri_qty <> 0 AND
2518: po_code_release_grp.Current_Release >=
2519: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
2520:
2521: SELECT propagate_job_change_to_po
2522: INTO l_propagate_job_change_to_po
2523: FROM wip_parameters
6835: x_returnStatus => l_returnStatus);
6836: END IF;
6837: END IF; -- po requisition per lot for schedule
6838:
6839: IF(po_code_release_grp.Current_Release <
6840: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
6841: -- Only cut new requisition if customer do not have PO patchset J,
6842: -- otherwise, try to update PO/requisition instead
6843: OPEN c_additional_reqs(p_group_id => p_gib.group_id);
6836: END IF;
6837: END IF; -- po requisition per lot for schedule
6838:
6839: IF(po_code_release_grp.Current_Release <
6840: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
6841: -- Only cut new requisition if customer do not have PO patchset J,
6842: -- otherwise, try to update PO/requisition instead
6843: OPEN c_additional_reqs(p_group_id => p_gib.group_id);
6844: /* for overcompletions - create new reqs for subsequent operations IF
8526: END IF; -- IF job txns
8527: END IF; -- scrap transactions
8528:
8529: -- Update PO quantity for scrap transactions
8530: IF (po_code_release_grp.Current_Release >=
8531: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
8532: FOR l_update_po IN c_update_po LOOP
8533:
8534: /* fix bug 6607192(FP 6348222): Cancel the attached PO with the job when Scrap Txn
8527: END IF; -- scrap transactions
8528:
8529: -- Update PO quantity for scrap transactions
8530: IF (po_code_release_grp.Current_Release >=
8531: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
8532: FOR l_update_po IN c_update_po LOOP
8533:
8534: /* fix bug 6607192(FP 6348222): Cancel the attached PO with the job when Scrap Txn
8535: is happening for all the job qty */