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_RESULT_PUB dependencies on OKL_SIF_RETS

Line 43: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V

39:
40:
41:
42: ---------------------------------------------------------------------------
43: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
44: ---------------------------------------------------------------------------
45: PROCEDURE populate_sif_rets(p_api_version IN NUMBER := 1.0,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,

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

46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

48: x_id OUT NOCOPY NUMBER,
49: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
50: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
51: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
52: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
53: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
54: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
55: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
56: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 178: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V

174: END populate_sif_rets;
175:
176: -- mvasudev , 04/24/2002
177: ---------------------------------------------------------------------------
178: -- PROCEDURE populate_sif_rets for: OKL_SIF_RETS_V
179: ---------------------------------------------------------------------------
180: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

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

179: ---------------------------------------------------------------------------
180: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

181: x_id OUT NOCOPY NUMBER,
182: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
183: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
184: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
185: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
186: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
187: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
188: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
189: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

319: x_id OUT NOCOPY NUMBER,
320: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
321: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
322: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
323: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
324: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
325: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
326: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
327: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

453:
454: PROCEDURE populate_sif_rets(x_return_status OUT NOCOPY VARCHAR2,
455: x_id OUT NOCOPY NUMBER,
456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

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

455: x_id OUT NOCOPY NUMBER,
456: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
457: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
458: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
459: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
460: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
461: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
462: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
463: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 1882: FROM Okl_Sif_Rets

1878:
1879: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1880: SELECT
1881: ID
1882: FROM Okl_Sif_Rets
1883: WHERE okl_sif_rets.transaction_number = trx_number;
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: lp_sifv_rec sifv_rec_type;

Line 1883: WHERE okl_sif_rets.transaction_number = trx_number;

1879: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1880: SELECT
1881: ID
1882: FROM Okl_Sif_Rets
1883: WHERE okl_sif_rets.transaction_number = trx_number;
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: lp_sifv_rec sifv_rec_type;
1887: lx_sifv_rec sifv_rec_type;

Line 1974: FROM Okl_Sif_Rets

1970:
1971: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1972: SELECT
1973: ID
1974: FROM Okl_Sif_Rets
1975: WHERE okl_sif_rets.transaction_number = trx_number;
1976:
1977: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1978: lp_sifv_rec sifv_rec_type;

Line 1975: WHERE okl_sif_rets.transaction_number = trx_number;

1971: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1972: SELECT
1973: ID
1974: FROM Okl_Sif_Rets
1975: WHERE okl_sif_rets.transaction_number = trx_number;
1976:
1977: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1978: lp_sifv_rec sifv_rec_type;
1979: lx_sifv_rec sifv_rec_type;