APPS.AD_PA_INSERT_PACKAGE dependencies on AD_PM_PATCHES

Line 5: -- Procedure to insert/update in table ad_pm_patches

1: package body ad_pa_insert_package as
2: /* $Header: adpaipb.pls 120.2 2006/03/27 08:07:14 msailoz noship $ */
3:
4: --
5: -- Procedure to insert/update in table ad_pm_patches
6: --
7:
8: procedure insert_ad_pm_patches
9: (

Line 8: procedure insert_ad_pm_patches

4: --
5: -- Procedure to insert/update in table ad_pm_patches
6: --
7:
8: procedure insert_ad_pm_patches
9: (
10: bug_number_value number,
11: aru_update_date_value varchar2,
12: product_abbreviation_value varchar2,

Line 35: insert into ad_pm_patches

31: X_last_update_date varchar2
32: )
33: is
34: begin
35: insert into ad_pm_patches
36: (
37: patch_metadata_key ,
38: bug_number ,
39: product_abbreviation,

Line 86: update ad_pm_patches

82: );
83:
84: exception
85: when dup_val_on_index then
86: update ad_pm_patches
87: set
88: product_abbreviation = product_abbreviation_value ,
89: product_family_abbreviation = nvl(product_family_abbv_value,'Not Found'),
90: patch_name = patch_name_value ,

Line 111: end insert_ad_pm_patches;

107: where
108: ( bug_number = bug_number_value
109: and patch_metadata_key = 'DEFAULT' );
110:
111: end insert_ad_pm_patches;
112:
113: -- msailoz bug#4956568 Set release name to R12
114: -- Procedure to insert/update in table ad_pm_patches for R12
115: --

Line 114: -- Procedure to insert/update in table ad_pm_patches for R12

110:
111: end insert_ad_pm_patches;
112:
113: -- msailoz bug#4956568 Set release name to R12
114: -- Procedure to insert/update in table ad_pm_patches for R12
115: --
116:
117: procedure insert_ad_pm_patches
118: (

Line 117: procedure insert_ad_pm_patches

113: -- msailoz bug#4956568 Set release name to R12
114: -- Procedure to insert/update in table ad_pm_patches for R12
115: --
116:
117: procedure insert_ad_pm_patches
118: (
119: bug_number_value number,
120: aru_update_date_value varchar2,
121: product_abbreviation_value varchar2,

Line 149: INSERT INTO ad_pm_patches

145: ELSE
146: l_entity_baseline := p_entity_baseline;
147: END IF;
148:
149: INSERT INTO ad_pm_patches
150: (
151: patch_metadata_key ,
152: bug_number ,
153: product_abbreviation,

Line 191: update ad_pm_patches

187: FROM DUAL;
188:
189: exception
190: when dup_val_on_index then
191: update ad_pm_patches
192: set
193: product_abbreviation = product_abbreviation_value ,
194: product_family_abbreviation = nvl(product_family_abbv_value,'Not Found'),
195: patch_name = patch_name_value ,

Line 209: end insert_ad_pm_patches;

205: ( bug_number = bug_number_value
206: and baseline = l_entity_baseline
207: and patch_metadata_key = 'DEFAULT' );
208:
209: end insert_ad_pm_patches;
210:
211:
212: --
213: -- Procedure to insert/update in ad_pm_product_info