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

APPS.JTF_CHANGED_TERR_PKG dependencies on FND_API

Line 141: decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),

137: TERR_RSC_ID,
138: ORG_ID
139: ) VALUES (
140: px_TERR_ID,
141: decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),
142: decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),

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

138: ORG_ID
139: ) VALUES (
140: px_TERR_ID,
141: decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),
142: decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),

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

139: ) VALUES (
140: px_TERR_ID,
141: decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),
142: decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),

Line 144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),

140: px_TERR_ID,
141: decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),
142: decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),

Line 145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),

141: decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_TERR_VALUE_ID),
142: decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),

Line 146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),

142: decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, NULL, p_TRIGGER_MODE),
143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),

Line 147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),

143: decode( p_ACTION, FND_API.G_MISS_CHAR, NULL, p_ACTION),
144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),

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

144: decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_TERRITORY_ID),
145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),

Line 149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),

145: decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_START_DATE_ACTIVE),
146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),

Line 150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),

146: decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_END_DATE_ACTIVE),
147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),

Line 151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),

147: decode( p_O_RANK, FND_API.G_MISS_NUM, NULL, p_O_RANK),
148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),

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

148: decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_UPDATE_FLAG),
149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),

Line 153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),

149: decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_START_DATE_ACTIVE),
150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),

Line 154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),

150: decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_END_DATE_ACTIVE),
151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),

Line 155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),

151: decode( p_N_RANK, FND_API.G_MISS_NUM, NULL, p_N_RANK),
152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),

Line 156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),

152: decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_UPDATE_FLAG),
153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),

Line 157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),

153: decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATED_BY),
154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),

Line 158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),

154: decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_LAST_UPDATE_DATE),
155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),

Line 159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),

155: decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_O_CREATED_BY),
156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),

Line 160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),

156: decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_O_CREATION_DATE),
157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),

Line 161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),

157: decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_O_LAST_UPDATE_LOGIN),
158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),

Line 162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),

158: decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_O_TERR_QUAL_ID),
159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),

Line 163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),

159: decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_INCLUDE_FLAG),
160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),

Line 164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),

160: decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_O_COMPARISON_OPERATOR),
161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),

Line 165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),

161: decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_ID_USED_FLAG),
162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),

Line 166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),

162: decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_CHAR_ID),
163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),

Line 167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),

163: decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_LOW_VALUE_CHAR),
164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),

Line 168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),

164: decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_O_HIGH_VALUE_CHAR),
165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),

Line 169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),

165: decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_LOW_VALUE_NUMBER),
166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),

Line 170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),

166: decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_O_HIGH_VALUE_NUMBER),
167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),

Line 171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),

167: decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_O_VALUE_SET),
168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),

Line 172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),

168: decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_O_INTEREST_TYPE_ID),
169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),

Line 173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),

169: decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_PRI_INTEREST_CODE_ID),
170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),

Line 174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),

170: decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_O_SEC_INTEREST_CODE_ID),
171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),

Line 175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),

171: decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_O_CURRENCY_CODE),
172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),

Line 176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),

172: decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATED_BY),
173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),

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

173: decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_LAST_UPDATE_DATE),
174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),

Line 178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),

174: decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_N_CREATED_BY),
175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),

Line 179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),

175: decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_N_CREATION_DATE),
176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),

Line 180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),

176: decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_N_LAST_UPDATE_LOGIN),
177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),

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

177: decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NULL, p_N_TERR_QUAL_ID),
178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),

Line 182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),

178: decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_INCLUDE_FLAG),
179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),

Line 183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),

179: decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_N_COMPARISON_OPERATOR),
180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),

Line 184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),

180: decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_ID_USED_FLAG),
181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),

Line 185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),

181: decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_CHAR_ID),
182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),

Line 186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),

182: decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_LOW_VALUE_CHAR),
183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),

Line 187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),

183: decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NULL, p_N_HIGH_VALUE_CHAR),
184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),

Line 188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),

184: decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_LOW_VALUE_NUMBER),
185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),

Line 189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),

185: decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, p_N_HIGH_VALUE_NUMBER),
186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),

Line 190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),

186: decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NULL, p_N_VALUE_SET),
187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),

Line 191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),

187: decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_N_INTEREST_TYPE_ID),
188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),

Line 192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),

188: decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_PRI_INTEREST_CODE_ID),
189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),

Line 193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),

189: decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NULL, p_N_SEC_INTEREST_CODE_ID),
190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),

Line 194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),

190: decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_N_CURRENCY_CODE),
191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),

Line 195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),

191: decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_O_RESOURCE_ID),
192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),

Line 196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),

192: decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_O_RESOURCE_TYPE),
193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),

Line 197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),

193: decode( p_O_ROLE, FND_API.G_MISS_CHAR, NULL, p_O_ROLE),
194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),

Line 198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),

194: decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_PRI_CONTACT_FLAG),
195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),

195: decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_O_FULL_ACCESS_FLAG),
196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),

Line 200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),

196: decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_N_RESOURCE_ID),
197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),
204: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));

Line 201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),

197: decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, p_N_RESOURCE_TYPE),
198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),
204: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));
205: End Insert_Row;

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

198: decode( p_N_ROLE, FND_API.G_MISS_CHAR, NULL, p_N_ROLE),
199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),
204: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));
205: End Insert_Row;
206:

Line 203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),

199: decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_PRI_CONTACT_FLAG),
200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),
204: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));
205: End Insert_Row;
206:
207: PROCEDURE Update_Row(

Line 204: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));

200: decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_N_FULL_ACCESS_FLAG),
201: decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_ONLY_FLAG),
202: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
203: decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL, p_TERR_RSC_ID),
204: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID));
205: End Insert_Row;
206:
207: PROCEDURE Update_Row(
208: p_TERR_ID NUMBER,

Line 278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),

274: IS
275: BEGIN
276: Update JTF_CHANGED_TERR_ALL
277: SET
278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),

Line 279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),

275: BEGIN
276: Update JTF_CHANGED_TERR_ALL
277: SET
278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),

Line 280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),

276: Update JTF_CHANGED_TERR_ALL
277: SET
278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),

Line 281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),

277: SET
278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),

Line 282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),

278: TERR_VALUE_ID = decode( p_TERR_VALUE_ID, FND_API.G_MISS_NUM, TERR_VALUE_ID, p_TERR_VALUE_ID),
279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),

Line 283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),

279: TRIGGER_MODE = decode( p_TRIGGER_MODE, FND_API.G_MISS_CHAR, TRIGGER_MODE, p_TRIGGER_MODE),
280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),

Line 284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),

280: ACTION = decode( p_ACTION, FND_API.G_MISS_CHAR, ACTION, p_ACTION),
281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),

Line 285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),

281: PARENT_TERRITORY_ID = decode( p_PARENT_TERRITORY_ID, FND_API.G_MISS_NUM, PARENT_TERRITORY_ID, p_PARENT_TERRITORY_ID),
282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),

Line 286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),

282: OLD_START_DATE_ACTIVE = decode( p_O_START_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_START_DATE_ACTIVE, p_O_START_DATE_ACTIVE),
283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),

Line 287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),

283: OLD_END_DATE_ACTIVE = decode( p_O_END_DATE_ACTIVE, FND_API.G_MISS_DATE, OLD_END_DATE_ACTIVE, p_O_END_DATE_ACTIVE),
284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),

Line 288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),

284: OLD_RANK = decode( p_O_RANK, FND_API.G_MISS_NUM, OLD_RANK, p_O_RANK),
285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),

Line 289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),

285: OLD_UPDATE_FLAG = decode( p_O_UPDATE_FLAG, FND_API.G_MISS_CHAR, OLD_UPDATE_FLAG, p_O_UPDATE_FLAG),
286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),

Line 290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),

286: NEW_START_DATE_ACTIVE = decode( p_N_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_START_DATE_ACTIVE, p_N_START_DATE_ACTIVE),
287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),

Line 291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),

287: NEW_END_DATE_ACTIVE = decode( p_N_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NEW_END_DATE_ACTIVE, p_N_END_DATE_ACTIVE),
288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),

Line 292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),

288: NEW_RANK = decode( p_N_RANK, FND_API.G_MISS_NUM, NEW_RANK, p_N_RANK),
289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),

Line 293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),

289: NEW_UPDATE_FLAG = decode( p_N_UPDATE_FLAG, FND_API.G_MISS_CHAR, NEW_UPDATE_FLAG, p_N_UPDATE_FLAG),
290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),

Line 294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),

290: OLD_LAST_UPDATED_BY = decode( p_O_LAST_UPDATED_BY, FND_API.G_MISS_NUM, OLD_LAST_UPDATED_BY, p_O_LAST_UPDATED_BY),
291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),

Line 295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),

291: OLD_LAST_UPDATE_DATE = decode( p_O_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, OLD_LAST_UPDATE_DATE, p_O_LAST_UPDATE_DATE),
292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),

Line 296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),

292: OLD_CREATED_BY = decode( p_O_CREATED_BY, FND_API.G_MISS_NUM, OLD_CREATED_BY, p_O_CREATED_BY),
293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),

Line 297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),

293: OLD_CREATION_DATE = decode( p_O_CREATION_DATE, FND_API.G_MISS_DATE, OLD_CREATION_DATE, p_O_CREATION_DATE),
294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),

Line 298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),

294: OLD_LAST_UPDATE_LOGIN = decode( p_O_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, OLD_LAST_UPDATE_LOGIN, p_O_LAST_UPDATE_LOGIN),
295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),

Line 299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),

295: OLD_TERR_QUAL_ID = decode( p_O_TERR_QUAL_ID, FND_API.G_MISS_NUM, OLD_TERR_QUAL_ID, p_O_TERR_QUAL_ID),
296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),

Line 300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),

296: OLD_INCLUDE_FLAG = decode( p_O_INCLUDE_FLAG, FND_API.G_MISS_CHAR, OLD_INCLUDE_FLAG, p_O_INCLUDE_FLAG),
297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),

Line 301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),

297: OLD_COMPARISON_OPERATOR = decode( p_O_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, OLD_COMPARISON_OPERATOR, p_O_COMPARISON_OPERATOR),
298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),

Line 302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),

298: OLD_ID_USED_FLAG = decode( p_O_ID_USED_FLAG, FND_API.G_MISS_CHAR, OLD_ID_USED_FLAG, p_O_ID_USED_FLAG),
299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),

Line 303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),

299: OLD_LOW_VALUE_CHAR_ID = decode( p_O_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, OLD_LOW_VALUE_CHAR_ID, p_O_LOW_VALUE_CHAR_ID),
300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),

Line 304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),

300: OLD_LOW_VALUE_CHAR = decode( p_O_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_LOW_VALUE_CHAR, p_O_LOW_VALUE_CHAR),
301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),

Line 305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),

301: OLD_HIGH_VALUE_CHAR = decode( p_O_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, OLD_HIGH_VALUE_CHAR, p_O_HIGH_VALUE_CHAR),
302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),

Line 306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),

302: OLD_LOW_VALUE_NUMBER = decode( p_O_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_LOW_VALUE_NUMBER, p_O_LOW_VALUE_NUMBER),
303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),

Line 307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),

303: OLD_HIGH_VALUE_NUMBER = decode( p_O_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, OLD_HIGH_VALUE_NUMBER, p_O_HIGH_VALUE_NUMBER),
304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),

Line 308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),

304: OLD_VALUE_SET = decode( p_O_VALUE_SET, FND_API.G_MISS_NUM, OLD_VALUE_SET, p_O_VALUE_SET),
305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),

Line 309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),

305: OLD_INTEREST_TYPE_ID = decode( p_O_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, OLD_INTEREST_TYPE_ID, p_O_INTEREST_TYPE_ID),
306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),

Line 310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),

306: OLD_PRIMARY_INTEREST_CODE_ID = decode( p_O_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_PRIMARY_INTEREST_CODE_ID, p_O_PRI_INTEREST_CODE_ID),
307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),

Line 311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),

307: OLD_SECONDARY_INTEREST_CODE_ID = decode( p_O_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, OLD_SECONDARY_INTEREST_CODE_ID, p_O_SEC_INTEREST_CODE_ID),
308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),

Line 312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),

308: OLD_CURRENCY_CODE = decode( p_O_CURRENCY_CODE, FND_API.G_MISS_CHAR, OLD_CURRENCY_CODE, p_O_CURRENCY_CODE),
309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),

Line 313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),

309: NEW_LAST_UPDATED_BY = decode( p_N_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NEW_LAST_UPDATED_BY, p_N_LAST_UPDATED_BY),
310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),

Line 314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),

310: NEW_LAST_UPDATE_DATE = decode( p_N_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NEW_LAST_UPDATE_DATE, p_N_LAST_UPDATE_DATE),
311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),

Line 315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),

311: NEW_CREATED_BY = decode( p_N_CREATED_BY, FND_API.G_MISS_NUM, NEW_CREATED_BY, p_N_CREATED_BY),
312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),

Line 316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),

312: NEW_CREATION_DATE = decode( p_N_CREATION_DATE, FND_API.G_MISS_DATE, NEW_CREATION_DATE, p_N_CREATION_DATE),
313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),

Line 317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),

313: NEW_LAST_UPDATE_LOGIN = decode( p_N_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NEW_LAST_UPDATE_LOGIN, p_N_LAST_UPDATE_LOGIN),
314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),

Line 318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),

314: NEW_TERR_QUAL_ID = decode( p_N_TERR_QUAL_ID, FND_API.G_MISS_NUM, NEW_TERR_QUAL_ID, p_N_TERR_QUAL_ID),
315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),

Line 319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),

315: NEW_INCLUDE_FLAG = decode( p_N_INCLUDE_FLAG, FND_API.G_MISS_CHAR, NEW_INCLUDE_FLAG, p_N_INCLUDE_FLAG),
316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),

Line 320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),

316: NEW_COMPARISON_OPERATOR = decode( p_N_COMPARISON_OPERATOR, FND_API.G_MISS_CHAR, NEW_COMPARISON_OPERATOR, p_N_COMPARISON_OPERATOR),
317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),

Line 321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),

317: NEW_ID_USED_FLAG = decode( p_N_ID_USED_FLAG, FND_API.G_MISS_CHAR, NEW_ID_USED_FLAG, p_N_ID_USED_FLAG),
318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),

Line 322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),

318: NEW_LOW_VALUE_CHAR_ID = decode( p_N_LOW_VALUE_CHAR_ID, FND_API.G_MISS_NUM, NEW_LOW_VALUE_CHAR_ID, p_N_LOW_VALUE_CHAR_ID),
319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),

Line 323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),

319: NEW_LOW_VALUE_CHAR = decode( p_N_LOW_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_LOW_VALUE_CHAR, p_N_LOW_VALUE_CHAR),
320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),

Line 324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),

320: NEW_HIGH_VALUE_CHAR = decode( p_N_HIGH_VALUE_CHAR, FND_API.G_MISS_CHAR, NEW_HIGH_VALUE_CHAR, p_N_HIGH_VALUE_CHAR),
321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),

Line 325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),

321: NEW_LOW_VALUE_NUMBER = decode( p_N_LOW_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_LOW_VALUE_NUMBER, p_N_LOW_VALUE_NUMBER),
322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),

Line 326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),

322: NEW_HIGH_VALUE_NUMBER = decode( p_N_HIGH_VALUE_NUMBER, FND_API.G_MISS_NUM, NEW_HIGH_VALUE_NUMBER, p_N_HIGH_VALUE_NUMBER),
323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),

Line 327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),

323: NEW_VALUE_SET = decode( p_N_VALUE_SET, FND_API.G_MISS_NUM, NEW_VALUE_SET, p_N_VALUE_SET),
324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),

Line 328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),

324: NEW_INTEREST_TYPE_ID = decode( p_N_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NEW_INTEREST_TYPE_ID, p_N_INTEREST_TYPE_ID),
325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),

Line 329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),

325: NEW_PRIMARY_INTEREST_CODE_ID = decode( p_N_PRI_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_PRIMARY_INTEREST_CODE_ID, p_N_PRI_INTEREST_CODE_ID),
326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),

Line 330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),

326: NEW_SECONDARY_INTEREST_CODE_ID = decode( p_N_SEC_INTEREST_CODE_ID, FND_API.G_MISS_NUM, NEW_SECONDARY_INTEREST_CODE_ID, p_N_SEC_INTEREST_CODE_ID),
327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),

Line 331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),

327: NEW_CURRENCY_CODE = decode( p_N_CURRENCY_CODE, FND_API.G_MISS_CHAR, NEW_CURRENCY_CODE, p_N_CURRENCY_CODE),
328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),

Line 332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),

328: OLD_RESOURCE_ID = decode( p_O_RESOURCE_ID, FND_API.G_MISS_NUM, OLD_RESOURCE_ID, p_O_RESOURCE_ID),
329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),

Line 333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),

329: OLD_RESOURCE_TYPE = decode( p_O_RESOURCE_TYPE, FND_API.G_MISS_CHAR, OLD_RESOURCE_TYPE, p_O_RESOURCE_TYPE),
330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),

Line 334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),

330: OLD_ROLE = decode( p_O_ROLE, FND_API.G_MISS_CHAR, OLD_ROLE, p_O_ROLE),
331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),

Line 335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),

331: OLD_PRIMARY_CONTACT_FLAG = decode( p_O_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, OLD_PRIMARY_CONTACT_FLAG, p_O_PRI_CONTACT_FLAG),
332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),

332: OLD_FULL_ACCESS_FLAG = decode( p_O_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, OLD_FULL_ACCESS_FLAG, p_O_FULL_ACCESS_FLAG),
333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),

Line 337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),

333: NEW_RESOURCE_ID = decode( p_N_RESOURCE_ID, FND_API.G_MISS_NUM, NEW_RESOURCE_ID, p_N_RESOURCE_ID),
334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),
341: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)

Line 338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),

334: NEW_RESOURCE_TYPE = decode( p_N_RESOURCE_TYPE, FND_API.G_MISS_CHAR, NEW_RESOURCE_TYPE, p_N_RESOURCE_TYPE),
335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),
341: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
342: where TERR_ID = p_TERR_ID;

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

335: NEW_ROLE = decode( p_N_ROLE, FND_API.G_MISS_CHAR, NEW_ROLE, p_N_ROLE),
336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),
341: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
342: where TERR_ID = p_TERR_ID;
343:

Line 340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),

336: NEW_PRIMARY_CONTACT_FLAG = decode( p_N_PRI_CONTACT_FLAG, FND_API.G_MISS_CHAR, NEW_PRIMARY_CONTACT_FLAG, p_N_PRI_CONTACT_FLAG),
337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),
341: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
342: where TERR_ID = p_TERR_ID;
343:
344: If (SQL%NOTFOUND) then

Line 341: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)

337: NEW_FULL_ACCESS_FLAG = decode( p_N_FULL_ACCESS_FLAG, FND_API.G_MISS_CHAR, NEW_FULL_ACCESS_FLAG, p_N_FULL_ACCESS_FLAG),
338: TRANSFER_ONLY_FLAG = decode( p_TRANSFER_ONLY_FLAG, FND_API.G_MISS_CHAR, TRANSFER_ONLY_FLAG, p_TRANSFER_ONLY_FLAG),
339: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
340: TERR_RSC_ID = decode( p_TERR_RSC_ID, FND_API.G_MISS_NUM, TERR_RSC_ID, p_TERR_RSC_ID),
341: ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID)
342: where TERR_ID = p_TERR_ID;
343:
344: If (SQL%NOTFOUND) then
345: RAISE NO_DATA_FOUND;