APPS.OKL_XMLP_PARAMS_PVT dependencies on OKL_XMLP_PARAMS

Line 1: PACKAGE OKL_XMLP_PARAMS_PVT AS

1: PACKAGE OKL_XMLP_PARAMS_PVT AS
2: /* $Header: OKLRXMPS.pls 120.1 2007/01/04 14:51:29 udhenuko noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ---------------------------------------------------------------------------

Line 8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XMLP_PARAMS_PVT';

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_XMLP_PARAMS_PVT';
9: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
10: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11:
12:

Line 25: -- table OKL_XMLP_PARAMS

21: -- Start of comments
22: --
23: -- Procedure Name : create_xmlp_params_rec
24: -- Description : procedure for inserting the records in
25: -- table OKL_XMLP_PARAMS
26: -- Business Rules : This procedure creates a record containing the parameter
27: -- name, value and type code. x_return_status is 'S' on success.
28: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
29: -- x_msg_data, p_xmp_rec, x_xmp_rec.

Line 49: -- table OKL_XMLP_PARAMS

45: -- Start of comments
46: --
47: -- Procedure Name : create_xmlp_params_tbl
48: -- Description : procedure for inserting the records in
49: -- table OKL_XMLP_PARAMS
50: -- Business Rules : This procedure creates a record containing the parameter
51: -- name, value and type code. x_return_status is 'S' on success.
52: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
53: -- x_msg_data, p_xmp_tbl, x_xmp_tbl.

Line 73: -- table OKL_XMLP_PARAMS

69: -- Start of comments
70: --
71: -- Procedure Name : update_xmlp_params_rec
72: -- Description : procedure for updating the records in
73: -- table OKL_XMLP_PARAMS
74: -- Business Rules : This procedure updates a record based on the id provided.
75: -- x_return_status is 'S' on success.
76: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
77: -- x_msg_data, p_xmp_rec, x_xmp_rec.

Line 97: -- table OKL_XMLP_PARAMS

93: -- Start of comments
94: --
95: -- Procedure Name : update_xmlp_params_tbl
96: -- Description : procedure for updating the records in
97: -- table OKL_XMLP_PARAMS
98: -- Business Rules : This procedure updates a record based on the id provided.
99: -- x_return_status is 'S' on success.
100: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
101: -- x_msg_data, p_xmp_tbl, x_xmp_tbl.

Line 121: -- table OKL_XMLP_PARAMS

117: -- Start of comments
118: --
119: -- Procedure Name : delete_xmlp_params_rec
120: -- Description : procedure for deleting the records in
121: -- table OKL_XMLP_PARAMS
122: -- Business Rules : This procedure deletes a record based on the id provided.
123: -- x_return_status is 'S' on success.
124: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
125: -- x_msg_data, p_xmp_rec, x_xmp_rec.

Line 134: ,p_batch_id IN OKL_XMLP_PARAMS.Batch_Id%TYPE

130: ,p_init_msg_list IN VARCHAR2
131: ,x_return_status OUT NOCOPY VARCHAR2
132: ,x_msg_count OUT NOCOPY NUMBER
133: ,x_msg_data OUT NOCOPY VARCHAR2
134: ,p_batch_id IN OKL_XMLP_PARAMS.Batch_Id%TYPE
135: );
136:
137:
138: ---------------------------------------------------------------------------

Line 145: -- table OKL_XMLP_PARAMS

141: -- Start of comments
142: --
143: -- Procedure Name : validate_xmlp_params_rec
144: -- Description : procedure for validating the records in
145: -- table OKL_XMLP_PARAMS
146: -- Business Rules : Validates the record passed to it. x_return_status is 'S' on success.
147: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
148: -- x_msg_data, p_xmp_rec.
149: -- Version : 1.0

Line 167: -- table OKL_XMLP_PARAMS

163: -- Start of comments
164: --
165: -- Procedure Name : validate_xmlp_params_tbl
166: -- Description : procedure for validating the records in
167: -- table OKL_XMLP_PARAMS
168: -- Business Rules : Validates the records passed to it. x_return_status is 'S' on success.
169: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
170: -- x_msg_data, p_xmp_tbl.
171: -- Version : 1.0

Line 182: END OKL_XMLP_PARAMS_PVT;

178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_xmp_tbl IN xmp_tbl_type);
181:
182: END OKL_XMLP_PARAMS_PVT;