APPS.OKS_OKSNREPD_XMLP_PKG dependencies on FND_PROFILE

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

92: WHEN /*SRW.USER_EXIT_FAILURE*/OTHERS THEN
93: /*SRW.MESSAGE(1
94: ,'srw_init')*/NULL;
95: END;
96: IF P_ORG_ID IS NULL AND FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG') = 'Y' THEN
97: P_ORG_ID := FND_PROFILE.VALUE('ORG_ID');
98: END IF;
99: IF P_ORG_ID IS NOT NULL THEN
100: X_ORG_ID := ' and exp.org_id = :p_org_id';

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

93: /*SRW.MESSAGE(1
94: ,'srw_init')*/NULL;
95: END;
96: IF P_ORG_ID IS NULL AND FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG') = 'Y' THEN
97: P_ORG_ID := FND_PROFILE.VALUE('ORG_ID');
98: END IF;
99: IF P_ORG_ID IS NOT NULL THEN
100: X_ORG_ID := ' and exp.org_id = :p_org_id';
101: P_ORG_ID_WHERE := X_ORG_ID;