DBA Data[Home] [Help]

APPS.OZF_FUNDS_PVT dependencies on AMS_ACCESS_PVT

Line 373: l_access_rec ams_access_pvt.access_rec_type;

369: l_approver_id NUMBER;
370: l_is_requester_owner VARCHAR2(10);
371: -- l_request_rec ozf_fund_request_pvt.request_rec_type;
372: -- variable for creating access //mpande
373: l_access_rec ams_access_pvt.access_rec_type;
374: l_access_id NUMBER;
375: l_par_fund_owner NUMBER;
376: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
377: -- record and table variable for creating FC record // mpande

Line 1023: ams_access_pvt.create_access(

1019: l_access_rec.user_or_role_id := l_fund_rec.owner;
1020: l_access_rec.arc_user_or_role_type := 'USER';
1021: l_access_rec.admin_flag := 'Y';
1022: l_access_rec.owner_flag := 'Y';
1023: ams_access_pvt.create_access(
1024: p_api_version => l_api_version
1025: ,p_init_msg_list => fnd_api.g_false
1026: ,p_validation_level => p_validation_level
1027: ,x_return_status => l_return_status

Line 1074: ams_access_pvt.create_access(

1070: l_access_rec.user_or_role_id := l_par_fund_owner;
1071: l_access_rec.arc_user_or_role_type := 'USER';
1072: l_access_rec.admin_flag := 'Y'; -- 12/03/2001 yzhao: give admin access to parent
1073: l_access_rec.owner_flag := 'N';
1074: ams_access_pvt.create_access(
1075: p_api_version => l_api_version
1076: ,p_init_msg_list => fnd_api.g_false
1077: ,p_validation_level => p_validation_level
1078: ,x_return_status => l_return_status

Line 1509: l_access_rec ams_access_pvt.access_rec_type;

1505: l_mc_record_id NUMBER;
1506: l_mc_transaction_rec ozf_mc_transactions_pvt.mc_transactions_rec_type;
1507: */
1508: --- variable for creating access //mpande
1509: l_access_rec ams_access_pvt.access_rec_type;
1510: l_access_id NUMBER;
1511: l_act_access_id NUMBER;
1512: l_acc_obj_ver_num NUMBER;
1513: l_par_fund_owner NUMBER;

Line 3118: ams_access_pvt.init_access_rec(l_access_rec);

3114: /* commented by feliu on 05/13/2003 to fix bug 2969498;
3115: OPEN c_access(p_fund_rec.fund_id);
3116: FETCH c_access INTO l_act_access_id, l_acc_obj_ver_num;
3117: CLOSE c_access;
3118: ams_access_pvt.init_access_rec(l_access_rec);
3119: l_access_rec.activity_access_id := l_act_access_id;
3120: l_access_rec.object_version_number := l_acc_obj_ver_num;
3121: l_access_rec.act_access_to_object_id := l_fund_rec.fund_id;
3122: l_access_rec.arc_act_access_to_object := 'FUND';

Line 3127: ams_access_pvt.update_access(

3123: l_access_rec.user_or_role_id := l_fund_rec.owner;
3124: l_access_rec.arc_user_or_role_type := 'USER';
3125: l_access_rec.admin_flag := 'Y';
3126: l_access_rec.owner_flag := 'Y';
3127: ams_access_pvt.update_access(
3128: p_api_version => l_api_version
3129: ,p_init_msg_list => fnd_api.g_false
3130: ,p_validation_level => p_validation_level
3131: ,x_return_status => l_return_status

Line 3138: AMS_Access_PVT.update_object_owner

3134: ,p_commit => fnd_api.g_false
3135: ,p_access_rec => l_access_rec);
3136: */
3137:
3138: AMS_Access_PVT.update_object_owner
3139: ( p_api_version => 1.0
3140: ,p_init_msg_list => FND_API.G_FALSE
3141: ,p_commit => FND_API.G_FALSE
3142: ,p_validation_level => p_validation_level

Line 4251: ozf_utility_pvt.debug_message('resource'||ams_access_pvt.check_update_access(p_complete_rec.fund_id, 'FUND', l_resource_id, 'USER'));

4247: -- mpande added on Sep 11 for giving update access to owner and persons who have access with edit metric flag = 'Y'
4248: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);
4249:
4250: IF G_DEBUG THEN
4251: ozf_utility_pvt.debug_message('resource'||ams_access_pvt.check_update_access(p_complete_rec.fund_id, 'FUND', l_resource_id, 'USER'));
4252: END IF;
4253:
4254: IF l_resource_id <> -1 THEN
4255: IF ams_access_pvt.check_update_access(

Line 4255: IF ams_access_pvt.check_update_access(

4251: ozf_utility_pvt.debug_message('resource'||ams_access_pvt.check_update_access(p_complete_rec.fund_id, 'FUND', l_resource_id, 'USER'));
4252: END IF;
4253:
4254: IF l_resource_id <> -1 THEN
4255: IF ams_access_pvt.check_update_access(
4256: p_complete_rec.fund_id
4257: ,'FUND'
4258: ,l_resource_id
4259: ,'USER') <>

Line 5909: l_access_rec ams_access_pvt.access_rec_type;

5905: := 'update_funds_access';
5906: l_full_name CONSTANT VARCHAR2(60)
5907: := g_pkg_name || '.' || l_api_name;
5908:
5909: l_access_rec ams_access_pvt.access_rec_type;
5910: --l_fund_owner NUMBER;
5911: l_return_status VARCHAR2(1);
5912: l_access_id NUMBER;
5913: l_acc_obj_ver_num NUMBER;

Line 5986: ams_access_pvt.create_access(

5982: l_access_rec.user_or_role_id := fund.owner;
5983: l_access_rec.arc_user_or_role_type := 'USER';
5984: l_access_rec.admin_flag := 'Y';
5985: l_access_rec.owner_flag := 'Y';
5986: ams_access_pvt.create_access(
5987: p_api_version => l_api_version
5988: ,p_init_msg_list => fnd_api.g_false
5989: ,p_validation_level => p_validation_level
5990: ,x_return_status => l_return_status

Line 6013: ams_access_pvt.delete_access(

6009: l_access_rec.activity_access_id := l_access_id;
6010: l_access_rec.object_version_number := l_acc_obj_ver_num;
6011:
6012: IF fund.owner <>p_fund_rec.owner AND l_access_rec.activity_access_id is NOT NULL THEN
6013: ams_access_pvt.delete_access(
6014: p_api_version => l_api_version
6015: ,p_init_msg_list => fnd_api.g_false
6016: ,p_validation_level => p_validation_level
6017: ,x_return_status => l_return_status