[Home] [Help]
PACKAGE: APPS.OKL_STREAM_MIGRATION_PVT
Source
1 PACKAGE OKL_STREAM_MIGRATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSMGS.pls 120.2 2005/10/30 03:17:20 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STREAM_MIGRATION_PVT';
5 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
6 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
7 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8
9 G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
10 G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
11 G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12 G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13 G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14
15 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
17 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
18 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19
20 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
21 G_EXCEPTION_ERROR EXCEPTION;
22 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
23
24 SUBTYPE aesv_rec_type IS Okl_Process_Tmpt_Set_Pub.aesv_rec_type;
25 SUBTYPE avlv_rec_type IS Okl_Process_Tmpt_Set_Pub.avlv_rec_type;
26 SUBTYPE atlv_rec_type IS Okl_Process_Tmpt_Set_Pub.atlv_rec_type;
27 SUBTYPE pdtv_rec_type IS Okl_Products_Pub.pdtv_rec_type;
28
29 -- Stream Generation Template Set
30 SUBTYPE gttv_rec_type IS Okl_Gtt_Pvt.gttv_rec_type;
31 SUBTYPE gttv_tbl_type IS Okl_Gtt_Pvt.gttv_tbl_type;
32
33 -- Stream Generation Template
34 SUBTYPE gtsv_rec_type IS Okl_Gts_Pvt.gtsv_rec_type;
35 SUBTYPE gtsv_tbl_type IS Okl_Gts_Pvt.gtsv_tbl_type;
36
37 -- Stream Generation Template Stream Types
38 SUBTYPE gtlv_rec_type IS Okl_Gtl_Pvt.gtlv_rec_type;
39 SUBTYPE gtlv_tbl_type IS Okl_Gtl_Pvt.gtlv_tbl_type;
40
41 -- Stream Generation Template Stream Types
42 SUBTYPE gtpv_rec_type IS Okl_Gtp_Pvt.gtpv_rec_type;
43 SUBTYPE gtpv_tbl_type IS Okl_Gtp_Pvt.gtpv_tbl_type;
44
45 SUBTYPE error_msgs_tbl_type IS Okl_Strm_Gen_Template_Pvt.error_msgs_tbl_type;
46
47 TYPE dep_sty_rec IS RECORD (
48 sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM,
49 sty_code okl_strm_type_b.code%TYPE DEFAULT Okl_Api.G_MISS_CHAR,
50 stream_type_purpose okl_strm_type_b.stream_type_purpose%TYPE DEFAULT Okl_Api.G_MISS_CHAR
51 );
52
53 TYPE dep_sty_tbl IS TABLE OF dep_sty_rec INDEX BY BINARY_INTEGER;
54
55
56 ---------------------------------------------------------------------------
57 -- PROCEDURE Migrate_Accounting_Templates
58 ---------------------------------------------------------------------------
59 -- Start of comments
60 --
61 -- Procedure Name : Migrate_Accounting_Templates
62 -- Description : Procedure to migrate accounting templates and products
63 -- Business Rules :
64 -- Parameters :
65 -- Version : 1.0
66 -- End of comments
67 ---------------------------------------------------------------------------
68
69 PROCEDURE Migrate_Accounting_Templates;
70
71 ---------------------------------------------------------------------------
72 -- PROCEDURE Migrate_Streams_Process
73 ---------------------------------------------------------------------------
74 -- Start of comments
75 --
76 -- Procedure Name : Migrate_Streams_Process
77 -- Description : Procedure to create new stream templates
78 -- Business Rules :
79 -- Parameters :
80 -- Version : 1.0
81 -- End of comments
82 ---------------------------------------------------------------------------
83
84 PROCEDURE Migrate_Streams_Process(p_stream_generator IN VARCHAR2);
85
86
87 ---------------------------------------------------------------------------
88 -- PROCEDURE Migrate_Stream_Types
89 ---------------------------------------------------------------------------
90 -- Start of comments
91 --
92 -- Procedure Name : Migrate_Stream_Types
93 -- Description : Procedure to migrate stream types based on its usage
94 -- Business Rules :
95 -- Parameters :
96 -- Version : 1.0
97 -- End of comments
98 ---------------------------------------------------------------------------
99
100 PROCEDURE Migrate_Stream_Types(x_return_status OUT NOCOPY VARCHAR2);
101
102 ---------------------------------------------------------------------------
103 -- PROCEDURE Check_If_Used
104 ---------------------------------------------------------------------------
105 -- Start of comments
106 --
107 -- Procedure Name : Check_If_Used
108 -- Description : Procedure to check if a stream type is used on a contract
109 -- of a specific deal type
110 -- Business Rules :
111 -- Parameters :
112 -- Version : 1.0
113 -- End of comments
114 ---------------------------------------------------------------------------
115
116 FUNCTION Check_If_Used (p_sty_id IN NUMBER,
117 p_book_class IN VARCHAR2,
118 p_tax_owner IN VARCHAR2)
119 RETURN VARCHAR2;
120
121 END OKL_STREAM_MIGRATION_PVT;
122