APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on GMP_ROUTING_OFFSETS

Line 1221: DELETE FROM gmp_routing_offsets

1217: END IF ; -- valid item id and org id
1218:
1219: BEGIN
1220:
1221: DELETE FROM gmp_routing_offsets
1222: WHERE fmeff_id = item_eff.fmeff_id
1223: AND organization_id = item_eff.org_id;
1224:
1225: EXCEPTION

Line 1235: INSERT INTO gmp_routing_offsets(

1231:
1232: FOR i IN 1..rtg_steps_tbl.COUNT
1233: LOOP
1234:
1235: INSERT INTO gmp_routing_offsets(
1236: /*Sowmya - Inventory convergence - commented plant code and included organization id*/
1237: --plant_code, fmeff_id, recipe_id,
1238: organization_id,
1239: fmeff_id,

Line 1273: log_message('Error in insert into gmp_routing_offsets'||SQLERRM) ;

1269: END LOOP;
1270:
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: log_message('Error in insert into gmp_routing_offsets'||SQLERRM) ;
1274:
1275: END ; -- end of anonymous block for insert
1276:
1277: END IF; -- Bug: 8736658 Vpedarla