APPS.IGF_SL_LOR_LOC_PKG dependencies on IGF_SL_LOR_LOC_ALL

Line 5: old_references igf_sl_lor_loc_all%ROWTYPE;

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

Line 6: new_references igf_sl_lor_loc_all%ROWTYPE;

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

Line 225: FROM IGF_SL_LOR_LOC_ALL

221: */
222:
223: CURSOR cur_old_ref_values IS
224: SELECT *
225: FROM IGF_SL_LOR_LOC_ALL
226: WHERE rowid = x_rowid;
227:
228: BEGIN
229:

Line 541: FROM igf_sl_lor_loc_all

537: || (reverse chronological order - newest change first)
538: */
539: CURSOR cur_rowid IS
540: SELECT rowid
541: FROM igf_sl_lor_loc_all
542: WHERE loan_id = x_loan_id
543: FOR UPDATE NOWAIT;
544:
545: lv_rowid cur_rowid%RowType;

Line 576: FROM igf_sl_lor_loc_all

572: || (reverse chronological order - newest change first)
573: */
574: CURSOR cur_rowid IS
575: SELECT rowid
576: FROM igf_sl_lor_loc_all
577: WHERE origination_id = x_origination_id
578: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
579:
580: lv_rowid cur_rowid%RowType;

Line 611: FROM igf_sl_lor_loc_all

607: || (reverse chronological order - newest change first)
608: */
609: CURSOR cur_rowid IS
610: SELECT rowid
611: FROM igf_sl_lor_loc_all
612: WHERE ((origination_id = x_origination_id));
613:
614: lv_rowid cur_rowid%RowType;
615:

Line 637: FROM igf_sl_lor_loc_all

633: ) AS
634:
635: CURSOR cur_rowid IS
636: SELECT rowid
637: FROM igf_sl_lor_loc_all
638: WHERE ((award_id = x_award_id));
639:
640: lv_rowid cur_rowid%RowType;
641:

Line 663: FROM igf_sl_lor_loc_all

659: ) AS
660:
661: CURSOR cur_rowid IS
662: SELECT rowid
663: FROM igf_sl_lor_loc_all
664: WHERE ((base_id = x_base_id));
665:
666: lv_rowid cur_rowid%RowType;
667:

Line 1353: FROM igf_sl_lor_loc_all

1349: || (reverse chronological order - newest change first)
1350: */
1351: CURSOR c IS
1352: SELECT rowid
1353: FROM igf_sl_lor_loc_all
1354: WHERE loan_id = x_loan_id;
1355:
1356: x_last_update_date DATE;
1357: x_last_updated_by NUMBER;

Line 1363: l_org_id igf_sl_lor_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

1359: x_request_id NUMBER;
1360: x_program_id NUMBER;
1361: x_program_application_id NUMBER;
1362: x_program_update_date DATE;
1363: l_org_id igf_sl_lor_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
1364:
1365: BEGIN
1366:
1367: x_last_update_date := SYSDATE;

Line 1604: INSERT INTO igf_sl_lor_loc_all(

1600: x_borower_credit_authoriz_flag => x_borower_credit_authoriz_flag ,
1601: x_esign_src_typ_cd => x_esign_src_typ_cd
1602: );
1603:
1604: INSERT INTO igf_sl_lor_loc_all(
1605: loan_id,
1606: origination_id,
1607: loan_number,
1608: loan_type,

Line 2433: FROM igf_sl_lor_loc_all

2429: borower_electronic_sign_flag,
2430: borower_credit_authoriz_flag,
2431: esign_src_typ_cd
2432:
2433: FROM igf_sl_lor_loc_all
2434: WHERE rowid = x_rowid
2435: FOR UPDATE NOWAIT;
2436:
2437: tlinfo c1%ROWTYPE;

Line 3102: UPDATE igf_sl_lor_loc_all

3098: x_program_update_date := SYSDATE;
3099: END IF;
3100: END IF;
3101:
3102: UPDATE igf_sl_lor_loc_all
3103: SET
3104: origination_id = new_references.origination_id,
3105: loan_number = new_references.loan_number,
3106: loan_type = new_references.loan_type,

Line 3524: FROM igf_sl_lor_loc_all

3520: || (reverse chronological order - newest change first)
3521: */
3522: CURSOR c1 IS
3523: SELECT rowid
3524: FROM igf_sl_lor_loc_all
3525: WHERE loan_id = x_loan_id;
3526:
3527: BEGIN
3528:

Line 3961: DELETE FROM igf_sl_lor_loc_all

3957: p_action => 'DELETE',
3958: x_rowid => x_rowid
3959: );
3960:
3961: DELETE FROM igf_sl_lor_loc_all
3962: WHERE rowid = x_rowid;
3963:
3964: IF (SQL%NOTFOUND) THEN
3965: RAISE NO_DATA_FOUND;

Line 3985: l_org_id igf_sl_lor_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

3981: */
3982: l_rowid ROWID;
3983: l_source VARCHAR2(30);
3984: l_seq NUMBER;
3985: l_org_id igf_sl_lor_loc_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
3986:
3987: BEGIN
3988:
3989: IF p_action = 'INSERT' THEN