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

Line 115: p_award_id IN igf_aw_award_v.award_id%TYPE

111:
112:
113: PROCEDURE display_auth_process_log(p_person_number IN igs_pe_person.person_number%TYPE,
114: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
115: p_award_id IN igf_aw_award_v.award_id%TYPE
116: ) IS
117: ------------------------------------------------------------------------------------
118: --Created by : brajendr
119: --Date created : 16-May-2002

Line 242: p_award_id IN igf_aw_award.award_id%TYPE,

238:
239: PROCEDURE send_work_auth(p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
240: p_person_id IN hz_parties.party_id%TYPE,
241: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
242: p_award_id IN igf_aw_award.award_id%TYPE,
243: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
244: p_ld_seq_no IN igs_ca_inst.sequence_number%TYPE,
245: p_call IN VARCHAR2,
246: p_auth_date IN DATE

Line 272: cv_award_id igf_aw_award.award_id%TYPE,

268: FROM igf_aw_fund_mast
269: WHERE fund_id = cv_fund_id;
270:
271: CURSOR c_awd (cv_fund_id igf_aw_fund_mast.fund_id%TYPE,
272: cv_award_id igf_aw_award.award_id%TYPE,
273: cv_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
274: SELECT pit.api_person_id ssn,
275: fmast.ci_cal_type,
276: fmast.ci_sequence_number,

Line 279: FROM igf_aw_award awd,

275: fmast.ci_cal_type,
276: fmast.ci_sequence_number,
277: awd.base_id,
278: awd.award_id
279: FROM igf_aw_award awd,
280: igf_aw_fund_cat fcat,
281: igf_aw_fund_mast fmast,
282: igf_ap_fa_base_rec farec,
283: igs_pe_alt_pers_id_v pit,

Line 330: cp_award_id igf_aw_award_all.award_id%TYPE

326: WHERE party_id = cv_person_id
327: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE);
328:
329: CURSOR c_accept_amnt(
330: cp_award_id igf_aw_award_all.award_id%TYPE
331: ) IS
332: SELECT NVL(awd.accepted_amt,0) accepted_amt
333: FROM igf_aw_award awd
334: WHERE awd.award_id = cp_award_id;

Line 333: FROM igf_aw_award awd

329: CURSOR c_accept_amnt(
330: cp_award_id igf_aw_award_all.award_id%TYPE
331: ) IS
332: SELECT NVL(awd.accepted_amt,0) accepted_amt
333: FROM igf_aw_award awd
334: WHERE awd.award_id = cp_award_id;
335:
336: CURSOR c_next_auth IS
337: SELECT igf_se_auth_s1.NEXTVAL

Line 340: CURSOR c_auth_check(cv_award_id igf_aw_award.award_id%TYPE,

336: CURSOR c_next_auth IS
337: SELECT igf_se_auth_s1.NEXTVAL
338: FROM dual;
339:
340: CURSOR c_auth_check(cv_award_id igf_aw_award.award_id%TYPE,
341: cv_ld_cal_type igs_ca_inst.cal_type%TYPE,
342: cv_ld_seq_no igs_ca_inst.sequence_number%TYPE
343: ) IS
344: SELECT auth_id

Line 828: FROM igf_aw_award_all awd,

824: fa.person_id person_id,
825: awd.base_id,
826: hz.party_number person_number,
827: fmast.fund_code
828: FROM igf_aw_award_all awd,
829: igf_aw_fund_mast_all fmast,
830: igf_aw_fund_cat_all fcat,
831: igf_ap_fa_base_rec_all fa,
832: hz_parties hz

Line 846: cp_award_id igf_aw_award_all.award_id%TYPE

842: AND fa.person_id = hz.party_id;
843:
844: -- Check if authorization already exists
845: CURSOR c_auth_exists(
846: cp_award_id igf_aw_award_all.award_id%TYPE
847: ) IS
848: SELECT 'x'
849: FROM igf_se_auth
850: WHERE award_id = cp_award_id

Line 856: cp_award_id igf_aw_award_all.award_id%TYPE

852: l_auth_exists c_auth_exists%ROWTYPE;
853:
854: -- Check if accepted amounts are equal at the award and authorization levels
855: CURSOR c_amounts(
856: cp_award_id igf_aw_award_all.award_id%TYPE
857: ) IS
858: SELECT awd.accepted_amt accepted_amt,
859: auth.accepted_amnt accepted_amnt
860: FROM igf_aw_award_all awd,

Line 860: FROM igf_aw_award_all awd,

856: cp_award_id igf_aw_award_all.award_id%TYPE
857: ) IS
858: SELECT awd.accepted_amt accepted_amt,
859: auth.accepted_amnt accepted_amnt
860: FROM igf_aw_award_all awd,
861: igf_se_auth auth
862: WHERE awd.award_id = auth.award_id
863: AND awd.award_id = cp_award_id
864: AND auth.flag = 'A';

Line 998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b

994:
995: CURSOR c_auth_count(cv_auth_id igf_se_auth.auth_id%TYPE,
996: cv_person_id hz_parties.party_id%TYPE) IS
997: SELECT COUNT(*) count
998: FROM igf_se_auth c,igf_aw_award a, igf_ap_fa_base_rec b
999: WHERE c.auth_id = cv_auth_id
1000: AND c.award_id = a.award_id
1001: AND a.base_id = b.base_id
1002: AND b.person_id = cv_person_id

Line 1260: FROM igf_aw_award_all awd,

1256: cv_auth_id igf_se_auth.auth_id%TYPE
1257: ) IS
1258: SELECT NVL(accepted_amt,NVL(offered_amt,0)) accepted_amt,
1259: base_id
1260: FROM igf_aw_award_all awd,
1261: igf_se_auth se
1262: WHERE se.award_id = awd.award_id
1263: AND se.auth_id = cv_auth_id
1264: AND se.flag = 'A';

Line 1271: FROM igf_aw_award awd,

1267: CURSOR c_award(
1268: cp_auth_id igf_se_auth.auth_id%TYPE
1269: ) IS
1270: SELECT awd.*
1271: FROM igf_aw_award awd,
1272: igf_se_auth auth
1273: WHERE auth.auth_id = cp_auth_id
1274: AND auth.award_id = awd.award_id;
1275:

Line 1426: igf_aw_award_pkg.update_row(

1422: OPEN c_award(l_auth_id);
1423: FETCH c_award INTO l_award;
1424: CLOSE c_award;
1425:
1426: igf_aw_award_pkg.update_row(
1427: x_rowid => l_award.row_id,
1428: x_award_id => l_award.award_id,
1429: x_fund_id => l_award.fund_id,
1430: x_base_id => l_award.base_id,

Line 1558: p_award_id IN igf_aw_award_all.award_id%TYPE

1554: PROCEDURE se_notify(p_person_id IN hz_parties.party_id%TYPE,
1555: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
1556: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
1557: p_ld_seq_no IN igs_ca_inst.sequence_number%TYPE,
1558: p_award_id IN igf_aw_award_all.award_id%TYPE
1559: ) IS
1560: ------------------------------------------------------------------------------------
1561: --Created by : ssawhney ( Oracle IDC)
1562: --Date created: 2nd jan