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_SL_CL_RECIPIENT_PKG dependencies on IGF_SL_CL_RECIPIENT

Line 1: PACKAGE BODY igf_sl_cl_recipient_pkg AS

1: PACKAGE BODY igf_sl_cl_recipient_pkg AS
2: /* $Header: IGFLI06B.pls 120.1 2006/04/19 08:12:43 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_recipient%ROWTYPE;

Line 5: old_references igf_sl_cl_recipient%ROWTYPE;

1: PACKAGE BODY igf_sl_cl_recipient_pkg AS
2: /* $Header: IGFLI06B.pls 120.1 2006/04/19 08:12:43 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_recipient%ROWTYPE;
6: new_references igf_sl_cl_recipient%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sl_cl_recipient%ROWTYPE;

2: /* $Header: IGFLI06B.pls 120.1 2006/04/19 08:12:43 bvisvana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_cl_recipient%ROWTYPE;
6: new_references igf_sl_cl_recipient%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 40: FROM IGF_SL_CL_RECIPIENT

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGF_SL_CL_RECIPIENT
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 134: || igf_aw_fund_cat_pkg.get_fk_igf_sl_cl_recipient

130: || Known limitations, enhancements or remarks :
131: || Change History :
132: || Who When What
133: || bkkumar 10-apr-04 FACR116 - Added the
134: || igf_aw_fund_cat_pkg.get_fk_igf_sl_cl_recipient
135: || (reverse chronological order - newest change first)
136: */
137: BEGIN
138:

Line 139: igf_sl_cl_setup_pkg.get_fk_igf_sl_cl_recipient (

135: || (reverse chronological order - newest change first)
136: */
137: BEGIN
138:
139: igf_sl_cl_setup_pkg.get_fk_igf_sl_cl_recipient (
140: old_references.relationship_cd
141: );
142:
143: igf_sl_cl_pref_lenders_pkg.get_fk_igf_sl_cl_recipient (

Line 143: igf_sl_cl_pref_lenders_pkg.get_fk_igf_sl_cl_recipient (

139: igf_sl_cl_setup_pkg.get_fk_igf_sl_cl_recipient (
140: old_references.relationship_cd
141: );
142:
143: igf_sl_cl_pref_lenders_pkg.get_fk_igf_sl_cl_recipient (
144: old_references.relationship_cd
145: );
146:
147: igf_sl_lor_pkg.get_fk_igf_sl_cl_recipient (

Line 147: igf_sl_lor_pkg.get_fk_igf_sl_cl_recipient (

143: igf_sl_cl_pref_lenders_pkg.get_fk_igf_sl_cl_recipient (
144: old_references.relationship_cd
145: );
146:
147: igf_sl_lor_pkg.get_fk_igf_sl_cl_recipient (
148: old_references.relationship_cd
149: );
150:
151: igf_aw_fund_cat_pkg.get_fk_igf_sl_cl_recipient (

Line 151: igf_aw_fund_cat_pkg.get_fk_igf_sl_cl_recipient (

147: igf_sl_lor_pkg.get_fk_igf_sl_cl_recipient (
148: old_references.relationship_cd
149: );
150:
151: igf_aw_fund_cat_pkg.get_fk_igf_sl_cl_recipient (
152: old_references.relationship_cd
153: );
154:
155: END check_child_existance;

Line 222: FROM igf_sl_cl_recipient

218: || (reverse chronological order - newest change first)
219: */
220: CURSOR cur_rowid IS
221: SELECT rowid
222: FROM igf_sl_cl_recipient
223: WHERE rcpt_id = x_rcpt_id
224: FOR UPDATE NOWAIT;
225:
226: lv_rowid cur_rowid%RowType;

Line 263: FROM igf_sl_cl_recipient

259: || (reverse chronological order - newest change first)
260: */
261: CURSOR cur_rowid IS
262: SELECT rowid
263: FROM igf_sl_cl_recipient
264: WHERE lender_id = x_lender_id
265: AND ((lend_non_ed_brc_id = x_lend_non_ed_brc_id) OR (lend_non_ed_brc_id IS NULL AND x_lend_non_ed_brc_id IS NULL))
266: AND guarantor_id = x_guarantor_id
267: AND recipient_id = x_recipient_id

Line 302: FROM igf_sl_cl_recipient

298: || (reverse chronological order - newest change first)
299: */
300: CURSOR cur_rowid IS
301: SELECT rowid
302: FROM igf_sl_cl_recipient
303: WHERE ((relationship_cd = x_relationship_cd))
304: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
305:
306: lv_rowid cur_rowid%RowType;

Line 337: FROM igf_sl_cl_recipient

333: || (reverse chronological order - newest change first)
334: */
335: CURSOR cur_rowid IS
336: SELECT rowid
337: FROM igf_sl_cl_recipient
338: WHERE ((lender_id = x_lender_id));
339:
340: lv_rowid cur_rowid%RowType;
341:

Line 373: FROM igf_sl_cl_recipient

369: || (reverse chronological order - newest change first)
370: */
371: CURSOR cur_rowid IS
372: SELECT rowid
373: FROM igf_sl_cl_recipient
374: WHERE ((lender_id = x_lender_id) AND
375: (lend_non_ed_brc_id = x_lend_non_ed_brc_id));
376:
377: lv_rowid cur_rowid%RowType;

Line 409: FROM igf_sl_cl_recipient

405: || (reverse chronological order - newest change first)
406: */
407: CURSOR cur_rowid IS
408: SELECT rowid
409: FROM igf_sl_cl_recipient
410: WHERE ((guarantor_id = x_guarantor_id));
411:
412: lv_rowid cur_rowid%RowType;
413:

Line 548: FROM igf_sl_cl_recipient

544: || (reverse chronological order - newest change first)
545: */
546: CURSOR c IS
547: SELECT rowid
548: FROM igf_sl_cl_recipient
549: WHERE rcpt_id = x_rcpt_id;
550:
551: x_last_update_date DATE;
552: x_last_updated_by NUMBER;

Line 577: SELECT igf_sl_cl_recipient_s.nextval

573: app_exception.raise_exception;
574: END IF;
575:
576:
577: SELECT igf_sl_cl_recipient_s.nextval
578: INTO x_rcpt_id
579: FROM dual;
580:
581:

Line 603: INSERT INTO igf_sl_cl_recipient (

599: x_relationship_cd_desc => x_relationship_cd_desc,
600: x_preferred_flag => x_preferred_flag
601: );
602:
603: INSERT INTO igf_sl_cl_recipient (
604: rcpt_id,
605: lender_id,
606: lend_non_ed_brc_id,
607: guarantor_id,

Line 685: FROM igf_sl_cl_recipient

681: enabled,
682: relationship_cd,
683: relationship_cd_desc,
684: preferred_flag
685: FROM igf_sl_cl_recipient
686: WHERE rowid = x_rowid
687: FOR UPDATE NOWAIT;
688:
689: tlinfo c1%ROWTYPE;

Line 798: UPDATE igf_sl_cl_recipient

794: x_relationship_cd_desc => x_relationship_cd_desc,
795: x_preferred_flag => x_preferred_flag
796: );
797:
798: UPDATE igf_sl_cl_recipient
799: SET
800: lender_id = new_references.lender_id,
801: lend_non_ed_brc_id = new_references.lend_non_ed_brc_id,
802: guarantor_id = new_references.guarantor_id,

Line 848: FROM igf_sl_cl_recipient

844: || (reverse chronological order - newest change first)
845: */
846: CURSOR c1 IS
847: SELECT rowid
848: FROM igf_sl_cl_recipient
849: WHERE rcpt_id = x_rcpt_id;
850:
851: BEGIN
852:

Line 915: DELETE FROM igf_sl_cl_recipient

911: p_action => 'DELETE',
912: x_rowid => x_rowid
913: );
914:
915: DELETE FROM igf_sl_cl_recipient
916: WHERE rowid = x_rowid;
917:
918: IF (SQL%NOTFOUND) THEN
919: RAISE NO_DATA_FOUND;

Line 925: END igf_sl_cl_recipient_pkg;

921:
922: END delete_row;
923:
924:
925: END igf_sl_cl_recipient_pkg;