[Home] [Help]
PACKAGE: APPS.JTY_TAE_CONTROL_PVT
Source
1 Package JTY_TAE_CONTROL_PVT AS
2 /* $Header: jtfyaecs.pls 120.1 2006/03/30 17:27:13 achanda noship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTY_TAE_CONTROL_PVT
7 -- ---------------------------------------------------
8 -- PURPOSE
9 --
10 -- Analyses territory data before calling mass assignment cursor generator.
11 --
12 -- Procedures:
13 -- (see below for specification)
14 --
15 -- NOTES
16 -- This package is for public use
17 --
18 -- HISTORY
19 -- 06/10/2005 ACHANDA Created.
20 --
21 -- REQIRES / DEPENDENCIES
22 --
23 -- MODIFIES
24 --
25 -- EFFECTS
26 --
27
28 PROCEDURE set_table_nologging( p_table_name VARCHAR2 );
29
30 PROCEDURE Decompose_Terr_Defns
31 ( p_Api_Version_Number IN NUMBER,
32 p_Init_Msg_List IN VARCHAR2,
33 p_trans_target IN VARCHAR2,
34 p_classify_terr_comb IN VARCHAR2,
35 p_process_tx_oin_sel IN VARCHAR2,
36 p_generate_indexes IN VARCHAR2,
37 p_source_id IN NUMBER,
38 p_trans_id IN NUMBER,
39 p_program_name IN VARCHAR2,
40 p_mode IN VARCHAR2,
41 x_Return_Status OUT NOCOPY VARCHAR2,
42 x_Msg_Count OUT NOCOPY NUMBER,
43 x_Msg_Data OUT NOCOPY VARCHAR2,
44 ERRBUF OUT NOCOPY VARCHAR2,
45 RETCODE OUT NOCOPY VARCHAR2 );
46
47 PROCEDURE delete_combinations
48 ( p_source_id IN NUMBER,
49 p_trans_id IN NUMBER,
50 p_mode IN VARCHAR2,
51 x_Return_Status OUT NOCOPY VARCHAR2,
52 x_Msg_Count OUT NOCOPY NUMBER,
53 x_Msg_Data OUT NOCOPY VARCHAR2,
54 ERRBUF OUT NOCOPY VARCHAR2,
55 RETCODE OUT NOCOPY VARCHAR2 );
56
57 PROCEDURE Classify_Territories
58 ( p_source_id IN NUMBER,
59 p_trans_id IN NUMBER,
60 p_mode IN VARCHAR2,
61 p_qual_prd_tbl IN JTY_TERR_ENGINE_GEN_PVT.qual_prd_tbl_type,
62 x_Return_Status OUT NOCOPY VARCHAR2,
63 x_Msg_Count OUT NOCOPY NUMBER,
64 x_Msg_Data OUT NOCOPY VARCHAR2,
65 ERRBUF OUT NOCOPY VARCHAR2,
66 RETCODE OUT NOCOPY VARCHAR2 );
67
68 PROCEDURE Classify_dea_Territories
69 ( p_source_id IN NUMBER,
70 p_trans_id IN NUMBER,
71 p_qual_prd_tbl IN JTY_TERR_ENGINE_GEN_PVT.qual_prd_tbl_type,
72 x_Return_Status OUT NOCOPY VARCHAR2,
73 x_Msg_Count OUT NOCOPY NUMBER,
74 x_Msg_Data OUT NOCOPY VARCHAR2,
75 ERRBUF OUT NOCOPY VARCHAR2,
76 RETCODE OUT NOCOPY VARCHAR2 );
77
78 PROCEDURE reduce_dnmval_idx_set
79 ( p_source_id IN NUMBER,
80 p_mode IN VARCHAR2,
81 x_Return_Status OUT NOCOPY VARCHAR2);
82
83 PROCEDURE reduce_deaval_idx_set
84 ( p_source_id IN NUMBER,
85 x_Return_Status OUT NOCOPY VARCHAR2);
86 END JTY_TAE_CONTROL_PVT;