APPS.IGC_CC_SEC_GROUP_USERS_PKG dependencies on IGC_CC_GROUP_USERS

Line 44: CURSOR C IS SELECT ROWID FROM IGC_CC_GROUP_USERS

40: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
41: l_api_version CONSTANT NUMBER := 1.0;
42:
43:
44: CURSOR C IS SELECT ROWID FROM IGC_CC_GROUP_USERS
45: WHERE CC_GROUP_ID = P_CC_GROUP_ID
46: and USER_ID = P_USER_ID ;
47: BEGIN
48:

Line 66: INSERT INTO IGC_CC_GROUP_USERS(

62: END IF;
63:
64: p_return_status := FND_API.G_RET_STS_SUCCESS ;
65:
66: INSERT INTO IGC_CC_GROUP_USERS(
67: CC_GROUP_ID,
68: USER_ID,
69: CONTEXT,
70: ATTRIBUTE1,

Line 217: UPDATE IGC_CC_GROUP_USERS

213: END IF;
214:
215: p_return_status := FND_API.G_RET_STS_SUCCESS ;
216:
217: UPDATE IGC_CC_GROUP_USERS
218: SET
219: CC_GROUP_ID = P_CC_GROUP_ID,
220: USER_ID = P_USER_ID,
221: CONTEXT = P_CONTEXT,

Line 339: from IGC_CC_GROUP_USERS

335: attribute12,
336: attribute13,
337: attribute14,
338: attribute15
339: from IGC_CC_GROUP_USERS
340: where rowid = P_ROWID
341: for UPDATE OF CC_GROUP_ID NOWAIT;
342: Recinfo C%ROWTYPE;
343:

Line 523: FROM IGC_CC_GROUP_USERS

519:
520: BEGIN
521: SELECT cc_group_id, user_id
522: INTO x_cc_group_id, x_user_id
523: FROM IGC_CC_GROUP_USERS
524: WHERE rowid = P_rowid;
525:
526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN

Line 532: /* Delete IGC_CC_GROUP_USERS - Detail Record */

528: RAISE;
529: END;
530:
531:
532: /* Delete IGC_CC_GROUP_USERS - Detail Record */
533: DELETE FROM IGC_CC_GROUP_USERS
534: WHERE cc_group_id = x_cc_group_id
535: and user_id = x_user_id;
536:

Line 533: DELETE FROM IGC_CC_GROUP_USERS

529: END;
530:
531:
532: /* Delete IGC_CC_GROUP_USERS - Detail Record */
533: DELETE FROM IGC_CC_GROUP_USERS
534: WHERE cc_group_id = x_cc_group_id
535: and user_id = x_user_id;
536:
537: IF (SQL%NOTFOUND) THEN