[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_TOP_LINE_PVT
Source
1 PACKAGE okl_contract_top_line_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRKTLS.pls 115.4 2002/12/30 21:24:18 smereddy noship $ */
3
4 subtype klev_rec_type is okl_kle_pvt.klev_rec_type;
5 subtype klev_tbl_type is okl_kle_pvt.klev_tbl_type;
6 subtype clev_rec_type is okl_okc_migration_pvt.clev_rec_type;
7 subtype clev_tbl_type is okl_okc_migration_pvt.clev_tbl_type;
8 subtype cimv_rec_type is okl_okc_migration_pvt.cimv_rec_type;
9 subtype cimv_tbl_type is okl_okc_migration_pvt.cimv_tbl_type;
10 subtype cplv_rec_type is okl_okc_migration_pvt.cplv_rec_type;
11 subtype cplv_tbl_type is okl_okc_migration_pvt.cplv_tbl_type;
12
13
14 -- GLOBAL VARIABLES
15
16 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_TOP_LINE_PVT';
17 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18 G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE';
19 G_INVALID_PERIOD CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_PERIOD';
20 G_INCOMPLETE_RULE CONSTANT VARCHAR2(200) := 'OKL_LLA_INCOMPLETE_RULE';
21 G_INVALID_EXP_AMOUNT CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_EXP_AMOUNT';
22 G_INVALID_LINE_RULE CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_LINE_RULE';
23 G_UOM_SETUP_ERROR CONSTANT VARCHAR2(1000) := 'OKL_GUARANTOR_UOM_ERROR';
24
25 PROCEDURE create_contract_top_line(
26 p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 p_clev_rec IN clev_rec_type,
32 p_klev_rec IN klev_rec_type,
33 p_cimv_rec IN cimv_rec_type,
34 p_cplv_rec IN cplv_rec_type,
35 x_clev_rec OUT NOCOPY clev_rec_type,
36 x_klev_rec OUT NOCOPY klev_rec_type,
37 x_cimv_rec OUT NOCOPY cimv_rec_type,
38 x_cplv_rec OUT NOCOPY cplv_rec_type);
39
40 PROCEDURE create_contract_link_serv (
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_chr_id IN NUMBER,
47 p_contract_number IN VARCHAR2,
48 p_item_name IN VARCHAR2,
49 p_supplier_name IN VARCHAR2,
50 x_cle_id OUT NOCOPY NUMBER);
51
52 PROCEDURE update_contract_top_line(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_clev_rec IN clev_rec_type,
59 p_klev_rec IN klev_rec_type,
60 p_cimv_rec IN cimv_rec_type,
61 p_cplv_rec IN cplv_rec_type,
62 x_clev_rec OUT NOCOPY clev_rec_type,
63 x_klev_rec OUT NOCOPY klev_rec_type,
64 x_cimv_rec OUT NOCOPY cimv_rec_type,
65 x_cplv_rec OUT NOCOPY cplv_rec_type);
66
67
68 PROCEDURE update_contract_link_serv (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_chr_id IN NUMBER,
75 p_cle_id IN NUMBER,
76 p_contract_number IN VARCHAR2,
77 p_item_name IN VARCHAR2,
78 p_supplier_name IN VARCHAR2,
79 x_cle_id OUT NOCOPY NUMBER);
80
81 PROCEDURE delete_contract_top_line(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_clev_rec IN clev_rec_type,
88 p_klev_rec IN klev_rec_type,
89 p_cimv_rec IN cimv_rec_type,
90 p_cplv_rec IN cplv_rec_type);
91
92 PROCEDURE delete_contract_line(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_chr_id IN number,
99 p_cle_id IN number);
100
101 PROCEDURE create_contract_top_line(
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_clev_tbl IN clev_tbl_type,
108 p_klev_tbl IN klev_tbl_type,
109 p_cimv_tbl IN cimv_tbl_type,
110 p_cplv_tbl IN cplv_tbl_type,
111 x_clev_tbl OUT NOCOPY clev_tbl_type,
112 x_klev_tbl OUT NOCOPY klev_tbl_type,
113 x_cimv_tbl OUT NOCOPY cimv_tbl_type,
114 x_cplv_tbl OUT NOCOPY cplv_tbl_type);
115
116 PROCEDURE update_contract_top_line(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_clev_tbl IN clev_tbl_type,
123 p_klev_tbl IN klev_tbl_type,
124 p_cimv_tbl IN cimv_tbl_type,
125 p_cplv_tbl IN cplv_tbl_type,
126 x_clev_tbl OUT NOCOPY clev_tbl_type,
127 x_klev_tbl OUT NOCOPY klev_tbl_type,
128 x_cimv_tbl OUT NOCOPY cimv_tbl_type,
129 x_cplv_tbl OUT NOCOPY cplv_tbl_type);
130
131 PROCEDURE delete_contract_top_line(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_clev_tbl IN clev_tbl_type,
138 p_klev_tbl IN klev_tbl_type,
139 p_cimv_tbl IN cimv_tbl_type,
140 p_cplv_tbl IN cplv_tbl_type);
141
142 PROCEDURE validate_fee_expense_rule(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
149 p_line_id IN OKC_K_LINES_V.ID%TYPE,
150 p_no_of_period IN NUMBER,
151 p_frequency IN VARCHAR2,
152 p_amount_per_period IN NUMBER
153 );
154 PROCEDURE validate_passthru_rule(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_line_id IN OKC_K_LINES_V.ID%TYPE,
161 p_vendor_id IN NUMBER,
162 p_payment_term IN VARCHAR2,
163 p_payment_term_id IN NUMBER,
164 p_pay_to_site IN VARCHAR2,
165 p_pay_to_site_id IN NUMBER,
166 p_payment_method_code IN VARCHAR2,
167 x_payment_term_id1 OUT NOCOPY VARCHAR2,
168 x_pay_site_id1 OUT NOCOPY VARCHAR2,
169 x_payment_method_id1 OUT NOCOPY VARCHAR2
170 );
171
172 END OKL_CONTRACT_TOP_LINE_PVT;