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_CALC_IM_EFC dependencies on IGF_AP_FA_BASE_REC_ALL

Line 17: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

13: --Who When What
14: -------------------------------------------------------------------
15: -- Get person number
16: CURSOR c_person_number(
17: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
18: ) IS
19: SELECT party_number
20: FROM hz_parties parties,
21: igf_ap_fa_base_rec_all fabase

Line 21: igf_ap_fa_base_rec_all fabase

17: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
18: ) IS
19: SELECT party_number
20: FROM hz_parties parties,
21: igf_ap_fa_base_rec_all fabase
22: WHERE fabase.person_id = parties.party_id
23: AND fabase.base_id = cp_base_id;
24:
25: l_person_number hz_parties.party_number%TYPE;

Line 35: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

31: g_error NUMBER := 0;
32: g_total NUMBER := 0;
33:
34: PROCEDURE log_parameters(
35: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
36: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
37: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE
39: ) AS

Line 36: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

32: g_total NUMBER := 0;
33:
34: PROCEDURE log_parameters(
35: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
36: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
37: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE
39: ) AS
40: ------------------------------------------------------------------

Line 37: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

33:
34: PROCEDURE log_parameters(
35: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
36: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
37: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE
39: ) AS
40: ------------------------------------------------------------------
41: --Created by : veramach, Oracle India

Line 110: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

106: app_exception.raise_exception;
107: END log_parameters;
108:
109: PROCEDURE calculate_efc(
110: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
111: p_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
112: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
113: ) AS
114: ------------------------------------------------------------------

Line 111: p_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

107: END log_parameters;
108:
109: PROCEDURE calculate_efc(
110: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
111: p_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
112: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
113: ) AS
114: ------------------------------------------------------------------
115: --Created by : veramach, Oracle India

Line 112: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

108:
109: PROCEDURE calculate_efc(
110: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
111: p_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
112: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
113: ) AS
114: ------------------------------------------------------------------
115: --Created by : veramach, Oracle India
116: --Date created: 8-OCT-2003

Line 134: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

130: l_fnar_rec_fnd BOOLEAN := FALSE;
131:
132: -- Get all PROFILES of a given base_id
133: CURSOR c_all_profiles(
134: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
135: ) IS
136: SELECT prof.*
137: FROM igf_ap_css_profile prof
138: WHERE base_id = cp_base_id;

Line 157: cp_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

153: l_coa_duration_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE;
154:
155: -- Get sys_award_year based on cal type and sequence number
156: CURSOR c_award_year(
157: cp_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
158: cp_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
159: ) IS
160: SELECT sys_award_year
161: FROM igf_ap_batch_aw_map_all

Line 158: cp_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

154:
155: -- Get sys_award_year based on cal type and sequence number
156: CURSOR c_award_year(
157: cp_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
158: cp_seq_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
159: ) IS
160: SELECT sys_award_year
161: FROM igf_ap_batch_aw_map_all
162: WHERE ci_cal_type = cp_cal_type

Line 1041: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

1037: PROCEDURE main(
1038: errbuf OUT NOCOPY VARCHAR2,
1039: retcode OUT NOCOPY NUMBER,
1040: p_award_year IN VARCHAR2,
1041: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1042: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE
1043: ) AS
1044: ------------------------------------------------------------------
1045: --Created by : veramach, Oracle India

Line 1066: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

1062: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' ';
1063:
1064: -- Get base_ids from person id group
1065: CURSOR c_base_id(
1066: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1067: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1068: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1069: ) IS
1070: SELECT base_id

Line 1067: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

1063:
1064: -- Get base_ids from person id group
1065: CURSOR c_base_id(
1066: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1067: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1068: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1069: ) IS
1070: SELECT base_id
1071: FROM igf_ap_fa_base_rec_all

Line 1068: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE

1064: -- Get base_ids from person id group
1065: CURSOR c_base_id(
1066: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1067: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1068: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1069: ) IS
1070: SELECT base_id
1071: FROM igf_ap_fa_base_rec_all
1072: WHERE ci_sequence_number = cp_seq_number

Line 1071: FROM igf_ap_fa_base_rec_all

1067: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1068: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1069: ) IS
1070: SELECT base_id
1071: FROM igf_ap_fa_base_rec_all
1072: WHERE ci_sequence_number = cp_seq_number
1073: AND ci_cal_type = cp_cal_type
1074: AND person_id = cp_person_id;
1075:

Line 1076: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;

1072: WHERE ci_sequence_number = cp_seq_number
1073: AND ci_cal_type = cp_cal_type
1074: AND person_id = cp_person_id;
1075:
1076: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
1077: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1078:
1079: -- Get all base ids in a award year
1080: CURSOR c_all_base_id(

Line 1077: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

1073: AND ci_cal_type = cp_cal_type
1074: AND person_id = cp_person_id;
1075:
1076: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
1077: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1078:
1079: -- Get all base ids in a award year
1080: CURSOR c_all_base_id(
1081: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

Line 1081: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

1077: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
1078:
1079: -- Get all base ids in a award year
1080: CURSOR c_all_base_id(
1081: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1082: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1083: ) IS
1084: SELECT base_id
1085: FROM igf_ap_fa_base_rec_all

Line 1082: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE

1078:
1079: -- Get all base ids in a award year
1080: CURSOR c_all_base_id(
1081: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1082: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1083: ) IS
1084: SELECT base_id
1085: FROM igf_ap_fa_base_rec_all
1086: WHERE ci_sequence_number = cp_seq_number

Line 1085: FROM igf_ap_fa_base_rec_all

1081: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1082: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1083: ) IS
1084: SELECT base_id
1085: FROM igf_ap_fa_base_rec_all
1086: WHERE ci_sequence_number = cp_seq_number
1087: AND ci_cal_type = cp_cal_type;
1088:
1089: TYPE cur_person_id_type IS REF CURSOR;

Line 1092: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;

1088:
1089: TYPE cur_person_id_type IS REF CURSOR;
1090: lc_person_id cur_person_id_type;
1091:
1092: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
1093:
1094: TYPE base_idRefCur IS REF CURSOR;
1095: lc_base_id base_idRefCur;
1096: lbase igf_ap_fa_base_rec_all.base_id%TYPE;

Line 1096: lbase igf_ap_fa_base_rec_all.base_id%TYPE;

1092: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
1093:
1094: TYPE base_idRefCur IS REF CURSOR;
1095: lc_base_id base_idRefCur;
1096: lbase igf_ap_fa_base_rec_all.base_id%TYPE;
1097:
1098: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1099:
1100: BEGIN

Line 1164: OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number, p_persid_grp;

1160: l_list := igf_ap_ss_pkg.get_pid(p_persid_grp,lv_status,lv_group_type);
1161:
1162: --Bug #5021084. Passing Group ID if the group type is STATIC.
1163: IF lv_group_type = 'STATIC' THEN
1164: OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number, p_persid_grp;
1165: ELSIF lv_group_type = 'DYNAMIC' THEN
1166: OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number;
1167: END IF;
1168:

Line 1166: OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number;

1162: --Bug #5021084. Passing Group ID if the group type is STATIC.
1163: IF lv_group_type = 'STATIC' THEN
1164: OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number, p_persid_grp;
1165: ELSIF lv_group_type = 'DYNAMIC' THEN
1166: OPEN lc_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_cal_type, l_seq_number;
1167: END IF;
1168:
1169: FETCH lc_base_id INTO lbase;
1170: IF lc_base_id%FOUND THEN