APPS.IGF_AW_LI_IMPORT dependencies on IGF_AW_LI_AWD_INTS

Line 108: p_batch_num igf_aw_li_awd_ints.batch_num%TYPE) IS

104:
105: -- cursor to fetch records from the award legacy interface tables
106:
107: CURSOR cur_legacy_award_int(p_alternate_code igs_ca_inst.alternate_code%TYPE,
108: p_batch_num igf_aw_li_awd_ints.batch_num%TYPE) IS
109: SELECT
110: awdint.batch_num,
111: trim(awdint.ci_alternate_code) ci_alternate_code,
112: trim(awdint.fund_code) fund_code,

Line 135: FROM igf_aw_li_awd_ints awdint

131: awdint.lock_award_flag, --new col for FA131 COD updates build
132: awdint.app_trans_num_txt, --new col for FA131 COD updates build
133: awdint.authorization_date,
134: awdint.publish_in_ss_flag
135: FROM igf_aw_li_awd_ints awdint
136: WHERE awdint.batch_num = p_batch_num
137: AND awdint.ci_alternate_code = p_alternate_code
138: AND awdint.import_status_type IN ('U','R')
139: ORDER BY awdint.person_number, awdint.fund_code, awdint.award_number_txt;

Line 412: PROCEDURE validate_awdyear_int_rec(li_awd_rec IN OUT NOCOPY igf_aw_li_awd_ints%ROWTYPE, l_return_value OUT NOCOPY VARCHAR2) IS

408: END lock_std_coa;
409:
410:
411:
412: PROCEDURE validate_awdyear_int_rec(li_awd_rec IN OUT NOCOPY igf_aw_li_awd_ints%ROWTYPE, l_return_value OUT NOCOPY VARCHAR2) IS
413:
414: /***************************************************************
415: Created By : nsidana
416: Date Created By : 11/28/2003

Line 436: CURSOR cur_get_fund_code(p_fund_code igf_aw_li_awd_ints.fund_code%TYPE) IS

432: AND award_number_txt = li_awd_rec.award_number_txt;
433: l_award_id igf_aw_award_all.award_id%TYPE;
434: l_legacy_record_flag igf_aw_award_all.legacy_record_flag%TYPE;
435:
436: CURSOR cur_get_fund_code(p_fund_code igf_aw_li_awd_ints.fund_code%TYPE) IS
437: SELECT fmast.fund_code, fcat.fed_fund_code, fmast.fund_id
438: FROM igf_aw_fund_mast_all fmast,
439: igf_aw_fund_cat fcat
440: WHERE fmast.fund_code = fcat.fund_code

Line 488: PROCEDURE validate_open_award_year (li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,

484: AND pid.s_person_id_type = 'SSN'
485: AND SYSDATE BETWEEN api.start_Dt AND NVL(api.end_dt,SYSDATE);
486: c_get_person_ssn_rec c_get_person_ssn%ROWTYPE;
487:
488: PROCEDURE validate_open_award_year (li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,
489: l_status_open_awd_yr OUT NOCOPY VARCHAR2) IS
490: /***************************************************************
491: Created By : nsidana
492: Date Created By : 11/28/2003

Line 869: PROCEDURE create_award_record(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE, l_awd_ins_status OUT NOCOPY VARCHAR2) IS

865: );
866: END LOOP;
867: END maintain_old_award_hist_rec;
868:
869: PROCEDURE create_award_record(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE, l_awd_ins_status OUT NOCOPY VARCHAR2) IS
870: /***************************************************************
871: Created By : nsidana
872: Date Created By : 11/28/2003
873: Purpose : Created awards in the system.

Line 1628: PROCEDURE validate_disburs_int_rec(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,

1624: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1625: END validate_awdyear_int_rec;
1626:
1627:
1628: PROCEDURE validate_disburs_int_rec(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,
1629: p_return_status OUT NOCOPY VARCHAR2
1630: ) IS
1631:
1632: /***************************************************************

Line 1789: PROCEDURE create_disbursment_record(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,

1785: l_net_amount igf_aw_awd_disb_all.disb_net_amt%TYPE;
1786:
1787: l_padding_string VARCHAR2(100);
1788:
1789: PROCEDURE create_disbursment_record(li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,
1790: cur_legacy_disb_int_rec IN igf_aw_li_disb_ints%ROWTYPE,
1791: l_disb_rec_ins_status OUT NOCOPY VARCHAR2
1792: ) IS
1793: /***************************************************************

Line 2493: PROCEDURE validate_disb_act_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,

2489: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_DISBURS_INT_REC : '||SQLERRM);
2490: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
2491: END validate_disburs_int_rec;
2492:
2493: PROCEDURE validate_disb_act_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,
2494: li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,
2495: p_return_status OUT NOCOPY VARCHAR2
2496: ) IS
2497: /***************************************************************

Line 3126: PROCEDURE validate_disb_hold_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,

3122: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_DISB_ACT_INT_REC : '||SQLERRM);
3123: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3124: END validate_disb_act_int_rec;
3125:
3126: PROCEDURE validate_disb_hold_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,
3127: li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,
3128: p_return_status OUT NOCOPY VARCHAR2
3129: ) IS
3130: /***************************************************************

Line 3282: ctx_li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,

3278: l_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
3279: l_return_status_awd VARCHAR2(1);
3280:
3281: PROCEDURE del_or_upd_int_records(p_operation IN VARCHAR2,
3282: ctx_li_awd_rec IN igf_aw_li_awd_ints%ROWTYPE,
3283: p_status IN VARCHAR2) IS
3284: BEGIN
3285:
3286: IF(p_operation = 'U')THEN

Line 3287: UPDATE igf_aw_li_awd_ints

3283: p_status IN VARCHAR2) IS
3284: BEGIN
3285:
3286: IF(p_operation = 'U')THEN
3287: UPDATE igf_aw_li_awd_ints
3288: SET import_status_type = p_status,
3289: last_updated_by = fnd_global.user_id,
3290: last_update_date = SYSDATE,
3291: last_update_login = fnd_global.login_id,

Line 3316: DELETE FROM igf_aw_li_awd_ints

3312: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3313: AND person_number = ctx_li_awd_rec.person_number
3314: AND award_number_txt = ctx_li_awd_rec.award_number_txt;
3315:
3316: DELETE FROM igf_aw_li_awd_ints
3317: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3318: AND person_number = ctx_li_awd_rec.person_number
3319: AND award_number_txt = ctx_li_awd_rec.award_number_txt
3320: AND import_status_type = ctx_li_awd_rec.import_status_type;