[Home] [Help]
PACKAGE: APPS.AS_GAR_PROPOSALS_PUB
Source
1 PACKAGE AS_GAR_PROPOSALS_PUB AUTHID CURRENT_USER as
2 /* $Header: asxgrpps.pls 120.2 2005/09/05 21:36 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_PROPOSALS(
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_PROPOSALS(
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_PROPOSALS(
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
46 PROCEDURE INSERT_ACCESSES_PROPOSALS(
47 x_errbuf OUT NOCOPY VARCHAR2,
48 x_retcode OUT NOCOPY VARCHAR2,
49 p_terr_globals IN AS_GAR.TERR_GLOBALS,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE INSERT_TERR_ACCESSES_PROPOSALS(
53 x_errbuf OUT NOCOPY VARCHAR2,
54 x_retcode OUT NOCOPY VARCHAR2,
55 p_terr_globals IN AS_GAR.TERR_GLOBALS,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 PROCEDURE Perform_Proposal_Cleanup(
59 x_errbuf OUT NOCOPY VARCHAR2,
60 x_retcode OUT NOCOPY VARCHAR2,
61 p_terr_globals IN AS_GAR.TERR_GLOBALS,
62 x_return_status OUT NOCOPY VARCHAR2);
63
64 END AS_GAR_PROPOSALS_PUB;