DBA Data[Home] [Help]

APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_PE_PERSID_GROUP

Line 1403: p_group_id igs_pe_persid_group.group_id%TYPE,

1399: retcode out NOCOPY number ,
1400: p_curr_acad_adm_cal VARCHAR2,
1401: p_future_acad_adm_cal VARCHAR2,
1402: p_application_type VARCHAR2,
1403: p_group_id igs_pe_persid_group.group_id%TYPE,
1404: p_application_id NUMBER,
1405: p_decision_date VARCHAR2,
1406: p_dec_maker_id igs_pe_person_base_v.person_id%TYPE,
1407: p_dec_reason_id IGS_AD_CODE_CLASSES.code_id%TYPE

Line 1435: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;

1431: TYPE c_pers_group_ref IS REF CURSOR;
1432: c_person_group c_pers_group_ref;
1433:
1434: lv_status VARCHAR2(1) ;
1435: lv_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
1436: lv_sql_stmt VARCHAR(32767) ;
1437:
1438:
1439: /* This cursor returns the application to be processed for a given combination of person_id, current calendars and future calendars */