eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POPULATE_PRCENG_RST_PUB dependencies on OKL_SIF_RETS

Line 52: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V

48: --Added by BKATRAGA.
49: --This procedure is used in the populate_sif_ret_strms procedure prior to the bulk insert call.
50:
51: ---------------------------------------------------------------------------
52: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
53: ---------------------------------------------------------------------------
54: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,

Line 59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

57: x_id OUT NOCOPY NUMBER,
58: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
59: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
61: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
62: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
63: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
64: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
65: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 215: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V

211: END populate_sif_rets;
212:
213: -- mvasudev , 04/24/2002
214: ---------------------------------------------------------------------------
215: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
216: ---------------------------------------------------------------------------
217: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

216: ---------------------------------------------------------------------------
217: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

218: x_id OUT NOCOPY NUMBER,
219: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
220: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
221: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
222: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
223: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
224: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
225: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
226: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

383: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384: x_return_status OUT NOCOPY VARCHAR2,
385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

385: x_id OUT NOCOPY NUMBER,
386: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
387: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
388: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
389: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
390: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
391: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
392: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
393: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

547:
548: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
549: x_id OUT NOCOPY NUMBER,
550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

549: x_id OUT NOCOPY NUMBER,
550: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
551: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
552: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
553: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
554: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
555: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
556: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
557: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 2448: FROM Okl_Sif_Rets

2444:
2445: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2446: SELECT
2447: ID
2448: FROM Okl_Sif_Rets
2449: WHERE okl_sif_rets.transaction_number = trx_number;
2450:
2451: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2452: lp_sifv_rec sifv_rec_type;

Line 2449: WHERE okl_sif_rets.transaction_number = trx_number;

2445: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2446: SELECT
2447: ID
2448: FROM Okl_Sif_Rets
2449: WHERE okl_sif_rets.transaction_number = trx_number;
2450:
2451: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2452: lp_sifv_rec sifv_rec_type;
2453: lx_sifv_rec sifv_rec_type;

Line 2540: FROM Okl_Sif_Rets

2536:
2537: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2538: SELECT
2539: ID
2540: FROM Okl_Sif_Rets
2541: WHERE okl_sif_rets.transaction_number = trx_number;
2542:
2543: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2544: lp_sifv_rec sifv_rec_type;

Line 2541: WHERE okl_sif_rets.transaction_number = trx_number;

2537: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2538: SELECT
2539: ID
2540: FROM Okl_Sif_Rets
2541: WHERE okl_sif_rets.transaction_number = trx_number;
2542:
2543: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2544: lp_sifv_rec sifv_rec_type;
2545: lx_sifv_rec sifv_rec_type;