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_AW_SS_GEN_PKG dependencies on IGF_AW_AWARD

Line 85: PROCEDURE update_awards_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,

81: END IF;
82:
83: END apply_certf_resp;
84:
85: PROCEDURE update_awards_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,
86: p_offered_amt NUMBER,
87: p_accepted_amt NUMBER,
88: p_award_status VARCHAR2
89: ) AS

Line 103: CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE) IS

99: --Change History:
100: --Who When What
101: -------------------------------------------------------------------
102:
103: CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE) IS
104: SELECT disb.rowid row_id,
105: disb.*
106: FROM IGF_AW_AWD_DISB_ALL disb
107: WHERE award_id = cp_award_id

Line 112: FROM igf_aw_award awd,

108: AND trans_type IN ('A', 'P');
109:
110: CURSOR cur_fund_details (cp_award_id NUMBER) IS
111: SELECT mast.*
112: FROM igf_aw_award awd,
113: igf_aw_fund_mast mast
114: WHERE awd.award_id = cp_award_id
115: AND awd.fund_id = mast.fund_id;
116:

Line 451: FROM IGF_AW_AWARD_ALL awd,

447:
448: -- Cursor to return award status for all awards in an award period
449: CURSOR c_ap_award (cp_ci_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_award_prd_cd VARCHAR2, cp_base_id NUMBER) IS
450: SELECT awd.*
451: FROM IGF_AW_AWARD_ALL awd,
452: IGF_AW_AWD_DISB_ALL disb,
453: IGF_AW_AWD_PRD_TERM ap
454: WHERE awd.base_id = cp_base_id
455: AND awd.publish_in_ss_flag = 'Y'

Line 526: lv_view_only_prof_val := fnd_profile.value('IGF_AW_AWARD_VIEW_ONLY_IN_SS');

522: END IF;
523: END LOOP;
524:
525: -- Get the value of profile "IGF: View-only Awards via Student Self-Service"
526: lv_view_only_prof_val := fnd_profile.value('IGF_AW_AWARD_VIEW_ONLY_IN_SS');
527:
528: IF (lv_view_only_prof_val = 'Y') THEN -- If the profile value is Yes
529: lv_ret_status := 'VO'; -- All the awards will be shown in View Only mode in the Student Self-Service page.
530: RETURN lv_ret_status;

Line 668: FROM IGF_AW_AWARD awd,

664: RETURN VARCHAR2 AS
665:
666: CURSOR cur_fund_details ( cp_award_id NUMBER) IS
667: SELECT awd.lock_award_flag lock_awd_flag, mast.*
668: FROM IGF_AW_AWARD awd,
669: IGF_AW_FUND_MAST mast
670: WHERE awd.award_id = cp_award_id
671: AND awd.fund_id = mast.fund_id;
672: fund_mast_rec cur_fund_details%ROWTYPE;

Line 706: FROM IGF_AW_AWARD

702: l_orig_status cur_orig_status%ROWTYPE;
703:
704: CURSOR cur_award_status (cp_award_id NUMBER) IS
705: SELECT award_status
706: FROM IGF_AW_AWARD
707: WHERE award_id = cp_award_id;
708:
709: l_award_status igf_aw_award.AWARD_STATUS%TYPE;
710:

Line 709: l_award_status igf_aw_award.AWARD_STATUS%TYPE;

705: SELECT award_status
706: FROM IGF_AW_AWARD
707: WHERE award_id = cp_award_id;
708:
709: l_award_status igf_aw_award.AWARD_STATUS%TYPE;
710:
711:
712: BEGIN
713:

Line 808: FROM IGF_AW_AWARD awd,

804: RETURN VARCHAR2 AS
805:
806: CURSOR cur_fund_details (cp_award_id NUMBER) IS
807: SELECT awd.lock_award_flag lock_awd_flag, mast.*
808: FROM IGF_AW_AWARD awd,
809: IGF_AW_FUND_MAST mast
810: WHERE awd.award_id = cp_award_id
811: AND awd.fund_id = mast.fund_id;
812: fund_mast_rec cur_fund_details%ROWTYPE;

Line 846: FROM IGF_AW_AWARD

842: l_orig_status cur_orig_status%ROWTYPE;
843:
844: CURSOR cur_award_status (cp_award_id NUMBER) IS
845: SELECT award_status
846: FROM IGF_AW_AWARD
847: WHERE award_id = cp_award_id;
848:
849: l_award_status igf_aw_award.AWARD_STATUS%TYPE;
850:

Line 849: l_award_status igf_aw_award.AWARD_STATUS%TYPE;

845: SELECT award_status
846: FROM IGF_AW_AWARD
847: WHERE award_id = cp_award_id;
848:
849: l_award_status igf_aw_award.AWARD_STATUS%TYPE;
850:
851: BEGIN
852: OPEN cur_fund_details(p_award_id);
853: FETCH cur_fund_details INTO fund_mast_rec;

Line 948: FROM IGF_AW_AWARD awd,

944: RETURN VARCHAR2 AS
945:
946: CURSOR cur_fund_details (cp_award_id NUMBER) IS
947: SELECT awd.lock_award_flag lock_awd_flag, mast.*
948: FROM IGF_AW_AWARD awd,
949: IGF_AW_FUND_MAST mast
950: WHERE awd.award_id = cp_award_id
951: AND awd.fund_id = mast.fund_id;
952: fund_mast_rec cur_fund_details%ROWTYPE;

Line 986: FROM IGF_AW_AWARD awd

982: l_orig_status cur_orig_status%ROWTYPE;
983:
984: CURSOR cur_award_details (cp_award_id NUMBER) IS
985: SELECT *
986: FROM IGF_AW_AWARD awd
987: WHERE awd.award_id = cp_award_id;
988:
989: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;
990: rec_award_details cur_award_details%ROWTYPE;

Line 989: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;

985: SELECT *
986: FROM IGF_AW_AWARD awd
987: WHERE awd.award_id = cp_award_id;
988:
989: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;
990: rec_award_details cur_award_details%ROWTYPE;
991:
992: CURSOR cur_award_status (cp_award_id NUMBER) IS
993: SELECT award_status

Line 994: FROM IGF_AW_AWARD

990: rec_award_details cur_award_details%ROWTYPE;
991:
992: CURSOR cur_award_status (cp_award_id NUMBER) IS
993: SELECT award_status
994: FROM IGF_AW_AWARD
995: WHERE award_id = cp_award_id;
996:
997: l_award_status igf_aw_award.AWARD_STATUS%TYPE;
998:

Line 997: l_award_status igf_aw_award.AWARD_STATUS%TYPE;

993: SELECT award_status
994: FROM IGF_AW_AWARD
995: WHERE award_id = cp_award_id;
996:
997: l_award_status igf_aw_award.AWARD_STATUS%TYPE;
998:
999: BEGIN
1000:
1001: OPEN cur_fund_details(p_award_id);

Line 1106: PROCEDURE update_award_status ( p_award_id igf_aw_award_all.award_id%TYPE,

1102:
1103: RETURN 'M';
1104: END get_decline_display_mode;
1105:
1106: PROCEDURE update_award_status ( p_award_id igf_aw_award_all.award_id%TYPE,
1107: p_award_status VARCHAR2,
1108: p_lock_status VARCHAR2
1109: ) AS
1110: ------------------------------------------------------------------

Line 1123: CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE) IS

1119: --Change History:
1120: --Who When What
1121: -------------------------------------------------------------------
1122: -- Get an award
1123: CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE) IS
1124: SELECT awd.rowid row_id,
1125: awd.*
1126: FROM IGF_AW_AWARD_ALL awd
1127: WHERE award_id = cp_award_id;

Line 1126: FROM IGF_AW_AWARD_ALL awd

1122: -- Get an award
1123: CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE) IS
1124: SELECT awd.rowid row_id,
1125: awd.*
1126: FROM IGF_AW_AWARD_ALL awd
1127: WHERE award_id = cp_award_id;
1128: awd_rec c_award%ROWTYPE;
1129:
1130: BEGIN

Line 1135: igf_aw_award_pkg.set_award_change_source('STDNT_SELF_SERV');

1131: OPEN c_award(p_award_id);
1132: FETCH c_award INTO awd_rec;
1133: CLOSE c_award;
1134:
1135: igf_aw_award_pkg.set_award_change_source('STDNT_SELF_SERV');
1136:
1137: igf_aw_award_pkg.update_row(
1138: x_rowid => awd_rec.row_id,
1139: x_award_id => awd_rec.award_id,

Line 1137: igf_aw_award_pkg.update_row(

1133: CLOSE c_award;
1134:
1135: igf_aw_award_pkg.set_award_change_source('STDNT_SELF_SERV');
1136:
1137: igf_aw_award_pkg.update_row(
1138: x_rowid => awd_rec.row_id,
1139: x_award_id => awd_rec.award_id,
1140: x_fund_id => awd_rec.fund_id,
1141: x_base_id => awd_rec.base_id,

Line 1184: igf_aw_Award_pkg.reset_awd_hist_trans_id;

1180: x_awd_proc_status_code => awd_rec.awd_proc_status_code,
1181: x_publish_in_ss_flag => awd_rec.publish_in_ss_flag
1182: );
1183:
1184: igf_aw_Award_pkg.reset_awd_hist_trans_id;
1185:
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: NULL;

Line 1193: PROCEDURE update_awards_by_term_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,

1189: END update_award_status;
1190:
1191:
1192:
1193: PROCEDURE update_awards_by_term_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,
1194: p_ld_cal_type VARCHAR2,
1195: p_ld_seq_num NUMBER,
1196: p_offered_amt NUMBER,
1197: p_accepted_amt NUMBER,

Line 1213: CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE,

1209: --Change History:
1210: --Who When What
1211: -------------------------------------------------------------------
1212:
1213: CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE,
1214: cp_ld_cal_type VARCHAR2,
1215: cp_ld_seq_num NUMBER) IS
1216: SELECT disb.rowid row_id,
1217: disb.*

Line 1231: cp_award_id igf_aw_award_all.award_id%TYPE

1227: l_award_status VARCHAR2(30);
1228: l_lock_status VARCHAR2(1);
1229:
1230: CURSOR c_get_disb_rounding(
1231: cp_award_id igf_aw_award_all.award_id%TYPE
1232: ) IS
1233: SELECT fmast.disb_rounding_code
1234: FROM igf_aw_award_all awd,
1235: igf_aw_fund_mast_all fmast

Line 1234: FROM igf_aw_award_all awd,

1230: CURSOR c_get_disb_rounding(
1231: cp_award_id igf_aw_award_all.award_id%TYPE
1232: ) IS
1233: SELECT fmast.disb_rounding_code
1234: FROM igf_aw_award_all awd,
1235: igf_aw_fund_mast_all fmast
1236: WHERE awd.fund_id = fmast.fund_id
1237: AND awd.award_id = cp_award_id;
1238: rec_fund_mast c_get_disb_rounding%ROWTYPE;

Line 1402: FROM igf_aw_award_all

1398: l_last_accept_date DATE;
1399:
1400: CURSOR c_get_base_id (cp_award_id NUMBER) IS
1401: SELECT base_id
1402: FROM igf_aw_award_all
1403: WHERE award_id = cp_award_id;
1404:
1405: l_get_base_id c_get_base_id%ROWTYPE;
1406:

Line 1410: FROM IGF_AW_AWARD awd,

1406:
1407:
1408: CURSOR cur_fund_details ( cp_award_id NUMBER) IS
1409: SELECT awd.lock_award_flag lock_awd_flag, mast.*
1410: FROM IGF_AW_AWARD awd,
1411: IGF_AW_FUND_MAST mast
1412: WHERE awd.award_id = cp_award_id
1413: AND awd.fund_id = mast.fund_id;
1414: fund_mast_rec cur_fund_details%ROWTYPE;

Line 1446: l_award_status igf_aw_award_all.award_status%TYPE;

1442: WHERE award_id = cp_award_id;
1443:
1444: l_orig_status cur_orig_status%ROWTYPE;
1445:
1446: l_award_status igf_aw_award_all.award_status%TYPE;
1447:
1448: BEGIN
1449:
1450: OPEN c_get_base_id(p_award_id);

Line 1581: FROM igf_aw_award_all

1577: l_last_accept_date DATE;
1578:
1579: CURSOR c_get_base_id (cp_award_id NUMBER) IS
1580: SELECT base_id
1581: FROM igf_aw_award_all
1582: WHERE award_id = cp_award_id;
1583:
1584: l_get_base_id c_get_base_id%ROWTYPE;
1585:

Line 1588: FROM IGF_AW_AWARD awd,

1584: l_get_base_id c_get_base_id%ROWTYPE;
1585:
1586: CURSOR cur_fund_details (cp_award_id NUMBER) IS
1587: SELECT awd.lock_award_flag lock_awd_flag, mast.*
1588: FROM IGF_AW_AWARD awd,
1589: IGF_AW_FUND_MAST mast
1590: WHERE awd.award_id = cp_award_id
1591: AND awd.fund_id = mast.fund_id;
1592: fund_mast_rec cur_fund_details%ROWTYPE;

Line 1624: l_award_status igf_aw_award_all.award_status%TYPE;

1620: WHERE award_id = cp_award_id;
1621:
1622: l_orig_status cur_orig_status%ROWTYPE;
1623:
1624: l_award_status igf_aw_award_all.award_status%TYPE;
1625:
1626: BEGIN
1627:
1628: OPEN c_get_base_id(p_award_id);

Line 1760: FROM igf_aw_award_all

1756: l_last_accept_date DATE;
1757:
1758: CURSOR c_get_base_id (cp_award_id NUMBER) IS
1759: SELECT base_id
1760: FROM igf_aw_award_all
1761: WHERE award_id = cp_award_id;
1762:
1763: l_get_base_id c_get_base_id%ROWTYPE;
1764:

Line 1767: FROM IGF_AW_AWARD awd,

1763: l_get_base_id c_get_base_id%ROWTYPE;
1764:
1765: CURSOR cur_fund_details (cp_award_id NUMBER) IS
1766: SELECT awd.lock_award_flag lock_awd_flag, mast.*
1767: FROM IGF_AW_AWARD awd,
1768: IGF_AW_FUND_MAST mast
1769: WHERE awd.award_id = cp_award_id
1770: AND awd.fund_id = mast.fund_id;
1771: fund_mast_rec cur_fund_details%ROWTYPE;

Line 1805: FROM IGF_AW_AWARD awd

1801: l_orig_status cur_orig_status%ROWTYPE;
1802:
1803: CURSOR cur_award_details (cp_award_id NUMBER) IS
1804: SELECT *
1805: FROM IGF_AW_AWARD awd
1806: WHERE awd.award_id = cp_award_id;
1807:
1808: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;
1809: rec_award_details cur_award_details%ROWTYPE;

Line 1808: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;

1804: SELECT *
1805: FROM IGF_AW_AWARD awd
1806: WHERE awd.award_id = cp_award_id;
1807:
1808: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;
1809: rec_award_details cur_award_details%ROWTYPE;
1810:
1811: l_award_status igf_aw_award_all.award_status%TYPE;
1812:

Line 1811: l_award_status igf_aw_award_all.award_status%TYPE;

1807:
1808: --rec_award_status igf_aw_award.AWARD_STATUS%TYPE;
1809: rec_award_details cur_award_details%ROWTYPE;
1810:
1811: l_award_status igf_aw_award_all.award_status%TYPE;
1812:
1813: BEGIN
1814:
1815: OPEN c_get_base_id(p_award_id);