APPS.IGC_CC_SEC_GROUP_PKG dependencies on IGC_CC_GROUPS

Line 44: CURSOR C IS SELECT ROWID FROM IGC_CC_GROUPS

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

Line 67: INSERT INTO IGC_CC_GROUPS(

63:
64: p_return_status := FND_API.G_RET_STS_SUCCESS ;
65:
66:
67: INSERT INTO IGC_CC_GROUPS(
68: CC_GROUP_ID,
69: SET_OF_BOOKS_ID,
70: CC_GROUP_NAME,
71: CC_GROUP_DESC,

Line 220: UPDATE IGC_CC_GROUPS

216: END IF;
217:
218: p_return_status := FND_API.G_RET_STS_SUCCESS ;
219:
220: UPDATE IGC_CC_GROUPS
221: SET
222: CC_GROUP_ID = P_CC_GROUP_ID,
223: SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID,
224: CC_GROUP_NAME = P_CC_GROUP_NAME,

Line 347: FROM IGC_CC_GROUPS

343: attribute12,
344: attribute13,
345: attribute14,
346: attribute15
347: FROM IGC_CC_GROUPS
348: WHERE ROWID = P_ROWID
349: for UPDATE OF CC_GROUP_ID NOWAIT;
350: Recinfo C%ROWTYPE;
351:

Line 534: FROM IGC_CC_GROUPS

530:
531: BEGIN
532: SELECT cc_group_id
533: INTO x_cc_group_id
534: FROM IGC_CC_GROUPS
535: WHERE rowid = p_rowid;
536: EXCEPTION
537: WHEN NO_DATA_FOUND THEN
538: RAISE;

Line 550: /* Delete IGC_CC_GROUPS - Master Record */

546: IF (SQL%NOTFOUND) THEN
547: RAISE NO_DATA_FOUND;
548: END IF;
549:
550: /* Delete IGC_CC_GROUPS - Master Record */
551: DELETE FROM IGC_CC_GROUPS
552: WHERE cc_group_id = x_cc_group_id;
553:
554: IF (SQL%NOTFOUND) THEN

Line 551: DELETE FROM IGC_CC_GROUPS

547: RAISE NO_DATA_FOUND;
548: END IF;
549:
550: /* Delete IGC_CC_GROUPS - Master Record */
551: DELETE FROM IGC_CC_GROUPS
552: WHERE cc_group_id = x_cc_group_id;
553:
554: IF (SQL%NOTFOUND) THEN
555: RAISE NO_DATA_FOUND;

Line 641: FROM IGC_CC_GROUPS

637: -- p_return_status := FND_API.G_RET_STS_SUCCESS ;
638:
639: SELECT COUNT(1)
640: INTO DUMMY
641: FROM IGC_CC_GROUPS
642: WHERE CC_GROUP_NAME = P_GROUP_NAME AND
643: SET_OF_BOOKS_ID = P_SOB_ID AND
644: ((P_ROWID IS NULL) OR (ROWID <> P_ROWID));
645: -- dbms_output.put_line('DUMMY '||dummy);