APPS.IGF_SL_LENDER_BRC_PKG dependencies on IGF_SL_LENDER_BRC

Line 1: PACKAGE BODY igf_sl_lender_brc_pkg AS

1: PACKAGE BODY igf_sl_lender_brc_pkg AS
2: /* $Header: IGFLI02B.pls 115.6 2003/09/10 05:07:51 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lender_brc%ROWTYPE;

Line 5: old_references igf_sl_lender_brc%ROWTYPE;

1: PACKAGE BODY igf_sl_lender_brc_pkg AS
2: /* $Header: IGFLI02B.pls 115.6 2003/09/10 05:07:51 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lender_brc%ROWTYPE;
6: new_references igf_sl_lender_brc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_lender_brc%ROWTYPE;

2: /* $Header: IGFLI02B.pls 115.6 2003/09/10 05:07:51 veramach ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lender_brc%ROWTYPE;
6: new_references igf_sl_lender_brc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGF_SL_LENDER_BRC

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGF_SL_LENDER_BRC
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 114: igf_sl_cl_recipient_pkg.get_fk_igf_sl_lender_brc (

110: || (reverse chronological order - newest change first)
111: */
112: BEGIN
113:
114: igf_sl_cl_recipient_pkg.get_fk_igf_sl_lender_brc (
115: old_references.lender_id,
116: old_references.lend_non_ed_brc_id
117: );
118:

Line 163: FROM igf_sl_lender_brc

159: || (reverse chronological order - newest change first)
160: */
161: CURSOR cur_rowid IS
162: SELECT rowid
163: FROM igf_sl_lender_brc
164: WHERE lender_id = x_lender_id
165: AND lend_non_ed_brc_id = x_lend_non_ed_brc_id
166: FOR UPDATE NOWAIT;
167:

Line 199: FROM igf_sl_lender_brc

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igf_sl_lender_brc
200: WHERE ((lender_id = x_lender_id));
201:
202: lv_rowid cur_rowid%RowType;
203:

Line 234: FROM igf_sl_lender_brc

230: */
231:
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM igf_sl_lender_brc
235: WHERE party_id = x_party_id
236: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
237:
238: lv_rowid cur_rowid%RowType;

Line 353: FROM igf_sl_lender_brc

349: || (reverse chronological order - newest change first)
350: */
351: CURSOR c IS
352: SELECT rowid
353: FROM igf_sl_lender_brc
354: WHERE lender_id = x_lender_id
355: AND lend_non_ed_brc_id = x_lend_non_ed_brc_id;
356:
357: x_last_update_date DATE;

Line 397: INSERT INTO igf_sl_lender_brc (

393: x_last_updated_by => x_last_updated_by,
394: x_last_update_login => x_last_update_login
395: );
396:
397: INSERT INTO igf_sl_lender_brc (
398: lender_id,
399: lend_non_ed_brc_id,
400: description,
401: party_id,

Line 454: FROM igf_sl_lender_brc

450: SELECT
451: description,
452: party_id,
453: enabled
454: FROM igf_sl_lender_brc
455: WHERE rowid = x_rowid
456: FOR UPDATE NOWAIT;
457:
458: tlinfo c1%ROWTYPE;

Line 548: UPDATE igf_sl_lender_brc

544: x_last_updated_by => x_last_updated_by,
545: x_last_update_login => x_last_update_login
546: );
547:
548: UPDATE igf_sl_lender_brc
549: SET
550: description = new_references.description,
551: party_id = new_references.party_id,
552: enabled = new_references.enabled,

Line 585: FROM igf_sl_lender_brc

581: || (reverse chronological order - newest change first)
582: */
583: CURSOR c1 IS
584: SELECT rowid
585: FROM igf_sl_lender_brc
586: WHERE lender_id = x_lender_id
587: AND lend_non_ed_brc_id = x_lend_non_ed_brc_id;
588:
589: BEGIN

Line 641: DELETE FROM igf_sl_lender_brc

637: p_action => 'DELETE',
638: x_rowid => x_rowid
639: );
640:
641: DELETE FROM igf_sl_lender_brc
642: WHERE rowid = x_rowid;
643:
644: IF (SQL%NOTFOUND) THEN
645: RAISE NO_DATA_FOUND;

Line 651: END igf_sl_lender_brc_pkg;

647:
648: END delete_row;
649:
650:
651: END igf_sl_lender_brc_pkg;