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 777: WSH_INTEGRATION.DBI_Update_Detail_Log

773: IF l_debug_on THEN
774: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',p_delivery_detail_id);
775: END IF;
776: l_detail_tab(1) := p_delivery_detail_id;
777: WSH_INTEGRATION.DBI_Update_Detail_Log
778: (p_delivery_detail_id_tab => l_detail_tab,
779: p_dml_type => 'UPDATE',
780: x_return_status => l_dbi_rs);
781:

Line 3378: WSH_INTEGRATION.DBI_Update_Detail_Log

3374: IF l_debug_on THEN
3375: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',p_delivery_detail_split_rec.delivery_detail_id);
3376: END IF;
3377: l_detail_tab(1) := p_delivery_detail_split_rec.delivery_detail_id;
3378: WSH_INTEGRATION.DBI_Update_Detail_Log
3379: (p_delivery_detail_id_tab => l_detail_tab,
3380: p_dml_type => 'UPDATE',
3381: x_return_status => l_dbi_rs);
3382:

Line 3989: l_InvPCOutRecType WSH_INTEGRATION.InvPCOutRecType;

3985: -- muom
3986: l_dummy_quantity2 NUMBER;
3987:
3988: -- bug 2805603 : added following variables for call to get_inv_pc_attributes and set_inv_pc_attributes
3989: l_InvPCOutRecType WSH_INTEGRATION.InvPCOutRecType;
3990: l_InvPCInRecType WSH_INTEGRATION.InvPCInRecType;
3991: l_transaction_id NUMBER;
3992: l_transaction_temp_id wsh_delivery_Details.transaction_temp_id%type;
3993: l_msg_count NUMBER;

Line 3990: l_InvPCInRecType WSH_INTEGRATION.InvPCInRecType;

3986: l_dummy_quantity2 NUMBER;
3987:
3988: -- bug 2805603 : added following variables for call to get_inv_pc_attributes and set_inv_pc_attributes
3989: l_InvPCOutRecType WSH_INTEGRATION.InvPCOutRecType;
3990: l_InvPCInRecType WSH_INTEGRATION.InvPCInRecType;
3991: l_transaction_id NUMBER;
3992: l_transaction_temp_id wsh_delivery_Details.transaction_temp_id%type;
3993: l_msg_count NUMBER;
3994: l_msg_data VARCHAR2(2000);

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

4126: -- Debug Statements
4127: --
4128: IF l_debug_on THEN
4129: WSH_DEBUG_SV.logmsg(l_module_name, 'IN UPDATE_INVENTORY_INFO PROCEDURE ...' );
4130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Get_Inv_PC_Attributes' );
4131: END IF;
4132: --
4133: -- bug 2805603 : added call to get_inv_pc_attributes and set_inv_pc_attributes to get transaction_id and transaction_temp_id
4134: WSH_INTEGRATION.Get_Inv_PC_Attributes

Line 4134: WSH_INTEGRATION.Get_Inv_PC_Attributes

4130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Get_Inv_PC_Attributes' );
4131: END IF;
4132: --
4133: -- bug 2805603 : added call to get_inv_pc_attributes and set_inv_pc_attributes to get transaction_id and transaction_temp_id
4134: WSH_INTEGRATION.Get_Inv_PC_Attributes
4135: ( p_out_attributes => l_InvPCOutRecType,
4136: x_return_status => l_return_status,
4137: x_msg_count => l_msg_count,
4138: x_msg_data => l_msg_data) ;

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

4169: l_InvPCInRecType.source_code := 'INV';
4170: l_InvPCInRecType.api_version_number := 1.0;
4171: --
4172: IF l_debug_on THEN
4173: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Set_Inv_PC_Attributes' );
4174: END IF;
4175: --
4176: WSH_INTEGRATION.Set_Inv_PC_Attributes
4177: ( p_in_attributes => l_InvPCInRecType,

Line 4176: WSH_INTEGRATION.Set_Inv_PC_Attributes

4172: IF l_debug_on THEN
4173: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_INTEGRATION.Set_Inv_PC_Attributes' );
4174: END IF;
4175: --
4176: WSH_INTEGRATION.Set_Inv_PC_Attributes
4177: ( p_in_attributes => l_InvPCInRecType,
4178: x_return_status => l_return_status,
4179: x_msg_count => l_msg_count,
4180: x_msg_data => l_msg_data );

Line 4774: WSH_INTEGRATION.DBI_Update_Detail_Log

4770: IF l_debug_on THEN
4771: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',old_delivery_detail_rec.delivery_detail_id);
4772: END IF;
4773: l_detail_tab(1) := old_delivery_detail_rec.delivery_detail_id;
4774: WSH_INTEGRATION.DBI_Update_Detail_Log
4775: (p_delivery_detail_id_tab => l_detail_tab,
4776: p_dml_type => 'UPDATE',
4777: x_return_status => l_dbi_rs);
4778:

Line 4891: WSH_INTEGRATION.DBI_Update_Detail_Log

4887: IF l_debug_on THEN
4888: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_dummy_detail_id);
4889: END IF;
4890: l_detail_tab(1) := l_dummy_detail_id;
4891: WSH_INTEGRATION.DBI_Update_Detail_Log
4892: (p_delivery_detail_id_tab => l_detail_tab,
4893: p_dml_type => 'UPDATE',
4894: x_return_status => l_dbi_rs);
4895:

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

5047: g_ship_model_id := NULL ;
5048: g_backordered_item := NULL ;
5049: g_top_model_item := NULL ;
5050: g_ship_set_name := NULL ;
5051: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.FIRST;
5052: WHILE l_backorder_cnt IS NOT NULL LOOP
5053: --
5054: -- Debug Statements
5055: --

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

5053: --
5054: -- Debug Statements
5055: --
5056: IF l_debug_on THEN
5057: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5058: END IF;
5059: --
5060: IF NVL(old_delivery_detail_rec.ship_set_id,0) =
5061: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN

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

5057: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5058: END IF;
5059: --
5060: IF NVL(old_delivery_detail_rec.ship_set_id,0) =
5061: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN
5062: g_ss_smc_found := TRUE;
5063: --
5064: IF l_debug_on THEN
5065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

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

5061: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id,0) THEN
5062: g_ss_smc_found := TRUE;
5063: --
5064: IF l_debug_on THEN
5065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5066: END IF;
5067: --
5068: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5069: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;

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

5064: IF l_debug_on THEN
5065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5066: END IF;
5067: --
5068: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5069: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
5070: --
5071: IF l_debug_on THEN
5072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);

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

5065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5066: END IF;
5067: --
5068: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5069: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
5070: --
5071: IF l_debug_on THEN
5072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5073: END IF;

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

5068: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5069: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
5070: --
5071: IF l_debug_on THEN
5072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5073: END IF;
5074: --
5075: g_ship_set_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id;
5076: g_ship_model_id := NULL;

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

5071: IF l_debug_on THEN
5072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5073: END IF;
5074: --
5075: g_ship_set_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_set_id;
5076: g_ship_model_id := NULL;
5077: --
5078: IF g_delivery_detail_id IS NOT NULL THEN
5079: SELECT inventory_item_id

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

5109: --
5110: -- Debug Statements
5111: --
5112: IF l_debug_on THEN
5113: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
5114: END IF;
5115: --
5116: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
5117: EXIT;

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

5112: IF l_debug_on THEN
5113: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
5114: END IF;
5115: --
5116: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
5117: EXIT;
5118: END IF;
5119: --
5120: -- Debug Statements

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

5119: --
5120: -- Debug Statements
5121: --
5122: IF l_debug_on THEN
5123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
5124: END IF;
5125: --
5126: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
5127: END LOOP;

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

5122: IF l_debug_on THEN
5123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
5124: END IF;
5125: --
5126: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
5127: END LOOP;
5128: ELSIF old_delivery_detail_rec.ship_set_id IS NULL AND
5129: ( NVL(old_delivery_detail_rec.top_model_line_id,0) <> NVL(g_ship_model_id,0) ) THEN
5130: --

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

5141: g_ship_model_id := NULL ;
5142: g_backordered_item := NULL ;
5143: g_top_model_item := NULL ;
5144: g_ship_set_name := NULL ;
5145: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.FIRST;
5146: WHILE l_backorder_cnt IS NOT NULL LOOP
5147: --
5148: -- Debug Statements
5149: --

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

5147: --
5148: -- Debug Statements
5149: --
5150: IF l_debug_on THEN
5151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5152: END IF;
5153: --
5154: IF NVL(old_delivery_detail_rec.top_model_line_id,0) =
5155: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id,0) THEN

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

5151: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5152: END IF;
5153: --
5154: IF NVL(old_delivery_detail_rec.top_model_line_id,0) =
5155: NVL(WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id,0) THEN
5156: -- Consider Ship Model as Ship Set is not present
5157: g_ss_smc_found := TRUE;
5158: --
5159: -- Debug Statements

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

5158: --
5159: -- Debug Statements
5160: --
5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5163: END IF;
5164: --
5165: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5166: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;

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

5161: IF l_debug_on THEN
5162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5163: END IF;
5164: --
5165: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5166: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
5167: g_ship_set_id := NULL;
5168:
5169: -- Debug Statements

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

5162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5163: END IF;
5164: --
5165: g_move_order_line_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).move_order_line_id;
5166: g_delivery_detail_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).delivery_detail_id;
5167: g_ship_set_id := NULL;
5168:
5169: -- Debug Statements
5170: --

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

5168:
5169: -- Debug Statements
5170: --
5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5173: WSH_DEBUG_SV.logmsg(l_module_name, 'FOUND NEW G_MOVE_ORDER_LINE_ID = ' || G_MOVE_ORDER_LINE_ID ||
5174: ' G_DELIVERY_DETAIL_ID = ' || G_DELIVERY_DETAIL_ID );
5175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
5176: END IF;

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

5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL',WSH_DEBUG_SV.C_PROC_LEVEL);
5173: WSH_DEBUG_SV.logmsg(l_module_name, 'FOUND NEW G_MOVE_ORDER_LINE_ID = ' || G_MOVE_ORDER_LINE_ID ||
5174: ' G_DELIVERY_DETAIL_ID = ' || G_DELIVERY_DETAIL_ID );
5175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
5176: END IF;
5177: --
5178: g_ship_model_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id;
5179:

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

5174: ' G_DELIVERY_DETAIL_ID = ' || G_DELIVERY_DETAIL_ID );
5175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
5176: END IF;
5177: --
5178: g_ship_model_id := WSH_INTEGRATION.G_BackorderRec_Tbl(l_backorder_cnt).ship_model_id;
5179:
5180:
5181: IF g_delivery_detail_id IS NOT NULL THEN
5182: SELECT inventory_item_id

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

5203: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
5204: --
5205: g_top_model_item := WSH_UTIL_CORE.Get_Item_Name(l_top_model_item_id,old_delivery_detail_rec.organization_id);
5206: --
5207: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
5208: EXIT;
5209: END IF;
5210: --
5211: -- Debug Statements

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

5210: --
5211: -- Debug Statements
5212: --
5213: IF l_debug_on THEN
5214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
5215: END IF;
5216: --
5217: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
5218: END LOOP;

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

5213: IF l_debug_on THEN
5214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTEGRATION.G_BACKORDERREC_TBL.NEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
5215: END IF;
5216: --
5217: l_backorder_cnt := WSH_INTEGRATION.G_BackorderRec_Tbl.NEXT(l_backorder_cnt);
5218: END LOOP;
5219: END IF;
5220:
5221: --

Line 6874: WSH_INTEGRATION.DBI_Update_Detail_Log

6870: IF l_debug_on THEN
6871: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail id-',l_dummy_detail_id);
6872: END IF;
6873: l_detail_tab(1) := l_dummy_detail_id;
6874: WSH_INTEGRATION.DBI_Update_Detail_Log
6875: (p_delivery_detail_id_tab => l_detail_tab,
6876: p_dml_type => 'UPDATE',
6877: x_return_status => l_dbi_rs);
6878: