APPS.IGF_SL_CL_PREF_LENDERS_PKG dependencies on IGF_SL_CL_PREF_LENDERS

Line 1: PACKAGE BODY igf_sl_cl_pref_lenders_pkg AS

1: PACKAGE BODY igf_sl_cl_pref_lenders_pkg AS
2: /* $Header: IGFLI34B.pls 120.0 2005/06/01 13:14:07 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: g_msg_count NUMBER;

Line 9: old_references igf_sl_cl_pref_lenders%ROWTYPE;

5: g_msg_count NUMBER;
6: g_msg_data VARCHAR2(2000);
7: g_return_status VARCHAR2(1);
8:
9: old_references igf_sl_cl_pref_lenders%ROWTYPE;
10: new_references igf_sl_cl_pref_lenders%ROWTYPE;
11:
12: PROCEDURE set_column_values (
13: p_action IN VARCHAR2,

Line 10: new_references igf_sl_cl_pref_lenders%ROWTYPE;

6: g_msg_data VARCHAR2(2000);
7: g_return_status VARCHAR2(1);
8:
9: old_references igf_sl_cl_pref_lenders%ROWTYPE;
10: new_references igf_sl_cl_pref_lenders%ROWTYPE;
11:
12: PROCEDURE set_column_values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2,

Line 39: FROM igf_sl_cl_pref_lenders

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

Line 135: FROM igf_sl_cl_pref_lenders

131: || (reverse chronological order - newest change first)
132: */
133: CURSOR cur_rowid IS
134: SELECT rowid
135: FROM igf_sl_cl_pref_lenders
136: WHERE clprl_id = x_clprl_id
137: FOR UPDATE NOWAIT;
138:
139: lv_rowid cur_rowid%RowType;

Line 171: FROM igf_sl_cl_pref_lenders

167: || (reverse chronological order - newest change first)
168: */
169: CURSOR cur_rowid IS
170: SELECT rowid
171: FROM igf_sl_cl_pref_lenders
172: WHERE ((relationship_cd = x_relationship_cd));
173:
174: lv_rowid cur_rowid%RowType;
175:

Line 355: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_PREF_LENDERS_PKG.INSERT_ROW');

351: x_program_update_date := SYSDATE;
352: END IF;
353: ELSE
354: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
355: fnd_message.set_token ('ROUTINE', 'IGF_SL_CL_PREF_LENDERS_PKG.INSERT_ROW');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:

Line 378: INSERT INTO igf_sl_cl_pref_lenders (

374: x_last_updated_by => x_last_updated_by,
375: x_last_update_login => x_last_update_login
376: );
377:
378: INSERT INTO igf_sl_cl_pref_lenders (
379: clprl_id,
380: person_id,
381: relationship_cd,
382: start_date,

Line 395: igf_sl_cl_pref_lenders_s.NEXTVAL,

391: program_id,
392: program_application_id,
393: program_update_date
394: ) VALUES (
395: igf_sl_cl_pref_lenders_s.NEXTVAL,
396: new_references.person_id,
397: new_references.relationship_cd,
398: new_references.start_date,
399: new_references.end_date,

Line 455: FROM igf_sl_cl_pref_lenders

451: relationship_cd,
452: start_date,
453: end_date,
454: object_version_number
455: FROM igf_sl_cl_pref_lenders
456: WHERE rowid = x_rowid
457: FOR UPDATE NOWAIT;
458:
459: tlinfo c1%ROWTYPE;

Line 542: fnd_message.set_token ('ROUTINE', 'igf_sl_cl_pref_lenders_PKG.UPDATE_ROW');

538: x_last_update_login := -1;
539: END IF;
540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: fnd_message.set_token ('ROUTINE', 'igf_sl_cl_pref_lenders_PKG.UPDATE_ROW');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:

Line 576: UPDATE igf_sl_cl_pref_lenders

572: x_program_update_date := SYSDATE;
573: END IF;
574: END IF;
575:
576: UPDATE igf_sl_cl_pref_lenders
577: SET
578: person_id = new_references.person_id,
579: relationship_cd = new_references.relationship_cd,
580: start_date = new_references.start_date,

Line 636: DELETE FROM igf_sl_cl_pref_lenders

632: p_action => 'DELETE',
633: x_rowid => x_rowid
634: );
635:
636: DELETE FROM igf_sl_cl_pref_lenders
637: WHERE rowid = x_rowid;
638:
639: IF (SQL%NOTFOUND) THEN
640: RAISE NO_DATA_FOUND;

Line 646: END igf_sl_cl_pref_lenders_pkg;

642:
643: END delete_row;
644:
645:
646: END igf_sl_cl_pref_lenders_pkg;