[Home] [Help]
PACKAGE: APPS.BIS_CUSTOMIZATIONS_PVT
Source
1 PACKAGE BIS_CUSTOMIZATIONS_PVT AS
2 /* $Header: BISVCUSS.pls 120.1 2006/09/04 06:13:24 ankgoel noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.3=120.1):~PROD:~PATH:~FILE
5
6 /*
7 REM +=======================================================================+
8 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
9 REM | All rights reserved. |
10 REM +=======================================================================+
11 REM | FILENAME |
12 REM | BISVCUSS.pls |
13 REM | |
14 REM | DESCRIPTION |
15 REM | Private API for shipping ak customizations at function level |
16 REM | |
17 REM | NOTES |
18 REM | |
19 REM | HISTORY |
20 REM | 16-Dec-02 nkishore Creation |
21 REM | 09-Apr-03 rcmuthuk Added deleteCustomView Enh:2897956 |
22 REM | 09-Aug-06 ankgoel Bug#5412517 Del all customizations for a ak region |
23 REM +=======================================================================+
24 */
25 --
26 -- Data Types: Records
27 --
28 TYPE customizations_type IS RECORD
29 ( CUSTOMIZATION_APPLICATION_ID NUMBER :=NULL
30 ,CUSTOMIZATION_CODE VARCHAR2(30) :=NULL
31 ,REGION_APPLICATION_ID NUMBER(15) :=NULL
32 ,REGION_CODE VARCHAR2(30) :=NULL
33 ,VERTICALIZATION_ID VARCHAR2(150) :=NULL
34 ,LOCALIZATION_CODE VARCHAR2(150) :=NULL
35 ,ORG_ID NUMBER :=NULL
36 ,SITE_ID NUMBER :=NULL
37 ,RESPONSIBILITY_ID NUMBER :=NULL
38 ,WEB_USER_ID NUMBER :=NULL
39 ,DEFAULT_CUSTOMIZATION_FLAG VARCHAR2(1) :=NULL
40 ,CUSTOMIZATION_LEVEL_ID NUMBER :=NULL
41 ,START_DATE_ACTIVE DATE :=NULL
42 ,END_DATE_ACTIVE DATE :=NULL
43 ,REFERENCE_PATH VARCHAR2(100) :=NULL
44 ,FUNCTION_NAME fnd_form_functions.function_name%TYPE :=NULL
45 ,DEVELOPER_MODE VARCHAR2(1) :=NULL
46 ,NAME VARCHAR2(80) :=NULL
47 ,DESCRIPTION VARCHAR2(2000) :=NULL
48 );
49
50
51 TYPE custom_regions_type IS RECORD
52 (CUSTOMIZATION_APPLICATION_ID NUMBER :=NULL
53 , CUSTOMIZATION_CODE VARCHAR2(30) :=NULL
54 , REGION_APPLICATION_ID NUMBER :=NULL
55 , REGION_CODE VARCHAR2(30) :=NULL
56 , PROPERTY_NAME VARCHAR2(30) :=NULL
57 , PROPERTY_VARCHAR2_VALUE VARCHAR2(4000) :=NULL
58 , PROPERTY_NUMBER_VALUE NUMBER :=NULL
59 , CRITERIA_JOIN_CONDITION VARCHAR2(3) :=NULL
60 );
61
62 TYPE custom_region_items_type IS RECORD
63 (CUSTOMIZATION_APPLICATION_ID NUMBER :=NULL
64 , CUSTOMIZATION_CODE VARCHAR2(30) :=NULL
65 , REGION_APPLICATION_ID NUMBER :=NULL
66 , REGION_CODE VARCHAR2(30) :=NULL
67 , ATTRIBUTE_APPLICATION_ID NUMBER :=NULL
68 , ATTRIBUTE_CODE VARCHAR2(30) :=NULL
69 , PROPERTY_NAME VARCHAR2(30) :=NULL
70 , PROPERTY_VARCHAR2_VALUE VARCHAR2(4000) :=NULL
71 , PROPERTY_NUMBER_VALUE NUMBER :=NULL
72 , PROPERTY_DATE_VALUE DATE :=NULL
73 );
74
75 --
76 -- PROCEDUREs
77 --
78 -- creates rows into ak_customizations and tl tables
79 --
80 PROCEDURE Create_Customizations
81 ( p_api_version IN NUMBER
82 , p_commit IN VARCHAR2 := 'N'
83 , p_Customizations_Rec IN BIS_CUSTOMIZATIONS_PVT.customizations_type
84 , x_return_status OUT NOCOPY VARCHAR2
85 );
86 --
87 --
88 --
89 -- PLEASE VERIFY COMMENT BELOW
90 -- Update_Customizations and tl
91 --
92 --
93 PROCEDURE Update_Customizations
94 ( p_api_version IN NUMBER
95 , p_commit IN VARCHAR2 := 'N'
96 , p_Customizations_Rec IN BIS_CUSTOMIZATIONS_PVT.customizations_type
97 , x_return_status OUT NOCOPY VARCHAR2
98 );
99 --
100 --
101 -- creates rows into ak_custom_regions and tl tables
102 --
103 PROCEDURE Create_Custom_regions
104 ( p_api_version IN NUMBER
105 , p_commit IN VARCHAR2 := 'N'
106 , p_Custom_regions_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_regions_type
107 , x_return_status OUT NOCOPY VARCHAR2
108 );
109 --
110 --
111 -- updates rows into ak_custom_regions and tl tables
112 --
113 PROCEDURE Update_Custom_regions
114 ( p_api_version IN NUMBER
115 , p_commit IN VARCHAR2 := 'N'
116 , p_Custom_regions_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_regions_type
117 , x_return_status OUT NOCOPY VARCHAR2
118 );
119 --
120 --
121 -- creates rows into ak_custom_region_items and tl tables
122 --
123 PROCEDURE Create_Custom_region_items
124 ( p_api_version IN NUMBER
125 , p_commit IN VARCHAR2 := 'N'
126 , p_Custom_region_items_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_region_items_type
127 , x_return_status OUT NOCOPY VARCHAR2
128 );
129 --
130 --
131 -- updates rows into ak_custom_region_items and tl tables
132 --
133 PROCEDURE Update_Custom_region_items
134 ( p_api_version IN NUMBER
135 , p_commit IN VARCHAR2 := 'N'
136 , p_Custom_region_items_Rec IN BIS_CUSTOMIZATIONS_PVT.custom_region_items_type
137 , x_return_status OUT NOCOPY VARCHAR2
138 );
139 --
140 --
141 -- rcmuthuk Enh:2897956
142 -- deletes a custom view from all tables
143 --
144 PROCEDURE deleteCustomView
145 ( p_regionCode IN VARCHAR2
146 , p_customizationCode IN VARCHAR2
147 , p_regionAppId IN NUMBER
148 , p_customizationAppId IN NUMBER
149 , x_return_status OUT NOCOPY VARCHAR2
150 );
151
152 PROCEDURE delete_region_customizations
153 ( p_region_code IN VARCHAR2
154 , p_region_application_id IN NUMBER
155 , x_return_status OUT NOCOPY VARCHAR2
156 , x_msg_count OUT NOCOPY NUMBER
157 , x_msg_data OUT NOCOPY VARCHAR2
158 );
159 --
160 --
161 END BIS_CUSTOMIZATIONS_PVT;