APPS.FUN_SECURITY dependencies on FUN_SECURITY

Line 1: PACKAGE BODY FUN_SECURITY AS

1: PACKAGE BODY FUN_SECURITY AS
2: /* $Header: FUNSECAB.pls 120.13 2006/09/15 10:04:10 bsilveir noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FUN_SECURITY';
5: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FUN_SECURITY';

1: PACKAGE BODY FUN_SECURITY AS
2: /* $Header: FUNSECAB.pls 120.13 2006/09/15 10:04:10 bsilveir noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FUN_SECURITY';
5: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7:
8:

Line 30: 'fun.plsql.fun_security.get_instance_set_ids','begin');

26:
27: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
28: THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
30: 'fun.plsql.fun_security.get_instance_set_ids','begin');
31: END IF;
32:
33: FOR c_record IN c_get_instance_set_id
34: LOOP

Line 47: 'fun.plsql.fun_security.get_instance_set_ids','end');

43:
44: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
45: THEN
46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
47: 'fun.plsql.fun_security.get_instance_set_ids','end');
48: END IF;
49:
50: END get_instance_set_ids;
51:

Line 107: l_module := 'fun.plsql.fun_security.create_assign';

103: and start_date < sysdate and end_date > sysdate ));
104:
105: BEGIN
106:
107: l_module := 'fun.plsql.fun_security.create_assign';
108:
109: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
110: THEN
111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 864: l_module VARCHAR2(100) := 'fun.plsql.fun_security.update_assign';

860: l_instance_set_dist fnd_object_instance_sets.instance_set_id%TYPE;
861: l_grant_guid fnd_grants.grant_guid%TYPE;
862: l_api_version CONSTANT NUMBER := 1.0;
863: l_api_name CONSTANT VARCHAR2(30) := 'create_assign';
864: l_module VARCHAR2(100) := 'fun.plsql.fun_security.update_assign';
865:
866: CURSOR c_grant_info(
867: p_person_id NUMBER,
868: p_org_id NUMBER,

Line 1128: 'fun.plsql.fun_security.is_access_allow','begin');

1124: BEGIN
1125: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1126: THEN
1127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1128: 'fun.plsql.fun_security.is_access_allow','begin');
1129: END IF;
1130:
1131: SELECT 1
1132: INTO l_exists

Line 1152: 'fun.plsql.fun_security.is_access_allow','end');

1148:
1149: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1150: THEN
1151: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1152: 'fun.plsql.fun_security.is_access_allow','end');
1153: END IF;
1154:
1155: IF l_exists > 0 THEN
1156: RETURN 'Y';

Line 1167: 'fun.plsql.fun_security.is_access_allow','end');

1163: WHEN NO_DATA_FOUND THEN
1164: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1165: THEN
1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1167: 'fun.plsql.fun_security.is_access_allow','end');
1168: END IF;
1169: RETURN 'N';
1170: END is_access_allow;
1171:

Line 1194: 'fun.plsql.fun_security.is_access_valid','begin');

1190:
1191: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1192: THEN
1193: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1194: 'fun.plsql.fun_security.is_access_valid','begin');
1195: END IF;
1196:
1197: SELECT start_date,end_date
1198: INTO l_start_date,l_end_date

Line 1217: 'fun.plsql.fun_security.is_access_valid','end');

1213:
1214: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
1215: THEN
1216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1217: 'fun.plsql.fun_security.is_access_valid','end');
1218: END IF;
1219:
1220: IF ( (l_start_date IS NULL OR l_start_date <= SYSDATE)
1221: AND

Line 1234: END FUN_SECURITY;

1230: RETURN 'N';
1231:
1232: END is_access_valid;
1233:
1234: END FUN_SECURITY;