35:
36:
37: If p_organization_code is null then
38:
39: FND_FILE.put_line(FND_FILE.LOG, 'Organization Code : ALL Organizations');
40:
41: select organization_id
42: Bulk Collect
43: into l_all_orgs
56: end loop;
57:
58: else
59:
60: FND_FILE.put_line(FND_FILE.LOG, 'Organization Code : '||p_organization_code);
61:
62: select organization_id
63: into p_organization_id
64: from MTL_PARAMETERS
247: into l_row_count
248: from flm_ekb_act_snapshot
249: where organization_id = p_organization_id;
250:
251: -- FND_FILE.put_line(FND_FILE.LOG, 'Total rows for this organization are : '||l_row_count);
252: -- dbms_output.put_line('Total rows for this organization are : '||l_row_count);
253: end of testing */
254:
255: end;