APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_DOC_STAT

Line 216: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;

212: BEGIN -- admp_val_acai_ads
213: -- Validate the IGS_AD_PS_APPL_INST.adm_doc_status.
214: DECLARE
215: v_message_name VARCHAR2(30);
216: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
217: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
218: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
219: BEGIN
220: -- Set the default message number

Line 270: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;

266: -- Validate the IGS_AD_PS_APPL_INST.adm_doc_status,
267: -- It must be open and valid
268: DECLARE
269: v_message_name VARCHAR2(30);
270: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
271: BEGIN
272: -- Set the default message number
273: p_message_name := NULL;
274: -- Validate the closed indicator

Line 304: -- Validate if IGS_AD_DOC_STAT.adm_doc_status is closed.

300: RETURN TRUE;
301: END;
302: END admp_val_ads_item;
303: --
304: -- Validate if IGS_AD_DOC_STAT.adm_doc_status is closed.
305: FUNCTION admp_val_ads_closed(
306: p_adm_doc_status IN VARCHAR2 ,
307: p_message_name OUT NOCOPY VARCHAR2 )
308: RETURN BOOLEAN AS

Line 310: -- Validate the IGS_AD_DOC_STAT closed indicator

306: p_adm_doc_status IN VARCHAR2 ,
307: p_message_name OUT NOCOPY VARCHAR2 )
308: RETURN BOOLEAN AS
309: BEGIN -- admp_val_ads_closed
310: -- Validate the IGS_AD_DOC_STAT closed indicator
311: DECLARE
312: CURSOR c_ads(
313: cp_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE) IS
314: SELECT closed_ind

Line 313: cp_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE) IS

309: BEGIN -- admp_val_ads_closed
310: -- Validate the IGS_AD_DOC_STAT closed indicator
311: DECLARE
312: CURSOR c_ads(
313: cp_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE) IS
314: SELECT closed_ind
315: FROM IGS_AD_DOC_STAT
316: WHERE adm_doc_status = cp_adm_doc_status;
317: v_ads_rec c_ads%ROWTYPE;

Line 315: FROM IGS_AD_DOC_STAT

311: DECLARE
312: CURSOR c_ads(
313: cp_adm_doc_status IGS_AD_DOC_STAT.adm_doc_status%TYPE) IS
314: SELECT closed_ind
315: FROM IGS_AD_DOC_STAT
316: WHERE adm_doc_status = cp_adm_doc_status;
317: v_ads_rec c_ads%ROWTYPE;
318: cst_yes CONSTANT CHAR := 'Y';
319: BEGIN

Line 1599: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;

1595: cst_trg_as CONSTANT VARCHAR2(6) := 'TRG_AS';
1596: v_message_name VARCHAR2(30);
1597: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1598: v_old_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
1599: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
1600: v_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1601: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
1602: v_s_adm_entry_qual_status igs_ad_ent_qf_stat.s_adm_entry_qual_status%TYPE;
1603: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;

Line 2975: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;

2971: v_message_name VARCHAR2(30);
2972: v_s_adm_cndtnl_offer_status igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
2973: v_old_s_adm_cndtnl_offer_stat igs_ad_cndnl_ofrstat.s_adm_cndtnl_offer_status%TYPE;
2974: v_s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
2975: v_s_adm_doc_status igs_ad_doc_stat.s_adm_doc_status%TYPE;
2976: v_late_s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE;
2977: BEGIN
2978: --set the default message number
2979: p_message_name := NULL;