[Home] [Help]
PACKAGE: APPS.IEX_TERR_WINNERS_PUB
Source
1 PACKAGE IEX_TERR_WINNERS_PUB AUTHID CURRENT_USER as
2 /* $Header: iexttwps.pls 120.0 2005/07/21 12:46:55 schekuri noship $ */
3 ---------------------------------------------------------------------------
4 -- Start of Comments
5 ---------------------------------------------------------------------------
6 -- PACKAGE NAME: IEX_TERR_WINNERS_PUB
7 -- ---------------------------------------------------------------------
8 -- PURPOSE
9 --
10 -- Public Package for the concurrent program
11 -- "Generate Access Records".
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package to be used by the dependent procedures
18 -- of "Generate Access Records" conc job.
19 --
20 -- HISTORY
21 -- 04/14/2002 AXAVIER Francis Xavier Created.
22 -- 06/28/2003 SESUNDAR Modified for implementing parallel workers
23 -- 11/10/2003 SESUNDAR Added cursor_limit for bug fix 3164624
24 -- 11/11/2003 SESUNDAR Fixed bug#3194696
25 -- 11/13/2003 MMUSUVAT Enh3100827, opp status parameter
26 --
27 ---------------------------------------------------------------------------
28
29
30
31 /*-------------------------------------------------------------------------*
32 | PUBLIC CONSTANTS
33 *-------------------------------------------------------------------------*/
34
35 /*-------------------------------------------------------------------------*
36 | PUBLIC DATATYPES
37 *-------------------------------------------------------------------------*/
38 TYPE TERR_GLOBALS IS RECORD (
39 user_id NUMBER,
40 last_update_login NUMBER,
41 prog_appl_id NUMBER,
42 prog_id NUMBER,
43 request_id NUMBER,
44 prev_request_id NUMBER,
45 sequence NUMBER,
46 num_child_processes NUMBER,
47 min_num_parallel_proc NUMBER,
48 max_rank NUMBER,
49 run_mode VARCHAR2(7),
50 oppor_territories_exist VARCHAR2(1),
51 lead_territories_exist VARCHAR2(1),
52 manager_has_access VARCHAR2(1),
53 num_acct_qual NUMBER,
54 num_oppor_qual NUMBER,
55 num_lead_qual NUMBER,
56 num_acct_oppor_qual NUMBER,
57 num_acct_lead_qual NUMBER,
58 debug_flag VARCHAR2(1),
59 num_rollup_days NUMBER,
60 conversion_type VARCHAR2(30),
61 lead_status VARCHAR2(7),
62 opp_status VARCHAR2(7), -- mmusuvat, enh3100827
63 enable_dups_rs_del VARCHAR2(1),
64 transaction_type VARCHAR2(30),
65 worker_id NUMBER,
66 actual_workers NUMBER,
67 num_child_account_worker NUMBER,
68 num_child_oppor_worker NUMBER,
69 num_child_lead_worker NUMBER,
70 bulk_size NUMBER,
71 disable_lead_processing VARCHAR2(1),
72 cursor_limit NUMBER);
73
74
75 /*-------------------------------------------------------------------------*
76 | PUBLIC VARIABLES
77 *-------------------------------------------------------------------------*/
78 g_user_id NUMBER;
79 g_last_update_login NUMBER;
80 g_prog_appl_id NUMBER;
81 g_prog_id NUMBER;
82 g_request_id NUMBER;
83 g_prev_request_id NUMBER;
84 g_num_child_processes NUMBER;
85 g_min_num_parallel_proc NUMBER;
86 g_num_acct_qual NUMBER;
87 g_num_oppor_qual NUMBER;
88 g_num_lead_qual NUMBER;
89 g_num_acct_oppor_qual NUMBER;
90 g_num_acct_lead_qual NUMBER;
91 g_num_rollup_days NUMBER;
92 g_conversion_type VARCHAR2(30);
93 g_debug_flag VARCHAR2(1);
94 g_oppor_territories_exist VARCHAR2(1);
95 g_lead_territories_exist VARCHAR2(1);
96 g_run_mode VARCHAR2(7);
97
98 G_TAP_FLAG VARCHAR2(1) := 'N';
99
100 /*-------------------------------------------------------------------------*
101 | PUBLIC ROUTINES
102 *-------------------------------------------------------------------------*/
103 PROCEDURE Print_Debug( msg in VARCHAR2);
104 PROCEDURE Analyze_Table(
105 schema IN VARCHAR2,
106 table_name IN VARCHAR2,
107 p_percent IN NUMBER );
108
109
110 END IEX_TERR_WINNERS_PUB;