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.CN_CALC_SUBMISSION_PUB dependencies on DUAL

Line 1864: FROM dual;

1860: -- handling g_miss_* in l_p_calc_submission_rec_new
1861: SELECT Decode( l_p_calc_submission_rec.batch_name, fnd_api.g_miss_char,
1862: l_calc_sub_batch_rec.name, l_p_calc_submission_rec.batch_name )
1863: INTO l_p_calc_submission_rec.batch_name
1864: FROM dual;
1865:
1866: IF l_p_calc_submission_rec.batch_name = p_calc_submission_rec_old.batch_name THEN
1867: l_name_validate_flag := 'N';
1868: ELSE

Line 1875: FROM dual;

1871:
1872: SELECT Decode( l_p_calc_submission_rec.start_date, fnd_api.g_miss_date,
1873: l_calc_sub_batch_rec.start_date, l_p_calc_submission_rec.start_date )
1874: INTO l_p_calc_submission_rec.start_date
1875: FROM dual;
1876:
1877: SELECT Decode( l_p_calc_submission_rec.end_date, fnd_api.g_miss_date,
1878: l_calc_sub_batch_rec.end_date, l_p_calc_submission_rec.end_date )
1879: INTO l_p_calc_submission_rec.end_date

Line 1880: FROM dual;

1876:
1877: SELECT Decode( l_p_calc_submission_rec.end_date, fnd_api.g_miss_date,
1878: l_calc_sub_batch_rec.end_date, l_p_calc_submission_rec.end_date )
1879: INTO l_p_calc_submission_rec.end_date
1880: FROM dual;
1881:
1882: SELECT Decode( l_p_calc_submission_rec.calculation_type, fnd_api.g_miss_char,
1883: l_calc_sub_batch_rec.calc_type, l_p_calc_submission_rec.calculation_type )
1884: INTO l_p_calc_submission_rec.calculation_type

Line 1885: FROM dual;

1881:
1882: SELECT Decode( l_p_calc_submission_rec.calculation_type, fnd_api.g_miss_char,
1883: l_calc_sub_batch_rec.calc_type, l_p_calc_submission_rec.calculation_type )
1884: INTO l_p_calc_submission_rec.calculation_type
1885: FROM dual;
1886:
1887: SELECT Decode( l_p_calc_submission_rec.salesrep_option, fnd_api.g_miss_char,
1888: l_calc_sub_batch_rec.salesrep_option, l_p_calc_submission_rec.salesrep_option )
1889: INTO l_p_calc_submission_rec.salesrep_option

Line 1890: FROM dual;

1886:
1887: SELECT Decode( l_p_calc_submission_rec.salesrep_option, fnd_api.g_miss_char,
1888: l_calc_sub_batch_rec.salesrep_option, l_p_calc_submission_rec.salesrep_option )
1889: INTO l_p_calc_submission_rec.salesrep_option
1890: FROM dual;
1891:
1892: SELECT Decode( l_p_calc_submission_rec.entire_hierarchy, fnd_api.g_miss_char,
1893: l_calc_sub_batch_rec.hierarchy_flag, l_p_calc_submission_rec.entire_hierarchy )
1894: INTO l_p_calc_submission_rec.entire_hierarchy

Line 1895: FROM dual;

1891:
1892: SELECT Decode( l_p_calc_submission_rec.entire_hierarchy, fnd_api.g_miss_char,
1893: l_calc_sub_batch_rec.hierarchy_flag, l_p_calc_submission_rec.entire_hierarchy )
1894: INTO l_p_calc_submission_rec.entire_hierarchy
1895: FROM dual;
1896:
1897: SELECT Decode( l_p_calc_submission_rec.concurrent_calculation, fnd_api.g_miss_char,
1898: l_calc_sub_batch_rec.concurrent_flag, l_p_calc_submission_rec.concurrent_calculation )
1899: INTO l_p_calc_submission_rec.concurrent_calculation

Line 1900: FROM dual;

1896:
1897: SELECT Decode( l_p_calc_submission_rec.concurrent_calculation, fnd_api.g_miss_char,
1898: l_calc_sub_batch_rec.concurrent_flag, l_p_calc_submission_rec.concurrent_calculation )
1899: INTO l_p_calc_submission_rec.concurrent_calculation
1900: FROM dual;
1901:
1902: SELECT Decode( l_p_calc_submission_rec.incremental_calculation, fnd_api.g_miss_char,
1903: l_calc_sub_batch_rec.intelligent_flag, l_p_calc_submission_rec.incremental_calculation )
1904: INTO l_p_calc_submission_rec.incremental_calculation

Line 1905: FROM dual;

1901:
1902: SELECT Decode( l_p_calc_submission_rec.incremental_calculation, fnd_api.g_miss_char,
1903: l_calc_sub_batch_rec.intelligent_flag, l_p_calc_submission_rec.incremental_calculation )
1904: INTO l_p_calc_submission_rec.incremental_calculation
1905: FROM dual;
1906:
1907: SELECT Decode( l_p_calc_submission_rec.interval_type, fnd_api.g_miss_char,
1908: Decode( l_calc_sub_batch_rec.interval_type_id, NULL, NULL, -1000, 'PERIOD',
1909: -1001, 'QUARTER', -1002, 'YEAR', -1003 , 'ALL' ),

Line 1912: FROM dual;

1908: Decode( l_calc_sub_batch_rec.interval_type_id, NULL, NULL, -1000, 'PERIOD',
1909: -1001, 'QUARTER', -1002, 'YEAR', -1003 , 'ALL' ),
1910: l_p_calc_submission_rec.interval_type )
1911: INTO l_p_calc_submission_rec.interval_type
1912: FROM dual;
1913:
1914: SELECT Decode( l_p_calc_submission_rec.attribute_category, fnd_api.g_miss_char,
1915: l_calc_sub_batch_rec.attribute_category, l_p_calc_submission_rec.attribute_category )
1916: INTO l_p_calc_submission_rec.attribute_category

Line 1917: FROM dual;

1913:
1914: SELECT Decode( l_p_calc_submission_rec.attribute_category, fnd_api.g_miss_char,
1915: l_calc_sub_batch_rec.attribute_category, l_p_calc_submission_rec.attribute_category )
1916: INTO l_p_calc_submission_rec.attribute_category
1917: FROM dual;
1918:
1919: SELECT Decode( l_p_calc_submission_rec.attribute1, fnd_api.g_miss_char,
1920: l_calc_sub_batch_rec.attribute1, l_p_calc_submission_rec.attribute1 )
1921: INTO l_p_calc_submission_rec.attribute1

Line 1922: FROM dual;

1918:
1919: SELECT Decode( l_p_calc_submission_rec.attribute1, fnd_api.g_miss_char,
1920: l_calc_sub_batch_rec.attribute1, l_p_calc_submission_rec.attribute1 )
1921: INTO l_p_calc_submission_rec.attribute1
1922: FROM dual;
1923:
1924: SELECT Decode( l_p_calc_submission_rec.attribute2, fnd_api.g_miss_char,
1925: l_calc_sub_batch_rec.attribute2, l_p_calc_submission_rec.attribute2 )
1926: INTO l_p_calc_submission_rec.attribute2

Line 1927: FROM dual;

1923:
1924: SELECT Decode( l_p_calc_submission_rec.attribute2, fnd_api.g_miss_char,
1925: l_calc_sub_batch_rec.attribute2, l_p_calc_submission_rec.attribute2 )
1926: INTO l_p_calc_submission_rec.attribute2
1927: FROM dual;
1928:
1929: SELECT Decode( l_p_calc_submission_rec.attribute3, fnd_api.g_miss_char,
1930: l_calc_sub_batch_rec.attribute3, l_p_calc_submission_rec.attribute3 )
1931: INTO l_p_calc_submission_rec.attribute3

Line 1932: FROM dual;

1928:
1929: SELECT Decode( l_p_calc_submission_rec.attribute3, fnd_api.g_miss_char,
1930: l_calc_sub_batch_rec.attribute3, l_p_calc_submission_rec.attribute3 )
1931: INTO l_p_calc_submission_rec.attribute3
1932: FROM dual;
1933:
1934: SELECT Decode( l_p_calc_submission_rec.attribute4, fnd_api.g_miss_char,
1935: l_calc_sub_batch_rec.attribute4, l_p_calc_submission_rec.attribute4 )
1936: INTO l_p_calc_submission_rec.attribute4

Line 1937: FROM dual;

1933:
1934: SELECT Decode( l_p_calc_submission_rec.attribute4, fnd_api.g_miss_char,
1935: l_calc_sub_batch_rec.attribute4, l_p_calc_submission_rec.attribute4 )
1936: INTO l_p_calc_submission_rec.attribute4
1937: FROM dual;
1938:
1939: SELECT Decode( l_p_calc_submission_rec.attribute5, fnd_api.g_miss_char,
1940: l_calc_sub_batch_rec.attribute5, l_p_calc_submission_rec.attribute5 )
1941: INTO l_p_calc_submission_rec.attribute5

Line 1942: FROM dual;

1938:
1939: SELECT Decode( l_p_calc_submission_rec.attribute5, fnd_api.g_miss_char,
1940: l_calc_sub_batch_rec.attribute5, l_p_calc_submission_rec.attribute5 )
1941: INTO l_p_calc_submission_rec.attribute5
1942: FROM dual;
1943:
1944: SELECT Decode( l_p_calc_submission_rec.attribute6, fnd_api.g_miss_char,
1945: l_calc_sub_batch_rec.attribute6, l_p_calc_submission_rec.attribute6 )
1946: INTO l_p_calc_submission_rec.attribute6

Line 1947: FROM dual;

1943:
1944: SELECT Decode( l_p_calc_submission_rec.attribute6, fnd_api.g_miss_char,
1945: l_calc_sub_batch_rec.attribute6, l_p_calc_submission_rec.attribute6 )
1946: INTO l_p_calc_submission_rec.attribute6
1947: FROM dual;
1948:
1949: SELECT Decode( l_p_calc_submission_rec.attribute7, fnd_api.g_miss_char,
1950: l_calc_sub_batch_rec.attribute7, l_p_calc_submission_rec.attribute7 )
1951: INTO l_p_calc_submission_rec.attribute7

Line 1952: FROM dual;

1948:
1949: SELECT Decode( l_p_calc_submission_rec.attribute7, fnd_api.g_miss_char,
1950: l_calc_sub_batch_rec.attribute7, l_p_calc_submission_rec.attribute7 )
1951: INTO l_p_calc_submission_rec.attribute7
1952: FROM dual;
1953:
1954: SELECT Decode( l_p_calc_submission_rec.attribute8, fnd_api.g_miss_char,
1955: l_calc_sub_batch_rec.attribute8, l_p_calc_submission_rec.attribute8 )
1956: INTO l_p_calc_submission_rec.attribute8

Line 1957: FROM dual;

1953:
1954: SELECT Decode( l_p_calc_submission_rec.attribute8, fnd_api.g_miss_char,
1955: l_calc_sub_batch_rec.attribute8, l_p_calc_submission_rec.attribute8 )
1956: INTO l_p_calc_submission_rec.attribute8
1957: FROM dual;
1958:
1959: SELECT Decode( l_p_calc_submission_rec.attribute9, fnd_api.g_miss_char,
1960: l_calc_sub_batch_rec.attribute9, l_p_calc_submission_rec.attribute9 )
1961: INTO l_p_calc_submission_rec.attribute9

Line 1962: FROM dual;

1958:
1959: SELECT Decode( l_p_calc_submission_rec.attribute9, fnd_api.g_miss_char,
1960: l_calc_sub_batch_rec.attribute9, l_p_calc_submission_rec.attribute9 )
1961: INTO l_p_calc_submission_rec.attribute9
1962: FROM dual;
1963:
1964: SELECT Decode( l_p_calc_submission_rec.attribute10, fnd_api.g_miss_char,
1965: l_calc_sub_batch_rec.attribute10, l_p_calc_submission_rec.attribute10 )
1966: INTO l_p_calc_submission_rec.attribute10

Line 1967: FROM dual;

1963:
1964: SELECT Decode( l_p_calc_submission_rec.attribute10, fnd_api.g_miss_char,
1965: l_calc_sub_batch_rec.attribute10, l_p_calc_submission_rec.attribute10 )
1966: INTO l_p_calc_submission_rec.attribute10
1967: FROM dual;
1968:
1969: SELECT Decode( l_p_calc_submission_rec.attribute11, fnd_api.g_miss_char,
1970: l_calc_sub_batch_rec.attribute11, l_p_calc_submission_rec.attribute11 )
1971: INTO l_p_calc_submission_rec.attribute11

Line 1972: FROM dual;

1968:
1969: SELECT Decode( l_p_calc_submission_rec.attribute11, fnd_api.g_miss_char,
1970: l_calc_sub_batch_rec.attribute11, l_p_calc_submission_rec.attribute11 )
1971: INTO l_p_calc_submission_rec.attribute11
1972: FROM dual;
1973:
1974: SELECT Decode( l_p_calc_submission_rec.attribute12, fnd_api.g_miss_char,
1975: l_calc_sub_batch_rec.attribute12, l_p_calc_submission_rec.attribute12 )
1976: INTO l_p_calc_submission_rec.attribute12

Line 1977: FROM dual;

1973:
1974: SELECT Decode( l_p_calc_submission_rec.attribute12, fnd_api.g_miss_char,
1975: l_calc_sub_batch_rec.attribute12, l_p_calc_submission_rec.attribute12 )
1976: INTO l_p_calc_submission_rec.attribute12
1977: FROM dual;
1978:
1979: SELECT Decode( l_p_calc_submission_rec.attribute13, fnd_api.g_miss_char,
1980: l_calc_sub_batch_rec.attribute13, l_p_calc_submission_rec.attribute13 )
1981: INTO l_p_calc_submission_rec.attribute13

Line 1982: FROM dual;

1978:
1979: SELECT Decode( l_p_calc_submission_rec.attribute13, fnd_api.g_miss_char,
1980: l_calc_sub_batch_rec.attribute13, l_p_calc_submission_rec.attribute13 )
1981: INTO l_p_calc_submission_rec.attribute13
1982: FROM dual;
1983:
1984: SELECT Decode( l_p_calc_submission_rec.attribute14, fnd_api.g_miss_char,
1985: l_calc_sub_batch_rec.attribute14, l_p_calc_submission_rec.attribute14 )
1986: INTO l_p_calc_submission_rec.attribute14

Line 1987: FROM dual;

1983:
1984: SELECT Decode( l_p_calc_submission_rec.attribute14, fnd_api.g_miss_char,
1985: l_calc_sub_batch_rec.attribute14, l_p_calc_submission_rec.attribute14 )
1986: INTO l_p_calc_submission_rec.attribute14
1987: FROM dual;
1988:
1989: SELECT Decode( l_p_calc_submission_rec.attribute15, fnd_api.g_miss_char,
1990: l_calc_sub_batch_rec.attribute15, l_p_calc_submission_rec.attribute1 )
1991: INTO l_p_calc_submission_rec.attribute15

Line 1992: FROM dual;

1988:
1989: SELECT Decode( l_p_calc_submission_rec.attribute15, fnd_api.g_miss_char,
1990: l_calc_sub_batch_rec.attribute15, l_p_calc_submission_rec.attribute1 )
1991: INTO l_p_calc_submission_rec.attribute15
1992: FROM dual;
1993:
1994: --+
1995: -- Validate calculation submission batch level
1996: --+