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.AMS_COMPETITOR_PRODUCTS_B_PKG dependencies on FND_API

Line 129: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id),

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

Line 130: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

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

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

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

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

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

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

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

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

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

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

Line 136: DECODE( p_competitor_party_id, FND_API.g_miss_num, NULL, p_competitor_party_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),

Line 137: DECODE( p_competitor_product_code, FND_API.g_miss_char, NULL, p_competitor_product_code),

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

Line 138: DECODE( p_interest_type_id, FND_API.g_miss_num, NULL, p_interest_type_id),

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)

Line 139: DECODE( p_inventory_item_id, FND_API.g_miss_num, NULL, p_inventory_item_id),

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)

Line 140: DECODE( p_organization_id, FND_API.g_miss_num, NULL, p_organization_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)

Line 141: DECODE( p_comp_product_url, FND_API.g_miss_char, NULL, p_comp_product_url),

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)

Line 142: DECODE( p_original_system_ref, FND_API.g_miss_char, NULL, p_original_system_ref)

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)

Line 143: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_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)

Line 144: ,DECODE( p_start_date, FND_API.g_miss_date, NULL, p_start_date)

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)

Line 145: ,DECODE( p_end_date, FND_API.g_miss_date, NULL, p_end_date)

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)

Line 146: ,DECODE( p_category_id, FND_API.g_miss_num, NULL, p_category_id)

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)

Line 147: ,DECODE( p_category_set_id, FND_API.g_miss_num, NULL, p_category_set_id)

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)

Line 148: , DECODE(p_context , FND_API.G_MISS_CHAR , NULL , p_context)

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)

Line 149: , DECODE(p_attribute1 , FND_API.G_MISS_CHAR, NULL , p_attribute1)

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)

Line 150: , DECODE(p_attribute2 , FND_API.G_MISS_CHAR, NULL , p_attribute2)

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)

Line 151: , DECODE(p_attribute3 , FND_API.G_MISS_CHAR, NULL , p_attribute3)

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)

Line 152: , DECODE(p_attribute4 , FND_API.G_MISS_CHAR, NULL , p_attribute4)

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)

Line 153: , DECODE(p_attribute5 , FND_API.G_MISS_CHAR, NULL , p_attribute5)

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)

Line 154: , DECODE(p_attribute6 , FND_API.G_MISS_CHAR, NULL , p_attribute6)

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)

Line 155: , DECODE(p_attribute7 , FND_API.G_MISS_CHAR, NULL , p_attribute7)

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)

Line 156: , DECODE(p_attribute8 , FND_API.G_MISS_CHAR, NULL , p_attribute8)

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)

Line 157: , DECODE(p_attribute9 , FND_API.G_MISS_CHAR, NULL , p_attribute9)

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)

Line 158: , DECODE(p_attribute10 , FND_API.G_MISS_CHAR, NULL , p_attribute10)

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)

Line 159: , DECODE(p_attribute11 , FND_API.G_MISS_CHAR, NULL , p_attribute11)

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)

Line 160: , DECODE(p_attribute12 , FND_API.G_MISS_CHAR, NULL , p_attribute12)

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

Line 161: , DECODE(p_attribute13 , FND_API.G_MISS_CHAR, NULL , p_attribute13)

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:

Line 162: , DECODE(p_attribute14 , FND_API.G_MISS_CHAR, NULL , p_attribute14)

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(

Line 163: , DECODE(p_attribute15 , FND_API.G_MISS_CHAR, NULL , p_attribute15)

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,

Line 180: DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_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,

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

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

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

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(

Line 190: --,DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_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(
194: SELECT NULL

Line 196: WHERE t.competitor_product_id = DECODE( px_competitor_product_id, FND_API.g_miss_num, NULL, px_competitor_product_id)

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;

Line 261: competitor_product_id = DECODE( p_competitor_product_id, FND_API.g_miss_num, null, null, competitor_product_id, p_competitor_product_id),

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

Line 262: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, null, null, object_version_number, p_object_version_number),

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

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

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

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

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

Line 265: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, to_date(null) , to_date(null), creation_date, p_creation_date),

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

Line 266: created_by = DECODE( p_created_by, FND_API.g_miss_num, null, null, created_by, p_created_by),

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

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

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

Line 268: competitor_party_id = DECODE( p_competitor_party_id, FND_API.g_miss_num, null, null, competitor_party_id, p_competitor_party_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),

Line 269: competitor_product_code = DECODE( p_competitor_product_code, FND_API.g_miss_char, null, null, competitor_product_code, p_competitor_product_code),

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

Line 270: interest_type_id = DECODE( p_interest_type_id, FND_API.g_miss_num, null, null, interest_type_id, p_interest_type_id),

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)

Line 271: inventory_item_id = DECODE( p_inventory_item_id, FND_API.g_miss_num, null, p_inventory_item_id),

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)

Line 272: organization_id = DECODE( p_organization_id, FND_API.g_miss_num, null, p_organization_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)

Line 273: comp_product_url = DECODE( p_comp_product_url, FND_API.g_miss_char, null , null, comp_product_url, p_comp_product_url),

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)

Line 274: original_system_ref = DECODE( p_original_system_ref, FND_API.g_miss_char, null , null , original_system_ref, p_original_system_ref)

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)

Line 275: --,security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, null , null , security_group_id, p_security_group_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)

Line 276: ,start_date = DECODE( p_start_date, FND_API.g_miss_date, to_date(null), to_date(null), start_date, p_start_date)

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 )

Line 277: ,end_date = DECODE( p_end_date, FND_API.g_miss_date, to_date(null), to_date(null), end_date, p_end_date)

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)

Line 278: ,category_id = DECODE( p_category_id, FND_API.g_miss_num, null, p_category_id)

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)

Line 279: ,category_set_id = DECODE( p_category_set_id, FND_API.g_miss_num, null, p_category_Set_id)

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)

Line 280: , context = DECODE(p_context, FND_API.G_MISS_CHAR, null, null , context, p_context )

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)

Line 281: , attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, null, null , attribute1 , p_attribute1)

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)

Line 282: , attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, null, null , attribute2 , p_attribute2)

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)

Line 283: , attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, null, null , attribute3 , p_attribute3)

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)

Line 284: , attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, null, null , attribute4 , p_attribute4)

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)

Line 285: , attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, null, null , attribute5 , p_attribute5)

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)

Line 286: , attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, null, null , attribute6 , p_attribute6)

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)

Line 287: , attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, null, null , attribute7 , p_attribute7)

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)

Line 288: , attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, null, null , attribute8 , p_attribute8)

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)

Line 289: , attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, null, null , attribute9 , p_attribute9)

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)

Line 290: , attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, null, null , attribute10 , p_attribute10)

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)

Line 291: , attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute11)

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)

Line 292: , attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, null, null , attribute12 , p_attribute12)

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

Line 293: , attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, null, null , attribute13 , p_attribute13)

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;

Line 294: , attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, null, null , attribute14 , p_attribute14)

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:

Line 295: , attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, null, null , attribute15 , p_attribute15)

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

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 305: competitor_product_name = DECODE( p_competitor_product_name, FND_API.g_miss_char, competitor_product_name, p_competitor_product_name),

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

Line 306: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),

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

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

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

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

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

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

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:

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 ;