[Home] [Help]
34: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
35: l_msg_data VARCHAR2(2000);
36: l_msg VARCHAR2(2000);
37: l_return_status VARCHAR2(2000);
38: allocate_table wip_picking_pub.allocate_comp_tbl_t;
39: l_pickslip_conc_req_id NUMBER := 0;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_uLog constant BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level;
42: l_pLog constant BOOLEAN := l_uLog AND FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
126: allocate_table(1).start_serial := p_fm_serial;
127: allocate_table(1).end_serial := p_to_serial;
128:
129: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
130: 'Calling wip_picking_pub.allocate_comp');
131: end if;
132: wip_picking_pub.allocate_comp(p_alloc_comp_tbl => allocate_table,
133: p_cutoff_date => null,
134: p_wip_entity_type => wip_constants.eam,
128:
129: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
130: 'Calling wip_picking_pub.allocate_comp');
131: end if;
132: wip_picking_pub.allocate_comp(p_alloc_comp_tbl => allocate_table,
133: p_cutoff_date => null,
134: p_wip_entity_type => wip_constants.eam,
135: p_organization_id => p_organization_id,
136: x_return_status => l_return_status,
137: x_msg_data => l_msg_data,
138: x_mo_req_number => x_request_number,
139: x_conc_req_id => l_pickslip_conc_req_id);
140: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
141: 'After Calling wip_picking_pub.allocate_comp');
142: end if;
143: if (l_sLog) then
144: l_msg := 'WIP returned: Request Number:' || x_request_number || ', x_return_status:'
145: || l_return_status|| ', x_msg_data:' || l_msg_data ||
265: wdj.project_id,
266: wdj.task_id,
267: wro.date_required date_required,
268: (wro.required_quantity - wro.quantity_issued
269: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
270: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
271: - Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0) ) AS requested_quantity
272: from wip_entities we,
273: wip_discrete_jobs wdj,
292: --and wdj.MATERIAL_ISSUE_BY_MO LIKE 'Y' --only for workorders that have Enable Material Request as Yes
293: and we.organization_id = p_organization_id
294: and (wo.count_point_type in (1,2) or wo.count_point_type is null)
295: and wro.required_quantity > (wro.quantity_issued +
296: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
297: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)+ Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0))
298: and wro.date_required < sysdate + p_days_forward
299: order by date_required, we.wip_entity_id;
300: /*
307: and wro.wip_entity_id = wo.wip_entity_id(+)
308: and wro.operation_seq_num = wo.operation_seq_num(+)
309: and (wo.count_point_type in (1,2) or wo.count_point_type is null)
310: and wro.required_quantity > (wro.quantity_issued +
311: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
312: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)+ Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0))
313: and wro.date_required < sysdate + p_days_forward)
314: order by date_required, we.wip_entity_id;
315: --changed for 14271265
321: l_projectID NUMBER;
322: l_taskID NUMBER;
323: --i NUMBER := 0;
324: eam_i NUMBER := 0;
325: -- l_allocTbl wip_picking_pub.allocate_tbl_t;
326: l_alloc_comp_tbl_t wip_picking_pub.allocate_comp_tbl_t;
327: l_returnStatus VARCHAR2(1);
328: l_msgData VARCHAR2(2000);
329: l_picksetFlag VARCHAR2(1);
322: l_taskID NUMBER;
323: --i NUMBER := 0;
324: eam_i NUMBER := 0;
325: -- l_allocTbl wip_picking_pub.allocate_tbl_t;
326: l_alloc_comp_tbl_t wip_picking_pub.allocate_comp_tbl_t;
327: l_returnStatus VARCHAR2(1);
328: l_msgData VARCHAR2(2000);
329: l_picksetFlag VARCHAR2(1);
330: l_outBuffer VARCHAR2(240);