DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on WSH_PICKING_BATCHES

Line 1344: FROM WSH_PICKING_BATCHES

1340: NVL(END_DATE_ACTIVE, SYSDATE + 1);
1341:
1342: CURSOR batch(x_batch_name IN VARCHAR2) IS
1343: SELECT batch_id
1344: FROM WSH_PICKING_BATCHES
1345: WHERE NAME = x_batch_name;
1346:
1347: CURSOR move_order(x_batch_name IN VARCHAR2) IS
1348: SELECT header_id

Line 1396: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ;

1392: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_process_pvt.process_sales_order';
1393:
1394: /* pick release rule api changes/srl reservations changes *
1395: */
1396: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ;
1397: l_ret_status varchar2(1);
1398: l_reservation_id number;
1399:
1400: cursor c_srl_reservation(p_srl_num varchar2, p_item_id number) is

Line 1752: WSH_PICKING_BATCHES_GRP.Create_Batch(

1748: end if;
1749: end if;
1750: Debug(' pick_confirm_flag['||l_batch_Rec.auto_pick_confirm_flag||']',l_mod_name, 1);
1751:
1752: WSH_PICKING_BATCHES_GRP.Create_Batch(
1753: p_api_version_number => 1.0,
1754: p_init_msg_list => FND_API.G_FALSE,
1755: p_commit => FND_API.G_FALSE,
1756: x_return_status => l_ret_status,

Line 1772: wsh_picking_batches_pub.Release_Batch (

1768: RAISE Fnd_Api.G_EXC_ERROR;
1769: END IF;
1770: Debug('Batch created batch_id=['||l_batch_id||']',l_mod_name,1);
1771:
1772: wsh_picking_batches_pub.Release_Batch (
1773: -- Standard parameters
1774: p_api_version => 1.0,
1775: p_init_msg_list => Fnd_API.G_False,
1776: p_commit => Fnd_API.G_False,