1 Package JTY_ASSIGN_BULK_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfyaeas.pls 120.1.12010000.4 2009/04/08 12:47:29 ppillai ship $ */
3 ---------------------------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTY_ASSIGN_BULK_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- This package is a public API for getting winning territories
10 -- or territory resources for bulk transaction objects
11 --
12 -- Procedures:
13 -- (see below for specification)
14 --
15 -- NOTES
16 -- This package is publicly available for use
17 --
18 -- HISTORY
19 -- 06/22/2005 achanda CREATED
20 --
21
22 -- ***************************************************
23 -- GLOBAL VARIABLES and RECORD TYPE DEFINITIONS
24 -- ***************************************************
25
26
27 -- ***************************************************
28 -- API Specifications
29 -- ***************************************************
30 -- api name : --
31 -- type : public.
32 -- function : --
33 -- pre-reqs :
34 -- notes: BELOW API for MULTI-NUM MULTI-LEVEL PROCESSING
35 --
36 PROCEDURE Process_Level_Winners (
37 p_terr_LEVEL_target_tbl IN VARCHAR2,
38 p_terr_PARENT_LEVEL_tbl IN VARCHAR2,
39 p_UPPER_LEVEL_FROM_ROOT IN NUMBER,
40 p_LOWER_LEVEL_FROM_ROOT IN NUMBER,
41 p_matches_target IN VARCHAR2,
42 p_source_id IN NUMBER,
43 p_run_mode IN VARCHAR2,
44 p_date_effective IN BOOLEAN,
45 x_return_status OUT NOCOPY VARCHAR2,
46 p_worker_id IN NUMBER);
47
48 PROCEDURE Process_Final_Level_Winners (
49 p_terr_LEVEL_target_tbl IN VARCHAR2,
50 p_terr_L5_target_tbl IN VARCHAR2,
51 p_matches_target IN VARCHAR2,
52 p_source_id IN NUMBER,
53 p_run_mode IN VARCHAR2,
54 p_date_effective IN BOOLEAN,
55 x_return_status OUT NOCOPY VARCHAR2,
56 p_worker_id IN NUMBER);
57
58
59 -- ***************************************************
60 -- API Specifications
61 -- ***************************************************
62 -- api name : collect_trans_data
63 -- type : public.
64 -- function :
65 -- pre-reqs :
66 -- notes: API designed to insert transaction objects into TRANS table
67 -- for "TOTAL", "INCREMENTAL" and "DATE EFFECTIVE" mode.
68 --
69 PROCEDURE collect_trans_data
70 ( p_api_version_number IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72 p_source_id IN NUMBER,
73 p_trans_id IN NUMBER,
74 p_program_name IN VARCHAR2,
75 p_mode IN VARCHAR2,
76 p_where IN VARCHAR2,
77 p_no_of_workers IN NUMBER,
78 p_percent_analyzed IN NUMBER,
79 p_request_id IN NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 ERRBUF OUT NOCOPY VARCHAR2,
84 RETCODE OUT NOCOPY VARCHAR2,
85 p_oic_mode IN VARCHAR2 DEFAULT 'NOOIC'
86 );
87
88 -- ***************************************************
89 -- API Specifications
90 -- ***************************************************
91 -- api name : get_winners
92 -- type : public.
93 -- function :
94 -- pre-reqs :
95 -- notes: API designed to get the winning territories for the
96 -- transaction objs, it supports multiple worker architecture
97 --
98 PROCEDURE get_winners
99 ( p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_source_id IN NUMBER,
102 p_trans_id IN NUMBER,
103 p_program_name IN VARCHAR2,
104 p_mode IN VARCHAR2,
105 p_percent_analyzed IN NUMBER,
106 p_worker_id IN NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 ERRBUF OUT NOCOPY VARCHAR2,
111 RETCODE OUT NOCOPY VARCHAR2,
112 p_oic_mode IN VARCHAR2 DEFAULT 'NOOIC',
113 p_terr_id IN NUMBER DEFAULT NULL);
114
115
116 END JTY_ASSIGN_BULK_PUB;