APPS.AS_GAR_ACCOUNTS_PUB dependencies on AS_GAR_ACCOUNTS_PUB

Line 1: PACKAGE BODY AS_GAR_ACCOUNTS_PUB AS

1: PACKAGE BODY AS_GAR_ACCOUNTS_PUB AS
2: /* $Header: asxgracb.pls 120.11.12000000.2 2007/05/05 08:30:51 annsrini ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: AS_GAR_ACCOUNTS_PUB

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

Line 111: AS_GAR_ACCOUNTS_PUB.EXPLODE_GROUPS_ACCOUNTS(

107: COMMIT;
108:
109: -- Explode GROUPS if any inside winners
110: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
111: AS_GAR_ACCOUNTS_PUB.EXPLODE_GROUPS_ACCOUNTS(
112: x_errbuf => l_errbuf,
113: x_retcode => l_retcode,
114: p_terr_globals => l_terr_globals,
115: x_return_status => l_return_status);

Line 129: AS_GAR_ACCOUNTS_PUB.EXPLODE_TEAMS_ACCOUNTS(

125: COMMIT;
126:
127: -- Explode TEAMS if any inside winners
128: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
129: AS_GAR_ACCOUNTS_PUB.EXPLODE_TEAMS_ACCOUNTS(
130: x_errbuf => l_errbuf,
131: x_retcode => l_retcode,
132: p_terr_globals => l_terr_globals,
133: x_return_status => l_return_status);

Line 147: AS_GAR_ACCOUNTS_PUB.SET_TEAM_LEAD_ACCOUNTS(

143: COMMIT;
144:
145: -- Set team leader for Accounts
146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);
147: AS_GAR_ACCOUNTS_PUB.SET_TEAM_LEAD_ACCOUNTS(
148: x_errbuf => l_errbuf,
149: x_retcode => l_retcode,
150: p_terr_globals => l_terr_globals,
151: x_return_status => l_return_status);

Line 163: AS_GAR_ACCOUNTS_PUB.INSERT_ACCESSES_ACCOUNTS(

159: End If;
160:
161: -- Insert into Account Accesses from Winners
162: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);
163: AS_GAR_ACCOUNTS_PUB.INSERT_ACCESSES_ACCOUNTS(
164: x_errbuf => l_errbuf,
165: x_retcode => l_retcode,
166: p_terr_globals => l_terr_globals,
167: x_return_status => l_return_status);

Line 179: AS_GAR_ACCOUNTS_PUB.INSERT_TERR_ACCESSES_ACCOUNTS(

175: End If;
176:
177: -- Insert into territory Accesses
178: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
179: AS_GAR_ACCOUNTS_PUB.INSERT_TERR_ACCESSES_ACCOUNTS(
180: x_errbuf => l_errbuf,
181: x_retcode => l_retcode,
182: p_terr_globals => l_terr_globals,
183: x_return_status => l_return_status);

Line 199: AS_GAR_ACCOUNTS_PUB.SET_TEAM_LEAD_PRM_ACCOUNTS(

195: FETCH get_count INTO l_count;
196: CLOSE get_count;
197: IF l_count > 0 THEN -- If There are any PRM Resources assigned in JTY
198: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || 'PRM:: ' || AS_GAR.G_START);
199: AS_GAR_ACCOUNTS_PUB.SET_TEAM_LEAD_PRM_ACCOUNTS(
200: x_errbuf => l_errbuf,
201: x_retcode => l_retcode,
202: p_terr_globals => l_terr_globals,
203: x_return_status => l_return_status);

Line 215: AS_GAR_ACCOUNTS_PUB.INSERT_ACCESSES_PRM_ACCOUNTS(

211: End If;
212:
213: -- Insert into Account Accesses from Winners
214: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ' || AS_GAR.G_START);
215: AS_GAR_ACCOUNTS_PUB.INSERT_ACCESSES_PRM_ACCOUNTS(
216: x_errbuf => l_errbuf,
217: x_retcode => l_retcode,
218: p_terr_globals => l_terr_globals,
219: x_return_status => l_return_status);

Line 231: AS_GAR_ACCOUNTS_PUB.INSERT_TERR_ACCESSES_PRM_ACCS(

227: End If;
228:
229: -- Insert into territory Accesses
230: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ' || AS_GAR.G_START);
231: AS_GAR_ACCOUNTS_PUB.INSERT_TERR_ACCESSES_PRM_ACCS(
232: x_errbuf => l_errbuf,
233: x_retcode => l_retcode,
234: p_terr_globals => l_terr_globals,
235: x_return_status => l_return_status);

Line 249: AS_GAR_ACCOUNTS_PUB.Perform_Account_Cleanup(

245: END IF;
246:
247: -- Remove (soft delete) records in access table that are not qualified
248: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);
249: AS_GAR_ACCOUNTS_PUB.Perform_Account_Cleanup(
250: x_errbuf => l_errbuf,
251: x_retcode => l_retcode,
252: p_terr_globals => l_terr_globals,
253: x_return_status => l_return_status);

Line 2502: END AS_GAR_ACCOUNTS_PUB;

2498: END Perform_Account_Cleanup;
2499:
2500: /************************** End Account Cleanup ***********************/
2501:
2502: END AS_GAR_ACCOUNTS_PUB;
2503: