APPS.CSC_PROF_GROUPS_PKG dependencies on CSC_PROF_GROUPS_B

Line 66: INSERT INTO CSC_PROF_GROUPS_B(

62: FETCH C2 INTO px_GROUP_ID;
63: CLOSE C2;
64: End If;
65: -- to_date(NULL) added to include timestamp during creation
66: INSERT INTO CSC_PROF_GROUPS_B(
67: GROUP_ID,
68: CREATED_BY,
69: CREATION_DATE,
70: LAST_UPDATED_BY,

Line 149: Update CSC_PROF_GROUPS_B

145: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
146: p_APPLICATION_ID NUMBER )
147: IS
148: BEGIN
149: Update CSC_PROF_GROUPS_B
150: SET
151: LAST_UPDATED_BY =p_LAST_UPDATED_BY,
152: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
153: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 187: DELETE FROM CSC_PROF_GROUPS_B

183: p_OBJECT_VERSION_NUMBER NUMBER)
184: IS
185: BEGIN
186:
187: DELETE FROM CSC_PROF_GROUPS_B
188: WHERE GROUP_ID = p_GROUP_ID
189: AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
190: If (SQL%NOTFOUND) then
191: RAISE NO_DATA_FOUND;

Line 215: from CSC_PROF_GROUPS_B

211: END_DATE_ACTIVE,
212: USE_IN_CUSTOMER_DASHBOARD,
213: PARTY_TYPE,
214: OBJECT_VERSION_NUMBER
215: from CSC_PROF_GROUPS_B
216: where GROUP_ID = P_GROUP_ID
217: and object_version_number = p_object_version_number
218: for update of GROUP_ID nowait;
219: recinfo c%rowtype;

Line 246: from CSC_PROF_GROUPS_B B

242: begin
243: delete from CSC_PROF_GROUPS_TL T
244: where not exists
245: (select NULL
246: from CSC_PROF_GROUPS_B B
247: where B.GROUP_ID = T.GROUP_ID
248: );
249:
250: update CSC_PROF_GROUPS_TL T set (