PACKAGE: APPS.AD_PA_INSERT_PACKAGE

Source

1 package ad_pa_insert_package as
2 /* $Header: adpaips.pls 120.1 2006/03/24 03:25:44 msailoz noship $ */
3 
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,
13    product_family_abbv_value  varchar2,
14    patch_name_value            varchar2,
15    conc_request_id             number,
16    bug_description_value       varchar2,
17    is_family_pack_flag 	       varchar2,
18    is_mini_pack_flag	       varchar2,
19    is_high_priority_flag       varchar2,
20    is_maint_pack_flag          varchar2,
21    X_in_reference_family_pack  varchar2,
22    X_reference_family_pack     varchar2,
23    X_in_reference_mini_pack    varchar2,
24    X_reference_mini_pack       varchar2,
25    X_in_reference_maint_pack   varchar2,
26    X_reference_maint_pack      varchar2,
27    X_infobundle_upload_date    varchar2,
28    X_creation_date             varchar2,
29    X_last_updated_by           number,
30    X_created_by                number,
31    X_last_update_date          varchar2
32 );
33 
34 -- msailoz bug#4956568 Set release name to R12
35 -- Procedure to insert/update in table ad_pm_patches for R12
36 --
37 
38 procedure insert_ad_pm_patches
39 (
40    bug_number_value            number,
41    aru_update_date_value       varchar2,
42    product_abbreviation_value  varchar2,
43    product_family_abbv_value  varchar2,
44    patch_name_value            varchar2,
45    conc_request_id             number,
46    bug_description_value       varchar2,
47    is_high_priority_flag       varchar2,
48    X_infobundle_upload_date    varchar2,
49    X_creation_date             varchar2,
50    X_last_updated_by           number,
51    X_created_by                number,
52    X_last_update_date          varchar2,
53    is_code_level_flag           varchar2,
54    p_patch_type                varchar2,
55    p_entity_abbr                varchar2,
56    p_entity_baseline            varchar2
57 );
58 
59 --
60 -- Procedure to insert/update in ad_pm_product_info
61 --
62 
63 procedure insert_ad_pm_product_info
64  (
65   X_product_abbreviation        varchar2,
66   X_pseudo_product_flag         varchar2,
67   X_product_family_flag         varchar2,
68   X_application_short_name      varchar2,
69   X_product_name                varchar2,
70   X_product_family_abbreviation varchar2,
71   X_product_family_name         varchar2,
72   X_aru_update_date             varchar2,
73   X_currDate                    varchar2 ,
74   X_last_updated_by             number,
75   X_created_by                  number
76  );
77 
78 
79 --
80 -- Procedure to insert/update in ad_pm_prod_family_map
81 --  Added for Bug# 2814295 to update the new AD Patch Advisor
82 --  table ad_pm_prod_family_map
83 
84 procedure insert_ad_pm_prod_family_map
85  (
86   X_product_abbreviation        varchar2,
87   X_product_family_abbreviation varchar2,
88   X_aru_update_date             varchar2,
89   X_currDate                    varchar2,
90   X_last_updated_by             number,
91   X_created_by                  number
92  );
93 
94 
95 end ad_pa_insert_package;