APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on GMP_ROUTING_OFFSETS

Line 1027: DELETE FROM gmp_routing_offsets

1023: END IF ; -- valid item id and org id
1024:
1025: BEGIN
1026:
1027: DELETE FROM gmp_routing_offsets
1028: WHERE fmeff_id = item_eff.fmeff_id
1029: AND organization_id = item_eff.org_id;
1030:
1031: EXCEPTION

Line 1041: INSERT INTO gmp_routing_offsets(

1037:
1038: FOR i IN 1..rtg_steps_tbl.COUNT
1039: LOOP
1040:
1041: INSERT INTO gmp_routing_offsets(
1042: /*Sowmya - Inventory convergence - commented plant code and included organization id*/
1043: --plant_code, fmeff_id, recipe_id,
1044: organization_id,
1045: fmeff_id,

Line 1079: log_message('Error in insert into gmp_routing_offsets'||sqlerrm) ;

1075: END LOOP;
1076:
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: log_message('Error in insert into gmp_routing_offsets'||sqlerrm) ;
1080:
1081: END ; -- end of anonymous block for insert
1082:
1083: