[Home] [Help]
138: END IF;
139: -- G_no_of_reports := to_char(to_number(G_no_of_reports) + 1);
140: IF (G_matl_rep_id IS NOT NULL) THEN NULL;
141: DELETE
142: FROM ps_matl_hdr pmh
143: WHERE pmh.matl_rep_id = G_matl_rep_id
144: AND
145: ((pmh.inventory_item_id NOT IN (SELECT pmd1.inventory_item_id
146: FROM ps_matl_dtl pmd1
191: /*============================================================================+
192: | |
193: | PROCEDURE NAME ps_insert_header |
194: | |
195: | DESCRIPTION Procedure to insert data into ps_matl_hdr |
196: | |
197: | MODIFICATION HISTORY |
198: | 07/14/01 Praveen Reddy ----- created |
199: | |
360: G_item_tab(X_i).inventory_item_id := X_item_id;
361: G_item_tab(X_i).organization_id := X_org_id;
362: G_item_tab(X_i).category_id := X_category_id;
363: -- Inserts the data into Header table.
364: INSERT INTO ps_matl_hdr (matl_rep_id,inventory_item_id,organization_id,category_id)
365: VALUES(X_rep_id,X_item_id,X_org_id,X_category_id);
366: IF dbms_sql.fetch_rows (cur_item) <= 0 THEN
367: EXIT;
368: END IF;
481: G_matl_rep_id);
482:
483: -- if there are no transactions then that item row is deleted from header table.
484: IF X_row_count = 0 THEN
485: DELETE FROM ps_matl_hdr
486: WHERE inventory_item_id = V_item_id
487: AND organization_id = V_organization_id
488: AND matl_rep_id = G_matl_rep_id;
489: RETURN(-1);
678: ' AND pmd.organization_id = pmh.organization_id ' ||
679: ' AND pmd.matl_rep_id = pmh.matl_rep_id ' ||
680: ' ORDER BY pmd.inventory_item_id, pmd.organization_id, pmd.perd_end_date ' ||
681: ' ) DETAIL ' ||
682: ' FROM ps_matl_hdr pmh ' ||
683: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
684: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
685: ' ) HEADER ' ||
686: ' FROM DUAL ';