[Home] [Help]
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
170: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);
171:
172: --Insert data in PS_MATL_HDR.
173: insert_header_data;
174:
175: IF G_item_tab.count > 0 then
176: rips1usr_unbucket_report;
175: IF G_item_tab.count > 0 then
176: rips1usr_unbucket_report;
177:
178: DELETE
179: FROM ps_matl_hdr pmh
180: WHERE pmh.matl_rep_id = G_matl_rep_id
181: AND
182: ((pmh.inventory_item_id NOT IN (SELECT pud1.inventory_item_id
183: FROM ps_ubkt_dtl pud1
246: /*============================================================================+
247: | |
248: | PROCEDURE NAME INSERT_HEADER_DATA |
249: | |
250: | DESCRIPTION Procedure to insert data into ps_matl_hdr |
251: | This Procedure fetches data for the Header Table by |
252: | building the Where condition based on the User and the|
253: | Planning Classes and then inserts into the Header |
254: | Table by creating a record group |
420: G_item_tab(X_i).inventory_item_id := X_item_id;
421: G_item_tab(X_i).organization_id := X_org_id;
422: G_item_tab(X_i).category_id := X_category_id;
423: -- Inserts the data into Header table.
424: INSERT INTO ps_matl_hdr (matl_rep_id,inventory_item_id,organization_id,category_id)
425: VALUES(X_rep_id,X_item_id,X_org_id,X_category_id);
426: IF dbms_sql.fetch_rows (cur_item) <= 0 THEN
427: EXIT;
428: END IF;
1287: dbms_sql.close_cursor(X_doc);
1288:
1289: IF X_i = 0 THEN
1290:
1291: DELETE FROM ps_matl_hdr
1292: WHERE inventory_item_id = V_item_id
1293: AND matl_rep_id = G_matl_rep_id;
1294: END IF;
1295:
1859: --Modified order by clause as per bug # 11072275
1860: --' ORDER BY pud.inventory_item_id, pud.organization_id, pud.trans_date, pud.doc_type ' ||
1861: ' ORDER BY pud.inventory_item_id, pud.organization_id, pud.trans_date, rownum ' ||
1862: ' ) DETAIL ' ||
1863: ' FROM ps_matl_hdr pmh ' ||
1864: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
1865: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
1866: ' ) HEADER ' ||
1867: ' FROM DUAL ';