APPS.OZF_DISC_LINE_PKG dependencies on FND_API

Line 142: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),

138: attribute14,
139: attribute15,
140: offer_id
141: ) VALUES (
142: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),

Line 143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),

139: attribute15,
140: offer_id
141: ) VALUES (
142: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),

Line 144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),

140: offer_id
141: ) VALUES (
142: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),

Line 145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),

141: ) VALUES (
142: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),

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

142: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),

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

143: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),

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

144: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),

Line 149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),

145: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),

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

146: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),

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

147: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),

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

148: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),

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

149: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),

Line 154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),

150: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),

Line 155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),

151: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),

Line 156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),

152: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),

Line 157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),

153: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),

Line 158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),

154: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),

155: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),

Line 160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),

156: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),

157: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

158: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

159: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

160: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

161: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

Line 166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

162: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),

Line 167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

163: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

164: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

165: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),

166: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

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

167: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

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

168: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

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

169: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

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

170: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

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

171: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

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

172: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

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

173: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

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

174: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

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

175: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

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

176: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

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

177: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
185: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

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

178: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
185: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
186: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id));

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

179: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
185: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
186: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id));
187:

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

180: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
185: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
186: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id));
187:
188: END Insert_Row;

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

181: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
185: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
186: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id));
187:
188: END Insert_Row;
189:

Line 186: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id));

182: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
183: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
184: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
185: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
186: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id));
187:
188: END Insert_Row;
189:
190: -- ========================================================

Line 308: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),

304: attribute15,
305: offer_id,
306: formula_id
307: ) VALUES (
308: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),

Line 309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),

305: offer_id,
306: formula_id
307: ) VALUES (
308: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),

Line 310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),

306: formula_id
307: ) VALUES (
308: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),

Line 311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),

307: ) VALUES (
308: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),

Line 312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),

308: DECODE( px_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, px_offer_discount_line_id),
309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),

Line 313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),

309: DECODE( p_parent_discount_line_id, FND_API.G_MISS_NUM, NULL, p_parent_discount_line_id),
310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),

Line 314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),

310: DECODE( p_volume_from, FND_API.G_MISS_NUM, NULL, p_volume_from),
311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),

Line 315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),

311: DECODE( p_volume_to, FND_API.G_MISS_NUM, NULL, p_volume_to),
312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),

Line 316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),

312: DECODE( p_volume_operator, FND_API.g_miss_char, NULL, p_volume_operator),
313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),

Line 317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),

313: DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type),
314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),

Line 318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),

314: DECODE( p_volume_break_type, FND_API.g_miss_char, NULL, p_volume_break_type),
315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),

Line 319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),

315: DECODE( p_discount, FND_API.G_MISS_NUM, NULL, p_discount),
316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),

Line 320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),

316: DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type),
317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),

Line 321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),

317: DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type),
318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),

Line 322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),

318: DECODE( p_tier_level, FND_API.g_miss_char, NULL, p_tier_level),
319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),

Line 323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),

319: DECODE( p_incompatibility_group, FND_API.g_miss_char, NULL, p_incompatibility_group),
320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),

Line 324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),

320: DECODE( p_precedence, FND_API.G_MISS_NUM, NULL, p_precedence),
321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),

321: DECODE( p_bucket, FND_API.g_miss_char, NULL, p_bucket),
322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),

Line 326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),

322: DECODE( p_scan_value, FND_API.G_MISS_NUM, NULL, p_scan_value),
323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),

323: DECODE( p_scan_data_quantity, FND_API.G_MISS_NUM, NULL, p_scan_data_quantity),
324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

324: DECODE( p_scan_unit_forecast, FND_API.G_MISS_NUM, NULL, p_scan_unit_forecast),
325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

325: DECODE( p_channel_id, FND_API.G_MISS_NUM, NULL, p_channel_id),
326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

326: DECODE( p_adjustment_flag, FND_API.g_miss_char, NULL, p_adjustment_flag),
327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

327: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL) , p_start_date_active),
328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

Line 332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

328: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),

Line 333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

329: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

330: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

331: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),

332: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

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

333: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

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

334: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

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

335: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

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

336: DECODE( p_context, FND_API.g_miss_char, NULL, p_context),
337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

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

337: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

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

338: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

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

339: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

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

340: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

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

341: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

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

342: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

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

343: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),

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

344: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),

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

345: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
353: DECODE( p_formula_id, FND_API.G_MISS_NUM, NULL, p_formula_id)

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

346: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
353: DECODE( p_formula_id, FND_API.G_MISS_NUM, NULL, p_formula_id)
354: );

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

347: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
353: DECODE( p_formula_id, FND_API.G_MISS_NUM, NULL, p_formula_id)
354: );
355:

Line 352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),

348: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
353: DECODE( p_formula_id, FND_API.G_MISS_NUM, NULL, p_formula_id)
354: );
355:
356: END Insert_Row;

Line 353: DECODE( p_formula_id, FND_API.G_MISS_NUM, NULL, p_formula_id)

349: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
350: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
351: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
352: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
353: DECODE( p_formula_id, FND_API.G_MISS_NUM, NULL, p_formula_id)
354: );
355:
356: END Insert_Row;
357:

Line 424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),

420: IS
421: BEGIN
422: Update ozf_offer_discount_lines
423: SET
424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),

Line 425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),

421: BEGIN
422: Update ozf_offer_discount_lines
423: SET
424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),

Line 426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),

422: Update ozf_offer_discount_lines
423: SET
424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),

Line 427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),

423: SET
424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),

Line 428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),

424: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),

Line 429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),

425: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),

Line 430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),

426: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),

Line 431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),

427: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),

Line 432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),

428: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),

Line 433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),

429: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),

Line 434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),

430: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),

Line 435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),

431: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),

Line 436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),

432: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),

Line 437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),

433: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),

Line 438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),

434: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),

Line 439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),

435: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),

436: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),

437: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),

Line 442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),

438: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

Line 443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

439: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

440: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

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

441: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

442: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),

Line 447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

443: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

Line 448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

444: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
445: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

Line 450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),

446: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

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

447: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

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

448: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

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

449: object_version_number = nvl(p_object_version_number,0) + 1 ,
450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

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

450: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

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

451: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

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

452: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

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

453: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

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

454: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

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

455: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

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

456: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

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

457: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
465: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),

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

458: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
465: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
466: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id)

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

459: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
465: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
466: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id)
467: WHERE offer_discount_line_id = p_offer_discount_line_id

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

460: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
465: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
466: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id)
467: WHERE offer_discount_line_id = p_offer_discount_line_id
468: AND object_version_number = p_object_version_number;

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

461: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
465: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
466: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id)
467: WHERE offer_discount_line_id = p_offer_discount_line_id
468: AND object_version_number = p_object_version_number;
469:

Line 466: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id)

462: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
463: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
464: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
465: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
466: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id)
467: WHERE offer_discount_line_id = p_offer_discount_line_id
468: AND object_version_number = p_object_version_number;
469:
470:

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

468: AND object_version_number = p_object_version_number;
469:
470:
471: IF (SQL%NOTFOUND) THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474:
475:
476: END Update_Row;

Line 542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),

538: IS
539: BEGIN
540: Update ozf_offer_discount_lines
541: SET
542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),

Line 543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),

539: BEGIN
540: Update ozf_offer_discount_lines
541: SET
542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),

Line 544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),

540: Update ozf_offer_discount_lines
541: SET
542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),

Line 545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),

541: SET
542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),

Line 546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),

542: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),

Line 547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),

543: parent_discount_line_id = DECODE( p_parent_discount_line_id, null, parent_discount_line_id, FND_API.G_MISS_NUM, null, p_parent_discount_line_id),
544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),

Line 548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),

544: volume_from = DECODE( p_volume_from, null, volume_from, FND_API.G_MISS_NUM, null, p_volume_from),
545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),

Line 549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),

545: volume_to = DECODE( p_volume_to, null, volume_to, FND_API.G_MISS_NUM, null, p_volume_to),
546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),

Line 550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),

546: volume_operator = DECODE( p_volume_operator, null, volume_operator, FND_API.g_miss_char, null, p_volume_operator),
547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),

Line 551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),

547: volume_type = DECODE( p_volume_type, null, volume_type, FND_API.g_miss_char, null, p_volume_type),
548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),

Line 552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),

548: volume_break_type = DECODE( p_volume_break_type, null, volume_break_type, FND_API.g_miss_char, null, p_volume_break_type),
549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),

Line 553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),

549: discount = DECODE( p_discount, null, discount, FND_API.G_MISS_NUM, null, p_discount),
550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),

Line 554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),

550: discount_type = DECODE( p_discount_type, null, discount_type, FND_API.g_miss_char, null, p_discount_type),
551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),

Line 555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),

551: tier_type = DECODE( p_tier_type, null, tier_type, FND_API.g_miss_char, null, p_tier_type),
552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),

Line 556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),

552: tier_level = DECODE( p_tier_level, null, tier_level, FND_API.g_miss_char, null, p_tier_level),
553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),

Line 557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),

553: incompatibility_group = DECODE( p_incompatibility_group, null, incompatibility_group, FND_API.g_miss_char, null, p_incompatibility_group),
554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

Line 558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),

554: precedence = DECODE( p_precedence, null, precedence, FND_API.G_MISS_NUM, null, p_precedence),
555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

Line 559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),

555: bucket = DECODE( p_bucket, null, bucket, FND_API.g_miss_char, null, p_bucket),
556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),

Line 560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),

556: scan_value = DECODE( p_scan_value, null, scan_value, FND_API.G_MISS_NUM, null, p_scan_value),
557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

Line 561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),

557: scan_data_quantity = DECODE( p_scan_data_quantity, null, scan_data_quantity, FND_API.G_MISS_NUM, null, p_scan_data_quantity),
558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),

558: scan_unit_forecast = DECODE( p_scan_unit_forecast, null, scan_unit_forecast, FND_API.G_MISS_NUM, null, p_scan_unit_forecast),
559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

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

559: channel_id = DECODE( p_channel_id, null, channel_id, FND_API.G_MISS_NUM, null, p_channel_id),
560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

560: adjustment_flag = DECODE( p_adjustment_flag, null, adjustment_flag, FND_API.g_miss_char, null, p_adjustment_flag),
561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),

Line 565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

561: start_date_active = DECODE( p_start_date_active, to_date(NULL), start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

Line 566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

562: end_date_active = DECODE( p_end_date_active, to_date(NULL), end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
563: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

Line 568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),

564: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

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

565: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

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

566: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

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

567: object_version_number = nvl(p_object_version_number,0) + 1 ,
568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

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

568: context = DECODE( p_context, FND_API.g_miss_char, context, p_context),
569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

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

569: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

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

570: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

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

571: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

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

572: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

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

573: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

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

574: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

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

575: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),

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

576: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),

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

577: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
585: formula_id = DECODE( p_formula_id, null, formula_id, FND_API.G_MISS_NUM, null, p_formula_id)

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

578: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
585: formula_id = DECODE( p_formula_id, null, formula_id, FND_API.G_MISS_NUM, null, p_formula_id)
586: WHERE offer_discount_line_id = p_offer_discount_line_id

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

579: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
585: formula_id = DECODE( p_formula_id, null, formula_id, FND_API.G_MISS_NUM, null, p_formula_id)
586: WHERE offer_discount_line_id = p_offer_discount_line_id
587: AND object_version_number = p_object_version_number;

Line 584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),

580: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
585: formula_id = DECODE( p_formula_id, null, formula_id, FND_API.G_MISS_NUM, null, p_formula_id)
586: WHERE offer_discount_line_id = p_offer_discount_line_id
587: AND object_version_number = p_object_version_number;
588:

Line 585: formula_id = DECODE( p_formula_id, null, formula_id, FND_API.G_MISS_NUM, null, p_formula_id)

581: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
582: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
583: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
584: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
585: formula_id = DECODE( p_formula_id, null, formula_id, FND_API.G_MISS_NUM, null, p_formula_id)
586: WHERE offer_discount_line_id = p_offer_discount_line_id
587: AND object_version_number = p_object_version_number;
588:
589:

Line 591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

587: AND object_version_number = p_object_version_number;
588:
589:
590: IF (SQL%NOTFOUND) THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:
594:
595: END Update_Row;

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: DELETE FROM ozf_offer_discount_lines
617: WHERE offer_discount_line_id = p_offer_discount_line_id
618: AND object_version_number = p_object_version_number;
619: If (SQL%NOTFOUND) then
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: End If;
622: END Delete_Row ;
623:
624:

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

629: BEGIN
630: DELETE FROM ozf_offer_discount_lines WHERE parent_discount_line_id = p_offer_discount_line_id;
631:
632: If (SQL%NOTFOUND) then
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: End If;
635:
636: END delete_tiers;
637: -- ========================================================

Line 667: RAISE FND_API.g_exc_error;

663: FETCH c INTO Recinfo;
664: IF (c%NOTFOUND) THEN
665: CLOSE c;
666: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
667: RAISE FND_API.g_exc_error;
668: END IF;
669: CLOSE c;
670: END Lock_Row;
671: