[Home] [Help]
238: This API first checks for Authorization_Status , it shoud not be in ('CANCELLED',
239: 'REJECTED'). Then it checks for Destination_Type , it should be 'SHOP FLOOR'.
240: Then it checks for Cancel_Flag , it should not be 'Yes'. Then it checks for
241: osp flag, if this is 'NO' then it checks whether
242: that requisition line exists in cst_eam_wo_estimate_details table. If it
243: exists then this compares for required quantity, rate and unit price in PO
244: table and EAM table. If there is any change or requisition does not exist
245: in EAM table then this calls 'Call_Validate_for_Reestimation' procedure
246: to set the estimation status to reestimate.
302: BEGIN
303:
304: SELECT requisition_line_id
305: INTO l_count
306: FROM CST_EAM_WO_ESTIMATE_DETAILS
307: WHERE requisition_line_id = p_req_line_id
308: AND wip_entity_id = l_wip_entity_id;
309:
310: EXCEPTION
315: END;
316:
317: l_stmt_num := 50;
318:
319: -- Requisition line id exists in cst_eam_wo_estimate_details
320: IF ( l_count <> 0 ) THEN
321:
322: l_stmt_num := 60;
323:
323:
324: SELECT nvl( required_quantity, 0) , nvl( rate, 0) ,
325: nvl( item_cost, 0)
326: INTO l_req_qty , l_rate , l_unit_price
327: FROM CST_EAM_WO_ESTIMATE_DETAILS
328: WHERE requisition_line_id = p_req_line_id
329: AND wip_entity_id = l_wip_entity_id;
330:
331: l_stmt_num := 70;
355: x_msg_data := l_msg_data;
356:
357: END IF; /* ENDIF for comparing values IF */
358:
359: -- Requisition line id does not exist in cst_eam_wo_estimate_details
360: ELSIF ( l_count = 0 ) THEN
361:
362: l_stmt_num := 100;
363:
394: for each distribution line. This API first checks for Authorization_Status ,
395: it shoud not be in ('CANCELLED','REJECTED'). Then it checks for Destination_Type ,
396: it should be 'SHOP FLOOR'.Then it checks for Cancel_Flag , it should not be 'Yes'.
397: Then it checks forF osp flag, if this is 'NO' then it checks whether
398: that distribution line exists in cst_eam_wo_estimate_details table. If it
399: exists then this compares for required quantity, rate and unit price in PO
400: table and EAM table. If there is any change in the values then call the procedure
401: Call_Validate_for_Reestimation'. If distribution line does not exist in EAM
402: table then it checks whether requisition has been converted into 'PO' or not
466:
467: SELECT po_distribution_id , nvl( required_quantity, 0 ) , nvl( rate, 0 ) ,
468: nvl( item_cost , 0 )
469: INTO l_count, l_req_qty , l_rate , l_unit_price
470: FROM CST_EAM_WO_ESTIMATE_DETAILS
471: WHERE po_distribution_id = p_po_dist_id
472: AND wip_entity_id = l_wip_entity_id;
473:
474: EXCEPTION
479: END;
480:
481: l_stmt_num := 50;
482:
483: --po_distribution_id exists in cst_eam_wo_estimate_details
484: IF( l_count <> 0) then
485:
486: l_stmt_num := 60;
487:
488: /* SELECT nvl( required_quantity, 0 ) , nvl( rate, 0 ) ,
489: nvl( item_cost , 0 )
490: INTO l_req_qty , l_rate ,
491: l_unit_price
492: FROM CST_EAM_WO_ESTIMATE_DETAILS
493: WHERE po_distribution_id = p_po_dist_id
494: AND wip_entity_id = l_wip_entity_id ; */
495:
496: l_estimate_flag := 1;
494: AND wip_entity_id = l_wip_entity_id ; */
495:
496: l_estimate_flag := 1;
497:
498: --Po distribution id does not exist in cst_eam_wo_estimate_details
499: ELSIF ( l_count = 0 ) THEN
500:
501: BEGIN
502:
522: l_stmt_num := 90;
523:
524: SELECT requisition_line_id
525: INTO l_req_line_id
526: FROM CST_EAM_WO_ESTIMATE_DETAILS
527: WHERE line_location_id = l_line_location_id
528: AND wip_entity_id = l_wip_entity_id;
529:
530: l_stmt_num := 100;
532: SELECT nvl( required_quantity , 0 ) , nvl( rate , 0 ) ,
533: nvl( item_cost , 0 )
534: INTO l_req_qty , l_rate ,
535: l_unit_price
536: FROM CST_EAM_WO_ESTIMATE_DETAILS
537: WHERE requisition_line_id = l_req_line_id
538: AND wip_entity_id = l_wip_entity_id;
539:
540: l_estimate_flag := 1;