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_GR_GRD_LGCY_PUB dependencies on IGS_GR_GRADUAND

Line 50: p_proxy_award_ind OUT NOCOPY IGS_GR_GRADUAND_ALL.PROXY_AWARD_IND%TYPE

46: p_person_id OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE,
47: p_cal_type OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE,
48: p_sequence_number OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
49: p_proxy_award_person_id OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE,
50: p_proxy_award_ind OUT NOCOPY IGS_GR_GRADUAND_ALL.PROXY_AWARD_IND%TYPE
51: )
52: RETURN BOOLEAN;
53:
54: FUNCTION VALIDATE_GRAD_DB_CONS ( p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,

Line 68: P_proxy_award_ind IN IGS_GR_GRADUAND_ALL. PROXY_AWARD_IND%TYPE

64: P_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
65: P_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE,
66: P_sequence_number IN IGS_CA_INST. SEQUENCE_NUMBER%TYPE,
67: P_proxy_award_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
68: P_proxy_award_ind IN IGS_GR_GRADUAND_ALL. PROXY_AWARD_IND%TYPE
69:
70: ) RETURN BOOLEAN;
71: FUNCTION VALIDATE_POST_GRADUAND(
72: p_lgcy_grd_rec IN OUT NOCOPY lgcy_grd_rec_type,

Line 111: l_proxy_award_ind IGS_GR_GRADUAND_ALL.PROXY_AWARD_IND%TYPE;

107: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
108: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
109: l_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
110: l_proxy_award_person_id IGS_PE_PERSON.PERSON_ID%TYPE;
111: l_proxy_award_ind IGS_GR_GRADUAND_ALL.PROXY_AWARD_IND%TYPE;
112:
113: l_return_value VARCHAR2(1);
114:
115: WARN_TYPE_ERR EXCEPTION;

Line 186: INSERT INTO igs_gr_graduand

182: RAISE FND_API.G_EXC_ERROR; --Error handling Goes here
183: END IF;
184: --End of Call to validate_graduand
185: --Call RAW insert into the table
186: INSERT INTO igs_gr_graduand
187: (
188: PERSON_ID,
189: CREATE_DT,
190: GRD_CAL_TYPE,

Line 490: p_desc_flex_name => 'IGS_GR_GRADUAND_FLEX' ) THEN

486: p_ATTRIBUTE17 => p_lgcy_grd_rec.ATTRIBUTE17 ,
487: p_ATTRIBUTE18 => p_lgcy_grd_rec.ATTRIBUTE18 ,
488: p_ATTRIBUTE19 => p_lgcy_grd_rec.ATTRIBUTE19 ,
489: p_ATTRIBUTE20 => p_lgcy_grd_rec.ATTRIBUTE20 ,
490: p_desc_flex_name => 'IGS_GR_GRADUAND_FLEX' ) THEN
491: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
492: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_DESC_FLEX');
493: FND_MSG_PUB.ADD;
494: END IF;

Line 505: p_proxy_award_ind OUT NOCOPY IGS_GR_GRADUAND_ALL.PROXY_AWARD_IND%TYPE

501: p_person_id OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE,
502: p_cal_type OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE,
503: p_sequence_number OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
504: p_proxy_award_person_id OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE,
505: p_proxy_award_ind OUT NOCOPY IGS_GR_GRADUAND_ALL.PROXY_AWARD_IND%TYPE
506: )RETURN BOOLEAN
507:
508: /****************************************************************************************************************
509: || Created By : msrinivi

Line 618: IF Igs_Gr_Graduand_Pkg.Get_Pk_For_Validation(X_PERSON_ID => p_person_id,

614: l_return_value VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
615:
616: BEGIN
617: -- Check for record existance
618: IF Igs_Gr_Graduand_Pkg.Get_Pk_For_Validation(X_PERSON_ID => p_person_id,
619: X_CREATE_DT => p_lgcy_grd_rec.create_dt) THEN
620: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRAD_PK_ALREADY_EXISTS');
621: FND_MSG_PUB.ADD;
622: l_return_value := 'W'; -- Error out

Line 628: IF Igs_Gr_Graduand_Pkg.get_uk_for_validation(

624: END IF;
625: -- End of check for record existance
626:
627: -- Check for Unique key
628: IF Igs_Gr_Graduand_Pkg.get_uk_for_validation(
629: X_PERSON_ID => p_person_id,
630: X_CREATE_DT => p_lgcy_grd_rec.create_dt,
631: X_AWARD_COURSE_CD => p_lgcy_grd_rec.award_program_cd,
632: X_AWARD_CRS_VERSION_NUMBER => p_lgcy_grd_rec.award_prog_version_number,

Line 746: P_proxy_award_ind IN IGS_GR_GRADUAND_ALL. PROXY_AWARD_IND%TYPE

742: P_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
743: P_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE,
744: P_sequence_number IN IGS_CA_INST. SEQUENCE_NUMBER%TYPE,
745: P_proxy_award_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
746: P_proxy_award_ind IN IGS_GR_GRADUAND_ALL. PROXY_AWARD_IND%TYPE
747:
748: ) RETURN BOOLEAN
749:
750: /****************************************************************************************************************

Line 754: || inserting a record in the table IGS_GR_GRADUAND_ALL

750: /****************************************************************************************************************
751: || Created By : msrinivi
752: || Created On : 11-Nov-2002
753: || Purpose : This function validates all the business rules before
754: || inserting a record in the table IGS_GR_GRADUAND_ALL
755: ||
756: ||
757: || Known limitations, enhancements or remarks :
758: || Change History :

Line 822: cst_attending CONSTANT IGS_GR_GRADUAND.s_graduand_type%TYPE := 'ATTENDING';

818: v_sca_crs_rqrmnt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
819: v_scaae_exists VARCHAR2(1);
820: v_sca_exists CHAR(1);
821:
822: cst_attending CONSTANT IGS_GR_GRADUAND.s_graduand_type%TYPE := 'ATTENDING';
823: cst_graduated CONSTANT VARCHAR2(9) := 'GRADUATED';
824: cst_surrender CONSTANT VARCHAR2(9) := 'SURRENDER';
825: cst_approved CONSTANT VARCHAR2(8) := 'APPROVED';
826:

Line 982: || inserting a record in the table IGS_GR_GRADUAND

978: /****************************************************************************************************************
979: || Created By : msrinivi
980: || Created On : 11-Nov-2002
981: || Purpose : This function validates all the business rules after
982: || inserting a record in the table IGS_GR_GRADUAND
983: ||
984: ||
985: || Known limitations, enhancements or remarks :
986: || Change History :