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.

[Home] [Help]

APPS.IGF_AW_COA_GEN dependencies on IGS_CA_INST

Line 199: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

195:
196: FUNCTION isCoaLocked(
197: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
198: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
199: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
200: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
201: ) RETURN BOOLEAN AS
202: ------------------------------------------------------------------
203: --Created by : veramach, Oracle India

Line 200: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

196: FUNCTION isCoaLocked(
197: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
198: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
199: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
200: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
201: ) RETURN BOOLEAN AS
202: ------------------------------------------------------------------
203: --Created by : veramach, Oracle India
204: --Date created: 07-OCT-2004

Line 219: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

215: -- Get item/term level lock
216: CURSOR c_item_term(
217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
218: cp_item_code igf_aw_item.item_code%TYPE,
219: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
220: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
221: ) IS
222: SELECT NVL(lock_flag,'N') lock_flag
223: FROM igf_aw_coa_itm_terms

Line 220: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

216: CURSOR c_item_term(
217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
218: cp_item_code igf_aw_item.item_code%TYPE,
219: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
220: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
221: ) IS
222: SELECT NVL(lock_flag,'N') lock_flag
223: FROM igf_aw_coa_itm_terms
224: WHERE base_id = cp_base_id

Line 343: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

339: PROCEDURE updateLock(
340: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
341: p_mode VARCHAR2,
342: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
343: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
344: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
345: );
346:
347: PROCEDURE doLockInternal(

Line 344: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

340: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
341: p_mode VARCHAR2,
342: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
343: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
344: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
345: );
346:
347: PROCEDURE doLockInternal(
348: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 350: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

346:
347: PROCEDURE doLockInternal(
348: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
349: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
350: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
351: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
352: ) AS
353: ------------------------------------------------------------------
354: --Created by : veramach, Oracle India

Line 351: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

347: PROCEDURE doLockInternal(
348: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
349: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
350: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
351: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
352: ) AS
353: ------------------------------------------------------------------
354: --Created by : veramach, Oracle India
355: --Date created: 07-OCT-2004

Line 381: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

377:
378: PROCEDURE doUnlockInternal(
379: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
380: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
381: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
382: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
383: ) AS
384: ------------------------------------------------------------------
385: --Created by : veramach, Oracle India

Line 382: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

378: PROCEDURE doUnlockInternal(
379: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
380: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
381: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
382: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
383: ) AS
384: ------------------------------------------------------------------
385: --Created by : veramach, Oracle India
386: --Date created: 07-OCT-2004

Line 413: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

409: PROCEDURE updateLock(
410: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
411: p_mode VARCHAR2,
412: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
413: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
414: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
415: ) AS
416: ------------------------------------------------------------------
417: --Created by : veramach, Oracle India

Line 414: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

410: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
411: p_mode VARCHAR2,
412: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
413: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
414: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
415: ) AS
416: ------------------------------------------------------------------
417: --Created by : veramach, Oracle India
418: --Date created: 07-OCT-2004

Line 432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

428:
429: CURSOR c_item_term(
430: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
431: cp_item_code igf_aw_item.item_code%TYPE,
432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
434: ) IS
435: SELECT terms.rowid row_id,
436: terms.*

Line 433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

429: CURSOR c_item_term(
430: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
431: cp_item_code igf_aw_item.item_code%TYPE,
432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
434: ) IS
435: SELECT terms.rowid row_id,
436: terms.*
437: FROM igf_aw_coa_itm_terms terms

Line 953: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

949:
950: FUNCTION doLock(
951: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
952: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
953: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
954: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
955: ) RETURN VARCHAR2 AS
956: ------------------------------------------------------------------
957: --Created by : veramach, Oracle India

Line 954: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

950: FUNCTION doLock(
951: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
952: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
953: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
954: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
955: ) RETURN VARCHAR2 AS
956: ------------------------------------------------------------------
957: --Created by : veramach, Oracle India
958: --Date created: 07-OCT-2004

Line 995: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

991:
992: FUNCTION doUnlock(
993: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
994: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
995: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
996: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
997: ) RETURN VARCHAR2 AS
998: ------------------------------------------------------------------
999: --Created by : veramach, Oracle India

Line 996: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

992: FUNCTION doUnlock(
993: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
994: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
995: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
996: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
997: ) RETURN VARCHAR2 AS
998: ------------------------------------------------------------------
999: --Created by : veramach, Oracle India
1000: --Date created: 07-OCT-2004

Line 1219: p_ld_cal_type igs_ca_inst.cal_type%TYPE,

1215: END canUseAnticipVal;
1216:
1217: FUNCTION getBaseDetails(
1218: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1219: p_ld_cal_type igs_ca_inst.cal_type%TYPE,
1220: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1221: ) RETURN base_details AS
1222: ------------------------------------------------------------------
1223: --Created by : veramach, Oracle India

Line 1220: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1216:
1217: FUNCTION getBaseDetails(
1218: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1219: p_ld_cal_type igs_ca_inst.cal_type%TYPE,
1220: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1221: ) RETURN base_details AS
1222: ------------------------------------------------------------------
1223: --Created by : veramach, Oracle India
1224: --Date created: 11-Oct-2004

Line 1258: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1254:
1255: -- Get anticipated values
1256: CURSOR c_anticip(
1257: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1258: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1259: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1260: ) IS
1261: SELECT org_unit_cd,
1262: program_type,

Line 1259: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1255: -- Get anticipated values
1256: CURSOR c_anticip(
1257: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1258: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1259: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1260: ) IS
1261: SELECT org_unit_cd,
1262: program_type,
1263: program_location_cd,

Line 1282: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1278:
1279: -- Get org unit
1280: CURSOR c_org(
1281: cp_person_id hz_parties.party_id%TYPE,
1282: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1283: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1284: ) IS
1285: SELECT ps.responsible_org_unit_cd,1 record_order
1286: FROM igs_en_spa_terms key,

Line 1283: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1279: -- Get org unit
1280: CURSOR c_org(
1281: cp_person_id hz_parties.party_id%TYPE,
1282: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1283: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1284: ) IS
1285: SELECT ps.responsible_org_unit_cd,1 record_order
1286: FROM igs_en_spa_terms key,
1287: igs_ps_ver ps

Line 1308: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1304:
1305: -- Get program type
1306: CURSOR c_prg_type(
1307: cp_person_id hz_parties.party_id%TYPE,
1308: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1309: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1310: ) IS
1311: SELECT pt.course_type,1 record_order
1312: FROM igs_en_spa_terms sp,

Line 1309: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1305: -- Get program type
1306: CURSOR c_prg_type(
1307: cp_person_id hz_parties.party_id%TYPE,
1308: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1309: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1310: ) IS
1311: SELECT pt.course_type,1 record_order
1312: FROM igs_en_spa_terms sp,
1313: igs_ps_ver pv,

Line 1337: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1333:
1334: -- Get program location
1335: CURSOR c_prog_loc(
1336: cp_person_id hz_parties.party_id%TYPE,
1337: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1338: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1339: ) IS
1340: SELECT location_cd,
1341: 1 record_order

Line 1338: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1334: -- Get program location
1335: CURSOR c_prog_loc(
1336: cp_person_id hz_parties.party_id%TYPE,
1337: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1338: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1339: ) IS
1340: SELECT location_cd,
1341: 1 record_order
1342: FROM igs_en_spa_terms

Line 1358: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1354:
1355: -- Get get program code
1356: CURSOR c_prog_code(
1357: cp_person_id hz_parties.party_id%TYPE,
1358: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1359: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1360: ) IS
1361: SELECT program_cd,
1362: program_version,

Line 1359: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1355: -- Get get program code
1356: CURSOR c_prog_code(
1357: cp_person_id hz_parties.party_id%TYPE,
1358: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1359: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1360: ) IS
1361: SELECT program_cd,
1362: program_version,
1363: 1 record_order

Line 1382: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1378:
1379: -- Get attendance type
1380: CURSOR c_att_type(
1381: cp_person_id hz_parties.party_id%TYPE,
1382: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1383: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1384: ) IS
1385: SELECT attendance_type,
1386: 1 record_order

Line 1383: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1379: -- Get attendance type
1380: CURSOR c_att_type(
1381: cp_person_id hz_parties.party_id%TYPE,
1382: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1383: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1384: ) IS
1385: SELECT attendance_type,
1386: 1 record_order
1387: FROM igs_en_spa_terms

Line 1403: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1399:
1400: -- Get attendance mode
1401: CURSOR c_att_mode(
1402: cp_person_id hz_parties.party_id%TYPE,
1403: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1404: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1405: ) IS
1406: SELECT attendance_mode,
1407: 1 record_order

Line 1404: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1400: -- Get attendance mode
1401: CURSOR c_att_mode(
1402: cp_person_id hz_parties.party_id%TYPE,
1403: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1404: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1405: ) IS
1406: SELECT attendance_mode,
1407: 1 record_order
1408: FROM igs_en_spa_terms

Line 1432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

1428:
1429: -- Get housing status
1430: CURSOR c_housing_status(
1431: cp_person_id hz_parties.party_id%TYPE,
1432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1434: ) IS
1435: SELECT teach_period_resid_stat_cd
1436: FROM igs_pe_teach_periods_all

Line 1433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

1429: -- Get housing status
1430: CURSOR c_housing_status(
1431: cp_person_id hz_parties.party_id%TYPE,
1432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
1433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1434: ) IS
1435: SELECT teach_period_resid_stat_cd
1436: FROM igs_pe_teach_periods_all
1437: WHERE person_id = cp_person_id

Line 2140: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

2136:
2137: END set_awd_proc_status;
2138:
2139: PROCEDURE get_award_period_dates(
2140: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
2141: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2142: p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
2143: p_start_date OUT NOCOPY DATE,
2144: p_end_date OUT NOCOPY DATE

Line 2141: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

2137: END set_awd_proc_status;
2138:
2139: PROCEDURE get_award_period_dates(
2140: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
2141: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
2142: p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
2143: p_start_date OUT NOCOPY DATE,
2144: p_end_date OUT NOCOPY DATE
2145: ) AS

Line 2161: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

2157: -------------------------------------------------------------------
2158:
2159: -- Get all terms attached to the awarding period
2160: CURSOR c_load_cal(
2161: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2162: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2163: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
2164: ) IS
2165: SELECT MIN(cal.start_dt) start_date,

Line 2162: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

2158:
2159: -- Get all terms attached to the awarding period
2160: CURSOR c_load_cal(
2161: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
2162: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
2163: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
2164: ) IS
2165: SELECT MIN(cal.start_dt) start_date,
2166: MAX(cal.end_dt) end_date

Line 2168: igs_ca_inst cal

2164: ) IS
2165: SELECT MIN(cal.start_dt) start_date,
2166: MAX(cal.end_dt) end_date
2167: FROM igf_aw_awd_prd_term aprd,
2168: igs_ca_inst cal
2169: WHERE aprd.ci_cal_type = cp_ci_cal_type
2170: AND aprd.ci_sequence_number = cp_ci_sequence_number
2171: AND aprd.award_prd_cd = cp_award_prd_code
2172: AND aprd.ld_cal_type = cal.cal_type