APPS.GMD_ITEM_TECHNICAL_DATA_PVT dependencies on GMD_TECHNICAL_DATA_HDR

Line 83: INSERT INTO GMD_TECHNICAL_DATA_HDR (

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

Line 386: UPDATE gmd_technical_data_hdr

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

Line 441: FROM gmd_technical_data_hdr h

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