eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_USA_INV_PVT dependencies on WSH_INTEGRATION

Line 764: WSH_INTEGRATION.DBI_Update_Detail_Log

760: IF l_debug_on THEN
761: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',p_delivery_detail_id);
762: END IF;
763: l_detail_tab(1) := p_delivery_detail_id;
764: WSH_INTEGRATION.DBI_Update_Detail_Log
765: (p_delivery_detail_id_tab => l_detail_tab,
766: p_dml_type => 'UPDATE',
767: x_return_status => l_dbi_rs);
768:

Line 3088: WSH_INTEGRATION.DBI_Update_Detail_Log

3084: IF l_debug_on THEN
3085: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',p_delivery_detail_split_rec.delivery_detail_id);
3086: END IF;
3087: l_detail_tab(1) := p_delivery_detail_split_rec.delivery_detail_id;
3088: WSH_INTEGRATION.DBI_Update_Detail_Log
3089: (p_delivery_detail_id_tab => l_detail_tab,
3090: p_dml_type => 'UPDATE',
3091: x_return_status => l_dbi_rs);
3092:

Line 3595: l_InvPCOutRecType WSH_INTEGRATION.InvPCOutRecType;

3591:
3592: l_dummy_quantity NUMBER;
3593:
3594: -- bug 2805603 : added following variables for call to get_inv_pc_attributes and set_inv_pc_attributes
3595: l_InvPCOutRecType WSH_INTEGRATION.InvPCOutRecType;
3596: l_InvPCInRecType WSH_INTEGRATION.InvPCInRecType;
3597: l_transaction_id NUMBER;
3598: l_transaction_temp_id wsh_delivery_Details.transaction_temp_id%type;
3599: l_msg_count NUMBER;

Line 3596: l_InvPCInRecType WSH_INTEGRATION.InvPCInRecType;

3592: l_dummy_quantity NUMBER;
3593:
3594: -- bug 2805603 : added following variables for call to get_inv_pc_attributes and set_inv_pc_attributes
3595: l_InvPCOutRecType WSH_INTEGRATION.InvPCOutRecType;
3596: l_InvPCInRecType WSH_INTEGRATION.InvPCInRecType;
3597: l_transaction_id NUMBER;
3598: l_transaction_temp_id wsh_delivery_Details.transaction_temp_id%type;
3599: l_msg_count NUMBER;
3600: l_msg_data VARCHAR2(2000);

Line 3723: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Get_Inv_PC_Attributes' );

3719: -- Debug Statements
3720: --
3721: IF l_debug_on THEN
3722: WSH_DEBUG_SV.logmsg(l_module_name, 'IN UPDATE_INVENTORY_INFO PROCEDURE ...' );
3723: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Get_Inv_PC_Attributes' );
3724: END IF;
3725: --
3726: -- bug 2805603 : added call to get_inv_pc_attributes and set_inv_pc_attributes to get transaction_id and transaction_temp_id
3727: WSH_INTEGRATION.Get_Inv_PC_Attributes

Line 3727: WSH_INTEGRATION.Get_Inv_PC_Attributes

3723: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Get_Inv_PC_Attributes' );
3724: END IF;
3725: --
3726: -- bug 2805603 : added call to get_inv_pc_attributes and set_inv_pc_attributes to get transaction_id and transaction_temp_id
3727: WSH_INTEGRATION.Get_Inv_PC_Attributes
3728: ( p_out_attributes => l_InvPCOutRecType,
3729: x_return_status => l_return_status,
3730: x_msg_count => l_msg_count,
3731: x_msg_data => l_msg_data) ;

Line 3766: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Set_Inv_PC_Attributes' );

3762: l_InvPCInRecType.source_code := 'INV';
3763: l_InvPCInRecType.api_version_number := 1.0;
3764: --
3765: IF l_debug_on THEN
3766: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Set_Inv_PC_Attributes' );
3767: END IF;
3768: --
3769: WSH_INTEGRATION.Set_Inv_PC_Attributes
3770: ( p_in_attributes => l_InvPCInRecType,

Line 3769: WSH_INTEGRATION.Set_Inv_PC_Attributes

3765: IF l_debug_on THEN
3766: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Set_Inv_PC_Attributes' );
3767: END IF;
3768: --
3769: WSH_INTEGRATION.Set_Inv_PC_Attributes
3770: ( p_in_attributes => l_InvPCInRecType,
3771: x_return_status => l_return_status,
3772: x_msg_count => l_msg_count,
3773: x_msg_data => l_msg_data );

Line 4240: WSH_INTEGRATION.DBI_Update_Detail_Log

4236: IF l_debug_on THEN
4237: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',old_delivery_detail_rec.delivery_detail_id);
4238: END IF;
4239: l_detail_tab(1) := old_delivery_detail_rec.delivery_detail_id;
4240: WSH_INTEGRATION.DBI_Update_Detail_Log
4241: (p_delivery_detail_id_tab => l_detail_tab,
4242: p_dml_type => 'UPDATE',
4243: x_return_status => l_dbi_rs);
4244:

Line 4357: WSH_INTEGRATION.DBI_Update_Detail_Log

4353: IF l_debug_on THEN
4354: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_dummy_detail_id);
4355: END IF;
4356: l_detail_tab(1) := l_dummy_detail_id;
4357: WSH_INTEGRATION.DBI_Update_Detail_Log
4358: (p_delivery_detail_id_tab => l_detail_tab,
4359: p_dml_type => 'UPDATE',
4360: x_return_status => l_dbi_rs);
4361:

Line 4515: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.FIRST;

4511: g_ship_model_id := NULL ;
4512: g_backordered_item := NULL ;
4513: g_top_model_item := NULL ;
4514: g_ship_set_name := NULL ;
4515: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.FIRST;
4516: WHILE l_backorder_cnt IS NOT NULL LOOP
4517: --
4518: -- Debug Statements
4519: --

Line 4521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4517: --
4518: -- Debug Statements
4519: --
4520: IF l_debug_on THEN
4521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4522: END IF;
4523: --
4524: IF NVL(old_delivery_detail_rec.ship_set_id,0) =
4525: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN

Line 4525: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN

4521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4522: END IF;
4523: --
4524: IF NVL(old_delivery_detail_rec.ship_set_id,0) =
4525: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN
4526: g_ss_smc_found := TRUE;
4527: --
4528: IF l_debug_on THEN
4529: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 4529: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4525: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN
4526: g_ss_smc_found := TRUE;
4527: --
4528: IF l_debug_on THEN
4529: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4530: END IF;
4531: --
4532: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4533: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;

Line 4532: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;

4528: IF l_debug_on THEN
4529: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4530: END IF;
4531: --
4532: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4533: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
4534: --
4535: IF l_debug_on THEN
4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 4533: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;

4529: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4530: END IF;
4531: --
4532: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4533: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
4534: --
4535: IF l_debug_on THEN
4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4537: END IF;

Line 4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4532: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4533: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
4534: --
4535: IF l_debug_on THEN
4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4537: END IF;
4538: --
4539: g_ship_set_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id;
4540: g_ship_model_id := NULL;

Line 4539: g_ship_set_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id;

4535: IF l_debug_on THEN
4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4537: END IF;
4538: --
4539: g_ship_set_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id;
4540: g_ship_model_id := NULL;
4541: --
4542: IF g_delivery_detail_id IS NOT NULL THEN
4543: SELECT inventory_item_id

Line 4577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);

4573: --
4574: -- Debug Statements
4575: --
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
4578: END IF;
4579: --
4580: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
4581: EXIT;

Line 4580: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);

4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
4578: END IF;
4579: --
4580: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
4581: EXIT;
4582: END IF;
4583: --
4584: -- Debug Statements

Line 4587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

4583: --
4584: -- Debug Statements
4585: --
4586: IF l_debug_on THEN
4587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
4588: END IF;
4589: --
4590: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
4591: END LOOP;

Line 4590: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);

4586: IF l_debug_on THEN
4587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
4588: END IF;
4589: --
4590: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
4591: END LOOP;
4592: ELSIF old_delivery_detail_rec.ship_set_id IS NULL AND
4593: ( NVL(old_delivery_detail_rec.top_model_line_id,0) <> NVL(g_ship_model_id,0) ) THEN
4594: --

Line 4609: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.FIRST;

4605: g_ship_model_id := NULL ;
4606: g_backordered_item := NULL ;
4607: g_top_model_item := NULL ;
4608: g_ship_set_name := NULL ;
4609: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.FIRST;
4610: WHILE l_backorder_cnt IS NOT NULL LOOP
4611: --
4612: -- Debug Statements
4613: --

Line 4615: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4611: --
4612: -- Debug Statements
4613: --
4614: IF l_debug_on THEN
4615: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4616: END IF;
4617: --
4618: IF NVL(old_delivery_detail_rec.top_model_line_id,0) =
4619: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id,0) THEN

Line 4619: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id,0) THEN

4615: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4616: END IF;
4617: --
4618: IF NVL(old_delivery_detail_rec.top_model_line_id,0) =
4619: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id,0) THEN
4620: -- Consider Ship Model as Ship Set is not present
4621: g_ss_smc_found := TRUE;
4622: --
4623: -- Debug Statements

Line 4626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4622: --
4623: -- Debug Statements
4624: --
4625: IF l_debug_on THEN
4626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4627: END IF;
4628: --
4629: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4630: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;

Line 4629: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;

4625: IF l_debug_on THEN
4626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4627: END IF;
4628: --
4629: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4630: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
4631: g_ship_set_id := NULL;
4632:
4633: -- Debug Statements

Line 4630: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;

4626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4627: END IF;
4628: --
4629: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
4630: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
4631: g_ship_set_id := NULL;
4632:
4633: -- Debug Statements
4634: --

Line 4636: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

4632:
4633: -- Debug Statements
4634: --
4635: IF l_debug_on THEN
4636: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4637: WSH_DEBUG_SV.logmsg(l_module_name, 'FOUND NEW G_MOVE_ORDER_LINE_ID = ' || G_MOVE_ORDER_LINE_ID ||
4638: ' G_DELIVERY_DETAIL_ID = ' || G_DELIVERY_DETAIL_ID );
4639: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
4640: END IF;

Line 4639: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);

4635: IF l_debug_on THEN
4636: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
4637: WSH_DEBUG_SV.logmsg(l_module_name, 'FOUND NEW G_MOVE_ORDER_LINE_ID = ' || G_MOVE_ORDER_LINE_ID ||
4638: ' G_DELIVERY_DETAIL_ID = ' || G_DELIVERY_DETAIL_ID );
4639: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
4640: END IF;
4641: --
4642: g_ship_model_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id;
4643:

Line 4642: g_ship_model_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id;

4638: ' G_DELIVERY_DETAIL_ID = ' || G_DELIVERY_DETAIL_ID );
4639: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
4640: END IF;
4641: --
4642: g_ship_model_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id;
4643:
4644:
4645: IF g_delivery_detail_id IS NOT NULL THEN
4646: SELECT inventory_item_id

Line 4671: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);

4667: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
4668: --
4669: g_top_model_item := WSH_UTIL_CORE.Get_Item_Name(l_top_model_item_id,old_delivery_detail_rec.organization_id);
4670: --
4671: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
4672: EXIT;
4673: END IF;
4674: --
4675: -- Debug Statements

Line 4678: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

4674: --
4675: -- Debug Statements
4676: --
4677: IF l_debug_on THEN
4678: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
4679: END IF;
4680: --
4681: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
4682: END LOOP;

Line 4681: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);

4677: IF l_debug_on THEN
4678: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
4679: END IF;
4680: --
4681: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
4682: END LOOP;
4683: END IF;
4684:
4685: --

Line 6207: WSH_INTEGRATION.DBI_Update_Detail_Log

6203: IF l_debug_on THEN
6204: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_dummy_detail_id);
6205: END IF;
6206: l_detail_tab(1) := l_dummy_detail_id;
6207: WSH_INTEGRATION.DBI_Update_Detail_Log
6208: (p_delivery_detail_id_tab => l_detail_tab,
6209: p_dml_type => 'UPDATE',
6210: x_return_status => l_dbi_rs);
6211: