1 Package JTY_ASSIGN_BULK_PUB AS
2 /* $Header: jtfyaeas.pls 120.1 2005/09/22 22:38:34 achanda noship $ */
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 );
86
87 -- ***************************************************
88 -- API Specifications
89 -- ***************************************************
90 -- api name : get_winners
91 -- type : public.
92 -- function :
93 -- pre-reqs :
94 -- notes: API designed to get the winning territories for the
95 -- transaction objs, it supports multiple worker architecture
96 --
97 PROCEDURE get_winners
98 ( p_api_version_number IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100 p_source_id IN NUMBER,
101 p_trans_id IN NUMBER,
102 p_program_name IN VARCHAR2,
103 p_mode IN VARCHAR2,
104 p_percent_analyzed IN NUMBER,
105 p_worker_id IN NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 ERRBUF OUT NOCOPY VARCHAR2,
110 RETCODE OUT NOCOPY VARCHAR2);
111
112 END JTY_ASSIGN_BULK_PUB;