APPS.IGS_AD_TERM_UNITDTLS_PKG dependencies on IGS_AD_TERM_DETAILS

Line 24: FROM igs_ad_acad_history_v hist, igs_ad_transcript_v trans, igs_ad_term_details_v term

20: ***************************************************************/
21:
22: CURSOR check_status(cp_term_details_id IN NUMBER) IS
23: SELECT DISTINCT 1
24: FROM igs_ad_acad_history_v hist, igs_ad_transcript_v trans, igs_ad_term_details_v term
25: WHERE hist.education_id = trans.education_id
26: AND trans.transcript_id = term.transcript_id
27: AND term.term_details_id = cp_term_details_id
28: AND hist.status = 'I';

Line 249: ELSIF NOT Igs_Ad_Term_Details_Pkg.Get_PK_For_Validation (

245:
246: IF (((old_references.term_details_id = new_references.term_details_id)) OR
247: ((new_references.term_details_id IS NULL))) THEN
248: NULL;
249: ELSIF NOT Igs_Ad_Term_Details_Pkg.Get_PK_For_Validation (
250: new_references.term_details_id
251: ) THEN
252: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_DETAILS'));

Line 253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_DETAILS'));

249: ELSIF NOT Igs_Ad_Term_Details_Pkg.Get_PK_For_Validation (
250: new_references.term_details_id
251: ) THEN
252: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TERM_DETAILS'));
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257:

Line 371: PROCEDURE Get_FK_Igs_Ad_Term_Details (

367: Close cur_rowid;
368:
369: END Get_FK_Igs_Ad_Code_Classes;
370:
371: PROCEDURE Get_FK_Igs_Ad_Term_Details (
372: x_term_details_id IN NUMBER
373: ) AS
374:
375: /*************************************************************

Line 406: END Get_FK_Igs_Ad_Term_Details;

402: Return;
403: END IF;
404: Close cur_rowid;
405:
406: END Get_FK_Igs_Ad_Term_Details;
407:
408: PROCEDURE Check_Child_Existance AS
409: BEGIN
410: -- Next part of code has been added as per bug# 2401170

Line 1041: l_cp_attempted_total igs_ad_term_details.total_cp_attempted%TYPE;

1037: FROM igs_ad_term_unitdtls
1038: WHERE term_details_id = x_term_id
1039: GROUP BY term_details_id;
1040:
1041: l_cp_attempted_total igs_ad_term_details.total_cp_attempted%TYPE;
1042: l_cp_earned_total igs_ad_term_details.total_cp_earned%TYPE;
1043: l_unit_grade_points_total igs_ad_term_details.total_unit_gp%TYPE;
1044:
1045: BEGIN

Line 1042: l_cp_earned_total igs_ad_term_details.total_cp_earned%TYPE;

1038: WHERE term_details_id = x_term_id
1039: GROUP BY term_details_id;
1040:
1041: l_cp_attempted_total igs_ad_term_details.total_cp_attempted%TYPE;
1042: l_cp_earned_total igs_ad_term_details.total_cp_earned%TYPE;
1043: l_unit_grade_points_total igs_ad_term_details.total_unit_gp%TYPE;
1044:
1045: BEGIN
1046:

Line 1043: l_unit_grade_points_total igs_ad_term_details.total_unit_gp%TYPE;

1039: GROUP BY term_details_id;
1040:
1041: l_cp_attempted_total igs_ad_term_details.total_cp_attempted%TYPE;
1042: l_cp_earned_total igs_ad_term_details.total_cp_earned%TYPE;
1043: l_unit_grade_points_total igs_ad_term_details.total_unit_gp%TYPE;
1044:
1045: BEGIN
1046:
1047: OPEN c_get_data;

Line 1051: UPDATE igs_ad_term_details SET total_cp_attempted=l_cp_attempted_total

1047: OPEN c_get_data;
1048: FETCH c_get_data INTO l_cp_attempted_total,l_cp_earned_total,l_unit_grade_points_total;
1049: CLOSE c_get_data;
1050:
1051: UPDATE igs_ad_term_details SET total_cp_attempted=l_cp_attempted_total
1052: ,total_cp_earned=l_cp_earned_total
1053: ,total_unit_gp=l_unit_grade_points_total
1054: WHERE term_details_id = x_term_id ;
1055: END update_term_tab;