[Home] [Help]
PACKAGE: APPS.OKL_CREDIT_MEMO_PVT
Source
1 PACKAGE OKL_CREDIT_MEMO_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCRMS.pls 120.4 2007/04/20 19:08:57 apaul noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 --Added credit_date as an addtnl parameter to the table of records.
8 TYPE credit_rec IS RECORD (lsm_id NUMBER,
9 -- 5897792 Start
10 transaction_source VARCHAR2(50),
11 source_trx_number VARCHAR2(50),
12 -- 5897792 End
13 credit_amount NUMBER,
14 credit_sty_id NUMBER,
15 credit_try_name VARCHAR2(150) DEFAULT 'Credit Memo',
16 credit_desc VARCHAR2(2000),
17 credit_date DATE DEFAULT SYSDATE,
18 currency_code VARCHAR2(30));
19
20 TYPE credit_tbl IS TABLE OF credit_rec INDEX BY BINARY_INTEGER;
21
22
23 SUBTYPE taiv_rec_type IS okl_trx_ar_invoices_pub.taiv_rec_type;
24 SUBTYPE taiv_tbl_type IS okl_trx_ar_invoices_pub.taiv_tbl_type;
25
26
27 ---------------------------------------------------------------------------
28 -- GLOBAL CONSTANTS
29 ---------------------------------------------------------------------------
30 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREDIT_MEMO_PVT';
31 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
32 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
33 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
34 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
35
36
37 ---------------------------------------------------------------------------
38 -- Procedures and Functions
39 ---------------------------------------------------------------------------
40 PROCEDURE insert_request(p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2,
42 --p_lsm_id IN NUMBER,
43 p_tld_id IN NUMBER,
44 p_credit_amount IN NUMBER,
45 p_credit_sty_id IN NUMBER,
46 p_credit_desc IN VARCHAR2,
47 p_credit_date IN DATE,
48 p_try_id IN NUMBER,
49 -- Bug 5897792 Start
50 p_transaction_source IN VARCHAR2 DEFAULT NULL,
51 p_source_trx_number IN VARCHAR2 DEFAULT NULL,
52 -- Bug 5897792 End
53 x_tai_id OUT NOCOPY NUMBER,
54 x_taiv_rec OUT NOCOPY taiv_rec_type,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2);
58
59
60 PROCEDURE insert_request(p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 p_credit_list IN credit_tbl,
63 -- Bug 5897792 Start
64 p_transaction_source IN VARCHAR2 DEFAULT NULL,
65 p_source_trx_number IN VARCHAR2 DEFAULT NULL,
66 -- Bug 5897792 End
67 x_taiv_tbl OUT NOCOPY taiv_tbl_type,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2);
71
72 --rkuttiya added for bug #4341480
73 PROCEDURE insert_on_acc_cm_request(p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2,
75 -- Bug 5897792 Start
76 --p_lsm_id IN NUMBER,
77 p_tld_id IN NUMBER,
78 -- Bug 5897792 End
79 p_credit_amount IN NUMBER,
80 p_credit_sty_id IN NUMBER,
81 p_credit_desc IN VARCHAR2,
82 p_credit_date IN DATE,
83 p_try_id IN NUMBER,
84 -- Bug 5897792 Start
85 p_transaction_source IN VARCHAR2 DEFAULT NULL,
86 p_source_trx_number IN VARCHAR2 DEFAULT NULL,
87 -- Bug 5897792 End
88 x_tai_id OUT NOCOPY NUMBER,
89 x_taiv_rec OUT NOCOPY taiv_rec_type,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2);
93 -- end fix for bug #4341480
94
95 END okl_credit_memo_pvt;