DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_GRANTS_PVT

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 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 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 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 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 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 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 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 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 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 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 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 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 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,