[Home] [Help]
269: /*============================================================================+
270: | |
271: | PROCEDURE NAME mr_insert_header |
272: | |
273: | DESCRIPTION Procedure to insert data into ps_matl_hdr |
274: | This Procedure fetches data for the Header Table by |
275: | building the Where condition based on the User and the|
276: | Planning Classes and then inserts into the Header |
277: | Table by creating a record group |
361: G_planning_tab(X_i).item_id := X_item_id;
362: -- Inserts the data into Header table.
363: /* this information is used for Report Header Purposes */
364:
365: INSERT INTO ps_matl_hdr (matl_rep_id,planning_class,item_id)
366: VALUES(X_rep_id,X_planning_class,X_item_id);
367:
368: IF dbms_sql.fetch_rows (cur_planning) <= 0 then
369: EXIT;
712: --
713: /* if there are no transactions then that item row is deleted from
714: header table. */
715: IF X_i = 0 THEN
716: DELETE FROM ps_matl_hdr
717: WHERE item_id = V_item_id
718: AND matl_rep_id = G_matl_rep_id;
719: END IF;
720: --