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.BIS_PMV_PMF_PVT dependencies on BISFV_TARGETS

Line 1722: l_bisfv_targets_rec bisfv_targets%ROWTYPE;

1718: l_target VARCHAR2(32000);
1719:
1720: -- pvt retrieve------------------------------
1721:
1722: l_bisfv_targets_rec bisfv_targets%ROWTYPE;
1723: l_bisbv_target_levels_rec bisbv_target_levels%ROWTYPE;
1724: l_plan_id NUMBER;
1725: l_Business_Plan_Rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
1726: l_Business_Plan_Rec_p BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;

Line 1776: INTO l_bisfv_targets_rec

1772: = FND_API.G_TRUE
1773: AND l_Target_Rec.Target_ID IS NOT NULL
1774: ) THEN
1775: SELECT *
1776: INTO l_bisfv_targets_rec
1777: FROM bisfv_targets bisfv_targets
1778: WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;
1779:
1780:

Line 1777: FROM bisfv_targets bisfv_targets

1773: AND l_Target_Rec.Target_ID IS NOT NULL
1774: ) THEN
1775: SELECT *
1776: INTO l_bisfv_targets_rec
1777: FROM bisfv_targets bisfv_targets
1778: WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;
1779:
1780:
1781: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_Level_ID)

Line 1778: WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;

1774: ) THEN
1775: SELECT *
1776: INTO l_bisfv_targets_rec
1777: FROM bisfv_targets bisfv_targets
1778: WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;
1779:
1780:
1781: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_Level_ID)
1782: = FND_API.G_TRUE

Line 1830: INTO l_bisfv_targets_rec

1826: end if;
1827: --------------------------------------------
1828:
1829: SELECT *
1830: INTO l_bisfv_targets_rec
1831: FROM bisfv_targets bisfv_targets
1832: WHERE bisfv_targets.TARGET_LEVEL_ID = pTarget_Level_ID
1833: -- used to be p_Target_Rec.Plan_ID
1834: AND bisfv_targets.PLAN_ID = l_plan_id

Line 1831: FROM bisfv_targets bisfv_targets

1827: --------------------------------------------
1828:
1829: SELECT *
1830: INTO l_bisfv_targets_rec
1831: FROM bisfv_targets bisfv_targets
1832: WHERE bisfv_targets.TARGET_LEVEL_ID = pTarget_Level_ID
1833: -- used to be p_Target_Rec.Plan_ID
1834: AND bisfv_targets.PLAN_ID = l_plan_id
1835:

Line 1832: WHERE bisfv_targets.TARGET_LEVEL_ID = pTarget_Level_ID

1828:
1829: SELECT *
1830: INTO l_bisfv_targets_rec
1831: FROM bisfv_targets bisfv_targets
1832: WHERE bisfv_targets.TARGET_LEVEL_ID = pTarget_Level_ID
1833: -- used to be p_Target_Rec.Plan_ID
1834: AND bisfv_targets.PLAN_ID = l_plan_id
1835:
1836: ---changed org and time logic

Line 1834: AND bisfv_targets.PLAN_ID = l_plan_id

1830: INTO l_bisfv_targets_rec
1831: FROM bisfv_targets bisfv_targets
1832: WHERE bisfv_targets.TARGET_LEVEL_ID = pTarget_Level_ID
1833: -- used to be p_Target_Rec.Plan_ID
1834: AND bisfv_targets.PLAN_ID = l_plan_id
1835:
1836: ---changed org and time logic
1837: AND (l_org_level_value_id IS NULL
1838: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))

Line 1838: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))

1834: AND bisfv_targets.PLAN_ID = l_plan_id
1835:
1836: ---changed org and time logic
1837: AND (l_org_level_value_id IS NULL
1838: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))
1839:
1840: AND (l_time_level_value_id IS NULL
1841: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
1842:

Line 1841: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))

1837: AND (l_org_level_value_id IS NULL
1838: OR NVL(bisfv_targets.ORG_LEVEL_VALUE_ID,'T') = NVL(l_org_level_value_id, 'T'))
1839:
1840: AND (l_time_level_value_id IS NULL
1841: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
1842:
1843: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
1844: = DECODE( l_Target_Rec.Dim1_Level_Value_ID
1845: , FND_API.G_MISS_CHAR

Line 1843: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')

1839:
1840: AND (l_time_level_value_id IS NULL
1841: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
1842:
1843: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
1844: = DECODE( l_Target_Rec.Dim1_Level_Value_ID
1845: , FND_API.G_MISS_CHAR
1846: , 'T'
1847: , NVL(l_Target_Rec.Dim1_Level_Value_ID, 'T')

Line 1849: AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')

1845: , FND_API.G_MISS_CHAR
1846: , 'T'
1847: , NVL(l_Target_Rec.Dim1_Level_Value_ID, 'T')
1848: )
1849: AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')
1850: = DECODE( l_Target_Rec.Dim2_Level_Value_ID
1851: , FND_API.G_MISS_CHAR
1852: , 'T'
1853: , NVL(l_Target_Rec.Dim2_Level_Value_ID, 'T')

Line 1855: AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')

1851: , FND_API.G_MISS_CHAR
1852: , 'T'
1853: , NVL(l_Target_Rec.Dim2_Level_Value_ID, 'T')
1854: )
1855: AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')
1856: = DECODE( l_Target_Rec.Dim3_Level_Value_ID
1857: , FND_API.G_MISS_CHAR
1858: , 'T'
1859: , NVL(l_Target_Rec.Dim3_Level_Value_ID, 'T')

Line 1861: AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')

1857: , FND_API.G_MISS_CHAR
1858: , 'T'
1859: , NVL(l_Target_Rec.Dim3_Level_Value_ID, 'T')
1860: )
1861: AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')
1862: = DECODE( l_Target_Rec.Dim4_Level_Value_ID
1863: , FND_API.G_MISS_CHAR
1864: , 'T'
1865: , NVL(l_Target_Rec.Dim4_Level_Value_ID, 'T')

Line 1867: AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')

1863: , FND_API.G_MISS_CHAR
1864: , 'T'
1865: , NVL(l_Target_Rec.Dim4_Level_Value_ID, 'T')
1866: )
1867: AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')
1868: = DECODE( l_Target_Rec.Dim5_Level_Value_ID
1869: , FND_API.G_MISS_CHAR
1870: , 'T'
1871: , NVL(l_Target_Rec.Dim5_Level_Value_ID, 'T')

Line 1873: AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')

1869: , FND_API.G_MISS_CHAR
1870: , 'T'
1871: , NVL(l_Target_Rec.Dim5_Level_Value_ID, 'T')
1872: )
1873: AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')
1874: = DECODE( l_Target_Rec.Dim6_Level_Value_ID
1875: , FND_API.G_MISS_CHAR
1876: , 'T'
1877: , NVL(l_Target_Rec.Dim6_Level_Value_ID, 'T')

Line 1879: AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')

1875: , FND_API.G_MISS_CHAR
1876: , 'T'
1877: , NVL(l_Target_Rec.Dim6_Level_Value_ID, 'T')
1878: )
1879: AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')
1880: = DECODE( l_Target_Rec.Dim7_Level_Value_ID
1881: , FND_API.G_MISS_CHAR
1882: , 'T'
1883: , NVL(l_Target_Rec.Dim7_Level_Value_ID, 'T')

Line 1888: lTarget := l_bisfv_targets_rec.target;

1884: )
1885: ;
1886: END IF;
1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN

Line 1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)

1886: END IF;
1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)

Line 1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))

1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null

Line 1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)

1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null
1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))
1897: THEN
1898: Select

Line 1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))

1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null
1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))
1897: THEN
1898: Select
1899: COMPUTING_FUNCTION_ID
1900: into

Line 1903: where target_level_ID =l_bisfv_targets_rec.Target_Level_ID;

1899: COMPUTING_FUNCTION_ID
1900: into
1901: lComputing_Function_Id
1902: from bisbv_target_levels
1903: where target_level_ID =l_bisfv_targets_rec.Target_Level_ID;
1904:
1905: END IF;
1906:
1907: -- only compute target if found computing fn id

Line 1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;

1910: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE)
1911: AND (BIS_UTILITIES_PUB.Value_Not_Null
1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))
1913: THEN
1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
1916: l_Target_Rec.Target_Level_Short_Name
1917: := l_bisfv_targets_rec.Target_Level_Short_Name;
1918: l_Target_Rec.Target_Level_Name

Line 1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;

1911: AND (BIS_UTILITIES_PUB.Value_Not_Null
1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))
1913: THEN
1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
1916: l_Target_Rec.Target_Level_Short_Name
1917: := l_bisfv_targets_rec.Target_Level_Short_Name;
1918: l_Target_Rec.Target_Level_Name
1919: := l_bisfv_targets_rec.Target_Level_Name;

Line 1917: := l_bisfv_targets_rec.Target_Level_Short_Name;

1913: THEN
1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
1916: l_Target_Rec.Target_Level_Short_Name
1917: := l_bisfv_targets_rec.Target_Level_Short_Name;
1918: l_Target_Rec.Target_Level_Name
1919: := l_bisfv_targets_rec.Target_Level_Name;
1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;

Line 1919: := l_bisfv_targets_rec.Target_Level_Name;

1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
1916: l_Target_Rec.Target_Level_Short_Name
1917: := l_bisfv_targets_rec.Target_Level_Short_Name;
1918: l_Target_Rec.Target_Level_Name
1919: := l_bisfv_targets_rec.Target_Level_Name;
1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
1923: l_Target_Rec.Org_Level_Value_ID

Line 1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;

1916: l_Target_Rec.Target_Level_Short_Name
1917: := l_bisfv_targets_rec.Target_Level_Short_Name;
1918: l_Target_Rec.Target_Level_Name
1919: := l_bisfv_targets_rec.Target_Level_Name;
1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
1923: l_Target_Rec.Org_Level_Value_ID
1924: := l_bisfv_targets_rec.Org_Level_Value_ID;

Line 1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;

1917: := l_bisfv_targets_rec.Target_Level_Short_Name;
1918: l_Target_Rec.Target_Level_Name
1919: := l_bisfv_targets_rec.Target_Level_Name;
1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
1923: l_Target_Rec.Org_Level_Value_ID
1924: := l_bisfv_targets_rec.Org_Level_Value_ID;
1925: l_Target_Rec.Time_Level_Value_ID

Line 1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;

1918: l_Target_Rec.Target_Level_Name
1919: := l_bisfv_targets_rec.Target_Level_Name;
1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
1923: l_Target_Rec.Org_Level_Value_ID
1924: := l_bisfv_targets_rec.Org_Level_Value_ID;
1925: l_Target_Rec.Time_Level_Value_ID
1926: := l_bisfv_targets_rec.Time_Level_Value_ID;

Line 1924: := l_bisfv_targets_rec.Org_Level_Value_ID;

1920: l_Target_Rec.Plan_ID := l_bisfv_targets_rec.Plan_ID;
1921: l_Target_Rec.Plan_Short_Name := l_bisfv_targets_rec.Plan_Short_Name;
1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
1923: l_Target_Rec.Org_Level_Value_ID
1924: := l_bisfv_targets_rec.Org_Level_Value_ID;
1925: l_Target_Rec.Time_Level_Value_ID
1926: := l_bisfv_targets_rec.Time_Level_Value_ID;
1927: l_Target_Rec.Dim1_Level_Value_ID
1928: := l_bisfv_targets_rec.Dim1_Level_Value_ID;

Line 1926: := l_bisfv_targets_rec.Time_Level_Value_ID;

1922: l_Target_Rec.Plan_Name := l_bisfv_targets_rec.Plan_Name;
1923: l_Target_Rec.Org_Level_Value_ID
1924: := l_bisfv_targets_rec.Org_Level_Value_ID;
1925: l_Target_Rec.Time_Level_Value_ID
1926: := l_bisfv_targets_rec.Time_Level_Value_ID;
1927: l_Target_Rec.Dim1_Level_Value_ID
1928: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
1929: l_Target_Rec.Dim2_Level_Value_ID
1930: := l_bisfv_targets_rec.Dim2_Level_Value_ID;

Line 1928: := l_bisfv_targets_rec.Dim1_Level_Value_ID;

1924: := l_bisfv_targets_rec.Org_Level_Value_ID;
1925: l_Target_Rec.Time_Level_Value_ID
1926: := l_bisfv_targets_rec.Time_Level_Value_ID;
1927: l_Target_Rec.Dim1_Level_Value_ID
1928: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
1929: l_Target_Rec.Dim2_Level_Value_ID
1930: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
1931: l_Target_Rec.Dim3_Level_Value_ID
1932: := l_bisfv_targets_rec.Dim3_Level_Value_ID;

Line 1930: := l_bisfv_targets_rec.Dim2_Level_Value_ID;

1926: := l_bisfv_targets_rec.Time_Level_Value_ID;
1927: l_Target_Rec.Dim1_Level_Value_ID
1928: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
1929: l_Target_Rec.Dim2_Level_Value_ID
1930: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
1931: l_Target_Rec.Dim3_Level_Value_ID
1932: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
1933: l_Target_Rec.Dim4_Level_Value_ID
1934: := l_bisfv_targets_rec.Dim4_Level_Value_ID;

Line 1932: := l_bisfv_targets_rec.Dim3_Level_Value_ID;

1928: := l_bisfv_targets_rec.Dim1_Level_Value_ID;
1929: l_Target_Rec.Dim2_Level_Value_ID
1930: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
1931: l_Target_Rec.Dim3_Level_Value_ID
1932: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
1933: l_Target_Rec.Dim4_Level_Value_ID
1934: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
1935: l_Target_Rec.Dim5_Level_Value_ID
1936: := l_bisfv_targets_rec.Dim5_Level_Value_ID;

Line 1934: := l_bisfv_targets_rec.Dim4_Level_Value_ID;

1930: := l_bisfv_targets_rec.Dim2_Level_Value_ID;
1931: l_Target_Rec.Dim3_Level_Value_ID
1932: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
1933: l_Target_Rec.Dim4_Level_Value_ID
1934: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
1935: l_Target_Rec.Dim5_Level_Value_ID
1936: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
1937: l_Target_Rec.Dim6_Level_Value_ID
1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;

Line 1936: := l_bisfv_targets_rec.Dim5_Level_Value_ID;

1932: := l_bisfv_targets_rec.Dim3_Level_Value_ID;
1933: l_Target_Rec.Dim4_Level_Value_ID
1934: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
1935: l_Target_Rec.Dim5_Level_Value_ID
1936: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
1937: l_Target_Rec.Dim6_Level_Value_ID
1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
1939: l_Target_Rec.Dim7_Level_Value_ID
1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;

Line 1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;

1934: := l_bisfv_targets_rec.Dim4_Level_Value_ID;
1935: l_Target_Rec.Dim5_Level_Value_ID
1936: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
1937: l_Target_Rec.Dim6_Level_Value_ID
1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
1939: l_Target_Rec.Dim7_Level_Value_ID
1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;

Line 1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;

1936: := l_bisfv_targets_rec.Dim5_Level_Value_ID;
1937: l_Target_Rec.Dim6_Level_Value_ID
1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
1939: l_Target_Rec.Dim7_Level_Value_ID
1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;

Line 1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;

1937: l_Target_Rec.Dim6_Level_Value_ID
1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
1939: l_Target_Rec.Dim7_Level_Value_ID
1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;

Line 1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;

1938: := l_bisfv_targets_rec.Dim6_Level_Value_ID;
1939: l_Target_Rec.Dim7_Level_Value_ID
1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;

Line 1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;

1939: l_Target_Rec.Dim7_Level_Value_ID
1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;

Line 1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;

1940: := l_bisfv_targets_rec.Dim7_Level_Value_ID;
1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;

Line 1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;

1941: l_Target_Rec.Target := l_bisfv_targets_rec.Target;
1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name

Line 1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;

1942: l_Target_Rec.Range1_low := l_bisfv_targets_rec.Range1_low;
1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name
1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;

Line 1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;

1943: l_Target_Rec.Range1_high := l_bisfv_targets_rec.Range1_high;
1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name
1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;

Line 1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;

1944: l_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
1945: l_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name
1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;

Line 1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;

1946: l_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name
1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;
1953: l_Target_Rec.Notify_Resp2_Short_Name
1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;

Line 1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;

1947: l_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name
1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;
1953: l_Target_Rec.Notify_Resp2_Short_Name
1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;

Line 1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;

1948: l_Target_Rec.Notify_Resp1_ID := l_bisfv_targets_rec.Notify_Resp1_ID;
1949: l_Target_Rec.Notify_Resp1_Short_Name
1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;
1953: l_Target_Rec.Notify_Resp2_Short_Name
1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;

Line 1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;

1950: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;
1953: l_Target_Rec.Notify_Resp2_Short_Name
1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;
1957: l_Target_Rec.Notify_Resp3_Short_Name
1958: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;

Line 1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;

1951: l_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;
1953: l_Target_Rec.Notify_Resp2_Short_Name
1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;
1957: l_Target_Rec.Notify_Resp3_Short_Name
1958: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1959: l_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;

Line 1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;

1952: l_Target_Rec.Notify_Resp2_ID := l_bisfv_targets_rec.Notify_Resp2_ID;
1953: l_Target_Rec.Notify_Resp2_Short_Name
1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;
1957: l_Target_Rec.Notify_Resp3_Short_Name
1958: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1959: l_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1960:

Line 1958: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;

1954: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;
1957: l_Target_Rec.Notify_Resp3_Short_Name
1958: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1959: l_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1960:
1961: lTarget :=
1962: BIS_TARGET_PVT.Get_Target

Line 1959: l_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;

1955: l_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1956: l_Target_Rec.Notify_Resp3_ID := l_bisfv_targets_rec.Notify_Resp3_ID;
1957: l_Target_Rec.Notify_Resp3_Short_Name
1958: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1959: l_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1960:
1961: lTarget :=
1962: BIS_TARGET_PVT.Get_Target
1963: ( p_computing_function_id => lcomputing_function_id

Line 1971: x_range1_low := l_bisfv_targets_rec.Range1_low;

1967: END IF;
1968:
1969:
1970: xTarget := lTarget;
1971: x_range1_low := l_bisfv_targets_rec.Range1_low;
1972: x_range1_high := l_bisfv_targets_rec.Range1_high;
1973: if (l_bisfv_targets_rec.Target_ID is null) or (l_bisfv_targets_rec.Target_ID = FND_API.G_MISS_NUM) then
1974: xTarget := 'NONE';
1975: x_range1_low := 'NONE';

Line 1972: x_range1_high := l_bisfv_targets_rec.Range1_high;

1968:
1969:
1970: xTarget := lTarget;
1971: x_range1_low := l_bisfv_targets_rec.Range1_low;
1972: x_range1_high := l_bisfv_targets_rec.Range1_high;
1973: if (l_bisfv_targets_rec.Target_ID is null) or (l_bisfv_targets_rec.Target_ID = FND_API.G_MISS_NUM) then
1974: xTarget := 'NONE';
1975: x_range1_low := 'NONE';
1976: x_Range1_high := 'NONE';

Line 1973: if (l_bisfv_targets_rec.Target_ID is null) or (l_bisfv_targets_rec.Target_ID = FND_API.G_MISS_NUM) then

1969:
1970: xTarget := lTarget;
1971: x_range1_low := l_bisfv_targets_rec.Range1_low;
1972: x_range1_high := l_bisfv_targets_rec.Range1_high;
1973: if (l_bisfv_targets_rec.Target_ID is null) or (l_bisfv_targets_rec.Target_ID = FND_API.G_MISS_NUM) then
1974: xTarget := 'NONE';
1975: x_range1_low := 'NONE';
1976: x_Range1_high := 'NONE';
1977: else