DBA Data[Home] [Help]

APPS.IBE_MSITE_GRP dependencies on IBE_MSITE_PRTY_ACCSS

Line 1042: FROM ibe_msite_prty_accss

1038: ORDER BY MR.msite_resp_id, MR.group_code;
1039:
1040: CURSOR c_get_msite_access_csr(c_msite_id NUMBER) IS
1041: SELECT party_id, start_date_active, end_date_active
1042: FROM ibe_msite_prty_accss
1043: WHERE msite_id = c_msite_id;
1044: BEGIN
1045: SAVEPOINT DUPLICATE_MSITE_SAVE;
1046: l_api_name:= 'duplicate_msite';

Line 1438: Ibe_Msite_Prty_Accss_Mgr_Pvt.Associate_Parties_To_MSite(

1434: l_i := l_i + 1;
1435: END LOOP;
1436: CLOSE c_get_msite_access_csr;
1437: IF (l_i > 1) THEN
1438: Ibe_Msite_Prty_Accss_Mgr_Pvt.Associate_Parties_To_MSite(
1439: p_api_version => 1.0,
1440: p_init_msg_list => FND_API.G_FALSE,
1441: p_commit => p_commit,
1442: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2304: delete from ibe_msite_prty_accss

2300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2301: END IF;
2302: End Loop;
2303:
2304: delete from ibe_msite_prty_accss
2305: where msite_id = p_msite_id_tbl(l_index).msite_id;
2306:
2307: delete from ibe_wf_notif_msg_maps
2308: where msite_id = p_msite_id_tbl(l_index).msite_id;