[Home] [Help]
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);
169:
170: --Insert data in PS_MATL_HDR.
171: insert_header_data;
172:
173: IF G_item_tab.count > 0 then
174: rips1usr_unbucket_report;
173: IF G_item_tab.count > 0 then
174: rips1usr_unbucket_report;
175:
176: DELETE
177: FROM ps_matl_hdr pmh
178: WHERE pmh.matl_rep_id = G_matl_rep_id
179: AND
180: ((pmh.inventory_item_id NOT IN (SELECT pud1.inventory_item_id
181: FROM ps_ubkt_dtl pud1
244: /*============================================================================+
245: | |
246: | PROCEDURE NAME INSERT_HEADER_DATA |
247: | |
248: | DESCRIPTION Procedure to insert data into ps_matl_hdr |
249: | This Procedure fetches data for the Header Table by |
250: | building the Where condition based on the User and the|
251: | Planning Classes and then inserts into the Header |
252: | Table by creating a record group |
418: G_item_tab(X_i).inventory_item_id := X_item_id;
419: G_item_tab(X_i).organization_id := X_org_id;
420: G_item_tab(X_i).category_id := X_category_id;
421: -- Inserts the data into Header table.
422: INSERT INTO ps_matl_hdr (matl_rep_id,inventory_item_id,organization_id,category_id)
423: VALUES(X_rep_id,X_item_id,X_org_id,X_category_id);
424: IF dbms_sql.fetch_rows (cur_item) <= 0 THEN
425: EXIT;
426: END IF;
1281: dbms_sql.close_cursor(X_doc);
1282:
1283: IF X_i = 0 THEN
1284:
1285: DELETE FROM ps_matl_hdr
1286: WHERE inventory_item_id = V_item_id
1287: AND matl_rep_id = G_matl_rep_id;
1288: END IF;
1289:
1824: ' AND pud.organization_id = pmh.organization_id ' ||
1825: ' AND pud.matl_rep_id = pmh.matl_rep_id ' ||
1826: ' ORDER BY pud.inventory_item_id, pud.organization_id, pud.trans_date, pud.doc_type ' ||
1827: ' ) DETAIL ' ||
1828: ' FROM ps_matl_hdr pmh ' ||
1829: ' WHERE pmh.matl_rep_id = ' ||G_matl_rep_id||
1830: ' ORDER BY pmh.inventory_item_id, pmh.organization_id ' ||
1831: ' ) HEADER ' ||
1832: ' FROM DUAL ';