PACKAGE: APPS.IEX_ATA_PUB

Source

1 PACKAGE IEX_ATA_PUB AS
2 /* $Header: iextpins.pls 120.5 2006/03/18 06:38:19 lkkumar noship $ */
3 
4 /*-------------------------------------------------------------------------*
5  |
6  |                             PUBLIC CONSTANTS
7  |
8  *-------------------------------------------------------------------------*/
9 G_QUALIFIER_CODE_SIZE NUMBER := 30; -- size of qualifier_code
10 
11 -- flag for NEW MODE in running program
12 G_NEW_MODE            VARCHAR2(11) := 'NEW';
13 
14 -- flag for TOTAL MODE in running program
15 G_TOTAL_MODE          VARCHAR2(5) := 'TOTAL';
16 
17 /*-------------------------------------------------------------------------*
18  |
19  |                             PUBLIC DATATYPES
20  |
21  *-------------------------------------------------------------------------*/
22 TYPE IEX_GLOBALS IS RECORD (
23     user_id                 NUMBER,
24     last_update_login       NUMBER,
25     prog_appl_id            NUMBER,
26     prog_id                 NUMBER,
27     request_id              NUMBER,
28     prev_request_id         NUMBER,
29     sequence                NUMBER,
30     num_child_processes     NUMBER,
31     min_num_parallel_proc   NUMBER,
32     max_rank                NUMBER,
33     run_mode                VARCHAR2(7),
34     manager_has_access      VARCHAR2(1),
35     num_acct_qual           NUMBER,
36     num_oppor_qual          NUMBER,
37     num_acct_oppor_qual     NUMBER,
38     debug_flag              VARCHAR2(1),
39     num_rollup_days         NUMBER,
40     conversion_type         VARCHAR2(30),
41     rec_to_commit           NUMBER,
42     rec_to_open             NUMBER);
43 
44 TYPE QUAL_LIST_REC_TYPE IS RECORD (
45     seeded_qualifier_id     NUMBER,
46     qualifier_code          VARCHAR2(30)
47 );
48 
49 TYPE QUAL_LIST_TBL_TYPE IS TABLE OF QUAL_LIST_REC_TYPE
50 	INDEX BY BINARY_INTEGER;
51 
52 
53 /*-------------------------------------------------------------------------*
54  |
55  |                             PUBLIC VARIABLES
56  |
57  *-------------------------------------------------------------------------*/
58 
59 g_user_id                 NUMBER;
60 g_last_update_login       NUMBER;
61 g_prog_appl_id            NUMBER;
62 g_prog_id                 NUMBER;
63 g_request_id              NUMBER;
64 g_prev_request_id         NUMBER;
65 g_num_child_processes     NUMBER;
66 g_min_num_parallel_proc   NUMBER;
67 g_NumChildAccountWorker   NUMBER;
68 g_NumChildOpporWorker     NUMBER;
69 g_NumChildLeadWorker      NUMBER;
70 g_num_acct_qual           NUMBER;
71 g_num_acct_oppor_qual     NUMBER;
72 g_num_rollup_days         NUMBER;
73 g_conversion_type         VARCHAR2(30);
74 g_trace_mode              VARCHAR2(1);
75 g_debug_flag              VARCHAR2(1);
76 g_run_mode                VARCHAR2(15);
77 g_Mode                    VARCHAR2(30);
78 g_oppor_territories_exist VARCHAR2(1);
79 g_lead_territories_exist  VARCHAR2(1);
80 p_lead_status			  VARCHAR2(30);
81 p_opp_status			  VARCHAR2(30);
82 
83 /*-------------------------------------------------------------------------*
84  |
85  |                             PUBLIC ROUTINES
86  |
87  *-------------------------------------------------------------------------*/
88 --Bug5043777 Removed the parameters which is no longer in use.
89 PROCEDURE Assign_Territory_Accesses(
90     ERRBUF                OUT NOCOPY VARCHAR2,
91     RETCODE               OUT NOCOPY VARCHAR2,
92     P_ORG_ID              IN NUMBER
93 );
94 
95 PROCEDURE iex_DEBUG( msg in VARCHAR2);
96 
97 PROCEDURE Set_Area_Sizes;
98 
99 
100 END IEX_ATA_PUB;