APPS.PSP_PSPRCSLD_XMLP_PKG dependencies on FND_PROFILE

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

387:
388: PROCEDURE PUT(NAME IN VARCHAR2
389: ,VAL IN VARCHAR2) IS
390: BEGIN
391: /* STPROC.INIT('begin FND_PROFILE.PUT(:NAME, :VAL); end;');
392: STPROC.BIND_I(NAME);
393: STPROC.BIND_I(VAL);
394: STPROC.EXECUTE;*/null;
395:

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

397:
398: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
399: X0 BOOLEAN;
400: BEGIN
401: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
402: STPROC.BIND_I(NAME);
403: STPROC.BIND_O(X0);
404: STPROC.EXECUTE;
405: STPROC.RETRIEVE(2

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

409:
410: PROCEDURE GET(NAME IN VARCHAR2
411: ,VAL OUT NOCOPY VARCHAR2) IS
412: BEGIN
413: /* STPROC.INIT('begin FND_PROFILE.GET(:NAME, :VAL); end;');
414: STPROC.BIND_I(NAME);
415: STPROC.BIND_O(VAL);
416: STPROC.EXECUTE;
417: STPROC.RETRIEVE(2

Line 419: FND_PROFILE.GET(NAME,VAL);

415: STPROC.BIND_O(VAL);
416: STPROC.EXECUTE;
417: STPROC.RETRIEVE(2
418: ,VAL);*/
419: FND_PROFILE.GET(NAME,VAL);
420: END GET;
421:
422: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
423: X0 VARCHAR2(2000);

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

421:
422: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
423: X0 VARCHAR2(2000);
424: BEGIN
425: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE(:NAME); end;');
426: STPROC.BIND_O(X0);
427: STPROC.BIND_I(NAME);
428: STPROC.EXECUTE;
429: STPROC.RETRIEVE(1

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

434: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
435: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
436: X0 BOOLEAN;
437: BEGIN
438: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
439: STPROC.BIND_I(X_NAME);
440: STPROC.BIND_I(X_VALUE);
441: STPROC.BIND_O(X0);
442: STPROC.EXECUTE;

Line 455: /* 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;');

451: ,X_LEVEL_VALUE IN VARCHAR2
452: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
453: X0 BOOLEAN;
454: BEGIN
455: /* 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;');
456: STPROC.BIND_I(X_NAME);
457: STPROC.BIND_I(X_VALUE);
458: STPROC.BIND_I(X_LEVEL_NAME);
459: STPROC.BIND_I(X_LEVEL_VALUE);

Line 476: FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);

472: ,VAL_Z OUT NOCOPY VARCHAR2
473: ,DEFINED_Z OUT NOCOPY BOOLEAN) IS
474: BEGIN
475: /* STPROC.INIT('declare DEFINED_Z BOOLEAN; begin DEFINED_Z := sys.diutil.int_to_bool(:DEFINED_Z);
476: FND_PROFILE.GET_SPECIFIC(:NAME_Z, :USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :VAL_Z, DEFINED_Z);
477: :DEFINED_Z := sys.diutil.bool_to_int(DEFINED_Z); end;');
478: STPROC.BIND_O(DEFINED_Z);
479: STPROC.BIND_I(NAME_Z);
480: STPROC.BIND_I(USER_ID_Z);

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

493: ,RESPONSIBILITY_ID IN NUMBER
494: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
495: X0 VARCHAR2(2000);
496: BEGIN
497: /* STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
498: STPROC.BIND_O(X0);
499: STPROC.BIND_I(NAME);
500: STPROC.BIND_I(USER_ID);
501: STPROC.BIND_I(RESPONSIBILITY_ID);

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

510: ,RESPONSIBILITY_ID_Z IN NUMBER
511: ,APPLICATION_ID_Z IN NUMBER
512: ,SITE_ID_Z IN NUMBER) IS
513: BEGIN
514: /* STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
515: STPROC.BIND_I(USER_ID_Z);
516: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
517: STPROC.BIND_I(APPLICATION_ID_Z);
518: STPROC.BIND_I(SITE_ID_Z);

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

522: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
523: ,VALS IN VARCHAR2
524: ,NUM IN NUMBER) IS
525: BEGIN
526: /* STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
527: STPROC.BIND_I(NAMES);
528: STPROC.BIND_I(VALS);
529: STPROC.BIND_I(NUM);
530: STPROC.EXECUTE;*/ null;