DBA Data[Home] [Help]

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 1551: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;

1547:
1548: PROCEDURE set_profile_opt_ext_user
1549: (p_userid in number)
1550: is
1551: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1552: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1553: lv_pattern VARCHAR2(40);
1554: lv_flag VARCHAR2(40);
1555: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';

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

1548: PROCEDURE set_profile_opt_ext_user
1549: (p_userid in number)
1550: is
1551: lv_external_web_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1552: lv_ext_servlet_agent fnd_profile_option_values.profile_option_value%TYPE := NULL;
1553: lv_pattern VARCHAR2(40);
1554: lv_flag VARCHAR2(40);
1555: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
1556: begin

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

1554: lv_flag VARCHAR2(40);
1555: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
1556: begin
1557:
1558: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);
1559: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);
1560:
1561: IF ( lv_external_web_agent IS NOT NULL ) THEN
1562:

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

1555: lv_proc_name VARCHAR2(30) := 'set_profile_opt_ext_user';
1556: begin
1557:
1558: fnd_profile.get('POS_EXTERNAL_URL', lv_external_web_agent);
1559: fnd_profile.get('POS_EXTERNAL_URL', lv_ext_servlet_agent);
1560:
1561: IF ( lv_external_web_agent IS NOT NULL ) THEN
1562:
1563: lv_pattern := '/pls';

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

1568: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1569: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
1570: END IF;
1571:
1572: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',
1573: x_value => lv_external_web_agent,
1574: x_level_name => 'USER',
1575: x_level_value => p_userid ) ) THEN
1576:

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

1586:
1587: END IF;
1588:
1589: owa_pattern.change(lv_ext_servlet_agent, '/pls.*', '/OA_HTML');
1590: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
1591: x_value => lv_ext_servlet_agent,
1592: x_level_name => 'USER',
1593: x_level_value => p_userid ) ) THEN
1594:

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

1604:
1605: END IF;
1606:
1607: owa_pattern.change(lv_ext_servlet_agent, '/OA_HTML.*', '');
1608: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
1609: x_value => lv_ext_servlet_agent,
1610: x_level_name => 'USER',
1611: x_level_value => p_userid ) ) THEN
1612:

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

1621: END IF;
1622:
1623: END IF;
1624: ELSE
1625: IF ( fnd_profile.save( x_name => 'APPS_FRAMEWORK_AGENT',
1626: x_value => lv_ext_servlet_agent,
1627: x_level_name => 'USER',
1628: x_level_value => p_userid ) ) THEN
1629:

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

1640: END IF;
1641: -- set only the framework agent. there is no way to set web agent
1642: -- as we dont know the external dbc name.
1643: lv_ext_servlet_agent := lv_ext_servlet_agent || '/OA_HTML';
1644: IF ( fnd_profile.save( x_name => 'APPS_SERVLET_AGENT',
1645: x_value => lv_ext_servlet_agent,
1646: x_level_name => 'USER',
1647: x_level_value => p_userid ) ) THEN
1648: