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