[Home] [Help]
PACKAGE: APPS.OE_OE_FORM_HEADER_SCREDIT
Source
1 PACKAGE OE_OE_Form_Header_Scredit AUTHID CURRENT_USER AS
2 /* $Header: OEXFHSCS.pls 120.0 2005/05/31 23:15:51 appldev noship $ */
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 , p_header_id IN NUMBER
12 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_dw_update_advice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
30 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
31 , x_percent OUT NOCOPY /* file.sql.39 change */ NUMBER
32 , x_salesrep_id OUT NOCOPY /* file.sql.39 change */ NUMBER
33 , x_sales_credit_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
34 , x_sales_credit_id OUT NOCOPY /* file.sql.39 change */ NUMBER
35 , x_wh_update_date OUT NOCOPY /* file.sql.39 change */ DATE
36 , x_salesrep OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 , x_sales_credit_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 --SG {
39 , x_sales_group_id OUT NOCOPY /* file.sql.39 change */ NUMBER
40 , x_sales_group_updated_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 --SG}
42 );
43
44 -- Procedure : Change_Attribute
45 --
46
47 PROCEDURE Change_Attribute
48 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
50 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 , p_sales_credit_id IN NUMBER
52 , p_attr_id IN NUMBER
53 , p_attr_value IN VARCHAR2
54 , p_attribute1 IN VARCHAR2
55 , p_attribute10 IN VARCHAR2
56 , p_attribute11 IN VARCHAR2
57 , p_attribute12 IN VARCHAR2
58 , p_attribute13 IN VARCHAR2
59 , p_attribute14 IN VARCHAR2
60 , p_attribute15 IN VARCHAR2
61 , p_attribute2 IN VARCHAR2
62 , p_attribute3 IN VARCHAR2
63 , p_attribute4 IN VARCHAR2
64 , p_attribute5 IN VARCHAR2
65 , p_attribute6 IN VARCHAR2
66 , p_attribute7 IN VARCHAR2
67 , p_attribute8 IN VARCHAR2
68 , p_attribute9 IN VARCHAR2
69 , p_context IN VARCHAR2
70 --SG {
71 , p_sales_group_id IN NUMBER
72 , p_sales_group_updated_flag IN VARCHAR2
73 --SG}
74 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_dw_update_advice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
92 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
93 , x_percent OUT NOCOPY /* file.sql.39 change */ NUMBER
94 , x_salesrep_id OUT NOCOPY /* file.sql.39 change */ NUMBER
95 , x_sales_credit_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
96 , x_sales_credit_id OUT NOCOPY /* file.sql.39 change */ NUMBER
97 , x_wh_update_date OUT NOCOPY /* file.sql.39 change */ DATE
98 , x_salesrep OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , x_sales_credit_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 --SG {
101 , x_sales_group OUT NOCOPY VARCHAR2
102 , x_sales_group_id OUT NOCOPY NUMBER
103 , x_sales_group_updated_flag OUT NOCOPY VARCHAR2
104 --SG}
105 );
106
107 -- Procedure Validate_And_Write
108 --
109
110 PROCEDURE Validate_And_Write
111 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
113 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , p_sales_credit_id IN NUMBER
115 , p_change_reason_code IN VARCHAR2
116 , p_change_comments IN VARCHAR2
117 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
118 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
119 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
120 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
121 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
122 , x_lock_control OUT NOCOPY /* file.sql.39 change */ NUMBER
123 );
124
125 -- Procedure Delete_Row
126 --
127
128 PROCEDURE Delete_Row
129 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
131 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , p_sales_credit_id IN NUMBER
133 , p_change_reason_code IN VARCHAR2 Default Null
134 , p_change_comments IN VARCHAR2 Default Null
135 );
136
137 -- Procedure Process_Entity
138 --
139
140 PROCEDURE Process_Entity
141 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
143 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 );
145
146 -- Procedure lock_Row
147 --
148
149
150 PROCEDURE Lock_Row
151 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
153 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , p_sales_credit_id IN NUMBER
155 , p_lock_control IN NUMBER
156 );
157
158 --SG{
159 Procedure Get_Values(p_header_scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
160 ,x_header_scredit_val_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Val_Rec_Type);
161 --SG}
162
163
164 END OE_OE_Form_Header_Scredit;