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_ALL

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 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 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 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 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 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 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);