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_CREATE_STREAMS_PVT dependencies on OKC_API

Line 341: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

337: END IF;
338: RETURN l_deal_type;
339: END get_deal_type;
340: BEGIN
341: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
342: lp_sifv_rec.khr_id := p_lease_header_rec.khr_id;
343: lp_sifv_rec.sif_mode := p_lease_header_rec.sif_mode;
344: lp_sifv_rec.country := p_lease_header_rec.country;
345:

Line 402: AND (p_lease_header_rec.Jtot_Object1_Code IS NULL OR p_lease_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)

398: -- Mandatory Checks moved here from TAPI(OKL_SIF_PVT) to get rid of
399: -- cyclic dependancy of OKL_SIF_PVT with OKL_INVOKE_PRICING_ENGINE_PVT
400:
401: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
402: AND (p_lease_header_rec.Jtot_Object1_Code IS NULL OR p_lease_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)
403: THEN
404: lp_sifv_rec.jtot_object1_code := p_lease_header_rec.jtot_object1_code;
405: /* smahapat for fee type soln
406: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

Line 411: x_return_status := Okc_Api.G_RET_STS_ERROR;

407: p_msg_name => G_REQUIRED_VALUE,
408: p_token1 => G_COL_NAME_TOKEN,
409: p_token1_value => 'JTOT_OBJECT1_CODE'
410: );
411: x_return_status := Okc_Api.G_RET_STS_ERROR;
412: RAISE G_EXCEPTION_ERROR;
413:
414: */
415: ELSE

Line 419: AND (p_lease_header_rec.object1_id1 IS NULL OR p_lease_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)

415: ELSE
416: lp_sifv_rec.jtot_object1_code := p_lease_header_rec.jtot_object1_code;
417: END IF;
418: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
419: AND (p_lease_header_rec.object1_id1 IS NULL OR p_lease_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)
420: THEN
421: lp_sifv_rec.object1_id1 := p_lease_header_rec.object1_id1;
422: /* smahapat for fee type soln
423: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

Line 428: x_return_status := Okc_Api.G_RET_STS_ERROR;

424: p_msg_name => G_REQUIRED_VALUE,
425: p_token1 => G_COL_NAME_TOKEN,
426: p_token1_value => 'OBJECT1_ID1'
427: );
428: x_return_status := Okc_Api.G_RET_STS_ERROR;
429: RAISE G_EXCEPTION_ERROR;
430: */
431: ELSE
432: lp_sifv_rec.object1_id1 := p_lease_header_rec.object1_id1;

Line 452: x_return_status := Okc_Api.G_RET_STS_ERROR;

448: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
449: p_msg_name => G_REQUIRED_VALUE,
450: p_token1 => G_COL_NAME_TOKEN,
451: p_token1_value => 'SIF_ID');
452: x_return_status := Okc_Api.G_RET_STS_ERROR;
453: RAISE G_EXCEPTION_ERROR;
454: END IF;
455: END LOOP;
456: END IF;

Line 583: AND (p_loan_header_rec.Jtot_Object1_Code IS NULL OR p_loan_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)

579: -- mvasudev , 07/08/2002
580: -- Mandatory Checks moved here from TAPI(OKL_SIF_PVT) to get rid of
581: -- cyclic dependancy of OKL_SIF_PVT with OKL_INVOKE_PRICING_ENGINE_PVT
582: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
583: AND (p_loan_header_rec.Jtot_Object1_Code IS NULL OR p_loan_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)
584: THEN
585: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
586: p_msg_name => G_REQUIRED_VALUE,
587: p_token1 => G_COL_NAME_TOKEN,

Line 590: x_return_status := Okc_Api.G_RET_STS_ERROR;

586: p_msg_name => G_REQUIRED_VALUE,
587: p_token1 => G_COL_NAME_TOKEN,
588: p_token1_value => 'JTOT_OBJECT1_CODE'
589: );
590: x_return_status := Okc_Api.G_RET_STS_ERROR;
591: RAISE G_EXCEPTION_ERROR;
592: ELSE
593: lp_sifv_rec.jtot_object1_code := p_loan_header_rec.jtot_object1_code;
594: END IF;

Line 596: AND (p_loan_header_rec.object1_id1 IS NULL OR p_loan_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)

592: ELSE
593: lp_sifv_rec.jtot_object1_code := p_loan_header_rec.jtot_object1_code;
594: END IF;
595: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
596: AND (p_loan_header_rec.object1_id1 IS NULL OR p_loan_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)
597: THEN
598: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
599: p_msg_name => G_REQUIRED_VALUE,
600:

Line 604: x_return_status := Okc_Api.G_RET_STS_ERROR;

600:
601: p_token1 => G_COL_NAME_TOKEN,
602: p_token1_value => 'OBJECT1_ID1'
603: );
604: x_return_status := Okc_Api.G_RET_STS_ERROR;
605: RAISE G_EXCEPTION_ERROR;
606: ELSE
607: lp_sifv_rec.object1_id1 := p_loan_header_rec.object1_id1;
608: END IF;

Line 628: x_return_status := Okc_Api.G_RET_STS_ERROR;

624: p_msg_name => G_REQUIRED_VALUE,
625:
626: p_token1 => G_COL_NAME_TOKEN,
627: p_token1_value => 'SIF_ID');
628: x_return_status := Okc_Api.G_RET_STS_ERROR;
629: RAISE G_EXCEPTION_ERROR;
630: END IF;
631: END LOOP;
632: END IF;

Line 691: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

687:
688: lp_silv_rec silv_rec_type;
689: lx_silv_rec silv_rec_type;
690: i NUMBER := 0;
691: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
692: l_index NUMBER := -1;
693: BEGIN
694: l_return_status := G_RET_STS_SUCCESS;
695:

Line 845: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

841: sec_dep_index NUMBER := 0;
842: subsidy_index NUMBER := 0;
843: s_count NUMBER := 0;
844: BEGIN
845: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
846:
847: --sechawla 10-jul-09 PRB ESG enhancements : begin
848: OPEN get_rebook_type;
849: FETCH get_rebook_type INTO l_PROSPECTIVE_REBOOK_YN;

Line 918: AND p_csm_one_off_fee_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM

914: -- If the Fee is for a specific Asset, Store the corresponding SIL_ID.
915: -- Useful for Inbound API to map it back to the specific Asset
916: */
917: IF p_csm_one_off_fee_tbl(i).kle_asset_id IS NOT NULL
918: AND p_csm_one_off_fee_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM
919: THEN
920:
921: get_sil_id(p_csm_one_off_fee_tbl(i).kle_asset_id,l_sfev_one_off_tbl(i).sil_id);
922: IF l_sfev_one_off_tbl(i).sil_id = 0 THEN

Line 987: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

983: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
984:
985: BEGIN
986:
987: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
988:
989: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
990: OPEN get_rebook_type ;
991: FETCh get_rebook_type INTO l_PROSPECTIVE_REBOOK_YN ;

Line 1032: AND p_csm_periodic_expenses_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM

1028: */
1029: IF p_csm_periodic_expenses_tbl(i).kle_asset_id IS NOT NULL
1030:
1031:
1032: AND p_csm_periodic_expenses_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM
1033: THEN
1034: get_sil_id(p_csm_periodic_expenses_tbl(i).kle_asset_id,l_sfev_periodic_tbl(i).sil_id);
1035: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
1036: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

Line 1117: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1113:
1114: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
1115:
1116: BEGIN
1117: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1118: --Added bu kthiruva on 02-Dec-2005
1119: --The p_csm_periodic_expenses_tbl should be traversed from FIRST to LAST
1120: --and not from 1 to tbl.COUNT
1121: --Bug 4766555 - Start of Changes

Line 1163: AND p_csm_periodic_expenses_tbl(j).kle_asset_id <> Okc_Api.G_MISS_NUM

1159: -- Useful for Inbound API to map it back to the specific Asset
1160: */
1161:
1162: IF p_csm_periodic_expenses_tbl(j).kle_asset_id IS NOT NULL
1163: AND p_csm_periodic_expenses_tbl(j).kle_asset_id <> Okc_Api.G_MISS_NUM
1164: THEN
1165: get_sil_id(p_csm_periodic_expenses_tbl(j).kle_asset_id,l_sfev_periodic_tbl(i).sil_id);
1166: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
1167: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

Line 1220: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1216: IS
1217: l_siyv_tbl siyv_tbl_type;
1218: i NUMBER := 0;
1219: BEGIN
1220: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1221: FOR i IN 1..p_csm_yields_tbl.COUNT
1222: LOOP
1223: l_siyv_tbl(i).sif_id := p_sif_id;
1224: l_siyv_tbl(i).yield_name := p_csm_yields_tbl(i).yield_name;

Line 1235: AND p_csm_yields_tbl(i).nominal_yn <> OKC_API.G_MISS_CHAR

1231: l_siyv_tbl(i).nominal_yn := p_csm_yields_tbl(i).nominal_yn;
1232: /* Translate Nominal_yn
1233:
1234: IF p_csm_yields_tbl(i).nominal_yn IS NOT NULL
1235: AND p_csm_yields_tbl(i).nominal_yn <> OKC_API.G_MISS_CHAR
1236: THEN
1237: IF p_csm_yields_tbl(i).nominal_yn = G_FND_YES
1238: THEN
1239: l_siyv_tbl(i).nominal_yn := G_CSM_TRUE;

Line 1336: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1332: i NUMBER := 0;
1333: l_sty_name VARCHAR2(150);
1334: l_token1_value VARCHAR2(150);
1335: BEGIN
1336: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1337:
1338: FOR l_okl_sfe_ids IN l_okl_sfe_ids_csr(p_sif_id)
1339: LOOP
1340: i := i + 1;

Line 1355: AND p_csm_stream_types_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM

1351: l_sitv_tbl(i).sif_id := p_sif_id;
1352: l_sitv_tbl(i).sty_id := p_csm_stream_types_tbl(i).stream_type_id;
1353: l_sitv_tbl(i).pricing_name := p_csm_stream_types_tbl(i).pricing_name;
1354: IF p_csm_stream_types_tbl(i).kle_asset_id IS NOT NULL
1355: AND p_csm_stream_types_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM
1356: THEN
1357:
1358: get_sil_id(p_csm_stream_types_tbl(i).kle_asset_id,l_sitv_tbl(i).sil_id);
1359:

Line 1396: AND p_csm_stream_types_tbl(i).kle_fee_id <> Okc_Api.G_MISS_NUM

1392: OPEN l_okl_sil_sfe_ids_csr(p_sif_id, l_sitv_tbl(i).sil_id,l_sty_name);
1393: FETCH l_okl_sil_sfe_ids_csr INTO l_sitv_tbl(i).sfe_id;
1394: CLOSE l_okl_sil_sfe_ids_csr;
1395: ELSIF p_csm_stream_types_tbl(i).kle_fee_id IS NOT NULL
1396: AND p_csm_stream_types_tbl(i).kle_fee_id <> Okc_Api.G_MISS_NUM
1397: THEN
1398: get_sfe_id(p_csm_stream_types_tbl(i).kle_fee_id,p_csm_stream_types_tbl(i).stream_type_id,l_sitv_tbl(i).sfe_id);
1399: -- smahapat added for fee type soln
1400: IF l_sitv_tbl(i).sfe_id = 0 THEN

Line 1495: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1491:
1492: lp_silv_rec silv_rec_type;
1493: lx_silv_rec silv_rec_type;
1494: i NUMBER := 0;
1495: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1496: l_index NUMBER := -1;
1497: l_sil_index NUMBER := 0;
1498: l_count NUMBER := 0;
1499:

Line 1616: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1612:
1613: l_PROSPECTIVE_REBOOK_YN VARCHAR2(1);
1614:
1615: BEGIN
1616: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1617:
1618: -- sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
1619: OPEN get_rebook_type ;
1620: FETCH get_rebook_type INTO l_PROSPECTIVE_REBOOK_YN;

Line 1688: AND p_csm_loan_levels_tbl(j).kle_loan_id <> Okc_Api.G_MISS_NUM

1684: -- Useful for Inbound API to map it back to the specific Asset
1685: */
1686:
1687: IF p_csm_loan_levels_tbl(j).kle_loan_id IS NOT NULL
1688: AND p_csm_loan_levels_tbl(j).kle_loan_id <> Okc_Api.G_MISS_NUM
1689: THEN
1690:
1691: get_sil_id(p_csm_loan_levels_tbl(j).kle_loan_id,l_sfev_periodic_tbl(i).sil_id);
1692:

Line 1771: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1767: ) IS
1768:
1769: lp_silv_rec silv_rec_type;
1770: lx_silv_rec silv_rec_type;
1771: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1772: l_csm_loan_lines_tbl csm_loan_line_tbl_type;
1773: l_csm_loan_levels_tbl csm_loan_level_tbl_type;
1774:
1775: lp_sfev_loan_levels_tbl sfev_tbl_type;

Line 1984: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1980: ) IS
1981:
1982: lp_silv_rec silv_rec_type;
1983: lx_silv_rec silv_rec_type;
1984: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1985: l_csm_loan_lines_tbl csm_loan_line_tbl_type;
1986: l_csm_loan_levels_tbl csm_loan_level_tbl_type;
1987:
1988: lp_sfev_loan_levels_tbl sfev_tbl_type;

Line 2215: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2211: ) IS
2212:
2213: lp_silv_rec silv_rec_type;
2214: lx_silv_rec silv_rec_type;
2215: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2216:
2217: lp_sfev_loan_levels_tbl sfev_tbl_type;
2218: lx_sfev_loan_levels_tbl sfev_tbl_type;
2219:

Line 2471: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2467: -- new structures for finance fee
2468:
2469: x_csm_one_off_fee_tbl csm_one_off_fee_tbl_type;
2470: x_csm_periodic_expenses_tbl csm_periodic_expenses_tbl_type;
2471: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2472: l_api_version CONSTANT NUMBER := 1;
2473: l_sif_id NUMBER;
2474: l_khr_id NUMBER;
2475: l_pending BOOLEAN := FALSE;

Line 2509: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

2505: );
2506: --smahapat addition end
2507: l_pending BOOLEAN DEFAULT FALSE;
2508: BEGIN
2509: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
2510: IF p_khr_id IS NOT NULL THEN
2511: --smahapat 11/10/02 multi-gaap - addition
2512: IF p_purpose_code IS NOT NULL AND p_purpose_code = G_PURPOSE_CODE_REPORT THEN
2513: FOR l_sif_rpt_csr IN l_okl_sif_rpt_status_csr(p_khr_id)

Line 3118: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3114: l_sif_id NUMBER;
3115: l_khr_id NUMBER;
3116:
3117: l_pending BOOLEAN := FALSE;
3118: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3119: ---------------------------------------------------------------------------
3120: -- FUNCTION pending_request_exists
3121: -- Checks if any request is pending for the specified ContractNumber
3122: ---------------------------------------------------------------------------

Line 3153: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

3149: );
3150: --smahapat addition end
3151: l_pending BOOLEAN DEFAULT FALSE;
3152: BEGIN
3153: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
3154: IF p_khr_id IS NOT NULL THEN
3155:
3156: --smahapat 11/10/02 multi-gaap - addition
3157: IF p_purpose_code IS NOT NULL AND p_purpose_code = G_PURPOSE_CODE_REPORT THEN

Line 3706: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3702: lp_sifv_rec sifv_rec_type;
3703:
3704: lx_sifv_rec sifv_rec_type;
3705: l_api_name CONSTANT VARCHAR2(30) := 'Invoke_Pricing_Engine';
3706: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3707:
3708: l_api_version CONSTANT NUMBER := 1;
3709: l_trx_sub_type VARCHAR2(20);
3710: BEGIN

Line 3852: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

3848: l_siyv_tbl siyv_tbl_type;
3849: i NUMBER := 0;
3850: l_target_count NUMBER := 0;
3851: BEGIN
3852: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
3853: FOR i IN 1..p_csm_yields_tbl.COUNT
3854: LOOP
3855: l_siyv_tbl(i).sif_id := p_sif_id;
3856: l_siyv_tbl(i).yield_name := p_csm_yields_tbl(i).yield_name;

Line 3867: p_csm_yields_tbl(i).target_value <> OKC_API.G_MISS_NUM

3863: l_siyv_tbl(i).nominal_yn := p_csm_yields_tbl(i).nominal_yn;
3864: l_siyv_tbl(i).target_value := p_csm_yields_tbl(i).target_value;
3865: l_siyv_tbl(i).pre_tax_yn := p_csm_yields_tbl(i).pre_tax_yn;
3866: IF p_csm_yields_tbl(i).target_value IS NOT NULL AND
3867: p_csm_yields_tbl(i).target_value <> OKC_API.G_MISS_NUM
3868: THEN
3869: l_target_count := l_target_count + 1;
3870: END IF;
3871: IF l_target_count > 1 THEN

Line 3940: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3936: lp_siyv_tbl siyv_tbl_type;
3937: lx_siyv_tbl siyv_tbl_type;
3938: lp_sitv_tbl sitv_tbl_type;
3939: lx_sitv_tbl sitv_tbl_type;
3940: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3941: l_api_version CONSTANT NUMBER := 1;
3942: l_sif_id NUMBER;
3943: l_khr_id NUMBER;
3944: l_pending BOOLEAN := FALSE;

Line 3968: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

3964: );
3965: l_pending BOOLEAN DEFAULT FALSE;
3966: BEGIN
3967:
3968: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
3969: --IF p_csm_lease_header IS NOT NULL THEN
3970: FOR l_sif_csr IN l_okl_sif_status_csr(p_csm_lease_header)
3971: LOOP
3972: l_pending := TRUE;

Line 4406: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

4402: lx_sitv_tbl sitv_tbl_type;
4403: l_sif_id NUMBER;
4404: l_khr_id NUMBER;
4405: l_pending BOOLEAN := FALSE;
4406: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
4407: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
4408:
4409: -- new structures for financed fee
4410: x_csm_one_off_fee_tbl csm_one_off_fee_tbl_type;

Line 4446: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

4442: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
4443: );
4444: l_pending BOOLEAN DEFAULT FALSE;
4445: BEGIN
4446: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4447: IF p_csm_loan_header.orp_code IN( G_ORP_CODE_RESTRUCTURE_AM,G_ORP_CODE_RESTRUCTURE_CS,G_ORP_CODE_RENEWAL)
4448: THEN
4449: FOR l_sif_csr IN l_okl_sif_restr_status_csr(p_csm_loan_header)
4450: LOOP

Line 4937: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

4933: lx_siyv_tbl siyv_tbl_type;
4934: lp_sitv_tbl sitv_tbl_type;
4935: lx_sitv_tbl sitv_tbl_type;
4936:
4937: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
4938:
4939: -- new structures for Rollover fee
4940: x_csm_one_off_fee_tbl csm_one_off_fee_tbl_type;
4941: x_csm_periodic_expenses_tbl csm_periodic_expenses_tbl_type;

Line 4966: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

4962: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
4963: );
4964: l_pending BOOLEAN DEFAULT FALSE;
4965: BEGIN
4966: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4967: IF p_khr_id IS NOT NULL THEN
4968: FOR l_sif_csr IN l_okl_sif_status_csr(p_khr_id)
4969: LOOP
4970: l_pending := TRUE;

Line 5345: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

5341:
5342: PROCEDURE add_balance_information(x_sfev_tbl IN OUT NOCOPY sfev_tbl_type,
5343: x_return_status OUT NOCOPY VARCHAR2)
5344: IS
5345: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
5346: BEGIN
5347: FOR i in x_sfev_tbl.FIRST .. x_sfev_tbl.LAST
5348: LOOP
5349: IF x_sfev_tbl(i).balance_type_code is NULL