eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROF_GROUP_CATEGORIES_PKG dependencies on FND_API

Line 7: -- 26 Nov 2002 JAmose For Fnd_Api.G_Miss* changes

3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CATEGORIES_PKG
5: -- Purpose :
6: -- History :
7: -- 26 Nov 2002 JAmose For Fnd_Api.G_Miss* changes
8: -- 19 july 2005 tpalaniv Modified the load_row API to fetch last_updated_by using FND API
9: -- 19-09-2005 vshastry Bug 4596220. Added condition in insert row
10: -- NOTE :
11: -- End of Comments

Line 8: -- 19 july 2005 tpalaniv Modified the load_row API to fetch last_updated_by using FND API

4: -- Package name : CSC_PROF_GROUP_CATEGORIES_PKG
5: -- Purpose :
6: -- History :
7: -- 26 Nov 2002 JAmose For Fnd_Api.G_Miss* changes
8: -- 19 july 2005 tpalaniv Modified the load_row API to fetch last_updated_by using FND API
9: -- 19-09-2005 vshastry Bug 4596220. Added condition in insert row
10: -- NOTE :
11: -- End of Comments
12:

Line 46: If (px_GROUP_CATEGORY_ID IS NULL) OR (px_GROUP_CATEGORY_ID = FND_API.G_MISS_NUM) then

42: ps_seeded_flag:='N';
43: End If;
44: END IF;
45:
46: If (px_GROUP_CATEGORY_ID IS NULL) OR (px_GROUP_CATEGORY_ID = FND_API.G_MISS_NUM) then
47: OPEN C2;
48: FETCH C2 INTO px_GROUP_CATEGORY_ID;
49: CLOSE C2;
50: End If;

Line 64: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),

60: LAST_UPDATE_LOGIN,
61: SEEDED_FLAG
62: ) VALUES (
63: px_GROUP_CATEGORY_ID,
64: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

Line 65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),

61: SEEDED_FLAG
62: ) VALUES (
63: px_GROUP_CATEGORY_ID,
64: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),

62: ) VALUES (
63: px_GROUP_CATEGORY_ID,
64: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

Line 67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

63: px_GROUP_CATEGORY_ID,
64: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
71: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

64: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
71: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
72: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG));

Line 69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

65: decode( p_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_CATEGORY_CODE),
66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
71: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
72: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG));
73: End Insert_Row;

Line 70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

66: decode( p_CATEGORY_SEQUENCE, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SEQUENCE),
67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
71: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
72: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG));
73: End Insert_Row;
74:

Line 71: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

67: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
68: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
69: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
70: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
71: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
72: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG));
73: End Insert_Row;
74:
75: PROCEDURE Update_Row(