APPS.IGF_SL_GEN dependencies on IGF_SL_CL_PREF_LENDERS

Line 785: PROCEDURE check_lend_relation( p_person_id IN igf_sl_cl_pref_lenders.person_id%TYPE,

781: RETURN ( NVL(l_phone_area_code,'000')|| l_phone_number);
782:
783: END get_person_phone;
784:
785: PROCEDURE check_lend_relation( p_person_id IN igf_sl_cl_pref_lenders.person_id%TYPE,
786: p_start_date IN DATE,
787: p_end_date IN DATE,
788: p_message OUT NOCOPY VARCHAR2)
789: AS

Line 803: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE

799: (reverse chronological order - newest change first)
800: ***************************************************************/
801:
802: CURSOR c_chk_active_rec (
803: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
804: )
805: IS
806: SELECT count(*) cnt
807: FROM igf_sl_cl_pref_lenders

Line 807: FROM igf_sl_cl_pref_lenders

803: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
804: )
805: IS
806: SELECT count(*) cnt
807: FROM igf_sl_cl_pref_lenders
808: WHERE person_id = cp_person_id
809: AND end_date IS NULL;
810:
811: l_chk_active_rec c_chk_active_rec%ROWTYPE;

Line 814: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

810:
811: l_chk_active_rec c_chk_active_rec%ROWTYPE;
812:
813: CURSOR c_chk_overlap_date (
814: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
815: cp_start_date DATE,
816: cp_end_date DATE
817: )
818: IS

Line 820: FROM igf_sl_cl_pref_lenders

816: cp_end_date DATE
817: )
818: IS
819: SELECT count(*) cnt
820: FROM igf_sl_cl_pref_lenders
821: WHERE person_id = cp_person_id
822: AND ( ( cp_start_date BETWEEN start_date AND NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD')) )
823: OR ( NVL(cp_end_date,TO_DATE('4712/12/31','YYYY/MM/DD')) BETWEEN start_date AND NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD')))
824: OR ( cp_start_date < start_date AND NVL(cp_end_date,TO_DATE('4712/12/31','YYYY/MM/DD')) > NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))));

Line 870: PROCEDURE get_person_details ( p_person_id IN igf_sl_cl_pref_lenders.person_id%TYPE,

866: app_exception.raise_exception;
867:
868: END check_lend_relation;
869:
870: PROCEDURE get_person_details ( p_person_id IN igf_sl_cl_pref_lenders.person_id%TYPE,
871: p_person_dtl_rec IN OUT NOCOPY person_dtl_cur)
872: AS
873: /*************************************************************
874: Created By : bkkumar

Line 887: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

883: start date and end date from igs_pe_hz_pty_sites.
884: (reverse chronological order - newest change first)
885: **************************************************************/
886: CURSOR c_get_ssn (
887: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
888: cp_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE
889: )
890: IS
891: SELECT api.api_person_id_uf ssn,

Line 905: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE

901:
902: l_get_ssn c_get_ssn%ROWTYPE;
903:
904: CURSOR c_get_name (
905: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
906: )
907: IS
908: SELECT person_id,
909: person_number,

Line 926: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

922: l_get_name c_get_name%ROWTYPE;
923:
924:
925: CURSOR c_get_emailaddr (
926: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
927: cp_primary_flag igs_pe_contacts_v.primary_flag%TYPE,
928: cp_status igs_pe_contacts_v.status%TYPE,
929: cp_contact_point_type igs_pe_contacts_v.contact_point_type%TYPE
930: )

Line 942: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

938:
939: l_get_emailaddr c_get_emailaddr%ROWTYPE;
940:
941: CURSOR c_get_paddr (
942: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
943: cp_identifying_address_flag hz_party_sites.identifying_address_flag%TYPE
944: )
945: IS
946: SELECT ps.party_id,

Line 973: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

969: l_get_paddr c_get_paddr%ROWTYPE;
970:
971:
972: CURSOR c_get_lic_num (
973: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
974: cp_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE
975: )
976: IS
977: SELECT api.api_person_id,

Line 993: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

989:
990: l_get_lic_num c_get_lic_num%ROWTYPE;
991:
992: CURSOR c_get_addr (
993: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
994: cp_status hz_party_site_uses.status%TYPE,
995: cp_site_use_type hz_party_site_uses.site_use_type%TYPE
996: )
997: IS

Line 1027: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

1023: l_get_addr c_get_addr%ROWTYPE;
1024:
1025:
1026: CURSOR c_get_reg_num (
1027: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1028: cp_perm_res_cntry igs_pe_eit_perm_res_v.perm_res_cntry%TYPE
1029: )
1030: IS
1031: SELECT document_num

Line 1040: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

1036:
1037: l_get_reg_num VARCHAR2(150);
1038:
1039: CURSOR c_get_res_state (
1040: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1041: cp_information_type igs_pe_eit.information_type%TYPE
1042: )
1043: IS
1044: SELECT pei_information1 state_code,

Line 1055: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,

1051: l_get_res_state c_get_res_state%ROWTYPE;
1052:
1053:
1054: CURSOR c_get_citzn_status (
1055: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1056: cp_lookup_type igs_lookup_values.lookup_type%TYPE
1057: )
1058: IS
1059: SELECT lkup.tag,

Line 1216: FROM igf_sl_cl_pref_lenders

1212: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE
1213: )
1214: IS
1215: SELECT relationship_cd
1216: FROM igf_sl_cl_pref_lenders
1217: WHERE relationship_cd = cp_rel_code
1218: AND ROWNUM = 1;
1219:
1220: l_chk_rel_code2 c_chk_rel_code2%ROWTYPE;

Line 1240: -- cursor to check whether the relationship exists in the igf_sl_cl_pref_lenders table

1236: FETCH c_chk_rel_code1 INTO l_chk_rel_code1;
1237: CLOSE c_chk_rel_code1;
1238:
1239: l_chk_rel_code2 := NULL;
1240: -- cursor to check whether the relationship exists in the igf_sl_cl_pref_lenders table
1241: OPEN c_chk_rel_code2(p_rel_code);
1242: FETCH c_chk_rel_code2 INTO l_chk_rel_code2;
1243: CLOSE c_chk_rel_code2;
1244: