APPS.FLM_SEQ_READER_WRITER dependencies on MRP_RECOMMENDATIONS

Line 342: update_mrp_recommendations(l_sch_tbl_to_insert,l_return_code);

338: o_return_code := 1;
339: return;
340: end if;
341:
342: update_mrp_recommendations(l_sch_tbl_to_insert,l_return_code);
343: if(l_return_code = 1) then
344: o_return_code := 1;
345: return;
346: end if;

Line 1049: * To update the mrp_recommendations based on schedules inserted *

1045: END call_cto_api;
1046:
1047:
1048: /******************************************************************
1049: * To update the mrp_recommendations based on schedules inserted *
1050: ******************************************************************/
1051: PROCEDURE update_mrp_recommendations(i_schedules_tbl IN wip_flow_schedule_tbl,
1052: o_return_code IN OUT NOCOPY NUMBER) IS
1053:

Line 1051: PROCEDURE update_mrp_recommendations(i_schedules_tbl IN wip_flow_schedule_tbl,

1047:
1048: /******************************************************************
1049: * To update the mrp_recommendations based on schedules inserted *
1050: ******************************************************************/
1051: PROCEDURE update_mrp_recommendations(i_schedules_tbl IN wip_flow_schedule_tbl,
1052: o_return_code IN OUT NOCOPY NUMBER) IS
1053:
1054: l_index NUMBER;
1055: l_item_tbl_to_update_rec wip_flow_schedule_tbl;

Line 1103: UPDATE mrp_recommendations

1099: END LOOP;
1100: if(l_item_tbl_to_update_rec.COUNT > 0) then
1101: for k in l_item_tbl_to_update_rec.FIRST .. l_item_tbl_to_update_rec.LAST
1102: LOOP
1103: UPDATE mrp_recommendations
1104: SET quantity_in_process =
1105: nvl(quantity_in_process,0) + l_item_tbl_to_update_rec(k).planned_quantity
1106: WHERE transaction_id = l_item_tbl_to_update_rec(k).demand_source_line;
1107: END LOOP;

Line 1115: END update_mrp_recommendations;

1111: WHEN OTHERS THEN
1112: o_return_code := 1;
1113: return;
1114:
1115: END update_mrp_recommendations;
1116:
1117:
1118: /******************************************************************
1119: * Used to insert all the schedule in the table *