[Home] [Help]
PACKAGE: APPS.OKL_SETUPDSFPARAMETERS_PVT
Source
1 PACKAGE OKL_SETUPDSFPARAMETERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSFRS.pls 120.1 2005/06/03 05:31:21 rirawat noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_SEQUENCE_NUMBER CONSTANT VARCHAR2(200) := 'OKL_SEQUENCE_NUMBER';
9
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12 G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
13
14 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
15 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPDSFPARAMETERS_PVT';
16 G_PCT_TYPE CONSTANT VARCHAR2(30) := 'CONTEXT'; -- parameter context
17 G_PSC_TYPE CONSTANT VARCHAR2(30) := 'STATIC'; -- parameter static
18
19 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
20
21 SUBTYPE dsfv_rec_type IS okl_data_src_fnctns_pub.dsfv_rec_type;
22 SUBTYPE dsfv_tbl_type IS okl_data_src_fnctns_pub.dsfv_tbl_type;
23
24 SUBTYPE fprv_rec_type IS okl_fnctn_prmtrs_pub.fprv_rec_type;
25 SUBTYPE fprv_tbl_type IS okl_fnctn_prmtrs_pub.fprv_tbl_type;
26
27 PROCEDURE get_rec(
28 p_fprv_rec IN fprv_rec_type,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_no_data_found OUT NOCOPY BOOLEAN,
31 x_fprv_rec OUT NOCOPY fprv_rec_type);
32
33 PROCEDURE insert_dsfparameters(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_dsfv_rec IN dsfv_rec_type,
40 p_fprv_rec IN fprv_rec_type,
41 x_fprv_rec OUT NOCOPY fprv_rec_type);
42
43 PROCEDURE update_dsfparameters(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_dsfv_rec IN dsfv_rec_type,
50 p_fprv_rec IN fprv_rec_type,
51 x_fprv_rec OUT NOCOPY fprv_rec_type);
52
53 PROCEDURE delete_dsfparameters(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_fprv_tbl IN fprv_tbl_type);
60
61 -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : begin
62 PROCEDURE insert_dsfparameters(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_dsfv_rec IN dsfv_rec_type,
69 p_fprv_tbl IN fprv_tbl_type,
70 x_fprv_tbl OUT NOCOPY fprv_tbl_type);
71 -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end
72
73 -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : begin
74 PROCEDURE update_dsfparameters(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_dsfv_rec IN dsfv_rec_type,
81 p_fprv_tbl IN fprv_tbl_type,
82 x_fprv_tbl OUT NOCOPY fprv_tbl_type);
83 -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : end
84
85
86 END OKL_SETUPDSFPARAMETERS_PVT;