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_PROFILE_MATCHING_PKG dependencies on IGF_AP_BATCH_AW_MAP

Line 21: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;

17: lv_record_status igf_ap_match_Details.record_status%TYPE;
18: g_force_add VARCHAR2(1);
19: g_create_inquiry VARCHAR2(1);
20: g_adm_source_type VARCHAR2(30);
21: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
22: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
23: g_match_code VARCHAR2(30);
24: g_school_code VARCHAR2(30);
25: g_rec_type VARCHAR2(1);

Line 22: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;

18: g_force_add VARCHAR2(1);
19: g_create_inquiry VARCHAR2(1);
20: g_adm_source_type VARCHAR2(30);
21: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
22: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;
23: g_match_code VARCHAR2(30);
24: g_school_code VARCHAR2(30);
25: g_rec_type VARCHAR2(1);
26: g_profile_year VARCHAR2(30);

Line 936: FROM igf_ap_css_interface iii, igf_ap_batch_aw_map ibm

932: || (reverse chronological order - newest change first)
933: */
934: CURSOR cur_css_interface ( pn_css_id NUMBER) IS
935: SELECT iii.*, ibm.ci_sequence_number, ibm.ci_cal_type
936: FROM igf_ap_css_interface iii, igf_ap_batch_aw_map ibm
937: WHERE iii.css_id = pn_css_id
938: AND TO_NUMBER(iii.academic_year) = ibm.css_academic_year ;
939:
940:

Line 4465: FROM igf_ap_batch_aw_map_all

4461: AND cal.sequence_number = x_ci_sequence_number;
4462:
4463: CURSOR c_profile(cp_cal_type VARCHAR2,cp_seq_number NUMBER) IS
4464: SELECT css_academic_year
4465: FROM igf_ap_batch_aw_map_all
4466: WHERE ci_cal_type = cp_cal_type
4467: AND ci_sequence_number = cp_seq_number;
4468:
4469: -- Get ci_cal_type,ci_sequence_number from IGF_AP_BATCH_AW_MAP which maps to academic year of

Line 4469: -- Get ci_cal_type,ci_sequence_number from IGF_AP_BATCH_AW_MAP which maps to academic year of

4465: FROM igf_ap_batch_aw_map_all
4466: WHERE ci_cal_type = cp_cal_type
4467: AND ci_sequence_number = cp_seq_number;
4468:
4469: -- Get ci_cal_type,ci_sequence_number from IGF_AP_BATCH_AW_MAP which maps to academic year of
4470: -- cur_css_interface.academic_year .
4471: CURSOR cur_batch_aw_map(lv_academic_year NUMBER) IS
4472: SELECT ci_cal_type,ci_sequence_number
4473: FROM igf_ap_batch_aw_map

Line 4473: FROM igf_ap_batch_aw_map

4469: -- Get ci_cal_type,ci_sequence_number from IGF_AP_BATCH_AW_MAP which maps to academic year of
4470: -- cur_css_interface.academic_year .
4471: CURSOR cur_batch_aw_map(lv_academic_year NUMBER) IS
4472: SELECT ci_cal_type,ci_sequence_number
4473: FROM igf_ap_batch_aw_map
4474: WHERE css_academic_year = lv_academic_year;
4475:
4476: -- Cursor to get the setup values from igf_ap_record_match
4477: CURSOR cur_setup_score(cp_match_code VARCHAR2) IS

Line 4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;

4482: lv_apm_id igf_ap_person_match.APM_ID%TYPE ;
4483: alt_code_rec cur_alt_code%ROWTYPE;
4484: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
4485: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
4486: l_profile_year igf_ap_batch_aw_map_all.css_academic_year%TYPE;
4487: l_profile c_profile%ROWTYPE;
4488: INVALID_PARAMETER EXCEPTION;
4489:
4490: BEGIN

Line 4764: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS

4760: SELECT apm_id
4761: FROM igf_ap_person_match
4762: WHERE css_id = cp_css_id;
4763:
4764: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4765: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
4766: FROM IGF_AP_BATCH_AW_MAP ibm
4767: WHERE ibm.batch_year = cp_batch_year;
4768:

Line 4766: FROM IGF_AP_BATCH_AW_MAP ibm

4762: WHERE css_id = cp_css_id;
4763:
4764: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4765: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
4766: FROM IGF_AP_BATCH_AW_MAP ibm
4767: WHERE ibm.batch_year = cp_batch_year;
4768:
4769: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
4770:

Line 4830: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS

4826: p_match_code IN VARCHAR2,
4827: p_batch_year IN NUMBER
4828: ) IS
4829:
4830: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4831: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
4832: FROM IGF_AP_BATCH_AW_MAP ibm
4833: WHERE ibm.batch_year = cp_batch_year;
4834:

Line 4832: FROM IGF_AP_BATCH_AW_MAP ibm

4828: ) IS
4829:
4830: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4831: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
4832: FROM IGF_AP_BATCH_AW_MAP ibm
4833: WHERE ibm.batch_year = cp_batch_year;
4834:
4835: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
4836:

Line 4903: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS

4899: PROCEDURE ss_wrap_create_base_record ( p_css_id IN NUMBER,
4900: p_person_id IN NUMBER,
4901: p_batch_year IN NUMBER)
4902: AS
4903: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4904: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
4905: FROM IGF_AP_BATCH_AW_MAP ibm
4906: WHERE ibm.batch_year = cp_batch_year;
4907: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;

Line 4905: FROM IGF_AP_BATCH_AW_MAP ibm

4901: p_batch_year IN NUMBER)
4902: AS
4903: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
4904: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
4905: FROM IGF_AP_BATCH_AW_MAP ibm
4906: WHERE ibm.batch_year = cp_batch_year;
4907: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
4908:
4909: CURSOR cur_css_interface(cp_css_id IN NUMBER) IS

Line 5042: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS

5038: SELECT prof.base_id
5039: FROM IGF_AP_CSS_PROFILE prof
5040: WHERE prof.css_id_number = cp_css_id_number;
5041:
5042: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
5043: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
5044: FROM IGF_AP_BATCH_AW_MAP ibm
5045: WHERE ibm.batch_year = cp_batch_year;
5046:

Line 5044: FROM IGF_AP_BATCH_AW_MAP ibm

5040: WHERE prof.css_id_number = cp_css_id_number;
5041:
5042: CURSOR cur_get_cal_sequence (cp_batch_year igf_ap_batch_aw_map.batch_year%TYPE) IS
5043: SELECT ibm.ci_cal_type, ibm.ci_sequence_number
5044: FROM IGF_AP_BATCH_AW_MAP ibm
5045: WHERE ibm.batch_year = cp_batch_year;
5046:
5047: rec_get_cal_sequence cur_get_cal_sequence%ROWTYPE;
5048: