APPS.WMS_WIP_INTEGRATION dependencies on WIP_LPN_COMPLETIONS_LOTS

Line 91: multiple lots in wip_lpn_completions_lots for the given header_id. */

87: WHERE header_id = l_temp_header_id
88: AND lot_number IS NULL;
89:
90: /* Bug: 2976160 : cursor defined to replace 'Select INTO ' to support
91: multiple lots in wip_lpn_completions_lots for the given header_id. */
92: CURSOR wip_lpn_comp_lots_csr IS
93: SELECT lot_number
94: FROM wip_lpn_completions_lots
95: WHERE header_id = l_temp_header_id;

Line 94: FROM wip_lpn_completions_lots

90: /* Bug: 2976160 : cursor defined to replace 'Select INTO ' to support
91: multiple lots in wip_lpn_completions_lots for the given header_id. */
92: CURSOR wip_lpn_comp_lots_csr IS
93: SELECT lot_number
94: FROM wip_lpn_completions_lots
95: WHERE header_id = l_temp_header_id;
96: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
97: BEGIN
98: l_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 603: FROM wip_lpn_completions_lots

599: N_ATTRIBUTE10,
600: vendor_name,
601: supplier_lot_number,
602: territory_code
603: FROM wip_lpn_completions_lots
604: WHERE header_id = l_temp_header_id);
605:
606:
607: IF (l_debug = 1) THEN

Line 612: wms_wip_integration.insert_lot for each lot in wip_lpn_completions_lots table,

608: mydebug('Backflush: Loop thru wip_lpn_comp_lots_rec ');
609: END IF;
610:
611: /* Bug: 2976160 : replaced Select INTO with cursor loop to call
612: wms_wip_integration.insert_lot for each lot in wip_lpn_completions_lots table,
613: for the given header_id. there can be more than one lot . */
614: FOR wip_lpn_comp_lots_rec in wip_lpn_comp_lots_csr
615: LOOP
616: IF (l_debug = 1) THEN

Line 1229: FROM wip_lpn_completions_lots

1225: v1,v2,n20,v4,d14,v5,v6,n21,d15,d16,n22,v7,n23,v8,
1226: v9,d18,n24,v10,n25,n26,v11,n27,v12,v13,v14,
1227: v15,v16
1228:
1229: FROM wip_lpn_completions_lots
1230: WHERE header_id = p_ref_id
1231: AND lot_number = p_lot;
1232:
1233:

Line 1796: FROM wip_lpn_completions_lots

1792: ,N_ATTRIBUTE9
1793: ,territory_code
1794: ,l_object_id
1795: ,status_id
1796: FROM wip_lpn_completions_lots
1797: WHERE header_id = p_header_id
1798: AND lot_number = p_lot_number
1799: );
1800:

Line 1807: FROM wip_lpn_completions_lots

1803: /* bug4073725 changes start */
1804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1805: SELECT status_id
1806: INTO l_status_id
1807: FROM wip_lpn_completions_lots
1808: WHERE header_id = p_header_id
1809: AND lot_number = p_lot_number;
1810: IF ( l_status_id IS NOT NULL ) THEN
1811: l_status_rec.update_method := inv_material_status_pub.g_update_method_auto;