APPS.IGS_AD_WF_P2A dependencies on IGS_AD_CODE_CLASSES

Line 106: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;

102:
103: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;
104: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;
105: l_seq_val NUMBER;
106: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;
107:
108: l_return_status VARCHAR2(3);
109: l_msg_count NUMBER;
110: l_msg_data VARCHAR2(2000);

Line 784: CURSOR c_source_id (cp_source IGS_AD_CODE_CLASSES.system_status%TYPE) IS

780: actid in NUMBER ,
781: funcmode in VARCHAR2 ,
782: resultout OUT NOCOPY VARCHAR2 ) IS
783:
784: CURSOR c_source_id (cp_source IGS_AD_CODE_CLASSES.system_status%TYPE) IS
785: SELECT code_id
786: FROM igs_ad_code_classes
787: WHERE upper(system_status) = cp_source
788: and class = 'SYS_APPL_SOURCE' and system_default = 'Y'

Line 786: FROM igs_ad_code_classes

782: resultout OUT NOCOPY VARCHAR2 ) IS
783:
784: CURSOR c_source_id (cp_source IGS_AD_CODE_CLASSES.system_status%TYPE) IS
785: SELECT code_id
786: FROM igs_ad_code_classes
787: WHERE upper(system_status) = cp_source
788: and class = 'SYS_APPL_SOURCE' and system_default = 'Y'
789: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
790:

Line 792: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;

788: and class = 'SYS_APPL_SOURCE' and system_default = 'Y'
789: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
790:
791: l_login_role VARCHAR2(30);
792: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;
793: l_app_source IGS_AD_CODE_CLASSES.system_status%TYPE;
794:
795: BEGIN
796:

Line 793: l_app_source IGS_AD_CODE_CLASSES.system_status%TYPE;

789: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';
790:
791: l_login_role VARCHAR2(30);
792: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;
793: l_app_source IGS_AD_CODE_CLASSES.system_status%TYPE;
794:
795: BEGIN
796:
797: l_appl_source_id := NULL;