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 721: lp_silv_rec.residual_amount := p_csm_line_details_tbl(i).residual_amount;

717: lp_silv_rec.description := p_csm_line_details_tbl(i).description;
718: lp_silv_rec.asset_cost := p_csm_line_details_tbl(i).asset_cost;
719: lp_silv_rec.date_delivery := p_csm_line_details_tbl(i).date_delivery;
720: lp_silv_rec.date_funding := p_csm_line_details_tbl(i).date_funding;
721: lp_silv_rec.residual_amount := p_csm_line_details_tbl(i).residual_amount;
722: lp_silv_rec.residual_date := p_csm_line_details_tbl(i).residual_date;
723: lp_silv_rec.fed_depre_method := p_csm_line_details_tbl(i).fed_depre_method;
724: lp_silv_rec.fed_depre_basis_percent := p_csm_line_details_tbl(i).fed_depre_basis_percent;
725: lp_silv_rec.date_fed_depre := p_csm_line_details_tbl(i).date_fed_depre;

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

718: lp_silv_rec.asset_cost := p_csm_line_details_tbl(i).asset_cost;
719: lp_silv_rec.date_delivery := p_csm_line_details_tbl(i).date_delivery;
720: lp_silv_rec.date_funding := p_csm_line_details_tbl(i).date_funding;
721: lp_silv_rec.residual_amount := p_csm_line_details_tbl(i).residual_amount;
722: lp_silv_rec.residual_date := p_csm_line_details_tbl(i).residual_date;
723: lp_silv_rec.fed_depre_method := p_csm_line_details_tbl(i).fed_depre_method;
724: lp_silv_rec.fed_depre_basis_percent := p_csm_line_details_tbl(i).fed_depre_basis_percent;
725: lp_silv_rec.date_fed_depre := p_csm_line_details_tbl(i).date_fed_depre;
726: lp_silv_rec.fed_depre_term := p_csm_line_details_tbl(i).fed_depre_term;

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

741: lp_silv_rec.book_term := p_csm_line_details_tbl(i).book_term;
742: lp_silv_rec.book_salvage := p_csm_line_details_tbl(i).book_salvage;
743: lp_silv_rec.book_adr_convention := p_csm_line_details_tbl(i).book_adr_convention;
744: lp_silv_rec.book_depre_dmnshing_value_rt := p_csm_line_details_tbl(i).book_depre_dmnshing_value_rt;
745: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;
746: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;
747: lp_silv_rec.purchase_option := p_csm_line_details_tbl(i).purchase_option;
748: lp_silv_rec.purchase_option_amount := p_csm_line_details_tbl(i).purchase_option_amount;
749: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;

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

742: lp_silv_rec.book_salvage := p_csm_line_details_tbl(i).book_salvage;
743: lp_silv_rec.book_adr_convention := p_csm_line_details_tbl(i).book_adr_convention;
744: lp_silv_rec.book_depre_dmnshing_value_rt := p_csm_line_details_tbl(i).book_depre_dmnshing_value_rt;
745: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;
746: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;
747: lp_silv_rec.purchase_option := p_csm_line_details_tbl(i).purchase_option;
748: lp_silv_rec.purchase_option_amount := p_csm_line_details_tbl(i).purchase_option_amount;
749: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;
750: lp_silv_rec.down_payment_amount := p_csm_line_details_tbl(i).down_payment_amount;

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

745: lp_silv_rec.residual_guarantee_method := p_csm_line_details_tbl(i).residual_guarantee_method;
746: lp_silv_rec.residual_guarantee_amount := p_csm_line_details_tbl(i).residual_guarantee_amount;
747: lp_silv_rec.purchase_option := p_csm_line_details_tbl(i).purchase_option;
748: lp_silv_rec.purchase_option_amount := p_csm_line_details_tbl(i).purchase_option_amount;
749: lp_silv_rec.residual_guarantee_type := p_csm_line_details_tbl(i).guarantee_type;
750: lp_silv_rec.down_payment_amount := p_csm_line_details_tbl(i).down_payment_amount;
751: lp_silv_rec.capitalize_down_payment_yn := p_csm_line_details_tbl(i).capitalize_down_payment_yn;
752: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Lines_Pub.insert_sif_lines
753: IF(L_DEBUG_ENABLED='Y') THEN

Line 2489: SELECT '1' FROM dual

2485: ,x_return_status OUT NOCOPY VARCHAR2
2486: ) RETURN BOOLEAN
2487: IS
2488: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2489: SELECT '1' FROM dual
2490: WHERE EXISTS
2491: (SELECT '1'
2492: FROM OKL_STREAM_INTERFACES
2493: WHERE khr_id = p_khr_id

Line 2499: SELECT '1' FROM dual

2495: );
2496: --smahapat 11/10/02 multi-gaap - addition
2497: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2498:
2499: SELECT '1' FROM dual
2500: WHERE EXISTS
2501: (SELECT '1'
2502: FROM OKL_STREAM_INTERFACES
2503: WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT

Line 3132: SELECT '1' FROM dual

3128: ,x_return_status OUT NOCOPY VARCHAR2
3129: ) RETURN BOOLEAN
3130: IS
3131: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
3132: SELECT '1' FROM dual
3133: WHERE EXISTS
3134: (SELECT '1'
3135: FROM OKL_STREAM_INTERFACES
3136: WHERE khr_id = p_khr_id

Line 3143: SELECT '1' FROM dual

3139: --smahapat 11/10/02 multi-gaap - addition
3140:
3141:
3142: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
3143: SELECT '1' FROM dual
3144: WHERE EXISTS
3145: (SELECT '1'
3146: FROM OKL_STREAM_INTERFACES
3147: WHERE khr_id = p_khr_id AND purpose_code = G_PURPOSE_CODE_REPORT

Line 3957: SELECT '1' FROM dual

3953: ,x_return_status OUT NOCOPY VARCHAR2
3954: ) RETURN BOOLEAN
3955: IS
3956: CURSOR l_okl_sif_status_csr(p_csm_lease_header csm_lease_rec_type) IS
3957: SELECT '1' FROM dual
3958: WHERE EXISTS
3959: (SELECT '1'
3960: FROM OKL_STREAM_INTERFACES
3961: WHERE jtot_object1_code = p_csm_lease_header.jtot_object1_code

Line 4426: SELECT '1' FROM dual

4422: ,x_return_status OUT NOCOPY VARCHAR2
4423: ) RETURN BOOLEAN
4424: IS
4425: CURSOR l_okl_sif_restr_status_csr(p_csm_loan_header csm_loan_rec_type) IS
4426: SELECT '1' FROM dual
4427: WHERE EXISTS
4428: (SELECT '1'
4429: FROM OKL_STREAM_INTERFACES
4430: WHERE jtot_object1_code = p_csm_loan_header.jtot_object1_code

Line 4435: SELECT '1' FROM dual

4431: AND object1_id1 = p_csm_loan_header.object1_id1
4432: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST)
4433: );
4434: CURSOR l_okl_sif_quote_status_csr(p_csm_loan_header csm_loan_rec_type) IS
4435: SELECT '1' FROM dual
4436: WHERE EXISTS
4437: (SELECT '1'
4438: FROM OKL_STREAM_INTERFACES
4439: WHERE khr_id = p_csm_loan_header.khr_id

Line 4957: SELECT '1' FROM dual

4953: ,x_return_status OUT NOCOPY VARCHAR2
4954: ) RETURN BOOLEAN
4955: IS
4956: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
4957: SELECT '1' FROM dual
4958: WHERE EXISTS
4959: (SELECT '1'
4960: FROM OKL_STREAM_INTERFACES
4961: WHERE khr_id = p_khr_id