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

APPS.OZF_OFFER_ADJ_NEW_PRODUCTS_PKG dependencies on FND_API

Line 75: DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),

71: last_updated_by,
72: last_update_login,
73: object_version_number
74: ) VALUES (
75: DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),
76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),

Line 76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),

72: last_update_login,
73: object_version_number
74: ) VALUES (
75: DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),
76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),

Line 77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),

73: object_version_number
74: ) VALUES (
75: DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),
76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),

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

74: ) VALUES (
75: DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),
76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),

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

75: DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),
76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

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

76: DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

77: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

78: DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

79: DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

80: DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

Line 85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

81: DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
89: END Insert_Row;

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

82: DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
89: END Insert_Row;
90:

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

83: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
89: END Insert_Row;
90:
91:

Line 88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
89: END Insert_Row;
90:
91:
92: ----------------------------------------------------------

Line 128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)

124: IS
125: BEGIN
126: Update OZF_OFFER_ADJ_NEW_PRODUCTS
127: SET
128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)

Line 129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)

125: BEGIN
126: Update OZF_OFFER_ADJ_NEW_PRODUCTS
127: SET
128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)

Line 130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)

126: Update OZF_OFFER_ADJ_NEW_PRODUCTS
127: SET
128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)

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

127: SET
128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)

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

128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)

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

129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137: , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)

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

130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137: , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)
138: , last_update_login = DECODE( p_last_update_login, null , last_update_login, FND_API.g_miss_num, null , p_last_update_login)

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

131: , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137: , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)
138: , last_update_login = DECODE( p_last_update_login, null , last_update_login, FND_API.g_miss_num, null , p_last_update_login)
139: , object_version_number = nvl(p_object_version_number,0) + 1

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

132: , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137: , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)
138: , last_update_login = DECODE( p_last_update_login, null , last_update_login, FND_API.g_miss_num, null , p_last_update_login)
139: , object_version_number = nvl(p_object_version_number,0) + 1
140: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID

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

133: , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137: , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)
138: , last_update_login = DECODE( p_last_update_login, null , last_update_login, FND_API.g_miss_num, null , p_last_update_login)
139: , object_version_number = nvl(p_object_version_number,0) + 1
140: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
141: AND object_version_number = p_object_version_number;

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

134: , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135: , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136: , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137: , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)
138: , last_update_login = DECODE( p_last_update_login, null , last_update_login, FND_API.g_miss_num, null , p_last_update_login)
139: , object_version_number = nvl(p_object_version_number,0) + 1
140: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
141: AND object_version_number = p_object_version_number;
142:

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
141: AND object_version_number = p_object_version_number;
142:
143: IF (SQL%NOTFOUND) THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: END Update_Row;
147:
148:

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: BEGIN
169: DELETE FROM OZF_OFFER_ADJ_NEW_PRODUCTS
170: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID;
171: If (SQL%NOTFOUND) then
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: End If;
174: END Delete_Row ;
175:
176: