DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on WSH_PICKING_BATCHES

Line 1307: FROM WSH_PICKING_BATCHES

1303: NVL(END_DATE_ACTIVE, SYSDATE + 1);
1304:
1305: CURSOR batch(x_batch_name IN VARCHAR2) IS
1306: SELECT batch_id
1307: FROM WSH_PICKING_BATCHES
1308: WHERE NAME = x_batch_name;
1309:
1310: CURSOR move_order(x_batch_name IN VARCHAR2) IS
1311: SELECT header_id

Line 1359: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ;

1355: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1356:
1357: /* pick release rule api changes/srl reservations changes *
1358: */
1359: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ;
1360: l_ret_status varchar2(1);
1361: l_reservation_id number;
1362:
1363: cursor c_srl_reservation(p_srl_num varchar2, p_item_id number) is

Line 1715: WSH_PICKING_BATCHES_GRP.Create_Batch(

1711: end if;
1712: end if;
1713: Debug(' pick_confirm_flag['||l_batch_Rec.auto_pick_confirm_flag||']',l_mod_name, 1);
1714:
1715: WSH_PICKING_BATCHES_GRP.Create_Batch(
1716: p_api_version_number => 1.0,
1717: p_init_msg_list => FND_API.G_FALSE,
1718: p_commit => FND_API.G_FALSE,
1719: x_return_status => l_ret_status,

Line 1735: wsh_picking_batches_pub.Release_Batch (

1731: RAISE Fnd_Api.G_EXC_ERROR;
1732: END IF;
1733: Debug('Batch created batch_id=['||l_batch_id||']',l_mod_name,1);
1734:
1735: wsh_picking_batches_pub.Release_Batch (
1736: -- Standard parameters
1737: p_api_version => 1.0,
1738: p_init_msg_list => Fnd_API.G_False,
1739: p_commit => Fnd_API.G_False,