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 1877: /*l_duplicate_uom := fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM');

1873:
1874: BEGIN
1875:
1876: /* Start : 5686752 */
1877: /*l_duplicate_uom := fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM');
1878: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1879:
1880: OPEN c_UOM_Conversion_Rate_csr;
1881: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;

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

1874: BEGIN
1875:
1876: /* Start : 5686752 */
1877: /*l_duplicate_uom := fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM');
1878: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1879:
1880: OPEN c_UOM_Conversion_Rate_csr;
1881: FETCH c_UOM_Conversion_Rate_csr into l_UOM_Conversion_Rate_rec;
1882: IF (c_UOM_Conversion_Rate_csr%NOTFOUND) THEN

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

1888: p_duplicate_time_frame := sysdate - l_multiple_by;
1889:
1890: END CALCULATE_DUPLICATE_TIME_FRAME;*/
1891:
1892: l_duplicate_uom := UPPER(fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM'));
1893: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1894:
1895: If l_duplicate_uom = 'HR' Then
1896: p_duplicate_time_frame := sysdate - (l_duplicate_offset * 1/24);

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

1889:
1890: END CALCULATE_DUPLICATE_TIME_FRAME;*/
1891:
1892: l_duplicate_uom := UPPER(fnd_profile.value('CS_SR_DUP_TIME_FRAME_UOM'));
1893: l_duplicate_offset := fnd_profile.value('CS_SR_DUP_TIME_FRAME');
1894:
1895: If l_duplicate_uom = 'HR' Then
1896: p_duplicate_time_frame := sysdate - (l_duplicate_offset * 1/24);
1897: ElsIf l_duplicate_uom = 'DAY' Then