[Home] [Help]
PACKAGE: APPS.OKL_PAY_INVOICES_MAN_PVT
Source
1 PACKAGE OKL_PAY_INVOICES_MAN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPIMS.pls 120.3 2006/11/17 11:57:56 zrehman noship $ */
3 ------------------------------------------------------------------------------
4 -- Global Variables
5 ------------------------------------------------------------------------------
6
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PAY_INVOICE_MAN';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
12 ------------------------------------------------------------------------------
13 -- Global Record Type
14 ------------------------------------------------------------------------------
15
16 TYPE man_inv_rec_type IS RECORD (
17 ipvs_id okl_trx_ap_invoices_b.ipvs_id%type
18 ,khr_id okl_trx_ap_invoices_b.khr_id%type
19 ,currency okl_trx_ap_invoices_b.currency_code%type
20 ,vendor_id okl_trx_ap_invoices_b.vendor_id%type
21 ,payment_method_code okl_trx_ap_invoices_b.payment_method_code%type
22 ,invoice_date DATE
23 ,pay_terms okl_trx_ap_invoices_b.ippt_id%type
24 ,invoice_number okl_trx_ap_invoices_b.invoice_number%type
25 ,invoice_category_code okl_trx_ap_invoices_b.invoice_category_code%type
26 ,invoice_type okl_trx_ap_invoices_b.invoice_type%type
27 ,amount okl_trx_ap_invoices_b.amount%type
28 ,sty_id okl_strm_type_b.id%type
29 ,Pay_Group_lookup_code okl_trx_ap_invoices_b.Pay_Group_lookup_code%type
30 ,Vendor_Invoice_Number okl_trx_ap_invoices_b.Vendor_Invoice_Number%type
31 ,sel_id okl_strm_elements.id%TYPE
32 ,legal_entity_id okl_trx_ap_invoices_b.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
33 );
34
35 g_miss_man_inv_rec man_inv_rec_type;
36
37 TYPE man_inv_tbl_type IS TABLE OF man_inv_rec_type
38 INDEX BY BINARY_INTEGER;
39
40 ---------------------------------------------------------------------------
41 -- Procedures and Functions
42 ---------------------------------------------------------------------------
43
44 PROCEDURE manual_entry(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_man_inv_rec IN man_inv_rec_type
50 ,x_man_inv_rec OUT NOCOPY man_inv_rec_type
51 );
52
53 PROCEDURE manual_entry(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_man_inv_tbl IN man_inv_tbl_type
59 ,x_man_inv_tbl OUT NOCOPY man_inv_tbl_type
60 );
61 END; -- Package spec