34: IS
35: BEGIN
36:
37: IF p_attr_code =('NAME') THEN
38: IF NVL(p_record.NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
39: RETURN p_record.NAME;
40: ELSE
41: RETURN NULL;
42: END IF;
40: ELSE
41: RETURN NULL;
42: END IF;
43: ELSIF p_attr_code =('SALESREP_ID') THEN
44: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
45: RETURN p_record.SALESREP_ID;
46: ELSE
47: RETURN NULL;
48: END IF;
59: IS
60: BEGIN
61:
62: IF p_attr_code =('NAME') THEN
63: IF NVL(p_record.NAME, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
64: RETURN to_date(p_record.NAME,'RRRR/MM/DD HH24:MI:SS');
65: ELSE
66: RETURN NULL;
67: END IF;
65: ELSE
66: RETURN NULL;
67: END IF;
68: ELSIF p_attr_code =('SALESREP_ID') THEN
69: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
70: RETURN to_date(p_record.SALESREP_ID,'RRRR/MM/DD HH24:MI:SS');
71: ELSE
72: RETURN NULL;
73: END IF;
96: WHERE SALESREP_ID = p_SALESREP_ID
97: ;
98: BEGIN
99:
100: IF (NVL(p_SALESREP_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
101: THEN
102: RETURN 0 ;
103: ELSIF (NVL(g_cached_record.SALESREP_ID,FND_API.G_MISS_NUM) <> p_SALESREP_ID)
104: THEN
99:
100: IF (NVL(p_SALESREP_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
101: THEN
102: RETURN 0 ;
103: ELSIF (NVL(g_cached_record.SALESREP_ID,FND_API.G_MISS_NUM) <> p_SALESREP_ID)
104: THEN
105: Clear_SALESREP_Cache;
106: Open cache;
107: FETCH cache into g_cached_record;