[Home] [Help]
130: CURSOR Cur_wip_entity IS
131: SELECT 1
132: FROM DUAL
133: WHERE EXISTS (SELECT 1
134: FROM wip_entities
135: WHERE organization_id = p_organization_id
136: AND wip_entity_name = p_batch_no);
137: BEGIN
138: x_return_status := fnd_api.g_ret_sts_success;
1368: ELSE
1369: l_prefix := FND_PROFILE.VALUE('GME_FPO_PREFIX');
1370: END IF;
1371: /*5698727 rework commented the following code. We will validate the wip entity
1372: when we are updating the wip_entities table later once the actual doc_no is available */
1373: /* Bug6398619 we have to validate the batch no for the manual doc ordering as
1374: the time stamp is not created for the manual ordering */
1375: IF l_doc_numbering <> gme_common_pvt.g_auto_doc_numbering THEN
1376: validate_wip_entity(p_organization_id => x_batch_header_rec.organization_id,
1907: UPDATE gme_batch_header
1908: SET batch_no = x_batch_header_rec.batch_no
1909: WHERE batch_id = x_batch_header_rec.batch_id;
1910:
1911: /*5698727 rework update the wip_entities table with actual batch no*/
1912: UPDATE wip_entities
1913: SET wip_entity_name = l_prefix||x_batch_header_rec.batch_no
1914: WHERE organization_id = x_batch_header_rec.organization_id
1915: AND wip_entity_name = l_prefix||l_doc_timestamp;
1908: SET batch_no = x_batch_header_rec.batch_no
1909: WHERE batch_id = x_batch_header_rec.batch_id;
1910:
1911: /*5698727 rework update the wip_entities table with actual batch no*/
1912: UPDATE wip_entities
1913: SET wip_entity_name = l_prefix||x_batch_header_rec.batch_no
1914: WHERE organization_id = x_batch_header_rec.organization_id
1915: AND wip_entity_name = l_prefix||l_doc_timestamp;
1916: --5698727
2269: || TO_CHAR (x_batch_header_rec.batch_id) );
2270: END IF;
2271:
2272: /* Update WIP entity table to put the primary product id */
2273: UPDATE wip_entities
2274: SET primary_item_id = l_recipe_validity_rule.inventory_item_id
2275: WHERE wip_entity_id = x_batch_header_rec.batch_id;
2276:
2277: -- Rajesh Patangya Bug # 6752637