APPS.IGS_AD_SS_GEN_001 dependencies on IGS_CA_INST

Line 1599: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

1595:
1596: --Procedure sent from HQ to be added
1597: -----------------------------------
1598: PROCEDURE get_acad_cal(p_adm_cal_type IN igs_ca_type.cal_type%TYPE,
1599: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1600: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
1601: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE) AS
1602: l_message fnd_new_messages.message_name%TYPE;
1603: l_start_dt DATE;

Line 1601: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE) AS

1597: -----------------------------------
1598: PROCEDURE get_acad_cal(p_adm_cal_type IN igs_ca_type.cal_type%TYPE,
1599: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1600: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
1601: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE) AS
1602: l_message fnd_new_messages.message_name%TYPE;
1603: l_start_dt DATE;
1604: l_end_dt DATE;
1605: l_out VARCHAR2(2000);

Line 1615: igs_ca_inst ci_adm,

1611: SELECT ci_adm.sequence_number adm_sequence_number,
1612: ci_acad.cal_type acad_cal_type,
1613: ci_acad.sequence_number acad_sequence_number
1614: FROM igs_ca_type ct_adm,
1615: igs_ca_inst ci_adm,
1616: igs_ca_stat cs,
1617: igs_ca_inst_rel cir,
1618: igs_ca_inst ci_acad,
1619: igs_ca_type ct_acad

Line 1617: igs_ca_inst_rel cir,

1613: ci_acad.sequence_number acad_sequence_number
1614: FROM igs_ca_type ct_adm,
1615: igs_ca_inst ci_adm,
1616: igs_ca_stat cs,
1617: igs_ca_inst_rel cir,
1618: igs_ca_inst ci_acad,
1619: igs_ca_type ct_acad
1620: WHERE ct_adm.cal_type = cp_cal_type
1621: AND ct_adm.cal_type = ci_adm.cal_type

Line 1618: igs_ca_inst ci_acad,

1614: FROM igs_ca_type ct_adm,
1615: igs_ca_inst ci_adm,
1616: igs_ca_stat cs,
1617: igs_ca_inst_rel cir,
1618: igs_ca_inst ci_acad,
1619: igs_ca_type ct_acad
1620: WHERE ct_adm.cal_type = cp_cal_type
1621: AND ct_adm.cal_type = ci_adm.cal_type
1622: AND SYSDATE <= ci_adm.end_dt