APPS.OKS_EXTWARPRGM_OSO_PVT dependencies on FND_PROFILE

Line 904: l_notify := Nvl(Fnd_Profile.Value ('OKS_INTEGRATION_NOTIFY_YN'),'NO');

900: l_receiver Varchar2(30);
901:
902: BEGIN
903:
904: l_notify := Nvl(Fnd_Profile.Value ('OKS_INTEGRATION_NOTIFY_YN'),'NO');
905: l_receiver := Nvl(Fnd_Profile.Value ('OKS_INTEGRATION_NOTIFY_TO'),'SYSADMIN');
906:
907:
908: If upper(l_notify) = 'YES' Then

Line 905: l_receiver := Nvl(Fnd_Profile.Value ('OKS_INTEGRATION_NOTIFY_TO'),'SYSADMIN');

901:
902: BEGIN
903:
904: l_notify := Nvl(Fnd_Profile.Value ('OKS_INTEGRATION_NOTIFY_YN'),'NO');
905: l_receiver := Nvl(Fnd_Profile.Value ('OKS_INTEGRATION_NOTIFY_TO'),'SYSADMIN');
906:
907:
908: If upper(l_notify) = 'YES' Then
909:

Line 1463: l_ctrgrp := Nvl(p_k_header_rec.chr_group, Nvl(Fnd_Profile.Value ('OKS_WARR_CONTRACT_GROUP'),2));

1459:
1460:
1461: --Grouping Routine
1462:
1463: l_ctrgrp := Nvl(p_k_header_rec.chr_group, Nvl(Fnd_Profile.Value ('OKS_WARR_CONTRACT_GROUP'),2));
1464: l_cgcv_tbl_in(1).cgp_parent_id := l_ctrgrp;
1465: l_cgcv_tbl_in(1).included_chr_id := l_chrid;
1466: l_cgcv_tbl_in(1).object_version_number := OKC_API.G_MISS_NUM;
1467: l_cgcv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;