APPS.IGF_AW_ROLLOVER dependencies on IGS_CA_INST_ALL

Line 20: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

16: p_todo IN VARCHAR2,
17: p_award_grp IN VARCHAR2
18: );
19:
20: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
21: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
22: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
23: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
24: ) RETURN BOOLEAN;

Line 21: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

17: p_award_grp IN VARCHAR2
18: );
19:
20: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
21: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
22: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
23: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
24: ) RETURN BOOLEAN;
25:

Line 22: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

18: );
19:
20: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
21: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
22: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
23: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
24: ) RETURN BOOLEAN;
25:
26:

Line 23: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE

19:
20: FUNCTION chk_calendar_mapping ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
21: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
22: p_to_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
23: p_to_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE
24: ) RETURN BOOLEAN;
25:
26:
27: FUNCTION get_fund_cd (

Line 29: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

25:
26:
27: FUNCTION get_fund_cd (
28: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
29: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
30: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
31: ) RETURN igf_aw_fund_mast_all.fund_code%TYPE;
32:
33:

Line 30: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

26:
27: FUNCTION get_fund_cd (
28: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
29: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
30: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
31: ) RETURN igf_aw_fund_mast_all.fund_code%TYPE;
32:
33:
34: FUNCTION get_plan_cd(

Line 36: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,

32:
33:
34: FUNCTION get_plan_cd(
35: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
36: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
37: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
38: ) RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE;
39:
40:

Line 37: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

33:
34: FUNCTION get_plan_cd(
35: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
36: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
37: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
38: ) RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE;
39:
40:
41: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 41: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,

37: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
38: ) RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE;
39:
40:
41: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
43: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
44: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
45: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE

Line 42: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

38: ) RETURN igf_aw_awd_dist_plans.awd_dist_plan_cd%TYPE;
39:
40:
41: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
43: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
44: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
45: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
46: )

Line 43: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,

39:
40:
41: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
43: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
44: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
45: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
46: )
47: RETURN VARCHAR;

Line 44: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

40:
41: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
42: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
43: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
44: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
45: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
46: )
47: RETURN VARCHAR;
48: