APPS.ASO_QUOTE_STATUS_PKG dependencies on FND_API

Line 64: If (px_QUOTE_STATUS_ID IS NULL) OR (px_QUOTE_STATUS_ID = FND_API.G_MISS_NUM) then

60:
61: IS
62: CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM sys.dual;
63: BEGIN
64: If (px_QUOTE_STATUS_ID IS NULL) OR (px_QUOTE_STATUS_ID = FND_API.G_MISS_NUM) then
65: OPEN C;
66: FETCH C INTO px_QUOTE_STATUS_ID;
67: CLOSE C;
68: End If;

Line 115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

111: ATTRIBUTE19,
112: ATTRIBUTE20
113: ) VALUES (
114: px_QUOTE_STATUS_ID,
115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

112: ATTRIBUTE20
113: ) VALUES (
114: px_QUOTE_STATUS_ID,
115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

113: ) VALUES (
114: px_QUOTE_STATUS_ID,
115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

Line 118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

114: px_QUOTE_STATUS_ID,
115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

115: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),

Line 120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

116: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

Line 121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

117: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),

Line 122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

118: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),

Line 123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),

119: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),

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

120: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),

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

121: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),

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

122: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),

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

123: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),

Line 128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),

124: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),

Line 129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),

125: decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),

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

126: decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),

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

127: decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),

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

128: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

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

129: ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

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

130: decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),

131: decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

132: decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

133: decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

134: decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

135: decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

136: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

137: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

138: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

139: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

140: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

141: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

142: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

143: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

Line 148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

144: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),

Line 149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

145: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),

Line 150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

146: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),

Line 151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

147: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),

Line 152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),

148: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)

Line 153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),

149: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
157: );

Line 154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),

150: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
157: );
158:

Line 155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),

151: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
157: );
158:
159: insert into ASO_QUOTE_STATUSES_TL (

Line 156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)

152: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
157: );
158:
159: insert into ASO_QUOTE_STATUSES_TL (
160: QUOTE_STATUS_ID,

Line 176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),

172: LANGUAGE,
173: SOURCE_LANG
174: ) select
175: px_QUOTE_STATUS_ID,
176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

173: SOURCE_LANG
174: ) select
175: px_QUOTE_STATUS_ID,
176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

174: ) select
175: px_QUOTE_STATUS_ID,
176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

Line 179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),

175: px_QUOTE_STATUS_ID,
176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

176: ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),

Line 181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

177: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),

Line 182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

178: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),

Line 183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

179: ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
187: L.LANGUAGE_CODE,

Line 184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),

180: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
187: L.LANGUAGE_CODE,
188: userenv('LANG')

Line 185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),

181: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
187: L.LANGUAGE_CODE,
188: userenv('LANG')
189: from FND_LANGUAGES L

Line 186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),

182: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184: ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185: decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
187: L.LANGUAGE_CODE,
188: userenv('LANG')
189: from FND_LANGUAGES L
190: where L.INSTALLED_FLAG in ('I', 'B')

Line 247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

243: IS
244: BEGIN
245: Update ASO_QUOTE_STATUSES_B
246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

244: BEGIN
245: Update ASO_QUOTE_STATUSES_B
246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

245: Update ASO_QUOTE_STATUSES_B
246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

Line 250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

246: SET
247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

247: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

Line 252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

248: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),

Line 253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

249: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),

Line 254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

250: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),

Line 255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

251: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),

Line 256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),

252: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),

Line 257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),

253: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:

Line 258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),

254: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),

Line 259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),

255: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),

Line 260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),

256: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257: UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),

Line 262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),

258: AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),

Line 263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),

259: USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),

Line 264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),

260: EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),

Line 265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),

261:
262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),

262: EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),

263: ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),

264: ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

265: ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

Line 270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

266: ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

267: SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

268: ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

269: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

270: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

271: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

272: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

273: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

274: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

275: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

276: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

Line 281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

277: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),

Line 282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

278: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),

Line 283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

279: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),

Line 284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

280: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),

Line 285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),

281: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
289: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)

Line 286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),

282: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
289: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
290: where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;

Line 287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),

283: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
289: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
290: where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
291:

Line 288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),

284: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
289: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
290: where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
291:
292: If (SQL%NOTFOUND) then

Line 289: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)

285: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
289: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
290: where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
291:
292: If (SQL%NOTFOUND) then
293: RAISE NO_DATA_FOUND;

Line 297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),

293: RAISE NO_DATA_FOUND;
294: End If;
295:
296: update ASO_QUOTE_STATUSES_TL set
297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),

294: End If;
295:
296: update ASO_QUOTE_STATUSES_TL set
297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

295:
296: update ASO_QUOTE_STATUSES_TL set
297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

Line 300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

296: update ASO_QUOTE_STATUSES_TL set
297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

Line 302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
306: SOURCE_LANG = userenv('LANG')

Line 303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
306: SOURCE_LANG = userenv('LANG')
307: where QUOTE_STATUS_ID = P_QUOTE_STATUS_ID

Line 304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
306: SOURCE_LANG = userenv('LANG')
307: where QUOTE_STATUS_ID = P_QUOTE_STATUS_ID
308: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

301: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
303: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305: PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
306: SOURCE_LANG = userenv('LANG')
307: where QUOTE_STATUS_ID = P_QUOTE_STATUS_ID
308: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
309:

Line 656: IF (l_quote_status_id is not null) or (l_quote_status_id <> FND_API.G_MISS_NUM) THEN

652: for i in C2 loop
653: l_quote_status_id := i.QUOTE_STATUS_ID;
654: exit;
655: end loop;
656: IF (l_quote_status_id is not null) or (l_quote_status_id <> FND_API.G_MISS_NUM) THEN
657: UPDATE_ROW (
658: p_QUOTE_STATUS_ID => l_quote_status_id ,
659: p_STATUS_CODE => X_STATUS_CODE ,
660: p_MEANING => X_MEANING,