DBA Data[Home] [Help]

APPS.EAM_MATERIALISSUE_PVT dependencies on WIP_PICKING_PUB

Line 1062: wip_picking_pub.cancel_comp_allocations (p_wip_entity_id => l_wip_entity_id,

1058: l_wip_entity_id := p_wip_entity_id;
1059: l_operation_seq_num := p_operation_seq_num;
1060: l_inventory_item_id := p_inventory_item_id;
1061:
1062: wip_picking_pub.cancel_comp_allocations (p_wip_entity_id => l_wip_entity_id,
1063: p_operation_seq_num => l_operation_seq_num,
1064: p_inventory_item_id => l_inventory_item_id,
1065: p_wip_entity_type => wip_constants.eam,
1066: p_repetitive_schedule_id => NULL,

Line 1162: l_allocate_comp_red_rec wip_picking_pub.allocate_comp_rec_t;

1158:
1159: l_msg_count NUMBER;
1160: l_request_number VARCHAR2(30);
1161:
1162: l_allocate_comp_red_rec wip_picking_pub.allocate_comp_rec_t;
1163: l_allocate_comp_red_tbl wip_picking_pub.allocate_comp_tbl_t;
1164:
1165: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;
1166: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;

Line 1163: l_allocate_comp_red_tbl wip_picking_pub.allocate_comp_tbl_t;

1159: l_msg_count NUMBER;
1160: l_request_number VARCHAR2(30);
1161:
1162: l_allocate_comp_red_rec wip_picking_pub.allocate_comp_rec_t;
1163: l_allocate_comp_red_tbl wip_picking_pub.allocate_comp_tbl_t;
1164:
1165: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;
1166: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;
1167:

Line 1165: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;

1161:
1162: l_allocate_comp_red_rec wip_picking_pub.allocate_comp_rec_t;
1163: l_allocate_comp_red_tbl wip_picking_pub.allocate_comp_tbl_t;
1164:
1165: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;
1166: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;
1167:
1168: BEGIN
1169: -- Standard Start of API savepoint

Line 1166: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;

1162: l_allocate_comp_red_rec wip_picking_pub.allocate_comp_rec_t;
1163: l_allocate_comp_red_tbl wip_picking_pub.allocate_comp_tbl_t;
1164:
1165: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;
1166: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;
1167:
1168: BEGIN
1169: -- Standard Start of API savepoint
1170: SAVEPOINT comp_alloc_chng_qty;

Line 1264: wip_picking_pub.reduce_comp_allocations ( p_comp_tbl => l_allocate_comp_red_tbl,

1260: l_allocate_comp_red_rec.end_serial := null;
1261:
1262: l_allocate_comp_red_tbl(1) := l_allocate_comp_red_rec;
1263:
1264: wip_picking_pub.reduce_comp_allocations ( p_comp_tbl => l_allocate_comp_red_tbl,
1265: p_wip_entity_type => wip_constants.eam,
1266: p_organization_id => l_organization_id,
1267: x_return_status => l_return_status,
1268: x_msg_data => l_msg_data);

Line 1410: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;

1406:
1407: l_msg_count NUMBER;
1408: l_request_number VARCHAR2(80);
1409:
1410: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;
1411: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;
1412:
1413: BEGIN
1414:

Line 1411: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;

1407: l_msg_count NUMBER;
1408: l_request_number VARCHAR2(80);
1409:
1410: l_allocate_comp_inc_rec wip_picking_pub.allocate_comp_rec_t;
1411: l_allocate_comp_inc_tbl wip_picking_pub.allocate_comp_tbl_t;
1412:
1413: BEGIN
1414:
1415: -- Standard Start of API savepoint

Line 1588: l_allocate_rec wip_picking_pub.allocate_rec_t;

1584: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1585: l_msg VARCHAR2(2000);
1586:
1587:
1588: l_allocate_rec wip_picking_pub.allocate_rec_t;
1589: l_allocate_tbl wip_picking_pub.allocate_tbl_t;
1590:
1591: BEGIN
1592:

Line 1589: l_allocate_tbl wip_picking_pub.allocate_tbl_t;

1585: l_msg VARCHAR2(2000);
1586:
1587:
1588: l_allocate_rec wip_picking_pub.allocate_rec_t;
1589: l_allocate_tbl wip_picking_pub.allocate_tbl_t;
1590:
1591: BEGIN
1592:
1593: -- Standard Start of API savepoint

Line 1640: 'Calling wip_picking_pub.allocate');

1636: l_allocate_rec.alt_rtg_dsg := null;
1637: l_allocate_tbl(1) := l_allocate_rec;
1638:
1639: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1640: 'Calling wip_picking_pub.allocate');
1641: end if;
1642: wip_picking_pub.allocate(p_alloc_tbl => l_allocate_tbl,
1643: p_cutoff_date => null,
1644: p_wip_entity_type => wip_constants.eam,

Line 1642: wip_picking_pub.allocate(p_alloc_tbl => l_allocate_tbl,

1638:
1639: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1640: 'Calling wip_picking_pub.allocate');
1641: end if;
1642: wip_picking_pub.allocate(p_alloc_tbl => l_allocate_tbl,
1643: p_cutoff_date => null,
1644: p_wip_entity_type => wip_constants.eam,
1645: p_organization_id => l_organization_id,
1646: x_mo_req_number => l_request_number,

Line 1659: l_msg := 'wip_picking_pub.allocate returned:'|| 'x_return_status:'

1655: x_msg_data := l_msg_data;
1656: end if;
1657:
1658: if (l_sLog) then
1659: l_msg := 'wip_picking_pub.allocate returned:'|| 'x_return_status:'
1660: ||x_return_status||' x_mo_req_number:'||l_request_number;
1661: l_msg := REPLACE(l_msg, CHR(0), ' ');
1662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,l_msg);
1663: end if;

Line 1667: 'Calling wip_picking_pub.cancel_allocations');

1663: end if;
1664:
1665: elsif p_status_type IN (5,7) then --status_type 5 is added for bug 7631627
1666: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1667: 'Calling wip_picking_pub.cancel_allocations');
1668: end if;
1669: wip_picking_pub.cancel_allocations (p_wip_entity_id => l_wip_entity_id,
1670: p_wip_entity_type => wip_constants.eam,
1671: p_repetitive_schedule_id => NULL,

Line 1669: wip_picking_pub.cancel_allocations (p_wip_entity_id => l_wip_entity_id,

1665: elsif p_status_type IN (5,7) then --status_type 5 is added for bug 7631627
1666: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1667: 'Calling wip_picking_pub.cancel_allocations');
1668: end if;
1669: wip_picking_pub.cancel_allocations (p_wip_entity_id => l_wip_entity_id,
1670: p_wip_entity_type => wip_constants.eam,
1671: p_repetitive_schedule_id => NULL,
1672: x_return_status => l_return_status,
1673: x_msg_data => l_msg_data);

Line 1683: 'wip_picking_pub.cancel_allocations returned:'|| 'x_return_status:'

1679: x_msg_data := l_msg_data;
1680: end if;
1681:
1682: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1683: 'wip_picking_pub.cancel_allocations returned:'|| 'x_return_status:'
1684: ||x_return_status);
1685: end if;
1686: end if;
1687: