[Home] [Help]
PACKAGE: APPS.OKS_SUBSCR_HDR_PUB
Source
1 PACKAGE OKS_SUBSCR_HDR_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPSBHS.pls 120.1 2006/09/11 22:36:55 jakuruvi noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 SUBTYPE schv_rec_type IS oks_subscr_hdr_pvt.schv_rec_type;
7 SUBTYPE schv_tbl_type IS oks_subscr_hdr_pvt.schv_tbl_type;
8 SUBTYPE sbh_rec_type IS oks_subscr_hdr_pvt.sbh_rec_type;
9 SUBTYPE sbh_tbl_type IS oks_subscr_hdr_pvt.sbh_tbl_type;
10 SUBTYPE oks_subscr_header_tl_rec_type IS oks_subscr_hdr_pvt.oks_subscr_header_tl_rec_type;
11 SUBTYPE oks_subscr_header_tl_tbl_type IS oks_subscr_hdr_pvt.oks_subscr_header_tl_tbl_type;
12
13 ---------------------------------------------------------------------------
14 -- GLOBAL MESSAGE CONSTANTS
15 ---------------------------------------------------------------------------
16 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
17 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
18 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
19 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
20 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
21 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
22 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
24 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
25 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
26 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
28 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL EXCEPTIONS
32 ---------------------------------------------------------------------------
33 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34
35 ---------------------------------------------------------------------------
36 -- GLOBAL VARIABLES
37 ---------------------------------------------------------------------------
38 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SUBSCR_HDR_PUB';
39 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
40 ---------------------------------------------------------------------------
41 -- Procedures and Functions
42 ---------------------------------------------------------------------------
43
44 PROCEDURE qc;
45 PROCEDURE change_version;
46 PROCEDURE api_copy;
47 PROCEDURE add_language;
48 PROCEDURE insert_row(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_schv_rec IN schv_rec_type,
55 x_schv_rec OUT NOCOPY schv_rec_type);
56 PROCEDURE insert_row(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_schv_tbl IN schv_tbl_type,
63 x_schv_tbl OUT NOCOPY schv_tbl_type,
64 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
65 PROCEDURE insert_row(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_schv_tbl IN schv_tbl_type,
72 x_schv_tbl OUT NOCOPY schv_tbl_type);
73 PROCEDURE lock_row(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_schv_rec IN schv_rec_type);
80 PROCEDURE lock_row(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_schv_tbl IN schv_tbl_type,
87 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
88 PROCEDURE lock_row(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_schv_tbl IN schv_tbl_type);
95 PROCEDURE update_row(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_schv_rec IN schv_rec_type,
102 x_schv_rec OUT NOCOPY schv_rec_type);
103 PROCEDURE update_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_schv_tbl IN schv_tbl_type,
110 x_schv_tbl OUT NOCOPY schv_tbl_type,
111 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
112 PROCEDURE update_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_schv_tbl IN schv_tbl_type,
119 x_schv_tbl OUT NOCOPY schv_tbl_type);
120 PROCEDURE delete_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_schv_rec IN schv_rec_type);
127 PROCEDURE delete_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_schv_tbl IN schv_tbl_type,
134 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135 PROCEDURE delete_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_schv_tbl IN schv_tbl_type);
142 PROCEDURE validate_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_schv_rec IN schv_rec_type);
149 PROCEDURE validate_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_schv_tbl IN schv_tbl_type,
156 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157 PROCEDURE validate_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_schv_tbl IN schv_tbl_type);
164 END OKS_SUBSCR_HDR_PUB;