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 1242: FROM wip_lpn_completions_lots

1238: v9,d18,n24,v10,n25,n26,v11,n27,v12,v13,v14,
1239: v15,v16,
1240: n28,v17,d19,d20 -- bug 12708745
1241:
1242: FROM wip_lpn_completions_lots
1243: WHERE header_id = p_ref_id
1244: AND lot_number = p_lot;
1245:
1246:

Line 1826: FROM wip_lpn_completions_lots

1822: ,ORIGINATION_TYPE
1823: ,EXPIRATION_ACTION_CODE
1824: ,EXPIRATION_ACTION_DATE
1825: ,HOLD_DATE
1826: FROM wip_lpn_completions_lots
1827: WHERE header_id = p_header_id
1828: AND lot_number = p_lot_number
1829: );
1830:

Line 1837: FROM wip_lpn_completions_lots

1833: /* bug4073725 changes start */
1834: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1835: SELECT status_id
1836: INTO l_status_id
1837: FROM wip_lpn_completions_lots
1838: WHERE header_id = p_header_id
1839: AND lot_number = p_lot_number;
1840: IF ( l_status_id IS NOT NULL ) THEN
1841: l_status_rec.update_method := inv_material_status_pub.g_update_method_auto;