APPS.PO_APPROVAL_REMINDER_SV dependencies on FND_PROFILE_OPTIONS_VL

Line 3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;

3251: l_amount_threshold NUMBER;
3252: l_completion_threshold NUMBER;
3253: l_contractor_or_job VARCHAR2(500);
3254: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3257: BEGIN
3258: -- Retrieve the profile options for the Reminder thresholds.
3259: BEGIN

Line 3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;

3252: l_completion_threshold NUMBER;
3253: l_contractor_or_job VARCHAR2(500);
3254: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3257: BEGIN
3258: -- Retrieve the profile options for the Reminder thresholds.
3259: BEGIN
3260: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';

Line 3268: FROM FND_PROFILE_OPTIONS_VL

3264: EXCEPTION
3265: WHEN value_error THEN
3266: SELECT user_profile_option_name
3267: INTO l_user_profile_name
3268: FROM FND_PROFILE_OPTIONS_VL
3269: WHERE profile_option_name = l_profile_name;
3270:
3271: FND_MESSAGE.set_name ('PO', 'PO_PROFILE_OPTION_NUMERIC');
3272: FND_MESSAGE.set_token ( 'PROFILE_OPTION', l_user_profile_name );