[Home] [Help]
PACKAGE: APPS.AS_GAR_QOT_PUB
Source
1 PACKAGE AS_GAR_QOT_PUB as
2 /* $Header: asxgrqts.pls 120.2 2005/09/30 02:16 subabu noship $ */
3 /*-------------------------------------------------------------------------*
4 | PUBLIC CONSTANTS
5 *-------------------------------------------------------------------------*/
6
7 /*-------------------------------------------------------------------------*
8 | PUBLIC DATATYPES
9 *-------------------------------------------------------------------------*/
10
11 /*-------------------------------------------------------------------------*
12 | PUBLIC VARIABLES
13 *-------------------------------------------------------------------------*/
14 g_debug_flag VARCHAR2(1);
15
16 /*-------------------------------------------------------------------------*
17 | PUBLIC ROUTINES
18 *-------------------------------------------------------------------------*/
19 PROCEDURE GAR_WRAPPER(
20 errbuf OUT NOCOPY VARCHAR2,
21 retcode OUT NOCOPY VARCHAR2,
22 p_run_mode IN VARCHAR2,
23 p_debug_mode IN VARCHAR2,
24 p_trace_mode IN VARCHAR2,
25 p_worker_id IN VARCHAR2,
26 P_percent_analyzed IN NUMBER );
27
28 PROCEDURE EXPLODE_TEAMS_QOT(
29 x_errbuf OUT NOCOPY VARCHAR2,
30 x_retcode OUT NOCOPY VARCHAR2,
31 p_terr_globals IN AS_GAR.TERR_GLOBALS,
32 x_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE EXPLODE_GROUPS_QOT(
35 x_errbuf OUT NOCOPY VARCHAR2,
36 x_retcode OUT NOCOPY VARCHAR2,
37 p_terr_globals IN AS_GAR.TERR_GLOBALS,
38 x_return_status OUT NOCOPY VARCHAR2);
39
40 PROCEDURE SET_TEAM_LEAD_QOT(
41 x_errbuf OUT NOCOPY VARCHAR2,
42 x_retcode OUT NOCOPY VARCHAR2,
43 p_terr_globals IN AS_GAR.TERR_GLOBALS,
44 x_return_status OUT NOCOPY VARCHAR2);
45 PROCEDURE SET_FAF_QOT(
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 PROCEDURE INSERT_ACCESSES_QOT(
51 x_errbuf OUT NOCOPY VARCHAR2,
52 x_retcode OUT NOCOPY VARCHAR2,
53 p_terr_globals IN AS_GAR.TERR_GLOBALS,
54 x_return_status OUT NOCOPY VARCHAR2);
55
56 PROCEDURE INSERT_TERR_ACCESSES_QOT(
57 x_errbuf OUT NOCOPY VARCHAR2,
58 x_retcode OUT NOCOPY VARCHAR2,
59 p_terr_globals IN AS_GAR.TERR_GLOBALS,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62 PROCEDURE PERFORM_QOT_CLEANUP(
63 x_errbuf OUT NOCOPY VARCHAR2,
64 x_retcode OUT NOCOPY VARCHAR2,
65 p_terr_globals IN AS_GAR.TERR_GLOBALS,
66 x_return_status OUT NOCOPY VARCHAR2);
67
68 PROCEDURE ASSIGN_QOT_OWNER(
69 x_errbuf OUT NOCOPY VARCHAR2,
70 x_retcode OUT NOCOPY VARCHAR2,
71 p_terr_globals IN AS_GAR.TERR_GLOBALS,
72 x_return_status OUT NOCOPY VARCHAR2);
73
74 END AS_GAR_QOT_PUB;