APPS.AD_PA_INSERT_PACKAGE dependencies on AD_PM_PRODUCT_INFO

Line 213: -- Procedure to insert/update in ad_pm_product_info

209: end insert_ad_pm_patches;
210:
211:
212: --
213: -- Procedure to insert/update in ad_pm_product_info
214: --
215:
216: procedure insert_ad_pm_product_info
217: (

Line 216: procedure insert_ad_pm_product_info

212: --
213: -- Procedure to insert/update in ad_pm_product_info
214: --
215:
216: procedure insert_ad_pm_product_info
217: (
218: X_product_abbreviation varchar2,
219: X_pseudo_product_flag varchar2,
220: X_product_family_flag varchar2,

Line 232: insert into ad_pm_product_info

228: X_created_by number
229: )
230: is
231: begin
232: insert into ad_pm_product_info
233: (
234: product_abbreviation ,
235: pseudo_product_flag ,
236: product_family_flag ,

Line 260: update ad_pm_product_info

256: to_date(X_currdate,'yyyy-mm-dd hh24:mi:ss')
257: );
258: exception
259: when dup_val_on_index then
260: update ad_pm_product_info
261: set pseudo_product_flag = X_pseudo_product_flag ,
262: product_family_flag = X_product_family_flag ,
263: application_short_name = X_application_short_name ,
264: product_name = X_product_name ,

Line 272: end insert_ad_pm_product_info ;

268: = to_date(X_currdate,'yyyy-mm-dd hh24:mi:ss'),
269: last_updated_by = X_last_updated_by
270: where product_abbreviation = X_product_abbreviation;
271:
272: end insert_ad_pm_product_info ;
273:
274:
275: --
276: -- Procedure to insert/update in ad_pm_prod_family_map