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

APPS.OZF_CREATE_OZF_PROD_LINE_PKG dependencies on FND_API

Line 84: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),

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),

Line 85: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),

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),

Line 86: DECODE( p_product_level, FND_API.g_miss_char, NULL, p_product_level),

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),

Line 87: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),

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),

Line 88: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),

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),

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

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),

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

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),

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

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),

Line 92: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_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),
96: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

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),

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

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),

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

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));

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

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:

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

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;

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

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:

Line 99: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

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:

Line 173: DECODE( px_off_discount_product_id, FND_API.G_MISS_NUM, NULL, px_off_discount_product_id),

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),

Line 174: DECODE( p_parent_off_disc_prod_id, FND_API.G_MISS_NUM, NULL, p_parent_off_disc_prod_id),

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),

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

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),

Line 176: DECODE( p_product_id, FND_API.G_MISS_NUM, NULL, p_product_id),

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),

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

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),

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

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),

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

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),

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

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),

Line 181: DECODE( p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_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),
185: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

Line 188: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),

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),

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

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)

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

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: );

Line 191: DECODE( p_apply_discount_flag, FND_API.g_miss_char, NULL, p_apply_discount_flag),

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:

Line 192: DECODE( p_include_volume_flag, FND_API.g_miss_char, NULL, p_include_volume_flag),

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;

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

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:

Line 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),

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),

Line 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),

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),

Line 234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),

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),

Line 235: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),

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),

Line 236: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),

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),

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

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

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

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

Line 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),

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

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

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;

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

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:

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 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),

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),

Line 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),

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),

Line 298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),

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),

Line 299: product_id = DECODE( p_product_id, null, product_id, FND_API.G_MISS_NUM, null, p_product_id),

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),

Line 300: excluder_flag = DECODE( p_excluder_flag, null, excluder_flag, FND_API.g_miss_char, null, p_excluder_flag),

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),

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

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

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

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),

Line 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),

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),

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

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),

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

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),

Line 309: product_context = DECODE( p_product_context, null, product_context, FND_API.g_miss_char, null, p_product_context),

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),

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

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

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

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

Line 312: apply_discount_flag = DECODE( p_apply_discount_flag, null, apply_discount_flag, FND_API.g_miss_char, null, p_apply_discount_flag),

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;

Line 313: include_volume_flag = DECODE( p_include_volume_flag, null, include_volume_flag, FND_API.g_miss_char, null, p_include_volume_flag),

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:

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 398: RAISE FND_API.g_exc_error;

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: