20: inv_int_flag VARCHAR2(1); -- Added for bug # 6469970
21: wdd_exists VARCHAR2(1); -- Added for bug # 6469970
22: oel_exists VARCHAR2(1); -- Added for bug # 6469970
23: l_total_loop NUMBER := 0;
24: l_date_from DATE := fnd_date.canonical_to_date(p_date_from);
25: l_date_to DATE := fnd_date.canonical_to_date(p_date_to);
26: l_prev_header_id mtl_txn_request_headers.header_id%TYPE;
27:
28: -- Bug 4237808
21: wdd_exists VARCHAR2(1); -- Added for bug # 6469970
22: oel_exists VARCHAR2(1); -- Added for bug # 6469970
23: l_total_loop NUMBER := 0;
24: l_date_from DATE := fnd_date.canonical_to_date(p_date_from);
25: l_date_to DATE := fnd_date.canonical_to_date(p_date_to);
26: l_prev_header_id mtl_txn_request_headers.header_id%TYPE;
27:
28: -- Bug 4237808
29: -- Rewriting the cursor below to pick up an index (instead of