280:
281:
282: FUNCTION VALIDATE_TYPE (X_VALUE VARCHAR2, X_DATATYPE NUMBER) RETURN BOOLEAN IS
283: -- bug 10212823
284: null_num number := fnd_api.G_NULL_NUM;
285: null_char varchar2(1) := fnd_api.G_NULL_char;
286: null_date date := fnd_api.G_NULL_date;
287: BEGIN
288: --bug 10212823
281:
282: FUNCTION VALIDATE_TYPE (X_VALUE VARCHAR2, X_DATATYPE NUMBER) RETURN BOOLEAN IS
283: -- bug 10212823
284: null_num number := fnd_api.G_NULL_NUM;
285: null_char varchar2(1) := fnd_api.G_NULL_char;
286: null_date date := fnd_api.G_NULL_date;
287: BEGIN
288: --bug 10212823
289: IF (X_VALUE IN (to_char(null_num), null_char, to_char(null_date))) THEN
282: FUNCTION VALIDATE_TYPE (X_VALUE VARCHAR2, X_DATATYPE NUMBER) RETURN BOOLEAN IS
283: -- bug 10212823
284: null_num number := fnd_api.G_NULL_NUM;
285: null_char varchar2(1) := fnd_api.G_NULL_char;
286: null_date date := fnd_api.G_NULL_date;
287: BEGIN
288: --bug 10212823
289: IF (X_VALUE IN (to_char(null_num), null_char, to_char(null_date))) THEN
290: RETURN TRUE;
472: l_col3 VARCHAR2(100);
473: l_col4 VARCHAR2(100);
474: l_col5 VARCHAR2(100);
475:
476: null_num number := fnd_api.G_NULL_NUM;
477: null_char varchar2(1) := fnd_api.G_NULL_char;
478: null_date date := fnd_api.G_NULL_date;
479:
480: BEGIN
473: l_col4 VARCHAR2(100);
474: l_col5 VARCHAR2(100);
475:
476: null_num number := fnd_api.G_NULL_NUM;
477: null_char varchar2(1) := fnd_api.G_NULL_char;
478: null_date date := fnd_api.G_NULL_date;
479:
480: BEGIN
481:
474: l_col5 VARCHAR2(100);
475:
476: null_num number := fnd_api.G_NULL_NUM;
477: null_char varchar2(1) := fnd_api.G_NULL_char;
478: null_date date := fnd_api.G_NULL_date;
479:
480: BEGIN
481:
482: -- Bug 3136107.
553: l_col3 VARCHAR2(100);
554: l_col4 VARCHAR2(100);
555: l_col5 VARCHAR2(100);
556:
557: null_num number := fnd_api.G_NULL_NUM;
558: null_char varchar2(1) := fnd_api.G_NULL_char;
559: null_date date := fnd_api.G_NULL_date;
560:
561: BEGIN
554: l_col4 VARCHAR2(100);
555: l_col5 VARCHAR2(100);
556:
557: null_num number := fnd_api.G_NULL_NUM;
558: null_char varchar2(1) := fnd_api.G_NULL_char;
559: null_date date := fnd_api.G_NULL_date;
560:
561: BEGIN
562:
555: l_col5 VARCHAR2(100);
556:
557: null_num number := fnd_api.G_NULL_NUM;
558: null_char varchar2(1) := fnd_api.G_NULL_char;
559: null_date date := fnd_api.G_NULL_date;
560:
561: BEGIN
562:
563: -- Bug 3136107.