[Home] [Help]
1838:
1839: /* Added to fix issues due to varying numeric formats */
1840: /* Commented the below code as the below conversion fails if the application numeric format
1841: is set to ',' and handled the conversion while inserting the data in archive tables throug API*/
1842: /*l_mkode0600 := fnd_number.number_to_canonical(l_mkode0600 );
1843: l_mkode0610 := fnd_number.number_to_canonical(l_mkode0610);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1839: /* Added to fix issues due to varying numeric formats */
1840: /* Commented the below code as the below conversion fails if the application numeric format
1841: is set to ',' and handled the conversion while inserting the data in archive tables throug API*/
1842: /*l_mkode0600 := fnd_number.number_to_canonical(l_mkode0600 );
1843: l_mkode0610 := fnd_number.number_to_canonical(l_mkode0610);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1840: /* Commented the below code as the below conversion fails if the application numeric format
1841: is set to ',' and handled the conversion while inserting the data in archive tables throug API*/
1842: /*l_mkode0600 := fnd_number.number_to_canonical(l_mkode0600 );
1843: l_mkode0610 := fnd_number.number_to_canonical(l_mkode0610);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1841: is set to ',' and handled the conversion while inserting the data in archive tables throug API*/
1842: /*l_mkode0600 := fnd_number.number_to_canonical(l_mkode0600 );
1843: l_mkode0610 := fnd_number.number_to_canonical(l_mkode0610);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1842: /*l_mkode0600 := fnd_number.number_to_canonical(l_mkode0600 );
1843: l_mkode0610 := fnd_number.number_to_canonical(l_mkode0610);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1843: l_mkode0610 := fnd_number.number_to_canonical(l_mkode0610);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1844: l_mkode0620 := fnd_number.number_to_canonical(l_mkode0620);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1845: l_iltype_0010_bal := fnd_number.number_to_canonical(l_iltype_0010_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1846: l_iltype_0011_bal := fnd_number.number_to_canonical(l_iltype_0011_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1847: l_iltype_0013_bal := fnd_number.number_to_canonical(l_iltype_0013_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1848: l_iltype_0015_bal := fnd_number.number_to_canonical(l_iltype_0015_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1849: --l_iltype_0021_bal := fnd_number.number_to_canonical(l_iltype_0021_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1850: l_iltype_0121_bal := fnd_number.number_to_canonical(l_iltype_0121_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1851: l_iltype_0122_bal := fnd_number.number_to_canonical(l_iltype_0122_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1852: l_iltype_0027_bal := fnd_number.number_to_canonical(l_iltype_0027_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1853: l_iltype_0022_bal := fnd_number.number_to_canonical(l_iltype_0022_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1854: l_iltype_0023_bal := fnd_number.number_to_canonical(l_iltype_0023_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1855: l_iltype_0024_bal := fnd_number.number_to_canonical(l_iltype_0024_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1856: l_iltype_0025_bal := fnd_number.number_to_canonical(l_iltype_0025_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1857: l_iltype_0026_bal := fnd_number.number_to_canonical(l_iltype_0026_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1858: l_iltype_0029_bal := fnd_number.number_to_canonical(l_iltype_0029_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1859: --l_iltype_0032_bal := fnd_number.number_to_canonical(l_iltype_0032_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1860: l_iltype_0034_bal := fnd_number.number_to_canonical(l_iltype_0034_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1861: l_iltype_0035_bal := fnd_number.number_to_canonical(l_iltype_0035_bal);
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1862: l_iltype_0036_bal := fnd_number.number_to_canonical(l_iltype_0036_bal);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1863: l_iltype_0037_bal := fnd_number.number_to_canonical(l_iltype_0037_bal);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1864: l_iltype_0091_bal := fnd_number.number_to_canonical(l_iltype_0091_bal);
1865: l_iltype_0210_bal := fnd_number.number_to_canonical(l_iltype_0210_bal);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1866: l_iltype_0132_bal := fnd_number.number_to_canonical(l_iltype_0132_bal);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1867: l_iltype_0232_bal := fnd_number.number_to_canonical(l_iltype_0232_bal);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1868: l_iltype_0332_bal := fnd_number.number_to_canonical(l_iltype_0332_bal);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1869:
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1870: l_iltype_0010_unit := fnd_number.number_to_canonical(l_iltype_0010_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1871: l_iltype_0011_unit := fnd_number.number_to_canonical(l_iltype_0011_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1872: l_iltype_0013_unit := fnd_number.number_to_canonical(l_iltype_0013_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1873: l_iltype_0015_unit := fnd_number.number_to_canonical(l_iltype_0015_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1874: --l_iltype_0021_unit := fnd_number.number_to_canonical(l_iltype_0021_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1875: l_iltype_0121_unit := fnd_number.number_to_canonical(l_iltype_0121_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1876: l_iltype_0122_unit := fnd_number.number_to_canonical(l_iltype_0122_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1877: l_iltype_0022_unit := fnd_number.number_to_canonical(l_iltype_0022_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1878: l_iltype_0023_unit := fnd_number.number_to_canonical(l_iltype_0023_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1879: l_iltype_0024_unit := fnd_number.number_to_canonical(l_iltype_0024_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1880: l_iltype_0025_unit := fnd_number.number_to_canonical(l_iltype_0025_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1881: l_iltype_0026_unit := fnd_number.number_to_canonical(l_iltype_0026_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1882: l_iltype_0027_unit := fnd_number.number_to_canonical(l_iltype_0027_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1883: l_iltype_0029_unit := fnd_number.number_to_canonical(l_iltype_0029_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1884: --l_iltype_0032_unit := fnd_number.number_to_canonical(l_iltype_0032_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1892: l_iltype_0232_unit := fnd_number.number_to_canonical(l_iltype_0232_unit);
1885: l_iltype_0034_unit := fnd_number.number_to_canonical(l_iltype_0034_unit);
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1892: l_iltype_0232_unit := fnd_number.number_to_canonical(l_iltype_0232_unit);
1893: l_iltype_0332_unit := fnd_number.number_to_canonical(l_iltype_0332_unit); */
1886: l_iltype_0035_unit := fnd_number.number_to_canonical(l_iltype_0035_unit);
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1892: l_iltype_0232_unit := fnd_number.number_to_canonical(l_iltype_0232_unit);
1893: l_iltype_0332_unit := fnd_number.number_to_canonical(l_iltype_0332_unit); */
1894:
1887: l_iltype_0036_unit := fnd_number.number_to_canonical(l_iltype_0036_unit);
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1892: l_iltype_0232_unit := fnd_number.number_to_canonical(l_iltype_0232_unit);
1893: l_iltype_0332_unit := fnd_number.number_to_canonical(l_iltype_0332_unit); */
1894:
1895: -- Creating Initial Archive Entries
1888: l_iltype_0037_unit := fnd_number.number_to_canonical(l_iltype_0037_unit);
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1892: l_iltype_0232_unit := fnd_number.number_to_canonical(l_iltype_0232_unit);
1893: l_iltype_0332_unit := fnd_number.number_to_canonical(l_iltype_0332_unit); */
1894:
1895: -- Creating Initial Archive Entries
1896: /*Changes for Lunar Payroll */
1889: l_iltype_0091_unit := fnd_number.number_to_canonical(l_iltype_0091_unit);
1890: l_iltype_0210_unit := fnd_number.number_to_canonical(l_iltype_0210_unit);
1891: l_iltype_0132_unit := fnd_number.number_to_canonical(l_iltype_0132_unit);
1892: l_iltype_0232_unit := fnd_number.number_to_canonical(l_iltype_0232_unit);
1893: l_iltype_0332_unit := fnd_number.number_to_canonical(l_iltype_0332_unit); */
1894:
1895: -- Creating Initial Archive Entries
1896: /*Changes for Lunar Payroll */
1897: If csr_rec.payroll_period = '4' then
1924: ,p_action_information12 => l_mkode0610 -- MKODE of IPTYPE 0610
1925: ,p_action_information13 => l_mkode0620 -- MKODE of IPTYPE 0620
1926: ,p_action_information14 => to_char(l_lnr_payroll_period) -- MKODE of IPTYPE 0700 /*Changes for Lunar Payroll */
1927: ,p_action_information15 => csr_rec.sal_basis_mkode -- MKODE of IPTYPE 0800
1928: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0010_bal) -- Balance for ILTYPE 0010
1929: ,p_action_information17 => fnd_number.number_to_canonical(l_iltype_0011_bal) -- Balance for ILTYPE 0011
1930: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0013_bal) -- Balance for ILTYPE 0013
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1925: ,p_action_information13 => l_mkode0620 -- MKODE of IPTYPE 0620
1926: ,p_action_information14 => to_char(l_lnr_payroll_period) -- MKODE of IPTYPE 0700 /*Changes for Lunar Payroll */
1927: ,p_action_information15 => csr_rec.sal_basis_mkode -- MKODE of IPTYPE 0800
1928: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0010_bal) -- Balance for ILTYPE 0010
1929: ,p_action_information17 => fnd_number.number_to_canonical(l_iltype_0011_bal) -- Balance for ILTYPE 0011
1930: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0013_bal) -- Balance for ILTYPE 0013
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1926: ,p_action_information14 => to_char(l_lnr_payroll_period) -- MKODE of IPTYPE 0700 /*Changes for Lunar Payroll */
1927: ,p_action_information15 => csr_rec.sal_basis_mkode -- MKODE of IPTYPE 0800
1928: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0010_bal) -- Balance for ILTYPE 0010
1929: ,p_action_information17 => fnd_number.number_to_canonical(l_iltype_0011_bal) -- Balance for ILTYPE 0011
1930: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0013_bal) -- Balance for ILTYPE 0013
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1927: ,p_action_information15 => csr_rec.sal_basis_mkode -- MKODE of IPTYPE 0800
1928: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0010_bal) -- Balance for ILTYPE 0010
1929: ,p_action_information17 => fnd_number.number_to_canonical(l_iltype_0011_bal) -- Balance for ILTYPE 0011
1930: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0013_bal) -- Balance for ILTYPE 0013
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1929: ,p_action_information17 => fnd_number.number_to_canonical(l_iltype_0011_bal) -- Balance for ILTYPE 0011
1930: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0013_bal) -- Balance for ILTYPE 0013
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1930: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0013_bal) -- Balance for ILTYPE 0013
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1931: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0015_bal) -- Balance for ILTYPE 0015
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1939: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0034_bal) -- Balance for ILTYPE 0034
1932: ,p_action_information20 => NULL -- Balance for ILTYPE 0021
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1939: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0034_bal) -- Balance for ILTYPE 0034
1940: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0036_bal) -- Balance for ILTYPE 0036
1933: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0022_bal) -- Balance for ILTYPE 0022
1934: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0023_bal) -- Balance for ILTYPE 0023
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1939: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0034_bal) -- Balance for ILTYPE 0034
1940: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0036_bal) -- Balance for ILTYPE 0036
1941: ,p_action_information29 => fnd_number.number_to_canonical(l_iltype_0037_bal) -- Balance for ILTYPE 0037
1935: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0024_bal) -- Balance for ILTYPE 0024
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1939: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0034_bal) -- Balance for ILTYPE 0034
1940: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0036_bal) -- Balance for ILTYPE 0036
1941: ,p_action_information29 => fnd_number.number_to_canonical(l_iltype_0037_bal) -- Balance for ILTYPE 0037
1942: ,p_action_information30 => l_hourly_salaried -- Hourly/Salaried
1943: );
1936: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0025_bal) -- Balance for ILTYPE 0025
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1939: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0034_bal) -- Balance for ILTYPE 0034
1940: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0036_bal) -- Balance for ILTYPE 0036
1941: ,p_action_information29 => fnd_number.number_to_canonical(l_iltype_0037_bal) -- Balance for ILTYPE 0037
1942: ,p_action_information30 => l_hourly_salaried -- Hourly/Salaried
1943: );
1944:
1937: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0026_bal) -- Balance for ILTYPE 0026
1938: ,p_action_information26 => NULL -- Balance for ILTYPE 0032
1939: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0034_bal) -- Balance for ILTYPE 0034
1940: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0036_bal) -- Balance for ILTYPE 0036
1941: ,p_action_information29 => fnd_number.number_to_canonical(l_iltype_0037_bal) -- Balance for ILTYPE 0037
1942: ,p_action_information30 => l_hourly_salaried -- Hourly/Salaried
1943: );
1944:
1945: --9865127 START
2111: ,p_action_information3 => p_payroll_action_id -- Payroll action id (of Archive)
2112: ,p_action_information4 => csr_rec.time_off_lieu -- Time Off in Lieu
2113: ,p_action_information5 => l_start_date_from -- csr_rec.asg_start_date -- Assignment Start Date - For Bug 9002015
2114: ,p_action_information6 => 'PART2' -- Archive part 2 on context AAP
2115: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0010_unit) -- Units for ILTYPE 0010
2116: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0011_unit) -- Units for ILTYPE 0011
2117: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0013_unit) -- Units for ILTYPE 0013
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2112: ,p_action_information4 => csr_rec.time_off_lieu -- Time Off in Lieu
2113: ,p_action_information5 => l_start_date_from -- csr_rec.asg_start_date -- Assignment Start Date - For Bug 9002015
2114: ,p_action_information6 => 'PART2' -- Archive part 2 on context AAP
2115: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0010_unit) -- Units for ILTYPE 0010
2116: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0011_unit) -- Units for ILTYPE 0011
2117: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0013_unit) -- Units for ILTYPE 0013
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2113: ,p_action_information5 => l_start_date_from -- csr_rec.asg_start_date -- Assignment Start Date - For Bug 9002015
2114: ,p_action_information6 => 'PART2' -- Archive part 2 on context AAP
2115: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0010_unit) -- Units for ILTYPE 0010
2116: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0011_unit) -- Units for ILTYPE 0011
2117: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0013_unit) -- Units for ILTYPE 0013
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2114: ,p_action_information6 => 'PART2' -- Archive part 2 on context AAP
2115: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0010_unit) -- Units for ILTYPE 0010
2116: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0011_unit) -- Units for ILTYPE 0011
2117: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0013_unit) -- Units for ILTYPE 0013
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2116: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0011_unit) -- Units for ILTYPE 0011
2117: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0013_unit) -- Units for ILTYPE 0013
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2117: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0013_unit) -- Units for ILTYPE 0013
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2118: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0015_unit) -- Units for ILTYPE 0015
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2126: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0034_unit) -- Units for ILTYPE 0034
2119: ,p_action_information11 => NULL -- Units for ILTYPE 0021
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2126: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0034_unit) -- Units for ILTYPE 0034
2127: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0036_unit) -- Units for ILTYPE 0036
2120: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0022_unit) -- Units for ILTYPE 0022
2121: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0023_unit) -- Units for ILTYPE 0023
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2126: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0034_unit) -- Units for ILTYPE 0034
2127: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0036_unit) -- Units for ILTYPE 0036
2128: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0037_unit) -- Units for ILTYPE 0037
2122: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0024_unit) -- Units for ILTYPE 0024
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2126: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0034_unit) -- Units for ILTYPE 0034
2127: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0036_unit) -- Units for ILTYPE 0036
2128: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0037_unit) -- Units for ILTYPE 0037
2129: ,p_action_information21 => to_char(l_bal_todate,'YYYYMMDD') -- Added for bug 5003220 to display end date instead of ass end date
2130: ,p_action_information22 => l_punit -- Assignment_level Production Unit Code
2123: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0025_unit) -- Units for ILTYPE 0025
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2126: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0034_unit) -- Units for ILTYPE 0034
2127: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0036_unit) -- Units for ILTYPE 0036
2128: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0037_unit) -- Units for ILTYPE 0037
2129: ,p_action_information21 => to_char(l_bal_todate,'YYYYMMDD') -- Added for bug 5003220 to display end date instead of ass end date
2130: ,p_action_information22 => l_punit -- Assignment_level Production Unit Code
2131: --8848543
2124: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0026_unit) -- Units for ILTYPE 0026
2125: ,p_action_information17 => NULL -- Units for ILTYPE 0032
2126: ,p_action_information18 => fnd_number.number_to_canonical(l_iltype_0034_unit) -- Units for ILTYPE 0034
2127: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0036_unit) -- Units for ILTYPE 0036
2128: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0037_unit) -- Units for ILTYPE 0037
2129: ,p_action_information21 => to_char(l_bal_todate,'YYYYMMDD') -- Added for bug 5003220 to display end date instead of ass end date
2130: ,p_action_information22 => l_punit -- Assignment_level Production Unit Code
2131: --8848543
2132: ,p_action_information23 => l_start_date_from -- For Bug 9266075 to_char(l_date_from,'YYYYMMDD')
2149: ,p_action_information3 => p_payroll_action_id -- Payroll action id (of Archive)
2150: ,p_action_information4 => null
2151: ,p_action_information5 => null
2152: ,p_action_information6 => 'PART3'
2153: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0121_unit)
2154: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0122_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2150: ,p_action_information4 => null
2151: ,p_action_information5 => null
2152: ,p_action_information6 => 'PART3'
2153: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0121_unit)
2154: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0122_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2151: ,p_action_information5 => null
2152: ,p_action_information6 => 'PART3'
2153: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0121_unit)
2154: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0122_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2152: ,p_action_information6 => 'PART3'
2153: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0121_unit)
2154: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0122_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2153: ,p_action_information7 => fnd_number.number_to_canonical(l_iltype_0121_unit)
2154: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0122_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2154: ,p_action_information8 => fnd_number.number_to_canonical(l_iltype_0122_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2155: ,p_action_information9 => fnd_number.number_to_canonical(l_iltype_0027_unit)
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2163: ,p_action_information17 => NULL -- Reserved for future use
2156: ,p_action_information10 => fnd_number.number_to_canonical(l_iltype_0029_unit)
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2163: ,p_action_information17 => NULL -- Reserved for future use
2164: ,p_action_information18 => NULL -- Reserved for future use
2157: ,p_action_information11 => fnd_number.number_to_canonical(l_iltype_0035_unit)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2163: ,p_action_information17 => NULL -- Reserved for future use
2164: ,p_action_information18 => NULL -- Reserved for future use
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2158: ,p_action_information12 => fnd_number.number_to_canonical(l_iltype_0091_unit)
2159: ,p_action_information13 => fnd_number.number_to_canonical(l_iltype_0210_unit)
2160: ,p_action_information14 => fnd_number.number_to_canonical(l_iltype_0132_unit)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2163: ,p_action_information17 => NULL -- Reserved for future use
2164: ,p_action_information18 => NULL -- Reserved for future use
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2161: ,p_action_information15 => fnd_number.number_to_canonical(l_iltype_0232_unit)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2163: ,p_action_information17 => NULL -- Reserved for future use
2164: ,p_action_information18 => NULL -- Reserved for future use
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2162: ,p_action_information16 => fnd_number.number_to_canonical(l_iltype_0332_unit)
2163: ,p_action_information17 => NULL -- Reserved for future use
2164: ,p_action_information18 => NULL -- Reserved for future use
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2163: ,p_action_information17 => NULL -- Reserved for future use
2164: ,p_action_information18 => NULL -- Reserved for future use
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2164: ,p_action_information18 => NULL -- Reserved for future use
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2165: ,p_action_information19 => fnd_number.number_to_canonical(l_iltype_0121_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2173: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0232_bal)
2166: ,p_action_information20 => fnd_number.number_to_canonical(l_iltype_0122_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2173: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0232_bal)
2174: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0332_bal)
2167: ,p_action_information21 => fnd_number.number_to_canonical(l_iltype_0027_bal)
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2173: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0232_bal)
2174: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0332_bal)
2175: ,p_action_information29 => NULL -- Reserved for future use
2168: ,p_action_information22 => fnd_number.number_to_canonical(l_iltype_0029_bal)
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2173: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0232_bal)
2174: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0332_bal)
2175: ,p_action_information29 => NULL -- Reserved for future use
2176: ,p_action_information30 => NULL -- Reserved for future use
2169: ,p_action_information23 => fnd_number.number_to_canonical(l_iltype_0035_bal)
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2173: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0232_bal)
2174: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0332_bal)
2175: ,p_action_information29 => NULL -- Reserved for future use
2176: ,p_action_information30 => NULL -- Reserved for future use
2177: );
2170: ,p_action_information24 => fnd_number.number_to_canonical(l_iltype_0091_bal)
2171: ,p_action_information25 => fnd_number.number_to_canonical(l_iltype_0210_bal)
2172: ,p_action_information26 => fnd_number.number_to_canonical(l_iltype_0132_bal)
2173: ,p_action_information27 => fnd_number.number_to_canonical(l_iltype_0232_bal)
2174: ,p_action_information28 => fnd_number.number_to_canonical(l_iltype_0332_bal)
2175: ,p_action_information29 => NULL -- Reserved for future use
2176: ,p_action_information30 => NULL -- Reserved for future use
2177: );
2178:
2527: iptype_tab(4).mkode := rec_get_body_info.action_information10;
2528:
2529: iptype_tab(5).iptype := '0600';
2530: /* Modified for bug number 4998056. Multiply the amount with 100 to avoid decimal point */
2531: iptype_tab(5).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information11)),2) * 100,0);
2532:
2533: iptype_tab(6).iptype := '0610';
2534: /* Modified for bug number 4998056. Multiply the amount with 100 to avoid decimal point */
2535: iptype_tab(6).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information12)),2) * 100,0);
2531: iptype_tab(5).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information11)),2) * 100,0);
2532:
2533: iptype_tab(6).iptype := '0610';
2534: /* Modified for bug number 4998056. Multiply the amount with 100 to avoid decimal point */
2535: iptype_tab(6).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information12)),2) * 100,0);
2536:
2537: iptype_tab(7).iptype := '0620';
2538: /* Modified for bug number 4998056. Multiply the amount with 100 to avoid decimal point */
2539: iptype_tab(7).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information13)),2) * 100,0);
2535: iptype_tab(6).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information12)),2) * 100,0);
2536:
2537: iptype_tab(7).iptype := '0620';
2538: /* Modified for bug number 4998056. Multiply the amount with 100 to avoid decimal point */
2539: iptype_tab(7).mkode := nvl(round(FND_NUMBER.CANONICAL_TO_NUMBER(trim(rec_get_body_info.action_information13)),2) * 100,0);
2540:
2541: iptype_tab(8).iptype := '0700';
2542: iptype_tab(8).mkode := rec_get_body_info.action_information14;
2543:
2792: END IF;
2793:
2794: xml_tab(l_counter).TagName :='TIME_UNITS';
2795: /* Modified for bug number 4997824. Multiply the balances with 100 to avoid decimal point */
2796: xml_tab(l_counter).TagValue := round(FND_NUMBER.CANONICAL_TO_NUMBER(l_bal),2) * 100;
2797: l_counter := l_counter + 1;
2798:
2799: xml_tab(l_counter).TagName :='SIGN_UNITS';
2800: xml_tab(l_counter).TagValue := l_sign;
2810: END IF;
2811:
2812: xml_tab(l_counter).TagName :='ILTYPE_BAL';
2813: /* Modified for bug number 4997824. Multiply the amount with 100 to avoid decimal point */
2814: xml_tab(l_counter).TagValue := round(FND_NUMBER.CANONICAL_TO_NUMBER(l_bal),2) * 100;
2815: l_counter := l_counter + 1;
2816:
2817: xml_tab(l_counter).TagName :='SIGN_BAL';
2818: xml_tab(l_counter).TagValue := l_sign;