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_FUND_MAST

Line 6: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

2: /* $Header: IGFSE01B.pls 120.7 2006/02/01 02:56:25 ridas ship $ */
3:
4: PROCEDURE display_auth_params(p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
5: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
6: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
7: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
8: ) IS
9: ------------------------------------------------------------------------------------
10: --Created by : brajendr

Line 44: CURSOR c_fund_dtls (c_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

40: igf_ap_fa_base_rec_all fa
41: WHERE fa.person_id = hz.party_id
42: AND fa.base_id = c_base_id;
43:
44: CURSOR c_fund_dtls (c_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
45: SELECT fund_code
46: FROM igf_aw_fund_mast
47: WHERE fund_id = c_fund_id;
48:

Line 46: FROM igf_aw_fund_mast

42: AND fa.base_id = c_base_id;
43:
44: CURSOR c_fund_dtls (c_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
45: SELECT fund_code
46: FROM igf_aw_fund_mast
47: WHERE fund_id = c_fund_id;
48:
49: parameter_rec c_get_parameters%ROWTYPE;
50: l_award_year igf_lookups_view.meaning%TYPE;

Line 55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;

51: l_fund_code igf_lookups_view.meaning%TYPE;
52: l_person_number igf_lookups_view.meaning%TYPE;
53: l_para_pass igf_lookups_view.meaning%TYPE;
54: l_awd_alternate_code igs_ca_inst.alternate_code%TYPE := NULL;
55: l_fund_id igf_aw_fund_mast_all.fund_code%TYPE := NULL;
56: l_base_id igs_pe_person.person_number%TYPE := NULL;
57:
58: BEGIN
59:

Line 114: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,

110: END display_auth_params;
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

Line 241: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

237:
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,

Line 266: CURSOR c_fund_mast ( cv_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

262: -- Added one more Validation, SSN is a mandatory for all
263: -- FWS awarded students.
264: -------------------------------------------------------------------------------------
265:
266: CURSOR c_fund_mast ( cv_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
267: SELECT threshold_perct, threshold_value
268: FROM igf_aw_fund_mast
269: WHERE fund_id = cv_fund_id;
270:

Line 268: FROM igf_aw_fund_mast

264: -------------------------------------------------------------------------------------
265:
266: CURSOR c_fund_mast ( cv_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
267: SELECT threshold_perct, threshold_value
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,

Line 271: CURSOR c_awd (cv_fund_id igf_aw_fund_mast.fund_id%TYPE,

267: SELECT threshold_perct, threshold_value
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,

Line 281: igf_aw_fund_mast fmast,

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,
284: igs_pe_person_id_typ pit_2
285: WHERE awd.fund_id = fmast.fund_id

Line 374: l_fund_id igf_aw_fund_mast.fund_id%TYPE;

370: tokens_rec c_get_tokens%ROWTYPE;
371:
372: l_place VARCHAR2(30);
373: l_person_id hz_parties.party_id%TYPE;
374: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
375: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
376: l_ld_seq_no igs_ca_inst.sequence_number%TYPE;
377: l_auth_id igf_se_auth.auth_id%TYPE := 0;
378: l_sequence_no igf_se_auth.sequence_no%TYPE := 0;

Line 788: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

784:
785: PROCEDURE send_work_auth_job(errbuf OUT NOCOPY VARCHAR2,
786: retcode OUT NOCOPY NUMBER,
787: p_awd_cal IN VARCHAR2,
788: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
789: p_dummy IN NUMBER,
790: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
791: ) IS
792: ------------------------------------------------------------------------------------

Line 819: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,

815: -------------------------------------------------------------------------------------
816:
817: CURSOR c_auth(cp_awd_cal_type igs_ca_inst.cal_type%TYPE,
818: cp_awd_seq_no igs_ca_inst.sequence_number%TYPE,
819: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
820: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
821: ) IS
822: SELECT awd.award_id,
823: awd.fund_id fund_id,

Line 829: igf_aw_fund_mast_all fmast,

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
833: WHERE fcat.fed_fund_code = 'FWS'

Line 1284: l_fund_id igf_aw_fund_mast.fund_id%TYPE;

1280:
1281: sum_rec c_sum%ROWTYPE;
1282: l_award c_award%ROWTYPE;
1283: auth_rec c_auth%ROWTYPE;
1284: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
1285: l_person_id igs_pe_person.person_id%TYPE;
1286: ln_total_paid_amount igf_se_payment.paid_amount%TYPE;
1287: l_notification_date igf_se_auth.notification_date%TYPE;
1288:

Line 1291: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

1287: l_notification_date igf_se_auth.notification_date%TYPE;
1288:
1289: -----------local function begin
1290: FUNCTION validate_threshold(
1291: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,
1292: p_paid_amount IN igf_aw_awds_sum_v.paid_amt%TYPE,
1293: p_accepted_amt IN igf_aw_awds_sum_v.accepted_amt%TYPE
1294: ) RETURN BOOLEAN IS
1295: ------------------------------------------------------------------------------------

Line 1306: CURSOR c_fund ( cv_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

1302: --masehgal 26-Dec-2002 # 2516712 Copied Trunc( Sysdate) in notification date
1303: -- to resolve locking error.
1304: -------------------------------------------------------------------------------------
1305:
1306: CURSOR c_fund ( cv_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
1307: SELECT threshold_perct, threshold_value
1308: FROM igf_aw_fund_mast
1309: WHERE fund_id = cv_fund_id;
1310:

Line 1308: FROM igf_aw_fund_mast

1304: -------------------------------------------------------------------------------------
1305:
1306: CURSOR c_fund ( cv_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
1307: SELECT threshold_perct, threshold_value
1308: FROM igf_aw_fund_mast
1309: WHERE fund_id = cv_fund_id;
1310:
1311: fund_rec c_fund%ROWTYPE;
1312: l_fund_id igf_aw_fund_mast.fund_id%TYPE;

Line 1312: l_fund_id igf_aw_fund_mast.fund_id%TYPE;

1308: FROM igf_aw_fund_mast
1309: WHERE fund_id = cv_fund_id;
1310:
1311: fund_rec c_fund%ROWTYPE;
1312: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
1313: l_paid_amount NUMBER;
1314: l_perct NUMBER(5,2);
1315: l_accepted_amt igf_aw_awds_sum_v.accepted_amt%TYPE;
1316:

Line 1555: p_fund_id IN igf_aw_fund_mast.fund_id%TYPE,

1551: END payroll_adjust;
1552:
1553:
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

Line 1578: FROM igf_aw_fund_mast

1574: WHERE fa.person_id = p_person_id ;
1575:
1576: CURSOR c_fund IS
1577: SELECT fund_code,threshold_perct,threshold_value
1578: FROM igf_aw_fund_mast
1579: WHERE fund_id = p_fund_id;
1580:
1581: CURSOR c_earned_amount IS
1582: SELECT paid_amt