APPS.IGF_SL_LOR_PKG dependencies on IGF_SL_LOR_ALL

Line 5: old_references igf_sl_lor_all%ROWTYPE;

1: PACKAGE BODY igf_sl_lor_pkg AS
2: /* $Header: IGFLI10B.pls 120.2 2006/08/03 12:49:51 tsailaja noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lor_all%ROWTYPE;
6: new_references igf_sl_lor_all%ROWTYPE;
7: g_v_called_from VARCHAR2(30);
8:
9: PROCEDURE set_column_values (

Line 6: new_references igf_sl_lor_all%ROWTYPE;

2: /* $Header: IGFLI10B.pls 120.2 2006/08/03 12:49:51 tsailaja noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_lor_all%ROWTYPE;
6: new_references igf_sl_lor_all%ROWTYPE;
7: g_v_called_from VARCHAR2(30);
8:
9: PROCEDURE set_column_values (
10: p_action IN VARCHAR2,

Line 155: FROM IGF_SL_LOR_ALL

151: */
152:
153: CURSOR cur_old_ref_values IS
154: SELECT *
155: FROM IGF_SL_LOR_ALL
156: WHERE rowid = x_rowid;
157:
158: BEGIN
159:

Line 490: FROM igf_sl_lor_all

486: || (reverse chronological order - newest change first)
487: */
488: CURSOR cur_rowid IS
489: SELECT rowid
490: FROM igf_sl_lor_all
491: WHERE origination_id = x_origination_id
492: FOR UPDATE NOWAIT;
493:
494: lv_rowid cur_rowid%RowType;

Line 525: FROM igf_sl_lor_all

521: || (reverse chronological order - newest change first)
522: */
523: CURSOR cur_rowid IS
524: SELECT rowid
525: FROM igf_sl_lor_all
526: WHERE loan_id = x_loan_id
527: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
528:
529: lv_rowid cur_rowid%RowType;

Line 560: FROM igf_sl_lor_all

556: || (reverse chronological order - newest change first)
557: */
558: CURSOR cur_rowid IS
559: SELECT rowid
560: FROM igf_sl_lor_all
561: WHERE ((p_person_id = x_party_id));
562:
563: lv_rowid cur_rowid%RowType;
564:

Line 595: FROM igf_sl_lor_all

591: || (reverse chronological order - newest change first)
592: */
593: CURSOR cur_rowid IS
594: SELECT rowid
595: FROM igf_sl_lor_all
596: WHERE ((loan_id = x_loan_id));
597:
598: lv_rowid cur_rowid%RowType;
599:

Line 630: FROM igf_sl_lor_all

626: || (reverse chronological order - newest change first)
627: */
628: CURSOR cur_rowid IS
629: SELECT rowid
630: FROM igf_sl_lor_all
631: WHERE ((relationship_cd = x_relationship_cd));
632:
633: lv_rowid cur_rowid%RowType;
634:

Line 1162: FROM igf_sl_lor_all

1158: || viramali 12-MAY-01 added call to after_dml
1159: */
1160: CURSOR c IS
1161: SELECT rowid
1162: FROM igf_sl_lor_all
1163: WHERE origination_id = x_origination_id;
1164:
1165: x_last_update_date DATE;
1166: x_last_updated_by NUMBER;

Line 1172: l_org_id igf_sl_lor_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

1168: x_request_id NUMBER;
1169: x_program_id NUMBER;
1170: x_program_application_id NUMBER;
1171: x_program_update_date DATE;
1172: l_org_id igf_sl_lor_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
1173:
1174: BEGIN
1175:
1176: x_last_update_date := SYSDATE;

Line 1344: INSERT INTO igf_sl_lor_all(

1340: x_acad_end_date => x_acad_end_date
1341:
1342: );
1343:
1344: INSERT INTO igf_sl_lor_all(
1345: origination_id,
1346: loan_id,
1347: sch_cert_date,
1348: orig_status_flag,

Line 1845: FROM igf_sl_lor_all

1841: b_alien_reg_num_txt ,
1842: esign_src_typ_cd ,
1843: acad_begin_date ,
1844: acad_end_date
1845: FROM igf_sl_lor_all
1846: WHERE rowid = x_rowid
1847: FOR UPDATE NOWAIT;
1848:
1849: tlinfo c1%ROWTYPE;

Line 2302: UPDATE igf_sl_lor_all

2298: x_program_update_date := SYSDATE;
2299: END IF;
2300: END IF;
2301:
2302: UPDATE igf_sl_lor_all
2303: SET
2304: loan_id = new_references.loan_id,
2305: sch_cert_date = new_references.sch_cert_date,
2306: orig_status_flag = new_references.orig_status_flag,

Line 2570: FROM igf_sl_lor_all

2566: || (reverse chronological order - newest change first)
2567: */
2568: CURSOR c1 IS
2569: SELECT rowid
2570: FROM igf_sl_lor_all
2571: WHERE origination_id = x_origination_id;
2572:
2573: BEGIN
2574:

Line 2866: DELETE FROM igf_sl_lor_all

2862: p_action => 'DELETE',
2863: x_rowid => x_rowid
2864: );
2865:
2866: DELETE FROM igf_sl_lor_all
2867: WHERE rowid = x_rowid;
2868:
2869: IF (SQL%NOTFOUND) THEN
2870: RAISE NO_DATA_FOUND;