APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_GEN_013

Line 1069: l_new_sys_stat := igs_ad_gen_013.get_sys_code_status(new_references.final_decision_code, new_references.final_decision_type);

1065: -- Raise the Business event when the Final Screening/Interview Decision of the Panel is modified.
1066: -- When both the Decision Date and the Final Screening Decision record is committed
1067: -- and the Final Screening Decision has changed from the system final screening decision
1068: -- of 'Pending' to any other system final screening decision.
1069: l_new_sys_stat := igs_ad_gen_013.get_sys_code_status(new_references.final_decision_code, new_references.final_decision_type);
1070: l_old_sys_stat := igs_ad_gen_013.get_sys_code_status(old_references.final_decision_code, old_references.final_decision_type);
1071: IF l_old_sys_stat = 'PENDING' AND l_new_sys_stat <> 'PENDING' THEN
1072: OPEN c_panel_type;
1073: FETCH c_panel_type INTO l_panel_type; -- 'SCREENING', 'INTERVIEW'

Line 1070: l_old_sys_stat := igs_ad_gen_013.get_sys_code_status(old_references.final_decision_code, old_references.final_decision_type);

1066: -- When both the Decision Date and the Final Screening Decision record is committed
1067: -- and the Final Screening Decision has changed from the system final screening decision
1068: -- of 'Pending' to any other system final screening decision.
1069: l_new_sys_stat := igs_ad_gen_013.get_sys_code_status(new_references.final_decision_code, new_references.final_decision_type);
1070: l_old_sys_stat := igs_ad_gen_013.get_sys_code_status(old_references.final_decision_code, old_references.final_decision_type);
1071: IF l_old_sys_stat = 'PENDING' AND l_new_sys_stat <> 'PENDING' THEN
1072: OPEN c_panel_type;
1073: FETCH c_panel_type INTO l_panel_type; -- 'SCREENING', 'INTERVIEW'
1074: CLOSE c_panel_type;