[Home] [Help]
PACKAGE: APPS.AS_GAR_LEADS_PUB
Source
1 PACKAGE AS_GAR_LEADS_PUB AUTHID CURRENT_USER as
2 /* $Header: asxgrlds.pls 120.1.12010000.2 2010/03/01 10:36:14 sariff ship $ */
3 /*-------------------------------------------------------------------------*
4 | PUBLIC CONSTANTS
5 *-------------------------------------------------------------------------*/
6
7 /*-------------------------------------------------------------------------*
8 | PUBLIC DATATYPES
9 *-------------------------------------------------------------------------*/
10
11 /*-------------------------------------------------------------------------*
12 | PUBLIC VARIABLES
13 *-------------------------------------------------------------------------*/
14
15 /*-------------------------------------------------------------------------*
16 | PUBLIC ROUTINES
17 *-------------------------------------------------------------------------*/
18 PROCEDURE GAR_WRAPPER(
19 errbuf OUT NOCOPY VARCHAR2,
20 retcode OUT NOCOPY VARCHAR2,
21 p_run_mode IN VARCHAR2,
22 p_debug_mode IN VARCHAR2,
23 p_trace_mode IN VARCHAR2,
24 p_worker_id IN VARCHAR2,
25 P_percent_analyzed IN NUMBER );
26
27 PROCEDURE EXPLODE_TEAMS_LEADS(
28 x_errbuf OUT NOCOPY VARCHAR2,
29 x_retcode OUT NOCOPY VARCHAR2,
30 p_terr_globals IN AS_GAR.TERR_GLOBALS,
31 x_return_status OUT NOCOPY VARCHAR2);
32
33 PROCEDURE EXPLODE_GROUPS_LEADS(
34 x_errbuf OUT NOCOPY VARCHAR2,
35 x_retcode OUT NOCOPY VARCHAR2,
36 p_terr_globals IN AS_GAR.TERR_GLOBALS,
37 x_return_status OUT NOCOPY VARCHAR2);
38
39 PROCEDURE SET_TEAM_LEAD_LEADS(
40 x_errbuf OUT NOCOPY VARCHAR2,
41 x_retcode OUT NOCOPY VARCHAR2,
42 p_terr_globals IN AS_GAR.TERR_GLOBALS,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 PROCEDURE INSERT_ACCESSES_LEADS(
46 x_errbuf OUT NOCOPY VARCHAR2,
47 x_retcode OUT NOCOPY VARCHAR2,
48 p_terr_globals IN AS_GAR.TERR_GLOBALS,
49 x_return_status OUT NOCOPY VARCHAR2);
50
51 PROCEDURE INSERT_TERR_ACCESSES_LEADS(
52 x_errbuf OUT NOCOPY VARCHAR2,
53 x_retcode OUT NOCOPY VARCHAR2,
54 p_terr_globals IN AS_GAR.TERR_GLOBALS,
55 x_return_status OUT NOCOPY VARCHAR2);
56
57 PROCEDURE PERFORM_LEAD_CLEANUP(
58 x_errbuf OUT NOCOPY VARCHAR2,
59 x_retcode OUT NOCOPY VARCHAR2,
60 p_terr_globals IN AS_GAR.TERR_GLOBALS,
61 x_return_status OUT NOCOPY VARCHAR2);
62
63 PROCEDURE ASSIGN_LEAD_OWNER(
64 x_errbuf OUT NOCOPY VARCHAR2,
65 x_retcode OUT NOCOPY VARCHAR2,
66 p_terr_globals IN AS_GAR.TERR_GLOBALS,
67 x_return_status OUT NOCOPY VARCHAR2);
68
69 -- three new procedure added for bug 8615468
70 PROCEDURE ASSIGN_DEFAULT_LEAD_OWNER(
71 x_errbuf OUT NOCOPY VARCHAR2,
72 x_retcode OUT NOCOPY VARCHAR2,
73 p_terr_globals IN AS_GAR.TERR_GLOBALS,
74 x_return_status OUT NOCOPY VARCHAR2);
75
76 PROCEDURE UNCHECK_LEAD_OWNER(
77 x_errbuf OUT NOCOPY VARCHAR2,
78 x_retcode OUT NOCOPY VARCHAR2,
79 p_terr_globals IN AS_GAR.TERR_GLOBALS,
80 x_return_status OUT NOCOPY VARCHAR2);
81
82 PROCEDURE UNCHECK_ASSIGN_SALESFORCE(
83 x_errbuf OUT NOCOPY VARCHAR2,
84 x_retcode OUT NOCOPY VARCHAR2,
85 p_terr_globals IN AS_GAR.TERR_GLOBALS,
86 x_return_status OUT NOCOPY VARCHAR2);
87
88 END AS_GAR_LEADS_PUB;