APPS.IGC_CC_ACCESS_PKG dependencies on IGC_CC_ACCESS

Line 1: PACKAGE BODY IGC_CC_ACCESS_PKG AS

1: PACKAGE BODY IGC_CC_ACCESS_PKG AS
2: /*$Header: IGCCACCB.pls 120.3.12000000.1 2007/08/20 12:10:32 mbremkum ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACCESS_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACCESS_PKG';

1: PACKAGE BODY IGC_CC_ACCESS_PKG AS
2: /*$Header: IGCCACCB.pls 120.3.12000000.1 2007/08/20 12:10:32 mbremkum ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACCESS_PKG';
5:
6: -- The flag determines whether to print debug information or not.
7: g_debug_flag VARCHAR2(1) := 'N' ;
8:

Line 43: FROM igc_cc_access

39: l_api_version CONSTANT NUMBER := 1.0;
40:
41: CURSOR C IS
42: SELECT rowid
43: FROM igc_cc_access
44: WHERE cc_access_id = p_cc_access_id;
45:
46: BEGIN
47:

Line 65: INSERT INTO igc_cc_access(

61: END IF;
62:
63: x_return_status := FND_API.G_RET_STS_SUCCESS ;
64:
65: INSERT INTO igc_cc_access(
66: CC_HEADER_ID,
67: USER_ID,
68: CC_GROUP_ID,
69: CC_ACCESS_ID,

Line 83: NVL(p_CC_ACCESS_ID, igc_cc_access_s.NEXTVAL),

79: (
80: p_CC_HEADER_ID,
81: p_USER_ID,
82: p_CC_GROUP_ID,
83: NVL(p_CC_ACCESS_ID, igc_cc_access_s.NEXTVAL),
84: p_CC_ACCESS_LEVEL,
85: p_CC_ACCESS_TYPE,
86: p_LAST_UPDATE_DATE,
87: p_LAST_UPDATED_BY,

Line 174: FROM igc_cc_access

170:
171: Counter NUMBER;
172: CURSOR C IS
173: SELECT *
174: FROM igc_cc_access
175: WHERE rowid = p_row_id
176: FOR UPDATE NOWAIT;
177: Recinfo C%ROWTYPE;
178:

Line 335: UPDATE igc_cc_access

331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS ;
333:
334:
335: UPDATE igc_cc_access
336: SET
337: CC_HEADER_ID = p_CC_HEADER_ID,
338: USER_ID = p_USER_ID,
339: CC_GROUP_ID = p_CC_GROUP_ID,

Line 440: DELETE FROM igc_cc_access

436: x_return_status := FND_API.G_RET_STS_SUCCESS ;
437:
438: -- Deleting the record in psb_dss_fdi_filters.
439:
440: DELETE FROM igc_cc_access
441: WHERE rowid = p_row_id;
442:
443:
444: IF (SQL%NOTFOUND) THEN

Line 515: FROM igc_cc_access

511: l_tmp VARCHAR2(1);
512:
513: CURSOR c IS
514: SELECT '1'
515: FROM igc_cc_access
516: WHERE cc_access_id = p_cc_access_id
517: AND (
518: p_row_id IS NULL
519: OR

Line 619: From IGC_CC_ACCESS

615:
616: Begin
617: Select max(cc_access_level)
618: Into l_u_access_level
619: From IGC_CC_ACCESS
620: Where user_id = p_user_id
621: and cc_access_type like 'U'
622: and cc_header_id = p_header_id
623: Group By cc_header_id;

Line 632: From IGC_CC_ACCESS a,

628:
629: Begin
630: Select max(cc_access_level)
631: Into l_g_access_level
632: From IGC_CC_ACCESS a,
633: IGC_CC_GROUP_USERS b
634: Where b.user_id = p_user_id
635: and a.cc_access_type like 'G'
636: and a.cc_header_id = p_header_id

Line 658: END IGC_CC_ACCESS_PKG;

654:
655: End get_access_level;
656:
657:
658: END IGC_CC_ACCESS_PKG;