eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_QUAL_TYPES_PKG dependencies on FND_API

Line 56: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

52: RELATED_ID5,
53: ORG_ID
54: ) VALUES (
55: x_QUAL_TYPE_ID,
56: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

53: ORG_ID
54: ) VALUES (
55: x_QUAL_TYPE_ID,
56: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),

Line 58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

54: ) VALUES (
55: x_QUAL_TYPE_ID,
56: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),

Line 59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

55: x_QUAL_TYPE_ID,
56: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),

Line 60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

56: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),

Line 61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),

57: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),

Line 62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),

58: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),

Line 63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),

59: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),

Line 64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),

60: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),

Line 65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),

61: decode( x_NAME, FND_API.G_MISS_CHAR, NULL,x_NAME),
62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),

Line 66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),

62: decode( x_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,x_DESCRIPTION),
63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),

Line 67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),

63: decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_SELECT_CLAUSE),
64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),

Line 68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),

64: decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL,x_WHERE_CLAUSE),
65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
72: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));

Line 69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),

65: decode( x_VIEW_NAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_NAME),
66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
72: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
73: OPEN C;

Line 70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),

66: decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR, NULL,x_VIEW_DDL_FILENAME),
67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
72: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
73: OPEN C;
74: FETCH C INTO x_Rowid;

Line 71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),

67: decode( x_RELATED_ID1, FND_API.G_MISS_NUM, NULL,x_RELATED_ID1),
68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
72: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
73: OPEN C;
74: FETCH C INTO x_Rowid;
75: If (C%NOTFOUND) then

Line 72: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));

68: decode( x_RELATED_ID2, FND_API.G_MISS_NUM, NULL,x_RELATED_ID2),
69: decode( x_RELATED_ID3, FND_API.G_MISS_NUM, NULL,x_RELATED_ID3),
70: decode( x_RELATED_ID4, FND_API.G_MISS_NUM, NULL,x_RELATED_ID4),
71: decode( x_RELATED_ID5, FND_API.G_MISS_NUM, NULL,x_RELATED_ID5),
72: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID));
73: OPEN C;
74: FETCH C INTO x_Rowid;
75: If (C%NOTFOUND) then
76: CLOSE C;

Line 119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),

115: ) IS
116: BEGIN
117: Update JTF_QUAL_TYPES_ALL
118: SET
119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

116: BEGIN
117: Update JTF_QUAL_TYPES_ALL
118: SET
119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

Line 121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

117: Update JTF_QUAL_TYPES_ALL
118: SET
119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),

Line 122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

118: SET
119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),

Line 123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

119: QUAL_TYPE_ID = decode( x_QUAL_TYPE_ID, FND_API.G_MISS_NUM,QUAL_TYPE_ID,x_QUAL_TYPE_ID),
120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),

Line 124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

120: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),

Line 125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),

121: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),

Line 126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),

122: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),

Line 127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),

123: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),

Line 128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),

124: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),

Line 129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),

125: NAME = decode( x_NAME, FND_API.G_MISS_CHAR,NAME,x_NAME),
126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),

Line 130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),

126: DESCRIPTION = decode( x_DESCRIPTION, FND_API.G_MISS_CHAR,DESCRIPTION,x_DESCRIPTION),
127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),

Line 131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),

127: SELECT_CLAUSE = decode( x_SELECT_CLAUSE, FND_API.G_MISS_CHAR,SELECT_CLAUSE,x_SELECT_CLAUSE),
128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),
135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),

Line 132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),

128: WHERE_CLAUSE = decode( x_WHERE_CLAUSE, FND_API.G_MISS_CHAR,WHERE_CLAUSE,x_WHERE_CLAUSE),
129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),
135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),
136: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

Line 133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),

129: VIEW_NAME = decode( x_VIEW_NAME, FND_API.G_MISS_CHAR,VIEW_NAME,x_VIEW_NAME),
130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),
135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),
136: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
137: where QUAL_TYPE_ID = X_QUAL_TYPE_ID and

Line 134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),

130: VIEW_DDL_FILENAME = decode( x_VIEW_DDL_FILENAME, FND_API.G_MISS_CHAR,VIEW_DDL_FILENAME,x_VIEW_DDL_FILENAME),
131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),
135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),
136: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
137: where QUAL_TYPE_ID = X_QUAL_TYPE_ID and
138: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;

Line 135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),

131: RELATED_ID1 = decode( x_RELATED_ID1, FND_API.G_MISS_NUM,RELATED_ID1,x_RELATED_ID1),
132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),
135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),
136: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
137: where QUAL_TYPE_ID = X_QUAL_TYPE_ID and
138: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
139:

Line 136: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

132: RELATED_ID2 = decode( x_RELATED_ID2, FND_API.G_MISS_NUM,RELATED_ID2,x_RELATED_ID2),
133: RELATED_ID3 = decode( x_RELATED_ID3, FND_API.G_MISS_NUM,RELATED_ID3,x_RELATED_ID3),
134: RELATED_ID4 = decode( x_RELATED_ID4, FND_API.G_MISS_NUM,RELATED_ID4,x_RELATED_ID4),
135: RELATED_ID5 = decode( x_RELATED_ID5, FND_API.G_MISS_NUM,RELATED_ID5,x_RELATED_ID5),
136: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
137: where QUAL_TYPE_ID = X_QUAL_TYPE_ID and
138: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
139:
140: If (SQL%NOTFOUND) then