eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_TESTS_PVT dependencies on GMD_SPEC_TESTS

Line 1: package body GMD_SPEC_TESTS_PVT as

1: package body GMD_SPEC_TESTS_PVT as
2: /* $Header: GMDVSPTB.pls 120.0 2005/05/25 19:16:49 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SPEC_ID in NUMBER,

Line 87: cursor C is select ROWID from GMD_SPEC_TESTS_B

83: X_TEST_EXPIRATION_SECONDS in number,
84: X_CALC_UOM_CONV_IND in VARCHAR2,
85: X_TO_QTY_UOM in VARCHAR2
86: ) is
87: cursor C is select ROWID from GMD_SPEC_TESTS_B
88: where SPEC_ID = X_SPEC_ID
89: and TEST_ID = X_TEST_ID
90: ;
91: begin

Line 92: insert into GMD_SPEC_TESTS_B (

88: where SPEC_ID = X_SPEC_ID
89: and TEST_ID = X_TEST_ID
90: ;
91: begin
92: insert into GMD_SPEC_TESTS_B (
93: ATTRIBUTE1,
94: ATTRIBUTE2,
95: MIN_VALUE_CHAR,
96: SPEC_ID,

Line 256: insert into GMD_SPEC_TESTS_TL (

252: X_CALC_UOM_CONV_IND,
253: X_TO_QTY_UOM
254: );
255:
256: insert into GMD_SPEC_TESTS_TL (
257: CREATED_BY,
258: LAST_UPDATED_BY,
259: LAST_UPDATE_DATE,
260: LAST_UPDATE_LOGIN,

Line 282: from GMD_SPEC_TESTS_TL T

278: from FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and not exists
281: (select NULL
282: from GMD_SPEC_TESTS_TL T
283: where T.SPEC_ID = X_SPEC_ID
284: and T.TEST_ID = X_TEST_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286:

Line 449: from GMD_SPEC_TESTS_B

445: MINUTES,
446: SECONDS,
447: CALC_UOM_CONV_IND,
448: TO_QTY_UOM
449: from GMD_SPEC_TESTS_B
450: where SPEC_ID = X_SPEC_ID
451: and TEST_ID = X_TEST_ID
452: for update of SPEC_ID nowait;
453: recinfo c%rowtype;

Line 458: from GMD_SPEC_TESTS_TL

454:
455: cursor c1 is select
456: TEST_DISPLAY,
457: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
458: from GMD_SPEC_TESTS_TL
459: where SPEC_ID = X_SPEC_ID
460: and TEST_ID = X_TEST_ID
461: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
462: for update of SPEC_ID nowait;

Line 720: update GMD_SPEC_TESTS_B set

716: X_CALC_UOM_CONV_IND in VARCHAR2,
717: X_TO_QTY_UOM in VARCHAR2
718: ) is
719: begin
720: update GMD_SPEC_TESTS_B set
721: ATTRIBUTE1 = X_ATTRIBUTE1,
722: ATTRIBUTE2 = X_ATTRIBUTE2,
723: MIN_VALUE_CHAR = X_MIN_VALUE_CHAR,
724: TEST_METHOD_ID = X_TEST_METHOD_ID,

Line 804: update GMD_SPEC_TESTS_TL set

800: if (sql%notfound) then
801: raise no_data_found;
802: end if;
803:
804: update GMD_SPEC_TESTS_TL set
805: TEST_DISPLAY = X_TEST_DISPLAY,
806: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
807: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
808: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

Line 825: delete from GMD_SPEC_TESTS_TL

821: P_TEST_ID in NUMBER
822: ) RETURN BOOLEAN IS
823: begin
824: IF p_spec_id IS NOT NULL and p_test_id IS NOT NULL THEN
825: delete from GMD_SPEC_TESTS_TL
826: where SPEC_ID = P_SPEC_ID
827: and TEST_ID = P_TEST_ID;
828:
829: if (sql%notfound) then

Line 833: delete from GMD_SPEC_TESTS_B

829: if (sql%notfound) then
830: raise no_data_found;
831: end if;
832:
833: delete from GMD_SPEC_TESTS_B
834: where SPEC_ID = P_SPEC_ID
835: and TEST_ID = P_TEST_ID;
836:
837: if (sql%notfound) then

Line 841: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');

837: if (sql%notfound) then
838: raise no_data_found;
839: end if;
840: ELSE
841: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
842: RETURN FALSE;
843: END IF;
844:
845: RETURN TRUE;

Line 850: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');

846:
847: EXCEPTION
848: WHEN NO_DATA_FOUND
849: THEN
850: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
851: RETURN FALSE;
852: WHEN OTHERS
853: THEN
854: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line 854: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

850: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
851: RETURN FALSE;
852: WHEN OTHERS
853: THEN
854: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
855: RETURN FALSE;
856: end DELETE_ROW;
857:
858:

Line 862: delete from GMD_SPEC_TESTS_TL T

858:
859: procedure ADD_LANGUAGE
860: is
861: begin
862: delete from GMD_SPEC_TESTS_TL T
863: where not exists
864: (select NULL
865: from GMD_SPEC_TESTS_B B
866: where B.SPEC_ID = T.SPEC_ID

Line 865: from GMD_SPEC_TESTS_B B

861: begin
862: delete from GMD_SPEC_TESTS_TL T
863: where not exists
864: (select NULL
865: from GMD_SPEC_TESTS_B B
866: where B.SPEC_ID = T.SPEC_ID
867: and B.TEST_ID = T.TEST_ID
868: );
869:

Line 870: update GMD_SPEC_TESTS_TL T set (

866: where B.SPEC_ID = T.SPEC_ID
867: and B.TEST_ID = T.TEST_ID
868: );
869:
870: update GMD_SPEC_TESTS_TL T set (
871: TEST_DISPLAY
872: ) = (select
873: B.TEST_DISPLAY
874: from GMD_SPEC_TESTS_TL B

Line 874: from GMD_SPEC_TESTS_TL B

870: update GMD_SPEC_TESTS_TL T set (
871: TEST_DISPLAY
872: ) = (select
873: B.TEST_DISPLAY
874: from GMD_SPEC_TESTS_TL B
875: where B.SPEC_ID = T.SPEC_ID
876: and B.TEST_ID = T.TEST_ID
877: and B.LANGUAGE = T.SOURCE_LANG)
878: where (

Line 886: from GMD_SPEC_TESTS_TL SUBB, GMD_SPEC_TESTS_TL SUBT

882: ) in (select
883: SUBT.SPEC_ID,
884: SUBT.TEST_ID,
885: SUBT.LANGUAGE
886: from GMD_SPEC_TESTS_TL SUBB, GMD_SPEC_TESTS_TL SUBT
887: where SUBB.SPEC_ID = SUBT.SPEC_ID
888: and SUBB.TEST_ID = SUBT.TEST_ID
889: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
890: and (SUBB.TEST_DISPLAY <> SUBT.TEST_DISPLAY

Line 895: insert into GMD_SPEC_TESTS_TL (

891: or (SUBB.TEST_DISPLAY is null and SUBT.TEST_DISPLAY is not null)
892: or (SUBB.TEST_DISPLAY is not null and SUBT.TEST_DISPLAY is null)
893: ));
894:
895: insert into GMD_SPEC_TESTS_TL (
896: CREATED_BY,
897: LAST_UPDATED_BY,
898: LAST_UPDATE_DATE,
899: LAST_UPDATE_LOGIN,

Line 917: from GMD_SPEC_TESTS_TL B, FND_LANGUAGES L

913: B.TEST_DISPLAY,
914: B.CREATION_DATE,
915: L.LANGUAGE_CODE,
916: B.SOURCE_LANG
917: from GMD_SPEC_TESTS_TL B, FND_LANGUAGES L
918: where L.INSTALLED_FLAG in ('I', 'B')
919: and B.LANGUAGE = userenv('LANG')
920: and not exists
921: (select NULL

Line 922: from GMD_SPEC_TESTS_TL T

918: where L.INSTALLED_FLAG in ('I', 'B')
919: and B.LANGUAGE = userenv('LANG')
920: and not exists
921: (select NULL
922: from GMD_SPEC_TESTS_TL T
923: where T.SPEC_ID = B.SPEC_ID
924: and T.TEST_ID = B.TEST_ID
925: and T.LANGUAGE = L.LANGUAGE_CODE);
926: end ADD_LANGUAGE;

Line 929: p_spec_tests IN gmd_spec_tests%ROWTYPE

925: and T.LANGUAGE = L.LANGUAGE_CODE);
926: end ADD_LANGUAGE;
927:
928: FUNCTION fetch_row (
929: p_spec_tests IN gmd_spec_tests%ROWTYPE
930: , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE
931: )
932: RETURN BOOLEAN
933: IS

Line 930: , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE

926: end ADD_LANGUAGE;
927:
928: FUNCTION fetch_row (
929: p_spec_tests IN gmd_spec_tests%ROWTYPE
930: , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE
931: )
932: RETURN BOOLEAN
933: IS
934: BEGIN

Line 938: FROM gmd_spec_tests

934: BEGIN
935: IF (p_spec_tests.spec_id IS NOT NULL) and (p_spec_tests.spec_id IS NOT NULL) THEN
936: SELECT *
937: INTO x_spec_tests
938: FROM gmd_spec_tests
939: WHERE spec_id = p_spec_tests.spec_id and test_id = p_spec_tests.test_id;
940: ELSE
941: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
942: RETURN FALSE;

Line 941: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');

937: INTO x_spec_tests
938: FROM gmd_spec_tests
939: WHERE spec_id = p_spec_tests.spec_id and test_id = p_spec_tests.test_id;
940: ELSE
941: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
942: RETURN FALSE;
943: END IF;
944: RETURN TRUE;
945:

Line 949: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');

945:
946: EXCEPTION
947: WHEN NO_DATA_FOUND
948: THEN
949: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
950: RETURN FALSE;
951: WHEN OTHERS
952: THEN
953: fnd_msg_pub.add_exc_msg ('GMD_SPEC_TESTS_PVT', 'FETCH_ROW');

Line 953: fnd_msg_pub.add_exc_msg ('GMD_SPEC_TESTS_PVT', 'FETCH_ROW');

949: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
950: RETURN FALSE;
951: WHEN OTHERS
952: THEN
953: fnd_msg_pub.add_exc_msg ('GMD_SPEC_TESTS_PVT', 'FETCH_ROW');
954: RETURN FALSE;
955:
956: END fetch_row;
957:

Line 970: FROM gmd_spec_tests_b

966:
967: IF (p_spec_id IS NOT NULL) and (p_test_id is NOT NULL) THEN
968: SELECT spec_id
969: INTO dummy
970: FROM gmd_spec_tests_b
971: WHERE spec_id = p_spec_id
972: AND test_id = p_test_id
973: FOR UPDATE OF spec_id NOWAIT ;
974: ELSE

Line 975: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');

971: WHERE spec_id = p_spec_id
972: AND test_id = p_test_id
973: FOR UPDATE OF spec_id NOWAIT ;
974: ELSE
975: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
976: RETURN FALSE;
977: END IF;
978:
979: RETURN TRUE;

Line 984: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');

980:
981: EXCEPTION
982: WHEN NO_DATA_FOUND
983: THEN
984: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
985: RETURN FALSE;
986: WHEN OTHERS
987: THEN
988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line 988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

984: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
985: RETURN FALSE;
986: WHEN OTHERS
987: THEN
988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
989: RETURN FALSE;
990: END lock_row;
991:
992: FUNCTION INSERT_ROW(p_spec_tests IN OUT NOCOPY GMD_SPEC_TESTS%ROWTYPE)

Line 992: FUNCTION INSERT_ROW(p_spec_tests IN OUT NOCOPY GMD_SPEC_TESTS%ROWTYPE)

988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
989: RETURN FALSE;
990: END lock_row;
991:
992: FUNCTION INSERT_ROW(p_spec_tests IN OUT NOCOPY GMD_SPEC_TESTS%ROWTYPE)
993: RETURN BOOLEAN IS
994: l_rowid ROWID ;
995: BEGIN
996:

Line 997: GMD_SPEC_TESTS_PVT.INSERT_ROW(

993: RETURN BOOLEAN IS
994: l_rowid ROWID ;
995: BEGIN
996:
997: GMD_SPEC_TESTS_PVT.INSERT_ROW(
998: X_ROWID => l_rowid,
999: X_SPEC_ID => p_spec_tests.spec_id,
1000: X_TEST_ID => p_spec_tests.test_id,
1001: X_TEST_METHOD_ID => p_spec_tests.test_method_id,

Line 1090: end GMD_SPEC_TESTS_PVT;

1086: SUBSTR(SQLERRM,1,100),'POSITION','010');
1087: RETURN FALSE;
1088:
1089: END INSERT_ROW;
1090: end GMD_SPEC_TESTS_PVT;