DBA Data[Home] [Help]

APPS.GMD_QC_TESTS_PUB dependencies on GMD_QC_TESTS_PVT

Line 198: IF NOT GMD_QC_TESTS_PVT.INSERT_ROW(

194: l_qc_tests_rec.created_by := l_user_id;
195: l_qc_tests_rec.last_updated_by := l_user_id;
196: l_qc_tests_rec.test_id := NULL;
197:
198: IF NOT GMD_QC_TESTS_PVT.INSERT_ROW(
199: p_qc_tests_rec => l_qc_tests_rec) THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:

Line 235: IF NOT GMD_QC_TESTS_PVT.fetch_row

231: END IF;
232:
233: l_qc_tests_rec_in.test_id := p_qc_test_values_tbl(1).test_id;
234:
235: IF NOT GMD_QC_TESTS_PVT.fetch_row
236: ( p_gmd_qc_tests => l_qc_tests_rec_in,
237: x_gmd_qc_tests => l_qc_tests_rec) THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;

Line 339: IF NOT GMD_QC_TESTS_PVT.fetch_row

335: END IF;
336:
337: l_qc_tests_rec_in.test_id := p_qc_cust_tests_tbl(1).test_id;
338:
339: IF NOT GMD_QC_TESTS_PVT.fetch_row
340: (
341: p_gmd_qc_tests => l_qc_tests_rec_in,
342: x_gmd_qc_tests => l_qc_tests_rec
343: ) THEN

Line 535: IF NOT GMD_QC_TESTS_PVT.fetch_row (

531: END IF;
532:
533: -- Fetch the Test Header Row.
534:
535: IF NOT GMD_QC_TESTS_PVT.fetch_row (
536: p_gmd_qc_tests => l_qc_tests_rec_in,
537: x_gmd_qc_tests => l_qc_tests_rec) THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;

Line 555: IF NOT GMD_QC_TESTS_PVT.lock_row

551:
552:
553: -- LOCK Header Row
554:
555: IF NOT GMD_QC_TESTS_PVT.lock_row
556: ( p_test_id => l_qc_tests_rec.test_id,
557: p_test_code => l_qc_tests_rec.test_code
558: ) THEN
559: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 568: IF NOT GMD_QC_TESTS_PVT.mark_for_delete(

564: RAISE FND_API.G_EXC_ERROR;
565: ELSE
566:
567: -- Mark this record for Purge
568: IF NOT GMD_QC_TESTS_PVT.mark_for_delete(
569: p_test_id => l_qc_tests_rec.test_id,
570: p_test_code => l_qc_tests_rec.test_code,
571: p_last_update_date => SYSDATE,
572: p_last_updated_by => l_user_id,

Line 700: IF NOT GMD_QC_TESTS_PVT.fetch_row(

696: END IF;
697:
698: -- Fetch test Header Row.
699:
700: IF NOT GMD_QC_TESTS_PVT.fetch_row(
701: p_gmd_qc_tests => l_qc_tests_rec_in,
702: x_gmd_qc_tests => l_qc_tests_rec) THEN
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;

Line 708: IF NOT GMD_QC_TESTS_PVT.lock_row(

704: END IF;
705:
706: -- NOW LOCK THIS HEADER ROW !!!!!
707:
708: IF NOT GMD_QC_TESTS_PVT.lock_row(
709: p_test_id => l_qc_tests_rec.test_id,
710: p_test_code => l_qc_tests_rec.test_code) THEN
711: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
712: 'l_table_name', 'GMD_QC_TESTS',

Line 905: IF NOT GMD_QC_TESTS_PVT.fetch_row(

901: END IF;
902:
903: -- Fetch test Header Row.
904:
905: IF NOT GMD_QC_TESTS_PVT.fetch_row(
906: p_gmd_qc_tests => l_qc_tests_rec_in,
907: x_gmd_qc_tests => l_qc_tests_rec) THEN
908: RAISE FND_API.G_EXC_ERROR;
909: END IF;

Line 913: IF NOT GMD_QC_TESTS_PVT.lock_row(

909: END IF;
910:
911: -- NOW LOCK THIS HEADER ROW !!!!!
912:
913: IF NOT GMD_QC_TESTS_PVT.lock_row(
914: p_test_id => l_qc_tests_rec.test_id,
915: p_test_code => l_qc_tests_rec.test_code) THEN
916: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
917: 'l_table_name', 'GMD_QC_TESTS',