APPS.OKL_SETUP_TRXPARAMS_PVT dependencies on OKL_SIF_TRX_PARMS

Line 5: -- PROCEDURE create_trx_parm for: OKL_SIF_TRX_PARMS_V

1: PACKAGE BODY OKL_SETUP_TRXPARAMS_PVT AS
2: /* $Header: OKLRTXRB.pls 115.1 2004/07/02 02:56:51 sgorantl noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE create_trx_parm for: OKL_SIF_TRX_PARMS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE create_trx_parm( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
9: x_return_status OUT NOCOPY VARCHAR2,

Line 21: FROM OKL_SIF_TRX_PARMS TRX

17:
18: CURSOR l_okl_sxp_index_csr(p_sxpv_rec sxpv_rec_type)
19: IS
20: SELECT NVL(MAX(INDEX_NUMBER1),0)
21: FROM OKL_SIF_TRX_PARMS TRX
22: WHERE TRX.SIF_ID = p_sxpv_rec.sif_id
23: AND TRX.SPP_ID = p_sxpv_rec.spp_id;
24:
25: l_okl_sxp_index_rec l_okl_sxp_index_csr%ROWTYPE;

Line 48: okl_sif_trx_parms_pub.insert_sif_trx_parms(p_api_version => p_api_version,

44: end if;
45:
46:
47: /* public api to insert streamtype */
48: okl_sif_trx_parms_pub.insert_sif_trx_parms(p_api_version => p_api_version,
49: p_init_msg_list => p_init_msg_list,
50: x_return_status => l_return_status,
51: x_msg_count => x_msg_count,
52: x_msg_data => x_msg_data,

Line 90: -- PROCEDURE update_trx_parm for: OKL_SIF_TRX_PARMS_V

86: end if;
87: END create_trx_parm;
88:
89: ---------------------------------------------------------------------------
90: -- PROCEDURE update_trx_parm for: OKL_SIF_TRX_PARMS_V
91: ---------------------------------------------------------------------------
92: PROCEDURE update_trx_parm(p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94: x_return_status OUT NOCOPY VARCHAR2,

Line 109: okl_sif_trx_parms_pub.update_sif_trx_parms(p_api_version => p_api_version,

105: BEGIN
106: l_sxpv_rec := p_sxpv_rec;
107:
108: /* public api to update formulae */
109: okl_sif_trx_parms_pub.update_sif_trx_parms(p_api_version => p_api_version,
110: p_init_msg_list => p_init_msg_list,
111: x_return_status => l_return_status,
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data,

Line 249: -- PROCEDURE delete_trx_parm for: OKL_SIF_TRX_PARMS_V

245:
246: END update_trx_parm;
247:
248: ---------------------------------------------------------------------------
249: -- PROCEDURE delete_trx_parm for: OKL_SIF_TRX_PARMS_V
250: ---------------------------------------------------------------------------
251: PROCEDURE delete_trx_parm(p_api_version IN NUMBER,
252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253: x_return_status OUT NOCOPY VARCHAR2,

Line 263: FROM OKL_SIF_TRX_PARMS

259:
260: CURSOR l_okl_sxp_csr(p_rec sxpv_rec_type)
261: IS
262: SELECT ID
263: FROM OKL_SIF_TRX_PARMS
264: WHERE SIF_ID = p_rec.sif_id
265: AND SPP_ID = p_rec.spp_id;
266:
267:

Line 306: okl_sif_trx_parms_pub.delete_sif_trx_parms(p_api_version => p_api_version,

302: END LOOP;
303:
304: IF l_sxpv_tbl.count > 0 THEN
305: /* public api to delete trxparms */
306: okl_sif_trx_parms_pub.delete_sif_trx_parms(p_api_version => p_api_version,
307: p_init_msg_list => p_init_msg_list,
308: x_return_status => l_return_status,
309: x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data,

Line 387: -- PROCEDURE create_trx_asset_parm for: OKL_SIF_TRX_PARMS_V

383: x_return_status := G_RET_STS_UNEXP_ERROR;
384: END delete_trx_parm;
385:
386: ---------------------------------------------------------------------------
387: -- PROCEDURE create_trx_asset_parm for: OKL_SIF_TRX_PARMS_V
388: ---------------------------------------------------------------------------
389: PROCEDURE create_trx_asset_parm( p_api_version IN NUMBER,
390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
391: x_return_status OUT NOCOPY VARCHAR2,

Line 442: -- PROCEDURE update_trx_asset_parm for: OKL_SIF_TRX_PARMS_V

438: x_return_status := G_RET_STS_UNEXP_ERROR;
439: END create_trx_asset_parm;
440:
441: ---------------------------------------------------------------------------
442: -- PROCEDURE update_trx_asset_parm for: OKL_SIF_TRX_PARMS_V
443: ---------------------------------------------------------------------------
444: PROCEDURE update_trx_asset_parm( p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
446: x_return_status OUT NOCOPY VARCHAR2,