[Home] [Help]
34:
35:
36: If p_organization_code is null then
37:
38: FND_FILE.put_line(FND_FILE.LOG, 'Organization Code : ALL Organizations');
39:
40: select organization_id
41: Bulk Collect
42: into l_all_orgs
55: end loop;
56:
57: else
58:
59: FND_FILE.put_line(FND_FILE.LOG, 'Organization Code : '||p_organization_code);
60:
61: select organization_id
62: into p_organization_id
63: from MTL_PARAMETERS
126: from mtl_parameters
127: where Organization_id = p_organization_id;
128:
129:
130: FND_FILE.put_line(FND_FILE.LOG, 'Please run the Actual Demand Calculation first for the Organization : '||l_organization_code);
131: -- dbms_output.put_line('Please run the Actual Demand Calculation first');
132: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Warning: Please run the Actual Demand Calculation before running Lead Time Calculation ');
133: -- Rollback;
134: Return;
162: -- dbms_output.put_line('Kanban card id : '||c_card_activity.kanban_card_id);
163: -- dbms_output.put_line('Kanban activity id : '||c_card_activity.REPLENISHMENT_activity_id);
164:
165: begin
166: -- FND_FILE.put_line(FND_FILE.LOG, 'Kanban Activity ID is : '||c_card_activity.REPLENISHMENT_activity_id);
167: Select
168: KANBAN_ACTIVITY_ID,
169: CREATION_DATE
170: into l_kanban_activity_id,
184: l_update_required := 'N';
185: end;
186:
187: if l_update_required = 'Y' then
188: -- FND_FILE.put_line(FND_FILE.LOG, 'Received Activity ID is : '||l_kanban_activity_id);
189: Update FLM_EKB_ACT_SNAPSHOT
190: Set RECEIVED_DATE = l_recv_date,
191: lead_time = to_number( l_recv_date - REPLENISHMENT_DATE ),
192: RECEIVED_ACTIVITY_ID = l_kanban_activity_id,
240: from flm_ekb_act_snapshot
241: where lead_time > 0
242: and organization_id = p_organization_id;
243:
244: FND_FILE.put_line(FND_FILE.LOG, 'Total rows updated are : '||l_row_count);
245: -- dbms_output.put_line('Total rows updated are : '||l_row_count);
246: end of testing */
247:
248: end;