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_DB_DISB_HOLDS_PKG dependencies on IGF_DB_DISB_HOLDS

Line 1: PACKAGE BODY igf_db_disb_holds_pkg AS

1: PACKAGE BODY igf_db_disb_holds_pkg AS
2: /* $Header: IGFDI09B.pls 120.1 2006/08/10 15:42:17 museshad noship $ */
3:
4: /*=======================================================================+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|

Line 10: | PL/SQL body for package: IGF_DB_DISB_HOLDS_PKG

6: | All rights reserved. |
7: +=======================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL body for package: IGF_DB_DISB_HOLDS_PKG
11: | |
12: | NOTES |
13: | |
14: | This package has a flag on the end of some of the procedures called |

Line 57: old_references igf_db_disb_holds_all%ROWTYPE;

53: | from form or package |
54: *=======================================================================*/
55:
56: l_rowid VARCHAR2(25);
57: old_references igf_db_disb_holds_all%ROWTYPE;
58: new_references igf_db_disb_holds_all%ROWTYPE;
59:
60: PROCEDURE set_column_values (
61: p_action IN VARCHAR2,

Line 58: new_references igf_db_disb_holds_all%ROWTYPE;

54: *=======================================================================*/
55:
56: l_rowid VARCHAR2(25);
57: old_references igf_db_disb_holds_all%ROWTYPE;
58: new_references igf_db_disb_holds_all%ROWTYPE;
59:
60: PROCEDURE set_column_values (
61: p_action IN VARCHAR2,
62: x_rowid IN VARCHAR2,

Line 90: FROM igf_db_disb_holds_all

86: */
87:
88: CURSOR cur_old_ref_values IS
89: SELECT *
90: FROM igf_db_disb_holds_all
91: WHERE rowid = x_rowid;
92:
93: BEGIN
94:

Line 153: FROM igf_db_disb_holds

149: --Cursor to find if there is already a Hold existing of the same as the one being inserted
150: --and for which the release flg is N
151: CURSOR cur_get_hold IS
152: SELECT COUNT(HOLD_ID)
153: FROM igf_db_disb_holds
154: WHERE award_id = x_award_id
155: AND disb_num = x_disb_num
156: AND hold = x_hold
157: AND release_flag ='N'

Line 230: FROM igf_db_disb_holds_all

226: || (reverse chronological order - newest change first)
227: */
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igf_db_disb_holds_all
231: WHERE hold_id = x_hold_id
232: FOR UPDATE NOWAIT;
233:
234: lv_rowid cur_rowid%RowType;

Line 266: FROM igf_db_disb_holds_all

262: || (reverse chronological order - newest change first)
263: */
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igf_db_disb_holds_all
267: WHERE ((award_id = x_award_id) AND
268: (disb_num = x_disb_num));
269:
270: lv_rowid cur_rowid%RowType;

Line 408: FROM igf_db_disb_holds_all

404: || (reverse chronological order - newest change first)
405: */
406: CURSOR c IS
407: SELECT rowid
408: FROM igf_db_disb_holds_all
409: WHERE hold_id = x_hold_id;
410:
411: --Cursor to get the Disbursment to Update the Manual Hold Ind
412: CURSOR cur_get_manualHold IS

Line 448: SELECT igf_db_disb_holds_s.NEXTVAL

444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447:
448: SELECT igf_db_disb_holds_s.NEXTVAL
449: INTO x_hold_id
450: FROM dual;
451:
452: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 475: INSERT INTO igf_db_disb_holds_all (

471: x_last_updated_by => x_last_updated_by,
472: x_last_update_login => x_last_update_login
473: );
474:
475: INSERT INTO igf_db_disb_holds_all (
476: hold_id,
477: award_id,
478: disb_num,
479: hold,

Line 618: FROM igf_db_disb_holds_all

614: hold_type,
615: release_date,
616: release_flag,
617: release_reason
618: FROM igf_db_disb_holds_all
619: WHERE rowid = x_rowid
620: FOR UPDATE NOWAIT;
621:
622: tlinfo c1%ROWTYPE;

Line 684: l_hold_id igf_db_disb_holds.hold_id%TYPE;

680: */
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

Line 690: FROM igf_db_disb_holds

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
690: FROM igf_db_disb_holds
691: WHERE disb_num =x_disb_num
692: AND award_id = x_award_id
693: AND release_flag ='N';
694:

Line 744: UPDATE igf_db_disb_holds_all

740: x_last_updated_by => x_last_updated_by,
741: x_last_update_login => x_last_update_login
742: );
743:
744: UPDATE igf_db_disb_holds_all
745: SET
746: award_id = new_references.award_id,
747: disb_num = new_references.disb_num,
748: hold = new_references.hold,

Line 869: FROM igf_db_disb_holds_all

865: || (reverse chronological order - newest change first)
866: */
867: CURSOR c1 IS
868: SELECT rowid
869: FROM igf_db_disb_holds_all
870: WHERE hold_id = x_hold_id;
871:
872: BEGIN
873:

Line 932: DELETE FROM igf_db_disb_holds_all

928: p_action => 'DELETE',
929: x_rowid => x_rowid
930: );
931:
932: DELETE FROM igf_db_disb_holds_all
933: WHERE rowid = x_rowid;
934:
935: IF (SQL%NOTFOUND) THEN
936: RAISE NO_DATA_FOUND;

Line 942: END igf_db_disb_holds_pkg;

938:
939: END delete_row;
940:
941:
942: END igf_db_disb_holds_pkg;