[Home] [Help]
PACKAGE: APPS.AK_CUSTOM_PUB
Source
1 package AK_CUSTOM_PUB AUTHID CURRENT_USER as
2 /* $Header: akdpcres.pls 115.6 2002/09/27 17:55:43 tshort noship $ */
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_CUSTOM_PUB';
8
9 -- Type definitions
10
11 -- Region primary key record
12
13 TYPE Custom_PK_Rec_Type IS RECORD (
14 custom_appl_id NUMBER := FND_API.G_MISS_NUM,
15 custom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
16 region_appl_id NUMBER := FND_API.G_MISS_NUM,
17 region_code VARCHAR2(30) := FND_API.G_MISS_CHAR
18 );
19
20 -- Customization Record
21
22 TYPE Custom_Rec_Type IS RECORD (
23 customization_appl_id NUMBER := NULL,
24 customization_code VARCHAR2(30) := NULL,
25 region_appl_id NUMBER := NULL,
26 region_code VARCHAR2(30) := NULL,
27 verticalization_id VARCHAR2(150) :=NULL,
28 localization_code VARCHAR2(150) := NULL,
29 org_id NUMBER := NULL,
30 site_id NUMBER := NULL,
31 responsibility_id NUMBER := NULL,
32 web_user_id NUMBER := NULL,
33 default_customization_flag VARCHAR2(1) := NULL,
34 customization_level_id NUMBER := NULL,
35 developer_mode VARCHAR2(1) := NULL,
36 reference_path VARCHAR2(100) := NULL,
37 function_name VARCHAR2(30) := NULL,
38 start_date_active DATE := NULL,
39 end_date_active DATE := NULL,
40 name VARCHAR2(80) := NULL,
41 description VARCHAR2(2000) := NULL,
42 created_by NUMBER := NULL,
43 creation_date DATE := NULL,
44 last_updated_by NUMBER := NULL,
45 last_update_date DATE := NULL,
46 last_update_login NUMBER := NULL);
47
48 -- Custom Region Record
49
50 TYPE Cust_Region_Rec_Type IS RECORD (
51 customization_appl_id NUMBER := NULL,
52 customization_code VARCHAR2(30) := NULL,
53 region_appl_id NUMBER := NULL,
54 region_code VARCHAR2(30) := NULL,
55 property_name VARCHAR2(30) := NULL,
56 property_varchar2_value VARCHAR2(2000) := NULL,
57 property_number_value NUMBER := NULL,
58 criteria_join_condition VARCHAR2(3) := NULL,
59 property_varchar2_value_tl VARCHAR2(2000) := NULL,
60 created_by NUMBER := NULL,
61 creation_date DATE := NULL,
62 last_updated_by NUMBER := NULL,
63 last_update_date DATE := NULL,
64 last_update_login NUMBER := NULL);
65
66 -- Custom Region Item Record
67
68 TYPE Cust_Reg_Item_Rec_Type IS RECORD (
69 customization_appl_id NUMBER := NULL,
70 customization_code VARCHAR2(30) := NULL,
71 region_appl_id NUMBER := NULL,
72 region_code VARCHAR2(30) := NULL,
73 attr_appl_id NUMBER := NULL,
74 attr_code VARCHAR2(30) := NULL,
75 property_name VARCHAR2(30) := NULL,
76 property_varchar2_value VARCHAR2(4000) := NULL,
77 property_number_value NUMBER := NULL,
78 property_date_value DATE := NULL,
79 property_varchar2_value_tl VARCHAR2(4000) := NULL,
80 created_by NUMBER := NULL,
81 creation_date DATE := NULL,
82 last_updated_by NUMBER := NULL,
83 last_update_date DATE := NULL,
84 last_update_login NUMBER := NULL);
85
86 -- Customization primary key table
87
88 TYPE Criteria_Tbl_Type IS TABLE OF AK_CRITERIA%ROWTYPE
89 INDEX BY BINARY_INTEGER;
90
91 TYPE Cust_Reg_Item_Tbl_Type IS TABLE OF Cust_Reg_Item_Rec_Type
92 INDEX BY BINARY_INTEGER;
93
94 TYPE Cust_Region_Tbl_Type IS TABLE OF Cust_Region_Rec_Type
95 INDEX BY BINARY_INTEGER;
96
97 TYPE Custom_PK_Tbl_Type IS TABLE OF Custom_PK_Rec_Type
98 INDEX BY BINARY_INTEGER;
99
100 TYPE Custom_Tbl_Type IS TABLE OF Custom_Rec_Type
101 INDEX BY BINARY_INTEGER;
102
103 /*Constants for missing data types */
104 G_MISS_CUST_REG_ITEM_REC Cust_Reg_Item_Rec_Type;
105 G_MISS_CUST_REG_ITEM_TBL Cust_Reg_Item_Tbl_Type;
106 G_MISS_CUST_REGION_REC Cust_Region_Rec_Type;
107 G_MISS_CUST_REGION_TBL Cust_Region_Tbl_Type;
108 G_MISS_CUSTOM_PK_REC Custom_PK_Rec_Type;
109 G_MISS_CUSTOM_PK_TBL Custom_PK_Tbl_Type;
110 G_MISS_CUSTOM_REC Custom_Rec_Type;
111 G_MISS_CUSTOM_TBL Custom_Tbl_Type;
112 G_MISS_CRITERIA_REC Criteria_Tbl_Type;
113
114 end AK_CUSTOM_PUB;