DBA Data[Home] [Help]

APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_CA_GEN_001

Line 111: SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))

107:
108: CURSOR c_dt_alias_val(l_dt_alias igs_ca_da_inst.dt_alias%TYPE,
109: l_cal_type igs_ca_da_inst.cal_type%TYPE,
110: l_ci_sequence_number igs_ca_da_inst.ci_sequence_number%TYPE) IS
111: SELECT max(IGS_CA_GEN_001.calp_get_alias_val(dt_alias, sequence_number, cal_type, ci_sequence_number))
112: FROM igs_ca_da_inst
113: WHERE dt_alias = l_dt_alias
114: AND cal_type = l_cal_type
115: AND ci_sequence_number = l_ci_sequence_number;

Line 329: igs_ca_gen_001.calp_get_ci_dates (

325: END IF;
326: END IF;
327: IF p_inserting THEN
328: -- Get the calendar start/end dates.
329: igs_ca_gen_001.calp_get_ci_dates (
330: new_references.cal_type,
331: new_references.ci_sequence_number,
332: new_references.ci_start_dt,
333: new_references.ci_end_dt