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_OR_INST_IMP_003_PKG dependencies on IGS_OR_INST_SDTL_INT

Line 1142: CURSOR cur_get_int_stat_det(p_int_stat_id igs_or_inst_sdtl_int.interface_inst_stat_id%TYPE,

1138: WHERE interface_id =cp_interface_id
1139: AND status =cp_status ;
1140:
1141: --Cursor to fetch the Interface Statistics Detail Records for this Statistics master record
1142: CURSOR cur_get_int_stat_det(p_int_stat_id igs_or_inst_sdtl_int.interface_inst_stat_id%TYPE,
1143: cp_status igs_or_inst_sdtl_int.status%TYPE) IS
1144: SELECT sdtl.rowid,sdtl.*
1145: FROM igs_or_inst_sdtl_int sdtl
1146: WHERE interface_inst_stat_id = p_int_stat_id

Line 1143: cp_status igs_or_inst_sdtl_int.status%TYPE) IS

1139: AND status =cp_status ;
1140:
1141: --Cursor to fetch the Interface Statistics Detail Records for this Statistics master record
1142: CURSOR cur_get_int_stat_det(p_int_stat_id igs_or_inst_sdtl_int.interface_inst_stat_id%TYPE,
1143: cp_status igs_or_inst_sdtl_int.status%TYPE) IS
1144: SELECT sdtl.rowid,sdtl.*
1145: FROM igs_or_inst_sdtl_int sdtl
1146: WHERE interface_inst_stat_id = p_int_stat_id
1147: AND status = cp_status;

Line 1145: FROM igs_or_inst_sdtl_int sdtl

1141: --Cursor to fetch the Interface Statistics Detail Records for this Statistics master record
1142: CURSOR cur_get_int_stat_det(p_int_stat_id igs_or_inst_sdtl_int.interface_inst_stat_id%TYPE,
1143: cp_status igs_or_inst_sdtl_int.status%TYPE) IS
1144: SELECT sdtl.rowid,sdtl.*
1145: FROM igs_or_inst_sdtl_int sdtl
1146: WHERE interface_inst_stat_id = p_int_stat_id
1147: AND status = cp_status;
1148:
1149: --Cursor to fetch the OSS Statistics Master Records for this Statistics Master Identifier

Line 1160: p_year igs_or_inst_sdtl_int.year%TYPE) IS

1156:
1157: --Cursor to fetch the OSS Statistics Detail Records to check against the recently
1158: --inserted Detail record.
1159: CURSOR cur_get_oss_stat_det(p_int_stat_id igs_or_inst_stat_dtl.inst_stat_id%TYPE,
1160: p_year igs_or_inst_sdtl_int.year%TYPE) IS
1161: SELECT sdtl.rowid,sdtl.*
1162: FROM igs_or_inst_stat_dtl sdtl
1163: WHERE sdtl.inst_stat_id = p_int_stat_id
1164: AND TO_CHAR(sdtl.year,'YYYY') = TO_CHAR(p_year,'YYYY');

Line 1214: UPDATE igs_or_inst_sdtl_int

1210:
1211:
1212: BEGIN
1213:
1214: UPDATE igs_or_inst_sdtl_int
1215: SET status = p_int_stat_det_rec.status,
1216: error_code = p_int_stat_det_rec.error_code
1217: WHERE interface_inst_stat_dtl_id = p_int_stat_det_rec.interface_inst_stat_dtl_id;
1218: