[Home] [Help]
PACKAGE: APPS.OKS_RENCPY_PVT
Source
1 PACKAGE OKS_RENCPY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRCPYS.pls 120.2 2005/09/27 14:32:40 anjkumar noship $*/
3
4 SUBTYPE chrv_rec_type IS OKC_CONTRACT_PUB.chrv_rec_type;
5 SUBTYPE chrv_tbl_type IS OKC_CONTRACT_PUB.chrv_tbl_type;
6 SUBTYPE clev_rec_type IS OKC_CONTRACT_PUB.clev_rec_type;
7 SUBTYPE clev_tbl_type IS OKC_CONTRACT_PUB.clev_tbl_type;
8 SUBTYPE cacv_rec_type IS OKC_CONTRACT_PUB.cacv_rec_type;
9 SUBTYPE cacv_tbl_type IS OKC_CONTRACT_PUB.cacv_tbl_type;
10 SUBTYPE cpsv_rec_type IS OKC_CONTRACT_PUB.cpsv_rec_type;
11 SUBTYPE cpsv_tbl_type IS OKC_CONTRACT_PUB.cpsv_tbl_type;
12 SUBTYPE klnv_rec_type IS OKS_KLN_PVT.klnv_rec_type;
13 --SUBTYPE klnv_tbl_type IS OKS_KLN_PVT.klnv_tbl_type;
14 SUBTYPE catv_rec_type IS OKC_K_ARTICLE_PUB.catv_rec_type;
15 SUBTYPE catv_tbl_type IS OKC_K_ARTICLE_PUB.catv_tbl_type;
16 SUBTYPE atnv_rec_type IS OKC_K_ARTICLE_PUB.atnv_rec_type;
17 SUBTYPE atnv_tbl_type IS OKC_K_ARTICLE_PUB.atnv_tbl_type;
18 SUBTYPE cnhv_rec_type IS OKC_CONDITIONS_PUB.cnhv_rec_type;
19 SUBTYPE cnhv_tbl_type IS OKC_CONDITIONS_PUB.cnhv_tbl_type;
20 SUBTYPE cnlv_rec_type IS OKC_CONDITIONS_PUB.cnlv_rec_type;
21 SUBTYPE cnlv_tbl_type IS OKC_CONDITIONS_PUB.cnlv_tbl_type;
22 SUBTYPE cimv_rec_type IS OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
23 SUBTYPE cimv_tbl_type IS OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;
24 SUBTYPE cplv_rec_type IS OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
25 SUBTYPE cplv_tbl_type IS OKC_CONTRACT_PARTY_PUB.cplv_tbl_type;
26 SUBTYPE cgcv_rec_type IS OKC_CONTRACT_GROUP_PUB.cgcv_rec_type;
27 SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
28 SUBTYPE ctcv_rec_type IS OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
29 SUBTYPE ctcv_tbl_type IS OKC_CONTRACT_PARTY_PUB.ctcv_tbl_type;
30
31 ---------------------------------------------------------------------------
32 -- GLOBAL MESSAGE CONSTANTS
33 ---------------------------------------------------------------------------
34 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
35 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
36 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
37 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
38 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
39 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
40 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
41 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
42 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
43 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
44 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
45 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
46 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
47 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';
48 G_PROGRAM_NAME CONSTANT VARCHAR2(200) := 'OKS_RENCPY_PVT';
49 G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
50
51 ------------------------------------------------------------------------------------
52 -- GLOBAL EXCEPTION
53 ---------------------------------------------------------------------------
54 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
55
56 -- GLOBAL VARIABLES
57 ---------------------------------------------------------------------------
58 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PVT';
59 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
60 g_klnv_rec klnv_rec_type;
61 ---------------------------------------------------------------------------
62
63 TYPE api_components_rec IS RECORD(id NUMBER,
64 to_k NUMBER,
65 component_type VARCHAR2(30),
66 attribute1 VARCHAR2(100));
67
68 TYPE api_components_tbl IS TABLE OF api_components_rec INDEX BY BINARY_INTEGER;
69
70 TYPE api_lines_rec IS RECORD(id NUMBER,
71 to_k NUMBER,
72 to_line NUMBER,
73 lse_id NUMBER,
74 line_exists_yn VARCHAR2(1));
75
76 TYPE api_lines_tbl IS TABLE OF api_lines_rec INDEX BY BINARY_INTEGER;
77
78 ---------------------------------------------------------------------------
79 -- Procedures and Functions
80 ---------------------------------------------------------------------------
81
82
83 PROCEDURE copy_contract_line(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_from_cle_id IN NUMBER,
90 p_from_chr_id IN NUMBER,
91 p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
92 p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
93 p_lse_id IN NUMBER,
94 p_to_template_yn IN VARCHAR2,
95 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
96 p_copy_line_party_yn IN VARCHAR2,
97 p_renew_ref_yn IN VARCHAR2,
98 p_need_conversion IN VARCHAR2 DEFAULT 'N',
99 x_cle_id OUT NOCOPY NUMBER);
100
101 PROCEDURE copy_party_roles(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_cpl_id IN NUMBER,
108 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
109 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
110 p_rle_code IN VARCHAR2,
111 x_cpl_id OUT NOCOPY NUMBER);
112
113 PROCEDURE copy_articles(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_cat_id IN NUMBER,
120 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
121 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
122 x_cat_id OUT NOCOPY NUMBER);
123
124
125 PROCEDURE copy_rules(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_old_cle_id IN NUMBER,
132 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
133 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
134 p_cust_acct_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
135 p_bill_to_site_use_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
136 p_to_template_yn IN VARCHAR2);
137
138
139 PROCEDURE create_trxn_extn(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_old_trx_ext_id IN NUMBER,
146 p_order_id IN NUMBER,
147 p_cust_acct_id IN NUMBER,
148 p_bill_to_site_use_id IN NUMBER,
149 x_trx_ext_id OUT NOCOPY NUMBER);
150
151 END OKS_RENCPY_PVT;
152