[Home] [Help]
7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPDSFPARAMETERS_PUB';
13:
14: SUBTYPE dsfv_rec_type IS okl_setupdsfparameters_pvt.dsfv_rec_type;
15: SUBTYPE dsfv_tbl_type IS okl_setupdsfparameters_pvt.dsfv_tbl_type;
25: x_fprv_rec OUT NOCOPY fprv_rec_type);
26:
27: PROCEDURE insert_dsfparameters(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_dsfv_rec IN dsfv_rec_type,
35: x_fprv_rec OUT NOCOPY fprv_rec_type);
36:
37: PROCEDURE update_dsfparameters(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_dsfv_rec IN dsfv_rec_type,
54:
55: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : begin
56: PROCEDURE insert_dsfparameters(
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_dsfv_rec IN dsfv_rec_type,
66:
67: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FNCTN_PRMTRS_V - TBL : begin
68: PROCEDURE update_dsfparameters(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_dsfv_rec IN dsfv_rec_type,