eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_GRANTS

Line 94: RETURN IGS_SC_GRANTS_PVT.check_attrib_text ( p_table_name , p_select_text , p_obj_attrib_type );

90:
91: RETURN BOOLEAN IS
92: BEGIN
93:
94: RETURN IGS_SC_GRANTS_PVT.check_attrib_text ( p_table_name , p_select_text , p_obj_attrib_type );
95:
96: END check_attrib_text;
97:
98:

Line 108: data insertion into the igs_sc_grants table.

104: /******************************************************************
105: Created By : Don Shellito
106: Date Created By : April 23, 2003
107: Purpose : This procedure is designed for the handling of
108: data insertion into the igs_sc_grants table.
109: Validation is performed on the function_id,
110: user_group_id, and obj_group_id that these IDs
111: are currently in the IGS Security structure.
112: Remarks :

Line 123: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,

119: ******************************************************************/
120: PROCEDURE Insert_Grant (p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
124: p_function_id IN igs_sc_grants.function_id%TYPE,
125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,

Line 124: p_function_id IN igs_sc_grants.function_id%TYPE,

120: PROCEDURE Insert_Grant (p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
124: p_function_id IN igs_sc_grants.function_id%TYPE,
125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,

Line 125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,

121: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
124: p_function_id IN igs_sc_grants.function_id%TYPE,
125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

Line 126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,

122: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
124: p_function_id IN igs_sc_grants.function_id%TYPE,
125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

Line 127: p_grant_name IN igs_sc_grants.grant_name%TYPE,

123: p_grant_id IN OUT NOCOPY igs_sc_grants.grant_id%TYPE,
124: p_function_id IN igs_sc_grants.function_id%TYPE,
125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

Line 128: p_grant_text IN igs_sc_grants.grant_text%TYPE,

124: p_function_id IN igs_sc_grants.function_id%TYPE,
125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
132: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

Line 129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

125: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
132: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
133: x_return_status OUT NOCOPY VARCHAR2,

Line 130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

126: p_obj_group_id IN igs_sc_grants.obj_group_id%TYPE,
127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
132: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_return_message OUT NOCOPY VARCHAR2

Line 131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

127: p_grant_name IN igs_sc_grants.grant_name%TYPE,
128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
132: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_return_message OUT NOCOPY VARCHAR2
135: )

Line 132: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

128: p_grant_text IN igs_sc_grants.grant_text%TYPE,
129: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
130: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
131: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
132: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_return_message OUT NOCOPY VARCHAR2
135: )
136: IS

Line 146: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;

142: l_api_version CONSTANT NUMBER := 1.0;
143: l_return_message VARCHAR2(2000);
144: l_message_count NUMBER(15);
145: l_return_status VARCHAR2(30);
146: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';

Line 147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;

143: l_return_message VARCHAR2(2000);
144: l_message_count NUMBER(15);
145: l_return_status VARCHAR2(30);
146: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';
151: l_function_id igs_sc_obj_functns.function_id%TYPE;

Line 148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;

144: l_message_count NUMBER(15);
145: l_return_status VARCHAR2(30);
146: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';
151: l_function_id igs_sc_obj_functns.function_id%TYPE;
152: l_obj_group_id igs_sc_objects.object_id%TYPE;

Line 149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;

145: l_return_status VARCHAR2(30);
146: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';
151: l_function_id igs_sc_obj_functns.function_id%TYPE;
152: l_obj_group_id igs_sc_objects.object_id%TYPE;
153: l_user_group_id wf_local_roles.orig_system_id%TYPE;

Line 150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';

146: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';
151: l_function_id igs_sc_obj_functns.function_id%TYPE;
152: l_obj_group_id igs_sc_objects.object_id%TYPE;
153: l_user_group_id wf_local_roles.orig_system_id%TYPE;
154:

Line 248: INTO igs_sc_grants

244: -- -----------------------------------------------------------------
245: -- Insert the values requested into the Grants table.
246: -- -----------------------------------------------------------------
247: INSERT
248: INTO igs_sc_grants
249: (grant_id,
250: function_id,
251: user_group_id,
252: obj_group_id,

Line 266: VALUES (NVL(p_grant_id,igs_sc_grants_s.nextval),

262: last_updated_by,
263: last_update_date,
264: last_update_login
265: )
266: VALUES (NVL(p_grant_id,igs_sc_grants_s.nextval),
267: l_function_id,
268: l_user_group_id,
269: l_obj_group_id,
270: p_grant_name,

Line 385: l_grant_id igs_sc_grants.grant_id%TYPE := p_grant_id;

381: l_message_count NUMBER(15);
382: l_return_status VARCHAR2(30);
383: l_user_attr_id igs_sc_usr_attribs.user_attrib_id%TYPE := p_user_attrib_id;
384: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE := p_obj_attrib_id;
385: l_grant_id igs_sc_grants.grant_id%TYPE := p_grant_id;
386:
387: BEGIN
388: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
389: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant_Cond';

Line 621: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

617:
618: -- -----------------------------------------------------------------
619: -- Check if admin mode is enabled
620: -- -----------------------------------------------------------------
621: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
622:
623: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
624: FND_MSG_PUB.Add;
625: RAISE FND_API.G_EXC_ERROR;

Line 784: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

780:
781: -- -----------------------------------------------------------------
782: -- Check if admin mode is enabled
783: -- -----------------------------------------------------------------
784: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
785:
786: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
787: FND_MSG_PUB.Add;
788: RAISE FND_API.G_EXC_ERROR;

Line 958: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

954:
955: -- -----------------------------------------------------------------
956: -- Check if admin mode is enabled
957: -- -----------------------------------------------------------------
958: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
959:
960: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_ERROR;

Line 1162: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

1158:
1159: -- -----------------------------------------------------------------
1160: -- Check if admin mode is enabled
1161: -- -----------------------------------------------------------------
1162: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
1163:
1164: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
1165: FND_MSG_PUB.Add;
1166: RAISE FND_API.G_EXC_ERROR;

Line 1356: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

1352:
1353: -- -----------------------------------------------------------------
1354: -- Check if admin mode is enabled
1355: -- -----------------------------------------------------------------
1356: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
1357:
1358: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
1359: FND_MSG_PUB.Add;
1360: RAISE FND_API.G_EXC_ERROR;

Line 1578: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

1574:
1575: -- -----------------------------------------------------------------
1576: -- Check if admin mode is enabled
1577: -- -----------------------------------------------------------------
1578: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
1579:
1580: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
1581: FND_MSG_PUB.Add;
1582: RAISE FND_API.G_EXC_ERROR;

Line 1672: IGS_SC_GRANTS_PVT.POPULATE_USER_ATTRIB (

1668: -- Generate values
1669:
1670: IF l_static_type IN ('C','S') AND l_user_attrib_type <> 'U' THEN
1671:
1672: IGS_SC_GRANTS_PVT.POPULATE_USER_ATTRIB (
1673: P_API_VERSION => 1.0,
1674: P_ATTRIB_ID => p_user_attrib_id,
1675: P_USER_ID => NULL,
1676: P_ALL_ATTRIBS => 'Y',

Line 2002: IGS_SC_GRANTS_PVT.POPULATE_USER_ATTRIB (

1998: p_expiration_date => p_expiration_date
1999: );
2000:
2001: -- Populate the user attributes values
2002: IGS_SC_GRANTS_PVT.POPULATE_USER_ATTRIB (
2003: P_API_VERSION => 1.0,
2004: P_ATTRIB_ID => NULL,
2005: P_USER_ID => p_user_orig_system_id,
2006: P_ALL_ATTRIBS => 'Y',

Line 2171: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

2167:
2168: -- -----------------------------------------------------------------
2169: -- Check if admin mode is enabled
2170: -- -----------------------------------------------------------------
2171: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
2172:
2173: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
2174: FND_MSG_PUB.Add;
2175: RAISE FND_API.G_EXC_ERROR;

Line 2609: p_grant_id IN igs_sc_grants.grant_id%TYPE,

2605: ******************************************************************/
2606: PROCEDURE Update_Grant (p_api_version IN NUMBER,
2607: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2608: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2609: p_grant_id IN igs_sc_grants.grant_id%TYPE,
2610: p_function_id IN igs_sc_grants.function_id%TYPE,
2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,

Line 2610: p_function_id IN igs_sc_grants.function_id%TYPE,

2606: PROCEDURE Update_Grant (p_api_version IN NUMBER,
2607: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2608: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2609: p_grant_id IN igs_sc_grants.grant_id%TYPE,
2610: p_function_id IN igs_sc_grants.function_id%TYPE,
2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

Line 2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,

2607: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2608: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2609: p_grant_id IN igs_sc_grants.grant_id%TYPE,
2610: p_function_id IN igs_sc_grants.function_id%TYPE,
2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

Line 2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,

2608: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2609: p_grant_id IN igs_sc_grants.grant_id%TYPE,
2610: p_function_id IN igs_sc_grants.function_id%TYPE,
2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

Line 2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,

2609: p_grant_id IN igs_sc_grants.grant_id%TYPE,
2610: p_function_id IN igs_sc_grants.function_id%TYPE,
2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
2617: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

Line 2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',

2610: p_function_id IN igs_sc_grants.function_id%TYPE,
2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
2617: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
2618: x_return_status OUT NOCOPY VARCHAR2,

Line 2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',

2611: p_user_group_id IN igs_sc_grants.user_group_id%TYPE,
2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
2617: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
2618: x_return_status OUT NOCOPY VARCHAR2,
2619: x_return_message OUT NOCOPY VARCHAR2

Line 2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',

2612: p_grant_name IN igs_sc_grants.grant_name%TYPE,
2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
2617: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
2618: x_return_status OUT NOCOPY VARCHAR2,
2619: x_return_message OUT NOCOPY VARCHAR2
2620: ) IS

Line 2617: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',

2613: p_grant_text IN igs_sc_grants.grant_text%TYPE,
2614: p_grant_select_flag IN igs_sc_grants.grant_select_flag%TYPE DEFAULT 'N',
2615: p_grant_insert_flag IN igs_sc_grants.grant_insert_flag%TYPE DEFAULT 'N',
2616: p_grant_update_flag IN igs_sc_grants.grant_update_flag%TYPE DEFAULT 'N',
2617: p_grant_delete_flag IN igs_sc_grants.grant_delete_flag%TYPE DEFAULT 'N',
2618: x_return_status OUT NOCOPY VARCHAR2,
2619: x_return_message OUT NOCOPY VARCHAR2
2620: ) IS
2621:

Line 2631: l_grant_name igs_sc_grants.grant_name%TYPE;

2627: l_api_version CONSTANT NUMBER := 1.0;
2628: l_return_message VARCHAR2(2000);
2629: l_message_count NUMBER(15);
2630: l_return_status VARCHAR2(30);
2631: l_grant_name igs_sc_grants.grant_name%TYPE;
2632: l_function_id igs_sc_grants.function_id%TYPE;
2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;

Line 2632: l_function_id igs_sc_grants.function_id%TYPE;

2628: l_return_message VARCHAR2(2000);
2629: l_message_count NUMBER(15);
2630: l_return_status VARCHAR2(30);
2631: l_grant_name igs_sc_grants.grant_name%TYPE;
2632: l_function_id igs_sc_grants.function_id%TYPE;
2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;

Line 2633: l_grant_text igs_sc_grants.grant_text%TYPE;

2629: l_message_count NUMBER(15);
2630: l_return_status VARCHAR2(30);
2631: l_grant_name igs_sc_grants.grant_name%TYPE;
2632: l_function_id igs_sc_grants.function_id%TYPE;
2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;

Line 2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;

2630: l_return_status VARCHAR2(30);
2631: l_grant_name igs_sc_grants.grant_name%TYPE;
2632: l_function_id igs_sc_grants.function_id%TYPE;
2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
2638: l_locked_flag igs_sc_grants.locked_flag%TYPE;

Line 2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;

2631: l_grant_name igs_sc_grants.grant_name%TYPE;
2632: l_function_id igs_sc_grants.function_id%TYPE;
2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
2638: l_locked_flag igs_sc_grants.locked_flag%TYPE;
2639:

Line 2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;

2632: l_function_id igs_sc_grants.function_id%TYPE;
2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
2638: l_locked_flag igs_sc_grants.locked_flag%TYPE;
2639:
2640: -- -----------------------------------------------------------------

Line 2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;

2633: l_grant_text igs_sc_grants.grant_text%TYPE;
2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
2638: l_locked_flag igs_sc_grants.locked_flag%TYPE;
2639:
2640: -- -----------------------------------------------------------------
2641: -- Define the cursors to be used in procedure.

Line 2638: l_locked_flag igs_sc_grants.locked_flag%TYPE;

2634: l_grant_select_flag igs_sc_grants.grant_select_flag%TYPE;
2635: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
2636: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
2637: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
2638: l_locked_flag igs_sc_grants.locked_flag%TYPE;
2639:
2640: -- -----------------------------------------------------------------
2641: -- Define the cursors to be used in procedure.
2642: -- -----------------------------------------------------------------

Line 2652: FROM igs_sc_grants

2648: grant_delete_flag,
2649: grant_update_flag,
2650: grant_insert_flag,
2651: locked_flag
2652: FROM igs_sc_grants
2653: WHERE grant_id = p_grant_id;
2654:
2655: BEGIN
2656:

Line 2759: UPDATE igs_sc_grants grts

2755:
2756: -- -----------------------------------------------------------------
2757: -- Update the existing record
2758: -- -----------------------------------------------------------------
2759: UPDATE igs_sc_grants grts
2760: SET grts.grant_name = p_grant_name,
2761: grts.grant_text = p_grant_text,
2762: grts.function_id = l_function_id,
2763: grts.user_group_id = p_user_group_id,

Line 2884: l_grant_name igs_sc_grants.grant_name%TYPE;

2880: l_message_count NUMBER(15);
2881: l_return_status VARCHAR2(30);
2882: l_obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE;
2883: l_user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE;
2884: l_grant_name igs_sc_grants.grant_name%TYPE;
2885: l_old_grant_cond_num NUMBER;
2886:
2887: -- -----------------------------------------------------------------
2888: -- Define the cursors to be used in procedure.

Line 2899: FROM igs_sc_grants grt

2895: AND cnds.grant_cond_num = p_grant_cond_num;
2896:
2897: CURSOR c_get_grant_name IS
2898: SELECT grt.grant_name
2899: FROM igs_sc_grants grt
2900: WHERE grt.grant_id = p_grant_id;
2901:
2902: BEGIN
2903:

Line 3110: l_grant_name igs_sc_grants.grant_name%TYPE;

3106: l_message_count NUMBER(15);
3107: l_return_status VARCHAR2(30);
3108: l_obj_group_name igs_sc_obj_groups.obj_group_name%TYPE;
3109: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;
3110: l_grant_name igs_sc_grants.grant_name%TYPE;
3111: l_grant_id igs_sc_grants.grant_id%TYPE;
3112:
3113: -- -----------------------------------------------------------------
3114: -- Define the cursors to be used in procedure.

Line 3111: l_grant_id igs_sc_grants.grant_id%TYPE;

3107: l_return_status VARCHAR2(30);
3108: l_obj_group_name igs_sc_obj_groups.obj_group_name%TYPE;
3109: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;
3110: l_grant_name igs_sc_grants.grant_name%TYPE;
3111: l_grant_id igs_sc_grants.grant_id%TYPE;
3112:
3113: -- -----------------------------------------------------------------
3114: -- Define the cursors to be used in procedure.
3115: -- -----------------------------------------------------------------

Line 3124: FROM igs_sc_grants grt

3120: WHERE grps.obj_group_id = p_obj_group_id;
3121:
3122: CURSOR c_get_grant_name IS
3123: SELECT grt.grant_name
3124: FROM igs_sc_grants grt
3125: WHERE grt.grant_id = l_grant_id;
3126:
3127: CURSOR c_get_grants IS
3128: SELECT grt.grant_id,

Line 3130: FROM igs_sc_grants grt

3126:
3127: CURSOR c_get_grants IS
3128: SELECT grt.grant_id,
3129: grt.grant_name
3130: FROM igs_sc_grants grt
3131: WHERE grt.obj_group_id = p_obj_group_id;
3132:
3133: BEGIN
3134:

Line 3208: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

3204:
3205: -- -----------------------------------------------------------------
3206: -- Update the object groups information for the group ID given.
3207: -- -----------------------------------------------------------------
3208: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
3209:
3210: UPDATE igs_sc_obj_groups objs
3211: SET objs.default_policy_type = l_default_policy_type,
3212: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

Line 3321: l_grant_id igs_sc_grants.grant_id%TYPE;

3317: l_return_status VARCHAR2(30);
3318: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;
3321: l_grant_id igs_sc_grants.grant_id%TYPE;
3322: l_grant_name igs_sc_grants.grant_name%TYPE;
3323: l_object_name fnd_objects.database_object_name%TYPE;
3324:
3325:

Line 3322: l_grant_name igs_sc_grants.grant_name%TYPE;

3318: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;
3321: l_grant_id igs_sc_grants.grant_id%TYPE;
3322: l_grant_name igs_sc_grants.grant_name%TYPE;
3323: l_object_name fnd_objects.database_object_name%TYPE;
3324:
3325:
3326: -- -----------------------------------------------------------------

Line 3341: igs_sc_grants grt

3337: CURSOR c_get_grant_info IS
3338: SELECT cond.grant_id,
3339: grt.grant_name
3340: FROM igs_sc_grant_conds cond,
3341: igs_sc_grants grt
3342: WHERE cond.obj_attrib_id = p_obj_attrib_id
3343: AND grt.grant_id = cond.grant_id;
3344:
3345: BEGIN

Line 3376: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

3372:
3373: -- -----------------------------------------------------------------
3374: -- Check if admin mode is enabled
3375: -- -----------------------------------------------------------------
3376: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
3377:
3378: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
3379: FND_MSG_PUB.Add;
3380: RAISE FND_API.G_EXC_ERROR;

Line 3598: l_grant_id igs_sc_grants.grant_id%TYPE;

3594: l_message_count NUMBER(15);
3595: l_return_status VARCHAR2(30);
3596: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;
3597: l_function_name igs_sc_obj_functns.function_name%TYPE;
3598: l_grant_id igs_sc_grants.grant_id%TYPE;
3599: l_grant_name igs_sc_grants.grant_name%TYPE;
3600:
3601: -- -----------------------------------------------------------------
3602: -- Define the cursors to be used in procedure.

Line 3599: l_grant_name igs_sc_grants.grant_name%TYPE;

3595: l_return_status VARCHAR2(30);
3596: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;
3597: l_function_name igs_sc_obj_functns.function_name%TYPE;
3598: l_grant_id igs_sc_grants.grant_id%TYPE;
3599: l_grant_name igs_sc_grants.grant_name%TYPE;
3600:
3601: -- -----------------------------------------------------------------
3602: -- Define the cursors to be used in procedure.
3603: -- -----------------------------------------------------------------

Line 3613: FROM igs_sc_grants grt

3609:
3610: CURSOR c_get_grants IS
3611: SELECT grt.grant_id,
3612: grt.grant_name
3613: FROM igs_sc_grants grt
3614: WHERE grt.function_id = p_function_id;
3615:
3616: BEGIN
3617:

Line 3646: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

3642:
3643: -- -----------------------------------------------------------------
3644: -- Check if admin mode is enabled
3645: -- -----------------------------------------------------------------
3646: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
3647:
3648: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
3649: FND_MSG_PUB.Add;
3650: RAISE FND_API.G_EXC_ERROR;

Line 3793: l_grant_name igs_sc_grants.grant_name%TYPE;

3789: l_return_status VARCHAR2(30);
3790: l_obj_group_id igs_sc_obj_attribs.obj_group_id%TYPE;
3791: l_obj_attrib_name igs_sc_obj_attribs.obj_attrib_name%TYPE;
3792: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
3793: l_grant_name igs_sc_grants.grant_name%TYPE;
3794:
3795: -- -----------------------------------------------------------------
3796: -- Define the cursors to be used in procedure.
3797: -- -----------------------------------------------------------------

Line 3808: igs_sc_grants grt

3804: CURSOR c_get_grant_info IS
3805: SELECT cond.grant_id,
3806: grt.grant_name
3807: FROM igs_sc_grant_conds cond,
3808: igs_sc_grants grt
3809: WHERE cond.obj_attrib_id = p_obj_attrib_id
3810: AND grt.grant_id = cond.grant_id;
3811:
3812: BEGIN

Line 3842: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

3838:
3839: -- -----------------------------------------------------------------
3840: -- Check if admin mode is enabled
3841: -- -----------------------------------------------------------------
3842: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
3843:
3844: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
3845: FND_MSG_PUB.Add;
3846: RAISE FND_API.G_EXC_ERROR;

Line 4005: l_grant_name igs_sc_grants.grant_name%TYPE;

4001: l_user_attrib_name igs_sc_usr_attribs.user_attrib_name%TYPE;
4002: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;
4003: l_static_type igs_sc_usr_attribs.static_type%TYPE;
4004: l_select_text igs_sc_usr_attribs.select_text%TYPE;
4005: l_grant_name igs_sc_grants.grant_name%TYPE;
4006: l_grant_id igs_sc_grants.grant_id%TYPE;
4007:
4008: -- -----------------------------------------------------------------
4009: -- Define the cursors to be used in procedure.

Line 4006: l_grant_id igs_sc_grants.grant_id%TYPE;

4002: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;
4003: l_static_type igs_sc_usr_attribs.static_type%TYPE;
4004: l_select_text igs_sc_usr_attribs.select_text%TYPE;
4005: l_grant_name igs_sc_grants.grant_name%TYPE;
4006: l_grant_id igs_sc_grants.grant_id%TYPE;
4007:
4008: -- -----------------------------------------------------------------
4009: -- Define the cursors to be used in procedure.
4010: -- -----------------------------------------------------------------

Line 4023: igs_sc_grants grt

4019: CURSOR c_get_grant_info IS
4020: SELECT cond.grant_id,
4021: grt.grant_name
4022: FROM igs_sc_grant_conds cond,
4023: igs_sc_grants grt
4024: WHERE cond.user_attrib_id = p_user_attrib_id
4025: AND grt.grant_id = cond.grant_id;
4026:
4027: BEGIN

Line 4058: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

4054:
4055: -- -----------------------------------------------------------------
4056: -- Check if admin mode is enabled
4057: -- -----------------------------------------------------------------
4058: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
4059:
4060: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
4061: FND_MSG_PUB.Add;
4062: RAISE FND_API.G_EXC_ERROR;

Line 4176: IGS_SC_GRANTS_PVT.POPULATE_USER_ATTRIB (

4172: WHERE attr.user_attrib_id = p_user_attrib_id;
4173:
4174: IF l_static_type IN ('C','S') AND (p_active_flag = 'Y') THEN
4175:
4176: IGS_SC_GRANTS_PVT.POPULATE_USER_ATTRIB (
4177: P_API_VERSION => 1.0,
4178: P_ATTRIB_ID => p_user_attrib_id,
4179: P_USER_ID => NULL,
4180: P_ALL_ATTRIBS => 'Y',

Line 4294: l_grant_id igs_sc_grants.grant_id%TYPE;

4290: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Object_Group';
4291: l_api_version CONSTANT NUMBER := 1.0;
4292: l_object_id igs_sc_objects.object_id%TYPE;
4293: l_function_id igs_sc_obj_functns.function_id%TYPE;
4294: l_grant_id igs_sc_grants.grant_id%TYPE;
4295: l_obj_attrib_id igs_sc_obj_attribs.obj_attrib_id%TYPE;
4296: l_return_message VARCHAR2(2000);
4297: l_message_count NUMBER(15);
4298: l_return_status VARCHAR2(30);

Line 4315: FROM igs_sc_grants grts

4311: WHERE funcs.obj_group_id = p_obj_group_id;
4312:
4313: CURSOR c_get_grant_id IS
4314: SELECT grts.grant_id
4315: FROM igs_sc_grants grts
4316: WHERE grts.obj_group_id = p_obj_group_id;
4317:
4318: CURSOR c_get_obj_attr_id IS
4319: SELECT attrs.obj_attrib_id

Line 4353: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

4349:
4350: -- -----------------------------------------------------------------
4351: -- Check if admin mode is enabled
4352: -- -----------------------------------------------------------------
4353: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
4354:
4355: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
4356: FND_MSG_PUB.Add;
4357: RAISE FND_API.G_EXC_ERROR;

Line 4638: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

4634:
4635: -- -----------------------------------------------------------------
4636: -- Check if admin mode is enabled
4637: -- -----------------------------------------------------------------
4638: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
4639:
4640: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
4641: FND_MSG_PUB.Add;
4642: RAISE FND_API.G_EXC_ERROR;

Line 4835: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

4831: x_return_status := FND_API.G_RET_STS_SUCCESS;
4832: -- -----------------------------------------------------------------
4833: -- Check if admin mode is enabled
4834: -- -----------------------------------------------------------------
4835: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
4836:
4837: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
4838: FND_MSG_PUB.Add;
4839: RAISE FND_API.G_EXC_ERROR;

Line 4923: l_grant_id igs_sc_grants.grant_id%TYPE;

4919: -- Define local variables to be used.
4920: -- -----------------------------------------------------------------
4921: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Object_Func';
4922: l_api_version CONSTANT NUMBER := 1.0;
4923: l_grant_id igs_sc_grants.grant_id%TYPE;
4924: l_return_message VARCHAR2(2000);
4925: l_message_count NUMBER(15);
4926: l_return_status VARCHAR2(30);
4927:

Line 4933: FROM igs_sc_grants grt,

4929: -- Define the cursors to be used in procedure.
4930: -- -----------------------------------------------------------------
4931: CURSOR c_get_grant_id IS
4932: SELECT grt.grant_id
4933: FROM igs_sc_grants grt,
4934: igs_sc_obj_functns fnc
4935: WHERE fnc.function_id = p_function_id
4936: AND grt.function_id = fnc.function_id
4937: AND grt.obj_group_id = fnc.obj_group_id;

Line 4969: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

4965:
4966: -- -----------------------------------------------------------------
4967: -- Check if admin mode is enabled
4968: -- -----------------------------------------------------------------
4969: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
4970:
4971: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
4972: FND_MSG_PUB.Add;
4973: RAISE FND_API.G_EXC_ERROR;

Line 5125: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

5121:
5122: -- -----------------------------------------------------------------
5123: -- Check if admin mode is enabled
5124: -- -----------------------------------------------------------------
5125: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
5126:
5127: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
5128: FND_MSG_PUB.Add;
5129: RAISE FND_API.G_EXC_ERROR;

Line 5250: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

5246:
5247: -- -----------------------------------------------------------------
5248: -- Check if admin mode is enabled
5249: -- -----------------------------------------------------------------
5250: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
5251:
5252: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
5253: FND_MSG_PUB.Add;
5254: RAISE FND_API.G_EXC_ERROR;

Line 5349: l_grant_name igs_sc_grants.grant_name%TYPE;

5345: l_api_version CONSTANT NUMBER := 1.0;
5346: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
5347: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
5348: l_user_id igs_sc_usr_att_vals.user_id%TYPE;
5349: l_grant_name igs_sc_grants.grant_name%TYPE;
5350: l_return_message VARCHAR2(2000);
5351: l_message_count NUMBER(15);
5352: l_return_status VARCHAR2(30);
5353:

Line 5362: igs_sc_grants gnt

5358: SELECT grts.grant_id,
5359: grts.grant_cond_num,
5360: gnt.grant_name
5361: FROM igs_sc_grant_conds grts,
5362: igs_sc_grants gnt
5363: WHERE grts.user_attrib_id = p_user_attrib_id
5364: AND gnt.grant_id = grts.grant_id;
5365:
5366: CURSOR c_get_user_id IS

Line 5401: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

5397:
5398: -- -----------------------------------------------------------------
5399: -- Check if admin mode is enabled
5400: -- -----------------------------------------------------------------
5401: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
5402:
5403: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
5404: FND_MSG_PUB.Add;
5405: RAISE FND_API.G_EXC_ERROR;

Line 5647: p_grant_id IN igs_sc_grants.grant_id%TYPE,

5643: ******************************************************************/
5644: PROCEDURE Delete_Grant (p_api_version IN NUMBER,
5645: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5646: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5647: p_grant_id IN igs_sc_grants.grant_id%TYPE,
5648: x_return_status OUT NOCOPY VARCHAR2,
5649: x_return_message OUT NOCOPY VARCHAR2
5650: ) IS
5651:

Line 5659: l_grant_name igs_sc_grants.grant_name%TYPE;

5655: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Grant';
5656: l_delete_oper CONSTANT VARCHAR2(30) := 'DELETE';
5657: l_api_version CONSTANT NUMBER := 1.0;
5658: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
5659: l_grant_name igs_sc_grants.grant_name%TYPE;
5660: l_return_message VARCHAR2(2000);
5661: l_message_count NUMBER(15);
5662: l_return_status VARCHAR2(30);
5663:

Line 5674: FROM igs_sc_grants grts

5670: WHERE grts.grant_id = p_grant_id;
5671:
5672: CURSOR c_get_grant_name IS
5673: SELECT grts.grant_name
5674: FROM igs_sc_grants grts
5675: WHERE grts.grant_id = p_grant_id;
5676:
5677: BEGIN
5678:

Line 5748: FROM igs_sc_grants grts

5744: -- -----------------------------------------------------------------
5745: -- Delete the grant that has been requested for deletion.
5746: -- -----------------------------------------------------------------
5747: DELETE
5748: FROM igs_sc_grants grts
5749: WHERE grts.grant_id = p_grant_id;
5750:
5751: ELSE
5752:

Line 5879: l_grant_name igs_sc_grants.grant_name%TYPE;

5875: -- -----------------------------------------------------------------
5876: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Grant_Cond';
5877: l_delete_oper CONSTANT VARCHAR2(30) := 'DELETE';
5878: l_api_version CONSTANT NUMBER := 1.0;
5879: l_grant_name igs_sc_grants.grant_name%TYPE;
5880: l_return_message VARCHAR2(2000);
5881: l_message_count NUMBER(15);
5882: l_return_status VARCHAR2(30);
5883:

Line 5889: FROM igs_sc_grants grts

5885: -- Define the cursors to be used in procedure.
5886: -- -----------------------------------------------------------------
5887: CURSOR c_get_grant_name IS
5888: SELECT grts.grant_name
5889: FROM igs_sc_grants grts
5890: WHERE grts.grant_id = p_grant_id;
5891:
5892: BEGIN
5893:

Line 6236: p_grant_id IN igs_sc_grants.grant_id%TYPE

6232: Don Shellito April 23, 2003 New Procedure Created.
6233:
6234: ******************************************************************/
6235: FUNCTION Is_Grant_Locked (
6236: p_grant_id IN igs_sc_grants.grant_id%TYPE
6237: ) RETURN VARCHAR2 AS
6238:
6239: -- -----------------------------------------------------------------
6240: -- Define local variables to be used.

Line 6244: l_lock_flag igs_sc_grants.locked_flag%TYPE;

6240: -- Define local variables to be used.
6241: -- -----------------------------------------------------------------
6242: l_api_name CONSTANT VARCHAR2(30) := 'Is_Grant_Locked';
6243: l_api_version CONSTANT NUMBER := 1.0;
6244: l_lock_flag igs_sc_grants.locked_flag%TYPE;
6245: l_return_message VARCHAR2(2000);
6246: l_message_count NUMBER(15);
6247: l_return_status VARCHAR2(30);
6248:

Line 6254: FROM igs_sc_grants grnt

6250: -- Define the cursors to be used in procedure.
6251: -- -----------------------------------------------------------------
6252: CURSOR c_get_lock_flag IS
6253: SELECT grnt.locked_flag
6254: FROM igs_sc_grants grnt
6255: WHERE grnt.grant_id = p_grant_id;
6256:
6257: BEGIN
6258:

Line 6311: p_grant_id IN igs_sc_grants.grant_id%TYPE,

6307: ******************************************************************/
6308: PROCEDURE Lock_Grant (p_api_version IN NUMBER,
6309: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6310: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6311: p_grant_id IN igs_sc_grants.grant_id%TYPE,
6312: x_return_status OUT NOCOPY VARCHAR2,
6313: x_return_message OUT NOCOPY VARCHAR2
6314: ) IS
6315:

Line 6321: l_grant_id igs_sc_grants.grant_id%TYPE;

6317: -- Define local variables to be used.
6318: -- -----------------------------------------------------------------
6319: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Grant';
6320: l_api_version CONSTANT NUMBER := 1.0;
6321: l_grant_id igs_sc_grants.grant_id%TYPE;
6322: l_return_message VARCHAR2(2000);
6323: l_message_count NUMBER(15);
6324: l_return_status VARCHAR2(30);
6325:

Line 6331: FROM igs_sc_grants grts

6327: -- Define the cursors to be used in procedure.
6328: -- -----------------------------------------------------------------
6329: CURSOR c_check_grant IS
6330: SELECT grts.grant_id
6331: FROM igs_sc_grants grts
6332: WHERE grts.grant_id = p_grant_id;
6333:
6334: BEGIN
6335:

Line 6384: IGS_SC_GRANTS_PVT.construct_grant(

6380:
6381: ELSE
6382:
6383: -- Generate grant for objects
6384: IGS_SC_GRANTS_PVT.construct_grant(
6385: p_api_version => 1.0,
6386: p_init_msg_list => FND_API.G_FALSE,
6387: p_commit => FND_API.G_FALSE,
6388: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 6398: UPDATE igs_sc_grants grts

6394: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6395: raise FND_API.G_EXC_ERROR;
6396: END IF;
6397:
6398: UPDATE igs_sc_grants grts
6399: SET grts.locked_flag = 'Y'
6400: WHERE grts.grant_id = p_grant_id;
6401:
6402: END IF;

Line 6490: p_grant_id IN igs_sc_grants.grant_id%TYPE,

6486: ******************************************************************/
6487: PROCEDURE Unlock_Grant (p_api_version IN NUMBER,
6488: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6489: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6490: p_grant_id IN igs_sc_grants.grant_id%TYPE,
6491: x_return_status OUT NOCOPY VARCHAR2,
6492: x_return_message OUT NOCOPY VARCHAR2
6493: ) IS
6494:

Line 6500: l_grant_id igs_sc_grants.grant_id%TYPE;

6496: -- Define local variables to be used.
6497: -- -----------------------------------------------------------------
6498: l_api_name CONSTANT VARCHAR2(30) := 'Unlock_Grant';
6499: l_api_version CONSTANT NUMBER := 1.0;
6500: l_grant_id igs_sc_grants.grant_id%TYPE;
6501: l_return_message VARCHAR2(2000);
6502: l_message_count NUMBER(15);
6503: l_return_status VARCHAR2(30);
6504: l_locked_flag_value VARCHAR2(1) := 'N';

Line 6511: FROM igs_sc_grants grts

6507: -- Define the cursors to be used in procedure.
6508: -- -----------------------------------------------------------------
6509: CURSOR c_check_grant IS
6510: SELECT grts.grant_id
6511: FROM igs_sc_grants grts
6512: WHERE grts.grant_id = p_grant_id;
6513:
6514: BEGIN
6515:

Line 6567: UPDATE igs_sc_grants grts

6563: DELETE
6564: FROM igs_sc_obj_grants objs
6565: WHERE objs.grant_id = p_grant_id;
6566:
6567: UPDATE igs_sc_grants grts
6568: SET grts.locked_flag = l_locked_flag_value
6569: WHERE grts.grant_id = p_grant_id;
6570:
6571: END IF;

Line 6994: l_grant_id igs_sc_grants.grant_id%TYPE;

6990: -- -----------------------------------------------------------------
6991: -- Define local variables to be used.
6992: -- -----------------------------------------------------------------
6993: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Grant_ID';
6994: l_grant_id igs_sc_grants.grant_id%TYPE;
6995:
6996: -- -----------------------------------------------------------------
6997: -- Define the cursors to be used in procedure.
6998: -- -----------------------------------------------------------------

Line 7001: FROM igs_sc_grants grt

6997: -- Define the cursors to be used in procedure.
6998: -- -----------------------------------------------------------------
6999: CURSOR c_check_grant_id IS
7000: SELECT grt.grant_id
7001: FROM igs_sc_grants grt
7002: WHERE grt.grant_id = p_grant_id;
7003:
7004: BEGIN
7005:

Line 7360: IGS_SC_GRANTS_PVT.unlock_all_grants(

7356: END IF;
7357: -- Just call the procedure
7358: SAVEPOINT Unlock_All_Grants;
7359:
7360: IGS_SC_GRANTS_PVT.unlock_all_grants(
7361: p_api_version => 1.0 ,
7362: x_return_status => l_return_status,
7363: x_msg_count => l_msg_count,
7364: x_msg_data => l_msg_data,

Line 7419: IGS_SC_GRANTS_PVT.lock_all_grants(

7415:
7416: -- Just call the procedure
7417: SAVEPOINT Lock_All_Grants;
7418:
7419: IGS_SC_GRANTS_PVT.lock_all_grants(
7420: p_api_version => 1.0 ,
7421: x_return_status => l_return_status,
7422: x_msg_count => l_msg_count,
7423: x_msg_data => l_msg_data,

Line 7472: IGS_SC_GRANTS_PVT.populate_user_attrib(

7468:
7469: -- Just call the procedure
7470: SAVEPOINT Unlock_All_Grants;
7471:
7472: IGS_SC_GRANTS_PVT.populate_user_attrib(
7473: p_api_version => 1.0 ,
7474: x_return_status => l_return_status,
7475: x_msg_count => l_msg_count,
7476: x_msg_data => l_msg_data,

Line 7638: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','insert';

7634: statement_types => :6,
7635: update_check => TRUE,
7636: long_predicate => TRUE); END;';
7637: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PI',
7638: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','insert';
7639: ELSE
7640: dbms_rls.add_policy (
7641: object_schema => l_owner,
7642: object_name => p_database_object_name,

Line 7645: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',

7641: object_schema => l_owner,
7642: object_name => p_database_object_name,
7643: policy_name => p_database_object_name||'_PI',
7644: function_schema => l_apps_schema,
7645: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',
7646: statement_types => 'insert',
7647: update_check => TRUE );
7648: END IF;
7649: ELSE

Line 7661: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.INSERT_ROW','insert';

7657: statement_types => :6,
7658: update_check => TRUE,
7659: long_predicate => TRUE); END;';
7660: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PI',
7661: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.INSERT_ROW','insert';
7662: ELSE
7663: dbms_rls.add_policy (object_schema => l_owner,
7664: object_name => p_database_object_name,
7665: policy_name => p_database_object_name||'_PI',

Line 7667: policy_function => 'IGS_SC_GRANTS_TBL_PVT.INSERT_ROW',

7663: dbms_rls.add_policy (object_schema => l_owner,
7664: object_name => p_database_object_name,
7665: policy_name => p_database_object_name||'_PI',
7666: function_schema => l_apps_schema,
7667: policy_function => 'IGS_SC_GRANTS_TBL_PVT.INSERT_ROW',
7668: statement_types => 'insert',
7669: update_check => TRUE );
7670: END IF;
7671: END IF;

Line 7685: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','update';

7681: statement_types => :6,
7682: update_check => TRUE,
7683: long_predicate => TRUE); END;';
7684: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PU',
7685: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','update';
7686: ELSE
7687: dbms_rls.add_policy (object_schema => l_owner,
7688: object_name => p_database_object_name,
7689: policy_name => p_database_object_name||'_PU',

Line 7691: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',

7687: dbms_rls.add_policy (object_schema => l_owner,
7688: object_name => p_database_object_name,
7689: policy_name => p_database_object_name||'_PU',
7690: function_schema => l_apps_schema,
7691: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',
7692: statement_types => 'update',
7693: update_check => TRUE );
7694: END IF;
7695: END IF;

Line 7708: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.SELECT_ROW','select';

7704: statement_types => :6,
7705: update_check => TRUE,
7706: long_predicate => TRUE); END;';
7707: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PS',
7708: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.SELECT_ROW','select';
7709: ELSE
7710: dbms_rls.add_policy (object_schema => l_owner,
7711: object_name => p_database_object_name,
7712: policy_name => p_database_object_name||'_PS',

Line 7714: policy_function => 'IGS_SC_GRANTS_TBL_PVT.SELECT_ROW',

7710: dbms_rls.add_policy (object_schema => l_owner,
7711: object_name => p_database_object_name,
7712: policy_name => p_database_object_name||'_PS',
7713: function_schema => l_apps_schema,
7714: policy_function => 'IGS_SC_GRANTS_TBL_PVT.SELECT_ROW',
7715: statement_types => 'select',
7716: update_check => TRUE );
7717: END IF;
7718: END IF;

Line 7732: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','delete';

7728: statement_types => :6,
7729: update_check => TRUE,
7730: long_predicate => TRUE); END;';
7731: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PD',
7732: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW','delete';
7733: ELSE
7734: dbms_rls.add_policy (object_schema => l_owner,
7735: object_name => p_database_object_name,
7736: policy_name => p_database_object_name||'_PD',

Line 7738: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',

7734: dbms_rls.add_policy (object_schema => l_owner,
7735: object_name => p_database_object_name,
7736: policy_name => p_database_object_name||'_PD',
7737: function_schema => l_apps_schema,
7738: policy_function => 'IGS_SC_GRANTS_TBL_PVT.UPDATE_ROW',
7739: statement_types => 'delete',
7740: update_check => TRUE );
7741: END IF;
7742: ELSE

Line 7754: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.DELETE_ROW','delete';

7750: statement_types => :6,
7751: update_check => TRUE,
7752: long_predicate => TRUE); END;';
7753: EXECUTE IMMEDIATE(l_stmt) using l_owner, p_database_object_name, p_database_object_name||'_PD',
7754: l_apps_schema,'IGS_SC_GRANTS_TBL_PVT.DELETE_ROW','delete';
7755: ELSE
7756: dbms_rls.add_policy (object_schema => l_owner,
7757: object_name => p_database_object_name,
7758: policy_name => p_database_object_name||'_PD',

Line 7760: policy_function => 'IGS_SC_GRANTS_TBL_PVT.DELETE_ROW',

7756: dbms_rls.add_policy (object_schema => l_owner,
7757: object_name => p_database_object_name,
7758: policy_name => p_database_object_name||'_PD',
7759: function_schema => l_apps_schema,
7760: policy_function => 'IGS_SC_GRANTS_TBL_PVT.DELETE_ROW',
7761: statement_types => 'delete',
7762: update_check => TRUE );
7763: END IF;
7764: END IF;

Line 7803: IGS_SC_GRANTS grant_id,user_group_id,obj_group_id ,function_id

7799: IGS_SC_OBJ_ATT_VALS object_id,obj_attrib_id
7800:
7801: IGS_SC_OBJ_GRANTS grant_id,object_id
7802:
7803: IGS_SC_GRANTS grant_id,user_group_id,obj_group_id ,function_id
7804:
7805: IGS_SC_GRANT_CONDS grant_id,obj_attrib_id,user_attrib_id
7806:
7807: */

Line 7810: CURSOR igs_sc_grants_c IS

7806:
7807: */
7808: PROCEDURE change_seq IS
7809:
7810: CURSOR igs_sc_grants_c IS
7811: SELECT grant_id
7812: FROM igs_sc_grants
7813: ORDER BY grant_id
7814: FOR UPDATE OF grant_id;

Line 7812: FROM igs_sc_grants

7808: PROCEDURE change_seq IS
7809:
7810: CURSOR igs_sc_grants_c IS
7811: SELECT grant_id
7812: FROM igs_sc_grants
7813: ORDER BY grant_id
7814: FOR UPDATE OF grant_id;
7815:
7816: CURSOR igs_sc_usr_attribs_c IS

Line 7847: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN

7843:
7844: -- -----------------------------------------------------------------
7845: -- Check if admin mode is enabled
7846: -- -----------------------------------------------------------------
7847: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
7848:
7849: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_ADMIN_MODE_OFF');
7850: FND_MSG_PUB.Add;
7851: RAISE FND_API.G_EXC_ERROR;

Line 7859: FOR igs_sc_grants_rec IN igs_sc_grants_c LOOP

7855: -- UPDATE GRANTS
7856:
7857: l_current_seq := 1;
7858:
7859: FOR igs_sc_grants_rec IN igs_sc_grants_c LOOP
7860:
7861: IF igs_sc_grants_rec.grant_id <> l_current_seq THEN
7862:
7863: -- Update all tables

Line 7861: IF igs_sc_grants_rec.grant_id <> l_current_seq THEN

7857: l_current_seq := 1;
7858:
7859: FOR igs_sc_grants_rec IN igs_sc_grants_c LOOP
7860:
7861: IF igs_sc_grants_rec.grant_id <> l_current_seq THEN
7862:
7863: -- Update all tables
7864: UPDATE IGS_SC_OBJ_GRANTS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7865:

Line 7864: UPDATE IGS_SC_OBJ_GRANTS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;

7860:
7861: IF igs_sc_grants_rec.grant_id <> l_current_seq THEN
7862:
7863: -- Update all tables
7864: UPDATE IGS_SC_OBJ_GRANTS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7865:
7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7867:
7868: -- Update table itself

Line 7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;

7862:
7863: -- Update all tables
7864: UPDATE IGS_SC_OBJ_GRANTS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7865:
7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7867:
7868: -- Update table itself
7869: UPDATE igs_sc_grants SET grant_id = l_current_seq WHERE CURRENT OF igs_sc_grants_c;
7870:

Line 7869: UPDATE igs_sc_grants SET grant_id = l_current_seq WHERE CURRENT OF igs_sc_grants_c;

7865:
7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7867:
7868: -- Update table itself
7869: UPDATE igs_sc_grants SET grant_id = l_current_seq WHERE CURRENT OF igs_sc_grants_c;
7870:
7871: END IF;
7872:
7873: l_current_seq := l_current_seq +1;

Line 7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7914:
7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7916:
7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7918:
7919: -- Update table itself
7920: UPDATE igs_sc_obj_groups SET obj_group_id = l_current_seq WHERE CURRENT OF igs_sc_obj_groups_c;
7921:

Line 7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;

7934: IF igs_sc_obj_functns_rec.function_id <> l_current_seq THEN
7935:
7936: -- Update all tables
7937:
7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;
7939:
7940: -- Update table itself
7941: UPDATE igs_sc_obj_functns SET function_id = l_current_seq WHERE CURRENT OF igs_sc_obj_functns_c;
7942:

Line 8019: IGS_SC_GRANTS_PVT.unlock_all_grants(

8015: -- API body
8016: -- Unlock all grants.
8017: IF p_obj_group_id <> -1 THEN
8018: -- Unlock Grants for the object group ID
8019: IGS_SC_GRANTS_PVT.unlock_all_grants(
8020: p_api_version => 1.0 ,
8021: x_return_status => l_return_status,
8022: x_msg_count => l_msg_count,
8023: x_msg_data => l_msg_data,

Line 8032: IGS_SC_GRANTS_PVT.unlock_all_grants(

8028: raise FND_API.G_EXC_ERROR;
8029: END IF;
8030: ELSE
8031: -- Unlock all grants i.e disable security
8032: IGS_SC_GRANTS_PVT.unlock_all_grants(
8033: p_api_version => 1.0 ,
8034: x_return_status => l_return_status,
8035: x_msg_count => l_msg_count,
8036: x_msg_data => l_msg_data,