[Home] [Help]
14: x_score_report_date IN DATE DEFAULT NULL,
15: x_edu_level_id IN NUMBER DEFAULT NULL,
16: x_score_type IN VARCHAR2 DEFAULT NULL,
17: x_score_source_id IN NUMBER DEFAULT NULL,
18: x_non_standard_admin IN VARCHAR2 DEFAULT NULL,
19: x_comp_test_score IN NUMBER DEFAULT NULL,
20: x_special_code IN VARCHAR2 DEFAULT NULL,
21: x_registration_number IN VARCHAR2 DEFAULT NULL,
22: x_grade_id IN NUMBER DEFAULT NULL,
107: new_references.score_type := l_score_type;
108: END IF;
109:
110: new_references.score_source_id := x_score_source_id;
111: new_references.non_standard_admin := x_non_standard_admin;
112: new_references.comp_test_score := x_comp_test_score;
113: new_references.special_code := x_special_code;
114: new_references.registration_number := x_registration_number;
115: new_references.grade_id := x_grade_id;
172: new_references.test_date := IGS_GE_DATE.IGSDATE(column_value);
173: ELSIF UPPER(column_name) = 'SCORE_REPORT_DATE' THEN
174: -- l_column_value := tochar( todate ( column_value, 'DD/MM/YYYY'), 'YYYY/MM/DD');
175: new_references.score_report_date := IGS_GE_DATE.IGSDATE(l_column_value);
176: ELSIF UPPER(column_name) = 'NON_STANDARD_ADMIN' THEN
177: new_references.non_standard_admin := column_value;
178: NULL;
179: END IF;
180:
173: ELSIF UPPER(column_name) = 'SCORE_REPORT_DATE' THEN
174: -- l_column_value := tochar( todate ( column_value, 'DD/MM/YYYY'), 'YYYY/MM/DD');
175: new_references.score_report_date := IGS_GE_DATE.IGSDATE(l_column_value);
176: ELSIF UPPER(column_name) = 'NON_STANDARD_ADMIN' THEN
177: new_references.non_standard_admin := column_value;
178: NULL;
179: END IF;
180:
181: -- The following code checks for check constraints on the Columns.
191: END IF;
192: END IF;
193:
194: -- The following code checks for check constraints on the Columns.
195: IF Upper(Column_Name) = 'NON_STANDARD_ADMIN' OR
196: Column_Name IS NULL THEN
197: IF NOT (new_references.non_standard_admin in ('Y','N')) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NON_STANDARD_ADMIN'));
193:
194: -- The following code checks for check constraints on the Columns.
195: IF Upper(Column_Name) = 'NON_STANDARD_ADMIN' OR
196: Column_Name IS NULL THEN
197: IF NOT (new_references.non_standard_admin in ('Y','N')) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NON_STANDARD_ADMIN'));
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
195: IF Upper(Column_Name) = 'NON_STANDARD_ADMIN' OR
196: Column_Name IS NULL THEN
197: IF NOT (new_references.non_standard_admin in ('Y','N')) THEN
198: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_NON_STANDARD_ADMIN'));
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
612: x_score_report_date IN DATE DEFAULT NULL,
613: x_edu_level_id IN NUMBER DEFAULT NULL,
614: x_score_type IN VARCHAR2 DEFAULT NULL,
615: x_score_source_id IN NUMBER DEFAULT NULL,
616: x_non_standard_admin IN VARCHAR2 DEFAULT NULL,
617: x_comp_test_score IN NUMBER DEFAULT NULL,
618: x_special_code IN VARCHAR2 DEFAULT NULL,
619: x_registration_number IN VARCHAR2 DEFAULT NULL,
620: x_grade_id IN NUMBER DEFAULT NULL,
670: x_score_report_date,
671: x_edu_level_id,
672: x_score_type,
673: x_score_source_id,
674: x_non_standard_admin,
675: x_comp_test_score,
676: x_special_code,
677: x_registration_number,
678: x_grade_id,
806: x_SCORE_REPORT_DATE IN DATE,
807: x_EDU_LEVEL_ID IN NUMBER,
808: x_SCORE_TYPE IN VARCHAR2,
809: x_SCORE_SOURCE_ID IN NUMBER,
810: x_NON_STANDARD_ADMIN IN VARCHAR2,
811: x_COMP_TEST_SCORE IN NUMBER,
812: x_SPECIAL_CODE IN VARCHAR2,
813: x_REGISTRATION_NUMBER IN VARCHAR2,
814: x_GRADE_ID IN NUMBER,
845: Who When What
846:
847: RAVISHAR Feb,25 2005 Removed the default value of X_MODE parameter from
848: body of this package for bug 4163319
849: GSCC standard says that default value should be
850: present only in specification
851:
852: (reverse chronological order - newest change first)
853: pbondugu 03-04-2003 For test_date and score_report_date trunc of those fileds are inserted into tables.
908: x_score_report_date=>X_SCORE_REPORT_DATE,
909: x_edu_level_id=>X_EDU_LEVEL_ID,
910: x_score_type=>X_SCORE_TYPE,
911: x_score_source_id=>X_SCORE_SOURCE_ID,
912: x_non_standard_admin=>X_NON_STANDARD_ADMIN,
913: x_comp_test_score=>X_COMP_TEST_SCORE,
914: x_special_code=>X_SPECIAL_CODE,
915: x_registration_number=>X_REGISTRATION_NUMBER,
916: x_grade_id=>X_GRADE_ID,
952: ,SCORE_REPORT_DATE
953: ,EDU_LEVEL_ID
954: ,SCORE_TYPE
955: ,SCORE_SOURCE_ID
956: ,NON_STANDARD_ADMIN
957: ,COMP_TEST_SCORE
958: ,SPECIAL_CODE
959: ,REGISTRATION_NUMBER
960: ,GRADE_ID
997: ,NEW_REFERENCES.SCORE_REPORT_DATE
998: ,NEW_REFERENCES.EDU_LEVEL_ID
999: ,NEW_REFERENCES.SCORE_TYPE
1000: ,NEW_REFERENCES.SCORE_SOURCE_ID
1001: ,NEW_REFERENCES.NON_STANDARD_ADMIN
1002: ,NEW_REFERENCES.COMP_TEST_SCORE
1003: ,NEW_REFERENCES.SPECIAL_CODE
1004: ,NEW_REFERENCES.REGISTRATION_NUMBER
1005: ,NEW_REFERENCES.GRADE_ID
1074: x_SCORE_REPORT_DATE IN DATE,
1075: x_EDU_LEVEL_ID IN NUMBER,
1076: x_SCORE_TYPE IN VARCHAR2,
1077: x_SCORE_SOURCE_ID IN NUMBER,
1078: x_NON_STANDARD_ADMIN IN VARCHAR2,
1079: x_COMP_TEST_SCORE IN NUMBER,
1080: x_SPECIAL_CODE IN VARCHAR2,
1081: x_REGISTRATION_NUMBER IN VARCHAR2,
1082: x_GRADE_ID IN NUMBER,
1121: , SCORE_REPORT_DATE
1122: , EDU_LEVEL_ID
1123: , SCORE_TYPE
1124: , SCORE_SOURCE_ID
1125: , NON_STANDARD_ADMIN
1126: , COMP_TEST_SCORE
1127: , SPECIAL_CODE
1128: , REGISTRATION_NUMBER
1129: , GRADE_ID
1178: AND (X_SCORE_TYPE is null)))
1179: AND ((tlinfo.SCORE_SOURCE_ID = X_SCORE_SOURCE_ID)
1180: OR ((tlinfo.SCORE_SOURCE_ID is null)
1181: AND (X_SCORE_SOURCE_ID is null)))
1182: AND ((tlinfo.NON_STANDARD_ADMIN = X_NON_STANDARD_ADMIN)
1183: OR ((tlinfo.NON_STANDARD_ADMIN is null)
1184: AND (X_NON_STANDARD_ADMIN is null)))
1185: AND ((tlinfo.COMP_TEST_SCORE = X_COMP_TEST_SCORE)
1186: OR ((tlinfo.COMP_TEST_SCORE is null)
1179: AND ((tlinfo.SCORE_SOURCE_ID = X_SCORE_SOURCE_ID)
1180: OR ((tlinfo.SCORE_SOURCE_ID is null)
1181: AND (X_SCORE_SOURCE_ID is null)))
1182: AND ((tlinfo.NON_STANDARD_ADMIN = X_NON_STANDARD_ADMIN)
1183: OR ((tlinfo.NON_STANDARD_ADMIN is null)
1184: AND (X_NON_STANDARD_ADMIN is null)))
1185: AND ((tlinfo.COMP_TEST_SCORE = X_COMP_TEST_SCORE)
1186: OR ((tlinfo.COMP_TEST_SCORE is null)
1187: AND (X_COMP_TEST_SCORE is null)))
1180: OR ((tlinfo.SCORE_SOURCE_ID is null)
1181: AND (X_SCORE_SOURCE_ID is null)))
1182: AND ((tlinfo.NON_STANDARD_ADMIN = X_NON_STANDARD_ADMIN)
1183: OR ((tlinfo.NON_STANDARD_ADMIN is null)
1184: AND (X_NON_STANDARD_ADMIN is null)))
1185: AND ((tlinfo.COMP_TEST_SCORE = X_COMP_TEST_SCORE)
1186: OR ((tlinfo.COMP_TEST_SCORE is null)
1187: AND (X_COMP_TEST_SCORE is null)))
1188: AND ((tlinfo.SPECIAL_CODE = X_SPECIAL_CODE)
1278: x_SCORE_REPORT_DATE IN DATE,
1279: x_EDU_LEVEL_ID IN NUMBER,
1280: x_SCORE_TYPE IN VARCHAR2,
1281: x_SCORE_SOURCE_ID IN NUMBER,
1282: x_NON_STANDARD_ADMIN IN VARCHAR2,
1283: x_COMP_TEST_SCORE IN NUMBER,
1284: x_SPECIAL_CODE IN VARCHAR2,
1285: x_REGISTRATION_NUMBER IN VARCHAR2,
1286: x_GRADE_ID IN NUMBER,
1318:
1319: (reverse chronological order - newest change first)
1320: RAVISHAR Feb,25 2005 Removed the default value of X_MODE parameter from
1321: body of this package for bug 4163319
1322: GSCC standard says that default value should be
1323: present only in specification
1324:
1325: pbondugu 03-04-2003 For test_date and score_report_date trunc of those fileds are updated into table.
1326:
1364: x_score_report_date=>X_SCORE_REPORT_DATE,
1365: x_edu_level_id=>X_EDU_LEVEL_ID,
1366: x_score_type=>X_SCORE_TYPE,
1367: x_score_source_id=>X_SCORE_SOURCE_ID,
1368: x_non_standard_admin=>X_NON_STANDARD_ADMIN,
1369: x_comp_test_score=>X_COMP_TEST_SCORE,
1370: x_special_code=>X_SPECIAL_CODE,
1371: x_registration_number=>X_REGISTRATION_NUMBER,
1372: x_grade_id=>X_GRADE_ID,
1422: SCORE_REPORT_DATE = NEW_REFERENCES.SCORE_REPORT_DATE,
1423: EDU_LEVEL_ID = NEW_REFERENCES.EDU_LEVEL_ID,
1424: SCORE_TYPE = NEW_REFERENCES.SCORE_TYPE,
1425: SCORE_SOURCE_ID = NEW_REFERENCES.SCORE_SOURCE_ID,
1426: NON_STANDARD_ADMIN = NEW_REFERENCES.NON_STANDARD_ADMIN,
1427: COMP_TEST_SCORE = NEW_REFERENCES.COMP_TEST_SCORE,
1428: SPECIAL_CODE = NEW_REFERENCES.SPECIAL_CODE,
1429: REGISTRATION_NUMBER = NEW_REFERENCES.REGISTRATION_NUMBER,
1430: GRADE_ID = NEW_REFERENCES.GRADE_ID,
1496: x_SCORE_REPORT_DATE IN DATE,
1497: x_EDU_LEVEL_ID IN NUMBER,
1498: x_SCORE_TYPE IN VARCHAR2,
1499: x_SCORE_SOURCE_ID IN NUMBER,
1500: x_NON_STANDARD_ADMIN IN VARCHAR2,
1501: x_COMP_TEST_SCORE IN NUMBER,
1502: x_SPECIAL_CODE IN VARCHAR2,
1503: x_REGISTRATION_NUMBER IN VARCHAR2,
1504: x_GRADE_ID IN NUMBER,
1535: Who When What
1536: (reverse chronological order - newest change first)
1537: RAVISHAR Feb,25 2005 Removed the default value of X_MODE parameter from
1538: body of this package for bug 4163319
1539: GSCC standard says that default value should be
1540: present only in specification
1541: ***************************************************************/
1542:
1543: cursor c1 is select ROWID from IGS_AD_TEST_RESULTS
1559: X_SCORE_REPORT_DATE,
1560: X_EDU_LEVEL_ID,
1561: X_SCORE_TYPE,
1562: X_SCORE_SOURCE_ID,
1563: X_NON_STANDARD_ADMIN,
1564: X_COMP_TEST_SCORE,
1565: X_SPECIAL_CODE,
1566: X_REGISTRATION_NUMBER,
1567: X_GRADE_ID,
1600: X_SCORE_REPORT_DATE,
1601: X_EDU_LEVEL_ID,
1602: X_SCORE_TYPE,
1603: X_SCORE_SOURCE_ID,
1604: X_NON_STANDARD_ADMIN,
1605: X_COMP_TEST_SCORE,
1606: X_SPECIAL_CODE,
1607: X_REGISTRATION_NUMBER,
1608: X_GRADE_ID,