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_EN_GEN_011 dependencies on IGS_AS_SUA_REF_CDS

Line 116: PERSON_ID IGS_AS_SUA_REF_CDS.PERSON_ID%TYPE,

112: r_sua r_sua_typ;
113: TYPE t_sua_typ IS TABLE OF r_sua%TYPE INDEX BY BINARY_INTEGER;
114:
115: TYPE suar_record_type IS RECORD (
116: PERSON_ID IGS_AS_SUA_REF_CDS.PERSON_ID%TYPE,
117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,
118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,

Line 117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,

113: TYPE t_sua_typ IS TABLE OF r_sua%TYPE INDEX BY BINARY_INTEGER;
114:
115: TYPE suar_record_type IS RECORD (
116: PERSON_ID IGS_AS_SUA_REF_CDS.PERSON_ID%TYPE,
117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,
118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,
121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,

Line 118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,

114:
115: TYPE suar_record_type IS RECORD (
116: PERSON_ID IGS_AS_SUA_REF_CDS.PERSON_ID%TYPE,
117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,
118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,
121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,
122: APPLIED_COURSE_CD IGS_AS_SUA_REF_CDS.APPLIED_COURSE_CD%TYPE);

Line 119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,

115: TYPE suar_record_type IS RECORD (
116: PERSON_ID IGS_AS_SUA_REF_CDS.PERSON_ID%TYPE,
117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,
118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,
121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,
122: APPLIED_COURSE_CD IGS_AS_SUA_REF_CDS.APPLIED_COURSE_CD%TYPE);
123: TYPE suar_table_type IS TABLE OF suar_record_type INDEX BY BINARY_INTEGER;

Line 120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,

116: PERSON_ID IGS_AS_SUA_REF_CDS.PERSON_ID%TYPE,
117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,
118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,
121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,
122: APPLIED_COURSE_CD IGS_AS_SUA_REF_CDS.APPLIED_COURSE_CD%TYPE);
123: TYPE suar_table_type IS TABLE OF suar_record_type INDEX BY BINARY_INTEGER;
124: empty_suar_table suar_table_type;

Line 121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,

117: COURSE_CD IGS_AS_SUA_REF_CDS.COURSE_CD%TYPE,
118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,
121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,
122: APPLIED_COURSE_CD IGS_AS_SUA_REF_CDS.APPLIED_COURSE_CD%TYPE);
123: TYPE suar_table_type IS TABLE OF suar_record_type INDEX BY BINARY_INTEGER;
124: empty_suar_table suar_table_type;
125: suar_table suar_table_type;

Line 122: APPLIED_COURSE_CD IGS_AS_SUA_REF_CDS.APPLIED_COURSE_CD%TYPE);

118: UOO_ID IGS_AS_SUA_REF_CDS.UOO_ID%TYPE,
119: REFERENCE_CODE_ID IGS_AS_SUA_REF_CDS.REFERENCE_CODE_ID%TYPE,
120: REFERENCE_CD_TYPE IGS_AS_SUA_REF_CDS.REFERENCE_CD_TYPE%TYPE,
121: REFERENCE_CD IGS_AS_SUA_REF_CDS.REFERENCE_CD%TYPE,
122: APPLIED_COURSE_CD IGS_AS_SUA_REF_CDS.APPLIED_COURSE_CD%TYPE);
123: TYPE suar_table_type IS TABLE OF suar_record_type INDEX BY BINARY_INTEGER;
124: empty_suar_table suar_table_type;
125: suar_table suar_table_type;
126:

Line 2616: From IGS_AS_SUA_REF_CDS suar

2612: Select suar.reference_code_id,
2613: suar.reference_cd_type,
2614: suar.reference_cd,
2615: suar.applied_course_cd
2616: From IGS_AS_SUA_REF_CDS suar
2617: Where suar.person_id = cp_person_id
2618: And suar.course_cd = cp_course_cd
2619: And suar.uoo_id = cp_uoo_id
2620: And suar.deleted_date IS NULL;

Line 2649: l_suarid IGS_AS_SUA_REF_CDS.suar_id%TYPE;

2645: PROCEDURE enrp_copy_suar(p_to_uoo_id IN NUMBER)
2646: IS
2647:
2648: l_rowid VARCHAR2(25);
2649: l_suarid IGS_AS_SUA_REF_CDS.suar_id%TYPE;
2650:
2651: BEGIN
2652:
2653: FOR l_count IN 1..suar_table.COUNT LOOP

Line 2654: igs_as_sua_ref_cds_pkg.insert_row (

2650:
2651: BEGIN
2652:
2653: FOR l_count IN 1..suar_table.COUNT LOOP
2654: igs_as_sua_ref_cds_pkg.insert_row (
2655: x_rowid => l_rowid,
2656: x_suar_id => l_suarid,
2657: x_person_id => suar_table(l_count).person_id,
2658: x_course_cd => suar_table(l_count).course_cd,