DBA Data[Home] [Help]

APPS.CSC_COLOR_CODES_PKG dependencies on FND_API

Line 8: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes

4: -- Package name : CSC_COLOR_CODES_PKG
5: -- Purpose :
6: -- History :
7: -- 03 Nov 00 axsubram Added Load_row for NLS (#1487340)
8: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
9: --
10: -- 19 july 2005 tpalaniv Modified the logic in load_row API to fetch l_user_id from fnd API
11: -- as part of R12 ATG Project
12: --

Line 10: -- 19 july 2005 tpalaniv Modified the logic in load_row API to fetch l_user_id from fnd API

6: -- History :
7: -- 03 Nov 00 axsubram Added Load_row for NLS (#1487340)
8: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes
9: --
10: -- 19 july 2005 tpalaniv Modified the logic in load_row API to fetch l_user_id from fnd API
11: -- as part of R12 ATG Project
12: --
13: -- NOTE :
14: -- End of Comments

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

38: LAST_UPDATE_LOGIN
39: ) VALUES (
40: px_COLOR_CODE,
41: p_rating_code,
42: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
43: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
44: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
45: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
46: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

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

39: ) VALUES (
40: px_COLOR_CODE,
41: p_rating_code,
42: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
43: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
44: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
45: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
46: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
47: End Insert_Row;

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

40: px_COLOR_CODE,
41: p_rating_code,
42: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
43: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
44: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
45: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
46: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
47: End Insert_Row;
48:

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

41: p_rating_code,
42: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
43: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
44: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
45: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
46: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
47: End Insert_Row;
48:
49: PROCEDURE Update_Row(

Line 46: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));

42: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
43: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
44: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
45: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
46: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
47: End Insert_Row;
48:
49: PROCEDURE Update_Row(
50: p_COLOR_CODE VARCHAR2,