[Home] [Help]
353: x_pull_sequence_id out nocopy number )
354: is
355: l_pull_seq_id Number;
356: Begin
357: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL into l_pull_seq_id from dual;
358:
359: INSERT INTO MTL_KANBAN_PULL_SEQUENCES
360: (Pull_sequence_id,
361: Inventory_item_id,
1192: Return Number
1193: is
1194: l_next_pull_seq_id Number;
1195: Begin
1196: select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL
1197: into l_next_pull_seq_id
1198: from dual;
1199:
1200: return l_next_pull_seq_id;
1320: Begin
1321: l_value := trunc(dbms_random.value(0,999999999999));
1322: if p_kanban_plan_id = -1 then
1323: l_sql := 'delete from MTL_KANBAN_PULL_SEQUENCES mkps1 where mkps1.Kanban_Plan_id = 0 and mkps1.pull_sequence_id in'||
1324: '(select syspullseq.pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES syspullseq, MTL_KANBAN_PULL_SEQUENCES prodpullSeq'||
1325: ' where syspullseq.kanban_plan_id = 0 and prodpullSeq.kanban_plan_id = -1 '||
1326: ' and syspullseq.organization_id = prodpullSeq.organization_id '||
1327: ' and syspullseq.inventory_item_id = prodpullSeq.inventory_item_id '||
1328: ' and syspullseq.Subinventory_name = prodpullSeq.Subinventory_name '||
1336: 'Kanban_size,Number_of_cards,Minimum_order_quantity,Allocation_Percent,Replenishment_lead_time,Fixed_Lot_multiplier,'||
1337: 'Safety_Stock_Days,Attribute_Category,Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,Attribute7,Attribute8,'||
1338: 'Attribute9,Attribute10,Attribute11,Attribute12,Attribute13,Attribute14,Attribute15,'||
1339: 'PLANNING_EFFECTIVITY,UPDATED_FLAG, RELEASE_KANBAN_FLAG,AVG_DEPENDENT_DEMAND,FUTURE_CARD_SIZE,FUTURE_NO_OF_CARDS)'||
1340: 'select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL,Inventory_item_id,Organization_id,Subinventory_name,0,'||
1341: 'Source_type,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,Locator_id,Calculate_Kanban_flag,'||
1342: 'decode(Calculate_Kanban_flag,1,FLM_KANBAN_PLANNING_UTIL.GET_CALCULATED_SIZE(PULL_SEQUENCE_ID,CALCULATE_KANBAN_FLAG,NUMBER_OF_CARDS,'||
1343: 'nvl(FLM_KANBAN_PLANNING_UTIL.get_average_demand(Organization_id,0,Inventory_item_id,Subinventory_name,Locator_id),nvl(AVG_DEPENDENT_DEMAND,0)),ALLOCATION_PERCENT,'||
1344: 'REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Kanban_size),'||
1358: 'ALLOCATION_PERCENT,REPLENISHMENT_LEAD_TIME,SAFETY_STOCK_DAYS,MINIMUM_ORDER_QUANTITY,FIXED_LOT_MULTIPLIER),Number_of_cards)'||
1359: ' from MTL_KANBAN_PULL_SEQUENCES where pull_sequence_id in ('||p_pull_seq_ids||')' ;
1360: else
1361: l_kanban_plan_id := p_kanban_plan_id;
1362: l_sql := 'update MTL_KANBAN_PULL_SEQUENCES set UPDATED_FLAG = '||l_value||
1363: ',FUTURE_NO_OF_CARDS = Number_of_cards,FUTURE_CARD_SIZE= Kanban_size where pull_sequence_id in ('||p_pull_seq_ids||')';
1364: end if;
1365: execute immediate l_sql;
1366: -- Generate Horizontal Plan Data.