APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_CONTROL_ALL

Line 112: Purpose : Gets the value of planned credits indicator from IGS_FI_CONTROL_ALL.

108: IS
109: /***************************************************************
110: Created By : SYkrishn
111: Date Created By : APR/03/2002
112: Purpose : Gets the value of planned credits indicator from IGS_FI_CONTROL_ALL.
113: Known Limitations,Enhancements or Remarks:
114: Change History :
115: Who When What
116:

Line 119: l_v_planned_credits_ind igs_fi_control_all.planned_credits_ind%TYPE := NULL;

115: Who When What
116:
117: ***************************************************************/
118:
119: l_v_planned_credits_ind igs_fi_control_all.planned_credits_ind%TYPE := NULL;
120: l_v_pln_cr_message fnd_new_messages.message_name%TYPE := NULL;
121:
122: BEGIN
123: --Call the genric function to get the value

Line 284: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;

280: l_ratio igs_fi_hold_plan.threshold_percent%TYPE;
281:
282: -- Changes due to SFCR018
283: -- Call the local function to get the value of planned_credits_ind
284: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
285: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
286: l_n_planned_credit igs_fi_credits.amount%TYPE :=0;
287: -- Changes due to SFCR018
288:

Line 1099: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;

1095: l_msg_str_1 VARCHAR2(1000) :=NULL;
1096: l_process_start_date igs_fi_person_holds.process_start_dT%TYPE;
1097: l_process_end_date igs_fi_person_holds.process_end_dT%TYPE;
1098:
1099: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1100:
1101: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1102: l_v_message_name fnd_new_messages.message_name%TYPE :=NULL;
1103: l_n_offset_days igs_fi_hold_plan.offset_days%TYPE :=0;

Line 1101: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;

1097: l_process_end_date igs_fi_person_holds.process_end_dT%TYPE;
1098:
1099: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1100:
1101: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1102: l_v_message_name fnd_new_messages.message_name%TYPE :=NULL;
1103: l_n_offset_days igs_fi_hold_plan.offset_days%TYPE :=0;
1104: l_n_student_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
1105: l_d_last_inst_due_date igs_fi_pp_instlmnts.due_date%TYPE;

Line 1817: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;

1813:
1814: l_hold_bal_amt igs_fi_balances.holds_balance%TYPE := 0.0;
1815:
1816: -- Changes due to SFCR018
1817: l_v_pln_cr_ind igs_fi_control_all.planned_credits_ind%TYPE := get_planned_credits_ind;
1818: l_v_pln_cr_message fnd_new_messages.message_name%TYPE :=NULL;
1819: l_n_planned_credit igs_fi_credits.amount%TYPE;
1820: -- Changes due to SFCR018
1821:

Line 2281: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;

2277: l_msg_str_0 VARCHAR2(1000);
2278: l_msg_str_1 VARCHAR2(1000);
2279: l_count PLS_INTEGER :=0;
2280:
2281: l_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
2282: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;
2283: l_version_number igs_fi_balance_rules.version_number%TYPE;
2284:
2285: l_n_total_count PLS_INTEGER := 0;

Line 2287: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;

2283: l_version_number igs_fi_balance_rules.version_number%TYPE;
2284:
2285: l_n_total_count PLS_INTEGER := 0;
2286:
2287: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
2288: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
2289: l_v_line_sepr VARCHAR2(1000) := '+-----------------------------------------------------------------------+';
2290:
2291: BEGIN