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_PARAMETERS_DTL_PKG dependencies on GEM_LOOKUPS

Line 102: CURSOR cur_gem_lookups IS

98: FROM GMD_PARAMETERS_DTL
99: WHERE PARAMETER_LINE_ID = X_PARAMETER_LINE_ID
100: FOR UPDATE OF PARAMETER_LINE_ID NOWAIT;
101:
102: CURSOR cur_gem_lookups IS
103: SELECT 1
104: from GEM_LOOKUPS
105: where lookup_code =X_PARAMETER_NAME
106: and lookup_type =X_LOOKUP_TYPE;

Line 104: from GEM_LOOKUPS

100: FOR UPDATE OF PARAMETER_LINE_ID NOWAIT;
101:
102: CURSOR cur_gem_lookups IS
103: SELECT 1
104: from GEM_LOOKUPS
105: where lookup_code =X_PARAMETER_NAME
106: and lookup_type =X_LOOKUP_TYPE;
107:
108: RECINFO C%ROWTYPE;

Line 109: GEMINFO Cur_gem_lookups%ROWTYPE;

105: where lookup_code =X_PARAMETER_NAME
106: and lookup_type =X_LOOKUP_TYPE;
107:
108: RECINFO C%ROWTYPE;
109: GEMINFO Cur_gem_lookups%ROWTYPE;
110: NEW_DATA_ENTRY EXCEPTION;
111: BEGIN
112: OPEN C;
113: FETCH C INTO RECINFO;

Line 119: OPEN cur_gem_lookups;

115:
116:
117: IF (C%NOTFOUND) THEN
118: CLOSE C;
119: OPEN cur_gem_lookups;
120: FETCH cur_gem_lookups INTO GEMINFO;
121: if cur_gem_lookups%NOTFOUND THEN
122: CLOSE cur_gem_lookups;
123: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line 120: FETCH cur_gem_lookups INTO GEMINFO;

116:
117: IF (C%NOTFOUND) THEN
118: CLOSE C;
119: OPEN cur_gem_lookups;
120: FETCH cur_gem_lookups INTO GEMINFO;
121: if cur_gem_lookups%NOTFOUND THEN
122: CLOSE cur_gem_lookups;
123: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
124: APP_EXCEPTION.RAISE_EXCEPTION;

Line 121: if cur_gem_lookups%NOTFOUND THEN

117: IF (C%NOTFOUND) THEN
118: CLOSE C;
119: OPEN cur_gem_lookups;
120: FETCH cur_gem_lookups INTO GEMINFO;
121: if cur_gem_lookups%NOTFOUND THEN
122: CLOSE cur_gem_lookups;
123: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
124: APP_EXCEPTION.RAISE_EXCEPTION;
125: ELSE

Line 122: CLOSE cur_gem_lookups;

118: CLOSE C;
119: OPEN cur_gem_lookups;
120: FETCH cur_gem_lookups INTO GEMINFO;
121: if cur_gem_lookups%NOTFOUND THEN
122: CLOSE cur_gem_lookups;
123: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
124: APP_EXCEPTION.RAISE_EXCEPTION;
125: ELSE
126: NULL;

Line 133: IF cur_gem_lookups%ISOPEN THEN

129: END IF;
130: IF c%ISOPEN THEN
131: CLOSE C;
132: END IF;
133: IF cur_gem_lookups%ISOPEN THEN
134: Close cur_gem_lookups;
135: END IF;
136: IF ( (RECINFO.PARAMETER_ID = X_PARAMETER_ID)
137: AND ((RECINFO.PARAMETER_TYPE = X_PARM_TYPE)

Line 134: Close cur_gem_lookups;

130: IF c%ISOPEN THEN
131: CLOSE C;
132: END IF;
133: IF cur_gem_lookups%ISOPEN THEN
134: Close cur_gem_lookups;
135: END IF;
136: IF ( (RECINFO.PARAMETER_ID = X_PARAMETER_ID)
137: AND ((RECINFO.PARAMETER_TYPE = X_PARM_TYPE)
138: OR ((RECINFO.PARAMETER_TYPE IS NULL) AND (X_PARM_TYPE IS NULL)))

Line 159: IF cur_gem_lookups%ISOPEN THEN

155: WHEN NEW_DATA_ENTRY THEN
156: IF c%ISOPEN THEN
157: CLOSE C;
158: END IF;
159: IF cur_gem_lookups%ISOPEN THEN
160: Close cur_gem_lookups;
161: END IF;
162: WHEN OTHERS THEN
163: IF c%ISOPEN THEN

Line 160: Close cur_gem_lookups;

156: IF c%ISOPEN THEN
157: CLOSE C;
158: END IF;
159: IF cur_gem_lookups%ISOPEN THEN
160: Close cur_gem_lookups;
161: END IF;
162: WHEN OTHERS THEN
163: IF c%ISOPEN THEN
164: CLOSE C;

Line 166: IF cur_gem_lookups%ISOPEN THEN

162: WHEN OTHERS THEN
163: IF c%ISOPEN THEN
164: CLOSE C;
165: END IF;
166: IF cur_gem_lookups%ISOPEN THEN
167: Close cur_gem_lookups;
168: END IF;
169:
170: END LOCK_ROW;

Line 167: Close cur_gem_lookups;

163: IF c%ISOPEN THEN
164: CLOSE C;
165: END IF;
166: IF cur_gem_lookups%ISOPEN THEN
167: Close cur_gem_lookups;
168: END IF;
169:
170: END LOCK_ROW;
171:

Line 270: FROM gem_lookups l

266: and ((h.organization_id = l_org_id) or ((l_org_id is NULL) and (h.organization_id IS NULL)))
267: UNION
268: select NULL parameter_id,NULL parameter_line_id,NULL parameter_type,lookup_code parameter_name, NULL PARAMETER_VALUE
269: ,NULL creation_date ,NULL last_updated_by,NULL last_updated_date,NULL last_updated_login,NULL created_by
270: FROM gem_lookups l
271: WHERE lookup_type = l_gem_type
272: and ENABLED_FLAG = 'Y'
273: AND not exists (select 1
274: from gmd_parameters_dtl d, gmd_parameters_hdr h