125: , attribute15
126:
127:
128: ) VALUES (
129: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
126:
127:
128: ) VALUES (
129: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
127:
128: ) VALUES (
129: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
128: ) VALUES (
129: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
129: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
131: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
132: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
133: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
134: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
135: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_id),
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_id),
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)
156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)
164: );
157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)
164: );
165:
158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)
164: );
165:
166: INSERT INTO AMS_COMPETITOR_PRODUCTS_TL(
159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)
160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)
161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)
162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)
163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)
164: );
165:
166: INSERT INTO AMS_COMPETITOR_PRODUCTS_TL(
167: competitor_product_id,
176: description
177: --,security_group_id
178: )
179: SELECT
180: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),
181: l.language_code,
182: USERENV('LANG'),
183: sysdate,
184: FND_GLOBAL.user_id,
184: FND_GLOBAL.user_id,
185: FND_GLOBAL.conc_login_id,
186: sysdate,
187: FND_GLOBAL.user_id,
188: DECODE( p_competitor_product_name, FND_API.g_miss_char, NULL, p_competitor_product_name),
189: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
190: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
191: FROM fnd_languages l
192: WHERE l.installed_flag IN ('I','B')
185: FND_GLOBAL.conc_login_id,
186: sysdate,
187: FND_GLOBAL.user_id,
188: DECODE( p_competitor_product_name, FND_API.g_miss_char, NULL, p_competitor_product_name),
189: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
190: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
191: FROM fnd_languages l
192: WHERE l.installed_flag IN ('I','B')
193: AND NOT EXISTS(
186: sysdate,
187: FND_GLOBAL.user_id,
188: DECODE( p_competitor_product_name, FND_API.g_miss_char, NULL, p_competitor_product_name),
189: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
190: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
191: FROM fnd_languages l
192: WHERE l.installed_flag IN ('I','B')
193: AND NOT EXISTS(
194: SELECT NULL
192: WHERE l.installed_flag IN ('I','B')
193: AND NOT EXISTS(
194: SELECT NULL
195: FROM ams_competitor_products_tl t
196: WHERE t.competitor_product_id = DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id)
197: AND t.language = l.language_code ) ;
198:
199:
200: END Insert_Row;
257: AMS_UTILITY_PVT.debug_message('Pub update: start');
258:
259: Update AMS_COMPETITOR_PRODUCTS_B
260: SET
261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
258:
259: Update AMS_COMPETITOR_PRODUCTS_B
260: SET
261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
259: Update AMS_COMPETITOR_PRODUCTS_B
260: SET
261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
260: SET
261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
263: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, to_date(null), to_date(null), last_update_date, p_last_update_date),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
264: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, null, null, last_updated_by, p_last_updated_by),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
267: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num,null, null, last_update_login, p_last_update_login),
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_id),
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_id),
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_id)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)
287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)
295: , attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, null, null , attribute15 , p_attribute15)
288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)
295: , attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, null, null , attribute15 , p_attribute15)
296: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)
295: , attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, null, null , attribute15 , p_attribute15)
296: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
297: AND object_version_number = p_object_version_number;
290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)
295: , attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, null, null , attribute15 , p_attribute15)
296: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
297: AND object_version_number = p_object_version_number;
298:
291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)
292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)
293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)
294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)
295: , attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, null, null , attribute15 , p_attribute15)
296: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
297: AND object_version_number = p_object_version_number;
298:
299: IF (SQL%NOTFOUND) THEN
296: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
297: AND object_version_number = p_object_version_number;
298:
299: IF (SQL%NOTFOUND) THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303: UPDATE AMS_COMPETITOR_PRODUCTS_TL
304: SET
301: END IF;
302:
303: UPDATE AMS_COMPETITOR_PRODUCTS_TL
304: SET
305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),
306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
307: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
308: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
309: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
302:
303: UPDATE AMS_COMPETITOR_PRODUCTS_TL
304: SET
305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),
306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
307: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
308: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
309: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
310: source_lang = USERENV('LANG')
303: UPDATE AMS_COMPETITOR_PRODUCTS_TL
304: SET
305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),
306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
307: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
308: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
309: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
310: source_lang = USERENV('LANG')
311: WHERE competitor_product_id = p_competitor_product_id
304: SET
305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),
306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
307: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
308: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
309: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
310: source_lang = USERENV('LANG')
311: WHERE competitor_product_id = p_competitor_product_id
312: AND USERENV('LANG') IN (language, source_lang);
305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),
306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
307: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
308: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
309: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
310: source_lang = USERENV('LANG')
311: WHERE competitor_product_id = p_competitor_product_id
312: AND USERENV('LANG') IN (language, source_lang);
313:
311: WHERE competitor_product_id = p_competitor_product_id
312: AND USERENV('LANG') IN (language, source_lang);
313:
314: IF (SQL%NOTFOUND) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318:
319:
340: DELETE FROM AMS_COMPETITOR_PRODUCTS_B
341: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID
342: AND object_version_number = p_object_version_number;
343: If (SQL%NOTFOUND) then
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: End If;
346:
347: DELETE FROM AMS_COMPETITOR_PRODUCTS_TL
348: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID;
346:
347: DELETE FROM AMS_COMPETITOR_PRODUCTS_TL
348: WHERE COMPETITOR_PRODUCT_ID = p_COMPETITOR_PRODUCT_ID;
349: If (SQL%NOTFOUND) then
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: End If;
352:
353:
354: END Delete_Row ;