[Home] [Help]
PACKAGE: APPS.PO_RELEASES_PKG_S1
Source
1 PACKAGE PO_RELEASES_PKG_S1 AUTHID CURRENT_USER as
2 /* $Header: POXP2PLS.pls 115.4 2003/07/06 19:03:39 dxie ship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: Lock_row()
6
7 DESCRIPTION: Table Handler to Lock 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 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
27 X_Po_Release_Id NUMBER,
28 X_Po_Header_Id NUMBER,
29 X_Release_Num NUMBER,
30 X_Agent_Id NUMBER,
31 X_Release_Date DATE,
32 X_Revision_Num NUMBER,
33 -- Bug 902976, zxzhang, 10/04/99
34 -- Change REVISED_DATE from VarChar(25) to Date.
35 -- X_Revised_Date VARCHAR2,
36 X_Revised_Date DATE,
37 X_Approved_Flag VARCHAR2,
38 X_Approved_Date DATE,
39 X_Print_Count NUMBER,
40 X_Printed_Date DATE,
41 X_Acceptance_Required_Flag VARCHAR2,
42 X_Acceptance_Due_Date DATE,
43 X_Hold_By NUMBER,
44 X_Hold_Date DATE,
45 X_Hold_Reason VARCHAR2,
46 X_Hold_Flag VARCHAR2,
47 X_Cancel_Flag VARCHAR2,
48 X_Cancelled_By NUMBER,
49 X_Cancel_Date DATE,
50 X_Cancel_Reason VARCHAR2,
51 X_Firm_Status_Lookup_Code VARCHAR2,
52 X_Pay_On_Code VARCHAR2,
53 --X_Firm_Date DATE,
54 X_Attribute_Category VARCHAR2,
55 X_Attribute1 VARCHAR2,
56 X_Attribute2 VARCHAR2,
57 X_Attribute3 VARCHAR2,
58 X_Attribute4 VARCHAR2,
59 X_Attribute5 VARCHAR2,
60 X_Attribute6 VARCHAR2,
61 X_Attribute7 VARCHAR2,
62 X_Attribute8 VARCHAR2,
63 X_Attribute9 VARCHAR2,
64 X_Attribute10 VARCHAR2,
65 X_Attribute11 VARCHAR2,
66 X_Attribute12 VARCHAR2,
67 X_Attribute13 VARCHAR2,
68 X_Attribute14 VARCHAR2,
69 X_Attribute15 VARCHAR2,
70 X_Authorization_Status VARCHAR2,
71 X_Ussgl_Transaction_Code VARCHAR2,
72 X_Government_Context VARCHAR2,
73 X_Closed_Code VARCHAR2,
74 X_Frozen_Flag VARCHAR2,
75 X_Release_Type VARCHAR2,
76 --X_Note_To_Vendor VARCHAR2
77 X_Global_Attribute_Category VARCHAR2,
78 X_Global_Attribute1 VARCHAR2,
79 X_Global_Attribute2 VARCHAR2,
80 X_Global_Attribute3 VARCHAR2,
81 X_Global_Attribute4 VARCHAR2,
82 X_Global_Attribute5 VARCHAR2,
83 X_Global_Attribute6 VARCHAR2,
84 X_Global_Attribute7 VARCHAR2,
85 X_Global_Attribute8 VARCHAR2,
86 X_Global_Attribute9 VARCHAR2,
87 X_Global_Attribute10 VARCHAR2,
88 X_Global_Attribute11 VARCHAR2,
89 X_Global_Attribute12 VARCHAR2,
90 X_Global_Attribute13 VARCHAR2,
91 X_Global_Attribute14 VARCHAR2,
92 X_Global_Attribute15 VARCHAR2,
93 X_Global_Attribute16 VARCHAR2,
94 X_Global_Attribute17 VARCHAR2,
95 X_Global_Attribute18 VARCHAR2,
96 X_Global_Attribute19 VARCHAR2,
97 X_Global_Attribute20 VARCHAR2,
98 p_shipping_control IN VARCHAR2 DEFAULT NULL -- <INBOUND LOGISTICS FPJ>
99 );
100
101
102 END PO_RELEASES_PKG_S1;