DBA Data[Home] [Help]

PACKAGE: APPS.OKL_BPD_CAP_PURPOSE_PUB

Source


1 PACKAGE Okl_Bpd_Cap_Purpose_Pub AUTHID CURRENT_USER AS
2  /* $Header: OKLPCPUS.pls 120.2 2005/10/30 04:01:32 appldev noship $ */
3  SUBTYPE okl_cash_dtls_rec_type IS okl_bpd_cap_purpose_pvt.okl_cash_dtls_rec_type;
4  SUBTYPE okl_cash_dtls_tbl_type IS okl_bpd_cap_purpose_pvt.okl_cash_dtls_tbl_type;
5 
6  -----------------------------------------------------------------------------
7   --Global Exception
8  ------------------------------------------------------------------------------
9   G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10  ------------------------------------------------------------------------------
11 
12  --Object type procedure for update
13 ---------------------------------------------------------------------------
14 -- PROCEDURE create_purpose
15 ---------------------------------------------------------------------------
16   -- Start of comments
17   --
18   -- Procedure Name  : create_purpose
19   -- Description     : procedure for inserting the records in
20   --                   table OKL_TXL_RCPT_APPS_B
21   -- Business Rules  :
22   -- Parameters      : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
23   --                   x_msg_data, p_strm_tbl, x_strm_tbl.
24   -- Version         : 1.0
25   -- End of comments
26   ---------------------------------------------------------------------------
27 
28 
29  PROCEDURE create_purpose      ( p_api_version      IN  NUMBER
30                                 ,p_init_msg_list    IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
31                                 ,x_return_status    OUT NOCOPY VARCHAR2
32                                 ,x_msg_count        OUT NOCOPY NUMBER
33                                 ,x_msg_data         OUT NOCOPY VARCHAR2
34                                 ,p_strm_tbl         IN  okl_cash_dtls_tbl_type
35                                 ,x_strm_tbl         OUT NOCOPY okl_cash_dtls_tbl_type
36                                );
37 ---------------------------------------------------------------------------
38 -- PROCEDURE update_purpose
39 ---------------------------------------------------------------------------
40   -- Start of comments
41   --
42   -- Procedure Name  : update_purpose
43   -- Description     : procedure for updating the records in
44   --                   table OKL_TXL_RCPT_APPS_B
45   -- Business Rules  :
46   -- Parameters      : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
47   --                   x_msg_data, p_strm_tbl, x_strm_tbl.
48   -- Version         : 1.0
49   -- End of comments
50   ---------------------------------------------------------------------------
51 
52 
53  PROCEDURE update_purpose      ( 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_strm_tbl         IN  okl_cash_dtls_tbl_type
59                                 ,x_strm_tbl         OUT NOCOPY okl_cash_dtls_tbl_type
60                                );
61 
62 ---------------------------------------------------------------------------
63 -- PROCEDURE delete_purpose
64 ---------------------------------------------------------------------------
65   -- Start of comments
66   --
67   -- Procedure Name  : delete_purpose
68   -- Description     : procedure for deleting the records in
69   --                   table OKL_TXL_RCPT_APPS_B
70   -- Business Rules  :
71   -- Parameters      : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
72   --                   x_msg_data, p_strm_tbl, x_strm_tbl.
73   -- Version         : 1.0
74   -- End of comments
75   ---------------------------------------------------------------------------
76 
77 
78  PROCEDURE delete_purpose      ( p_api_version      IN  NUMBER
79                                 ,p_init_msg_list    IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
80                                 ,x_return_status    OUT NOCOPY VARCHAR2
81                                 ,x_msg_count        OUT NOCOPY NUMBER
82                                 ,x_msg_data         OUT NOCOPY VARCHAR2
83                                 ,p_strm_tbl         IN  okl_cash_dtls_tbl_type
84                                 ,x_strm_tbl         OUT NOCOPY okl_cash_dtls_tbl_type
85                                );
86 
87 END Okl_Bpd_Cap_Purpose_Pub;