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.OZF_OFFER_PERFORMANCES_PKG dependencies on FND_API

Line 123: DECODE( px_offer_performance_id, FND_API.g_miss_num, NULL, px_offer_performance_id),

119: requirement_type,
120: uom_code,
121: description)
122: VALUES (
123: DECODE( px_offer_performance_id, FND_API.g_miss_num, NULL, px_offer_performance_id),
124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),

Line 124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),

120: uom_code,
121: description)
122: VALUES (
123: DECODE( px_offer_performance_id, FND_API.g_miss_num, NULL, px_offer_performance_id),
124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),

121: description)
122: VALUES (
123: DECODE( px_offer_performance_id, FND_API.g_miss_num, NULL, px_offer_performance_id),
124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

122: VALUES (
123: DECODE( px_offer_performance_id, FND_API.g_miss_num, NULL, px_offer_performance_id),
124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),

123: DECODE( px_offer_performance_id, FND_API.g_miss_num, NULL, px_offer_performance_id),
124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),

Line 128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

124: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),

Line 129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

125: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),

Line 130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),

Line 131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),

127: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),

Line 132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),

128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),

Line 133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),

129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),

Line 134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),

130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),

Line 135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),

131: DECODE( p_product_attribute_context, FND_API.g_miss_char, NULL, p_product_attribute_context),
132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),

132: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),

133: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),

134: DECODE( p_channel_id, FND_API.g_miss_num, NULL, p_channel_id),
135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

135: DECODE( p_start_date, FND_API.g_miss_date, to_date(NULL), p_start_date),
136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

136: DECODE( p_end_date, FND_API.g_miss_date, to_date(NULL), p_end_date),
137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

137: DECODE( p_estimated_value, FND_API.g_miss_num, NULL, p_estimated_value),
138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

138: DECODE( p_required_flag, FND_API.g_miss_char, NULL, p_required_flag),
139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

139: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

140: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

141: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

142: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

143: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

144: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

145: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

146: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

Line 151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

147: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

Line 152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

148: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),

Line 153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

149: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),
157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),

Line 154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

150: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),
157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
158: DECODE( p_description, FND_API.g_miss_char, NULL, p_description));

Line 155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),

151: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),
157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
158: DECODE( p_description, FND_API.g_miss_char, NULL, p_description));
159: END Insert_Row;

Line 156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),

152: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),
157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
158: DECODE( p_description, FND_API.g_miss_char, NULL, p_description));
159: END Insert_Row;
160:

Line 157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),

153: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),
157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
158: DECODE( p_description, FND_API.g_miss_char, NULL, p_description));
159: END Insert_Row;
160:
161:

Line 158: DECODE( p_description, FND_API.g_miss_char, NULL, p_description));

154: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
155: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
156: DECODE( p_requirement_type, FND_API.g_miss_char, NULL, p_requirement_type),
157: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
158: DECODE( p_description, FND_API.g_miss_char, NULL, p_description));
159: END Insert_Row;
160:
161:
162: ----------------------------------------------------------

Line 220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),

216: IS
217: BEGIN
218: Update OZF_OFFER_PERFORMANCES
219: SET
220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),
221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),

217: BEGIN
218: Update OZF_OFFER_PERFORMANCES
219: SET
220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),
221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

218: Update OZF_OFFER_PERFORMANCES
219: SET
220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),
221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),

Line 223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

219: SET
220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),
221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),

Line 224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),
221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),

Line 225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),

Line 226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),

222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),

Line 227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),

223: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),

Line 228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),

224: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),

Line 229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),

225: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),

Line 230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),

226: product_attribute_context = DECODE( p_product_attribute_context, FND_API.g_miss_char, product_attribute_context, p_product_attribute_context),
227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),

227: product_attribute = DECODE( p_product_attribute, FND_API.g_miss_char, product_attribute, p_product_attribute),
228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

Line 232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),

228: product_attr_value = DECODE( p_product_attr_value, FND_API.g_miss_char, product_attr_value, p_product_attr_value),
229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

Line 233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),

229: channel_id = DECODE( p_channel_id, FND_API.g_miss_num, channel_id, p_channel_id),
230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

Line 234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

230: start_date = DECODE( p_start_date, FND_API.g_miss_date, start_date, p_start_date),
231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

Line 235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

231: end_date = DECODE( p_end_date, FND_API.g_miss_date, end_date, p_end_date),
232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

Line 236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

232: estimated_value = DECODE( p_estimated_value, FND_API.g_miss_num, estimated_value, p_estimated_value),
233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

Line 237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

233: required_flag = DECODE( p_required_flag, FND_API.g_miss_char, required_flag, p_required_flag),
234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

Line 238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

234: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

Line 239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

235: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

Line 240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

236: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

Line 241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

237: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

Line 242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

238: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

Line 243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

239: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

Line 244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

240: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

Line 245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

241: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),

Line 246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

242: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

Line 247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

243: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),

Line 248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

244: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),
252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),

Line 249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),

245: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),
252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),
253: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

Line 250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),

246: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),
252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),
253: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
254: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID

Line 251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),

247: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),
252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),
253: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
254: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
255: AND object_version_number = p_object_version_number-1;

Line 252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),

248: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),
252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),
253: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
254: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
255: AND object_version_number = p_object_version_number-1;
256:

Line 253: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

249: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
250: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
251: requirement_type = DECODE( p_requirement_type, FND_API.g_miss_char, requirement_type, p_requirement_type),
252: uom_code = DECODE( p_uom_code, FND_API.g_miss_char, uom_code, p_uom_code),
253: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
254: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
255: AND object_version_number = p_object_version_number-1;
256:
257: IF (SQL%NOTFOUND) THEN

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

254: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
255: AND object_version_number = p_object_version_number-1;
256:
257: IF (SQL%NOTFOUND) THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260: END Update_Row;
261:
262:

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: BEGIN
283: DELETE FROM OZF_OFFER_PERFORMANCES
284: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID;
285: If (SQL%NOTFOUND) then
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: End If;
288: END Delete_Row ;
289:
290: