DBA Data[Home] [Help]

APPS.AS_GAR_LEADS_PUB dependencies on AS_GAR_LEADS_PUB

Line 1: PACKAGE BODY AS_GAR_LEADS_PUB AS

1: PACKAGE BODY AS_GAR_LEADS_PUB AS
2: /* $Header: asxgrldb.pls 120.8.12010000.2 2010/03/01 10:38:13 sariff ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: AS_GAR_LEADS_PUB

3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments
6: ---------------------------------------------------------------------------
7: -- PACKAGE NAME: AS_GAR_LEADS_PUB
8: -- ---------------------------------------------------------------------
9: -- PURPOSE
10: -- --------
11: -- This package contains procedures to accomplish each of the following

Line 107: AS_GAR_LEADS_PUB.EXPLODE_GROUPS_LEADS(

103: COMMIT;
104:
105: -- Explode GROUPS if any inside winners
106: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
107: AS_GAR_LEADS_PUB.EXPLODE_GROUPS_LEADS(
108: x_errbuf => l_errbuf,
109: x_retcode => l_retcode,
110: p_terr_globals => l_terr_globals,
111: x_return_status => l_return_status);

Line 125: AS_GAR_LEADS_PUB.EXPLODE_TEAMS_LEADS(

121: COMMIT;
122:
123: -- Explode TEAMS if any inside winners
124: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
125: AS_GAR_LEADS_PUB.EXPLODE_TEAMS_LEADS(
126: x_errbuf => l_errbuf,
127: x_retcode => l_retcode,
128: p_terr_globals => l_terr_globals,
129: x_return_status => l_return_status);

Line 143: AS_GAR_LEADS_PUB.SET_TEAM_LEAD_LEADS(

139: COMMIT;
140:
141: -- Set team leader for Leads
142: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);
143: AS_GAR_LEADS_PUB.SET_TEAM_LEAD_LEADS(
144: x_errbuf => l_errbuf,
145: x_retcode => l_retcode,
146: p_terr_globals => l_terr_globals,
147: x_return_status => l_return_status);

Line 159: AS_GAR_LEADS_PUB.INSERT_ACCESSES_LEADS(

155: End If;
156:
157: -- Insert into Lead Accesses from Winners
158: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);
159: AS_GAR_LEADS_PUB.INSERT_ACCESSES_LEADS(
160: x_errbuf => l_errbuf,
161: x_retcode => l_retcode,
162: p_terr_globals => l_terr_globals,
163: x_return_status => l_return_status);

Line 175: AS_GAR_LEADS_PUB.INSERT_TERR_ACCESSES_LEADS(

171: End If;
172:
173: -- Insert into territory Accesses
174: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
175: AS_GAR_LEADS_PUB.INSERT_TERR_ACCESSES_LEADS(
176: x_errbuf => l_errbuf,
177: x_retcode => l_retcode,
178: p_terr_globals => l_terr_globals,
179: x_return_status => l_return_status);

Line 191: AS_GAR_LEADS_PUB.PERFORM_LEAD_CLEANUP(

187: End If;
188:
189: -- Remove (soft delete) records in access table that are not qualified
190: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);
191: AS_GAR_LEADS_PUB.PERFORM_LEAD_CLEANUP(
192: x_errbuf => l_errbuf,
193: x_retcode => l_retcode,
194: p_terr_globals => l_terr_globals,
195: x_return_status => l_return_status);

Line 219: AS_GAR_LEADS_PUB.ASSIGN_LEAD_OWNER(

215: l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
216:
217: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);
218: IF l_assign_manual_flag = 'N' THEN
219: AS_GAR_LEADS_PUB.ASSIGN_LEAD_OWNER(
220: x_errbuf => l_errbuf,
221: x_retcode => l_retcode,
222: p_terr_globals => l_terr_globals,
223: x_return_status => l_return_status);

Line 225: AS_GAR_LEADS_PUB.ASSIGN_DEFAULT_LEAD_OWNER(

221: x_retcode => l_retcode,
222: p_terr_globals => l_terr_globals,
223: x_return_status => l_return_status);
224: IF l_resource_id IS NOT NULL THEN
225: AS_GAR_LEADS_PUB.ASSIGN_DEFAULT_LEAD_OWNER(
226: x_errbuf => l_errbuf,
227: x_retcode => l_retcode,
228: p_terr_globals => l_terr_globals,
229: x_return_status => l_return_status);

Line 233: AS_GAR_LEADS_PUB.UNCHECK_LEAD_OWNER(

229: x_return_status => l_return_status);
230: END IF;
231: ELSE
232: IF l_resource_id IS NOT NULL THEN
233: AS_GAR_LEADS_PUB.UNCHECK_LEAD_OWNER(
234: x_errbuf => l_errbuf,
235: x_retcode => l_retcode,
236: p_terr_globals => l_terr_globals,
237: x_return_status => l_return_status);

Line 238: AS_GAR_LEADS_PUB.ASSIGN_DEFAULT_LEAD_OWNER(

234: x_errbuf => l_errbuf,
235: x_retcode => l_retcode,
236: p_terr_globals => l_terr_globals,
237: x_return_status => l_return_status);
238: AS_GAR_LEADS_PUB.ASSIGN_DEFAULT_LEAD_OWNER(
239: x_errbuf => l_errbuf,
240: x_retcode => l_retcode,
241: p_terr_globals => l_terr_globals,
242: x_return_status => l_return_status);

Line 244: AS_GAR_LEADS_PUB.UNCHECK_ASSIGN_SALESFORCE(

240: x_retcode => l_retcode,
241: p_terr_globals => l_terr_globals,
242: x_return_status => l_return_status);
243: ELSE
244: AS_GAR_LEADS_PUB.UNCHECK_ASSIGN_SALESFORCE(
245: x_errbuf => l_errbuf,
246: x_retcode => l_retcode,
247: p_terr_globals => l_terr_globals,
248: x_return_status => l_return_status);

Line 2840: END AS_GAR_LEADS_PUB;

2836: END UNCHECK_ASSIGN_SALESFORCE;
2837:
2838: /**************************** End Uncheck_Assign_Salesforce ********************/
2839:
2840: END AS_GAR_LEADS_PUB;
2841: