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.

[Home] [Help]

APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_UNIT_VER

Line 100: igs_ps_unit_ver_all b,

96: -- Cursor to get system unit status for the unit section.
97: CURSOR c_unit_sts (cp_n_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID%TYPE) IS
98: SELECT a.s_unit_status
99: FROM igs_ps_unit_stat a,
100: igs_ps_unit_ver_all b,
101: igs_ps_unit_ofr_opt_all c
102: WHERE a.unit_status = b.unit_status
103: AND b.unit_cd = c.unit_cd
104: AND b.version_number = c.version_number

Line 1826: Purpose : Inserts into table IGS_PS_USEC_REF values inherited from igs_ps_unit_ver and IGS_PS_USEC_REF_CD

1822:
1823: /************************************************************************
1824: Created By : Aiyer
1825: Date Created By : 14/06/2001
1826: Purpose : Inserts into table IGS_PS_USEC_REF values inherited from igs_ps_unit_ver and IGS_PS_USEC_REF_CD
1827: : mandatory ref code types for unit_section with default ref code id's for the current uoo_id
1828: : at unit_section level
1829: Known limitations, enhancements or remarks:
1830: Change History :

Line 1861: -- Used to Inherit value from IGS_PS_UNIT_VER table

1857: reference_cd_type = p_c_reference_cd_type
1858: AND
1859: default_flag = 'Y';
1860:
1861: -- Used to Inherit value from IGS_PS_UNIT_VER table
1862: CURSOR c_igs_ps_unit_ver
1863: IS
1864: SELECT
1865: SHORT_TITLE,

Line 1862: CURSOR c_igs_ps_unit_ver

1858: AND
1859: default_flag = 'Y';
1860:
1861: -- Used to Inherit value from IGS_PS_UNIT_VER table
1862: CURSOR c_igs_ps_unit_ver
1863: IS
1864: SELECT
1865: SHORT_TITLE,
1866: SUBTITLE_MODIFIABLE_FLAG,

Line 1893: igs_ps_unit_ver uv

1889: ATTRIBUTE19 ,
1890: ATTRIBUTE20
1891: FROM
1892: igs_ps_unit_ofr_opt_all uoo,
1893: igs_ps_unit_ver uv
1894: WHERE
1895: uv.unit_cd = uoo.unit_cd
1896: AND
1897: uv.version_number = uoo.version_number

Line 1905: FOR cur_igs_ps_unit_ver IN c_igs_ps_unit_ver

1901: ln_usec_ref_cd_id IGS_PS_USEC_REF_CD.UNIT_SECTION_REFERENCE_CD_ID%TYPE := NULL;
1902: l_c_rowid1 VARCHAR2(25) :=NULL;
1903: l_c_rowid2 VARCHAR2(25) :=NULL;
1904: BEGIN
1905: FOR cur_igs_ps_unit_ver IN c_igs_ps_unit_ver
1906: LOOP
1907: BEGIN
1908: l_c_rowid1:=NULL;
1909: igs_ps_usec_ref_pkg.INSERT_ROW (

Line 1914: X_SHORT_TITLE => cur_igs_ps_unit_ver.Short_title,

1910: X_ROWID => l_c_rowid1,
1911: X_UNIT_SECTION_REFERENCE_ID => ln_usec_ref_id,
1912: X_UOO_ID => p_n_uoo_id,
1913: X_CLASS_SCHED_EXCLUSION_FLAG => 'N',
1914: X_SHORT_TITLE => cur_igs_ps_unit_ver.Short_title,
1915: X_SUBTITLE => NULL ,
1916: X_SUBTITLE_MODIFIABLE_FLAG => cur_igs_ps_unit_ver.Subtitle_modifiable_flag,
1917: X_REGISTRATION_EXCLUSION_FLAG => NULL ,
1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,

Line 1916: X_SUBTITLE_MODIFIABLE_FLAG => cur_igs_ps_unit_ver.Subtitle_modifiable_flag,

1912: X_UOO_ID => p_n_uoo_id,
1913: X_CLASS_SCHED_EXCLUSION_FLAG => 'N',
1914: X_SHORT_TITLE => cur_igs_ps_unit_ver.Short_title,
1915: X_SUBTITLE => NULL ,
1916: X_SUBTITLE_MODIFIABLE_FLAG => cur_igs_ps_unit_ver.Subtitle_modifiable_flag,
1917: X_REGISTRATION_EXCLUSION_FLAG => NULL ,
1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,
1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,

Line 1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,

1914: X_SHORT_TITLE => cur_igs_ps_unit_ver.Short_title,
1915: X_SUBTITLE => NULL ,
1916: X_SUBTITLE_MODIFIABLE_FLAG => cur_igs_ps_unit_ver.Subtitle_modifiable_flag,
1917: X_REGISTRATION_EXCLUSION_FLAG => NULL ,
1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,
1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,

Line 1919: X_TITLE => cur_igs_ps_unit_ver.Title ,

1915: X_SUBTITLE => NULL ,
1916: X_SUBTITLE_MODIFIABLE_FLAG => cur_igs_ps_unit_ver.Subtitle_modifiable_flag,
1917: X_REGISTRATION_EXCLUSION_FLAG => NULL ,
1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,
1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,

Line 1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,

1916: X_SUBTITLE_MODIFIABLE_FLAG => cur_igs_ps_unit_ver.Subtitle_modifiable_flag,
1917: X_REGISTRATION_EXCLUSION_FLAG => NULL ,
1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,
1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,

Line 1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,

1917: X_REGISTRATION_EXCLUSION_FLAG => NULL ,
1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,
1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,

Line 1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,

1918: X_RECORD_EXCLUSION_FLAG => cur_igs_ps_unit_ver.Record_exclusion_flag ,
1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,

Line 1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,

1919: X_TITLE => cur_igs_ps_unit_ver.Title ,
1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,

Line 1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,

1920: X_SUBTITLE_ID => cur_igs_ps_unit_ver.Subtitle_id,
1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,

Line 1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,

1921: X_ATTRIBUTE_CATEGORY => cur_igs_ps_unit_ver.Attribute_category,
1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,

Line 1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,

1922: X_ATTRIBUTE1 => cur_igs_ps_unit_ver.Attribute1 ,
1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,

Line 1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,

1923: X_ATTRIBUTE2 => cur_igs_ps_unit_ver.Attribute2 ,
1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,

Line 1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,

1924: X_ATTRIBUTE3 => cur_igs_ps_unit_ver.Attribute3 ,
1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,

Line 1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,

1925: X_ATTRIBUTE4 => cur_igs_ps_unit_ver.Attribute4 ,
1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,

Line 1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,

1926: X_ATTRIBUTE5 => cur_igs_ps_unit_ver.Attribute5 ,
1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,

Line 1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,

1927: X_ATTRIBUTE6 => cur_igs_ps_unit_ver.Attribute6 ,
1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,

Line 1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,

1928: X_ATTRIBUTE7 => cur_igs_ps_unit_ver.Attribute7 ,
1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,

Line 1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,

1929: X_ATTRIBUTE8 => cur_igs_ps_unit_ver.Attribute8 ,
1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,

Line 1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,

1930: X_ATTRIBUTE9 => cur_igs_ps_unit_ver.Attribute9 ,
1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,

Line 1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,

1931: X_ATTRIBUTE10 => cur_igs_ps_unit_ver.Attribute10 ,
1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,

Line 1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,

1932: X_ATTRIBUTE11 => cur_igs_ps_unit_ver.Attribute11 ,
1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,
1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,

Line 1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,

1933: X_ATTRIBUTE12 => cur_igs_ps_unit_ver.Attribute12 ,
1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,
1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,
1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,

Line 1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,

1934: X_ATTRIBUTE13 => cur_igs_ps_unit_ver.Attribute13 ,
1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,
1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,
1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,
1942: X_MODE => 'R'

Line 1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,

1935: X_ATTRIBUTE14 => cur_igs_ps_unit_ver.Attribute14 ,
1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,
1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,
1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,
1942: X_MODE => 'R'
1943: );

Line 1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,

1936: X_ATTRIBUTE15 => cur_igs_ps_unit_ver.Attribute15 ,
1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,
1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,
1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,
1942: X_MODE => 'R'
1943: );
1944: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type

Line 1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,

1937: X_ATTRIBUTE16 => cur_igs_ps_unit_ver.Attribute16 ,
1938: X_ATTRIBUTE17 => cur_igs_ps_unit_ver.Attribute17 ,
1939: X_ATTRIBUTE18 => cur_igs_ps_unit_ver.Attribute18 ,
1940: X_ATTRIBUTE19 => cur_igs_ps_unit_ver.Attribute19 ,
1941: X_ATTRIBUTE20 => cur_igs_ps_unit_ver.Attribute20 ,
1942: X_MODE => 'R'
1943: );
1944: FOR cur_igs_ge_ref_cd_type IN c_igs_ge_ref_cd_type
1945: LOOP