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.CS_CSXSRDET_XMLP_PKG dependencies on FND_PROFILE

Line 157: P_ORGANIZATION_ID := FND_PROFILE.VALUE('SO_ORGANIZATION_ID');

153: ,'srw_init')*/NULL;
154: END;
155: BEGIN
156: /*SRW.REFERENCE(P_ORGANIZATION_ID)*/NULL;
157: P_ORGANIZATION_ID := FND_PROFILE.VALUE('SO_ORGANIZATION_ID');
158: END;
159: BEGIN
160: /*SRW.REFERENCE(P_ITEM_STRUCT_NUM)*/NULL;
161: EXCEPTION

Line 216: STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');

212:
213: /*PROCEDURE PUT(NAME IN VARCHAR2
214: ,VAL IN VARCHAR2) IS
215: BEGIN
216: STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
217: STPROC.BIND_I(NAME);
218: STPROC.BIND_I(VAL);
219: STPROC.EXECUTE;
220: END PUT;*/

Line 225: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');

221:
222: /* FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
223: X0 BOOLEAN;
224: BEGIN
225: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
226: STPROC.BIND_I(NAME);
227: STPROC.BIND_O(X0);
228: STPROC.EXECUTE;
229: STPROC.RETRIEVE(2

Line 237: STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');

233:
234: /* PROCEDURE GET(NAME IN VARCHAR2
235: ,VAL OUT NOCOPY VARCHAR2) IS
236: BEGIN
237: STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
238: STPROC.BIND_I(NAME);
239: STPROC.BIND_O(VAL);
240: STPROC.EXECUTE;
241: STPROC.RETRIEVE(2

Line 248: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');

244:
245: /* FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
246: X0 VARCHAR2(2000);
247: BEGIN
248: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
249: STPROC.BIND_O(X0);
250: STPROC.BIND_I(NAME);
251: STPROC.EXECUTE;
252: STPROC.RETRIEVE(1

Line 260: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_WNPS(:NAME); end;');

256: */
257: /* FUNCTION VALUE_WNPS(NAME IN VARCHAR2) RETURN VARCHAR2 IS
258: X0 VARCHAR2(2000);
259: BEGIN
260: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_WNPS(:NAME); end;');
261: STPROC.BIND_O(X0);
262: STPROC.BIND_I(NAME);
263: STPROC.EXECUTE;
264: STPROC.RETRIEVE(1

Line 273: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');

269: /* FUNCTION SAVE_USER(X_NAME IN VARCHAR2
270: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
271: X0 BOOLEAN;
272: BEGIN
273: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
274: STPROC.BIND_I(X_NAME);
275: STPROC.BIND_I(X_VALUE);
276: STPROC.BIND_O(X0);
277: STPROC.EXECUTE;

Line 290: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE(:X_NAME, :X_VALUE, :X_LEVEL_NAME, :X_LEVEL_VALUE, :X_LEVEL_VALUE_APP_ID); :X0 := sys.diutil.bool_to_int(X0rv); end;');

286: ,X_LEVEL_VALUE IN VARCHAR2
287: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
288: X0 BOOLEAN;
289: BEGIN
290: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE(:X_NAME, :X_VALUE, :X_LEVEL_NAME, :X_LEVEL_VALUE, :X_LEVEL_VALUE_APP_ID); :X0 := sys.diutil.bool_to_int(X0rv); end;');
291: STPROC.BIND_I(X_NAME);
292: STPROC.BIND_I(X_VALUE);
293: STPROC.BIND_I(X_LEVEL_NAME);
294: STPROC.BIND_I(X_LEVEL_VALUE);

Line 310: STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z); FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);

306: ,APPLICATION_ID_Z IN NUMBER
307: ,VAL_Z OUT NOCOPY VARCHAR2
308: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
309: BEGIN
310: STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z); FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
311: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
312: STPROC.BIND_O(DEFINED_Z);
313: STPROC.BIND_I(NAME_Z);
314: STPROC.BIND_I(USER_ID_Z);

Line 331: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');

327: ,RESPONSIBILITY_ID IN NUMBER
328: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
329: X0 VARCHAR2(2000);
330: BEGIN
331: STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
332: STPROC.BIND_O(X0);
333: STPROC.BIND_I(NAME);
334: STPROC.BIND_I(USER_ID);
335: STPROC.BIND_I(RESPONSIBILITY_ID);

Line 348: STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');

344: ,RESPONSIBILITY_ID_Z IN NUMBER
345: ,APPLICATION_ID_Z IN NUMBER
346: ,SITE_ID_Z IN NUMBER) IS
347: BEGIN
348: STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
349: STPROC.BIND_I(USER_ID_Z);
350: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
351: STPROC.BIND_I(APPLICATION_ID_Z);
352: STPROC.BIND_I(SITE_ID_Z);

Line 360: STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');

356: /* PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
357: ,VALS IN VARCHAR2
358: ,NUM IN NUMBER) IS
359: BEGIN
360: STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
361: STPROC.BIND_I(NAMES);
362: STPROC.BIND_I(VALS);
363: STPROC.BIND_I(NUM);
364: STPROC.EXECUTE;