DBA Data[Home] [Help]

APPS.QLTTRAFB dependencies on FND_API

Line 284: null_num number := fnd_api.G_NULL_NUM;

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

Line 285: null_char varchar2(1) := fnd_api.G_NULL_char;

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

Line 286: null_date date := fnd_api.G_NULL_date;

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;

Line 476: null_num number := fnd_api.G_NULL_NUM;

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

Line 477: null_char varchar2(1) := fnd_api.G_NULL_char;

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:

Line 478: null_date date := fnd_api.G_NULL_date;

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.

Line 557: null_num number := fnd_api.G_NULL_NUM;

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

Line 558: null_char varchar2(1) := fnd_api.G_NULL_char;

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:

Line 559: null_date date := fnd_api.G_NULL_date;

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.