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.IGS_ADMAPPLICATION_PUB dependencies on IGS_AD_APPL

Line 1: PACKAGE BODY igs_admapplication_pub AS

1: PACKAGE BODY igs_admapplication_pub AS
2: /* $Header: IGSPAPPB.pls 120.16 2006/09/22 13:21:43 pbondugu noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2 (30):='IGS_ADMAPPLICATION_PUB';
4:
5: PROCEDURE check_length(p_param_name IN VARCHAR2, p_table_name IN VARCHAR2, p_param_length IN NUMBER) AS

Line 3: G_PKG_NAME CONSTANT VARCHAR2 (30):='IGS_ADMAPPLICATION_PUB';

1: PACKAGE BODY igs_admapplication_pub AS
2: /* $Header: IGSPAPPB.pls 120.16 2006/09/22 13:21:43 pbondugu noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2 (30):='IGS_ADMAPPLICATION_PUB';
4:
5: PROCEDURE check_length(p_param_name IN VARCHAR2, p_table_name IN VARCHAR2, p_param_length IN NUMBER) AS
6: CURSOR c_col_length IS
7: SELECT WIDTH , precision , column_type ,scale

Line 427: FROM IGS_AD_APPL a

423: ) AS
424:
425: CURSOR c_appl_cur IS
426: SELECT a.ROWID, a.*
427: FROM IGS_AD_APPL a
428: WHERE person_id = p_person_id
429: AND admission_appl_number = p_admission_appl_number;
430: l_c_appl_cur c_appl_cur%ROWTYPE;
431:

Line 1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,

1306: ---------------------------------------------------------------------------------------------------------------------------------------
1307:
1308:
1309: -- to get the one application row
1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1312: SELECT appl.*
1313: FROM igs_ad_appl_all appl
1314: WHERE person_id = cp_person_id AND

Line 1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

1307:
1308:
1309: -- to get the one application row
1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1312: SELECT appl.*
1313: FROM igs_ad_appl_all appl
1314: WHERE person_id = cp_person_id AND
1315: admission_appl_number = cp_admission_appl_number;

Line 1313: FROM igs_ad_appl_all appl

1309: -- to get the one application row
1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1312: SELECT appl.*
1313: FROM igs_ad_appl_all appl
1314: WHERE person_id = cp_person_id AND
1315: admission_appl_number = cp_admission_appl_number;
1316:
1317: -- to get teh application instance

Line 1360: v_admission_cat igs_ad_appl.admission_cat%TYPE;

1356: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
1357: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
1358:
1359:
1360: v_admission_cat igs_ad_appl.admission_cat%TYPE;
1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

Line 1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;

1357: cst_not_applic CONSTANT VARCHAR2(10) := 'NOT-APPLIC';
1358:
1359:
1360: v_admission_cat igs_ad_appl.admission_cat%TYPE;
1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

Line 1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

1358:
1359:
1360: v_admission_cat igs_ad_appl.admission_cat%TYPE;
1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;

Line 1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;

1359:
1360: v_admission_cat igs_ad_appl.admission_cat%TYPE;
1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;

Line 1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

1360: v_admission_cat igs_ad_appl.admission_cat%TYPE;
1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

Line 1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

1361: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

Line 1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;

Line 1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;

1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;

Line 1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;

1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
1374: l_application_id igs_ad_appl_all.application_id%TYPE;

Line 1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
1374: l_application_id igs_ad_appl_all.application_id%TYPE;
1375: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

Line 1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;

1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
1374: l_application_id igs_ad_appl_all.application_id%TYPE;
1375: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1376: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;

Line 1374: l_application_id igs_ad_appl_all.application_id%TYPE;

1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
1374: l_application_id igs_ad_appl_all.application_id%TYPE;
1375: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1376: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
1377: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
1378: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;

Line 2450: FROM igs_ad_appl_all appl

2446: CURSOR c_appl (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
2447: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
2448: IS
2449: SELECT appl.s_admission_process_type
2450: FROM igs_ad_appl_all appl
2451: WHERE appl.person_id = cp_person_id
2452: AND appl.admission_appl_number = cp_admission_appl_number;
2453:
2454: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

Line 2454: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

2450: FROM igs_ad_appl_all appl
2451: WHERE appl.person_id = cp_person_id
2452: AND appl.admission_appl_number = cp_admission_appl_number;
2453:
2454: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
2455:
2456: BEGIN
2457: l_msg_index := 0;
2458: SAVEPOINT UPDATE_ENTRY_QUAL_STATUS_SAVE;

Line 2775: END igs_admapplication_pub;

2771:
2772: END UPDATE_ENTRY_QUAL_STATUS;
2773:
2774:
2775: END igs_admapplication_pub;