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

Line 445: FND_PROFILE.get('APPS_FRAMEWORK_AGENT', lv_fwk_agent);

441: lv_fwk_agent VARCHAR2(4000) := NULL;
442:
443: BEGIN
444:
445: FND_PROFILE.get('APPS_FRAMEWORK_AGENT', lv_fwk_agent);
446:
447:
448: IF ( lv_fwk_agent IS NULL ) THEN
449: RETURN '';

Line 2697: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;

2693: ln_resp_app_id NUMBER := -1;
2694: lvr_exception_msg VARCHAR2(4000);
2695: lvr_status VARCHAR2(30);
2696:
2697: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
2698: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
2699:
2700: -- out parameters
2701: ln_party_id NUMBER := -1;

Line 2698: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;

2694: lvr_exception_msg VARCHAR2(4000);
2695: lvr_status VARCHAR2(30);
2696:
2697: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
2698: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
2699:
2700: -- out parameters
2701: ln_party_id NUMBER := -1;
2702: ln_relationship_id NUMBER := -1;

Line 3056: IF ( fnd_profile.save(

3052: set_profile_opt_ext_user(p_userid => ln_user_fnd_id);
3053:
3054: --OSN: need to set the profile to identify this user as a local user
3055: IF l_encrypted_initial_password IS NOT NULL THEN
3056: IF ( fnd_profile.save(
3057: X_NAME => 'APPS_SSO_LOCAL_LOGIN',
3058: -- 'Applications SSO Login Types' (Both/Local/SSO)
3059: X_VALUE => 'Local',
3060: X_LEVEL_NAME => 'USER',

Line 3111: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;

3107:
3108: PROCEDURE set_profile_opt_ext_user
3109: (p_userid in number)
3110: is
3111: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
3112: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
3113: lv_pattern VARCHAR2(40);
3114: lv_flag VARCHAR2(40);
3115: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';

Line 3112: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;

3108: PROCEDURE set_profile_opt_ext_user
3109: (p_userid in number)
3110: is
3111: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
3112: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
3113: lv_pattern VARCHAR2(40);
3114: lv_flag VARCHAR2(40);
3115: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
3116: begin

Line 3118: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);

3114: lv_flag VARCHAR2(40);
3115: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
3116: begin
3117:
3118: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);
3119: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);
3120:
3121: IF ( lv_external_web_agent IS NOT NULL ) THEN
3122:

Line 3119: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);

3115: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
3116: begin
3117:
3118: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);
3119: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);
3120:
3121: IF ( lv_external_web_agent IS NOT NULL ) THEN
3122:
3123: lv_pattern := '/pls';

Line 3132: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',

3128: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3129: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
3130: END IF;
3131:
3132: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',
3133: x_value => lv_external_web_agent,
3134: x_level_name => 'USER',
3135: x_level_value => p_userid ) ) THEN
3136:

Line 3150: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',

3146:
3147: END IF;
3148:
3149: owa_pattern.change(lv_ext_servlet_agent, '/pls.*', '/oa_servlets/');
3150: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
3151: x_value => lv_ext_servlet_agent,
3152: x_level_name => 'USER',
3153: x_level_value => p_userid ) ) THEN
3154:

Line 3168: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',

3164:
3165: END IF;
3166:
3167: owa_pattern.change(lv_ext_servlet_agent, '/oa_servlets.*', '');
3168: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
3169: x_value => lv_ext_servlet_agent,
3170: x_level_name => 'USER',
3171: x_level_value => p_userid ) ) THEN
3172:

Line 3185: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',

3181: END IF;
3182:
3183: END IF;
3184: ELSE
3185: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
3186: x_value => lv_ext_servlet_agent,
3187: x_level_name => 'USER',
3188: x_level_value => p_userid ) ) THEN
3189:

Line 3204: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',

3200: END IF;
3201: -- set only the framework agent. there is no way to set web agent
3202: -- as we dont know the external dbc name.
3203: lv_ext_servlet_agent := lv_ext_servlet_agent || '/oa_servlets';
3204: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
3205: x_value => lv_ext_servlet_agent,
3206: x_level_name => 'USER',
3207: x_level_value => p_userid ) ) THEN
3208: