APPS.GMD_ITEM_TECHNICAL_DATA_PVT dependencies on GMD_TECHNICAL_DATA_DTL

Line 195: INSERT INTO GMD_TECHNICAL_DATA_DTL (

191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: INSERT INTO GMD_TECHNICAL_DATA_DTL (
196: TECH_DATA_ID,
197: TECH_PARM_ID,
198: SORT_SEQ,
199: TEXT_DATA,

Line 302: UPDATE gmd_technical_data_dtl

298: -- Initialize API return status to success
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: IF (p_tech_data_id IS NOT NULL AND x_tech_parm_id IS NOT NULL) THEN
302: UPDATE gmd_technical_data_dtl
303: SET SORT_SEQ = p_sort_seq
304: , TEXT_DATA = p_text_data
305: , NUM_DATA = p_num_data
306: , BOOLEAN_DATA = p_boolean_data

Line 454: FROM gmd_technical_data_dtl

450:
451: -- Cursor to fetch technical data rec's based on tech_data_id
452: CURSOR get_tech_data_rec (l_tech_data_id NUMBER) IS
453: SELECT tech_parm_id, text_code, text_data, num_data, boolean_data, sort_seq
454: FROM gmd_technical_data_dtl
455: WHERE tech_data_id = l_tech_data_id;
456:
457: -- Cursor to fetch data type for the technical parameter passed
458: CURSOR get_tech_data_type (l_tech_parm_id NUMBER, l_orgn_id NUMBER) IS