APPS.IGF_SL_LOR_PKG dependencies on IGF_SL_PNOTE_STAT_H

Line 446: igf_sl_pnote_stat_h_pkg.get_ufk_igf_sl_lor (

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;

Line 468: ELSE igf_sl_pnote_stat_h_pkg.get_ufk_igf_sl_lor (

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:

Line 981: || Purpose : to call the table handler for igf_sl_pnote_stat_h

977: ) AS
978: /*
979: || Created By : viramali
980: || Created On : 12-MAY-2001
981: || Purpose : to call the table handler for igf_sl_pnote_stat_h
982: || to insert records
983: || Change History :
984: || Who When What
985: || smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.

Line 990: l_dlpnh_id igf_sl_pnote_stat_h.dlpnh_id%TYPE := NULL;

986: || (reverse chronological order - newest change first)
987: */
988:
989: l_pnote_stat_h_rowid VARCHAR2(30) := NULL;
990: l_dlpnh_id igf_sl_pnote_stat_h.dlpnh_id%TYPE := NULL;
991:
992: BEGIN
993: l_rowid := x_rowid;
994: IF (p_action = 'UPDATE') THEN

Line 1009: igf_sl_pnote_stat_h_pkg.insert_row (

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,