14: l_user_id NUMBER(15);
15: l_resp_id NUMBER(15);
16: l_resp_appl_id NUMBER(15);
17: l_sec_grp_id NUMBER(15);
18: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
19: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
15: l_resp_id NUMBER(15);
16: l_resp_appl_id NUMBER(15);
17: l_sec_grp_id NUMBER(15);
18: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
19: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
16: l_resp_appl_id NUMBER(15);
17: l_sec_grp_id NUMBER(15);
18: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
19: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
24: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
17: l_sec_grp_id NUMBER(15);
18: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
19: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
24: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
25: l_limit_time NUMBER;
18: l_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
19: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
24: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
25: l_limit_time NUMBER;
26: l_limit_connects NUMBER;
19: l_language_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
24: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
25: l_limit_time NUMBER;
26: l_limit_connects NUMBER;
27: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
20: l_date_format FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
21: l_date_language FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
22: l_numeric_characters FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
24: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
25: l_limit_time NUMBER;
26: l_limit_connects NUMBER;
27: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
28: l_timeout NUMBER;
23: l_nls_sort FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
24: l_nls_territory FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
25: l_limit_time NUMBER;
26: l_limit_connects NUMBER;
27: l_org_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
28: l_timeout NUMBER;
29: BEGIN
30:
31: BEGIN