[Home] [Help]
26: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
27: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and igf_db_awd_disb_dtl_pkg
28: --veramach July 2004 FA 151 HR Integration(bug #3709292)
29: -- Impact of obsoleting columns from fund manager
30: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
31: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE
32: -- TBH impact of the igf_aw_award Added columns LOCK_AWARD_FLAG,
33: -- APP_TRANS_NUM_TXT
34: --vvutukur 20-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure create_award_disb.
345: RETURN TRUE;
346: END check_eligibility;
347:
348: PROCEDURE create_disb_dtl(p_award_id igf_aw_award_all.award_id%TYPE,
349: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
350: AS
351: -------------------------------------------------------------------------------------
352: --Created by : smanglm ( Oracle IDC)
353: --Date created: 2002/01/11
365: --vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Assigned value 'D' to disb_dtl_rec.disb_activity, instead of NULL.
366: -------------------------------------------------------------------------------------
367:
368: CURSOR cur_chk_adj( cp_award_id igf_aw_award_all.award_id%TYPE,
369: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
370: IS
371: SELECT NVL(disb_seq_num,0) disb_seq_num
372: FROM igf_db_awd_disb_dtl
373: WHERE award_id = cp_award_id AND
374: disb_num = cp_disb_num;
375: chk_adj_rec cur_chk_adj%ROWTYPE;
376:
377: CURSOR cur_get_adisb( cp_award_id igf_aw_award_all.award_id%TYPE,
378: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
379: IS
380: SELECT *
381: FROM igf_aw_awd_disb
382: WHERE award_id = cp_award_id AND