eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PAYMENT_PLANS dependencies on IGS_LOOKUP_VALUES

Line 38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');

34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');

Line 39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');

35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');

Line 40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');

36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');

Line 41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');

37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');

Line 42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');

38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);

Line 43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');

39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:

Line 44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');

40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:
48: --Cursor for validating person group.

Line 45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');

41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:
48: --Cursor for validating person group.
49: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS

Line 596: l_v_pers_status igs_lookup_values.meaning%TYPE;

592: l_v_person_number igs_fi_parties_v.person_number%TYPE;
593: l_n_person_id igs_fi_parties_v.person_id%TYPE;
594: l_v_sql VARCHAR2(32767);
595: l_v_status VARCHAR2(1);
596: l_v_pers_status igs_lookup_values.meaning%TYPE;
597: l_v_pers_message fnd_new_messages.message_text%TYPE;
598:
599: l_n_count PLS_INTEGER;
600: l_n_cnt PLS_INTEGER;

Line 603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');

599: l_n_count PLS_INTEGER;
600: l_n_cnt PLS_INTEGER;
601: l_n_months PLS_INTEGER;
602:
603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');
604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');
605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,

Line 604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');

600: l_n_cnt PLS_INTEGER;
601: l_n_months PLS_INTEGER;
602:
603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');
604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');
605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,

Line 1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');

1064: l_v_closed CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'CLOSED';
1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;
1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');
1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');
1071:
1072: BEGIN

Line 1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');

1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;
1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');
1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');
1071:
1072: BEGIN
1073:

Line 1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');

1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');
1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');
1071:
1072: BEGIN
1073:
1074: --Loop through all the persons.

Line 1202: l_v_meaning igs_lookup_values.meaning%TYPE;

1198: -------------------------------------------------------------------
1199: --Ref cursor variable.
1200: l_cur_ref cur_ref;
1201:
1202: l_v_meaning igs_lookup_values.meaning%TYPE;
1203: l_v_sql VARCHAR2(32767);
1204: l_v_status VARCHAR2(1);
1205: l_v_var VARCHAR2(1);
1206: l_b_valid_param BOOLEAN := TRUE;

Line 1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');

1207: l_v_manage_acc igs_fi_control.manage_accounts%TYPE := NULL;
1208: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
1209: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1210:
1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');
1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');
1213: l_n_count PLS_INTEGER := 0;
1214: l_n_cnt PLS_INTEGER;
1215: l_org_id VARCHAR2(15);

Line 1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');

1208: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
1209: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1210:
1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');
1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');
1213: l_n_count PLS_INTEGER := 0;
1214: l_n_cnt PLS_INTEGER;
1215: l_org_id VARCHAR2(15);
1216: BEGIN