[Home] [Help]
190:
191: -- Initialize API return status to success
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: INSERT INTO GMD_TECHNICAL_DATA_DTL (
195: TECH_DATA_ID,
196: TECH_PARM_ID,
197: SORT_SEQ,
198: TEXT_DATA,
297: -- Initialize API return status to success
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: IF (p_tech_data_id IS NOT NULL AND x_tech_parm_id IS NOT NULL) THEN
301: UPDATE gmd_technical_data_dtl
302: SET SORT_SEQ = p_sort_seq
303: , TEXT_DATA = p_text_data
304: , NUM_DATA = p_num_data
305: , BOOLEAN_DATA = p_boolean_data
449:
450: -- Cursor to fetch technical data rec's based on tech_data_id
451: CURSOR get_tech_data_rec (l_tech_data_id NUMBER) IS
452: SELECT tech_parm_id, text_code, text_data, num_data, boolean_data, sort_seq
453: FROM gmd_technical_data_dtl
454: WHERE tech_data_id = l_tech_data_id;
455:
456: -- Cursor to fetch data type for the technical parameter passed
457: CURSOR get_tech_data_type (l_tech_parm_id NUMBER, l_orgn_id NUMBER) IS