APPS.GMD_VAL_DATA_PUB dependencies on GMD_VAL_RULE_GTMP

Line 112: DELETE FROM GMD_VAL_RULE_GTMP;

108: END LOOP;
109:
110: /* Bug No.6788488 - Start */
111: BEGIN
112: DELETE FROM GMD_VAL_RULE_GTMP;
113: IF x_recipe_validity_out.count > 0 THEN
114: FOR i in 1..x_recipe_validity_out.count LOOP
115: INSERT INTO GMD_VAL_RULE_GTMP(
116: recipe_validity_rule_id, recipe_id , orgn_code , recipe_use ,

Line 115: INSERT INTO GMD_VAL_RULE_GTMP(

111: BEGIN
112: DELETE FROM GMD_VAL_RULE_GTMP;
113: IF x_recipe_validity_out.count > 0 THEN
114: FOR i in 1..x_recipe_validity_out.count LOOP
115: INSERT INTO GMD_VAL_RULE_GTMP(
116: recipe_validity_rule_id, recipe_id , orgn_code , recipe_use ,
117: preference , start_date , end_date , min_qty ,
118: max_qty , std_qty , inv_min_qty , inv_max_qty ,
119: text_code , attribute_category , attribute1 , attribute2 ,