DBA Data[Home] [Help]

PACKAGE: APPS.QP_QP_FORM_PSG

Source


1 PACKAGE QP_QP_Form_Psg AUTHID CURRENT_USER AS
2 /* $Header: QPXFPSGS.pls 120.1 2005/06/13 23:42:32 appldev  $ */
3 
4 --  Procedure : Default_Attributes
5 --
6 
7 PROCEDURE Default_Attributes
8 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
10 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 ,   x_attribute1                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 ,   x_attribute10                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 ,   x_attribute11                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 ,   x_attribute12                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 ,   x_attribute13                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 ,   x_attribute14                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 ,   x_attribute15                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 ,   x_attribute2                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 ,   x_attribute3                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 ,   x_attribute4                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 ,   x_attribute5                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 ,   x_attribute6                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 ,   x_attribute7                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 ,   x_attribute8                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 ,   x_attribute9                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 ,   x_limits_enabled                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 ,   x_lov_enabled                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 ,   x_pte_code                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 ,   x_seeded_sourcing_method        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 ,   x_segment_id                    OUT NOCOPY /* file.sql.39 change */ NUMBER
32 ,   x_segment_level                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 ,   x_segment_pte_id                OUT NOCOPY /* file.sql.39 change */ NUMBER
34 ,   x_sourcing_enabled              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 ,   x_sourcing_status               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 ,   x_user_sourcing_method          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 ,   x_pte                           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 ,   x_segment                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 ,   x_segment_pte                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 );
41 
42 --  Procedure   :   Change_Attribute
43 --
44 
45 PROCEDURE Change_Attribute
46 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
48 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 ,   p_segment_pte_id                IN  NUMBER
50 ,   p_attr_id                       IN  NUMBER
51 ,   p_attr_value                    IN  VARCHAR2
52 ,   p_attribute1                    IN  VARCHAR2
53 ,   p_attribute10                   IN  VARCHAR2
54 ,   p_attribute11                   IN  VARCHAR2
55 ,   p_attribute12                   IN  VARCHAR2
56 ,   p_attribute13                   IN  VARCHAR2
57 ,   p_attribute14                   IN  VARCHAR2
58 ,   p_attribute15                   IN  VARCHAR2
59 ,   p_attribute2                    IN  VARCHAR2
60 ,   p_attribute3                    IN  VARCHAR2
61 ,   p_attribute4                    IN  VARCHAR2
62 ,   p_attribute5                    IN  VARCHAR2
63 ,   p_attribute6                    IN  VARCHAR2
64 ,   p_attribute7                    IN  VARCHAR2
65 ,   p_attribute8                    IN  VARCHAR2
66 ,   p_attribute9                    IN  VARCHAR2
67 ,   p_context                       IN  VARCHAR2
68 ,   x_attribute1                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 ,   x_attribute10                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 ,   x_attribute11                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 ,   x_attribute12                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 ,   x_attribute13                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 ,   x_attribute14                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 ,   x_attribute15                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 ,   x_attribute2                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 ,   x_attribute3                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 ,   x_attribute4                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 ,   x_attribute5                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 ,   x_attribute6                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 ,   x_attribute7                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 ,   x_attribute8                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 ,   x_attribute9                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 ,   x_limits_enabled                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 ,   x_lov_enabled                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 ,   x_pte_code                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 ,   x_seeded_sourcing_method        OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 ,   x_segment_id                    OUT NOCOPY /* file.sql.39 change */ NUMBER
89 ,   x_segment_level                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 ,   x_segment_pte_id                OUT NOCOPY /* file.sql.39 change */ NUMBER
91 ,   x_sourcing_enabled              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ,   x_sourcing_status               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 ,   x_user_sourcing_method          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 ,   x_pte                           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 ,   x_segment                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 ,   x_segment_pte                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 );
98 
99 --  Procedure       Validate_And_Write
100 --
101 
102 PROCEDURE Validate_And_Write
103 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
105 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 ,   p_segment_pte_id                IN  NUMBER
107 ,   x_creation_date                 OUT NOCOPY /* file.sql.39 change */ DATE
108 ,   x_created_by                    OUT NOCOPY /* file.sql.39 change */ NUMBER
109 ,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
110 ,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
111 ,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
112 );
113 
114 --  Procedure       Delete_Row
115 --
116 
117 PROCEDURE Delete_Row
118 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
120 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 ,   p_segment_pte_id                IN  NUMBER
122 );
123 
124 --  Procedure       Process_Entity
125 --
126 
127 PROCEDURE Process_Entity
128 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
130 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 );
132 
133 --  Procedure       lock_Row
134 --
135 
136 PROCEDURE Lock_Row
137 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
139 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 ,   p_attribute1                    IN  VARCHAR2
141 ,   p_attribute10                   IN  VARCHAR2
142 ,   p_attribute11                   IN  VARCHAR2
143 ,   p_attribute12                   IN  VARCHAR2
144 ,   p_attribute13                   IN  VARCHAR2
145 ,   p_attribute14                   IN  VARCHAR2
146 ,   p_attribute15                   IN  VARCHAR2
147 ,   p_attribute2                    IN  VARCHAR2
148 ,   p_attribute3                    IN  VARCHAR2
149 ,   p_attribute4                    IN  VARCHAR2
150 ,   p_attribute5                    IN  VARCHAR2
151 ,   p_attribute6                    IN  VARCHAR2
152 ,   p_attribute7                    IN  VARCHAR2
153 ,   p_attribute8                    IN  VARCHAR2
154 ,   p_attribute9                    IN  VARCHAR2
155 ,   p_context                       IN  VARCHAR2
156 ,   p_created_by                    IN  NUMBER
157 ,   p_creation_date                 IN  DATE
158 ,   p_last_updated_by               IN  NUMBER
159 ,   p_last_update_date              IN  DATE
160 ,   p_last_update_login             IN  NUMBER
161 ,   p_limits_enabled                IN  VARCHAR2
162 ,   p_lov_enabled                   IN  VARCHAR2
163 ,   p_program_application_id        IN  NUMBER
164 ,   p_program_id                    IN  NUMBER
165 ,   p_program_update_date           IN  DATE
166 ,   p_pte_code                      IN  VARCHAR2
167 ,   p_seeded_sourcing_method        IN  VARCHAR2
168 ,   p_segment_id                    IN  NUMBER
169 ,   p_segment_level                 IN  VARCHAR2
170 ,   p_segment_pte_id                IN  NUMBER
171 ,   p_sourcing_enabled              IN  VARCHAR2
172 ,   p_sourcing_status               IN  VARCHAR2
173 ,   p_user_sourcing_method          IN  VARCHAR2
174 );
175 
176 END QP_QP_Form_Psg;