APPS.IGF_AW_COA_GEN dependencies on IGS_CA_INST

Line 31: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

27:
28: FUNCTION isCoaLocked(
29: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
30: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
31: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
32: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
33: ) RETURN BOOLEAN;
34:
35: FUNCTION doLock(

Line 32: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

28: FUNCTION isCoaLocked(
29: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
30: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
31: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
32: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
33: ) RETURN BOOLEAN;
34:
35: FUNCTION doLock(
36: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 38: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

34:
35: FUNCTION doLock(
36: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
37: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
38: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
39: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
40: ) RETURN VARCHAR2;
41:
42: FUNCTION doUnlock(

Line 39: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

35: FUNCTION doLock(
36: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
37: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
38: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
39: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
40: ) RETURN VARCHAR2;
41:
42: FUNCTION doUnlock(
43: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 45: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,

41:
42: FUNCTION doUnlock(
43: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
44: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
45: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
46: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
47: ) RETURN VARCHAR2;
48:
49: TYPE base_details IS RECORD(

Line 46: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL

42: FUNCTION doUnlock(
43: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
44: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
45: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
46: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
47: ) RETURN VARCHAR2;
48:
49: TYPE base_details IS RECORD(
50: org_unit_cd igf_aw_coa_rate_det.org_unit_cd%TYPE,

Line 66: p_ld_cal_type igs_ca_inst.cal_type%TYPE,

62: );
63:
64: FUNCTION getBaseDetails(
65: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
66: p_ld_cal_type igs_ca_inst.cal_type%TYPE,
67: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
68: ) RETURN base_details;
69:
70: PROCEDURE ins_coa_todo(

Line 67: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE

63:
64: FUNCTION getBaseDetails(
65: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
66: p_ld_cal_type igs_ca_inst.cal_type%TYPE,
67: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE
68: ) RETURN base_details;
69:
70: PROCEDURE ins_coa_todo(
71: p_person_id hz_parties.party_id%TYPE DEFAULT NULL,

Line 114: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

110: p_award_prd_code IN igf_aw_award_prd.award_prd_cd%TYPE DEFAULT NULL
111: ) RETURN VARCHAR2;
112:
113: PROCEDURE get_award_period_dates(
114: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
115: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
116: p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
117: p_start_date OUT NOCOPY DATE,
118: p_end_date OUT NOCOPY DATE

Line 115: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

111: ) RETURN VARCHAR2;
112:
113: PROCEDURE get_award_period_dates(
114: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
115: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
116: p_award_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
117: p_start_date OUT NOCOPY DATE,
118: p_end_date OUT NOCOPY DATE
119: );