APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGS_CA_INST

Line 60: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,

56: l_has_isir VARCHAR2(1) := NULL;
57: l_has_profile VARCHAR2(1) := NULL;
58:
59: PROCEDURE log_input_params(
60: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
61: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
62: p_base_id IN NUMBER,
63: p_person_id_grp IN NUMBER,
64: p_upd_mode IN VARCHAR2,

Line 61: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,

57: l_has_profile VARCHAR2(1) := NULL;
58:
59: PROCEDURE log_input_params(
60: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
61: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
62: p_base_id IN NUMBER,
63: p_person_id_grp IN NUMBER,
64: p_upd_mode IN VARCHAR2,
65: p_item_number_1 IN NUMBER,

Line 111: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

107: */
108:
109: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
110: CURSOR c_alternate_code(
111: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
112: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
113: ) IS
114: SELECT alternate_code
115: FROM igs_ca_inst

Line 112: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE

108:
109: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
110: CURSOR c_alternate_code(
111: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
112: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
113: ) IS
114: SELECT alternate_code
115: FROM igs_ca_inst
116: WHERE cal_type = cp_ci_cal_type

Line 115: FROM igs_ca_inst

111: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
112: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
113: ) IS
114: SELECT alternate_code
115: FROM igs_ca_inst
116: WHERE cal_type = cp_ci_cal_type
117: AND sequence_number = cp_ci_sequence_number;
118:
119: CURSOR c_get_parameters IS

Line 161: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE;

157: WHERE todo_number = cp_item_number;
158:
159: parameter_rec c_get_parameters%ROWTYPE;
160: lc_item_description igf_ap_td_item_mst.description%TYPE;
161: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE;
162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;
163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;

Line 668: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,

664:
665: FUNCTION assign_todo(
666: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
667: p_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
668: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
670: p_upd_mode IN VARCHAR2,
671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,

Line 669: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,

665: FUNCTION assign_todo(
666: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
667: p_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
668: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
670: p_upd_mode IN VARCHAR2,
671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,