APPS.GMD_QC_TESTS_PVT dependencies on GMD_QC_TESTS_B

Line 70: CURSOR C IS SELECT ROWID FROM gmd_qc_tests_b

66: X_LAST_UPDATED_BY in NUMBER,
67: X_LAST_UPDATE_LOGIN in NUMBER,
68: X_TEST_GROUP_ORDER IN NUMBER
69: ) is
70: CURSOR C IS SELECT ROWID FROM gmd_qc_tests_b
71: WHERE TEST_ID = X_TEST_ID
72: ;
73:
74: BEGIN

Line 80: insert into GMD_QC_TESTS_B (

76: IF X_TEST_ID IS NULL THEN
77: SELECT GMD_QC_TEST_ID_S.NEXTVAL INTO X_TEST_ID FROM DUAL;
78: END IF;
79:
80: insert into GMD_QC_TESTS_B (
81: TEST_OPRN_LINE_ID,
82: TEST_PROVIDER_CODE,
83: DELETE_MARK,
84: TEXT_CODE,

Line 448: from GMD_QC_TESTS_B

444: REPORT_PRECISION,
445: PRIORITY,
446: TEST_OPRN_ID,
447: TEST_GROUP_ORDER
448: from GMD_QC_TESTS_B
449: where TEST_ID = X_TEST_ID
450: for update of TEST_ID nowait;
451: recinfo c%rowtype;
452:

Line 665: update GMD_QC_TESTS_B set

661: X_LAST_UPDATE_LOGIN in NUMBER,
662: X_TEST_GROUP_ORDER IN NUMBER
663: ) is
664: begin
665: update GMD_QC_TESTS_B set
666: TEST_OPRN_LINE_ID = X_TEST_OPRN_LINE_ID,
667: TEST_PROVIDER_CODE = X_TEST_PROVIDER_CODE,
668: DELETE_MARK = X_DELETE_MARK,
669: TEXT_CODE = X_TEXT_CODE,

Line 752: from GMD_QC_TESTS_B B

748: begin
749: delete from GMD_QC_TESTS_TL T
750: where not exists
751: (select NULL
752: from GMD_QC_TESTS_B B
753: where B.TEST_ID = T.TEST_ID
754: );
755:
756: update GMD_QC_TESTS_TL T set (

Line 859: FROM gmd_qc_tests_b

855:
856: IF (p_test_id IS NOT NULL) THEN
857: SELECT test_id
858: INTO dummy
859: FROM gmd_qc_tests_b
860: WHERE test_id = p_test_id
861: FOR UPDATE OF test_id NOWAIT ;
862: ELSIF (p_test_code IS NOT NULL) THEN
863: SELECT test_id

Line 865: FROM gmd_qc_tests_b

861: FOR UPDATE OF test_id NOWAIT ;
862: ELSIF (p_test_code IS NOT NULL) THEN
863: SELECT test_id
864: INTO dummy
865: FROM gmd_qc_tests_b
866: WHERE test_code = p_test_code
867: FOR UPDATE OF test_id NOWAIT ;
868: ELSE
869: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_QC_TESTS');

Line 899: UPDATE gmd_qc_tests_b

895:
896: BEGIN
897:
898: IF (p_test_id IS NOT NULL) THEN
899: UPDATE gmd_qc_tests_b
900: SET delete_mark = 1,
901: last_update_date = NVL(p_last_update_date,SYSDATE),
902: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
903: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)

Line 909: UPDATE gmd_qc_tests_b

905: IF SQL%NOTFOUND THEN
906: RAISE NO_DATA_FOUND ;
907: END IF;
908: ELSIF (p_test_code IS NOT NULL) THEN
909: UPDATE gmd_qc_tests_b
910: SET delete_mark = 1,
911: last_update_date = NVL(p_last_update_date,SYSDATE),
912: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
913: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)