APPS.CS_SRCONTACT_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 950: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;

946: l_activity_code VARCHAR2(1);
947: l_sr_contact_point_id NUMBER;
948: l_sysdate DATE;
949: l_add_audit VARCHAR2(1);
950: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
951: --
952: BEGIN
953: l_audit_enabled := FND_PROFILE.value('CS_SR_CONT_PNT_AUDIT_ENABLED');
954: IF p_contact_tbl.COUNT = 0

Line 1092: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;

1088: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1089: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1090: l_msg_count NUMBER;
1091: l_msg_data VARCHAR2(4000);
1092: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
1093: BEGIN
1094: l_audit_enabled := FND_PROFILE.value('CS_SR_CONT_PNT_AUDIT_ENABLED');
1095: UPDATE cs_hz_sr_contact_points
1096: SET primary_flag = 'N'