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_PS_GEN_001 dependencies on IGS_PS_AWARD

Line 14: --jbegum 16-Jun-2003 Bug#2983445 .Obsoleted the column award_title from igs_ps_award table.

10: --jdeekoll 28-July-2003 Bug#3060697 Modified the local procedure crsp_ins_cal_rec
11: --jbegum 23-July-2003 Bug#3060693 Modified the local procedure crsp_ins_ca_rec
12: --jbegum 27-jun-2003 Bug#2930935 Added the columns ACHIEVABLE_CREDIT_POINTS,ENROLLED_CREDIT_POINTS
13: -- in the call to igs_ps_usec_cps_pkg.insert_row
14: --jbegum 16-Jun-2003 Bug#2983445 .Obsoleted the column award_title from igs_ps_award table.
15: --smvk 09-Jun-2003 Bug # 2858436. Modified the procedure crsp_ins_crs_ver.
16: --shtatiko 03-JUN-2003 Enh# 2831572, Modified crsp_ins_unit_section and crsp_ins_crs_ver
17: --Nalin Kumar 26-May-2003 Modified the call to the igs_ps_unitass_item_pkg.insert row;
18: -- Passed the correct value to the newly added parameter (x_descroption) of the insert_row;

Line 48: -- Nalin Kumar 20-Nov-2001 Added 'DEFAULT_IND' parameter to call igs_ps_award_pkg.insert_row.

44: -- tbh IGS_PS_USEC_CPS_PKG Bug# 2224366
45: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_ps_val_cop.genp_val_staff_prsn
46: -- is changed to igs_ad_val_acai.genp_val_staff_prsn
47: --bayadav 19-Nov-2001 Bug no:2115430.Added column acad_perd_unit_set column in insert_orw call to IGS_PAT_OF_STUDY table
48: -- Nalin Kumar 20-Nov-2001 Added 'DEFAULT_IND' parameter to call igs_ps_award_pkg.insert_row.
49: -- The changes are as per the UK Award Aims DLD. Bug ID: 1366899
50: --Nalin Kumar 28-Jan-2002 Modified Procedure 'crsp_ins_crs_ver'
51: -- as pert of the HESA Intregation DLD (ENCR019). Bug# 2201753.
52: --ijeddy, Dec 3, 2003 Grade Book Enh build, bug no 3201661

Line 87: gv_ca_rec IGS_PS_AWARD%ROWTYPE;

83: gv_copn_rec IGS_PS_OFR_PAT_NOTE%ROWTYPE;
84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;
85: gv_coo_seq_num IGS_PS_OFR_OPT.coo_id%TYPE;
86: gv_cop_seq_num IGS_PS_OFR_PAT.cop_id%TYPE;
87: gv_ca_rec IGS_PS_AWARD%ROWTYPE;
88: gv_cao_rec IGS_PS_AWD_OWN%ROWTYPE;
89: gv_cow_rec IGS_PS_OWN%ROWTYPE;
90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;
91: gv_ae_rec IGS_PE_ALTERNATV_EXT%ROWTYPE;

Line 131: FROM IGS_PS_AWARD

127: WHERE course_cd = p_new_course_cd AND
128: version_number = p_new_version_number;
129: CURSOR gc_ca_rec IS
130: SELECT *
131: FROM IGS_PS_AWARD
132: WHERE course_cd = p_old_course_cd AND
133: version_number = p_old_version_number AND
134: CLOSED_IND = 'N';
135: CURSOR gc_cao_rec IS

Line 1333: -- procedure for inserting new IGS_PS_AWARD records

1329: ELSE
1330: App_Exception.Raise_Exception;
1331: END IF;
1332: END crsp_ins_calulink_rec;
1333: -- procedure for inserting new IGS_PS_AWARD records
1334: PROCEDURE crsp_ins_ca_rec (
1335: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1336: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1337: BEGIN

Line 1338: -- Bug#2983445 Removed the column award_title from call to igs_ps_award_pkg.insert_row.

1334: PROCEDURE crsp_ins_ca_rec (
1335: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1336: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1337: BEGIN
1338: -- Bug#2983445 Removed the column award_title from call to igs_ps_award_pkg.insert_row.
1339: -- inserting IGS_PS_AWARD records
1340:
1341: -- Bug#3060693 Modified the call to IGS_PS_AWARD_PKG.INSERT_ROW.
1342: -- Replaced the string 'Y' with gv_ca_rec.default_ind as the parameter being passed to X_DEFAULT_IND

Line 1339: -- inserting IGS_PS_AWARD records

1335: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1336: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1337: BEGIN
1338: -- Bug#2983445 Removed the column award_title from call to igs_ps_award_pkg.insert_row.
1339: -- inserting IGS_PS_AWARD records
1340:
1341: -- Bug#3060693 Modified the call to IGS_PS_AWARD_PKG.INSERT_ROW.
1342: -- Replaced the string 'Y' with gv_ca_rec.default_ind as the parameter being passed to X_DEFAULT_IND
1343:

Line 1341: -- Bug#3060693 Modified the call to IGS_PS_AWARD_PKG.INSERT_ROW.

1337: BEGIN
1338: -- Bug#2983445 Removed the column award_title from call to igs_ps_award_pkg.insert_row.
1339: -- inserting IGS_PS_AWARD records
1340:
1341: -- Bug#3060693 Modified the call to IGS_PS_AWARD_PKG.INSERT_ROW.
1342: -- Replaced the string 'Y' with gv_ca_rec.default_ind as the parameter being passed to X_DEFAULT_IND
1343:
1344:
1345: x_rowid := NULL;

Line 1346: IGS_PS_AWARD_PKG.INSERT_ROW(

1342: -- Replaced the string 'Y' with gv_ca_rec.default_ind as the parameter being passed to X_DEFAULT_IND
1343:
1344:
1345: x_rowid := NULL;
1346: IGS_PS_AWARD_PKG.INSERT_ROW(
1347: X_ROWID => x_rowid,
1348: X_COURSE_CD => p_new_course_cd,
1349: X_AWARD_CD => gv_ca_rec.award_cd,
1350: X_VERSION_NUMBER => p_new_version_number,

Line 1356: -- associated with each IGS_PS_AWARD record

1352: X_DEFAULT_IND => gv_ca_rec.default_ind,
1353: X_CLOSED_IND => gv_ca_rec.closed_ind
1354: );
1355: -- calling procedure to insert IGS_PS_AWD_OWN records
1356: -- associated with each IGS_PS_AWARD record
1357: OPEN gc_cao_rec;
1358: LOOP
1359: FETCH gc_cao_rec INTO gv_cao_rec;
1360: IF gc_cao_rec%FOUND THEN

Line 1909: -- calling procedure to insert IGS_PS_AWARD records

1905: END IF;
1906: CLOSE gc_cv_old_rec;
1907: -- if validation is successful
1908: p_message_name := 'IGS_PS_SUCCESS_COPY_PRGVER';
1909: -- calling procedure to insert IGS_PS_AWARD records
1910: OPEN gc_ca_rec;
1911: LOOP
1912: FETCH gc_ca_rec INTO gv_ca_rec;
1913: IF gc_ca_rec%FOUND THEN