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.ICX_REQ_ACCT_DIST dependencies on AK_ATTRIBUTES

Line 1715: v_ak_attributes_table varchar2_table;

1711: v_row_count NUMBER := 0;
1712: v_concatenated_segment VARCHAR2(2) := NULL;
1713: v_allocation_type VARCHAR2(30) := NULL;
1714:
1715: v_ak_attributes_table varchar2_table;
1716: v_segment_value fnd_flex_ext.SegmentArray;
1717: v_num_segments NUMBER := 0;
1718: v_percent_total NUMBER := 0;
1719:

Line 1723: cursor get_ak_attributes is

1719:
1720: v_org_id NUMBER := NULL;
1721: l NUMBER := NULL;
1722:
1723: cursor get_ak_attributes is
1724: select ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME
1725: from ak_region_items a,
1726: ak_attributes b,
1727: ak_regions c,

Line 1726: ak_attributes b,

1722:
1723: cursor get_ak_attributes is
1724: select ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME
1725: from ak_region_items a,
1726: ak_attributes b,
1727: ak_regions c,
1728: ak_object_attributes d
1729: where a.NODE_DISPLAY_FLAG = 'Y'
1730: and a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE

Line 1745: ak_attributes b,

1741:
1742: cursor check_concatenated_segment is
1743: select 1
1744: from ak_region_items a,
1745: ak_attributes b,
1746: ak_regions c,
1747: ak_object_attributes d
1748: where a.NODE_DISPLAY_FLAG = 'Y'
1749: and a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE

Line 1818: FOR ak_col IN get_ak_attributes LOOP

1814: IF v_concatenated_segment = 'N' THEN
1815: -- Find the segments turned on and build a pl/sql table to hold
1816: -- the segment attribute code
1817: l := 1;
1818: FOR ak_col IN get_ak_attributes LOOP
1819: v_ak_attributes_table(l) := ak_col.attribute_name;
1820: l := l + 1;
1821: END LOOP; /* FOR ak_col */
1822:

Line 1819: v_ak_attributes_table(l) := ak_col.attribute_name;

1815: -- Find the segments turned on and build a pl/sql table to hold
1816: -- the segment attribute code
1817: l := 1;
1818: FOR ak_col IN get_ak_attributes LOOP
1819: v_ak_attributes_table(l) := ak_col.attribute_name;
1820: l := l + 1;
1821: END LOOP; /* FOR ak_col */
1822:
1823: -- Get the total number of segments

Line 1824: v_num_segments := v_ak_attributes_table.COUNT;

1820: l := l + 1;
1821: END LOOP; /* FOR ak_col */
1822:
1823: -- Get the total number of segments
1824: v_num_segments := v_ak_attributes_table.COUNT;
1825:
1826: -- loop through every line returned to get the account segments
1827: FOR i in 1.. v_total_rows_returned LOOP
1828:

Line 1832: IF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG1' THEN

1828:
1829: -- Build the segment table for each row
1830: FOR j in 1 .. v_num_segments LOOP
1831:
1832: IF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG1' THEN
1833: v_segment_value(j) := icx_charge_acct_seg1(i);
1834: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG2' THEN
1835: v_segment_value(j) := icx_charge_acct_seg2(i);
1836: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG3' THEN

Line 1834: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG2' THEN

1830: FOR j in 1 .. v_num_segments LOOP
1831:
1832: IF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG1' THEN
1833: v_segment_value(j) := icx_charge_acct_seg1(i);
1834: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG2' THEN
1835: v_segment_value(j) := icx_charge_acct_seg2(i);
1836: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG3' THEN
1837: v_segment_value(j) := icx_charge_acct_seg3(i);
1838: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG4' THEN

Line 1836: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG3' THEN

1832: IF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG1' THEN
1833: v_segment_value(j) := icx_charge_acct_seg1(i);
1834: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG2' THEN
1835: v_segment_value(j) := icx_charge_acct_seg2(i);
1836: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG3' THEN
1837: v_segment_value(j) := icx_charge_acct_seg3(i);
1838: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG4' THEN
1839: v_segment_value(j) := icx_charge_acct_seg4(i);
1840: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG5' THEN

Line 1838: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG4' THEN

1834: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG2' THEN
1835: v_segment_value(j) := icx_charge_acct_seg2(i);
1836: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG3' THEN
1837: v_segment_value(j) := icx_charge_acct_seg3(i);
1838: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG4' THEN
1839: v_segment_value(j) := icx_charge_acct_seg4(i);
1840: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG5' THEN
1841: v_segment_value(j) := icx_charge_acct_seg5(i);
1842: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG6' THEN

Line 1840: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG5' THEN

1836: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG3' THEN
1837: v_segment_value(j) := icx_charge_acct_seg3(i);
1838: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG4' THEN
1839: v_segment_value(j) := icx_charge_acct_seg4(i);
1840: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG5' THEN
1841: v_segment_value(j) := icx_charge_acct_seg5(i);
1842: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG6' THEN
1843: v_segment_value(j) := icx_charge_acct_seg6(i);
1844: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG7' THEN

Line 1842: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG6' THEN

1838: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG4' THEN
1839: v_segment_value(j) := icx_charge_acct_seg4(i);
1840: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG5' THEN
1841: v_segment_value(j) := icx_charge_acct_seg5(i);
1842: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG6' THEN
1843: v_segment_value(j) := icx_charge_acct_seg6(i);
1844: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG7' THEN
1845: v_segment_value(j) := icx_charge_acct_seg7(i);
1846: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG8' THEN

Line 1844: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG7' THEN

1840: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG5' THEN
1841: v_segment_value(j) := icx_charge_acct_seg5(i);
1842: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG6' THEN
1843: v_segment_value(j) := icx_charge_acct_seg6(i);
1844: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG7' THEN
1845: v_segment_value(j) := icx_charge_acct_seg7(i);
1846: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG8' THEN
1847: v_segment_value(j) := icx_charge_acct_seg8(i);
1848: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG9' THEN

Line 1846: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG8' THEN

1842: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG6' THEN
1843: v_segment_value(j) := icx_charge_acct_seg6(i);
1844: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG7' THEN
1845: v_segment_value(j) := icx_charge_acct_seg7(i);
1846: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG8' THEN
1847: v_segment_value(j) := icx_charge_acct_seg8(i);
1848: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG9' THEN
1849: v_segment_value(j) := icx_charge_acct_seg9(i);
1850: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG10' THEN

Line 1848: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG9' THEN

1844: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG7' THEN
1845: v_segment_value(j) := icx_charge_acct_seg7(i);
1846: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG8' THEN
1847: v_segment_value(j) := icx_charge_acct_seg8(i);
1848: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG9' THEN
1849: v_segment_value(j) := icx_charge_acct_seg9(i);
1850: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG10' THEN
1851: v_segment_value(j) := icx_charge_acct_seg10(i);
1852: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG11' THEN

Line 1850: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG10' THEN

1846: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG8' THEN
1847: v_segment_value(j) := icx_charge_acct_seg8(i);
1848: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG9' THEN
1849: v_segment_value(j) := icx_charge_acct_seg9(i);
1850: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG10' THEN
1851: v_segment_value(j) := icx_charge_acct_seg10(i);
1852: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG11' THEN
1853: v_segment_value(j) := icx_charge_acct_seg11(i);
1854: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG12' THEN

Line 1852: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG11' THEN

1848: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG9' THEN
1849: v_segment_value(j) := icx_charge_acct_seg9(i);
1850: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG10' THEN
1851: v_segment_value(j) := icx_charge_acct_seg10(i);
1852: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG11' THEN
1853: v_segment_value(j) := icx_charge_acct_seg11(i);
1854: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG12' THEN
1855: v_segment_value(j) := icx_charge_acct_seg12(i);
1856: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG13' THEN

Line 1854: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG12' THEN

1850: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG10' THEN
1851: v_segment_value(j) := icx_charge_acct_seg10(i);
1852: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG11' THEN
1853: v_segment_value(j) := icx_charge_acct_seg11(i);
1854: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG12' THEN
1855: v_segment_value(j) := icx_charge_acct_seg12(i);
1856: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG13' THEN
1857: v_segment_value(j) := icx_charge_acct_seg13(i);
1858: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG14' THEN

Line 1856: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG13' THEN

1852: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG11' THEN
1853: v_segment_value(j) := icx_charge_acct_seg11(i);
1854: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG12' THEN
1855: v_segment_value(j) := icx_charge_acct_seg12(i);
1856: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG13' THEN
1857: v_segment_value(j) := icx_charge_acct_seg13(i);
1858: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG14' THEN
1859: v_segment_value(j) := icx_charge_acct_seg14(i);
1860: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG15' THEN

Line 1858: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG14' THEN

1854: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG12' THEN
1855: v_segment_value(j) := icx_charge_acct_seg12(i);
1856: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG13' THEN
1857: v_segment_value(j) := icx_charge_acct_seg13(i);
1858: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG14' THEN
1859: v_segment_value(j) := icx_charge_acct_seg14(i);
1860: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG15' THEN
1861: v_segment_value(j) := icx_charge_acct_seg15(i);
1862: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG16' THEN

Line 1860: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG15' THEN

1856: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG13' THEN
1857: v_segment_value(j) := icx_charge_acct_seg13(i);
1858: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG14' THEN
1859: v_segment_value(j) := icx_charge_acct_seg14(i);
1860: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG15' THEN
1861: v_segment_value(j) := icx_charge_acct_seg15(i);
1862: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG16' THEN
1863: v_segment_value(j) := icx_charge_acct_seg16(i);
1864: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG17' THEN

Line 1862: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG16' THEN

1858: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG14' THEN
1859: v_segment_value(j) := icx_charge_acct_seg14(i);
1860: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG15' THEN
1861: v_segment_value(j) := icx_charge_acct_seg15(i);
1862: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG16' THEN
1863: v_segment_value(j) := icx_charge_acct_seg16(i);
1864: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG17' THEN
1865: v_segment_value(j) := icx_charge_acct_seg17(i);
1866: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG18' THEN

Line 1864: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG17' THEN

1860: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG15' THEN
1861: v_segment_value(j) := icx_charge_acct_seg15(i);
1862: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG16' THEN
1863: v_segment_value(j) := icx_charge_acct_seg16(i);
1864: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG17' THEN
1865: v_segment_value(j) := icx_charge_acct_seg17(i);
1866: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG18' THEN
1867: v_segment_value(j) := icx_charge_acct_seg18(i);
1868: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG19' THEN

Line 1866: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG18' THEN

1862: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG16' THEN
1863: v_segment_value(j) := icx_charge_acct_seg16(i);
1864: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG17' THEN
1865: v_segment_value(j) := icx_charge_acct_seg17(i);
1866: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG18' THEN
1867: v_segment_value(j) := icx_charge_acct_seg18(i);
1868: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG19' THEN
1869: v_segment_value(j) := icx_charge_acct_seg19(i);
1870: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG20' THEN

Line 1868: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG19' THEN

1864: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG17' THEN
1865: v_segment_value(j) := icx_charge_acct_seg17(i);
1866: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG18' THEN
1867: v_segment_value(j) := icx_charge_acct_seg18(i);
1868: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG19' THEN
1869: v_segment_value(j) := icx_charge_acct_seg19(i);
1870: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG20' THEN
1871: v_segment_value(j) := icx_charge_acct_seg20(i);
1872: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG21' THEN

Line 1870: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG20' THEN

1866: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG18' THEN
1867: v_segment_value(j) := icx_charge_acct_seg18(i);
1868: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG19' THEN
1869: v_segment_value(j) := icx_charge_acct_seg19(i);
1870: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG20' THEN
1871: v_segment_value(j) := icx_charge_acct_seg20(i);
1872: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG21' THEN
1873: v_segment_value(j) := icx_charge_acct_seg21(i);
1874: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG22' THEN

Line 1872: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG21' THEN

1868: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG19' THEN
1869: v_segment_value(j) := icx_charge_acct_seg19(i);
1870: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG20' THEN
1871: v_segment_value(j) := icx_charge_acct_seg20(i);
1872: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG21' THEN
1873: v_segment_value(j) := icx_charge_acct_seg21(i);
1874: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG22' THEN
1875: v_segment_value(j) := icx_charge_acct_seg22(i);
1876: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG23' THEN

Line 1874: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG22' THEN

1870: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG20' THEN
1871: v_segment_value(j) := icx_charge_acct_seg20(i);
1872: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG21' THEN
1873: v_segment_value(j) := icx_charge_acct_seg21(i);
1874: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG22' THEN
1875: v_segment_value(j) := icx_charge_acct_seg22(i);
1876: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG23' THEN
1877: v_segment_value(j) := icx_charge_acct_seg23(i);
1878: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG24' THEN

Line 1876: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG23' THEN

1872: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG21' THEN
1873: v_segment_value(j) := icx_charge_acct_seg21(i);
1874: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG22' THEN
1875: v_segment_value(j) := icx_charge_acct_seg22(i);
1876: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG23' THEN
1877: v_segment_value(j) := icx_charge_acct_seg23(i);
1878: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG24' THEN
1879: v_segment_value(j) := icx_charge_acct_seg24(i);
1880: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG25' THEN

Line 1878: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG24' THEN

1874: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG22' THEN
1875: v_segment_value(j) := icx_charge_acct_seg22(i);
1876: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG23' THEN
1877: v_segment_value(j) := icx_charge_acct_seg23(i);
1878: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG24' THEN
1879: v_segment_value(j) := icx_charge_acct_seg24(i);
1880: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG25' THEN
1881: v_segment_value(j) := icx_charge_acct_seg25(i);
1882: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG26' THEN

Line 1880: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG25' THEN

1876: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG23' THEN
1877: v_segment_value(j) := icx_charge_acct_seg23(i);
1878: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG24' THEN
1879: v_segment_value(j) := icx_charge_acct_seg24(i);
1880: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG25' THEN
1881: v_segment_value(j) := icx_charge_acct_seg25(i);
1882: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG26' THEN
1883: v_segment_value(j) := icx_charge_acct_seg26(i);
1884: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG27' THEN

Line 1882: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG26' THEN

1878: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG24' THEN
1879: v_segment_value(j) := icx_charge_acct_seg24(i);
1880: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG25' THEN
1881: v_segment_value(j) := icx_charge_acct_seg25(i);
1882: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG26' THEN
1883: v_segment_value(j) := icx_charge_acct_seg26(i);
1884: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG27' THEN
1885: v_segment_value(j) := icx_charge_acct_seg27(i);
1886: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG28' THEN

Line 1884: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG27' THEN

1880: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG25' THEN
1881: v_segment_value(j) := icx_charge_acct_seg25(i);
1882: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG26' THEN
1883: v_segment_value(j) := icx_charge_acct_seg26(i);
1884: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG27' THEN
1885: v_segment_value(j) := icx_charge_acct_seg27(i);
1886: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG28' THEN
1887: v_segment_value(j) := icx_charge_acct_seg28(i);
1888: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG29' THEN

Line 1886: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG28' THEN

1882: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG26' THEN
1883: v_segment_value(j) := icx_charge_acct_seg26(i);
1884: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG27' THEN
1885: v_segment_value(j) := icx_charge_acct_seg27(i);
1886: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG28' THEN
1887: v_segment_value(j) := icx_charge_acct_seg28(i);
1888: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG29' THEN
1889: v_segment_value(j) := icx_charge_acct_seg29(i);
1890: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG30' THEN

Line 1888: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG29' THEN

1884: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG27' THEN
1885: v_segment_value(j) := icx_charge_acct_seg27(i);
1886: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG28' THEN
1887: v_segment_value(j) := icx_charge_acct_seg28(i);
1888: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG29' THEN
1889: v_segment_value(j) := icx_charge_acct_seg29(i);
1890: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG30' THEN
1891: v_segment_value(j) := icx_charge_acct_seg30(i);
1892: END IF; /* IF v_ak_attributes_table(j) */

Line 1890: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG30' THEN

1886: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG28' THEN
1887: v_segment_value(j) := icx_charge_acct_seg28(i);
1888: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG29' THEN
1889: v_segment_value(j) := icx_charge_acct_seg29(i);
1890: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG30' THEN
1891: v_segment_value(j) := icx_charge_acct_seg30(i);
1892: END IF; /* IF v_ak_attributes_table(j) */
1893:
1894: END LOOP; /* FOR j in 1 .. */

Line 1892: END IF; /* IF v_ak_attributes_table(j) */

1888: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG29' THEN
1889: v_segment_value(j) := icx_charge_acct_seg29(i);
1890: ELSIF v_ak_attributes_table(j) = 'ICX_CHARGE_ACCT_SEG30' THEN
1891: v_segment_value(j) := icx_charge_acct_seg30(i);
1892: END IF; /* IF v_ak_attributes_table(j) */
1893:
1894: END LOOP; /* FOR j in 1 .. */
1895:
1896: -- do not insert rows which are null or zero percent

Line 1959: CURSOR get_ak_attributes IS

1955: l_values icx_util.char240_table;
1956: v_segment_value fnd_flex_ext.SegmentArray;
1957: v_line_segments fnd_flex_ext.SegmentArray;
1958:
1959: CURSOR get_ak_attributes IS
1960: SELECT ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME,
1961: a.UPDATE_FLAG UPDATE_FLAG
1962: FROM ak_region_items a,
1963: ak_attributes b,

Line 1963: ak_attributes b,

1959: CURSOR get_ak_attributes IS
1960: SELECT ltrim(rtrim(a.ATTRIBUTE_CODE)) ATTRIBUTE_NAME,
1961: a.UPDATE_FLAG UPDATE_FLAG
1962: FROM ak_region_items a,
1963: ak_attributes b,
1964: ak_regions c
1965: WHERE a.NODE_DISPLAY_FLAG = 'Y'
1966: AND a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE
1967: AND a.ATTRIBUTE_APPLICATION_ID = b.ATTRIBUTE_APPLICATION_ID

Line 1998: ak_attributes b,

1994:
1995: CURSOR check_concatenated_segment IS
1996: SELECT 1
1997: FROM ak_region_items a,
1998: ak_attributes b,
1999: ak_regions c,
2000: ak_object_attributes d
2001: WHERE a.NODE_DISPLAY_FLAG = 'Y'
2002: AND a.ATTRIBUTE_CODE = b.ATTRIBUTE_CODE

Line 2050: FOR ak_col IN get_ak_attributes LOOP

2046: Y in the pl/sql table record to indicate whether the default account need to
2047: be inherited from the line default.
2048: */
2049: l := 1;
2050: FOR ak_col IN get_ak_attributes LOOP
2051: v_ak_segments(l).segment_name := ak_col.attribute_name;
2052: v_ak_segments(l).update_flag := ak_col.update_flag;
2053: l := l + 1;
2054: END LOOP; /* FOR ak_col */