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_CA_INS_ROLL_CI dependencies on IGS_CA_DA_INST_OFCNT

Line 609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,

605: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,

Line 610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,

606: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number

Line 611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,

607: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,

Line 612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,

608: CURSOR c_daio_cnstrt(
609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,

Line 613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,

609: cp_dt_alias IGS_CA_DA_INST_OFCNT.DT_ALIAS%TYPE,
610: cp_dai_sequence_number IGS_CA_DA_INST_OFCNT.dai_sequence_number%TYPE,
611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number

Line 615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,

611: cp_cal_type IGS_CA_DA_INST_OFCNT.CAL_TYPE%TYPE,
612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *

Line 616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,

612: cp_ci_sequence_number IGS_CA_DA_INST_OFCNT.ci_sequence_number%TYPE,
613: cp_offset_dt_alias IGS_CA_DA_INST_OFCNT.offset_dt_alias%TYPE,
614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *
620: FROM IGS_CA_DA_INST_OFCNT

Line 618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS

614: cp_offset_dai_sequence_number
615: IGS_CA_DA_INST_OFCNT.offset_dai_sequence_number%TYPE,
616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *
620: FROM IGS_CA_DA_INST_OFCNT
621: WHERE DT_ALIAS = cp_dt_alias AND
622: dai_sequence_number = cp_dai_sequence_number AND

Line 620: FROM IGS_CA_DA_INST_OFCNT

616: cp_offset_cal_type IGS_CA_DA_INST_OFCNT.offset_cal_type%TYPE,
617: cp_offset_ci_sequence_number
618: IGS_CA_DA_INST_OFCNT.offset_ci_sequence_number%TYPE) IS
619: SELECT *
620: FROM IGS_CA_DA_INST_OFCNT
621: WHERE DT_ALIAS = cp_dt_alias AND
622: dai_sequence_number = cp_dai_sequence_number AND
623: CAL_TYPE = cp_cal_type AND
624: ci_sequence_number = cp_ci_sequence_number AND

Line 642: IGS_CA_DA_INST_OFCNT_PKG.INSERT_ROW(

638: p_offset_dai_sequence_number,
639: p_offset_cal_type,
640: p_offset_ci_sequence_number) LOOP
641:
642: IGS_CA_DA_INST_OFCNT_PKG.INSERT_ROW(
643: X_ROWID => X_ROWID,
644: X_DT_ALIAS => p_new_dt_alias,
645: X_dai_sequence_number => p_new_dai_sequence_number,
646: X_CAL_TYPE => p_new_cal_type,