DBA Data[Home] [Help]

APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_CA_GEN_001

Line 342: SELECT IGS_CA_GEN_001.calp_set_alias_value(

338: c_adm_cat VARCHAR2,
339: c_acad_cal_type VARCHAR2,
340: c_s_adm_prcs_type VARCHAR2
341: ) IS
342: SELECT IGS_CA_GEN_001.calp_set_alias_value(
343: dai.absolute_val,
344: IGS_CA_GEN_002.cals_clc_dt_from_dai(
345: dai.ci_sequence_number, dai.CAL_TYPE, dai.DT_ALIAS, dai.sequence_number) ) adm_appl_due_dt_alias
346: FROM igs_ad_pecrs_ofop_dt pod, igs_ca_da_inst dai

Line 359: SELECT IGS_CA_GEN_001.calp_set_alias_value(

355:
356: CURSOR default_set_cur (c_adm_cal_type VARCHAR2,
357: c_adm_sequence_number NUMBER
358: ) IS
359: SELECT IGS_CA_GEN_001.calp_set_alias_value(
360: ca.absolute_val,
361: IGS_CA_GEN_002.cals_clc_dt_from_dai(
362: ca.ci_sequence_number, ca.CAL_TYPE, ca.DT_ALIAS, ca.sequence_number) ) alias_val
363: FROM IGS_CA_DA_INST ca, igs_ca_inst ci

Line 464: SELECT MAX( IGS_CA_GEN_001.calp_set_alias_value(

460: l_late_appl_exists VARCHAR2(2000);
461:
462:
463: CURSOR c_dai IS
464: SELECT MAX( IGS_CA_GEN_001.calp_set_alias_value(
465: dai.absolute_val,
466: IGS_CA_GEN_002.cals_clc_dt_from_dai(
467: dai.ci_sequence_number, dai.CAL_TYPE, dai.DT_ALIAS, dai.sequence_number) )) alias_val
468: FROM igs_ca_da da, igs_ca_da_inst dai