APPS.IGF_AW_RULE dependencies on IGF_AW_TARGET_GRP

Line 41: l_ci_cal_type igf_aw_target_grp.cal_type%TYPE ;

37: --
38:
39:
40: lv_get_recent_info VARCHAR2(10) := 'N';
41: l_ci_cal_type igf_aw_target_grp.cal_type%TYPE ;
42: l_ci_sequence_number igf_aw_target_grp.sequence_number%TYPE ;
43:
44:
45: --This process would assign the Award Group to the students for an award year or the students belonging to Person ID Group

Line 42: l_ci_sequence_number igf_aw_target_grp.sequence_number%TYPE ;

38:
39:
40: lv_get_recent_info VARCHAR2(10) := 'N';
41: l_ci_cal_type igf_aw_target_grp.cal_type%TYPE ;
42: l_ci_sequence_number igf_aw_target_grp.sequence_number%TYPE ;
43:
44:
45: --This process would assign the Award Group to the students for an award year or the students belonging to Person ID Group
46: PROCEDURE run ( errbuf OUT NOCOPY VARCHAR2,

Line 49: p_grp_code IN igf_aw_target_grp.group_cd%TYPE,

45: --This process would assign the Award Group to the students for an award year or the students belonging to Person ID Group
46: PROCEDURE run ( errbuf OUT NOCOPY VARCHAR2,
47: retcode OUT NOCOPY NUMBER,
48: l_award_year IN VARCHAR2 ,
49: p_grp_code IN igf_aw_target_grp.group_cd%TYPE,
50: p_pergrp_id IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
51: p_org_id IN NUMBER
52: )
53:

Line 153: PROCEDURE tgroup_rule( p_ci_cal_type in igf_aw_target_grp.cal_type%TYPE ,

149: p_pergrp_id ,
150: p_grp_code) ;
151: END run;
152:
153: PROCEDURE tgroup_rule( p_ci_cal_type in igf_aw_target_grp.cal_type%TYPE ,
154: p_ci_sequence_NUMBER in igf_aw_target_grp.sequence_number%TYPE,
155: p_pergrp_id in igs_pe_prsid_grp_mem_all.group_id%TYPE,
156: p_grp_code IN igf_aw_target_grp.group_cd%TYPE)
157:

Line 154: p_ci_sequence_NUMBER in igf_aw_target_grp.sequence_number%TYPE,

150: p_grp_code) ;
151: END run;
152:
153: PROCEDURE tgroup_rule( p_ci_cal_type in igf_aw_target_grp.cal_type%TYPE ,
154: p_ci_sequence_NUMBER in igf_aw_target_grp.sequence_number%TYPE,
155: p_pergrp_id in igs_pe_prsid_grp_mem_all.group_id%TYPE,
156: p_grp_code IN igf_aw_target_grp.group_cd%TYPE)
157:
158: IS

Line 156: p_grp_code IN igf_aw_target_grp.group_cd%TYPE)

152:
153: PROCEDURE tgroup_rule( p_ci_cal_type in igf_aw_target_grp.cal_type%TYPE ,
154: p_ci_sequence_NUMBER in igf_aw_target_grp.sequence_number%TYPE,
155: p_pergrp_id in igs_pe_prsid_grp_mem_all.group_id%TYPE,
156: p_grp_code IN igf_aw_target_grp.group_cd%TYPE)
157:
158: IS
159: /*
160: || Created By : cdcruz

Line 207: CURSOR c_rule_cd(cp_cal_type igf_aw_target_grp.cal_type%TYPE ,

203: hz.party_id = fa.person_id;
204:
205: l_year c_year%rowtype ;
206:
207: CURSOR c_rule_cd(cp_cal_type igf_aw_target_grp.cal_type%TYPE ,
208: cp_sequence_number igf_aw_target_grp.sequence_number%TYPE,
209: cp_group_cd igf_aw_target_grp.group_cd%TYPE)
210:
211: IS

Line 208: cp_sequence_number igf_aw_target_grp.sequence_number%TYPE,

204:
205: l_year c_year%rowtype ;
206:
207: CURSOR c_rule_cd(cp_cal_type igf_aw_target_grp.cal_type%TYPE ,
208: cp_sequence_number igf_aw_target_grp.sequence_number%TYPE,
209: cp_group_cd igf_aw_target_grp.group_cd%TYPE)
210:
211: IS
212: SELECT

Line 209: cp_group_cd igf_aw_target_grp.group_cd%TYPE)

205: l_year c_year%rowtype ;
206:
207: CURSOR c_rule_cd(cp_cal_type igf_aw_target_grp.cal_type%TYPE ,
208: cp_sequence_number igf_aw_target_grp.sequence_number%TYPE,
209: cp_group_cd igf_aw_target_grp.group_cd%TYPE)
210:
211: IS
212: SELECT
213: tgrp.group_cd R_code

Line 215: igf_aw_target_grp tgrp

211: IS
212: SELECT
213: tgrp.group_cd R_code
214: FROM
215: igf_aw_target_grp tgrp
216: WHERE cal_type =cp_cal_type AND
217: sequence_number =cp_sequence_number AND
218: group_cd = cp_group_cd;
219: