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_SUPPLIER_USER_REG_PKG dependencies on FND_PROFILE

Line 846: l_value fnd_profile_option_values.profile_option_value%TYPE;

842: x_msg_count OUT nocopy NUMBER,
843: x_msg_data OUT nocopy VARCHAR2
844: )
845: IS
846: l_value fnd_profile_option_values.profile_option_value%TYPE;
847: l_web_agent fnd_profile_option_values.profile_option_value%TYPE;
848: l_fwk_agent fnd_profile_option_values.profile_option_value%TYPE;
849: l_servlet_agent fnd_profile_option_values.profile_option_value%TYPE;
850: l_saved BOOLEAN;

Line 847: l_web_agent fnd_profile_option_values.profile_option_value%TYPE;

843: x_msg_data OUT nocopy VARCHAR2
844: )
845: IS
846: l_value fnd_profile_option_values.profile_option_value%TYPE;
847: l_web_agent fnd_profile_option_values.profile_option_value%TYPE;
848: l_fwk_agent fnd_profile_option_values.profile_option_value%TYPE;
849: l_servlet_agent fnd_profile_option_values.profile_option_value%TYPE;
850: l_saved BOOLEAN;
851: l_flag VARCHAR2(1);

Line 848: l_fwk_agent fnd_profile_option_values.profile_option_value%TYPE;

844: )
845: IS
846: l_value fnd_profile_option_values.profile_option_value%TYPE;
847: l_web_agent fnd_profile_option_values.profile_option_value%TYPE;
848: l_fwk_agent fnd_profile_option_values.profile_option_value%TYPE;
849: l_servlet_agent fnd_profile_option_values.profile_option_value%TYPE;
850: l_saved BOOLEAN;
851: l_flag VARCHAR2(1);
852: is_osn VARCHAR2(1);

Line 849: l_servlet_agent fnd_profile_option_values.profile_option_value%TYPE;

845: IS
846: l_value fnd_profile_option_values.profile_option_value%TYPE;
847: l_web_agent fnd_profile_option_values.profile_option_value%TYPE;
848: l_fwk_agent fnd_profile_option_values.profile_option_value%TYPE;
849: l_servlet_agent fnd_profile_option_values.profile_option_value%TYPE;
850: l_saved BOOLEAN;
851: l_flag VARCHAR2(1);
852: is_osn VARCHAR2(1);
853: BEGIN

Line 854: fnd_profile.get('POS_EXTERNAL_URL', l_value);

850: l_saved BOOLEAN;
851: l_flag VARCHAR2(1);
852: is_osn VARCHAR2(1);
853: BEGIN
854: fnd_profile.get('POS_EXTERNAL_URL', l_value);
855: l_web_agent := l_value;
856: l_fwk_agent := l_value;
857: owa_pattern.change(l_fwk_agent, '/pls.*', NULL);
858: l_servlet_agent := l_fwk_agent || '/OA_HTML/';

Line 863: l_saved := fnd_profile.save( x_name => 'APPS_WEB_AGENT',

859:
860: l_flag := NULL;
861: IF l_web_agent IS NOT NULL AND owa_pattern.match(l_web_agent,'/pls/', l_flag) THEN
862: -- The value of POS_EXTERNAL_URL still points to icx web site.
863: l_saved := fnd_profile.save( x_name => 'APPS_WEB_AGENT',
864: x_value => l_web_agent,
865: x_level_name => 'USER',
866: x_level_value => p_user_id
867: );

Line 871: l_saved := fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',

867: );
868: END IF;
869:
870: IF l_fwk_agent IS NOT NULL THEN
871: l_saved := fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
872: x_value => l_fwk_agent,
873: x_level_name => 'USER',
874: x_level_value => p_user_id
875: );

Line 879: l_saved := fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',

875: );
876: END IF;
877:
878: IF l_servlet_agent IS NOT NULL THEN
879: l_saved := fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
880: x_value => l_servlet_agent,
881: x_level_name => 'USER',
882: x_level_value => p_user_id
883: );

Line 890: l_saved := fnd_profile.save( x_name => 'APPS_SSO_LOCAL_LOGIN',

886:
887: --OSN: need to set the profile to identify this user as a local user
888: is_osn := is_osnrequest(p_registration_id);
889: IF (is_osn = 'Y') THEN
890: l_saved := fnd_profile.save( x_name => 'APPS_SSO_LOCAL_LOGIN',
891: -- 'Applications SSO Login Types' (Both/Local/SSO)
892: x_value => 'Local',
893: x_level_name => 'USER',
894: x_level_value => to_char(p_user_id),

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

1572:
1573: PROCEDURE set_profile_opt_ext_user
1574: (p_userid in number)
1575: is
1576: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1577: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1578: lv_pattern VARCHAR2(40);
1579: lv_flag VARCHAR2(40);
1580: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';

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

1573: PROCEDURE set_profile_opt_ext_user
1574: (p_userid in number)
1575: is
1576: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1577: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1578: lv_pattern VARCHAR2(40);
1579: lv_flag VARCHAR2(40);
1580: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
1581: begin

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

1579: lv_flag VARCHAR2(40);
1580: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
1581: begin
1582:
1583: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);
1584: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);
1585:
1586: IF ( lv_external_web_agent IS NOT NULL ) THEN
1587:

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

1580: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
1581: begin
1582:
1583: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);
1584: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);
1585:
1586: IF ( lv_external_web_agent IS NOT NULL ) THEN
1587:
1588: lv_pattern := '/pls';

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

1593: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1594: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
1595: END IF;
1596:
1597: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',
1598: x_value => lv_external_web_agent,
1599: x_level_name => 'USER',
1600: x_level_value => p_userid ) ) THEN
1601:

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

1611:
1612: END IF;
1613:
1614: owa_pattern.change(lv_ext_servlet_agent, '/pls.*', '/OA_HTML');
1615: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
1616: x_value => lv_ext_servlet_agent,
1617: x_level_name => 'USER',
1618: x_level_value => p_userid ) ) THEN
1619:

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

1629:
1630: END IF;
1631:
1632: owa_pattern.change(lv_ext_servlet_agent, '/OA_HTML.*', '');
1633: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
1634: x_value => lv_ext_servlet_agent,
1635: x_level_name => 'USER',
1636: x_level_value => p_userid ) ) THEN
1637:

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

1646: END IF;
1647:
1648: END IF;
1649: ELSE
1650: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
1651: x_value => lv_ext_servlet_agent,
1652: x_level_name => 'USER',
1653: x_level_value => p_userid ) ) THEN
1654:

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

1665: END IF;
1666: -- set only the framework agent. there is no way to set web agent
1667: -- as we dont know the external dbc name.
1668: lv_ext_servlet_agent := lv_ext_servlet_agent || '/OA_HTML';
1669: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
1670: x_value => lv_ext_servlet_agent,
1671: x_level_name => 'USER',
1672: x_level_value => p_userid ) ) THEN
1673: