[Home] [Help]
PACKAGE: APPS.OZF_DENORM_QUERIES_PVT
Source
1 Package Ozf_Denorm_Queries_Pvt AS
2 /* $Header: ozfvofds.pls 120.0 2005/06/01 00:24:29 appldev noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_Denorm_Queries_PVT';
4
5 TYPE stringArray IS TABLE OF VARCHAR2(4000)INDEX BY BINARY_INTEGER ;
6
7
8 TYPE denorm_queries_rec_type IS RECORD
9 (
10 DENORM_QUERY_ID NUMBER
11 ,QUERY_FOR VARCHAR2(30)
12 ,CONTEXT VARCHAR2(30)
13 ,ATTRIBUTE VARCHAR2(30)
14 ,SQL_STATEMENT VARCHAR2(32000)
15 ,ACTIVE_FLAG VARCHAR2(1)
16 ,CONDITION_NAME_COLUMN VARCHAR2(30)
17 ,CONDITION_ID_COLUMN VARCHAR2(30)
18 ,LAST_UPDATE_DATE DATE
19 ,LAST_UPDATED_BY NUMBER
20 ,CREATION_DATE DATE
21 ,CREATED_BY NUMBER
22 ,LAST_UPDATE_LOGIN NUMBER
23 ,OBJECT_VERSION_NUMBER NUMBER
24 ,SECURITY_GROUP_ID NUMBER
25
26 );
27
28
29
30 PROCEDURE create_denorm_queries
31 (
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
34 p_commit IN VARCHAR2 := FND_API.g_false,
35 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
36
37 p_denorm_queries_rec IN denorm_queries_rec_type,
38
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42
43 x_denorm_query_id OUT NOCOPY NUMBER
44 );
45
46 PROCEDURE update_denorm_queries
47 (
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
50 p_commit IN VARCHAR2 := FND_API.g_false,
51 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
52
53 p_denorm_queries_rec IN denorm_queries_rec_type,
54
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58
59 );
60
61 PROCEDURE delete_denorm_queries
62 (
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65 p_commit IN VARCHAR2 := FND_API.g_false,
66
67 p_denorm_query_id IN NUMBER,
68 p_object_version IN NUMBER,
69
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE validate_denorm_queries(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
78 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
79 p_validation_mode IN VARCHAR2,
80 p_denorm_queries_rec IN denorm_queries_rec_type,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86
87 ---------------------------------------------------------------------
88 -- PROCEDURE
89
90 --
91 -- PURPOSE
92 -- Perform the item level checking including unique keys,
93 -- required columns, foreign keys, domain constraints.
94 --
95 -- PARAMETERS
96
97 ---------------------------------------------------------------------
98 PROCEDURE check_denorm_queries_items(
99 p_denorm_queries_rec IN denorm_queries_rec_type,
100 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
101 x_return_status OUT NOCOPY VARCHAR2
102 );
103
104
105 ---------------------------------------------------------------------
106 -- PROCEDURE
107
108 --
109 -- PURPOSE
110 -- Check the record level business rules.
111 --
112 -- PARAMETERS
113
114 ---------------------------------------------------------------------
115
116 PROCEDURE check_denorm_queries_record (
117 p_denorm_queries_rec IN denorm_queries_rec_type,
118 x_return_status OUT NOCOPY VARCHAR2
119 );
120
121
122 ---------------------------------------------------------------------
123 -- PROCEDURE
124 -- init_denorm_queries_rec
125 --
126 -- PURPOSE
127 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
128 ---------------------------------------------------------------------
129 PROCEDURE init_denorm_queries_rec(
130 x_denorm_queries_rec OUT NOCOPY denorm_queries_rec_type
131 );
132 PROCEDURE complete_denorm_queries_rec(
133 p_denorm_queries_rec IN denorm_queries_rec_type,
134 x_complete_rec OUT NOCOPY denorm_queries_rec_type
135 );
136
137
138 PROCEDURE string_length_check(sqlst IN VARCHAR2, sArray OUT NOCOPY stringArray);
139
140 END Ozf_Denorm_Queries_Pvt;