APPS.IGF_SL_PREF_LENDER dependencies on IGF_SL_CL_PREF_LENDERS

Line 269: l_clprl_id igf_sl_cl_pref_lenders.clprl_id%TYPE := NULL;

265: l_return_status VARCHAR2(50);
266: l_total_record_cnt NUMBER := 0;
267: l_debug_str VARCHAR2(800) := NULL;
268: l_start_date DATE;
269: l_clprl_id igf_sl_cl_pref_lenders.clprl_id%TYPE := NULL;
270:
271:
272:
273: CURSOR c_get_relation_code (

Line 305: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE

301: l_person_id hz_parties.party_id%TYPE;
302: l_person_number hz_parties.party_number%TYPE;
303:
304: CURSOR c_chk_pref_lender (
305: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
306: )
307: IS
308: SELECT ROWID row_id,
309: clprl_id,

Line 313: FROM igf_sl_cl_pref_lenders

309: clprl_id,
310: relationship_cd,
311: start_date,
312: end_date
313: FROM igf_sl_cl_pref_lenders
314: WHERE person_id = cp_person_id
315: AND end_date IS NULL;
316:
317: l_chk_pref_lender c_chk_pref_lender%ROWTYPE;

Line 411: -- insert a record into the igf_sl_cl_pref_lenders table as no active lender exists

407: CLOSE c_chk_pref_lender;
408:
409: IF l_chk_pref_lender.start_date IS NULL THEN
410: l_message := NULL;
411: -- insert a record into the igf_sl_cl_pref_lenders table as no active lender exists
412: BEGIN
413: igf_sl_cl_pref_lenders_pkg.insert_row (
414: x_mode => 'R',
415: x_clprl_id => l_clprl_id,

Line 413: igf_sl_cl_pref_lenders_pkg.insert_row (

409: IF l_chk_pref_lender.start_date IS NULL THEN
410: l_message := NULL;
411: -- insert a record into the igf_sl_cl_pref_lenders table as no active lender exists
412: BEGIN
413: igf_sl_cl_pref_lenders_pkg.insert_row (
414: x_mode => 'R',
415: x_clprl_id => l_clprl_id,
416: x_rowid => lv_row_id,
417: x_msg_count => l_msg_count,

Line 426: -- the validation is done in the TBH of igf_sl_cl_pref_lenders

422: x_relationship_cd => p_rel_code,
423: x_end_date => NULL
424: );
425: -- here exception will be raised if the lender setup is invalid after performing the above operation
426: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
427: -- if no exception is raised then add the sucessful message to the log
428: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
429: fnd_message.set_token('PERS_NUM',l_person_number);
430: fnd_message.set_token('REL_CODE',p_rel_code);

Line 473: igf_sl_cl_pref_lenders_pkg.update_row (

469: END IF;
470: l_message := NULL;
471: -- Previous relationship record has to be end dated and a new record has to be added .
472: BEGIN
473: igf_sl_cl_pref_lenders_pkg.update_row (
474: x_mode => 'R',
475: x_clprl_id => l_chk_pref_lender.clprl_id,
476: x_rowid => l_chk_pref_lender.row_id,
477: x_msg_count => l_msg_count,

Line 485: igf_sl_cl_pref_lenders_pkg.insert_row (

481: x_start_date => l_chk_pref_lender.start_date,
482: x_relationship_cd => l_chk_pref_lender.relationship_cd,
483: x_end_date => TRUNC(l_start_date-1)
484: );
485: igf_sl_cl_pref_lenders_pkg.insert_row (
486: x_mode => 'R',
487: x_rowid => lv_row_id,
488: x_clprl_id => l_clprl_id,
489: x_msg_count => l_msg_count,

Line 498: -- the validation is done in the TBH of igf_sl_cl_pref_lenders

494: x_relationship_cd => p_rel_code,
495: x_end_date => NULL
496: );
497: -- here exception will be raised if the lender setup is invalid after performing the above operation
498: -- the validation is done in the TBH of igf_sl_cl_pref_lenders
499: -- if no exception is raised then add the sucessful message to the log
500: fnd_message.set_name('IGF','IGF_SL_CL_LEND_ADD');
501: fnd_message.set_token('PERS_NUM',l_person_number);
502: fnd_message.set_token('REL_CODE',p_rel_code);