APPS.IGS_UC_EXP_QUAL_SUM_IMP_PKG dependencies on IGS_UC_EXP_QUAL_SUM

Line 1: PACKAGE BODY igs_uc_exp_qual_sum_imp_pkg AS

1: PACKAGE BODY igs_uc_exp_qual_sum_imp_pkg AS
2: /* $Header: IGSUC29B.pls 120.1 2006/02/08 19:54:49 anwest noship $ */
3:
4:
5: PROCEDURE igs_uc_exp_qual_sum_imp(Errbuf OUT NOCOPY Varchar2 , Retcode OUT NOCOPY Varchar2) IS

Line 5: PROCEDURE igs_uc_exp_qual_sum_imp(Errbuf OUT NOCOPY Varchar2 , Retcode OUT NOCOPY Varchar2) IS

1: PACKAGE BODY igs_uc_exp_qual_sum_imp_pkg AS
2: /* $Header: IGSUC29B.pls 120.1 2006/02/08 19:54:49 anwest noship $ */
3:
4:
5: PROCEDURE igs_uc_exp_qual_sum_imp(Errbuf OUT NOCOPY Varchar2 , Retcode OUT NOCOPY Varchar2) IS
6: /*************************************************************
7: Created By : vbandaru
8: Date Created By : 23-JAN-2002
9: Purpose : to insert or to update the records into igs_uc_exp_qual_sum table

Line 9: Purpose : to insert or to update the records into igs_uc_exp_qual_sum table

5: PROCEDURE igs_uc_exp_qual_sum_imp(Errbuf OUT NOCOPY Varchar2 , Retcode OUT NOCOPY Varchar2) IS
6: /*************************************************************
7: Created By : vbandaru
8: Date Created By : 23-JAN-2002
9: Purpose : to insert or to update the records into igs_uc_exp_qual_sum table
10:
11: Know limitations, enhancements or remarks
12: Change History
13: Who When What

Line 40: FROM igs_uc_exp_qual_sum uexq

36: uexq.rowid, uexq.exp_gce, uexq.exp_vce, uexq.winter_a_levels,
37: uexq.prev_a_levels, uexq.prev_as_levels, uexq.sqa, uexq.btec,
38: uexq.ib, uexq.ilc, uexq.ailc, uexq.ksi, uexq.roa, uexq.manual,
39: uexq.oeq, uexq.prev_oeq, uexq.vqi
40: FROM igs_uc_exp_qual_sum uexq
41: WHERE uexq.person_id = l_oss_person_id;
42:
43: l_row1 c1%ROWTYPE;
44: l_row2 c2%ROWTYPE;

Line 46: l_exp_qual_sum_id igs_uc_exp_qual_sum.exp_qual_sum_id%TYPE DEFAULT NULL;

42:
43: l_row1 c1%ROWTYPE;
44: l_row2 c2%ROWTYPE;
45: l_rowid ROWID DEFAULT NULL;
46: l_exp_qual_sum_id igs_uc_exp_qual_sum.exp_qual_sum_id%TYPE DEFAULT NULL;
47:
48: BEGIN
49:
50: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate

Line 67: igs_uc_exp_qual_sum_pkg.update_row(

63: IF NVL(l_row1.exam_change_date, SYSDATE) >
64: l_row2.seq_updated_date THEN --(2)
65:
66: --smaddali passing lrow1.previous instead of lrow2.prev_a_levels to field x_prev_a_levels for bug 2430178
67: igs_uc_exp_qual_sum_pkg.update_row(
68: X_ROWID =>l_row2.rowid,
69: X_EXP_QUAL_SUM_ID =>l_row2.exp_qual_sum_id,
70: X_PERSON_ID =>l_row2.person_id,
71: X_EXP_GCE =>l_row1.gce,

Line 96: igs_uc_exp_qual_sum_pkg.insert_row(

92: CLOSE c2;
93:
94: ELSIF(c2%NOTFOUND) THEN
95: --smaddali passing lrow1.previous instead of NULL to field x_prev_a_levels for bug 2430178
96: igs_uc_exp_qual_sum_pkg.insert_row(
97: X_ROWID =>l_rowid,
98: X_EXP_QUAL_SUM_ID =>l_exp_qual_sum_id,
99: X_PERSON_ID =>l_row1.oss_person_id,
100: X_EXP_GCE =>l_row1.GCE,

Line 136: fnd_message.set_token('NAME','IGS_UC_EXP_QUAL_SUM_IMP_PKG.IGS_UC_EXP_QUAL_SUM_IMP');

132: WHEN OTHERS THEN
133: Retcode := 2 ;
134: Rollback;
135: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
136: fnd_message.set_token('NAME','IGS_UC_EXP_QUAL_SUM_IMP_PKG.IGS_UC_EXP_QUAL_SUM_IMP');
137: fnd_message.retrieve (Errbuf);
138: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
139: END igs_uc_exp_qual_sum_imp;
140:

Line 139: END igs_uc_exp_qual_sum_imp;

135: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
136: fnd_message.set_token('NAME','IGS_UC_EXP_QUAL_SUM_IMP_PKG.IGS_UC_EXP_QUAL_SUM_IMP');
137: fnd_message.retrieve (Errbuf);
138: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
139: END igs_uc_exp_qual_sum_imp;
140:
141: END igs_uc_exp_qual_sum_imp_pkg;

Line 141: END igs_uc_exp_qual_sum_imp_pkg;

137: fnd_message.retrieve (Errbuf);
138: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
139: END igs_uc_exp_qual_sum_imp;
140:
141: END igs_uc_exp_qual_sum_imp_pkg;