APPS.CS_SR_DUP_CHK_PVT dependencies on FND_PROFILE

Line 247: cs_dup_prof_value := fnd_profile.value('CS_SR_DUP_CHK_CRITERIA');

243: p_ea_attr_dup_flag := fnd_api.g_false;
244: return;
245: END IF;
246:
247: cs_dup_prof_value := fnd_profile.value('CS_SR_DUP_CHK_CRITERIA');
248:
249: IF p_incident_id is not null and
250: (cs_dup_prof_value NOT IN ('CS_DUP_CRIT_EA_ADDR', 'CS_DUP_CRIT_WITHNO_SERIAL', 'CS_DUP_CRIT_WITH_SERIAL') or cs_dup_prof_value is null)
251: THEN

Line 1939: /*l_duplicate_uom := fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM');

1935:
1936: BEGIN
1937:
1938: /* Start : 5686752 */
1939: /*l_duplicate_uom := fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM');
1940: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1941:
1942: OPEN c_UOM_Conversion_Rate_csr;
1943: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;

Line 1940: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');

1936: BEGIN
1937:
1938: /* Start : 5686752 */
1939: /*l_duplicate_uom := fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM');
1940: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1941:
1942: OPEN c_UOM_Conversion_Rate_csr;
1943: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;
1944: IF (c_UOM_Conversion_Rate_csr%NOTFOUND) THEN

Line 1954: l_duplicate_uom := UPPER(fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM'));

1950: p_duplicate_time_frame := sysdate - l_multiple_by;
1951:
1952: END CALCULATE_DUPLICATE_TIME_FRAME;*/
1953:
1954: l_duplicate_uom := UPPER(fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM'));
1955: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1956:
1957: If l_duplicate_uom = 'HR' Then
1958: p_duplicate_time_frame := sysdate - (l_duplicate_offset * 1/24);

Line 1955: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');

1951:
1952: END CALCULATE_DUPLICATE_TIME_FRAME;*/
1953:
1954: l_duplicate_uom := UPPER(fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM'));
1955: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1956:
1957: If l_duplicate_uom = 'HR' Then
1958: p_duplicate_time_frame := sysdate - (l_duplicate_offset * 1/24);
1959: ElsIf l_duplicate_uom = 'DAY' Then