APPS.GMD_QC_TEST_VALUES_PVT dependencies on GMD_QC_TEST_VALUES_B

Line 52: cursor C is select ROWID from GMD_QC_TEST_VALUES_B

48: X_LAST_UPDATE_DATE in DATE ,
49: X_LAST_UPDATED_BY in NUMBER ,
50: X_LAST_UPDATE_LOGIN in NUMBER
51: ) is
52: cursor C is select ROWID from GMD_QC_TEST_VALUES_B
53: where TEST_VALUE_ID = X_TEST_VALUE_ID
54: ;
55: begin
56:

Line 61: insert into GMD_QC_TEST_VALUES_B (

57: IF X_TEST_VALUE_ID IS NULL THEN
58: SELECT GMD_QC_TEST_VALUE_ID_S.NEXTVAL INTO X_TEST_VALUE_ID FROM DUAL;
59: END IF;
60:
61: insert into GMD_QC_TEST_VALUES_B (
62: TEST_VALUE_ID,
63: TEST_ID,
64: MIN_NUM,
65: MAX_NUM,

Line 335: from GMD_QC_TEST_VALUES_B

331: ATTRIBUTE27,
332: ATTRIBUTE28,
333: ATTRIBUTE29,
334: ATTRIBUTE30
335: from GMD_QC_TEST_VALUES_B
336: where TEST_VALUE_ID = X_TEST_VALUE_ID
337: for update of TEST_VALUE_ID nowait;
338: recinfo c%rowtype;
339:

Line 504: update GMD_QC_TEST_VALUES_B set

500: X_LAST_UPDATED_BY in NUMBER,
501: X_LAST_UPDATE_LOGIN in NUMBER
502: ) is
503: begin
504: update GMD_QC_TEST_VALUES_B set
505: TEST_ID = X_TEST_ID,
506: MIN_NUM = X_MIN_NUM,
507: MAX_NUM = X_MAX_NUM,
508: VALUE_CHAR = X_VALUE_CHAR,

Line 577: delete from GMD_QC_TEST_VALUES_B

573: if (sql%notfound) then
574: raise no_data_found;
575: end if;
576:
577: delete from GMD_QC_TEST_VALUES_B
578: where TEST_VALUE_ID = p_test_value_id;
579:
580: if (sql%notfound) then
581: raise no_data_found;

Line 607: from GMD_QC_TEST_VALUES_B B

603: begin
604: delete from GMD_QC_TEST_VALUES_TL T
605: where not exists
606: (select NULL
607: from GMD_QC_TEST_VALUES_B B
608: where B.TEST_VALUE_ID = T.TEST_VALUE_ID
609: );
610:
611: update GMD_QC_TEST_VALUES_TL T set (

Line 679: FROM gmd_qc_test_values_b

675:
676: IF (p_test_value_id IS NOT NULL) THEN
677: SELECT test_value_id
678: INTO dummy
679: FROM gmd_qc_test_values_b
680: WHERE test_value_id = p_test_value_id
681: FOR UPDATE OF test_value_id NOWAIT ;
682: ELSE
683: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_QC_TEST_VALUES');