APPS.AS_JTF_RS_GROUP_MEM_TRG dependencies on AS_ACCESSES_ALL

Line 55: update AS_ACCESSES_ALL acc

51: x_new_group_id is not null AND
52: x_old_group_id is not null) THEN
53:
54: -- Update Customer Access
55: update AS_ACCESSES_ALL acc
56: set object_version_number = nvl(object_version_number,0) + 1, acc.sales_group_id = x_new_group_id
57: where acc.salesforce_id = x_new_resource_id
58: and acc.sales_group_id = x_old_group_id
59: and acc.lead_id is null

Line 63: from AS_ACCESSES_ALL acc2

59: and acc.lead_id is null
60: and acc.sales_lead_id is null
61: and not exists
62: ( select 1
63: from AS_ACCESSES_ALL acc2
64: where acc2.sales_group_id = x_new_group_id
65: and acc2.salesforce_id = x_new_resource_id
66: and acc2.customer_id = acc.customer_id
67: and acc2.lead_id is null

Line 75: update AS_ACCESSES_ALL acc

71:
72: IF(l_opp_profile = 'OPEN') THEN
73:
74: -- Update Open Opportunity's Access
75: update AS_ACCESSES_ALL acc
76: set object_version_number = nvl(object_version_number,0) + 1, acc.sales_group_id = x_new_group_id
77: where acc.salesforce_id = x_new_resource_id
78: and acc.sales_group_id = x_old_group_id
79: and acc.lead_id is not null

Line 83: from AS_ACCESSES_ALL acc2

79: and acc.lead_id is not null
80: and acc.sales_lead_id is null
81: and not exists
82: ( select 1
83: from AS_ACCESSES_ALL acc2
84: where acc2.sales_group_id = x_new_group_id
85: and acc2.salesforce_id = x_new_resource_id
86: and acc2.customer_id = acc.customer_id
87: and acc2.lead_id = acc.lead_id

Line 122: update AS_ACCESSES_ALL acc

118: and st.opp_open_status_flag = 'Y');
119:
120: ELSIF(l_opp_profile = 'ALL') THEN
121:
122: update AS_ACCESSES_ALL acc
123: set object_version_number = nvl(object_version_number,0) + 1, acc.sales_group_id = x_new_group_id
124: where acc.salesforce_id = x_new_resource_id
125: and acc.sales_group_id = x_old_group_id
126: and acc.lead_id is not null

Line 130: from AS_ACCESSES_ALL acc2

126: and acc.lead_id is not null
127: and acc.sales_lead_id is null
128: and not exists
129: ( select 1
130: from AS_ACCESSES_ALL acc2
131: where acc2.sales_group_id = x_new_group_id
132: and acc2.salesforce_id = x_new_resource_id
133: and acc2.customer_id = acc.customer_id
134: and acc2.lead_id = acc.lead_id

Line 154: update AS_ACCESSES_ALL acc

150:
151: IF(l_lead_profile = 'OPEN') THEN
152:
153: -- Update Open Sales Leads' Access
154: update AS_ACCESSES_ALL acc
155: set object_version_number = nvl(object_version_number,0) + 1, acc.sales_group_id = x_new_group_id
156: where acc.salesforce_id = x_new_resource_id
157: and acc.sales_group_id = x_old_group_id
158: and acc.sales_lead_id is not null

Line 162: from AS_ACCESSES_ALL acc2

158: and acc.sales_lead_id is not null
159: and acc.lead_id is null
160: and not exists
161: ( select 1
162: from AS_ACCESSES_ALL acc2
163: where acc2.sales_group_id = x_new_group_id
164: and acc2.salesforce_id = x_new_resource_id
165: and acc2.customer_id = acc.customer_id
166: and acc2.sales_lead_id = acc.sales_lead_id

Line 191: update AS_ACCESSES_ALL acc

187:
188: ELSIF(l_lead_profile = 'ALL') THEN
189:
190: -- Update Sales Leads' Access
191: update AS_ACCESSES_ALL acc
192: set object_version_number = nvl(object_version_number,0) + 1, acc.sales_group_id = x_new_group_id
193: where acc.salesforce_id = x_new_resource_id
194: and acc.sales_group_id = x_old_group_id
195: and acc.sales_lead_id is not null

Line 199: from AS_ACCESSES_ALL acc2

195: and acc.sales_lead_id is not null
196: and acc.lead_id is null
197: and not exists
198: ( select 1
199: from AS_ACCESSES_ALL acc2
200: where acc2.sales_group_id = x_new_group_id
201: and acc2.salesforce_id = x_new_resource_id
202: and acc2.customer_id = acc.customer_id
203: and acc2.sales_lead_id = acc.sales_lead_id