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.IGI_IAC_RXI_I_WRAP_ASSET_BAL dependencies on FA_RX_SHARED_PKG

Line 651: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 652: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 653: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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:

Line 868: fa_rx_shared_pkg.concat_location (

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);

Line 875: fa_rx_shared_pkg.concat_asset_key (

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);

Line 882: fa_rx_shared_pkg.concat_category (

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);

Line 1044: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 1045: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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;

Line 1046: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 1369: fa_rx_shared_pkg.concat_location (

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);

Line 1376: fa_rx_shared_pkg.concat_asset_key (

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);

Line 1383: fa_rx_shared_pkg.concat_category (

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);

Line 1561: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 1562: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 1563: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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:

Line 1768: fa_rx_shared_pkg.concat_location (

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);

Line 1775: fa_rx_shared_pkg.concat_asset_key (

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);

Line 1784: fa_rx_shared_pkg.concat_category (

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);

Line 1937: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 1938: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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;

Line 1939: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 2252: fa_rx_shared_pkg.concat_location (

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);

Line 2259: fa_rx_shared_pkg.concat_asset_key (

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);

Line 2266: fa_rx_shared_pkg.concat_category (

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);

Line 2445: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 2446: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 2447: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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:

Line 2654: fa_rx_shared_pkg.concat_location (

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);

Line 2661: fa_rx_shared_pkg.concat_asset_key (

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);

Line 2670: fa_rx_shared_pkg.concat_category (

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);

Line 2836: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 2837: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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;

Line 2838: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 3149: fa_rx_shared_pkg.concat_location (

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);

Line 3156: fa_rx_shared_pkg.concat_asset_key (

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);

Line 3163: fa_rx_shared_pkg.concat_category (

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);

Line 3341: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 3342: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 3343: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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:

Line 3551: fa_rx_shared_pkg.concat_location (

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);

Line 3558: fa_rx_shared_pkg.concat_asset_key (

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);

Line 3567: fa_rx_shared_pkg.concat_category (

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);

Line 3731: l_loc_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 3732: l_asset_segs fa_rx_shared_pkg.Seg_Array;

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;

Line 3733: l_cat_segs fa_rx_shared_pkg.Seg_Array;

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);

Line 4047: fa_rx_shared_pkg.concat_location (

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);

Line 4054: fa_rx_shared_pkg.concat_asset_key (

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);

Line 4061: fa_rx_shared_pkg.concat_category (

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);