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