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 891: l_asset_no OKX_ASSETS_V.ASSET_NUMBER%TYPE;

887: Cursor c_asset_no IS
888: select 'DUMMY'||TO_CHAR(OKL_FAN_SEQ.NEXTVAL)
889: FROM dual;
890:
891: l_asset_no OKX_ASSETS_V.ASSET_NUMBER%TYPE;
892:
893: --Cursors to find if asset number exists
894: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
895: SELECT 'Y'

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

890:
891: l_asset_no OKX_ASSETS_V.ASSET_NUMBER%TYPE;
892:
893: --Cursors to find if asset number exists
894: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
895: SELECT 'Y'
896: FROM DUAL
897: WHERE EXISTS (SELECT '1'
898: FROM OKL_TXL_ASSETS_V

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

897: WHERE EXISTS (SELECT '1'
898: FROM OKL_TXL_ASSETS_V
899: WHERE asset_number = p_asset_number);
900:
901: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
902: --start modified abhsaxen for performance SQLID 20562304
903: select 'Y'
904: from okc_k_lines_b kleb,
905: okc_k_lines_tl kle,

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

910: and kleb.lse_id = lse.id
911: and lse.lty_code = 'FREE_FORM1';
912: --start modified abhsaxen for performance SQLID 20562304
913:
914: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
915: SELECT 'Y'
916: FROM DUAL
917: WHERE EXISTS (SELECT '1'
918: FROM OKX_ASSETS_V

Line 918: FROM OKX_ASSETS_V

914: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
915: SELECT 'Y'
916: FROM DUAL
917: WHERE EXISTS (SELECT '1'
918: FROM OKX_ASSETS_V
919: WHERE asset_number = p_asset_number);
920:
921: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
922: SELECT 'Y'

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

917: WHERE EXISTS (SELECT '1'
918: FROM OKX_ASSETS_V
919: WHERE asset_number = p_asset_number);
920:
921: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
922: SELECT 'Y'
923: FROM DUAL
924: WHERE EXISTS (SELECT '1'
925: FROM OKL_TXD_ASSETS_V

Line 1016: open c_okx_assets_v(l_asset_no);

1012: If c_txl_asset_number%NOTFOUND Then
1013: open c_okx_asset_lines_v(l_asset_no);
1014: Fetch c_okx_asset_lines_v into l_asset_exists;
1015: If c_okx_asset_lines_v%NOTFOUND Then
1016: open c_okx_assets_v(l_asset_no);
1017: Fetch c_okx_assets_v into l_asset_exists;
1018: If c_okx_assets_v%NOTFOUND Then
1019: open c_txd_assets_v(l_asset_no);
1020: Fetch c_txd_assets_v into l_Asset_exists;

Line 1017: Fetch c_okx_assets_v into l_asset_exists;

1013: open c_okx_asset_lines_v(l_asset_no);
1014: Fetch c_okx_asset_lines_v into l_asset_exists;
1015: If c_okx_asset_lines_v%NOTFOUND Then
1016: open c_okx_assets_v(l_asset_no);
1017: Fetch c_okx_assets_v into l_asset_exists;
1018: If c_okx_assets_v%NOTFOUND Then
1019: open c_txd_assets_v(l_asset_no);
1020: Fetch c_txd_assets_v into l_Asset_exists;
1021: If c_txd_assets_v%NOTFOUND Then

Line 1018: If c_okx_assets_v%NOTFOUND Then

1014: Fetch c_okx_asset_lines_v into l_asset_exists;
1015: If c_okx_asset_lines_v%NOTFOUND Then
1016: open c_okx_assets_v(l_asset_no);
1017: Fetch c_okx_assets_v into l_asset_exists;
1018: If c_okx_assets_v%NOTFOUND Then
1019: open c_txd_assets_v(l_asset_no);
1020: Fetch c_txd_assets_v into l_Asset_exists;
1021: If c_txd_assets_v%NOTFOUND Then
1022: null;

Line 1026: Close c_okx_assets_v;

1022: null;
1023: End If;
1024: Close c_txd_assets_v;
1025: End If;
1026: Close c_okx_assets_v;
1027: End If;
1028: Close c_okx_asset_lines_v;
1029: End If;
1030: Close c_txl_asset_number;

Line 1120: If c_okx_assets_v%ISOPEN Then

1116: End If;
1117: If c_txd_assets_v%ISOPEN Then
1118: CLOSE c_txd_assets_v;
1119: End If;
1120: If c_okx_assets_v%ISOPEN Then
1121: CLOSE c_okx_assets_v;
1122: End If;
1123: If c_okx_asset_lines_v%ISOPEN Then
1124: CLOSE c_okx_asset_lines_v;

Line 1121: CLOSE c_okx_assets_v;

1117: If c_txd_assets_v%ISOPEN Then
1118: CLOSE c_txd_assets_v;
1119: End If;
1120: If c_okx_assets_v%ISOPEN Then
1121: CLOSE c_okx_assets_v;
1122: End If;
1123: If c_okx_asset_lines_v%ISOPEN Then
1124: CLOSE c_okx_asset_lines_v;
1125: End If;

Line 1145: If c_okx_assets_v%ISOPEN Then

1141: End If;
1142: If c_txd_assets_v%ISOPEN Then
1143: CLOSE c_txd_assets_v;
1144: End If;
1145: If c_okx_assets_v%ISOPEN Then
1146: CLOSE c_okx_assets_v;
1147: End If;
1148: If c_okx_asset_lines_v%ISOPEN Then
1149: CLOSE c_okx_asset_lines_v;

Line 1146: CLOSE c_okx_assets_v;

1142: If c_txd_assets_v%ISOPEN Then
1143: CLOSE c_txd_assets_v;
1144: End If;
1145: If c_okx_assets_v%ISOPEN Then
1146: CLOSE c_okx_assets_v;
1147: End If;
1148: If c_okx_asset_lines_v%ISOPEN Then
1149: CLOSE c_okx_asset_lines_v;
1150: End If;