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_CS_LEASE_RENEWAL_PVT dependencies on OKL_CREATE_STREAMS_PUB

Line 846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;

842: l_trans_status VARCHAR2(100);
843: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
844: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
845:
846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

Line 847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;

843: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
844: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
845:
846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

Line 848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

844: l_upd_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
845:
846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;

Line 849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;

845:
846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;
853: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

Line 850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

846: l_csm_lease_header Okl_Create_Streams_Pub.csm_lease_rec_type;
847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;
853: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
854: l_reduce_residual_ptg_by NUMBER;

Line 851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

847: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;
853: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
854: l_reduce_residual_ptg_by NUMBER;
855: l_current_term NUMBER;

Line 852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;

848: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;
853: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
854: l_reduce_residual_ptg_by NUMBER;
855: l_current_term NUMBER;
856: l_new_term NUMBER;

Line 853: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

849: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
850: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
851: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
852: l_csm_line_details_tbl Okl_Create_Streams_Pub.csm_line_details_tbl_type;
853: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
854: l_reduce_residual_ptg_by NUMBER;
855: l_current_term NUMBER;
856: l_new_term NUMBER;
857: l_current_lease_attribs lease_details_tbl_type;

Line 975: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_RENEWAL;

971: --Fine tune the params
972: --x_csm_lease_header
973: l_csm_lease_header.jtot_object1_code := 'OKL_TRX_REQUESTS';
974: l_csm_lease_header.object1_id1 := x_trqv_tbl(1).id;
975: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_RENEWAL;
976:
977: --Check the following with Susan.
978: l_csm_lease_header.adjust := 'Rent';
979: l_csm_lease_header.adjustment_method := 'Proportional';

Line 994: l_rents_tbl(1).lock_level_step := OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;

990: l_rents_tbl.delete;
991: l_rents_tbl(1).description := 'RENT';
992: l_rents_tbl(1).number_of_periods := l_current_lease_attribs(1).term_duration;
993: l_rents_tbl(1).amount := NVL(l_current_lease_attribs(1).rent,0);
994: l_rents_tbl(1).lock_level_step := OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;
995:
996: --Check the following with Susan
997: l_rents_tbl(1).period := 'M';
998: l_rents_tbl(1).level_index_number := 1;

Line 999: l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

995:
996: --Check the following with Susan
997: l_rents_tbl(1).period := 'M';
998: l_rents_tbl(1).level_index_number := 1;
999: l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
1000: l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE;
1001: l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
1002: l_rents_tbl(1).date_start := l_current_lease_attribs(1).start_date;
1003:

Line 1000: l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE;

996: --Check the following with Susan
997: l_rents_tbl(1).period := 'M';
998: l_rents_tbl(1).level_index_number := 1;
999: l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
1000: l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE;
1001: l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
1002: l_rents_tbl(1).date_start := l_current_lease_attribs(1).start_date;
1003:
1004: --Level 2 for new amount:

Line 1001: l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

997: l_rents_tbl(1).period := 'M';
998: l_rents_tbl(1).level_index_number := 1;
999: l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
1000: l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE;
1001: l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
1002: l_rents_tbl(1).date_start := l_current_lease_attribs(1).start_date;
1003:
1004: --Level 2 for new amount:
1005: l_rents_tbl(2).description := 'RENT';

Line 1008: l_rents_tbl(2).lock_level_step := NULL; --OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;

1004: --Level 2 for new amount:
1005: l_rents_tbl(2).description := 'RENT';
1006: l_rents_tbl(2).number_of_periods := p_trqv_tbl(1).term_duration;
1007: l_rents_tbl(2).amount := 0;
1008: l_rents_tbl(2).lock_level_step := NULL; --OKL_CREATE_STREAMS_PUB.G_LOCK_AMOUNT;
1009: l_rents_tbl(2).query_level_yn := 'Y';
1010:
1011: --Check the following with Susan
1012: l_rents_tbl(2).period := 'M';

Line 1014: l_rents_tbl(2).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

1010:
1011: --Check the following with Susan
1012: l_rents_tbl(2).period := 'M';
1013: l_rents_tbl(2).level_index_number := 2;
1014: l_rents_tbl(2).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
1015: l_rents_tbl(2).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE; -- IS this hard coding Okay.. Check with Susan.
1016: l_rents_tbl(2).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
1017: l_rents_tbl(2).date_start := p_trqv_tbl(1).start_date;
1018:

Line 1015: l_rents_tbl(2).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE; -- IS this hard coding Okay.. Check with Susan.

1011: --Check the following with Susan
1012: l_rents_tbl(2).period := 'M';
1013: l_rents_tbl(2).level_index_number := 2;
1014: l_rents_tbl(2).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
1015: l_rents_tbl(2).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE; -- IS this hard coding Okay.. Check with Susan.
1016: l_rents_tbl(2).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
1017: l_rents_tbl(2).date_start := p_trqv_tbl(1).start_date;
1018:
1019:

Line 1016: l_rents_tbl(2).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

1012: l_rents_tbl(2).period := 'M';
1013: l_rents_tbl(2).level_index_number := 2;
1014: l_rents_tbl(2).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
1015: l_rents_tbl(2).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ADVANCE; -- IS this hard coding Okay.. Check with Susan.
1016: l_rents_tbl(2).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
1017: l_rents_tbl(2).date_start := p_trqv_tbl(1).start_date;
1018:
1019:
1020:

Line 1022: Okl_Create_Streams_Pub.CREATE_STREAMS_LEASE_RESTR(

1018:
1019:
1020:
1021: --Call Supertrump API to submit request.
1022: Okl_Create_Streams_Pub.CREATE_STREAMS_LEASE_RESTR(
1023: p_api_version => p_api_version,
1024: p_init_msg_list => p_init_msg_list,
1025: x_return_status => x_return_status,
1026: x_msg_count => x_msg_count,