APPS.CS_SRCONTACT_PKG dependencies on FND_PROFILE

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 953: l_audit_enabled := FND_PROFILE.value('CS_SR_CONT_PNT_AUDIT_ENABLED');

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
955: THEN
956: x_return_status := FND_API.G_RET_STS_SUCCESS;
957: RETURN;

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'

Line 1094: l_audit_enabled := FND_PROFILE.value('CS_SR_CONT_PNT_AUDIT_ENABLED');

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'
1097: WHERE incident_id = p_incident_id
1098: AND primary_flag = 'Y'