DBA Data[Home] [Help]

APPS.POS_USER_ADMIN_PKG dependencies on FND_PROFILE

Line 725: vl_password_lifespan_days fnd_profile_option_values.profile_option_value%TYPE DEFAULT NULL;

721: )
722: IS
723: l_unencrypted_password VARCHAR2(200);
724: l_testname NUMBER;
725: vl_password_lifespan_days fnd_profile_option_values.profile_option_value%TYPE DEFAULT NULL;
726: l_password_lifespan_days NUMBER DEFAULT NULL;
727: event_id Number;
728: CURSOR l_party_cur IS
729: SELECT party_type, status

Line 829: FND_PROFILE.GET('POS_SUPPLIER_USER_PASSWORD_EXP_DAYS',vl_password_lifespan_days);

825: END IF;
826:
827: -- Bug: 14292251
828: -- Fteching the profile value
829: FND_PROFILE.GET('POS_SUPPLIER_USER_PASSWORD_EXP_DAYS',vl_password_lifespan_days);
830:
831: IF (vl_password_lifespan_days IS NOT NULL OR vl_password_lifespan_days<>'') THEN
832: BEGIN
833: -- Converting fetched value to number

Line 1111: l_resp_profile fnd_profile_option_values.profile_option_value%TYPE;

1107: x_msg_count OUT NOCOPY NUMBER,
1108: x_msg_data OUT NOCOPY VARCHAR2
1109: )
1110: IS
1111: l_resp_profile fnd_profile_option_values.profile_option_value%TYPE;
1112: l_instr_index NUMBER;
1113: l_resp_key fnd_responsibility.responsibility_key%TYPE;
1114: l_resp_app_id NUMBER;
1115: l_step NUMBER;

Line 1119: fnd_profile.get('POS_DEFAULT_SUP_REG_RESP', l_resp_profile);

1115: l_step NUMBER;
1116: BEGIN
1117: x_return_status := fnd_api.g_ret_sts_success;
1118: l_step := 1;
1119: fnd_profile.get('POS_DEFAULT_SUP_REG_RESP', l_resp_profile);
1120:
1121: IF l_resp_profile IS NOT NULL THEN
1122: l_instr_index := Instr(l_resp_profile, ':');
1123: l_resp_key := Substr(l_resp_profile, 0, l_instr_index - 1);

Line 1146: fnd_profile.get('PON_DEFAULT_EXT_USER_RESP', l_resp_profile);

1142:
1143: l_step := 2;
1144: l_resp_profile := NULL;
1145:
1146: fnd_profile.get('PON_DEFAULT_EXT_USER_RESP', l_resp_profile);
1147:
1148: IF l_resp_profile IS NOT NULL THEN
1149: l_resp_key := l_resp_profile;
1150: