DBA Data[Home] [Help]

APPS.AS_ACCESS_PUB dependencies on FND_PROFILE

Line 1166: and FND_PROFILE.Value('AS_CUST_ACCESS') <> 'F'

1162: l_var varchar2(1);
1163: begin
1164: x_valid_flag := 'Y';
1165: if p_security_type = 'ORGANIZATION'
1166: and FND_PROFILE.Value('AS_CUST_ACCESS') <> 'F'
1167: then
1168: open org_contact_exist_csr;
1169: fetch org_contact_exist_csr into l_var;
1170: if org_contact_exist_csr%FOUND

Line 1179: and FND_PROFILE.Value('AS_OPP_ACCESS') <> 'F'

1175:
1176: end if;
1177: close org_contact_exist_csr;
1178: elsif p_security_type = 'OPPORTUNITY'
1179: and FND_PROFILE.Value('AS_OPP_ACCESS') <> 'F'
1180: then
1181: open opp_contact_exist_csr;
1182: fetch opp_contact_exist_csr into l_var;
1183: if opp_contact_exist_csr%FOUND

Line 1192: and FND_PROFILE.Value('AS_LEAD_ACCESS') <> 'F'

1188:
1189: end if;
1190: close opp_contact_exist_csr;
1191: elsif p_security_type = 'LEAD'
1192: and FND_PROFILE.Value('AS_LEAD_ACCESS') <> 'F'
1193: then
1194: open lead_contact_exist_csr;
1195: fetch lead_contact_exist_csr into l_var;
1196: if lead_contact_exist_csr%FOUND