DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_PROFILE_OPTION_VALUES

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 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