APPS.GMD_ITEM_TECHNICAL_DATA_PVT dependencies on GMD_TECHNICAL_DATA_HDR

Line 82: INSERT INTO GMD_TECHNICAL_DATA_HDR (

78: l_tech_data_id := x_tech_data_id;
79: END IF;
80: x_tech_data_id := l_tech_data_id;
81:
82: INSERT INTO GMD_TECHNICAL_DATA_HDR (
83: TECH_DATA_ID,
84: INVENTORY_ITEM_ID,
85: ORGANIZATION_ID,
86: LOT_ORGANIZATION_ID,

Line 385: UPDATE gmd_technical_data_hdr

381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: IF p_tech_data_id IS NOT NULL THEN
384: -- Delete in OPM is not Physical delete; Set delete mark to 1 (Mark for Purge)
385: UPDATE gmd_technical_data_hdr
386: SET DELETE_MARK = 1
387: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID
388: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
389: ,LAST_UPDATE_DATE = SYSDATE

Line 440: FROM gmd_technical_data_hdr h

436:
437: -- Cursor to fetch the tech_data_id based on the input data
438: CURSOR get_tech_data_id IS
439: SELECT tech_data_id
440: FROM gmd_technical_data_hdr h
441: WHERE h.inventory_item_id = p_header_rec.inventory_item_id
442: AND h.organization_id = p_header_rec.organization_id
443: AND (h.lot_number = p_header_rec.Lot_Number OR p_header_rec.Lot_Number IS NULL)
444: AND (h.lot_organization_id = p_header_rec.lot_organization_id OR p_header_rec.lot_organization_id IS NULL)