APPS.GMPMRRP dependencies on PS_MATL_HDR

Line 235: | DESCRIPTION Procedure to insert data into ps_matl_hdr |

231: /*============================================================================+
232: | |
233: | PROCEDURE NAME mr_insert_header |
234: | |
235: | DESCRIPTION Procedure to insert data into ps_matl_hdr |
236: | |
237: | MODIFICATION HISTORY |
238: | 07/14/01 Praveen Reddy ----- created |
239: | |

Line 317: INSERT INTO ps_matl_hdr (matl_rep_id,planning_class,item_id)

313: X_i := X_i + 1;
314: G_planning_tab(X_i).planning_class := X_planning_class;
315: G_planning_tab(X_i).item_id := X_item_id;
316: -- Inserts the data into Header table.
317: INSERT INTO ps_matl_hdr (matl_rep_id,planning_class,item_id)
318: VALUES(X_rep_id,X_planning_class,X_item_id);
319: IF dbms_sql.fetch_rows (cur_planning) <= 0 then
320: EXIT;
321: END IF;

Line 420: DELETE FROM ps_matl_hdr

416: G_matl_rep_id);
417:
418: -- if there are no transactions then that item row is deleted from header table.
419: IF X_row_count = 0 THEN
420: DELETE FROM ps_matl_hdr
421: WHERE item_id = V_item_id
422: AND matl_rep_id = G_matl_rep_id;
423: RETURN(-1);
424: END IF;