APPS.CSC_PROF_MODULE_GROUPS_PKG dependencies on FND_API

Line 8: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*

4: -- Package name : CSC_PROF_MODULE_GROUPS_PKG
5: -- Purpose :
6: -- History :
7: -- 03 Nov 00 axsubram Added load_row for NLS (# 1487333)
8: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*
9: -- from the definition for the performance reason
10: -- 19 july 2005 tpalaniv Modified the logic in load_row API to fetch last_updated_by based on FND API as part
11: -- of R12 ATG Project - Seed Data Versioning
12: -- 19-09-2005 vshastry Bug 4596220. Added condition in insert row

Line 10: -- 19 july 2005 tpalaniv Modified the logic in load_row API to fetch last_updated_by based on FND API as part

6: -- History :
7: -- 03 Nov 00 axsubram Added load_row for NLS (# 1487333)
8: -- 26 Nov 02 JAmose Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*
9: -- from the definition for the performance reason
10: -- 19 july 2005 tpalaniv Modified the logic in load_row API to fetch last_updated_by based on FND API as part
11: -- of R12 ATG Project - Seed Data Versioning
12: -- 19-09-2005 vshastry Bug 4596220. Added condition in insert row
13: -- NOTE :
14: -- End of Comments

Line 57: If (px_MODULE_GROUP_ID IS NULL) OR (px_MODULE_GROUP_ID = FND_API.G_MISS_NUM) then

53: ps_seeded_flag:='N';
54: End If;
55: END IF;
56:
57: If (px_MODULE_GROUP_ID IS NULL) OR (px_MODULE_GROUP_ID = FND_API.G_MISS_NUM) then
58: OPEN C2;
59: FETCH C2 INTO px_MODULE_GROUP_ID;
60: CLOSE C2;
61: End If;

Line 82: decode( p_FORM_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FORM_FUNCTION_ID),

78: APPLICATION_ID,
79: DASHBOARD_GROUP_ID
80: ) VALUES (
81: px_MODULE_GROUP_ID,
82: decode( p_FORM_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FORM_FUNCTION_ID),
83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),
84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),

Line 83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),

79: DASHBOARD_GROUP_ID
80: ) VALUES (
81: px_MODULE_GROUP_ID,
82: decode( p_FORM_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FORM_FUNCTION_ID),
83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),
84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),

Line 84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),

80: ) VALUES (
81: px_MODULE_GROUP_ID,
82: decode( p_FORM_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FORM_FUNCTION_ID),
83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),
84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),

Line 85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),

81: px_MODULE_GROUP_ID,
82: decode( p_FORM_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FORM_FUNCTION_ID),
83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),
84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),

Line 86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),

82: decode( p_FORM_FUNCTION_ID, FND_API.G_MISS_NUM, NULL, p_FORM_FUNCTION_ID),
83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),
84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

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

83: decode( p_FORM_FUNCTION_NAME,FND_API.G_MISS_CHAR,NULL, p_FORM_FUNCTION_NAME),
84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

Line 88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),

84: decode( p_RESPONSIBILITY_ID, FND_API.G_MISS_NUM, NULL, p_RESPONSIBILITY_ID),
85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

Line 89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),

85: decode( p_RESP_APPL_ID, FND_API.G_MISS_NUM, NULL, p_RESP_APPL_ID),
86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
93: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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

86: decode( p_PARTY_TYPE, FND_API.G_MISS_CHAR, NULL, p_PARTY_TYPE),
87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
93: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
94: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

87: decode( p_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID),
88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
93: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
94: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
95: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG),

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

88: decode( p_DASHBOARD_GROUP_FLAG, FND_API.G_MISS_CHAR, NULL, p_DASHBOARD_GROUP_FLAG),
89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
93: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
94: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
95: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG),
96: decode( p_APPLICATION_ID,CSC_CORE_UTILS_PVT.G_MISS_NUM, NULL, p_APPLICATION_ID),

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

89: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
93: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
94: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
95: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG),
96: decode( p_APPLICATION_ID,CSC_CORE_UTILS_PVT.G_MISS_NUM, NULL, p_APPLICATION_ID),
97: decode( p_DASHBOARD_GROUP_ID,CSC_CORE_UTILS_PVT.G_MISS_NUM,NULL, p_DASHBOARD_GROUP_ID));

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

90: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
91: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
93: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
94: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
95: decode( p_SEEDED_FLAG,CSC_CORE_UTILS_PVT.G_MISS_CHAR, NULL, ps_SEEDED_FLAG),
96: decode( p_APPLICATION_ID,CSC_CORE_UTILS_PVT.G_MISS_NUM, NULL, p_APPLICATION_ID),
97: decode( p_DASHBOARD_GROUP_ID,CSC_CORE_UTILS_PVT.G_MISS_NUM,NULL, p_DASHBOARD_GROUP_ID));
98: End Insert_Row;