APPS.IGF_SL_LOANS_PKG dependencies on IGF_SL_LOANS_ALL

Line 5: old_references igf_sl_loans_all%ROWTYPE;

1: PACKAGE BODY igf_sl_loans_pkg AS
2: /* $Header: IGFLI09B.pls 120.3 2006/08/03 12:36:04 tsailaja noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_loans_all%ROWTYPE;
6: new_references igf_sl_loans_all%ROWTYPE;
7: g_v_called_from VARCHAR2(30);
8:
9: PROCEDURE set_column_values (

Line 6: new_references igf_sl_loans_all%ROWTYPE;

2: /* $Header: IGFLI09B.pls 120.3 2006/08/03 12:36:04 tsailaja noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sl_loans_all%ROWTYPE;
6: new_references igf_sl_loans_all%ROWTYPE;
7: g_v_called_from VARCHAR2(30);
8:
9: PROCEDURE set_column_values (
10: p_action IN VARCHAR2 ,

Line 50: FROM IGF_SL_LOANS_ALL

46: */
47:
48: CURSOR cur_old_ref_values IS
49: SELECT *
50: FROM IGF_SL_LOANS_ALL
51: WHERE rowid = x_rowid;
52:
53: BEGIN
54:

Line 213: FROM igf_sl_loans_all

209: || for the Borrower Determination
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igf_sl_loans_all
214: WHERE loan_id = x_loan_id
215: FOR UPDATE NOWAIT;
216:
217: lv_rowid cur_rowid%ROWTYPE;

Line 249: FROM igf_sl_loans_all

245: || for the Borrower Determination
246: */
247: CURSOR cur_rowid IS
248: SELECT rowid
249: FROM igf_sl_loans_all
250: WHERE loan_number = x_loan_number
251: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
252:
253: lv_rowid cur_rowid%ROWTYPE;

Line 286: FROM igf_sl_loans_all

282: || for the Borrower Determination
283: */
284: CURSOR cur_rowid IS
285: SELECT rowid
286: FROM igf_sl_loans_all
287: WHERE award_id = x_award_id
288: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
289:
290: lv_rowid cur_rowid%ROWTYPE;

Line 321: FROM igf_sl_loans_all

317: || for the Borrower Determination
318: */
319: CURSOR cur_rowid IS
320: SELECT rowid
321: FROM igf_sl_loans_all
322: WHERE ((award_id = x_award_id));
323:
324: lv_rowid cur_rowid%ROWTYPE;
325:

Line 666: FROM igf_sl_loans_all

662: || for the Borrower Determination
663: */
664: CURSOR c IS
665: SELECT rowid
666: FROM igf_sl_loans_all
667: WHERE loan_id = x_loan_id;
668:
669: x_last_update_date DATE;
670: x_last_updated_by NUMBER;

Line 676: l_org_id igf_sl_loans_all.org_id%TYPE := igf_aw_gen.get_org_id;

672: x_request_id NUMBER;
673: x_program_id NUMBER;
674: x_program_application_id NUMBER;
675: x_program_update_date DATE;
676: l_org_id igf_sl_loans_all.org_id%TYPE := igf_aw_gen.get_org_id;
677:
678: BEGIN
679:
680: x_last_update_date := SYSDATE;

Line 738: INSERT INTO igf_sl_loans_all(

734: x_last_update_login => x_last_update_login ,
735: x_external_loan_id_txt => x_external_loan_id_txt
736: );
737:
738: INSERT INTO igf_sl_loans_all(
739: loan_id,
740: award_id,
741: seq_num,
742: loan_number,

Line 850: FROM igf_sl_loans_all

846: borw_detrm_code,
847: legacy_record_flag,
848: org_id,
849: external_loan_id_txt
850: FROM igf_sl_loans_all
851: WHERE rowid = x_rowid
852: FOR UPDATE NOWAIT;
853:
854: tlinfo c1%ROWTYPE;

Line 999: UPDATE igf_sl_loans_all

995: x_program_update_date := SYSDATE;
996: END IF;
997: END IF;
998:
999: UPDATE igf_sl_loans_all
1000: SET
1001: award_id = new_references.award_id,
1002: seq_num = new_references.seq_num,
1003: loan_number = new_references.loan_number,

Line 1069: FROM igf_sl_loans_all

1065: || for the Borrower Determination
1066: */
1067: CURSOR c1 IS
1068: SELECT rowid
1069: FROM igf_sl_loans_all
1070: WHERE loan_id = x_loan_id;
1071:
1072: BEGIN
1073:

Line 1141: DELETE FROM igf_sl_loans_all

1137: BEGIN
1138:
1139: before_dml ( p_action => 'DELETE', x_rowid => x_rowid );
1140:
1141: DELETE FROM igf_sl_loans_all
1142: WHERE rowid = x_rowid;
1143:
1144: IF (SQL%NOTFOUND) THEN
1145: RAISE NO_DATA_FOUND;