APPS.OKS_OKSSUMCO_XMLP_PKG dependencies on FND_PROFILE

Line 47: P_VENDOR_CONT_ROLE := NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE')

43: WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
44: /*SRW.MESSAGE(1
45: ,'srw_init')*/NULL;
46: END;
47: P_VENDOR_CONT_ROLE := NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE')
48: ,'SUP_SALES');
49: IF P_ORG_ID IS NULL AND FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG') = 'Y' THEN
50: P_ORG_ID := FND_PROFILE.VALUE('ORG_ID');
51: END IF;

Line 49: IF P_ORG_ID IS NULL AND FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG') = 'Y' THEN

45: ,'srw_init')*/NULL;
46: END;
47: P_VENDOR_CONT_ROLE := NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE')
48: ,'SUP_SALES');
49: IF P_ORG_ID IS NULL AND FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG') = 'Y' THEN
50: P_ORG_ID := FND_PROFILE.VALUE('ORG_ID');
51: END IF;
52: IF P_ORG_ID IS NOT NULL THEN
53: X_ORG_ID := ' and KHD.Authoring_Org_Id = :p_org_id ';

Line 50: P_ORG_ID := FND_PROFILE.VALUE('ORG_ID');

46: END;
47: P_VENDOR_CONT_ROLE := NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE')
48: ,'SUP_SALES');
49: IF P_ORG_ID IS NULL AND FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG') = 'Y' THEN
50: P_ORG_ID := FND_PROFILE.VALUE('ORG_ID');
51: END IF;
52: IF P_ORG_ID IS NOT NULL THEN
53: X_ORG_ID := ' and KHD.Authoring_Org_Id = :p_org_id ';
54: P_ORG_ID_WHERE := X_ORG_ID;