[Home] [Help]
PACKAGE: APPS.OKL_CS_TRANSACTIONS_PVT
Source
1 PACKAGE okl_cs_transactions_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRBFNS.pls 120.2 2008/02/22 10:00:50 dkagrawa ship $ */
3
4 ---------------------------------------------------------------------------
5 -- DATA TYPES
6 ---------------------------------------------------------------------------
7
8 TYPE SVF_INFO_REC IS RECORD (SVF_ID NUMBER := NULL,
9 SVF_NAME VARCHAR2(80) := NULL,
10 SVF_AMOUNT NUMBER(14,3) := NULL,
11 SVF_DESC VARCHAR2(1995) := NULL);
12
13 TYPE SVF_INFO_TBL IS TABLE OF SVF_INFO_REC INDEX BY BINARY_INTEGER;
14
15 ---------------------------------------------------------------------------
16 -- GLOBAL CONSTANTS
17 ---------------------------------------------------------------------------
18 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CS_TRANSACTIONS_PVT';
19 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
20 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
23
24 ---------------------------------------------------------------------------
25 -- Procedures and Functions
26 ---------------------------------------------------------------------------
27 PROCEDURE get_totals (p_select IN VARCHAR2,
28 p_from IN VARCHAR2,
29 p_where IN VARCHAR2,
30 x_inv_total OUT NOCOPY NUMBER,
31 x_rec_total OUT NOCOPY NUMBER,
32 x_due_total OUT NOCOPY NUMBER,
33 x_credit_total OUT NOCOPY NUMBER,
34 x_adjust_total OUT NOCOPY NUMBER,
35 x_row_count OUT NOCOPY NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2);
39
40
41 PROCEDURE get_svf_info (p_khr_id IN NUMBER,
42 p_svf_code IN VARCHAR2,
43 x_svf_info_rec OUT NOCOPY svf_info_rec,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2);
47
48 PROCEDURE get_credit_memo_info(p_khr_id IN NUMBER,
49 p_tai_id IN NUMBER,
50 x_trx_type OUT NOCOPY VARCHAR2,
51 x_inv_num OUT NOCOPY NUMBER,
52 x_trx_date OUT NOCOPY DATE,
53 x_trx_amount OUT NOCOPY NUMBER,
54 x_amnt_app OUT NOCOPY NUMBER,
55 x_amnt_due OUT NOCOPY NUMBER,
56 x_crd_amnt OUT NOCOPY NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2);
60
61
62 PROCEDURE check_process_template (p_ptm_code IN VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67
68 PROCEDURE get_pvt_label_email (p_khr_id IN NUMBER,
69 x_email OUT NOCOPY VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74
75 PROCEDURE create_svf_invoice (p_khr_id IN NUMBER,
76 p_sty_name IN VARCHAR2,
77 p_svf_code IN VARCHAR2,
78 p_svf_amount IN NUMBER,
79 p_svf_desc IN VARCHAR2 DEFAULT NULL,
80 p_syndication_code IN VARCHAR2 DEFAULT NULL,
81 p_factoring_code IN VARCHAR2 DEFAULT NULL,
82 x_tai_id OUT NOCOPY NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2);
86
87
88 END okl_cs_transactions_pvt;