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_AW_COA_GEN dependencies on IGF_AP_FA_ANT_DATA

Line 1272: FROM igf_ap_fa_ant_data

1268: attendance_type,
1269: attendance_mode,
1270: months_enrolled_num,
1271: credit_points_num
1272: FROM igf_ap_fa_ant_data
1273: WHERE base_id = cp_base_id
1274: AND ld_cal_type = cp_ld_cal_type
1275: AND ld_sequence_number = cp_ld_sequence_number;
1276:

Line 2186: p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,

2182:
2183: END get_award_period_dates;
2184:
2185: PROCEDURE check_oss_attrib(
2186: p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,
2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,

Line 2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,

2183: END get_award_period_dates;
2184:
2185: PROCEDURE check_oss_attrib(
2186: p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,
2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,
2191: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,

Line 2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,

2184:
2185: PROCEDURE check_oss_attrib(
2186: p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,
2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,
2191: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,
2192: p_ret_status OUT NOCOPY VARCHAR2

Line 2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,

2185: PROCEDURE check_oss_attrib(
2186: p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,
2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,
2191: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,
2192: p_ret_status OUT NOCOPY VARCHAR2
2193: ) IS

Line 2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,

2186: p_org_unit_code IN igf_ap_fa_ant_data.org_unit_cd%TYPE,
2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,
2191: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,
2192: p_ret_status OUT NOCOPY VARCHAR2
2193: ) IS
2194: ------------------------------------------------------------------

Line 2191: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,

2187: p_program_code IN igf_ap_fa_ant_data.program_cd%TYPE,
2188: p_program_type IN igf_ap_fa_ant_data.program_type%TYPE,
2189: p_program_location IN igf_ap_fa_ant_data.program_location_cd%TYPE,
2190: p_attend_type IN igf_ap_fa_ant_data.attendance_type%TYPE,
2191: p_attend_mode IN igf_ap_fa_ant_data.attendance_mode%TYPE,
2192: p_ret_status OUT NOCOPY VARCHAR2
2193: ) IS
2194: ------------------------------------------------------------------
2195: --Created by : ridas, Oracle India

Line 2211: CURSOR c_chk_org (cp_org_unit igf_ap_fa_ant_data.org_unit_cd%TYPE,

2207: -------------------------------------------------------------------
2208:
2209: -- Cursor to check whether the anticipated org unit is a responsible/owning org unit
2210: -- for the specified anticipated key program or not
2211: CURSOR c_chk_org (cp_org_unit igf_ap_fa_ant_data.org_unit_cd%TYPE,
2212: cp_program_code igf_ap_fa_ant_data.program_cd%TYPE)
2213: IS
2214: SELECT 'x'
2215: FROM igs_ps_ver

Line 2212: cp_program_code igf_ap_fa_ant_data.program_cd%TYPE)

2208:
2209: -- Cursor to check whether the anticipated org unit is a responsible/owning org unit
2210: -- for the specified anticipated key program or not
2211: CURSOR c_chk_org (cp_org_unit igf_ap_fa_ant_data.org_unit_cd%TYPE,
2212: cp_program_code igf_ap_fa_ant_data.program_cd%TYPE)
2213: IS
2214: SELECT 'x'
2215: FROM igs_ps_ver
2216: WHERE course_cd = cp_program_code

Line 2229: CURSOR c_chk_prog (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,

2225: l_chk_org c_chk_org%ROWTYPE;
2226:
2227:
2228: -- Cursor to check the Anticipated Key Program specified is of Anticipated Program Type or not
2229: CURSOR c_chk_prog (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2230: cp_program_type igf_ap_fa_ant_data.program_type%TYPE)
2231: IS
2232: SELECT 'x'
2233: FROM igs_ps_ver

Line 2230: cp_program_type igf_ap_fa_ant_data.program_type%TYPE)

2226:
2227:
2228: -- Cursor to check the Anticipated Key Program specified is of Anticipated Program Type or not
2229: CURSOR c_chk_prog (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2230: cp_program_type igf_ap_fa_ant_data.program_type%TYPE)
2231: IS
2232: SELECT 'x'
2233: FROM igs_ps_ver
2234: WHERE course_cd = cp_program_code

Line 2240: CURSOR c_chk_prog_offer (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,

2236:
2237: l_chk_prog c_chk_prog%ROWTYPE;
2238:
2239: -- Cursor to check Key Program at the specified Program Location
2240: CURSOR c_chk_prog_offer (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2241: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE)
2242: IS
2243: SELECT 'x'
2244: FROM igs_ps_ofr_opt_all offering

Line 2241: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE)

2237: l_chk_prog c_chk_prog%ROWTYPE;
2238:
2239: -- Cursor to check Key Program at the specified Program Location
2240: CURSOR c_chk_prog_offer (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2241: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE)
2242: IS
2243: SELECT 'x'
2244: FROM igs_ps_ofr_opt_all offering
2245: WHERE offering.course_cd = cp_program_code

Line 2253: CURSOR c_chk_prog_option (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,

2249:
2250:
2251: -- Cursor to check the existence of the program offering option for the combination of Key Program,
2252: -- Program Location, Anticipated Attendance Type and Anticipated Attendance Mode
2253: CURSOR c_chk_prog_option (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2254: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE,
2255: cp_attend_type igf_ap_fa_ant_data.attendance_type%TYPE,
2256: cp_attend_mode igf_ap_fa_ant_data.attendance_mode%TYPE)
2257: IS

Line 2254: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE,

2250:
2251: -- Cursor to check the existence of the program offering option for the combination of Key Program,
2252: -- Program Location, Anticipated Attendance Type and Anticipated Attendance Mode
2253: CURSOR c_chk_prog_option (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2254: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE,
2255: cp_attend_type igf_ap_fa_ant_data.attendance_type%TYPE,
2256: cp_attend_mode igf_ap_fa_ant_data.attendance_mode%TYPE)
2257: IS
2258: SELECT 'x'

Line 2255: cp_attend_type igf_ap_fa_ant_data.attendance_type%TYPE,

2251: -- Cursor to check the existence of the program offering option for the combination of Key Program,
2252: -- Program Location, Anticipated Attendance Type and Anticipated Attendance Mode
2253: CURSOR c_chk_prog_option (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2254: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE,
2255: cp_attend_type igf_ap_fa_ant_data.attendance_type%TYPE,
2256: cp_attend_mode igf_ap_fa_ant_data.attendance_mode%TYPE)
2257: IS
2258: SELECT 'x'
2259: FROM igs_ps_ofr_opt_all offering,

Line 2256: cp_attend_mode igf_ap_fa_ant_data.attendance_mode%TYPE)

2252: -- Program Location, Anticipated Attendance Type and Anticipated Attendance Mode
2253: CURSOR c_chk_prog_option (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2254: cp_location_code igf_ap_fa_ant_data.program_location_cd%TYPE,
2255: cp_attend_type igf_ap_fa_ant_data.attendance_type%TYPE,
2256: cp_attend_mode igf_ap_fa_ant_data.attendance_mode%TYPE)
2257: IS
2258: SELECT 'x'
2259: FROM igs_ps_ofr_opt_all offering,
2260: igs_ps_ofr_pat offering_pattern