[Home] [Help]
PACKAGE: APPS.OKS_TEMPLATE_SET_PUB
Source
1 PACKAGE OKS_TEMPLATE_SET_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPTMPS.pls 120.1 2005/07/14 16:52:31 skekkar noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_TEMPLATE_SET_V Record Spec
7 SUBTYPE tmsv_rec_type IS OKS_TEMPLATE_SET_PVT.tmsv_rec_type;
8 SUBTYPE tmsv_tbl_type IS OKS_TEMPLATE_SET_PVT.tmsv_tbl_type;
9 SUBTYPE tms_rec_type IS OKS_TEMPLATE_SET_PVT.tms_rec_type;
10 SUBTYPE tms_tbl_type IS OKS_TEMPLATE_SET_PVT.tms_tbl_type;
11 ---------------------------------------------------------------------------
12 ---------------------------------------------------------------------------
13 -- GLOBAL MESSAGE CONSTANTS
14 ---------------------------------------------------------------------------
15 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
16 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
17 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
18 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
19 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
26 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
27 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
28
29 ---------------------------------------------------------------------------
30 -- GLOBAL EXCEPTIONS
31 ---------------------------------------------------------------------------
32 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
33
34 ---------------------------------------------------------------------------
35 -- GLOBAL VARIABLES
36 ---------------------------------------------------------------------------
37 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_TEMPLATE_SET_PUB';
38 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
39 ---------------------------------------------------------------------------
40 -- Procedures and Functions
41 ---------------------------------------------------------------------------
42
43 PROCEDURE qc;
44 PROCEDURE change_version;
45 PROCEDURE api_copy;
46 PROCEDURE insert_row(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_tmsv_rec IN tmsv_rec_type,
53 x_tmsv_rec OUT NOCOPY tmsv_rec_type);
54 PROCEDURE insert_row(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_tmsv_tbl IN tmsv_tbl_type,
61 x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
62 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
63 PROCEDURE insert_row(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_tmsv_tbl IN tmsv_tbl_type,
70 x_tmsv_tbl OUT NOCOPY tmsv_tbl_type);
71 PROCEDURE lock_row(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_tmsv_rec IN tmsv_rec_type);
78 PROCEDURE lock_row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_tmsv_tbl IN tmsv_tbl_type,
85 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
86 PROCEDURE lock_row(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_tmsv_tbl IN tmsv_tbl_type);
93 PROCEDURE update_row(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_tmsv_rec IN tmsv_rec_type,
100 x_tmsv_rec OUT NOCOPY tmsv_rec_type);
101 PROCEDURE update_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_tmsv_tbl IN tmsv_tbl_type,
108 x_tmsv_tbl OUT NOCOPY tmsv_tbl_type,
109 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
110 PROCEDURE update_row(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_tmsv_tbl IN tmsv_tbl_type,
117 x_tmsv_tbl OUT NOCOPY tmsv_tbl_type);
118 PROCEDURE delete_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_tmsv_rec IN tmsv_rec_type);
125 PROCEDURE delete_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_tmsv_tbl IN tmsv_tbl_type,
132 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
133 PROCEDURE delete_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_tmsv_tbl IN tmsv_tbl_type);
140 PROCEDURE validate_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_tmsv_rec IN tmsv_rec_type);
147 PROCEDURE validate_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_tmsv_tbl IN tmsv_tbl_type,
154 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
155 PROCEDURE validate_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_tmsv_tbl IN tmsv_tbl_type);
162
163 PROCEDURE get_template_set_dtls
164 (
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 p_contract_id IN NUMBER,
168 p_document_type IN VARCHAR2,
169 p_report_duration IN NUMBER DEFAULT NULL,
170 p_report_period IN VARCHAR2 DEFAULT NULL,
171 x_template_language OUT NOCOPY VARCHAR2,
172 x_message_template_id OUT NOCOPY NUMBER,
173 x_attachment_template_id OUT NOCOPY NUMBER,
174 x_attachment_name OUT NOCOPY VARCHAR2,
175 x_contract_update_status OUT NOCOPY VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER
179 );
180
181 END OKS_TEMPLATE_SET_PUB;