APPS.IGF_AP_NSLDS_DATA_PKG dependencies on IGF_AP_NSLDS_DATA_ALL

Line 5: old_references igf_ap_nslds_data_all%ROWTYPE;

1: PACKAGE BODY IGF_AP_NSLDS_DATA_PKG AS
2: /* $Header: IGFAI10B.pls 120.0 2005/06/02 15:55:35 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_nslds_data_all%ROWTYPE;
6: new_references igf_ap_nslds_data_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_nslds_data_all%ROWTYPE;

2: /* $Header: IGFAI10B.pls 120.0 2005/06/02 15:55:35 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_nslds_data_all%ROWTYPE;
6: new_references igf_ap_nslds_data_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 226: FROM IGF_AP_NSLDS_DATA_ALL

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

Line 500: FROM igf_ap_nslds_data_all

496: || (reverse chronological order - newest change first)
497: */
498: CURSOR cur_rowid IS
499: SELECT rowid
500: FROM igf_ap_nslds_data_all
501: WHERE nslds_id = x_nslds_id
502: FOR UPDATE NOWAIT;
503:
504: lv_rowid cur_rowid%RowType;

Line 535: FROM igf_ap_nslds_data_all

531: || (reverse chronological order - newest change first)
532: */
533: CURSOR cur_rowid IS
534: SELECT rowid
535: FROM igf_ap_nslds_data_all
536: WHERE ((isir_id = x_isir_id));
537:
538: lv_rowid cur_rowid%RowType;
539:

Line 1222: FROM igf_ap_nslds_data_all

1218: || (reverse chronological order - newest change first)
1219: */
1220: CURSOR c IS
1221: SELECT rowid
1222: FROM igf_ap_nslds_data_all
1223: WHERE nslds_id = x_nslds_id;
1224:
1225: x_last_update_date DATE;
1226: x_last_updated_by NUMBER;

Line 1232: l_org_id igf_ap_nslds_data_all.org_id%TYPE := igf_aw_gen.get_org_id;

1228: x_request_id NUMBER;
1229: x_program_id NUMBER;
1230: x_program_application_id NUMBER;
1231: x_program_update_date DATE;
1232: l_org_id igf_ap_nslds_data_all.org_id%TYPE := igf_aw_gen.get_org_id;
1233:
1234: BEGIN
1235:
1236: SELECT igf_ap_nslds_data_s.nextval INTO x_nslds_id

Line 1478: INSERT INTO igf_ap_nslds_data_all (

1474: x_combined_loan_limit_type => x_combined_loan_limit_type,
1475: x_transaction_num_txt => x_transaction_num_txt
1476: );
1477:
1478: INSERT INTO igf_ap_nslds_data_all (
1479: nslds_id,
1480: isir_id,
1481: base_id,
1482: nslds_transaction_num,

Line 2315: FROM igf_ap_nslds_data_all

2311: dlp_master_prom_note_flag,
2312: subsidized_loan_limit_type,
2313: combined_loan_limit_type,
2314: transaction_num_txt
2315: FROM igf_ap_nslds_data_all
2316: WHERE rowid = x_rowid
2317: FOR UPDATE NOWAIT;
2318:
2319: tlinfo c1%ROWTYPE;

Line 3003: UPDATE igf_ap_nslds_data_all

2999: x_program_update_date := SYSDATE;
3000: END IF;
3001: END IF;
3002:
3003: UPDATE igf_ap_nslds_data_all
3004: SET
3005: isir_id = new_references.isir_id,
3006: base_id = new_references.base_id,
3007: nslds_transaction_num = new_references.nslds_transaction_num,

Line 3429: FROM igf_ap_nslds_data_all

3425: || (reverse chronological order - newest change first)
3426: */
3427: CURSOR c1 IS
3428: SELECT rowid
3429: FROM igf_ap_nslds_data_all
3430: WHERE nslds_id = x_nslds_id;
3431:
3432: BEGIN
3433:

Line 3868: DELETE FROM igf_ap_nslds_data_all

3864: p_action => 'DELETE',
3865: x_rowid => x_rowid
3866: );
3867:
3868: DELETE FROM igf_ap_nslds_data_all
3869: WHERE rowid = x_rowid;
3870:
3871: IF (SQL%NOTFOUND) THEN
3872: RAISE NO_DATA_FOUND;