2763: 'SOURCE');
2764:
2765: IF l_type = 'PROFILE_APPROVER'
2766: THEN
2767: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2768: IF itemtype = 'OEOH'
2769: THEN
2770: v_value :=
2771: oe_profile.VALUE
2767: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2768: IF itemtype = 'OEOH'
2769: THEN
2770: v_value :=
2771: oe_profile.VALUE
2772: (p_header_id => TO_NUMBER (itemkey),
2773: p_line_id => NULL,
2774: p_profile_option_name => 'OE_NOTIFICATION_APPROVER'
2775: );
2775: );
2776: ELSIF itemtype = 'OEOL'
2777: THEN
2778: v_value :=
2779: oe_profile.VALUE
2780: (p_header_id => NULL,
2781: p_line_id => TO_NUMBER (itemkey),
2782: p_profile_option_name => 'OE_NOTIFICATION_APPROVER'
2783: );