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.IGS_AV_UNT_LGCY_PUB dependencies on FND_GLOBAL

Line 1700: NVL(FND_GLOBAL.USER_ID,-1),

1696: exemption_institution_cd ,
1697: org_id
1698: ) VALUES (
1699: l_person_id,
1700: NVL(FND_GLOBAL.USER_ID,-1),
1701: SYSDATE ,
1702: NVL(FND_GLOBAL.USER_ID,-1),
1703: SYSDATE ,
1704: NVL(FND_GLOBAL.LOGIN_ID,-1),

Line 1702: NVL(FND_GLOBAL.USER_ID,-1),

1698: ) VALUES (
1699: l_person_id,
1700: NVL(FND_GLOBAL.USER_ID,-1),
1701: SYSDATE ,
1702: NVL(FND_GLOBAL.USER_ID,-1),
1703: SYSDATE ,
1704: NVL(FND_GLOBAL.LOGIN_ID,-1),
1705: upper(p_lgcy_adstunt_rec.program_cd) ,
1706: l_as_version_number,

Line 1704: NVL(FND_GLOBAL.LOGIN_ID,-1),

1700: NVL(FND_GLOBAL.USER_ID,-1),
1701: SYSDATE ,
1702: NVL(FND_GLOBAL.USER_ID,-1),
1703: SYSDATE ,
1704: NVL(FND_GLOBAL.LOGIN_ID,-1),
1705: upper(p_lgcy_adstunt_rec.program_cd) ,
1706: l_as_version_number,
1707: p_lgcy_adstunt_rec.total_exmptn_approved ,
1708: p_lgcy_adstunt_rec.total_exmptn_granted,

Line 1759: L_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;

1755: END IF;
1756:
1757: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL lgcy_adstunt_rec.prog_group_ind ');
1758:
1759: L_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1760: L_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1761: L_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1762:
1763: if (L_REQUEST_ID = -1) then

Line 1760: L_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;

1756:
1757: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL lgcy_adstunt_rec.prog_group_ind ');
1758:
1759: L_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1760: L_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1761: L_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1762:
1763: if (L_REQUEST_ID = -1) then
1764: L_REQUEST_ID := NULL ;

Line 1761: L_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;

1757: mydebug(' INSERT INTO IGS_AV_STND_UNIT_ALL lgcy_adstunt_rec.prog_group_ind ');
1758:
1759: L_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID ;
1760: L_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID ;
1761: L_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID ;
1762:
1763: if (L_REQUEST_ID = -1) then
1764: L_REQUEST_ID := NULL ;
1765: L_PROGRAM_ID := NULL ;

Line 1836: NVL(FND_GLOBAL.USER_ID,-1),

1832: l_request_id,
1833: l_program_application_id,
1834: l_program_id,
1835: l_program_update_date,
1836: NVL(FND_GLOBAL.USER_ID,-1),
1837: SYSDATE,
1838: NVL(FND_GLOBAL.USER_ID,-1),
1839: SYSDATE,
1840: NVL(FND_GLOBAL.LOGIN_ID,-1),

Line 1838: NVL(FND_GLOBAL.USER_ID,-1),

1834: l_program_id,
1835: l_program_update_date,
1836: NVL(FND_GLOBAL.USER_ID,-1),
1837: SYSDATE,
1838: NVL(FND_GLOBAL.USER_ID,-1),
1839: SYSDATE,
1840: NVL(FND_GLOBAL.LOGIN_ID,-1),
1841: l_av_stnd_unit_lvl_id,
1842: l_cal_type,

Line 1840: NVL(FND_GLOBAL.LOGIN_ID,-1),

1836: NVL(FND_GLOBAL.USER_ID,-1),
1837: SYSDATE,
1838: NVL(FND_GLOBAL.USER_ID,-1),
1839: SYSDATE,
1840: NVL(FND_GLOBAL.LOGIN_ID,-1),
1841: l_av_stnd_unit_lvl_id,
1842: l_cal_type,
1843: l_seq_number,
1844: upper(p_lgcy_adstunt_rec.institution_cd),

Line 1887: NVL(FND_GLOBAL.LOGIN_ID,-1),

1883: APPLIED_COURSE_CD,
1884: DELETED_DATE
1885: )
1886: VALUES (
1887: NVL(FND_GLOBAL.LOGIN_ID,-1),
1888: NVL(FND_GLOBAL.USER_ID,-1),
1889: SYSDATE,
1890: NVL(FND_GLOBAL.USER_ID,-1),
1891: SYSDATE,

Line 1888: NVL(FND_GLOBAL.USER_ID,-1),

1884: DELETED_DATE
1885: )
1886: VALUES (
1887: NVL(FND_GLOBAL.LOGIN_ID,-1),
1888: NVL(FND_GLOBAL.USER_ID,-1),
1889: SYSDATE,
1890: NVL(FND_GLOBAL.USER_ID,-1),
1891: SYSDATE,
1892: l_AVU_REFERENCE_CD_ID ,

Line 1890: NVL(FND_GLOBAL.USER_ID,-1),

1886: VALUES (
1887: NVL(FND_GLOBAL.LOGIN_ID,-1),
1888: NVL(FND_GLOBAL.USER_ID,-1),
1889: SYSDATE,
1890: NVL(FND_GLOBAL.USER_ID,-1),
1891: SYSDATE,
1892: l_AVU_REFERENCE_CD_ID ,
1893: l_person_id,
1894: l_av_stnd_unit_lvl_id,

Line 1929: NVL(FND_GLOBAL.LOGIN_ID,-1),

1925: basis_completion_ind,
1926: org_id,
1927: av_stnd_unit_id
1928: ) VALUES (
1929: NVL(FND_GLOBAL.LOGIN_ID,-1),
1930: NVL(FND_GLOBAL.USER_ID,-1),
1931: SYSDATE,
1932: NVL(FND_GLOBAL.USER_ID,-1),
1933: SYSDATE,

Line 1930: NVL(FND_GLOBAL.USER_ID,-1),

1926: org_id,
1927: av_stnd_unit_id
1928: ) VALUES (
1929: NVL(FND_GLOBAL.LOGIN_ID,-1),
1930: NVL(FND_GLOBAL.USER_ID,-1),
1931: SYSDATE,
1932: NVL(FND_GLOBAL.USER_ID,-1),
1933: SYSDATE,
1934: p_lgcy_adstunt_rec.basis_program_type ,

Line 1932: NVL(FND_GLOBAL.USER_ID,-1),

1928: ) VALUES (
1929: NVL(FND_GLOBAL.LOGIN_ID,-1),
1930: NVL(FND_GLOBAL.USER_ID,-1),
1931: SYSDATE,
1932: NVL(FND_GLOBAL.USER_ID,-1),
1933: SYSDATE,
1934: p_lgcy_adstunt_rec.basis_program_type ,
1935: p_lgcy_adstunt_rec.basis_year,
1936: p_lgcy_adstunt_rec.basis_completion_ind,

Line 2002: NVL(FND_GLOBAL.LOGIN_ID,-1),

1998: av_stnd_unit_id
1999: )
2000: VALUES
2001: (
2002: NVL(FND_GLOBAL.LOGIN_ID,-1),
2003: NVL(FND_GLOBAL.USER_ID,-1),
2004: SYSDATE,
2005: NVL(FND_GLOBAL.USER_ID,-1),
2006: SYSDATE,

Line 2003: NVL(FND_GLOBAL.USER_ID,-1),

1999: )
2000: VALUES
2001: (
2002: NVL(FND_GLOBAL.LOGIN_ID,-1),
2003: NVL(FND_GLOBAL.USER_ID,-1),
2004: SYSDATE,
2005: NVL(FND_GLOBAL.USER_ID,-1),
2006: SYSDATE,
2007: p_lgcy_adstunt_rec.alt_unit_cd,

Line 2005: NVL(FND_GLOBAL.USER_ID,-1),

2001: (
2002: NVL(FND_GLOBAL.LOGIN_ID,-1),
2003: NVL(FND_GLOBAL.USER_ID,-1),
2004: SYSDATE,
2005: NVL(FND_GLOBAL.USER_ID,-1),
2006: SYSDATE,
2007: p_lgcy_adstunt_rec.alt_unit_cd,
2008: p_lgcy_adstunt_rec.alt_version_number,
2009: upper(p_lgcy_adstunt_rec.optional_ind),