APPS.IGF_DB_DISB_HOLDS_PKG dependencies on IGF_DB_DISB_HOLDS_ALL

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 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 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 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;