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_GR_REPACKAGE dependencies on IGF_AP_FA_BASE_REC_ALL

Line 43: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

39: ----------------------------------------------------------------------
40: --
41:
42: PROCEDURE log_parameters(
43: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
44: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
45: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
46: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
47: p_test_run IN VARCHAR2,

Line 44: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

40: --
41:
42: PROCEDURE log_parameters(
43: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
44: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
45: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
46: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
47: p_test_run IN VARCHAR2,
48: p_cancel_invalid_award IN VARCHAR2

Line 45: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

41:
42: PROCEDURE log_parameters(
43: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
44: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
45: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
46: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
47: p_test_run IN VARCHAR2,
48: p_cancel_invalid_award IN VARCHAR2
49: ) AS

Line 72: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

68: l_cancel_inv_awd_log igf_lookups_view.meaning%TYPE ;
69:
70: -- Get person number
71: CURSOR c_person_number(
72: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
73: ) IS
74: SELECT party_number
75: FROM hz_parties parties,
76: igf_ap_fa_base_rec_all fabase

Line 76: igf_ap_fa_base_rec_all fabase

72: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
73: ) IS
74: SELECT party_number
75: FROM hz_parties parties,
76: igf_ap_fa_base_rec_all fabase
77: WHERE fabase.person_id = parties.party_id
78: AND fabase.base_id = cp_base_id;
79:
80: l_person_number hz_parties.party_number%TYPE;

Line 321: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE

317: END cancel_invalid_award;
318:
319:
320: PROCEDURE repackage(
321: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
322: ) AS
323: ------------------------------------------------------------------
324: --Created by : veramach, Oracle India
325: --Date created:

Line 337: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

333: --Who When What
334: -------------------------------------------------------------------
335:
336: CURSOR c_stud_det(
337: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
338: ) IS
339: SELECT awd.base_id,
340: awd.award_id,
341: awd.fund_id,

Line 394: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

390:
391:
392: -- Get active ISIR
393: CURSOR c_active_isir(
394: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
395: ) IS
396: SELECT isir_id
397: FROM igf_ap_isir_matched_all
398: WHERE base_id = cp_base_id

Line 404: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

400: l_active_isir c_active_isir%ROWTYPE;
401:
402: -- Get payment isir
403: CURSOR c_payment_isir(
404: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
405: ) IS
406: SELECT isir_id
407: FROM igf_ap_isir_matched_all
408: WHERE base_id = cp_base_id

Line 511: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

507: l_pell_schedule_code igf_aw_award_all.alt_pell_schedule%TYPE;
508:
509: -- Get person number
510: CURSOR c_person_number(
511: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
512: ) IS
513: SELECT party_number
514: FROM hz_parties parties,
515: igf_ap_fa_base_rec_all fabase

Line 515: igf_ap_fa_base_rec_all fabase

511: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
512: ) IS
513: SELECT party_number
514: FROM hz_parties parties,
515: igf_ap_fa_base_rec_all fabase
516: WHERE fabase.person_id = parties.party_id
517: AND fabase.base_id = cp_base_id;
518:
519: l_person_number hz_parties.party_number%TYPE;

Line 1321: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1317: PROCEDURE repackage_pell(
1318: errbuf OUT NOCOPY VARCHAR2,
1319: retcode OUT NOCOPY NUMBER,
1320: p_award_year IN VARCHAR2,
1321: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1322: p_org_id IN igf_aw_award_all.org_id%TYPE,
1323: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
1324: p_test_run IN VARCHAR2,
1325: p_cancel_invalid_awds IN VARCHAR2

Line 1347: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

1343: --
1344:
1345: -- Get all base ids in a award year
1346: CURSOR c_all_base_id(
1347: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1348: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1349: ) IS
1350: SELECT awd.base_id
1351: FROM igf_aw_award_all awd,

Line 1348: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE

1344:
1345: -- Get all base ids in a award year
1346: CURSOR c_all_base_id(
1347: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1348: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1349: ) IS
1350: SELECT awd.base_id
1351: FROM igf_aw_award_all awd,
1352: igf_aw_fund_mast_all fmast,

Line 1362: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

1358: AND fcat.fed_fund_code = 'PELL';
1359:
1360: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1361: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1362: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1363:
1364: TYPE baseidRefCur IS REF CURSOR;
1365: cur_base_id baseidRefCur;
1366:

Line 1427: OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number,p_persid_grp;

1423:
1424: --Bug #5021084. Passing Group ID if the group type is STATIC.
1425: IF lv_group_type = 'STATIC' THEN
1426: --open ref cursor for fetching the base_id of the person
1427: OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number,p_persid_grp;
1428: ELSIF lv_group_type = 'DYNAMIC' THEN
1429: --open ref cursor for fetching the base_id of the person
1430: OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number;
1431: END IF;

Line 1430: OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number;

1426: --open ref cursor for fetching the base_id of the person
1427: OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number,p_persid_grp;
1428: ELSIF lv_group_type = 'DYNAMIC' THEN
1429: --open ref cursor for fetching the base_id of the person
1430: OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number;
1431: END IF;
1432:
1433:
1434: FETCH cur_base_id INTO l_base_id;