647: l_reval_rsv_acct NUMBER;
648: l_concat_loc VARCHAR2(200);
649: l_concat_asset_key VARCHAR2(200);
650: l_concat_cat VARCHAR2(500);
651: l_loc_segs fa_rx_shared_pkg.Seg_Array;
652: l_asset_segs fa_rx_shared_pkg.Seg_Array;
653: l_cat_segs fa_rx_shared_pkg.Seg_Array;
654: l_stl_rate NUMBER;
655: l_CFDescription VARCHAR2(40);
648: l_concat_loc VARCHAR2(200);
649: l_concat_asset_key VARCHAR2(200);
650: l_concat_cat VARCHAR2(500);
651: l_loc_segs fa_rx_shared_pkg.Seg_Array;
652: l_asset_segs fa_rx_shared_pkg.Seg_Array;
653: l_cat_segs fa_rx_shared_pkg.Seg_Array;
654: l_stl_rate NUMBER;
655: l_CFDescription VARCHAR2(40);
656: l_path VARCHAR2(150);
649: l_concat_asset_key VARCHAR2(200);
650: l_concat_cat VARCHAR2(500);
651: l_loc_segs fa_rx_shared_pkg.Seg_Array;
652: l_asset_segs fa_rx_shared_pkg.Seg_Array;
653: l_cat_segs fa_rx_shared_pkg.Seg_Array;
654: l_stl_rate NUMBER;
655: l_CFDescription VARCHAR2(40);
656: l_path VARCHAR2(150);
657:
864:
865: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
866:
867: -- This will get the CONCATANATED LOCATION
868: fa_rx_shared_pkg.concat_location (
869: struct_id => l_g_loc_struct
870: ,ccid => l_location_id
871: ,concat_string => l_concat_loc
872: ,segarray => l_loc_segs);
871: ,concat_string => l_concat_loc
872: ,segarray => l_loc_segs);
873:
874: -- This will get the CONCATANATED ASSETKEY
875: fa_rx_shared_pkg.concat_asset_key (
876: struct_id => l_g_asset_key_struct
877: ,ccid => l_asset_key_ccid
878: ,concat_string => l_concat_asset_key
879: ,segarray => l_asset_segs);
878: ,concat_string => l_concat_asset_key
879: ,segarray => l_asset_segs);
880:
881: -- This gets the CONCATENATED CATEGORY NAME
882: fa_rx_shared_pkg.concat_category (
883: struct_id => l_g_cat_struct,
884: ccid => l_asset_cat_id,
885: concat_string => l_concat_cat,
886: segarray => l_cat_segs);
1040: l_reval_rsv_acct NUMBER;
1041: l_concat_loc VARCHAR2(240);
1042: l_concat_asset_key VARCHAR2(240);
1043: l_concat_cat VARCHAR2(600);
1044: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1045: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1046: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1047: l_stl_rate NUMBER;
1048: l_CFDescription VARCHAR2(40);
1041: l_concat_loc VARCHAR2(240);
1042: l_concat_asset_key VARCHAR2(240);
1043: l_concat_cat VARCHAR2(600);
1044: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1045: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1046: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1047: l_stl_rate NUMBER;
1048: l_CFDescription VARCHAR2(40);
1049: l_ADDescription fa_additions.description%type;
1042: l_concat_asset_key VARCHAR2(240);
1043: l_concat_cat VARCHAR2(600);
1044: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1045: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1046: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1047: l_stl_rate NUMBER;
1048: l_CFDescription VARCHAR2(40);
1049: l_ADDescription fa_additions.description%type;
1050: l_from_asset VARCHAR2(100);
1365: l_stl_rate := NULL;
1366: END IF;
1367:
1368: -- This will get the CONCATANATED LOCATION
1369: fa_rx_shared_pkg.concat_location (
1370: struct_id => l_g_loc_struct
1371: ,ccid => l_location_id
1372: ,concat_string => l_concat_loc
1373: ,segarray => l_loc_segs);
1372: ,concat_string => l_concat_loc
1373: ,segarray => l_loc_segs);
1374:
1375: -- This will get the CONCATANATED ASSETKEY
1376: fa_rx_shared_pkg.concat_asset_key (
1377: struct_id => l_g_asset_key_struct
1378: ,ccid => l_asset_key_ccid
1379: ,concat_string => l_concat_asset_key
1380: ,segarray => l_asset_segs);
1379: ,concat_string => l_concat_asset_key
1380: ,segarray => l_asset_segs);
1381:
1382: -- This gets the CONCATENATED CATEGORY NAME
1383: fa_rx_shared_pkg.concat_category (
1384: struct_id => l_g_cat_struct,
1385: ccid => l_asset_cat_id,
1386: concat_string => l_concat_cat,
1387: segarray => l_cat_segs);
1557: l_reval_rsv_acct NUMBER;
1558: l_concat_loc VARCHAR2(200);
1559: l_concat_asset_key VARCHAR2(200);
1560: l_concat_cat VARCHAR2(500);
1561: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1562: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1563: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1564: l_stl_rate NUMBER;
1565: l_CFDescription VARCHAR2(40);
1558: l_concat_loc VARCHAR2(200);
1559: l_concat_asset_key VARCHAR2(200);
1560: l_concat_cat VARCHAR2(500);
1561: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1562: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1563: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1564: l_stl_rate NUMBER;
1565: l_CFDescription VARCHAR2(40);
1566: l_path VARCHAR2(150);
1559: l_concat_asset_key VARCHAR2(200);
1560: l_concat_cat VARCHAR2(500);
1561: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1562: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1563: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1564: l_stl_rate NUMBER;
1565: l_CFDescription VARCHAR2(40);
1566: l_path VARCHAR2(150);
1567:
1764:
1765: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
1766:
1767: -- This will get the CONCATANATED LOCATION
1768: fa_rx_shared_pkg.concat_location (
1769: struct_id => l_g_loc_struct
1770: ,ccid => l_location_id
1771: ,concat_string => l_concat_loc
1772: ,segarray => l_loc_segs);
1771: ,concat_string => l_concat_loc
1772: ,segarray => l_loc_segs);
1773:
1774: -- This will get the CONCATANATED ASSETKEY
1775: fa_rx_shared_pkg.concat_asset_key (
1776: struct_id => l_g_asset_key_struct
1777: ,ccid => l_asset_key_ccid
1778: ,concat_string => l_concat_asset_key
1779: ,segarray => l_asset_segs);
1780:
1781:
1782:
1783: -- This gets the CONCATENATED CATEGORY NAME
1784: fa_rx_shared_pkg.concat_category (
1785: struct_id => l_g_cat_struct,
1786: ccid => l_asset_cat_id,
1787: concat_string => l_concat_cat,
1788: segarray => l_cat_segs);
1933: l_reval_rsv_acct NUMBER;
1934: l_concat_loc VARCHAR2(240);
1935: l_concat_asset_key VARCHAR2(240);
1936: l_concat_cat VARCHAR2(600);
1937: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1938: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1939: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1940: l_stl_rate NUMBER;
1941: l_CFDescription VARCHAR2(40);
1934: l_concat_loc VARCHAR2(240);
1935: l_concat_asset_key VARCHAR2(240);
1936: l_concat_cat VARCHAR2(600);
1937: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1938: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1939: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1940: l_stl_rate NUMBER;
1941: l_CFDescription VARCHAR2(40);
1942: l_ADDescription fa_additions.description%type;
1935: l_concat_asset_key VARCHAR2(240);
1936: l_concat_cat VARCHAR2(600);
1937: l_loc_segs fa_rx_shared_pkg.Seg_Array;
1938: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1939: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1940: l_stl_rate NUMBER;
1941: l_CFDescription VARCHAR2(40);
1942: l_ADDescription fa_additions.description%type;
1943: l_from_asset VARCHAR2(100);
2248: l_stl_rate := NULL;
2249: END IF;
2250:
2251: -- This will get the CONCATANATED LOCATION
2252: fa_rx_shared_pkg.concat_location (
2253: struct_id => l_g_loc_struct
2254: ,ccid => l_location_id
2255: ,concat_string => l_concat_loc
2256: ,segarray => l_loc_segs);
2255: ,concat_string => l_concat_loc
2256: ,segarray => l_loc_segs);
2257:
2258: -- This will get the CONCATANATED ASSETKEY
2259: fa_rx_shared_pkg.concat_asset_key (
2260: struct_id => l_g_asset_key_struct
2261: ,ccid => l_asset_key_ccid
2262: ,concat_string => l_concat_asset_key
2263: ,segarray => l_asset_segs);
2262: ,concat_string => l_concat_asset_key
2263: ,segarray => l_asset_segs);
2264:
2265: -- This gets the CONCATENATED CATEGORY NAME
2266: fa_rx_shared_pkg.concat_category (
2267: struct_id => l_g_cat_struct,
2268: ccid => l_asset_cat_id,
2269: concat_string => l_concat_cat,
2270: segarray => l_cat_segs);
2441: l_reval_rsv_acct NUMBER;
2442: l_concat_loc VARCHAR2(200);
2443: l_concat_asset_key VARCHAR2(200);
2444: l_concat_cat VARCHAR2(500);
2445: l_loc_segs fa_rx_shared_pkg.Seg_Array;
2446: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2447: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2448: l_stl_rate NUMBER;
2449: l_CFDescription VARCHAR2(40);
2442: l_concat_loc VARCHAR2(200);
2443: l_concat_asset_key VARCHAR2(200);
2444: l_concat_cat VARCHAR2(500);
2445: l_loc_segs fa_rx_shared_pkg.Seg_Array;
2446: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2447: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2448: l_stl_rate NUMBER;
2449: l_CFDescription VARCHAR2(40);
2450: l_path VARCHAR2(150);
2443: l_concat_asset_key VARCHAR2(200);
2444: l_concat_cat VARCHAR2(500);
2445: l_loc_segs fa_rx_shared_pkg.Seg_Array;
2446: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2447: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2448: l_stl_rate NUMBER;
2449: l_CFDescription VARCHAR2(40);
2450: l_path VARCHAR2(150);
2451:
2650:
2651: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
2652:
2653: -- This will get the CONCATANATED LOCATION
2654: fa_rx_shared_pkg.concat_location (
2655: struct_id => l_g_loc_struct
2656: ,ccid => l_location_id
2657: ,concat_string => l_concat_loc
2658: ,segarray => l_loc_segs);
2657: ,concat_string => l_concat_loc
2658: ,segarray => l_loc_segs);
2659:
2660: -- This will get the CONCATANATED ASSETKEY
2661: fa_rx_shared_pkg.concat_asset_key (
2662: struct_id => l_g_asset_key_struct
2663: ,ccid => l_asset_key_ccid
2664: ,concat_string => l_concat_asset_key
2665: ,segarray => l_asset_segs);
2666:
2667:
2668:
2669: -- This gets the CONCATENATED CATEGORY NAME
2670: fa_rx_shared_pkg.concat_category (
2671: struct_id => l_g_cat_struct,
2672: ccid => l_asset_cat_id,
2673: concat_string => l_concat_cat,
2674: segarray => l_cat_segs);
2832: l_reval_rsv_acct NUMBER;
2833: l_concat_loc VARCHAR2(240);
2834: l_concat_asset_key VARCHAR2(240);
2835: l_concat_cat VARCHAR2(600);
2836: l_loc_segs fa_rx_shared_pkg.Seg_Array;
2837: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2838: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2839: l_stl_rate NUMBER;
2840: l_CFDescription VARCHAR2(40);
2833: l_concat_loc VARCHAR2(240);
2834: l_concat_asset_key VARCHAR2(240);
2835: l_concat_cat VARCHAR2(600);
2836: l_loc_segs fa_rx_shared_pkg.Seg_Array;
2837: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2838: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2839: l_stl_rate NUMBER;
2840: l_CFDescription VARCHAR2(40);
2841: l_ADDescription fa_additions.description%type;
2834: l_concat_asset_key VARCHAR2(240);
2835: l_concat_cat VARCHAR2(600);
2836: l_loc_segs fa_rx_shared_pkg.Seg_Array;
2837: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2838: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2839: l_stl_rate NUMBER;
2840: l_CFDescription VARCHAR2(40);
2841: l_ADDescription fa_additions.description%type;
2842: l_from_asset VARCHAR2(100);
3145: l_stl_rate := NULL;
3146: END IF;
3147:
3148: -- This will get the CONCATANATED LOCATION
3149: fa_rx_shared_pkg.concat_location (
3150: struct_id => l_g_loc_struct
3151: ,ccid => l_location_id
3152: ,concat_string => l_concat_loc
3153: ,segarray => l_loc_segs);
3152: ,concat_string => l_concat_loc
3153: ,segarray => l_loc_segs);
3154:
3155: -- This will get the CONCATANATED ASSETKEY
3156: fa_rx_shared_pkg.concat_asset_key (
3157: struct_id => l_g_asset_key_struct
3158: ,ccid => l_asset_key_ccid
3159: ,concat_string => l_concat_asset_key
3160: ,segarray => l_asset_segs);
3159: ,concat_string => l_concat_asset_key
3160: ,segarray => l_asset_segs);
3161:
3162: -- This gets the CONCATENATED CATEGORY NAME
3163: fa_rx_shared_pkg.concat_category (
3164: struct_id => l_g_cat_struct,
3165: ccid => l_asset_cat_id,
3166: concat_string => l_concat_cat,
3167: segarray => l_cat_segs);
3337: l_reval_rsv_acct NUMBER;
3338: l_concat_loc VARCHAR2(200);
3339: l_concat_asset_key VARCHAR2(200);
3340: l_concat_cat VARCHAR2(500);
3341: l_loc_segs fa_rx_shared_pkg.Seg_Array;
3342: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3343: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3344: l_stl_rate NUMBER;
3345: l_CFDescription VARCHAR2(40);
3338: l_concat_loc VARCHAR2(200);
3339: l_concat_asset_key VARCHAR2(200);
3340: l_concat_cat VARCHAR2(500);
3341: l_loc_segs fa_rx_shared_pkg.Seg_Array;
3342: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3343: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3344: l_stl_rate NUMBER;
3345: l_CFDescription VARCHAR2(40);
3346: l_path VARCHAR2(150);
3339: l_concat_asset_key VARCHAR2(200);
3340: l_concat_cat VARCHAR2(500);
3341: l_loc_segs fa_rx_shared_pkg.Seg_Array;
3342: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3343: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3344: l_stl_rate NUMBER;
3345: l_CFDescription VARCHAR2(40);
3346: l_path VARCHAR2(150);
3347:
3547: END IF;
3548: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
3549:
3550: -- This will get the CONCATANATED LOCATION
3551: fa_rx_shared_pkg.concat_location (
3552: struct_id => l_g_loc_struct
3553: ,ccid => l_location_id
3554: ,concat_string => l_concat_loc
3555: ,segarray => l_loc_segs);
3554: ,concat_string => l_concat_loc
3555: ,segarray => l_loc_segs);
3556:
3557: -- This will get the CONCATANATED ASSETKEY
3558: fa_rx_shared_pkg.concat_asset_key (
3559: struct_id => l_g_asset_key_struct
3560: ,ccid => l_asset_key_ccid
3561: ,concat_string => l_concat_asset_key
3562: ,segarray => l_asset_segs);
3563:
3564:
3565:
3566: -- This gets the CONCATENATED CATEGORY NAME
3567: fa_rx_shared_pkg.concat_category (
3568: struct_id => l_g_cat_struct,
3569: ccid => l_asset_cat_id,
3570: concat_string => l_concat_cat,
3571: segarray => l_cat_segs);
3727: l_reval_rsv_acct NUMBER;
3728: l_concat_loc VARCHAR2(200);
3729: l_concat_asset_key VARCHAR2(200);
3730: l_concat_cat VARCHAR2(500);
3731: l_loc_segs fa_rx_shared_pkg.Seg_Array;
3732: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3733: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3734: l_stl_rate NUMBER;
3735: l_CFDescription VARCHAR2(40);
3728: l_concat_loc VARCHAR2(200);
3729: l_concat_asset_key VARCHAR2(200);
3730: l_concat_cat VARCHAR2(500);
3731: l_loc_segs fa_rx_shared_pkg.Seg_Array;
3732: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3733: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3734: l_stl_rate NUMBER;
3735: l_CFDescription VARCHAR2(40);
3736: l_ADDescription fa_additions.description%type;
3729: l_concat_asset_key VARCHAR2(200);
3730: l_concat_cat VARCHAR2(500);
3731: l_loc_segs fa_rx_shared_pkg.Seg_Array;
3732: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3733: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3734: l_stl_rate NUMBER;
3735: l_CFDescription VARCHAR2(40);
3736: l_ADDescription fa_additions.description%type;
3737: l_from_asset VARCHAR2(100);
4043: l_stl_rate := NULL;
4044: END IF;
4045:
4046: -- This will get the CONCATANATED LOCATION
4047: fa_rx_shared_pkg.concat_location (
4048: struct_id => l_g_loc_struct
4049: ,ccid => l_location_id
4050: ,concat_string => l_concat_loc
4051: ,segarray => l_loc_segs);
4050: ,concat_string => l_concat_loc
4051: ,segarray => l_loc_segs);
4052:
4053: -- This will get the CONCATANATED ASSETKEY
4054: fa_rx_shared_pkg.concat_asset_key (
4055: struct_id => l_g_asset_key_struct
4056: ,ccid => l_asset_key_ccid
4057: ,concat_string => l_concat_asset_key
4058: ,segarray => l_asset_segs);
4057: ,concat_string => l_concat_asset_key
4058: ,segarray => l_asset_segs);
4059:
4060: -- This gets the CONCATENATED CATEGORY NAME
4061: fa_rx_shared_pkg.concat_category (
4062: struct_id => l_g_cat_struct,
4063: ccid => l_asset_cat_id,
4064: concat_string => l_concat_cat,
4065: segarray => l_cat_segs);