APPS.IGF_SL_LENDER_PKG dependencies on IGF_SL_LENDER

Line 1: PACKAGE BODY igf_sl_lender_pkg AS

1: PACKAGE BODY igf_sl_lender_pkg AS
2: /* $Header: IGFLI01B.pls 115.11 2003/10/14 06:45:36 sjadhav ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lender%ROWTYPE;

Line 5: old_references igf_sl_lender%ROWTYPE;

1: PACKAGE BODY igf_sl_lender_pkg AS
2: /* $Header: IGFLI01B.pls 115.11 2003/10/14 06:45:36 sjadhav ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lender%ROWTYPE;
6: new_references igf_sl_lender%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_lender%ROWTYPE;

2: /* $Header: IGFLI01B.pls 115.11 2003/10/14 06:45:36 sjadhav ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lender%ROWTYPE;
6: new_references igf_sl_lender%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

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

Line 87: igf_sl_cl_recipient_pkg.get_fk_igf_sl_lender (

83: || (reverse chronological order - newest change first)
84: */
85: BEGIN
86:
87: igf_sl_cl_recipient_pkg.get_fk_igf_sl_lender (
88: old_references.lender_id
89: );
90:
91: igf_sl_lender_brc_pkg.get_fk_igf_sl_lender (

Line 91: igf_sl_lender_brc_pkg.get_fk_igf_sl_lender (

87: igf_sl_cl_recipient_pkg.get_fk_igf_sl_lender (
88: old_references.lender_id
89: );
90:
91: igf_sl_lender_brc_pkg.get_fk_igf_sl_lender (
92: old_references.lender_id
93: );
94:
95: END check_child_existance;

Line 138: FROM igf_sl_lender

134: || (reverse chronological order - newest change first)
135: */
136: CURSOR cur_rowid IS
137: SELECT rowid
138: FROM igf_sl_lender
139: WHERE lender_id = x_lender_id
140: FOR UPDATE NOWAIT;
141:
142: lv_rowid cur_rowid%RowType;

Line 173: FROM igf_sl_lender

169: */
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igf_sl_lender
174: WHERE party_id = x_party_id
175: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
176:
177: lv_rowid cur_rowid%RowType;

Line 293: FROM igf_sl_lender

289: || (reverse chronological order - newest change first)
290: */
291: CURSOR c IS
292: SELECT rowid
293: FROM igf_sl_lender
294: WHERE lender_id = x_lender_id;
295:
296: x_last_update_date DATE;
297: x_last_updated_by NUMBER;

Line 336: INSERT INTO igf_sl_lender (

332: x_last_updated_by => x_last_updated_by,
333: x_last_update_login => x_last_update_login
334: );
335:
336: INSERT INTO igf_sl_lender (
337: lender_id,
338: description,
339: party_id,
340: enabled,

Line 391: FROM igf_sl_lender

387: SELECT
388: description,
389: party_id,
390: enabled
391: FROM igf_sl_lender
392: WHERE rowid = x_rowid
393: FOR UPDATE NOWAIT;
394:
395: tlinfo c1%ROWTYPE;

Line 485: UPDATE igf_sl_lender

481: x_last_updated_by => x_last_updated_by,
482: x_last_update_login => x_last_update_login
483: );
484:
485: UPDATE igf_sl_lender
486: SET
487: description = new_references.description,
488: party_id = new_references.party_id,
489: enabled = new_references.enabled,

Line 522: FROM igf_sl_lender

518: || (reverse chronological order - newest change first)
519: */
520: CURSOR c1 IS
521: SELECT rowid
522: FROM igf_sl_lender
523: WHERE lender_id = x_lender_id;
524:
525: BEGIN
526:

Line 577: DELETE FROM igf_sl_lender

573: p_action => 'DELETE',
574: x_rowid => x_rowid
575: );
576:
577: DELETE FROM igf_sl_lender
578: WHERE rowid = x_rowid;
579:
580: IF (SQL%NOTFOUND) THEN
581: RAISE NO_DATA_FOUND;

Line 587: END igf_sl_lender_pkg;

583:
584: END delete_row;
585:
586:
587: END igf_sl_lender_pkg;