APPS.IGF_AP_LG_TD_IMP dependencies on IGF_SL_CL_PREF_LENDERS

Line 168: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE

164: -- museshad (FA 140). Forward declaration
165: PROCEDURE process_pref_lender(
166: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
167: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,
168: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE
169: );
170: -- museshad (FA 140)
171:
172: PROCEDURE main ( errbuf OUT NOCOPY VARCHAR2,

Line 344: l_clprl_id igf_sl_cl_pref_lenders.clprl_id%TYPE;

340: WHERE relationship_cd = cp_rel_cd AND
341: UPPER(ENABLED) = 'Y';
342:
343: l_chk_lender_rel_rec VARCHAR2(1);
344: l_clprl_id igf_sl_cl_pref_lenders.clprl_id%TYPE;
345: -- museshad (FA 140)
346:
347: BEGIN
348: igf_aw_gen.set_org_id(NULL);

Line 1012: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE

1008:
1009: PROCEDURE process_pref_lender(
1010: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1011: p_rel_cd IN igf_ap_li_todo_ints.relationship_cd%TYPE,
1012: p_clprl_id OUT NOCOPY igf_sl_cl_pref_lenders.clprl_id%TYPE
1013: )
1014: IS
1015:
1016: /*

Line 1035: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

1031: SELECT person_id
1032: FROM igf_ap_fa_base_rec_all
1033: WHERE base_id = cp_base_id;
1034:
1035: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1036:
1037: -- Gets the Prferred lender details if it exists
1038: CURSOR c_chk_pref_lender (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE)
1039: IS

Line 1038: CURSOR c_chk_pref_lender (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE)

1034:
1035: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1036:
1037: -- Gets the Prferred lender details if it exists
1038: CURSOR c_chk_pref_lender (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE)
1039: IS
1040: SELECT
1041: ROWID row_id,
1042: pref_lender.clprl_id,

Line 1048: igf_sl_cl_pref_lenders pref_lender

1044: pref_lender.start_date,
1045: pref_lender.end_date,
1046: pref_lender.person_id
1047: FROM
1048: igf_sl_cl_pref_lenders pref_lender
1049: WHERE
1050: pref_lender.person_id = cp_person_id
1051: AND pref_lender.end_date IS NULL;
1052:

Line 1078: igf_sl_cl_pref_lenders_pkg.insert_row (

1074: CLOSE c_chk_pref_lender;
1075:
1076: IF l_chk_pref_lender.start_date IS NULL THEN
1077: -- No Active Pref lender exists. So insert lender
1078: igf_sl_cl_pref_lenders_pkg.insert_row (
1079: x_mode => 'R',
1080: x_rowid => l_row_id,
1081: x_clprl_id => p_clprl_id,
1082: x_msg_count => l_msg_count,

Line 1096: igf_sl_cl_pref_lenders_pkg.update_row(

1092: IF l_chk_pref_lender.relationship_cd <> p_rel_cd THEN
1093: -- Existing active Pref lender is different from one being imported.
1094: -- Previous relationship record has to be end dated and
1095: -- a new record has to be added
1096: igf_sl_cl_pref_lenders_pkg.update_row(
1097: x_mode => 'R',
1098: x_rowid => l_chk_pref_lender.row_id,
1099: x_clprl_id => l_chk_pref_lender.clprl_id,
1100: x_msg_count => l_msg_count,

Line 1108: igf_sl_cl_pref_lenders_pkg.insert_row (

1104: x_start_date => l_chk_pref_lender.start_date,
1105: x_relationship_cd => l_chk_pref_lender.relationship_cd,
1106: x_end_date => TRUNC(SYSDATE - 1)
1107: );
1108: igf_sl_cl_pref_lenders_pkg.insert_row (
1109: x_mode => 'R',
1110: x_rowid => l_row_id,
1111: x_clprl_id => p_clprl_id,
1112: x_msg_count => l_msg_count,