442: igf_sl_lor_loc_pkg.get_fk_igf_sl_lor (
443: old_references.origination_id
444: );
445:
446: igf_sl_pnote_stat_h_pkg.get_ufk_igf_sl_lor (
447: old_references.loan_id
448: );
449:
450: END check_child_existance;
464:
465: IF (((old_references.loan_id = new_references.loan_id)) OR
466: ((old_references.loan_id IS NULL))) THEN
467: NULL;
468: ELSE igf_sl_pnote_stat_h_pkg.get_ufk_igf_sl_lor (
469: old_references.loan_id
470: );
471: END IF;
472:
1005: IF (p_action = 'UPDATE') AND ( new_references.pnote_status = old_references.pnote_status ) THEN
1006:
1007: null;
1008: ELSE
1009: igf_sl_pnote_stat_h_pkg.insert_row (
1010: x_mode => 'R',
1011: x_rowid => l_pnote_stat_h_rowid,
1012: x_dlpnh_id => l_dlpnh_id,
1013: x_loan_id => new_references.loan_id,