APPS.IGF_DB_DISB_HOLDS_PKG dependencies on IGF_AW_AWD_DISB

Line 32: | igf_aw_awd_disb_pkg |

28: | HISTORY |
29: | museshad 10-Aug-2006 5337555. Build FA 163.TBH Impact changes|
30: | veramach July 2004 FA 151 HR integration (bug # 3709292) |
31: | Impact of obsoleting columns from |
32: | igf_aw_awd_disb_pkg |
33: | Bug No :- 2154941 |
34: | Desc :- Disbursement and Sponsership Build for Jul 2002 FACCR004 |
35: | WHO WHEN WHAT
36:

Line 204: ELSIF NOT igf_aw_awd_disb_pkg.get_pk_for_validation (

200: (old_references.disb_num = new_references.disb_num)) OR
201: ((new_references.award_id IS NULL) OR
202: (new_references.disb_num IS NULL))) THEN
203: NULL;
204: ELSIF NOT igf_aw_awd_disb_pkg.get_pk_for_validation (
205: new_references.award_id,
206: new_references.disb_num
207: ) THEN
208: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 251: PROCEDURE get_fk_igf_aw_awd_disb (

247:
248: END get_pk_for_validation;
249:
250:
251: PROCEDURE get_fk_igf_aw_awd_disb (
252: x_award_id IN NUMBER,
253: x_disb_num IN NUMBER
254: ) AS
255: /*

Line 285: END get_fk_igf_aw_awd_disb;

281: RETURN;
282: END IF;
283: CLOSE cur_rowid;
284:
285: END get_fk_igf_aw_awd_disb;
286:
287:
288: PROCEDURE before_dml (
289: p_action IN VARCHAR2,

Line 414: FROM igf_aw_awd_disb

410:
411: --Cursor to get the Disbursment to Update the Manual Hold Ind
412: CURSOR cur_get_manualHold IS
413: SELECT *
414: FROM igf_aw_awd_disb
415: WHERE award_id =x_award_id
416: AND disb_num =x_disb_num
417: FOR UPDATE OF manual_hold_ind NOWAIT;
418:

Line 424: l_disb_rec igf_aw_awd_disb%ROWTYPE;

420:
421: x_last_update_date DATE;
422: x_last_updated_by NUMBER;
423: x_last_update_login NUMBER;
424: l_disb_rec igf_aw_awd_disb%ROWTYPE;
425:
426: BEGIN
427:
428:

Line 533: igf_aw_awd_disb_pkg.update_row(

529: l_disb_rec.elig_status_date := TRUNC(SYSDATE);
530: END IF;
531:
532: --Call the Update row the Award Disbursement Table
533: igf_aw_awd_disb_pkg.update_row(
534: x_rowid => l_disb_rec.row_id,
535: x_award_id => l_disb_rec.award_id,
536: x_disb_num => l_disb_rec.disb_num,
537: x_tp_cal_type => l_disb_rec.tp_cal_type,

Line 685: l_disb_rec igf_aw_awd_disb%ROWTYPE;

681: x_last_update_date DATE ;
682: x_last_updated_by NUMBER;
683: x_last_update_login NUMBER;
684: l_hold_id igf_db_disb_holds.hold_id%TYPE;
685: l_disb_rec igf_aw_awd_disb%ROWTYPE;
686:
687: --Cursor to check if all the Holds has been released for the disbursement
688: CURSOR cur_get_Holds IS
689: SELECT hold_id

Line 698: SELECT * FROM igf_aw_awd_disb

694:
695:
696: --Cursor to fetch the Disbursement
697: CURSOR cur_get_disb IS
698: SELECT * FROM igf_aw_awd_disb
699: WHERE award_id=x_award_id
700: AND disb_num =x_disb_num
701: FOR UPDATE OF disb_num NOWAIT;
702:

Line 786: igf_aw_awd_disb_pkg.update_row(

782: FETCH cur_get_disb INTO l_disb_rec;
783: CLOSE cur_get_disb;
784:
785: --Call the Update row the Award Disbursement Table
786: igf_aw_awd_disb_pkg.update_row(
787: x_rowid => l_disb_rec.row_id,
788: x_award_id => l_disb_rec.award_id,
789: x_disb_num => l_disb_rec.disb_num,
790: x_tp_cal_type => l_disb_rec.tp_cal_type,