APPS.IGF_AP_VER_GRPS_PRC_PKG dependencies on IGS_CA_INST

Line 6: PROCEDURE log_input_params( p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,

2: /* $Header: IGFAP29B.pls 120.5 2006/04/20 02:59:03 veramach ship $ */
3:
4: lb_return_value BOOLEAN := FALSE;
5:
6: PROCEDURE log_input_params( p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
7: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,

Line 7: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,

3:
4: lb_return_value BOOLEAN := FALSE;
5:
6: PROCEDURE log_input_params( p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
7: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 38: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,

34: || (reverse chronological order - newest change first)
35: */
36:
37: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
38: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
39: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
40: ) IS
41: SELECT alternate_code
42: FROM igs_ca_inst

Line 39: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE

35: */
36:
37: --Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
38: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
39: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
40: ) IS
41: SELECT alternate_code
42: FROM igs_ca_inst
43: WHERE cal_type = cp_ci_cal_type

Line 42: FROM igs_ca_inst

38: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
39: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
40: ) IS
41: SELECT alternate_code
42: FROM igs_ca_inst
43: WHERE cal_type = cp_ci_cal_type
44: AND sequence_number = cp_ci_sequence_number ;
45:
46: CURSOR c_get_parameters ( cp_lkup_type VARCHAR2 ) IS

Line 61: CURSOR c_get_verif_item (cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,

57: FROM igf_ap_td_item_mst
58: WHERE todo_number = cp_todo_number ;
59:
60: -- Get Verification Item Descrition
61: CURSOR c_get_verif_item (cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
62: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,
63: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
64: cp_lkup_type VARCHAR2 ) IS
65: SELECT lkup.meaning meaning

Line 62: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,

58: WHERE todo_number = cp_todo_number ;
59:
60: -- Get Verification Item Descrition
61: CURSOR c_get_verif_item (cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
62: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,
63: cp_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
64: cp_lkup_type VARCHAR2 ) IS
65: SELECT lkup.meaning meaning
66: FROM igf_ap_batch_aw_map map,

Line 101: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE ;

97:
98: parameter_rec c_get_parameters%ROWTYPE ;
99: verif_item_pmpt_rec c_get_verif_item%ROWTYPE ;
100: lc_item_description igf_ap_td_item_mst.description%TYPE ;
101: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE ;
102: lv_isir_field igf_lookups_view.meaning%TYPE ;
103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;
104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;

Line 371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,

367:
368:
369: FUNCTION add_ver_item(
370: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,

368:
369: FUNCTION add_ver_item(
370: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,