DBA Data[Home] [Help]

APPS.IGS_PR_STDNT_PR_OU_PKG dependencies on IGS_GE_NUMBER

Line 1414: new_references.SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

1410: BEGIN
1411: IF Column_Name IS NULL THEN
1412: NULL;
1413: ELSIF UPPER (Column_name) = 'SEQUENCE_NUMBER' THEN
1414: new_references.SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1415: ELSIF UPPER (Column_name) = 'PRG_CI_SEQUENCE_NUMBER' THEN
1416: new_references.PRG_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1417: ELSIF UPPER (Column_name) = 'PRA_SEQUENCE_NUMBER' THEN
1418: new_references.PRA_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

Line 1416: new_references.PRG_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

1412: NULL;
1413: ELSIF UPPER (Column_name) = 'SEQUENCE_NUMBER' THEN
1414: new_references.SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1415: ELSIF UPPER (Column_name) = 'PRG_CI_SEQUENCE_NUMBER' THEN
1416: new_references.PRG_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1417: ELSIF UPPER (Column_name) = 'PRA_SEQUENCE_NUMBER' THEN
1418: new_references.PRA_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1419: ELSIF UPPER (Column_name) = 'PRO_SEQUENCE_NUMBER' THEN
1420: new_references.PRO_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

Line 1418: new_references.PRA_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

1414: new_references.SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1415: ELSIF UPPER (Column_name) = 'PRG_CI_SEQUENCE_NUMBER' THEN
1416: new_references.PRG_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1417: ELSIF UPPER (Column_name) = 'PRA_SEQUENCE_NUMBER' THEN
1418: new_references.PRA_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1419: ELSIF UPPER (Column_name) = 'PRO_SEQUENCE_NUMBER' THEN
1420: new_references.PRO_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1421: ELSIF UPPER (Column_name) = 'DURATION' THEN
1422: new_references.DURATION:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

Line 1420: new_references.PRO_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

1416: new_references.PRG_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1417: ELSIF UPPER (Column_name) = 'PRA_SEQUENCE_NUMBER' THEN
1418: new_references.PRA_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1419: ELSIF UPPER (Column_name) = 'PRO_SEQUENCE_NUMBER' THEN
1420: new_references.PRO_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1421: ELSIF UPPER (Column_name) = 'DURATION' THEN
1422: new_references.DURATION:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1423: ELSIF UPPER (Column_name) = 'DURATION_TYPE' THEN
1424: new_references.DURATION_TYPE:= COLUMN_VALUE ;

Line 1422: new_references.DURATION:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

1418: new_references.PRA_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1419: ELSIF UPPER (Column_name) = 'PRO_SEQUENCE_NUMBER' THEN
1420: new_references.PRO_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1421: ELSIF UPPER (Column_name) = 'DURATION' THEN
1422: new_references.DURATION:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
1423: ELSIF UPPER (Column_name) = 'DURATION_TYPE' THEN
1424: new_references.DURATION_TYPE:= COLUMN_VALUE ;
1425: ELSIF UPPER (Column_name) = 'DECISION_STATUS' THEN
1426: new_references.DECISION_STATUS:= COLUMN_VALUE ;

Line 1432: new_references.RESTRICTED_ENROLMENT_CP:= IGS_GE_NUMBER.to_num(COLUMN_VALUE);

1428: new_references.SHOW_CAUSE_OUTCOME_TYPE:= COLUMN_VALUE ;
1429: ELSIF UPPER (Column_name) = 'APPEAL_OUTCOME_TYPE' THEN
1430: new_references.APPEAL_OUTCOME_TYPE:= COLUMN_VALUE ;
1431: ELSIF UPPER (Column_name) = 'RESTRICTED_ENROLMENT_CP' THEN
1432: new_references.RESTRICTED_ENROLMENT_CP:= IGS_GE_NUMBER.to_num(COLUMN_VALUE);
1433: ELSIF UPPER (Column_name) = 'COURSE_CD' THEN
1434: new_references.COURSE_CD:= COLUMN_VALUE ;
1435: ELSIF UPPER (Column_name) = 'DECISION_ORG_UNIT_CD' THEN
1436: new_references.DECISION_ORG_UNIT_CD:= COLUMN_VALUE ;