eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_GEN dependencies on IGS_CA_INST

Line 6: p_alt_code_one IN igs_ca_inst.alternate_code%TYPE,

2: /* $Header: IGFAP36B.pls 120.2 2005/12/11 03:59:59 appldev ship $ */
3:
4: FUNCTION validate_cal_inst(
5: p_cal_cat IN igs_ca_type.s_cal_cat%TYPE,
6: p_alt_code_one IN igs_ca_inst.alternate_code%TYPE,
7: p_alt_code_two IN igs_ca_inst.alternate_code%TYPE,
8: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
9: p_sequence_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE
10: ) RETURN BOOLEAN AS

Line 7: p_alt_code_two IN igs_ca_inst.alternate_code%TYPE,

3:
4: FUNCTION validate_cal_inst(
5: p_cal_cat IN igs_ca_type.s_cal_cat%TYPE,
6: p_alt_code_one IN igs_ca_inst.alternate_code%TYPE,
7: p_alt_code_two IN igs_ca_inst.alternate_code%TYPE,
8: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
9: p_sequence_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE
10: ) RETURN BOOLEAN AS
11:

Line 8: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,

4: FUNCTION validate_cal_inst(
5: p_cal_cat IN igs_ca_type.s_cal_cat%TYPE,
6: p_alt_code_one IN igs_ca_inst.alternate_code%TYPE,
7: p_alt_code_two IN igs_ca_inst.alternate_code%TYPE,
8: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
9: p_sequence_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE
10: ) RETURN BOOLEAN AS
11:
12: /*

Line 9: p_sequence_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE

5: p_cal_cat IN igs_ca_type.s_cal_cat%TYPE,
6: p_alt_code_one IN igs_ca_inst.alternate_code%TYPE,
7: p_alt_code_two IN igs_ca_inst.alternate_code%TYPE,
8: p_cal_type IN OUT NOCOPY igs_ca_inst.cal_type%TYPE,
9: p_sequence_number IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE
10: ) RETURN BOOLEAN AS
11:
12: /*
13: || Created By : brajendr

Line 27: cp_alternate_code igs_ca_inst.alternate_code%TYPE

23:
24: -- Get the details of
25: CURSOR check_cal_inst(
26: cp_cal_cat igs_ca_type.s_cal_cat%TYPE,
27: cp_alternate_code igs_ca_inst.alternate_code%TYPE
28: ) IS
29: SELECT cainst.alternate_code, cainst.cal_type, cainst.sequence_number
30: FROM igs_ca_inst cainst, igs_ca_type catyp
31: WHERE catyp.s_cal_cat = cp_cal_cat

Line 30: FROM igs_ca_inst cainst, igs_ca_type catyp

26: cp_cal_cat igs_ca_type.s_cal_cat%TYPE,
27: cp_alternate_code igs_ca_inst.alternate_code%TYPE
28: ) IS
29: SELECT cainst.alternate_code, cainst.cal_type, cainst.sequence_number
30: FROM igs_ca_inst cainst, igs_ca_type catyp
31: WHERE catyp.s_cal_cat = cp_cal_cat
32: AND cainst.cal_type = catyp.cal_type
33: AND cainst.ALTERNATE_CODE = cp_alternate_code
34: AND ROWNUM = 1;

Line 40: cp_alternate_code igs_ca_inst.alternate_code%TYPE,

36: check_cal_inst_rec check_cal_inst%ROWTYPE;
37:
38: -- Get the details of
39: CURSOR check_awd_load_rel(
40: cp_alternate_code igs_ca_inst.alternate_code%TYPE,
41: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
43: ) IS
44: SELECT 'X' val

Line 41: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

37:
38: -- Get the details of
39: CURSOR check_awd_load_rel(
40: cp_alternate_code igs_ca_inst.alternate_code%TYPE,
41: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
43: ) IS
44: SELECT 'X' val
45: FROM igs_ca_inst_rel rel,

Line 42: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

38: -- Get the details of
39: CURSOR check_awd_load_rel(
40: cp_alternate_code igs_ca_inst.alternate_code%TYPE,
41: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
43: ) IS
44: SELECT 'X' val
45: FROM igs_ca_inst_rel rel,
46: igs_ca_inst ca

Line 45: FROM igs_ca_inst_rel rel,

41: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
42: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
43: ) IS
44: SELECT 'X' val
45: FROM igs_ca_inst_rel rel,
46: igs_ca_inst ca
47: WHERE rel.sup_cal_type = ca.cal_type
48: AND rel.sup_ci_sequence_number = ca.sequence_number
49: AND ca.alternate_code = cp_alternate_code

Line 46: igs_ca_inst ca

42: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
43: ) IS
44: SELECT 'X' val
45: FROM igs_ca_inst_rel rel,
46: igs_ca_inst ca
47: WHERE rel.sup_cal_type = ca.cal_type
48: AND rel.sup_ci_sequence_number = ca.sequence_number
49: AND ca.alternate_code = cp_alternate_code
50: AND sub_cal_type = cp_ld_cal_type

Line 58: cp_alternate_code_load igs_ca_inst.alternate_code%TYPE,

54: check_awd_load_rel_rec check_awd_load_rel%ROWTYPE;
55:
56: -- Get the details of
57: CURSOR check_load_teach_rel(
58: cp_alternate_code_load igs_ca_inst.alternate_code%TYPE,
59: cp_alternate_code_teach igs_ca_inst.alternate_code%TYPE
60: ) IS
61: SELECT 'X' val
62: FROM igs_ca_load_to_teach_v

Line 59: cp_alternate_code_teach igs_ca_inst.alternate_code%TYPE

55:
56: -- Get the details of
57: CURSOR check_load_teach_rel(
58: cp_alternate_code_load igs_ca_inst.alternate_code%TYPE,
59: cp_alternate_code_teach igs_ca_inst.alternate_code%TYPE
60: ) IS
61: SELECT 'X' val
62: FROM igs_ca_load_to_teach_v
63: WHERE load_alternate_code = cp_alternate_code_load

Line 138: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

134: END validate_cal_inst;
135:
136:
137: PROCEDURE check_person ( p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
138: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
139: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
140: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
141: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE ) IS
142:

Line 139: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

135:
136:
137: PROCEDURE check_person ( p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
138: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
139: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
140: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
141: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE ) IS
142:
143: /*

Line 623: igs_ca_inst_all ca,

619: 11, PRIMARY_ALTERNATE_MONTH_11,
620: 12, PRIMARY_ALTERNATE_MONTH_12 ) ) efc
621: FROM igf_ap_isir_matched_all isir,
622: igf_ap_fa_base_rec_all fa,
623: igs_ca_inst_all ca,
624: igf_aw_coa_itm_terms coa
625: WHERE coa.base_id = fa.base_id
626: AND coa.base_id = isir.base_id
627: AND fa.base_id = cp_base_id

Line 681: igs_ca_inst ca

677: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
678: )IS
679: SELECT SUM(coait.amount) coa
680: FROM igf_aw_coa_itm_terms coait,
681: igs_ca_inst ca
682: WHERE ca.cal_type = coait.ld_cal_type
683: AND ca.sequence_number = coait.ld_sequence_number
684: AND ca.start_dt <= cp_ld_start_dt
685: AND coait.base_id = cp_base_id;

Line 733: igs_ca_inst ca

729: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
730: )IS
731: SELECT SUM(coait.amount) coa
732: FROM igf_aw_coa_itm_terms coait,
733: igs_ca_inst ca
734: WHERE ca.cal_type = coait.ld_cal_type
735: AND ca.sequence_number = coait.ld_sequence_number
736: AND ca.start_dt = cp_ld_start_dt
737: AND coait.base_id = cp_base_id;

Line 919: FROM igs_ca_inst_all ca,

915: CURSOR c_award_year(
916: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
917: ) IS
918: SELECT ca.alternate_code
919: FROM igs_ca_inst_all ca,
920: igf_ap_fa_base_rec_all fa
921: WHERE fa.base_id = cp_base_id
922: AND fa.ci_cal_type = ca.cal_type
923: AND fa.ci_sequence_number = ca.sequence_number;

Line 924: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

920: igf_ap_fa_base_rec_all fa
921: WHERE fa.base_id = cp_base_id
922: AND fa.ci_cal_type = ca.cal_type
923: AND fa.ci_sequence_number = ca.sequence_number;
924: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
925:
926: BEGIN
927: OPEN c_inst(p_base_id,p_item_sequence_number);
928: FETCH c_inst INTO l_inst;