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