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_CONTRACT_PVT dependencies on OKX_ASSETS_V

Line 859: l_asset_no OKX_ASSETS_V.ASSET_NUMBER%TYPE;

855: Cursor c_asset_no IS
856: select 'DUMMY'||TO_CHAR(OKL_FAN_SEQ.NEXTVAL)
857: FROM dual;
858:
859: l_asset_no OKX_ASSETS_V.ASSET_NUMBER%TYPE;
860:
861: --Cursors to find if asset number exists
862: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
863: SELECT 'Y'

Line 862: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

858:
859: l_asset_no OKX_ASSETS_V.ASSET_NUMBER%TYPE;
860:
861: --Cursors to find if asset number exists
862: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
863: SELECT 'Y'
864: FROM DUAL
865: WHERE EXISTS (SELECT '1'
866: FROM OKL_TXL_ASSETS_V

Line 869: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

865: WHERE EXISTS (SELECT '1'
866: FROM OKL_TXL_ASSETS_V
867: WHERE asset_number = p_asset_number);
868:
869: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
870: --start modified abhsaxen for performance SQLID 20562304
871: select 'Y'
872: from okc_k_lines_b kleb,
873: okc_k_lines_tl kle,

Line 882: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

878: and kleb.lse_id = lse.id
879: and lse.lty_code = 'FREE_FORM1';
880: --start modified abhsaxen for performance SQLID 20562304
881:
882: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
883: SELECT 'Y'
884: FROM DUAL
885: WHERE EXISTS (SELECT '1'
886: FROM OKX_ASSETS_V

Line 886: FROM OKX_ASSETS_V

882: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
883: SELECT 'Y'
884: FROM DUAL
885: WHERE EXISTS (SELECT '1'
886: FROM OKX_ASSETS_V
887: WHERE asset_number = p_asset_number);
888:
889: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
890: SELECT 'Y'

Line 889: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

885: WHERE EXISTS (SELECT '1'
886: FROM OKX_ASSETS_V
887: WHERE asset_number = p_asset_number);
888:
889: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
890: SELECT 'Y'
891: FROM DUAL
892: WHERE EXISTS (SELECT '1'
893: FROM OKL_TXD_ASSETS_V

Line 984: open c_okx_assets_v(l_asset_no);

980: If c_txl_asset_number%NOTFOUND Then
981: open c_okx_asset_lines_v(l_asset_no);
982: Fetch c_okx_asset_lines_v into l_asset_exists;
983: If c_okx_asset_lines_v%NOTFOUND Then
984: open c_okx_assets_v(l_asset_no);
985: Fetch c_okx_assets_v into l_asset_exists;
986: If c_okx_assets_v%NOTFOUND Then
987: open c_txd_assets_v(l_asset_no);
988: Fetch c_txd_assets_v into l_Asset_exists;

Line 985: Fetch c_okx_assets_v into l_asset_exists;

981: open c_okx_asset_lines_v(l_asset_no);
982: Fetch c_okx_asset_lines_v into l_asset_exists;
983: If c_okx_asset_lines_v%NOTFOUND Then
984: open c_okx_assets_v(l_asset_no);
985: Fetch c_okx_assets_v into l_asset_exists;
986: If c_okx_assets_v%NOTFOUND Then
987: open c_txd_assets_v(l_asset_no);
988: Fetch c_txd_assets_v into l_Asset_exists;
989: If c_txd_assets_v%NOTFOUND Then

Line 986: If c_okx_assets_v%NOTFOUND Then

982: Fetch c_okx_asset_lines_v into l_asset_exists;
983: If c_okx_asset_lines_v%NOTFOUND Then
984: open c_okx_assets_v(l_asset_no);
985: Fetch c_okx_assets_v into l_asset_exists;
986: If c_okx_assets_v%NOTFOUND Then
987: open c_txd_assets_v(l_asset_no);
988: Fetch c_txd_assets_v into l_Asset_exists;
989: If c_txd_assets_v%NOTFOUND Then
990: null;

Line 994: Close c_okx_assets_v;

990: null;
991: End If;
992: Close c_txd_assets_v;
993: End If;
994: Close c_okx_assets_v;
995: End If;
996: Close c_okx_asset_lines_v;
997: End If;
998: Close c_txl_asset_number;

Line 1088: If c_okx_assets_v%ISOPEN Then

1084: End If;
1085: If c_txd_assets_v%ISOPEN Then
1086: CLOSE c_txd_assets_v;
1087: End If;
1088: If c_okx_assets_v%ISOPEN Then
1089: CLOSE c_okx_assets_v;
1090: End If;
1091: If c_okx_asset_lines_v%ISOPEN Then
1092: CLOSE c_okx_asset_lines_v;

Line 1089: CLOSE c_okx_assets_v;

1085: If c_txd_assets_v%ISOPEN Then
1086: CLOSE c_txd_assets_v;
1087: End If;
1088: If c_okx_assets_v%ISOPEN Then
1089: CLOSE c_okx_assets_v;
1090: End If;
1091: If c_okx_asset_lines_v%ISOPEN Then
1092: CLOSE c_okx_asset_lines_v;
1093: End If;

Line 1113: If c_okx_assets_v%ISOPEN Then

1109: End If;
1110: If c_txd_assets_v%ISOPEN Then
1111: CLOSE c_txd_assets_v;
1112: End If;
1113: If c_okx_assets_v%ISOPEN Then
1114: CLOSE c_okx_assets_v;
1115: End If;
1116: If c_okx_asset_lines_v%ISOPEN Then
1117: CLOSE c_okx_asset_lines_v;

Line 1114: CLOSE c_okx_assets_v;

1110: If c_txd_assets_v%ISOPEN Then
1111: CLOSE c_txd_assets_v;
1112: End If;
1113: If c_okx_assets_v%ISOPEN Then
1114: CLOSE c_okx_assets_v;
1115: End If;
1116: If c_okx_asset_lines_v%ISOPEN Then
1117: CLOSE c_okx_asset_lines_v;
1118: End If;