APPS.CS_SRCONTACT_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 952: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;

948: l_activity_code VARCHAR2(1);
949: l_sr_contact_point_id NUMBER;
950: l_sysdate DATE;
951: l_add_audit VARCHAR2(1);
952: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
953: --
954: BEGIN
955: --siahmed added to disable auditing if invocation_mode is set to replay
956: --before there was no if condition it was just the following commented line

Line 1103: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;

1099: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1100: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1101: l_msg_count NUMBER;
1102: l_msg_data VARCHAR2(4000);
1103: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
1104: BEGIN
1105: l_audit_enabled := FND_PROFILE.value('CS_SR_CONT_PNT_AUDIT_ENABLED');
1106: UPDATE cs_hz_sr_contact_points
1107: SET primary_flag = 'N'