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 371: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

367: X_ATTRIBUTE15 => null,
368: X_MEANING => p_lookup_code||' '||p_meaning,
369: X_DESCRIPTION => p_description,
370: X_CREATION_DATE => SYSDATE,
371: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
372: X_LAST_UPDATE_DATE => SYSDATE,
373: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
374: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
375:

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

369: X_DESCRIPTION => p_description,
370: X_CREATION_DATE => SYSDATE,
371: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
372: X_LAST_UPDATE_DATE => SYSDATE,
373: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
374: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
375:
376: );
377:

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

370: X_CREATION_DATE => SYSDATE,
371: X_CREATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
372: X_LAST_UPDATE_DATE => SYSDATE,
373: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
374: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
375:
376: );
377:
378: end INSERT_ROW;

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

415: X_ATTRIBUTE15 => NULL,
416: X_MEANING => p_lookup_code||' '||p_meaning,
417: X_DESCRIPTION => null,
418: X_LAST_UPDATE_DATE => SYSDATE,
419: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
420: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
421:
422: end UPDATE_ROW;
423:

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

416: X_MEANING => p_lookup_code||' '||p_meaning,
417: X_DESCRIPTION => null,
418: X_LAST_UPDATE_DATE => SYSDATE,
419: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
420: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
421:
422: end UPDATE_ROW;
423:
424: /*