APPS.IGF_AW_ROLLOVER dependencies on IGF_AW_COA_RATE_DET

Line 987: FUNCTION rate_setup_exists ( p_item_code IN igf_aw_coa_rate_det.item_code%TYPE,

983:
984:
985: -- Function to check the existence of the rate based setup in the target award year
986: -- IF exists return TRUE, else return FALSE
987: FUNCTION rate_setup_exists ( p_item_code IN igf_aw_coa_rate_det.item_code%TYPE,
988: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
989: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
990: )
991: RETURN BOOLEAN IS

Line 1004: cp_item_code igf_aw_coa_rate_det.item_code%TYPE

1000:
1001: -- check whether the item code is present or not
1002: CURSOR c_item_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1003: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1004: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1005: ) IS
1006: SELECT 'X' exist
1007: FROM igf_aw_coa_rate_det item
1008: WHERE item.ci_cal_type = cp_to_cal_type

Line 1007: FROM igf_aw_coa_rate_det item

1003: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1004: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1005: ) IS
1006: SELECT 'X' exist
1007: FROM igf_aw_coa_rate_det item
1008: WHERE item.ci_cal_type = cp_to_cal_type
1009: AND item.ci_sequence_number = cp_to_sequence_number
1010: AND item.item_code = cp_item_code
1011: AND rownum = 1;

Line 1056: FROM igf_aw_coa_rate_det

1052: CURSOR c_get_itm_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1053: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1054: ) IS
1055: SELECT item_code
1056: FROM igf_aw_coa_rate_det
1057: WHERE ci_cal_type = cp_frm_cal_type
1058: AND ci_sequence_number = cp_frm_sequence_number
1059: GROUP BY item_code
1060: ORDER BY item_code;

Line 1066: cp_item_code igf_aw_coa_rate_det.item_code%TYPE

1062:
1063: -- Get the rate table setup details for the source award year
1064: CURSOR c_rate_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1065: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1066: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1067: ) IS
1068: SELECT rate.*
1069: FROM igf_aw_coa_rate_det rate
1070: WHERE rate.ci_cal_type = cp_frm_cal_type

Line 1069: FROM igf_aw_coa_rate_det rate

1065: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1066: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1067: ) IS
1068: SELECT rate.*
1069: FROM igf_aw_coa_rate_det rate
1070: WHERE rate.ci_cal_type = cp_frm_cal_type
1071: AND rate.ci_sequence_number = cp_frm_sequence_number
1072: AND rate.item_code = cp_item_code;
1073:

Line 1137: igf_aw_coa_rate_det_pkg.insert_row (

1133: END IF;
1134:
1135: IF l_error_occurred = 'N' THEN
1136: l_rowid := NULL;
1137: igf_aw_coa_rate_det_pkg.insert_row (
1138: x_mode => 'R',
1139: x_rowid => l_rowid,
1140: x_ci_cal_type => p_to_cal_type,
1141: x_ci_sequence_number => p_to_sequence_number,

Line 1814: cp_item_code igf_aw_coa_rate_det.item_code%TYPE

1810:
1811: --Check the existence of the COA Item in the rate table
1812: CURSOR c_coa_itm_exists (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1813: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1814: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1815: ) IS
1816: SELECT 'X' exist
1817: FROM igf_aw_coa_rate_det
1818: WHERE ci_cal_type = cp_cal_type

Line 1817: FROM igf_aw_coa_rate_det

1813: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1814: cp_item_code igf_aw_coa_rate_det.item_code%TYPE
1815: ) IS
1816: SELECT 'X' exist
1817: FROM igf_aw_coa_rate_det
1818: WHERE ci_cal_type = cp_cal_type
1819: AND ci_sequence_number = cp_sequence_number
1820: AND item_code = cp_item_code
1821: AND rownum = 1;