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