[Home] [Help]
PACKAGE: APPS.OKL_BPD_CAP_PURPOSE_PVT
Source
1 PACKAGE okl_bpd_cap_purpose_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRCPUS.pls 120.2 2005/10/30 04:02:23 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UPDT_CASH_DTLS';
9 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10
11
12 TYPE okl_cash_dtls_rec_type IS RECORD (
13 id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,
14 customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15 contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16 receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17 sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,
18 amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL
19 );
20
21
22
23 TYPE okl_cash_dtls_tbl_type IS TABLE OF okl_cash_dtls_rec_type
24 INDEX BY BINARY_INTEGER;
25
26 ---------------------------------------------------------------------------
27 -- Procedures and Functions
28 ---------------------------------------------------------------------------
29 ---------------------------------------------------------------------------
30 -- PROCEDURE create_purpose
31 ---------------------------------------------------------------------------
32 -- Start of comments
33 --
34 -- Procedure Name : create_purpose
35 -- Description : procedure for inserting the records in
36 -- table OKL_TXL_RCPT_APPS_B
37 -- Business Rules :
38 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
39 -- x_msg_data, p_strm_tbl, x_strm_tbl.
40 -- Version : 1.0
41 -- End of comments
42 ---------------------------------------------------------------------------
43
44 PROCEDURE create_purpose ( 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_strm_tbl IN okl_cash_dtls_tbl_type
50 ,x_strm_tbl OUT NOCOPY okl_cash_dtls_tbl_type
51 );
52 ---------------------------------------------------------------------------
53 -- PROCEDURE update_purpose
54 ---------------------------------------------------------------------------
55 -- Start of comments
56 --
57 -- Procedure Name : update_purpose
58 -- Description : procedure for updating the records in
59 -- table OKL_TXL_RCPT_APPS_B
60 -- Business Rules :
61 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
62 -- x_msg_data, p_strm_tbl, x_strm_tbl.
63 -- Version : 1.0
64 -- End of comments
65 ---------------------------------------------------------------------------
66
67 PROCEDURE update_purpose ( p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_strm_tbl IN okl_cash_dtls_tbl_type
73 ,x_strm_tbl OUT NOCOPY okl_cash_dtls_tbl_type
74 );
75
76 ---------------------------------------------------------------------------
77 -- PROCEDURE delete_purpose
78 ---------------------------------------------------------------------------
79 -- Start of comments
80 --
81 -- Procedure Name : delete_purpose
82 -- Description : procedure for deleting the records in
83 -- table OKL_TXL_RCPT_APPS_B
84 -- Business Rules :
85 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
86 -- x_msg_data, p_strm_tbl, x_strm_tbl.
87 -- Version : 1.0
88 -- End of comments
89 ---------------------------------------------------------------------------
90
91 PROCEDURE delete_purpose ( p_api_version IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 ,p_strm_tbl IN okl_cash_dtls_tbl_type
97 ,x_strm_tbl OUT NOCOPY okl_cash_dtls_tbl_type
98 );
99
100 END okl_bpd_cap_purpose_pvt;