DBA Data[Home] [Help]

APPS.AP_APXBCRPT_XMLP_PKG dependencies on FND_PROFILE

Line 145: begin FND_PROFILE.PUT(NAME, VAL); end;

141:
142: PROCEDURE PUT(NAME IN VARCHAR2
143: ,VAL IN VARCHAR2) IS
144: BEGIN
145: begin FND_PROFILE.PUT(NAME, VAL); end;
146:
147: END PUT;
148:
149: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS

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

148:
149: FUNCTION DEFINED(NAME IN VARCHAR2) RETURN BOOLEAN IS
150: X0 BOOLEAN;
151: BEGIN
152: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.DEFINED(:NAME); :X0 := sys.diutil.bool_to_int(X0rv); end;');
153: STPROC.BIND_I(NAME);
154: STPROC.BIND_O(X0);
155: STPROC.EXECUTE;
156: STPROC.RETRIEVE(2

Line 164: begin FND_PROFILE.GET(NAME, VAL); end;

160:
161: PROCEDURE GET(NAME IN VARCHAR2
162: ,VAL OUT NOCOPY VARCHAR2) IS
163: BEGIN
164: begin FND_PROFILE.GET(NAME, VAL); end;
165:
166: END GET;
167:
168: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS

Line 171: begin X0 := FND_PROFILE.VALUE(NAME); end;

167:
168: FUNCTION VALUE(NAME IN VARCHAR2) RETURN VARCHAR2 IS
169: X0 VARCHAR2(2000);
170: BEGIN
171: begin X0 := FND_PROFILE.VALUE(NAME); end;
172: RETURN X0;
173: END VALUE;
174:
175: FUNCTION VALUE_WNPS(NAME IN VARCHAR2) RETURN VARCHAR2 IS

Line 178: begin X0 := FND_PROFILE.VALUE_WNPS(NAME); end;

174:
175: FUNCTION VALUE_WNPS(NAME IN VARCHAR2) RETURN VARCHAR2 IS
176: X0 VARCHAR2(2000);
177: BEGIN
178: begin X0 := FND_PROFILE.VALUE_WNPS(NAME); end;
179: RETURN X0;
180: END VALUE_WNPS;
181:
182: FUNCTION SAVE_USER(X_NAME IN VARCHAR2

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

182: FUNCTION SAVE_USER(X_NAME IN VARCHAR2
183: ,X_VALUE IN VARCHAR2) RETURN BOOLEAN IS
184: X0 BOOLEAN;
185: BEGIN
186: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := FND_PROFILE.SAVE_USER(:X_NAME, :X_VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
187: STPROC.BIND_I(X_NAME);
188: STPROC.BIND_I(X_VALUE);
189: STPROC.BIND_O(X0);
190: STPROC.EXECUTE;

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

199: ,X_LEVEL_VALUE IN VARCHAR2
200: ,X_LEVEL_VALUE_APP_ID IN VARCHAR2) RETURN BOOLEAN IS
201: X0 BOOLEAN;
202: BEGIN
203: /* 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;');
204: STPROC.BIND_I(X_NAME);
205: STPROC.BIND_I(X_VALUE);
206: STPROC.BIND_I(X_LEVEL_NAME);
207: STPROC.BIND_I(X_LEVEL_VALUE);

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

239: ,RESPONSIBILITY_ID IN NUMBER
240: ,APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
241: X0 VARCHAR2(2000);
242: BEGIN
243: /*STPROC.INIT('begin :X0 := FND_PROFILE.VALUE_SPECIFIC(:NAME, :USER_ID, :RESPONSIBILITY_ID, :APPLICATION_ID); end;');
244: STPROC.BIND_O(X0);
245: STPROC.BIND_I(NAME);
246: STPROC.BIND_I(USER_ID);
247: STPROC.BIND_I(RESPONSIBILITY_ID);

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

256: ,RESPONSIBILITY_ID_Z IN NUMBER
257: ,APPLICATION_ID_Z IN NUMBER
258: ,SITE_ID_Z IN NUMBER) IS
259: BEGIN
260: /* STPROC.INIT('begin FND_PROFILE.INITIALIZE(:USER_ID_Z, :RESPONSIBILITY_ID_Z, :APPLICATION_ID_Z, :SITE_ID_Z); end;');
261: STPROC.BIND_I(USER_ID_Z);
262: STPROC.BIND_I(RESPONSIBILITY_ID_Z);
263: STPROC.BIND_I(APPLICATION_ID_Z);
264: STPROC.BIND_I(SITE_ID_Z);

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

268: PROCEDURE PUTMULTIPLE(NAMES IN VARCHAR2
269: ,VALS IN VARCHAR2
270: ,NUM IN NUMBER) IS
271: BEGIN
272: /* STPROC.INIT('begin FND_PROFILE.PUTMULTIPLE(:NAMES, :VALS, :NUM); end;');
273: STPROC.BIND_I(NAMES);
274: STPROC.BIND_I(VALS);
275: STPROC.BIND_I(NUM);
276: STPROC.EXECUTE;*/ null;