[Home] [Help]
PACKAGE: APPS.OKL_SUBSIDY_RFND_DTLS_PVT
Source
1 PACKAGE OKL_SUBSIDY_RFND_DTLS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSRFS.pls 115.0 2004/01/08 21:07:47 ramurt noship $ */
3
4 subtype srfdv_rec_type is okl_pyd_pvt.ppyd_rec_type;
5 subtype srfdv_tbl_type is okl_pyd_pvt.ppyd_tbl_type;
6 subtype srfvv_rec_type is okl_pyd_pvt.ppydv_rec_type;
7 subtype srfvv_tbl_type is okl_pyd_pvt.ppydv_tbl_type;
8
9 ---------------------------------------------------------------------------
10 -- GLOBAL MESSAGE CONSTANTS
11 ---------------------------------------------------------------------------
12 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
13 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
14 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
15 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
16 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
17 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
18 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
19 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
20 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
21 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
23 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25
26 ---------------------------------------------------------------------------
27 -- GLOBAL EXCEPTIONS
28 ---------------------------------------------------------------------------
29 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
30
31 ---------------------------------------------------------------------------
32 -- GLOBAL VARIABLES
33 ---------------------------------------------------------------------------
34 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUBSIDY_RFND_DTLS_PVT';
35 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
36 ---------------------------------------------------------------------------
37 -- Procedures and Functions
38 ---------------------------------------------------------------------------
39
40 PROCEDURE create_refund_dtls(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_srfvv_rec IN srfvv_rec_type,
47 x_srfvv_rec OUT NOCOPY srfvv_rec_type);
48
49 PROCEDURE create_refund_dtls(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_srfvv_tbl IN srfvv_tbl_type,
56 x_srfvv_tbl OUT NOCOPY srfvv_tbl_type);
57
58 PROCEDURE lock_refund_dtls(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_srfvv_rec IN srfvv_rec_type);
65
66 PROCEDURE lock_refund_dtls(
67 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_srfvv_tbl IN srfvv_tbl_type);
73
74 PROCEDURE update_refund_dtls(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_srfvv_rec IN srfvv_rec_type,
81 x_srfvv_rec OUT NOCOPY srfvv_rec_type);
82
83 PROCEDURE update_refund_dtls(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_srfvv_tbl IN srfvv_tbl_type,
90 x_srfvv_tbl OUT NOCOPY srfvv_tbl_type);
91
92 PROCEDURE delete_refund_dtls(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_srfvv_rec IN srfvv_rec_type);
99
100 PROCEDURE delete_refund_dtls(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_srfvv_tbl IN srfvv_tbl_type);
107
108 PROCEDURE validate_refund_dtls(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_srfvv_rec IN srfvv_rec_type);
115
116 PROCEDURE validate_refund_dtls(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_srfvv_tbl IN srfvv_tbl_type);
123
124 END OKL_SUBSIDY_RFND_DTLS_PVT;