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.IGF_SL_REL_DISB dependencies on IGF_DB_PAYS_PRG_T

Line 1014: -- temporary table igf_db_pays_prg_t

1010: --
1011: -- Created By : sjadhav
1012: -- Date Created By : Jan 07,2002
1013: -- Purpose : This routine inserts Pays Only Programs, Units into
1014: -- temporary table igf_db_pays_prg_t
1015: --
1016: --------------------------------------------------------------------------------------------
1017:
1018: -- Get all the teaching periods for the academic calendar instance

Line 1061: dbpays_rec igf_db_pays_prg_t%ROWTYPE;

1057: get_att_rec cur_get_att%ROWTYPE;
1058: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1059: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1060: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1061: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1062: l_rowid ROWID;
1063: BEGIN
1064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1065: THEN

Line 1105: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');

1101: l_rowid := NULL;
1102:
1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1104: THEN
1105: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
1106: END IF;
1107:
1108: igf_db_pays_prg_t_pkg.insert_row(
1109: x_rowid => l_rowid, x_dbpays_id => dbpays_rec.dbpays_id,

Line 1108: igf_db_pays_prg_t_pkg.insert_row(

1104: THEN
1105: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
1106: END IF;
1107:
1108: igf_db_pays_prg_t_pkg.insert_row(
1109: x_rowid => l_rowid, x_dbpays_id => dbpays_rec.dbpays_id,
1110: x_base_id => dbpays_rec.base_id,
1111: x_program_cd => dbpays_rec.program_cd,
1112: x_prg_ver_num => dbpays_rec.prg_ver_num,

Line 1147: -- common to temp table ( igf_db_pays_prg_t ) and fund setup for pays only program

1143: --------------------------------------------------------------------------------------------
1144:
1145: --
1146: -- This cursor will retreive records which are
1147: -- common to temp table ( igf_db_pays_prg_t ) and fund setup for pays only program
1148: -- If there are no records, the check is failed else passed
1149: --
1150:
1151: CURSOR cur_std_pays(

Line 1157: FROM igf_db_pays_prg_t

1153: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1154: )
1155: IS
1156: SELECT program_cd, prg_ver_num
1157: FROM igf_db_pays_prg_t
1158: WHERE base_id = p_base_id
1159: INTERSECT
1160: SELECT course_cd, version_number
1161: FROM igf_aw_fund_prg_v fprg

Line 1229: -- common to temp table ( igf_db_pays_prg_t ) and fund setup for pays only units

1225: --
1226: --------------------------------------------------------------------------------------------
1227: --
1228: -- This cursor will retreive records which are
1229: -- common to temp table ( igf_db_pays_prg_t ) and fund setup for pays only units
1230: -- If there are no records, the check is failed else passed
1231: --
1232:
1233: CURSOR cur_std_pays(

Line 1239: FROM igf_db_pays_prg_t

1235: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE
1236: )
1237: IS
1238: SELECT unit_cd, unit_ver_num
1239: FROM igf_db_pays_prg_t
1240: WHERE base_id = p_base_id
1241: INTERSECT
1242: SELECT unit_cd, version_number
1243: FROM igf_aw_fund_unit_v funit

Line 1421: FROM igf_db_pays_prg_t db;

1417: --------------------------------------------------------------------------------------------
1418: CURSOR cur_pays_prg
1419: IS
1420: SELECT db.ROWID row_id, db.*
1421: FROM igf_db_pays_prg_t db;
1422:
1423: pays_prg_rec cur_pays_prg%ROWTYPE;
1424: BEGIN
1425: OPEN cur_pays_prg;

Line 1430: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);

1426:
1427: LOOP
1428: FETCH cur_pays_prg INTO pays_prg_rec;
1429: EXIT WHEN cur_pays_prg%NOTFOUND;
1430: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
1431:
1432: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1433: THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');

Line 1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');

1430: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
1431:
1432: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1433: THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');
1435: END IF;
1436: END LOOP;
1437:
1438: CLOSE cur_pays_prg;

Line 2052: -- First get all the enrolled programs, unit sets for the student and insert into IGF_DB_PAYS_PRG_T

2048: END IF;
2049:
2050:
2051: --
2052: -- First get all the enrolled programs, unit sets for the student and insert into IGF_DB_PAYS_PRG_T
2053: -- We are doing this before starting the main loop.
2054: -- It may very well happen that there are no Pays only units or programs defined in fund setup
2055: -- Still we need to have the the enrolled programs, unit sets for the student into IGF_DB_PAYS_PRG_T
2056: --

Line 2055: -- Still we need to have the the enrolled programs, unit sets for the student into IGF_DB_PAYS_PRG_T

2051: --
2052: -- First get all the enrolled programs, unit sets for the student and insert into IGF_DB_PAYS_PRG_T
2053: -- We are doing this before starting the main loop.
2054: -- It may very well happen that there are no Pays only units or programs defined in fund setup
2055: -- Still we need to have the the enrolled programs, unit sets for the student into IGF_DB_PAYS_PRG_T
2056: --
2057:
2058: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2059: THEN