APPS.JTF_QUAL_USGS_PKG dependencies on FND_API

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

105: JSP_LOV_SQL,
106: use_in_lookup_flag
107: ) VALUES (
108: x_QUAL_USG_ID,
109: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
110: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

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

106: use_in_lookup_flag
107: ) VALUES (
108: x_QUAL_USG_ID,
109: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
110: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),

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

107: ) VALUES (
108: x_QUAL_USG_ID,
109: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
110: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),

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

108: x_QUAL_USG_ID,
109: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
110: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),

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

109: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
110: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),

Line 114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),

110: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),

Line 115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),

111: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),

Line 116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),

112: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),

Line 117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),

113: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),

Line 118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),

114: decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR, NULL,x_APPLICATION_SHORT_NAME),
115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),

Line 119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),

115: decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM, NULL,x_SEEDED_QUAL_ID),
116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),

Line 120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),

116: decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM, NULL,x_QUAL_TYPE_USG_ID),
117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),

Line 121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),

117: decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL,x_ENABLED_FLAG),
118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),

Line 122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),

118: decode( x_QUAL_COL1, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1),
119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),

Line 123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),

119: decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_ALIAS),
120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),

Line 124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),

120: decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_DATATYPE),
121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),

Line 125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),

121: decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE),
122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),

Line 126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),

122: decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_QUAL_COL1_TABLE_ALIAS),
123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),

Line 127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),

123: decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL),
124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),

Line 128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),

124: decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_DATATYPE),
125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),

Line 129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),

125: decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_PRIM_INT_CDE_COL_ALIAS),
126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),

Line 130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),

126: decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL),
127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),

Line 131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),

127: decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_ALIAS),
128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),

Line 132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),

128: decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR, NULL,x_SEC_INT_CDE_COL_DATATYPE),
129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),

Line 133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),

129: decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE),
130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),

Line 134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),

130: decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR, NULL,x_INT_CDE_COL_TABLE_ALIAS),
131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),

Line 135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),

131: decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR, NULL,x_SEEDED_FLAG),
132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),

Line 136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),

132: decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR, NULL,x_DISPLAY_TYPE),
133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),

Line 137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),

133: decode( x_LOV_SQL, FND_API.G_MISS_CHAR, NULL,x_LOV_SQL ),
134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),

Line 138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),

134: decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR, NULL,x_CONVERT_TO_ID_FLAG ),
135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),

Line 139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),

135: decode( x_COLUMN_COUNT, FND_API.G_MISS_NUM, NULL, X_COLUMN_COUNT ),
136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),

Line 140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),

136: decode( x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_FLAG ),
137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),

Line 141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),

137: decode( x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_FORMATTING_FUNCTION_NAME ),
138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),

Line 142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),

138: decode( x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_FLAG ),
139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),

Line 143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),

139: decode( x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, NULL, X_SPECIAL_FUNCTION_NAME ),
140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),

Line 144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),

140: decode( x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, NULL, X_ENABLE_LOV_VALIDATION ),
141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),

Line 145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),

141: decode( x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL1 ),
142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),

Line 146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),

142: decode( x_LOV_SQL2, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL2 ),
143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),

Line 147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),

143: decode( x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL2 ),
144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),

Line 148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),

144: decode( x_LOV_SQL3, FND_API.G_MISS_CHAR, NULL, X_LOV_SQL3 ),
145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
152: decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)

Line 149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),

145: decode( x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, NULL, X_DISPLAY_SQL3 ),
146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
152: decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
153: );

Line 150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),

146: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL, X_ORG_ID),
147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
152: decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
153: );
154: OPEN C;

Line 151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),

147: decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
152: decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
153: );
154: OPEN C;
155: FETCH C INTO x_Rowid;

Line 152: decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)

148: decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
149: decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
150: decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
151: decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
152: decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
153: );
154: OPEN C;
155: FETCH C INTO x_Rowid;
156: If (C%NOTFOUND) then

Line 227: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),

223: ) IS
224: BEGIN
225: Update JTF_QUAL_USGS
226: SET
227: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
228: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

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

224: BEGIN
225: Update JTF_QUAL_USGS
226: SET
227: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
228: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

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

225: Update JTF_QUAL_USGS
226: SET
227: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
228: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),

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

226: SET
227: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
228: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),

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

227: QUAL_USG_ID = decode( x_QUAL_USG_ID, FND_API.G_MISS_NUM,QUAL_USG_ID,x_QUAL_USG_ID),
228: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),

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

228: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),

Line 233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),

229: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),

Line 234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),

230: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),

Line 235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),

231: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),

Line 236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),

232: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),

Line 237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),

233: APPLICATION_SHORT_NAME = decode( x_APPLICATION_SHORT_NAME, FND_API.G_MISS_CHAR,APPLICATION_SHORT_NAME,x_APPLICATION_SHORT_NAME),
234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),

Line 238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),

234: SEEDED_QUAL_ID = decode( x_SEEDED_QUAL_ID, FND_API.G_MISS_NUM,SEEDED_QUAL_ID,x_SEEDED_QUAL_ID),
235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),

Line 239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),

235: QUAL_TYPE_USG_ID = decode( x_QUAL_TYPE_USG_ID, FND_API.G_MISS_NUM,QUAL_TYPE_USG_ID,x_QUAL_TYPE_USG_ID),
236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),

Line 240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),

236: ENABLED_FLAG = decode( x_ENABLED_FLAG, FND_API.G_MISS_CHAR,ENABLED_FLAG,x_ENABLED_FLAG),
237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),

Line 241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),

237: QUAL_COL1 = decode( x_QUAL_COL1, FND_API.G_MISS_CHAR,QUAL_COL1,x_QUAL_COL1),
238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),

Line 242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),

238: QUAL_COL1_ALIAS = decode( x_QUAL_COL1_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_ALIAS,x_QUAL_COL1_ALIAS),
239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),

Line 243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),

239: QUAL_COL1_DATATYPE = decode( x_QUAL_COL1_DATATYPE, FND_API.G_MISS_CHAR,QUAL_COL1_DATATYPE,x_QUAL_COL1_DATATYPE),
240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),

Line 244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),

240: QUAL_COL1_TABLE = decode( x_QUAL_COL1_TABLE, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE,x_QUAL_COL1_TABLE),
241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),

Line 245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),

241: QUAL_COL1_TABLE_ALIAS = decode( x_QUAL_COL1_TABLE_ALIAS, FND_API.G_MISS_CHAR,QUAL_COL1_TABLE_ALIAS,x_QUAL_COL1_TABLE_ALIAS),
242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),

Line 246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),

242: PRIM_INT_CDE_COL = decode( x_PRIM_INT_CDE_COL, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL,x_PRIM_INT_CDE_COL),
243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),

Line 247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),

243: PRIM_INT_CDE_COL_DATATYPE = decode( x_PRIM_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_DATATYPE,x_PRIM_INT_CDE_COL_DATATYPE),
244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),

Line 248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),

244: PRIM_INT_CDE_COL_ALIAS = decode( x_PRIM_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,PRIM_INT_CDE_COL_ALIAS,x_PRIM_INT_CDE_COL_ALIAS),
245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),

Line 249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),

245: SEC_INT_CDE_COL = decode( x_SEC_INT_CDE_COL, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL,x_SEC_INT_CDE_COL),
246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),

Line 250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),

246: SEC_INT_CDE_COL_ALIAS = decode( x_SEC_INT_CDE_COL_ALIAS, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_ALIAS,x_SEC_INT_CDE_COL_ALIAS),
247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),

Line 251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),

247: SEC_INT_CDE_COL_DATATYPE = decode( x_SEC_INT_CDE_COL_DATATYPE, FND_API.G_MISS_CHAR,SEC_INT_CDE_COL_DATATYPE,x_SEC_INT_CDE_COL_DATATYPE),
248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),

Line 252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),

248: INT_CDE_COL_TABLE = decode( x_INT_CDE_COL_TABLE, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE,x_INT_CDE_COL_TABLE),
249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),

Line 253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),

249: INT_CDE_COL_TABLE_ALIAS = decode( x_INT_CDE_COL_TABLE_ALIAS, FND_API.G_MISS_CHAR,INT_CDE_COL_TABLE_ALIAS,x_INT_CDE_COL_TABLE_ALIAS),
250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),

Line 254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),

250: SEEDED_FLAG = decode( x_SEEDED_FLAG, FND_API.G_MISS_CHAR,SEEDED_FLAG,x_SEEDED_FLAG),
251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),

Line 255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),

251: DISPLAY_TYPE = decode( x_DISPLAY_TYPE, FND_API.G_MISS_CHAR,DISPLAY_TYPE,x_DISPLAY_TYPE),
252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),

Line 256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),

252: LOV_SQL = decode( x_LOV_SQL, FND_API.G_MISS_CHAR,LOV_SQL,x_LOV_SQL),
253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),

Line 257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),

253: CONVERT_TO_ID_FLAG = decode( x_CONVERT_TO_ID_FLAG, FND_API.G_MISS_CHAR,CONVERT_TO_ID_FLAG, x_CONVERT_TO_ID_FLAG),
254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),

Line 258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),

254: COLUMN_COUNT = decode(x_COLUMN_COUNT, FND_API.G_MISS_NUM, COLUMN_COUNT, X_COLUMN_COUNT),
255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),

Line 259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),

255: FORMATTING_FUNCTION_FLAG = decode(x_FORMATTING_FUNCTION_FLAG, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_FLAG, X_FORMATTING_FUNCTION_FLAG),
256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),

Line 260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),

256: FORMATTING_FUNCTION_NAME = decode(x_FORMATTING_FUNCTION_NAME, FND_API.G_MISS_CHAR, FORMATTING_FUNCTION_NAME, X_FORMATTING_FUNCTION_NAME),
257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),

Line 261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),

257: SPECIAL_FUNCTION_FLAG = decode(x_SPECIAL_FUNCTION_FLAG, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_FLAG, X_SPECIAL_FUNCTION_FLAG),
258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),

Line 262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),

258: SPECIAL_FUNCTION_NAME = decode(x_SPECIAL_FUNCTION_NAME, FND_API.G_MISS_CHAR, SPECIAL_FUNCTION_NAME, X_SPECIAL_FUNCTION_NAME),
259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),

Line 263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),

259: ENABLE_LOV_VALIDATION = decode(x_ENABLE_LOV_VALIDATION, FND_API.G_MISS_CHAR, ENABLE_LOV_VALIDATION, X_ENABLE_LOV_VALIDATION),
260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),

Line 264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),

260: DISPLAY_SQL1 = decode(x_DISPLAY_SQL1, FND_API.G_MISS_CHAR, DISPLAY_SQL1, X_DISPLAY_SQL1),
261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),

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

261: LOV_SQL2 = decode(x_LOV_SQL2, FND_API.G_MISS_CHAR, LOV_SQL2, X_LOV_SQL2),
262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),

Line 266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),

262: DISPLAY_SQL2 = decode(x_DISPLAY_SQL2, FND_API.G_MISS_CHAR, DISPLAY_SQL2, X_DISPLAY_SQL2),
263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),

Line 267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),

263: LOV_SQL3 = decode(x_LOV_SQL3, FND_API.G_MISS_CHAR, LOV_SQL3, X_LOV_SQL3),
264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
271: use_in_lookup_flag = decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)

Line 268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),

264: DISPLAY_SQL3 = decode(x_DISPLAY_SQL3, FND_API.G_MISS_CHAR, DISPLAY_SQL3, X_DISPLAY_SQL3),
265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
271: use_in_lookup_flag = decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
272: where QUAL_USG_ID = x_QUAL_USG_ID and

Line 269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),

265: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, x_ORG_ID),
266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
271: use_in_lookup_flag = decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
272: where QUAL_USG_ID = x_QUAL_USG_ID and
273: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;

Line 270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),

266: RULE1 = decode( x_RULE1, FND_API.G_MISS_CHAR, NULL, X_RULE1),
267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
271: use_in_lookup_flag = decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
272: where QUAL_USG_ID = x_QUAL_USG_ID and
273: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
274:

Line 271: use_in_lookup_flag = decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)

267: RULE2 = decode( x_RULE2, FND_API.G_MISS_CHAR, NULL, X_RULE2),
268: DISPLAY_SEQUENCE = decode( x_DISPLAY_SEQUENCE, FND_API.G_MISS_NUM, NULL, X_DISPLAY_SEQUENCE),
269: DISPLAY_LENGTH = decode( x_DISPLAY_LENGTH, FND_API.G_MISS_NUM, NULL, X_DISPLAY_LENGTH),
270: JSP_LOV_SQL = decode( x_JSP_LOV_SQL, FND_API.G_MISS_CHAR, NULL, X_JSP_LOV_SQL),
271: use_in_lookup_flag = decode( x_use_in_lookup_flag, FND_API.G_MISS_CHAR, NULL, X_use_in_lookup_flag)
272: where QUAL_USG_ID = x_QUAL_USG_ID and
273: ( ORG_ID = x_ORG_ID OR ( ORG_ID IS NULL AND X_ORG_ID IS NULL)) ;
274:
275: If (SQL%NOTFOUND) then