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.MSD_COMMON_UTILITIES dependencies on MSD_LEVEL_VALUES

Line 83: from msd_level_values

79: BEGIN
80: if p_val is NULL then
81: select level_pk
82: into l_ret
83: from msd_level_values
84: where instance = p_instance_id
85: and p_sr_key = sr_level_pk
86: and level_id = nvl(p_level_id, l_def_level_id);
87: else

Line 90: from msd_level_values

86: and level_id = nvl(p_level_id, l_def_level_id);
87: else
88: select level_pk
89: into l_ret
90: from msd_level_values
91: where instance = p_instance_id
92: and level_value = p_val
93: and level_id = nvl(p_level_id, l_def_level_id);
94: end if;

Line 111: from msd_level_values

107: BEGIN
108: if p_val is NULL then
109: select level_pk
110: into l_ret
111: from msd_level_values
112: where instance = p_instance_id
113: and p_sr_key = sr_level_pk
114: and level_id = nvl(p_level_id, l_def_level_id);
115: else

Line 118: from msd_level_values

114: and level_id = nvl(p_level_id, l_def_level_id);
115: else
116: select level_pk
117: into l_ret
118: from msd_level_values
119: where instance = p_instance_id
120: and level_value = p_val
121: and level_id = nvl(p_level_id, l_def_level_id);
122: end if;

Line 138: from msd_level_values

134: l_ret NUMBER;
135:
136: cursor sr_lvl_pk_c1 (p_instance_id IN NUMBER, p_sr_key IN VARCHAR2, p_level_id IN NUMBER) IS
137: select level_pk
138: from msd_level_values
139: where instance = p_instance_id
140: and sr_level_pk = p_sr_key
141: and level_id = p_level_id;
142:

Line 145: from msd_level_values

141: and level_id = p_level_id;
142:
143: cursor lvl_val_c1 (p_instance_id IN NUMBER, p_val IN VARCHAR2, p_level_id IN NUMBER) IS
144: select level_pk
145: from msd_level_values
146: where instance = p_instance_id
147: and level_value = p_val
148: and level_id = p_level_id;
149:

Line 185: from msd_level_values

181: BEGIN
182: if p_val is NULL then
183: select level_pk
184: into l_ret
185: from msd_level_values
186: where instance = p_instance_id
187: and p_sr_key = sr_level_pk
188: and level_id = nvl(p_level_id, l_def_level_id);
189: else

Line 192: from msd_level_values

188: and level_id = nvl(p_level_id, l_def_level_id);
189: else
190: SELECT level_pk
191: into l_ret
192: from msd_level_values
193: where instance = p_instance_id
194: and level_value = p_val
195: and level_id = nvl(p_level_id, l_def_level_id);
196: end if;

Line 214: from msd_level_values

210: BEGIN
211: if p_val is NULL then
212: select level_pk
213: into l_ret
214: from msd_level_values
215: where instance = p_instance_id
216: and p_sr_key = sr_level_pk
217: and level_id = nvl(p_level_id, l_def_level_id);
218: else

Line 221: from msd_level_values

217: and level_id = nvl(p_level_id, l_def_level_id);
218: else
219: select level_pk
220: into l_ret
221: from msd_level_values
222: where instance = p_instance_id
223: and level_value = p_val
224: and level_id = nvl(p_level_id, l_def_level_id);
225: end if;

Line 243: from msd_level_values

239: BEGIN
240: if p_val is NULL then
241: select level_pk
242: into l_ret
243: from msd_level_values
244: where instance = p_instance_id
245: and p_sr_key = sr_level_pk
246: and level_id = nvl(p_level_id, l_def_level_id);
247: else

Line 250: from msd_level_values

246: and level_id = nvl(p_level_id, l_def_level_id);
247: else
248: select level_pk
249: into l_ret
250: from msd_level_values
251: where instance = p_instance_id
252: and level_value = p_val
253: and level_id = nvl(p_level_id, l_def_level_id);
254: end if;

Line 272: from msd_level_values

268: BEGIN
269: if p_val is NULL then
270: select level_pk
271: into l_ret
272: from msd_level_values
273: where instance = p_instance_id
274: and p_sr_key = sr_level_pk
275: and level_id = nvl(p_level_id, l_def_level_id);
276: else

Line 279: from msd_level_values

275: and level_id = nvl(p_level_id, l_def_level_id);
276: else
277: select level_pk
278: into l_ret
279: from msd_level_values
280: where instance = p_instance_id
281: and level_value = p_val
282: and level_id = nvl(p_level_id, l_def_level_id);
283: end if;

Line 302: from msd_level_values

298: BEGIN
299: if p_val is NULL then
300: select level_pk
301: into l_ret
302: from msd_level_values
303: where instance = p_instance_id
304: and p_sr_key = sr_level_pk
305: and level_id = nvl(p_level_id, l_def_level_id);
306: else

Line 309: from msd_level_values

305: and level_id = nvl(p_level_id, l_def_level_id);
306: else
307: select level_pk
308: into l_ret
309: from msd_level_values
310: where instance = p_instance_id
311: and level_value = p_val
312: and level_id = nvl(p_level_id, l_def_level_id);
313: end if;

Line 323: select msd_level_values_s.nextval into x_temp

319: function get_level_pk return number Is
320: x_temp number ;
321: Begin
322:
323: select msd_level_values_s.nextval into x_temp
324: from sys.dual ;
325:
326: return x_temp;
327:

Line 464: from msd_level_values

460: from sys.dual;
461:
462: select count(*)
463: into v_count
464: from msd_level_values
465: where sr_level_pk = to_char(v_ret);
466: end loop;
467:
468: return v_ret;

Line 502: from msd_level_values

498: and sr_level_pk = to_char(v_next);
499:
500: select count(*)
501: into v_count2
502: from msd_level_values
503: where instance = to_char(p_instance_id)
504: and sr_level_pk = to_char(v_next);
505:
506: end loop;

Line 547: from msd_level_values

543: function get_level_value(p_level_pk in number) return varchar2 is
544:
545: cursor c1 is
546: select level_value
547: from msd_level_values
548: where level_pk = p_level_pk;
549:
550: l_value varchar2(255);
551:

Line 1110: from msc_tp_id_lid mtp, msd_level_values mlv

1106: p_sr_instance_id in number) return number is
1107:
1108: cursor c_lvl_pk is
1109: select mlv.level_pk
1110: from msc_tp_id_lid mtp, msd_level_values mlv
1111: where
1112: mtp.tp_id = p_tp_id
1113: and mtp.sr_instance_id = p_sr_instance_id
1114: and mtp.partner_type = 2

Line 1609: from msd_level_values

1605: FUNCTION GET_SR_LEVEL_PK(P_INSTANCE_ID IN NUMBER, P_LEVEL_ID IN NUMBER, P_LEVEL_PK IN NUMBER, P_LEVEL_VALUE OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1606:
1607: cursor c1 is
1608: select sr_level_pk, level_value
1609: from msd_level_values
1610: where instance = P_INSTANCE_ID
1611: and level_id = P_LEVEL_ID
1612: and level_pk = P_LEVEL_PK;
1613:

Line 1640: from msd_level_values

1636: BEGIN
1637: if p_val is NULL then
1638: select dp_enabled_flag
1639: into l_ret
1640: from msd_level_values
1641: where instance = p_instance_id
1642: and p_sr_key = sr_level_pk
1643: and level_id = nvl(p_level_id, l_def_level_id);
1644: else

Line 1647: from msd_level_values

1643: and level_id = nvl(p_level_id, l_def_level_id);
1644: else
1645: select dp_enabled_flag
1646: into l_ret
1647: from msd_level_values
1648: where instance = p_instance_id
1649: and level_value = p_val
1650: and level_id = nvl(p_level_id, l_def_level_id);
1651: end if;