APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_PS_APPL_INST_ALL

Line 1882: From IGS_AD_PS_APPL_INST_ALL

1878: x_message_data OUT NOCOPY VARCHAR2) AS
1879:
1880: Cursor c_course IS
1881: Select NOMINATED_COURSE_CD, SEQUENCE_NUMBER
1882: From IGS_AD_PS_APPL_INST_ALL
1883: Where PERSON_ID = p_person_id
1884: And ADMISSION_APPL_NUMBER = p_admission_appl_number;
1885:
1886: l_one_stop VARCHAR2(1);

Line 2142: From IGS_AD_PS_APPL_INST_ALL

2138: ******************************************************************/
2139:
2140: CURSOR c_course IS
2141: Select NOMINATED_COURSE_CD, SEQUENCE_NUMBER
2142: From IGS_AD_PS_APPL_INST_ALL
2143: Where PERSON_ID = p_person_id
2144: And ADMISSION_APPL_NUMBER = p_admission_appl_number;
2145:
2146: --tray Bug 2405076

Line 2323: From IGS_AD_PS_APPL_INST_ALL

2319: ******************************************************************/
2320:
2321: Cursor c_course IS
2322: Select NOMINATED_COURSE_CD, SEQUENCE_NUMBER
2323: From IGS_AD_PS_APPL_INST_ALL
2324: Where PERSON_ID = p_person_id
2325: And ADMISSION_APPL_NUMBER = p_admission_appl_number;
2326:
2327: --tray Bug 2405076

Line 2534: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;

2530: AND admission_appl_number = cp_admission_appl_number;
2531:
2532: Rec_IGS_AD_PS_APPL_Inst c_upd_acai_eqdo%ROWTYPE;
2533:
2534: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2535: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2536:
2537: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2538: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;

Line 2535: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;

2531:
2532: Rec_IGS_AD_PS_APPL_Inst c_upd_acai_eqdo%ROWTYPE;
2533:
2534: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2535: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2536:
2537: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2538: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2539: l_admission_process_type IGS_AD_APPL_ALL.s_admission_process_type%TYPE;

Line 2537: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;

2533:
2534: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2535: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2536:
2537: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2538: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2539: l_admission_process_type IGS_AD_APPL_ALL.s_admission_process_type%TYPE;
2540: lv_mode VARCHAR2(1) DEFAULT 'R';
2541:

Line 2538: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;

2534: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2535: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2536:
2537: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2538: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2539: l_admission_process_type IGS_AD_APPL_ALL.s_admission_process_type%TYPE;
2540: lv_mode VARCHAR2(1) DEFAULT 'R';
2541:
2542: l_sc_encoded_text VARCHAR2(4000);

Line 2770: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;

2766: FOR UPDATE OF acai.adm_outcome_status NOWAIT;
2767:
2768: Rec_IGS_AD_PS_APPL_Inst c_upd_acai_outcm%ROWTYPE;
2769:
2770: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2771: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2772:
2773: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2774: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;

Line 2771: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;

2767:
2768: Rec_IGS_AD_PS_APPL_Inst c_upd_acai_outcm%ROWTYPE;
2769:
2770: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2771: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2772:
2773: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2774: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2775:

Line 2773: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;

2769:
2770: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2771: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2772:
2773: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2774: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2775:
2776: lv_mode VARCHAR2(1) DEFAULT 'R';
2777:

Line 2774: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;

2770: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
2771: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2772:
2773: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2774: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2775:
2776: lv_mode VARCHAR2(1) DEFAULT 'R';
2777:
2778: l_sc_encoded_text VARCHAR2(4000);

Line 2993: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;

2989: FOR UPDATE OF acai.ADM_OFFER_RESP_STATUS NOWAIT;
2990:
2991: Rec_IGS_AD_PS_APPL_Inst c_upd_acai_resp%ROWTYPE;
2992:
2993: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2994:
2995: lv_mode VARCHAR2(1) DEFAULT 'R';
2996: BEGIN
2997:

Line 5787: FROM IGS_AD_PS_APPL_INST_ALL

5783: x_return_status OUT NOCOPY VARCHAR2,
5784: x_error_msg OUT NOCOPY VARCHAR2) IS
5785: CURSOR get_appl_inst_rowid(cp_person_id NUMBER,cp_admission_appl_number NUMBER) IS
5786: SELECT ROWID
5787: FROM IGS_AD_PS_APPL_INST_ALL
5788: WHERE person_id = cp_person_id
5789: AND ADMISSION_APPL_NUMBER = cp_admission_appl_number;
5790:
5791: l_select_access BOOLEAN;