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 IGS_AV_UNT_REF_CDS

Line 24: FROM igs_av_unt_ref_cds

20: IS
21: CURSOR c_untref_cd
22: IS
23: SELECT 1
24: FROM igs_av_unt_ref_cds
25: WHERE av_stnd_unit_id = p_av_stnd_unit_id
26: AND reference_code_id = p_reference_code_id;
27:
28: x_return_status BOOLEAN := TRUE;

Line 1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;

1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;
1605: duplicate_record_exists EXCEPTION;
1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;
1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;
1608:
1609: CURSOR c_unit_ref_id is
1610: select IGS_AV_UNT_REF_CDS_S.nextval from dual;
1611:

Line 1610: select IGS_AV_UNT_REF_CDS_S.nextval from dual;

1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;
1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;
1608:
1609: CURSOR c_unit_ref_id is
1610: select IGS_AV_UNT_REF_CDS_S.nextval from dual;
1611:
1612: BEGIN
1613: mydebug('ENTERED create_adv_stnd_unit ');
1614: --Standard start of API savepoint

Line 1873: INSERT INTO IGS_AV_UNT_REF_CDS(

1869: mydebug('INSERT INTO IGS_AV_STD_UNT_BASIS_ALL AV_STND_UNIT_ID= '|| l_av_stnd_unit_lvl_id);
1870: OPEN c_unit_ref_id;
1871: FETCH c_unit_ref_id INTO l_AVU_REFERENCE_CD_ID;
1872: CLOSE c_unit_ref_id;
1873: INSERT INTO IGS_AV_UNT_REF_CDS(
1874: last_update_login,
1875: created_by,
1876: creation_date,
1877: last_updated_by,