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.

[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_OU_STAT

Line 214: CURSOR cur_s_adm_ou_stat(p_adm_out_status IGS_AD_OU_STAT.ADM_OUTCOME_STATUS%TYPE) IS

210: cur_ou_mapping_rec cur_ou_mapping%ROWTYPE;
211:
212: -- Cursor to fetch the System Admission Outcome status of the
213: -- current OSS Application Instance outcome status
214: CURSOR cur_s_adm_ou_stat(p_adm_out_status IGS_AD_OU_STAT.ADM_OUTCOME_STATUS%TYPE) IS
215: SELECT s_adm_outcome_status
216: FROM igs_ad_ou_stat
217: WHERE adm_outcome_status = p_adm_out_status;
218: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;

Line 216: FROM igs_ad_ou_stat

212: -- Cursor to fetch the System Admission Outcome status of the
213: -- current OSS Application Instance outcome status
214: CURSOR cur_s_adm_ou_stat(p_adm_out_status IGS_AD_OU_STAT.ADM_OUTCOME_STATUS%TYPE) IS
215: SELECT s_adm_outcome_status
216: FROM igs_ad_ou_stat
217: WHERE adm_outcome_status = p_adm_out_status;
218: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;
219:
220: -- Cursor to find the the value of Reconsideration Flag

Line 330: l_app_inst_sys_adm_ou_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

326: l_apc_det_rec cur_apc_det%ROWTYPE;
327:
328: -- Define the Local Variables
329: l_conc_request_id NUMBER(15);
330: l_app_inst_sys_adm_ou_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
331: l_oss_ou_status_of_app_choice igs_ad_ou_stat.adm_outcome_status%TYPE;
332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;
333:
334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

Line 331: l_oss_ou_status_of_app_choice igs_ad_ou_stat.adm_outcome_status%TYPE;

327:
328: -- Define the Local Variables
329: l_conc_request_id NUMBER(15);
330: l_app_inst_sys_adm_ou_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
331: l_oss_ou_status_of_app_choice igs_ad_ou_stat.adm_outcome_status%TYPE;
332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;
333:
334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
335: l_deffered_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;

Line 1608: CURSOR cur_s_adm_ou_stat(p_adm_out_status igs_ad_ou_stat.adm_outcome_status%TYPE) IS

1604: cur_map_offr_resp_rec cur_map_offr_resp%ROWTYPE;
1605:
1606: -- Cursor to fetch the System Admission Outcome status of the
1607: -- current OSS Application Instance outcome status
1608: CURSOR cur_s_adm_ou_stat(p_adm_out_status igs_ad_ou_stat.adm_outcome_status%TYPE) IS
1609: SELECT s_adm_outcome_status
1610: FROM igs_ad_ou_stat
1611: WHERE adm_outcome_status = p_adm_out_status;
1612: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;

Line 1610: FROM igs_ad_ou_stat

1606: -- Cursor to fetch the System Admission Outcome status of the
1607: -- current OSS Application Instance outcome status
1608: CURSOR cur_s_adm_ou_stat(p_adm_out_status igs_ad_ou_stat.adm_outcome_status%TYPE) IS
1609: SELECT s_adm_outcome_status
1610: FROM igs_ad_ou_stat
1611: WHERE adm_outcome_status = p_adm_out_status;
1612: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;
1613:
1614: -- Cursor to Fetch the Application Choices of export to OSS status 'RP'