DBA Data[Home] [Help]

APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_RESULT_TRANSFER_GT

Line 172: --GMD_API_PUB.Log_Message('Deleting gmd_result_transfer_gt');

168:
169: BEGIN
170: x_return_status :=FND_API.G_RET_STS_SUCCESS;
171: FND_MSG_PUB.initialize;
172: --GMD_API_PUB.Log_Message('Deleting gmd_result_transfer_gt');
173: l_place := 0;
174: DELETE gmd_result_transfer_gt;
175: l_place := 10;
176: IF (p_transfer_type = 'S') THEN

Line 174: DELETE gmd_result_transfer_gt;

170: x_return_status :=FND_API.G_RET_STS_SUCCESS;
171: FND_MSG_PUB.initialize;
172: --GMD_API_PUB.Log_Message('Deleting gmd_result_transfer_gt');
173: l_place := 0;
174: DELETE gmd_result_transfer_gt;
175: l_place := 10;
176: IF (p_transfer_type = 'S') THEN
177: l_place := 20;
178:

Line 254: INSERT INTO gmd_result_transfer_gt

250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: l_test_code := get_test_code(l_test_id);
253:
254: INSERT INTO gmd_result_transfer_gt
255: (parent_result_id,
256: child_result_id,
257: test_code,
258: result,

Line 296: INSERT INTO gmd_result_transfer_gt

292: CLOSE c_get_child_composite;
293: l_place := 130;
294: --INSERT Statement
295: l_test_code := get_test_code(c_get_composite_test_row.test_id);
296: INSERT INTO gmd_result_transfer_gt
297: (parent_result_id,
298: child_result_id,
299: test_code,
300: result,

Line 383: FROM GMD_RESULT_TRANSFER_GT A,

379: b.ATTRIBUTE27,
380: b.ATTRIBUTE28,
381: b.ATTRIBUTE29,
382: b.ATTRIBUTE30
383: FROM GMD_RESULT_TRANSFER_GT A,
384: gmd_results b
385: WHERE b.result_id = a.parent_result_id
386: ;
387:

Line 455: GMD_RESULT_TRANSFER_GT A

451: r.ATTRIBUTE28,
452: r.ATTRIBUTE29,
453: r.ATTRIBUTE30
454: FROM gmd_composite_results r,
455: GMD_RESULT_TRANSFER_GT A
456: WHERE r.composite_result_id = a.parent_result_id;
457:
458:
459: cursor c_action_code (p_sample_id IN NUMBER) IS