80: last_updated_by,
81: last_update_login,
82: object_version_number
83: ) VALUES (
84: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
81: last_update_login,
82: object_version_number
83: ) VALUES (
84: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
82: object_version_number
83: ) VALUES (
84: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
83: ) VALUES (
84: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
84: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
91: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
100:
93: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
100:
101: END Insert_Row;
94: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
100:
101: END Insert_Row;
102:
95: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
100:
101: END Insert_Row;
102:
103:
169: apply_discount_flag,
170: include_volume_flag,
171: object_version_number
172: ) VALUES (
173: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
170: include_volume_flag,
171: object_version_number
172: ) VALUES (
173: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
171: object_version_number
172: ) VALUES (
173: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
172: ) VALUES (
173: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
173: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),
174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
175: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
177: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
178: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
179: DECODE( p_start_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_start_date_active),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
180: DECODE( p_end_date_active, FND_API.G_MISS_DATE, to_date(NULL), p_end_date_active),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
182: DECODE( p_offer_id, FND_API.G_MISS_NUM, NULL, p_offer_id),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
183: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
184: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),
193: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
186: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),
193: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
194: );
187: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),
193: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
194: );
195:
188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),
193: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
194: );
195:
196: END Insert_Row;
189: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
190: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),
192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),
193: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
194: );
195:
196: END Insert_Row;
197:
228: IS
229: BEGIN
230: Update ozf_offer_discount_products
231: SET
232: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
229: BEGIN
230: Update ozf_offer_discount_products
231: SET
232: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
230: Update ozf_offer_discount_products
231: SET
232: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
231: SET
232: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
232: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
240: 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),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
243: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
243: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
244: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
237: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
238: 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),
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
243: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
244: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
245: object_version_number = nvl(p_object_version_number,0) + 1
238: 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),
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
243: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
244: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
245: object_version_number = nvl(p_object_version_number,0) + 1
246: WHERE off_discount_product_id = p_off_discount_product_id
239: 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),
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
243: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
244: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
245: object_version_number = nvl(p_object_version_number,0) + 1
246: WHERE off_discount_product_id = p_off_discount_product_id
247: AND object_version_number = p_object_version_number;
240: 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),
241: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
242: 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),
243: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
244: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
245: object_version_number = nvl(p_object_version_number,0) + 1
246: WHERE off_discount_product_id = p_off_discount_product_id
247: AND object_version_number = p_object_version_number;
248:
247: AND object_version_number = p_object_version_number;
248:
249:
250: IF (SQL%NOTFOUND) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253:
254:
255: END Update_Row;
292: IS
293: BEGIN
294: Update ozf_offer_discount_products
295: SET
296: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
293: BEGIN
294: Update ozf_offer_discount_products
295: SET
296: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
294: Update ozf_offer_discount_products
295: SET
296: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
295: SET
296: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
296: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
304: 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),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
301: uom_code = DECODE( p_uom_code, null, uom_code, FND_API.g_miss_char, null, p_uom_code),
302: 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),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
302: 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),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
303: 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),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
304: 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),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),
305: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),
313: include_volume_flag = DECODE( p_include_volume_flag, null, include_volume_flag, FND_API.g_miss_char, null, p_include_volume_flag),
306: 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),
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),
313: include_volume_flag = DECODE( p_include_volume_flag, null, include_volume_flag, FND_API.g_miss_char, null, p_include_volume_flag),
314: object_version_number = nvl(p_object_version_number,0) + 1
307: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),
313: include_volume_flag = DECODE( p_include_volume_flag, null, include_volume_flag, FND_API.g_miss_char, null, p_include_volume_flag),
314: object_version_number = nvl(p_object_version_number,0) + 1
315: WHERE off_discount_product_id = p_off_discount_product_id
308: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),
313: include_volume_flag = DECODE( p_include_volume_flag, null, include_volume_flag, FND_API.g_miss_char, null, p_include_volume_flag),
314: object_version_number = nvl(p_object_version_number,0) + 1
315: WHERE off_discount_product_id = p_off_discount_product_id
316: AND object_version_number = p_object_version_number;
309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),
310: product_attribute = DECODE( p_product_attribute, null, product_attribute, FND_API.g_miss_char, null, p_product_attribute),
311: product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value),
312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),
313: include_volume_flag = DECODE( p_include_volume_flag, null, include_volume_flag, FND_API.g_miss_char, null, p_include_volume_flag),
314: object_version_number = nvl(p_object_version_number,0) + 1
315: WHERE off_discount_product_id = p_off_discount_product_id
316: AND object_version_number = p_object_version_number;
317:
316: AND object_version_number = p_object_version_number;
317:
318:
319: IF (SQL%NOTFOUND) THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:
323:
324: END Update_Row;
345: DELETE FROM ozf_offer_discount_products
346: WHERE off_discount_product_id = p_off_discount_product_id
347: AND object_version_number = p_object_version_number;
348: If (SQL%NOTFOUND) then
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: End If;
351: END Delete_Row ;
352:
353:
358: BEGIN
359: DELETE FROM ozf_offer_discount_products
360: WHERE offer_discount_line_id = p_offer_discount_line_id;
361: If (SQL%NOTFOUND) then
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;
364:
365: END Delete_Product;
366:
394: FETCH c INTO Recinfo;
395: IF (c%NOTFOUND) THEN
396: CLOSE c;
397: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
398: RAISE FND_API.g_exc_error;
399: END IF;
400: CLOSE c;
401: END Lock_Row;
402: