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.AS_ACCESS_PVT dependencies on AS_ACCESS_PUB

Line 111: AS_ACCESS_PUB.Access_Profile_Rec_Type)

107: close get_person_id_csr;
108: end;
109:
110: procedure get_accessProfileValues(px_access_profile_rec in OUT NOCOPY
111: AS_ACCESS_PUB.Access_Profile_Rec_Type)
112:
113: is
114: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
115: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.get_accessProfileValues';

Line 177: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

173: procedure has_leadOwnerAccess
174: ( p_api_version_number IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
177: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
178: ,p_admin_flag IN VARCHAR2
179: ,p_admin_group_id IN NUMBER
180: ,p_person_id IN NUMBER
181: ,p_sales_lead_id IN NUMBER

Line 194: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

190: l_api_name CONSTANT VARCHAR2(30) := 'has_deleteLeadAccess';
191: l_api_version_number CONSTANT NUMBER := 2.0;
192: l_tmp varchar2(1);
193: l_person_id number;
194: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
195:
196: cursor resource_access_csr is
197: select 'X'
198: from as_accesses_all a

Line 482: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

478: procedure has_oppOwnerAccess
479: ( p_api_version_number IN NUMBER
480: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
481: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
482: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
483: ,p_admin_flag IN VARCHAR2
484: ,p_admin_group_id IN NUMBER
485: ,p_person_id IN NUMBER
486: ,p_lead_id IN NUMBER

Line 499: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

495: l_api_name CONSTANT VARCHAR2(30) := 'has_oppOwnerAccess';
496: l_api_version_number CONSTANT NUMBER := 2.0;
497: l_tmp varchar2(1);
498: l_person_id number;
499: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
500:
501: cursor resource_access_csr is
502: select 'X'
503: from as_accesses_all a

Line 1630: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,

1626: p_commit IN VARCHAR2
1627: := FND_API.G_FALSE,
1628: p_validation_level IN NUMBER
1629: := FND_API.G_VALID_LEVEL_FULL,
1630: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
1631: p_check_access_flag IN VARCHAR2,
1632: p_admin_flag IN VARCHAR2,
1633: p_admin_group_id IN NUMBER,
1634: p_identity_salesforce_id IN NUMBER,

Line 1790: AS_ACCESS_PUB.has_updateCustomerAccess

1786: then
1787: IF (p_sales_team_rec.lead_id is NULL or p_sales_team_rec.lead_id = FND_API.G_MISS_NUM)
1788: and (p_sales_team_rec.sales_lead_id is NULL or p_sales_team_rec.sales_lead_id = FND_API.G_MISS_NUM)
1789: THEN
1790: AS_ACCESS_PUB.has_updateCustomerAccess
1791: ( p_api_version_number => 2.0
1792: ,p_init_msg_list => p_init_msg_list
1793: ,p_validation_level => p_validation_level
1794: ,p_access_profile_rec => p_access_profile_rec

Line 1822: AS_ACCESS_PUB.has_updateOpportunityAccess

1818: END IF;
1819: ELSIF (p_sales_team_rec.lead_id is not NULL and p_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)
1820: then
1821:
1822: AS_ACCESS_PUB.has_updateOpportunityAccess
1823: ( p_api_version_number => 2.0
1824: ,p_init_msg_list => p_init_msg_list
1825: ,p_validation_level => p_validation_level
1826: ,p_access_profile_rec => p_access_profile_rec

Line 1856: AS_ACCESS_PUB.has_updateLeadAccess

1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;
1854: ELSIF (p_sales_team_rec.sales_lead_id is not NULL and p_sales_team_rec.sales_lead_id <> FND_API.G_MISS_NUM)
1855: then
1856: AS_ACCESS_PUB.has_updateLeadAccess
1857: ( p_api_version_number => 2.0
1858: ,p_init_msg_list => p_init_msg_list
1859: ,p_validation_level => p_validation_level
1860: ,p_access_profile_rec => p_access_profile_rec

Line 2257: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,

2253: p_commit IN VARCHAR2
2254: := FND_API.G_FALSE,
2255: p_validation_level IN NUMBER
2256: := FND_API.G_VALID_LEVEL_FULL,
2257: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
2258: p_check_access_flag IN VARCHAR2,
2259: p_admin_flag IN VARCHAR2,
2260: p_admin_group_id IN NUMBER,
2261: p_identity_salesforce_id IN NUMBER,

Line 2376: AS_ACCESS_PUB.has_updateCustomerAccess

2372: then
2373: IF (p_sales_team_rec.lead_id is NULL or p_sales_team_rec.lead_id = FND_API.G_MISS_NUM)
2374: and (p_sales_team_rec.sales_lead_id is NULL or p_sales_team_rec.sales_lead_id = FND_API.G_MISS_NUM)
2375: THEN
2376: AS_ACCESS_PUB.has_updateCustomerAccess
2377: ( p_api_version_number => 2.0
2378: ,p_init_msg_list => p_init_msg_list
2379: ,p_validation_level => p_validation_level
2380: ,p_access_profile_rec => p_access_profile_rec

Line 2408: AS_ACCESS_PUB.has_updateOpportunityAccess

2404: END IF;
2405: ELSIF (p_sales_team_rec.lead_id is not NULL and p_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)
2406: then
2407:
2408: AS_ACCESS_PUB.has_updateOpportunityAccess
2409: ( p_api_version_number => 2.0
2410: ,p_init_msg_list => p_init_msg_list
2411: ,p_validation_level => p_validation_level
2412: ,p_access_profile_rec => p_access_profile_rec

Line 2630: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,

2626: p_commit IN VARCHAR2
2627: := FND_API.G_FALSE,
2628: p_validation_level IN NUMBER
2629: := FND_API.G_VALID_LEVEL_FULL,
2630: p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
2631: p_check_access_flag IN VARCHAR2,
2632: p_admin_flag IN VARCHAR2,
2633: p_admin_group_id IN NUMBER,
2634: p_identity_salesforce_id IN NUMBER,

Line 2771: AS_ACCESS_PUB.has_updateCustomerAccess

2767: then
2768: IF (p_sales_team_rec.lead_id is NULL or p_sales_team_rec.lead_id = FND_API.G_MISS_NUM)
2769: and (p_sales_team_rec.sales_lead_id is NULL or p_sales_team_rec.sales_lead_id = FND_API.G_MISS_NUM)
2770: THEN
2771: AS_ACCESS_PUB.has_updateCustomerAccess
2772: ( p_api_version_number => 2.0
2773: ,p_init_msg_list => p_init_msg_list
2774: ,p_validation_level => p_validation_level
2775: ,p_access_profile_rec => p_access_profile_rec

Line 2802: AS_ACCESS_PUB.has_updateOpportunityAccess

2798: RAISE FND_API.G_EXC_ERROR;
2799: END IF;
2800: ELSIF (p_sales_team_rec.lead_id is not NULL and p_sales_team_rec.lead_id <> FND_API.G_MISS_NUM)
2801: then
2802: AS_ACCESS_PUB.has_updateOpportunityAccess
2803: ( p_api_version_number => 2.0
2804: ,p_init_msg_list => p_init_msg_list
2805: ,p_validation_level => p_validation_level
2806: ,p_access_profile_rec => p_access_profile_rec

Line 2836: AS_ACCESS_PUB.has_updateLeadAccess

2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834: ELSIF (p_sales_team_rec.sales_lead_id is not NULL and p_sales_team_rec.sales_lead_id <>FND_API.G_MISS_NUM)
2835: then
2836: AS_ACCESS_PUB.has_updateLeadAccess
2837: ( p_api_version_number => 2.0
2838: ,p_init_msg_list => p_init_msg_list
2839: ,p_validation_level => p_validation_level
2840: ,p_access_profile_rec => p_access_profile_rec

Line 3383: ( p_access_profile_rec IN as_access_pub.access_profile_rec_type

3379: -- this procedure only handle the case of as_cust_profile in ('P', 'T'). Other cases are
3380: -- handled in has_updateCustomerAccess
3381:
3382: procedure has_updatePersonAccess
3383: ( p_access_profile_rec IN as_access_pub.access_profile_rec_type
3384: ,p_admin_flag IN VARCHAR2
3385: ,p_admin_group_id IN NUMBER
3386: ,p_person_id IN NUMBER
3387: ,p_customer_id IN NUMBER

Line 3565: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

3561: procedure has_viewCustomerAccess
3562: ( p_api_version_number IN NUMBER
3563: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3564: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3565: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
3566: ,p_admin_flag IN VARCHAR2
3567: ,p_admin_group_id IN NUMBER
3568: ,p_person_id IN NUMBER
3569: ,p_customer_id IN NUMBER

Line 3582: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

3578: l_api_name CONSTANT VARCHAR2(30) := 'has_viewCustomerAccess';
3579: l_api_version_number CONSTANT NUMBER := 2.0;
3580: l_tmp varchar2(1);
3581: l_person_id number;
3582: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
3583:
3584: cursor resource_access_csr is
3585:
3586: select 'X'

Line 3787: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

3783: procedure has_updateCustomerAccess
3784: ( p_api_version_number IN NUMBER
3785: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3786: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3787: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
3788: ,p_admin_flag IN VARCHAR2
3789: ,p_admin_group_id IN NUMBER
3790: ,p_person_id IN NUMBER
3791: ,p_customer_id IN NUMBER

Line 3804: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

3800: l_api_name CONSTANT VARCHAR2(30) := 'has_updateCustomerAccess';
3801: l_api_version_number CONSTANT NUMBER := 2.0;
3802: l_tmp varchar2(1);
3803: l_person_id number;
3804: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
3805:
3806: cursor resource_access_csr is
3807:
3808: select 'X'

Line 4077: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

4073: procedure has_updateLeadAccess
4074: ( p_api_version_number IN NUMBER
4075: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4076: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4077: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
4078: ,p_admin_flag IN VARCHAR2
4079: ,p_admin_group_id IN NUMBER
4080: ,p_person_id IN NUMBER
4081: ,p_sales_lead_id IN NUMBER

Line 4094: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

4090: l_api_name CONSTANT VARCHAR2(30) := 'has_updateLeadAccess';
4091: l_api_version_number CONSTANT NUMBER := 2.0;
4092: l_tmp varchar2(1);
4093: l_person_id number;
4094: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4095:
4096: cursor resource_access_csr is
4097: select 'X'
4098: from as_accesses_all a

Line 4377: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

4373: procedure has_viewLeadAccess
4374: ( p_api_version_number IN NUMBER
4375: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4376: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4377: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
4378: ,p_admin_flag IN VARCHAR2
4379: ,p_admin_group_id IN NUMBER
4380: ,p_person_id IN NUMBER
4381: ,p_sales_lead_id IN NUMBER

Line 4394: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

4390: l_api_name CONSTANT VARCHAR2(30) := 'has_viewLeadAccess';
4391: l_api_version_number CONSTANT NUMBER := 2.0;
4392: l_tmp varchar2(1);
4393: l_person_id number;
4394: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4395:
4396: cursor resource_access_csr is
4397: select 'X'
4398: from as_accesses_all a

Line 4613: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

4609: procedure has_updateOpportunityAccess
4610: ( p_api_version_number IN NUMBER
4611: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4612: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4613: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
4614: ,p_admin_flag IN VARCHAR2
4615: ,p_admin_group_id IN NUMBER
4616: ,p_person_id IN NUMBER
4617: ,p_opportunity_id IN NUMBER

Line 4632: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

4628: l_tmp varchar2(1);
4629: l_update_access_flag varchar2(1);
4630: l_org_id NUMBER;
4631: l_person_id number;
4632: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4633:
4634: cursor resource_access_csr is
4635: select 'X'
4636: from as_accesses_all a

Line 4963: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type

4959: procedure has_viewOpportunityAccess
4960: ( p_api_version_number IN NUMBER
4961: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
4962: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
4963: ,p_access_profile_rec IN as_access_pub.access_profile_rec_type
4964: ,p_admin_flag IN VARCHAR2
4965: ,p_admin_group_id IN NUMBER
4966: ,p_person_id IN NUMBER
4967: ,p_opportunity_id IN NUMBER

Line 4982: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

4978: l_tmp varchar2(1);
4979: l_view_access_flag varchar2(1);
4980: l_org_id number;
4981: l_person_id number;
4982: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4983:
4984: cursor resource_access_csr is
4985: select 'X'
4986: from as_accesses_all a