APPS.PO_APPROVAL_REMINDER_SV dependencies on FND_PROFILE_OPTIONS_VL

Line 3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;

3285: l_amount_threshold NUMBER;
3286: l_completion_threshold NUMBER;
3287: l_contractor_or_job VARCHAR2(500);
3288: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3291: BEGIN
3292: -- Retrieve the profile options for the Reminder thresholds.
3293: BEGIN

Line 3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;

3286: l_completion_threshold NUMBER;
3287: l_contractor_or_job VARCHAR2(500);
3288: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3291: BEGIN
3292: -- Retrieve the profile options for the Reminder thresholds.
3293: BEGIN
3294: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';

Line 3302: FROM FND_PROFILE_OPTIONS_VL

3298: EXCEPTION
3299: WHEN value_error THEN
3300: SELECT user_profile_option_name
3301: INTO l_user_profile_name
3302: FROM FND_PROFILE_OPTIONS_VL
3303: WHERE profile_option_name = l_profile_name;
3304:
3305: FND_MESSAGE.set_name ('PO', 'PO_PROFILE_OPTION_NUMERIC');
3306: FND_MESSAGE.set_token ( 'PROFILE_OPTION', l_user_profile_name );