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 DUAL

Line 672: lp_silv_rec.residual_amount := p_csm_line_details_tbl(i).residual_amount;

668: lp_silv_rec.description := p_csm_line_details_tbl(i).description;
669: lp_silv_rec.asset_cost := p_csm_line_details_tbl(i).asset_cost;
670: lp_silv_rec.date_delivery := p_csm_line_details_tbl(i).date_delivery;
671: lp_silv_rec.date_funding := p_csm_line_details_tbl(i).date_funding;
672: lp_silv_rec.residual_amount := p_csm_line_details_tbl(i).residual_amount;
673: lp_silv_rec.residual_date := p_csm_line_details_tbl(i).residual_date;
674: lp_silv_rec.fed_depre_method := p_csm_line_details_tbl(i).fed_depre_method;
675: lp_silv_rec.fed_depre_basis_percent := p_csm_line_details_tbl(i).fed_depre_basis_percent;
676: lp_silv_rec.date_fed_depre := p_csm_line_details_tbl(i).date_fed_depre;

Line 673: lp_silv_rec.residual_date := p_csm_line_details_tbl(i).residual_date;

669: lp_silv_rec.asset_cost := p_csm_line_details_tbl(i).asset_cost;
670: lp_silv_rec.date_delivery := p_csm_line_details_tbl(i).date_delivery;
671: lp_silv_rec.date_funding := p_csm_line_details_tbl(i).date_funding;
672: lp_silv_rec.residual_amount := p_csm_line_details_tbl(i).residual_amount;
673: lp_silv_rec.residual_date := p_csm_line_details_tbl(i).residual_date;
674: lp_silv_rec.fed_depre_method := p_csm_line_details_tbl(i).fed_depre_method;
675: lp_silv_rec.fed_depre_basis_percent := p_csm_line_details_tbl(i).fed_depre_basis_percent;
676: lp_silv_rec.date_fed_depre := p_csm_line_details_tbl(i).date_fed_depre;
677: lp_silv_rec.fed_depre_term := p_csm_line_details_tbl(i).fed_depre_term;

Line 696: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;

692: lp_silv_rec.book_term := p_csm_line_details_tbl(i).book_term;
693: lp_silv_rec.book_salvage := p_csm_line_details_tbl(i).book_salvage;
694: lp_silv_rec.book_adr_convention := p_csm_line_details_tbl(i).book_adr_convention;
695: lp_silv_rec.book_depre_dmnshing_value_rt := p_csm_line_details_tbl(i).book_depre_dmnshing_value_rt;
696: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;
697: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;
698: lp_silv_rec.purchase_option := p_csm_line_details_tbl(i).purchase_option;
699: lp_silv_rec.purchase_option_amount := p_csm_line_details_tbl(i).purchase_option_amount;
700: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;

Line 697: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;

693: lp_silv_rec.book_salvage := p_csm_line_details_tbl(i).book_salvage;
694: lp_silv_rec.book_adr_convention := p_csm_line_details_tbl(i).book_adr_convention;
695: lp_silv_rec.book_depre_dmnshing_value_rt := p_csm_line_details_tbl(i).book_depre_dmnshing_value_rt;
696: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;
697: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;
698: lp_silv_rec.purchase_option := p_csm_line_details_tbl(i).purchase_option;
699: lp_silv_rec.purchase_option_amount := p_csm_line_details_tbl(i).purchase_option_amount;
700: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;
701: lp_silv_rec.down_payment_amount := p_csm_line_details_tbl(i).down_payment_amount;

Line 700: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;

696: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;
697: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;
698: lp_silv_rec.purchase_option := p_csm_line_details_tbl(i).purchase_option;
699: lp_silv_rec.purchase_option_amount := p_csm_line_details_tbl(i).purchase_option_amount;
700: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;
701: lp_silv_rec.down_payment_amount := p_csm_line_details_tbl(i).down_payment_amount;
702: lp_silv_rec.capitalize_down_payment_yn := p_csm_line_details_tbl(i).capitalize_down_payment_yn;
703: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Lines_Pub.insert_sif_lines
704: IF(L_DEBUG_ENABLED='Y') THEN

Line 2231: SELECT '1' FROM dual

2227: ,x_return_status OUT NOCOPY VARCHAR2
2228: ) RETURN BOOLEAN
2229: IS
2230: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2231: SELECT '1' FROM dual
2232: WHERE EXISTS
2233: (SELECT '1'
2234: FROM OKL_STREAM_INTERFACES
2235: WHERE khr_id = p_khr_id

Line 2241: SELECT '1' FROM dual

2237: );
2238: --smahapat 11/10/02 multi-gaap - addition
2239: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2240:
2241: SELECT '1' FROM dual
2242: WHERE EXISTS
2243: (SELECT '1'
2244: FROM OKL_STREAM_INTERFACES
2245: WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT

Line 2870: SELECT '1' FROM dual

2866: ,x_return_status OUT NOCOPY VARCHAR2
2867: ) RETURN BOOLEAN
2868: IS
2869: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2870: SELECT '1' FROM dual
2871: WHERE EXISTS
2872: (SELECT '1'
2873: FROM OKL_STREAM_INTERFACES
2874: WHERE khr_id = p_khr_id

Line 2881: SELECT '1' FROM dual

2877: --smahapat 11/10/02 multi-gaap - addition
2878:
2879:
2880: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2881: SELECT '1' FROM dual
2882: WHERE EXISTS
2883: (SELECT '1'
2884: FROM OKL_STREAM_INTERFACES
2885: WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT

Line 3695: SELECT '1' FROM dual

3691: ,x_return_status OUT NOCOPY VARCHAR2
3692: ) RETURN BOOLEAN
3693: IS
3694: CURSOR l_okl_sif_status_csr(p_csm_lease_header csm_lease_rec_type) IS
3695: SELECT '1' FROM dual
3696: WHERE EXISTS
3697: (SELECT '1'
3698: FROM OKL_STREAM_INTERFACES
3699: WHERE jtot_object1_code = p_csm_lease_header.jtot_object1_code

Line 4164: SELECT '1' FROM dual

4160: ,x_return_status OUT NOCOPY VARCHAR2
4161: ) RETURN BOOLEAN
4162: IS
4163: CURSOR l_okl_sif_restr_status_csr(p_csm_loan_header csm_loan_rec_type) IS
4164: SELECT '1' FROM dual
4165: WHERE EXISTS
4166: (SELECT '1'
4167: FROM OKL_STREAM_INTERFACES
4168: WHERE jtot_object1_code = p_csm_loan_header.jtot_object1_code

Line 4173: SELECT '1' FROM dual

4169: AND object1_id1 = p_csm_loan_header.object1_id1
4170: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST)
4171: );
4172: CURSOR l_okl_sif_quote_status_csr(p_csm_loan_header csm_loan_rec_type) IS
4173: SELECT '1' FROM dual
4174: WHERE EXISTS
4175: (SELECT '1'
4176: FROM OKL_STREAM_INTERFACES
4177: WHERE khr_id = p_csm_loan_header.khr_id

Line 4695: SELECT '1' FROM dual

4691: ,x_return_status OUT NOCOPY VARCHAR2
4692: ) RETURN BOOLEAN
4693: IS
4694: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
4695: SELECT '1' FROM dual
4696: WHERE EXISTS
4697: (SELECT '1'
4698: FROM OKL_STREAM_INTERFACES
4699: WHERE khr_id = p_khr_id