[Home] [Help]
PACKAGE: APPS.PO_RELEASES_PKG_S2
Source
1 PACKAGE PO_RELEASES_PKG_S2 AUTHID CURRENT_USER as
2 /* $Header: POXP3PLS.pls 115.5 2003/07/06 18:48:13 dxie ship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: Update_row()
6
7 DESCRIPTION: Table Handler to update the Release Header
8
9 PARAMETERS:
10
11 DESIGN REFERENCES:
12
13
14 ALGORITHM:
15
16 NOTES:
17
18 OPEN ISSUES:
19
20 CLOSED ISSUES:
21
22 CHANGE HISTORY: KPOWELL 4/20 Created
23 SIYER 6/6 Changed
24
25 ===========================================================================*/
26
27 PROCEDURE Update_Row(X_Rowid VARCHAR2,
28 X_Po_Release_Id NUMBER,
29 X_Last_Update_Date DATE,
30 X_Last_Updated_By NUMBER,
31 X_Po_Header_Id NUMBER,
32 X_Release_Num NUMBER,
33 X_Agent_Id NUMBER,
34 X_Release_Date DATE,
35 X_Last_Update_Login NUMBER,
36 X_Revision_Num NUMBER,
37 -- Bug 902976, zxzhang, 10/04/99
38 -- Change REVISED_DATE from VarChar(25) to Date.
39 -- X_Revised_Date VARCHAR2,
40 X_Revised_Date DATE,
41 X_Approved_Flag VARCHAR2,
42 X_Approved_Date DATE,
43 X_Print_Count NUMBER,
44 X_Printed_Date DATE,
45 X_Acceptance_Required_Flag VARCHAR2,
46 X_Acceptance_Due_Date DATE,
47 X_Hold_By NUMBER,
48 X_Hold_Date DATE,
49 X_Hold_Reason VARCHAR2,
50 X_Hold_Flag VARCHAR2,
51 X_Cancel_Flag VARCHAR2,
52 X_Cancelled_By NUMBER,
53 X_Cancel_Date DATE,
54 X_Cancel_Reason VARCHAR2,
55 X_Firm_Status_Lookup_Code VARCHAR2,
56 X_Pay_On_Code VARCHAR2,
57 X_Attribute_Category VARCHAR2,
58 X_Attribute1 VARCHAR2,
59 X_Attribute2 VARCHAR2,
60 X_Attribute3 VARCHAR2,
61 X_Attribute4 VARCHAR2,
62 X_Attribute5 VARCHAR2,
63 X_Attribute6 VARCHAR2,
64 X_Attribute7 VARCHAR2,
65 X_Attribute8 VARCHAR2,
66 X_Attribute9 VARCHAR2,
67 X_Attribute10 VARCHAR2,
68 X_Attribute11 VARCHAR2,
69 X_Attribute12 VARCHAR2,
70 X_Attribute13 VARCHAR2,
71 X_Attribute14 VARCHAR2,
72 X_Attribute15 VARCHAR2,
73 X_Authorization_Status VARCHAR2,
74 X_Ussgl_Transaction_Code VARCHAR2,
75 X_Government_Context VARCHAR2,
76 X_Closed_Code VARCHAR2,
77 X_Frozen_Flag VARCHAR2,
78 X_Release_Type VARCHAR2,
79 X_need_to_Approve IN OUT NOCOPY NUMBER,
80 X_Global_Attribute_Category VARCHAR2,
81 X_Global_Attribute1 VARCHAR2,
82 X_Global_Attribute2 VARCHAR2,
83 X_Global_Attribute3 VARCHAR2,
84 X_Global_Attribute4 VARCHAR2,
85 X_Global_Attribute5 VARCHAR2,
86 X_Global_Attribute6 VARCHAR2,
87 X_Global_Attribute7 VARCHAR2,
88 X_Global_Attribute8 VARCHAR2,
89 X_Global_Attribute9 VARCHAR2,
90 X_Global_Attribute10 VARCHAR2,
91 X_Global_Attribute11 VARCHAR2,
92 X_Global_Attribute12 VARCHAR2,
93 X_Global_Attribute13 VARCHAR2,
94 X_Global_Attribute14 VARCHAR2,
95 X_Global_Attribute15 VARCHAR2,
96 X_Global_Attribute16 VARCHAR2,
97 X_Global_Attribute17 VARCHAR2,
98 X_Global_Attribute18 VARCHAR2,
99 X_Global_Attribute19 VARCHAR2,
100 X_Global_Attribute20 VARCHAR2,
101 p_shipping_control IN VARCHAR2 DEFAULT NULL -- <INBOUND LOGISTICS FPJ>
102 );
103
104 /*===========================================================================
105 PROCEDURE NAME: Delete_row()
106
107 DESCRIPTION: Table Handler to Delete the Release Header.
108
109 PARAMETERS:
110
111 DESIGN REFERENCES:
112
113
114 ALGORITHM:
115
116 NOTES:
117
118 OPEN ISSUES:
119
120 CLOSED ISSUES:
121
122 CHANGE HISTORY: KPOWELL 4/20 Created
123 SIYER 6/6 Changed
124
125 ===========================================================================*/
126
127 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
128
129 END PO_RELEASES_PKG_S2;