APPS.AD_PA_INSERT_PACKAGE dependencies on AD_PM_PROD_FAMILY_MAP

Line 276: -- Procedure to insert/update in ad_pm_prod_family_map

272: end insert_ad_pm_product_info ;
273:
274:
275: --
276: -- Procedure to insert/update in ad_pm_prod_family_map
277: -- Added for Bug# 2814295 to update the new AD Patch Advisor
278: -- table ad_pm_prod_family_map
279:
280: procedure insert_ad_pm_prod_family_map

Line 278: -- table ad_pm_prod_family_map

274:
275: --
276: -- Procedure to insert/update in ad_pm_prod_family_map
277: -- Added for Bug# 2814295 to update the new AD Patch Advisor
278: -- table ad_pm_prod_family_map
279:
280: procedure insert_ad_pm_prod_family_map
281: (
282: X_product_abbreviation varchar2,

Line 280: procedure insert_ad_pm_prod_family_map

276: -- Procedure to insert/update in ad_pm_prod_family_map
277: -- Added for Bug# 2814295 to update the new AD Patch Advisor
278: -- table ad_pm_prod_family_map
279:
280: procedure insert_ad_pm_prod_family_map
281: (
282: X_product_abbreviation varchar2,
283: X_product_family_abbreviation varchar2,
284: X_aru_update_date varchar2,

Line 291: insert into ad_pm_prod_family_map

287: X_created_by number
288: )
289: is
290: begin
291: insert into ad_pm_prod_family_map
292: (
293: product_abbreviation ,
294: product_family_abbreviation,
295: creation_date ,

Line 312: -- is the primary key for the table AD_PM_PROD_FAMILY_MAP

308: );
309:
310: -- do nothing if the info already exists in table
311: -- Combination of PRODUCT_ABBREVIATION AND PRODUCT_FAMILY_ABBREVIATION
312: -- is the primary key for the table AD_PM_PROD_FAMILY_MAP
313: exception
314: when dup_val_on_index then
315: update ad_pm_prod_family_map
316: set

Line 315: update ad_pm_prod_family_map

311: -- Combination of PRODUCT_ABBREVIATION AND PRODUCT_FAMILY_ABBREVIATION
312: -- is the primary key for the table AD_PM_PROD_FAMILY_MAP
313: exception
314: when dup_val_on_index then
315: update ad_pm_prod_family_map
316: set
317: last_updated_by = X_last_updated_by ,
318: last_update_date = to_date(X_currdate,'yyyy-mm-dd hh24:mi:ss')
319: where

Line 323: end insert_ad_pm_prod_family_map;

319: where
320: product_abbreviation = X_product_abbreviation
321: and product_family_abbreviation = X_product_family_abbreviation;
322:
323: end insert_ad_pm_prod_family_map;
324:
325: end ad_pa_insert_package;