[Home] [Help]
PACKAGE: APPS.QP_ATTR_MAP_PVT
Source
1 PACKAGE QP_Attr_Map_PVT AS
2 /* $Header: QPXVMAPS.pls 120.3 2005/08/18 15:47:36 sfiresto ship $ */
3
4 -- Start of Comments
5 -- API name Process_Attr_Mapping
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Process_Attr_Mapping
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_commit IN VARCHAR2 := FND_API.G_FALSE
24 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25 , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
26 QP_GLOBALS.G_MISS_CONTROL_REC
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
31 QP_Attr_Map_PUB.G_MISS_PTE_REC
32 , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33 QP_Attr_Map_PUB.G_MISS_PTE_REC
34 , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35 QP_Attr_Map_PUB.G_MISS_RQT_TBL
36 , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37 QP_Attr_Map_PUB.G_MISS_RQT_TBL
38 , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39 QP_Attr_Map_PUB.G_MISS_SSC_TBL
40 , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41 QP_Attr_Map_PUB.G_MISS_SSC_TBL
42 , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43 QP_Attr_Map_PUB.G_MISS_PSG_TBL
44 , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45 QP_Attr_Map_PUB.G_MISS_PSG_TBL
46 , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47 QP_Attr_Map_PUB.G_MISS_SOU_TBL
48 , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49 QP_Attr_Map_PUB.G_MISS_SOU_TBL
50 , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51 QP_Attr_Map_PUB.G_MISS_FNA_TBL
52 , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53 QP_Attr_Map_PUB.G_MISS_FNA_TBL
54 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
59 , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
60 );
61
62 -- Start of Comments
63 -- API name Lock_Attr_Mapping
64 -- Type Private
65 -- Function
66 --
67 -- Pre-reqs
68 --
69 -- Parameters
70 --
71 -- Version Current version = 1.0
72 -- Initial version = 1.0
73 --
74 -- Notes
75 --
76 -- End of Comments
77
78 PROCEDURE Lock_Attr_Mapping
79 ( p_api_version_number IN NUMBER
80 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
81 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
83 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85 QP_Attr_Map_PUB.G_MISS_PTE_REC
86 , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87 QP_Attr_Map_PUB.G_MISS_RQT_TBL
88 , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89 QP_Attr_Map_PUB.G_MISS_SSC_TBL
90 , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91 QP_Attr_Map_PUB.G_MISS_PSG_TBL
92 , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93 QP_Attr_Map_PUB.G_MISS_SOU_TBL
94 , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95 QP_Attr_Map_PUB.G_MISS_FNA_TBL
96 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
101 , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
102 );
103
104 -- Start of Comments
105 -- API name Get_Attr_Mapping
106 -- Type Private
107 -- Function
108 --
109 -- Pre-reqs
110 --
111 -- Parameters
112 --
113 -- Version Current version = 1.0
114 -- Initial version = 1.0
115 --
116 -- Notes
117 --
118 -- End of Comments
119
120 PROCEDURE Get_Attr_Mapping
121 ( p_api_version_number IN NUMBER
122 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , p_lookup_code IN VARCHAR2
127 , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
128 , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129 , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130 , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131 , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
132 , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
133 );
134
135 -- Start of Comments
136 -- API name Check_Enabled_Fnas
137 -- Type Private
138 -- Function Executes Delayed Request to check for enabled functional areas
139 -- within the updated PTE/SS combinations. If there are any PTE/SS
140 -- combinations that have no enabled fnareas, it adds warning
141 -- messages to the stack.
142 --
143 -- Pre-reqs
144 --
145 -- Parameters
146 --
147 -- Version Current version = 1.0
148 -- Initial version = 1.0
149 --
150 -- Notes
151 --
152 -- End of Comments
153
154 PROCEDURE Check_Enabled_Fnas
155 ( x_msg_data OUT NOCOPY VARCHAR2
156 , x_msg_count OUT NOCOPY NUMBER
157 , x_return_status OUT NOCOPY VARCHAR2);
158
159 END QP_Attr_Map_PVT;