DBA Data[Home] [Help]

APPS.PER_SE_POSTALCODE_UPLOAD dependencies on FND_PROFILE

Line 80: fnd_profile.get (c_data_exchange_dir, l_location);

76: then RAISE UTL_FILE.invalid_filehandle;
77: END IF;
78:
79: /* Get the DIR set in the profile to local variable */
80: fnd_profile.get (c_data_exchange_dir, l_location);
81:
82: IF l_location IS NULL
83: THEN
84: -- error : I/O directory not defined

Line 376: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

372: X_ATTRIBUTE15 => null,
373: X_MEANING => p_lookup_code||' '||p_meaning,
374: X_DESCRIPTION => p_description,
375: X_CREATION_DATE => SYSDATE,
376: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
377: X_LAST_UPDATE_DATE => SYSDATE,
378: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
379: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
380:

Line 378: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

374: X_DESCRIPTION => p_description,
375: X_CREATION_DATE => SYSDATE,
376: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
377: X_LAST_UPDATE_DATE => SYSDATE,
378: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
379: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
380:
381: );
382:

Line 379: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

375: X_CREATION_DATE => SYSDATE,
376: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
377: X_LAST_UPDATE_DATE => SYSDATE,
378: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
379: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
380:
381: );
382:
383: end INSERT_ROW;

Line 424: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

420: X_ATTRIBUTE15 => NULL,
421: X_MEANING => p_lookup_code||' '||p_meaning,
422: X_DESCRIPTION => null,
423: X_LAST_UPDATE_DATE => SYSDATE,
424: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
425: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
426:
427: end UPDATE_ROW;
428:

Line 425: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));

421: X_MEANING => p_lookup_code||' '||p_meaning,
422: X_DESCRIPTION => null,
423: X_LAST_UPDATE_DATE => SYSDATE,
424: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
425: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
426:
427: end UPDATE_ROW;
428:
429: /*