APPS.OE_NOTIFY_USER_WF dependencies on FND_PROFILE

Line 13: l_result := FND_PROFILE.save(

9: IS
10: l_result Boolean;
11: l_return_result VARCHAR2(1);
12: BEGIN
13: l_result := FND_PROFILE.save(
14: X_NAME => 'ONT_SEND_STATUS_UPDATE_NOTIFICATION' ,
15: X_VALUE => p_value ,
16: X_LEVEL_NAME => 'USER' ,
17: X_LEVEL_VALUE => To_Char(p_user_id),

Line 434: l_cust_type := Nvl(fnd_profile.value('ONT_EXTERNAL_CUST_USAGE_TYPE'), 'CUSTOMER_ID');

430: -- Fetch the item attributes
431: l_header_id := wf_engine.getItemAttrNumber('OENF', itemkey, 'HEADER_ID');
432:
433: -- Fetch the profile setup information
434: l_cust_type := Nvl(fnd_profile.value('ONT_EXTERNAL_CUST_USAGE_TYPE'), 'CUSTOMER_ID');
435:
436: -- Get the customer_account_id
437: SELECT invoice_to_org_id, sold_to_org_id
438: INTO l_invoice_to_org_id, l_sold_to_org_id

Line 475: AND fnd_profile.value_specific('ONT_SEND_STATUS_UPDATE_NOTIFICATION',fu.user_id) = 'Y'

471: AND hcar.current_role_state = 'A'
472: -- AND hcar.cust_acct_site_id IS NULL -- 12616799
473: AND (hcar.end_date IS NULL OR hcar.end_date > SYSDATE)
474: AND (fu.end_date IS NULL OR fu.end_date > SYSDATE)
475: AND fnd_profile.value_specific('ONT_SEND_STATUS_UPDATE_NOTIFICATION',fu.user_id) = 'Y'
476: UNION
477: SELECT fu.user_id, fu.user_name
478: FROM hz_cust_account_roles hcar,
479: fnd_user fu,

Line 494: AND fnd_profile.value_specific('ONT_SEND_STATUS_UPDATE_NOTIFICATION',fu.user_id) = 'Y'

490: AND hr.status = 'A'
491: AND hr.subject_table_name = 'HZ_PARTIES'
492: AND (hr.end_date IS NULL OR hr.end_date > SYSDATE)
493: AND (fu.end_date IS NULL OR fu.end_date > SYSDATE)
494: AND fnd_profile.value_specific('ONT_SEND_STATUS_UPDATE_NOTIFICATION',fu.user_id) = 'Y'
495: );
496:
497: EXCEPTION
498: WHEN NO_DATA_FOUND THEN