[Home] [Help]
179: || Even though Entitlement bypasses this validation the running total
180: || As a result of this entitlement has to be updated for future funds.
181: ||
182: || adhawan 02-may-2002 Bug ID : 2330105
183: || Removed the logic , {If the Individual Packaging is set to "Y"
184: || and manually packaged is set to "N" then Packaging should skip that fund}
185: ||
186: || sjadhav 12-sep-2001 Bug ID : 1978618
187: || added exception param_err
255: || round off procedure incase of direct loans.
256: || Rounding off process. A call is made to roundoff process package
257: ||
258:
259: || The Packaging for a Run Code/Target Group/Individual Student is done in this pkg
260: ||
261: || Pre-requisites
262: || The following tables have to be populated before calling this process
263: || igf_fa_base_rec
555: cp_stud_program_cd igs_ps_ver_v.course_cd%type,
556: cp_fund_source igf_aw_fund_cat_all.fund_source%type
557: )
558: IS
559: SELECT 'x' FROM dual
560: WHERE EXISTS
561: ( SELECT * FROM IGS_PS_VER_V
562: WHERE course_cd = cp_stud_program_cd AND
563: DECODE(cp_fund_source,
4535: -------------------------------------------------------------------
4536:
4537: CURSOR c_terms IS
4538: SELECT 'x'
4539: FROM DUAL
4540: WHERE EXISTS(
4541: SELECT 'x'
4542: FROM igf_aw_awd_disb_all
4543: WHERE award_id = p_award_id
5735: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
5736: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
5737: ) IS
5738: SELECT 'x'
5739: FROM dual
5740: WHERE EXISTS (
5741: SELECT DISTINCT ld_cal_type,ld_sequence_number
5742: FROM igf_aw_dp_terms
5743: WHERE adplans_id = cp_adplans_id
11585:
11586: -- If the process ID is not assigned then assign the same from the sequences
11587: -- This is uesd to uniquely identify the records in the temporary table
11588: IF l_process_id IS NULL THEN
11589: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual;
11590: END IF;
11591:
11592: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11593: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_process_id.debug '|| g_req_id,'l_process_id:'||l_process_id);
13246: p_fund_id IN NUMBER,
13247: l_run_type IN VARCHAR2, -- Obsoleted parameter, retaining for backward compatibility
13248: p_publish_in_ss_flag IN VARCHAR2,
13249: l_run_code IN VARCHAR2, -- Obsoleted parameter, retaining for backward compatibility
13250: l_individual_pkg IN VARCHAR2 -- Obsoleted parameter, retaining for backward compatibility
13251: ) IS
13252: /*
13253: || Created By : cdcruz
13254: || Created On : 14-NOV-2000
13810: p_fund_id, -- p_fund_id
13811: NULL, -- l_run_type -- Obsoleted parameter
13812: p_publish_in_ss_flag, -- p_publish_in_ss_flag
13813: NULL, -- l_run_code -- Obsoleted parameter
13814: NULL -- l_individual_pkg -- Obsoleted parameter
13815: );
13816:
13817: EXCEPTION
13818: WHEN PARAM_ERR THEN