[Home] [Help]
PACKAGE: APPS.PO_REQUISITION_HEADERS_PKG
Source
1 PACKAGE PO_REQUISITION_HEADERS_PKG as
2 /* $Header: POXRIH1S.pls 120.0 2005/06/01 20:30:07 appldev noship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Requisition_Header_Id IN OUT NOCOPY NUMBER,
7 X_Preparer_Id NUMBER,
8 X_Last_Update_Date DATE,
9 X_Last_Updated_By NUMBER,
10 X_Segment1 IN OUT NOCOPY VARCHAR2,
11 X_Summary_Flag VARCHAR2,
12 X_Enabled_Flag VARCHAR2,
13 X_Segment2 VARCHAR2,
14 X_Segment3 VARCHAR2,
15 X_Segment4 VARCHAR2,
16 X_Segment5 VARCHAR2,
17 X_Start_Date_Active DATE,
18 X_End_Date_Active DATE,
19 X_Last_Update_Login NUMBER,
20 X_Creation_Date DATE,
21 X_Created_By NUMBER,
22 X_Description VARCHAR2,
23 X_Authorization_Status VARCHAR2,
24 X_Note_To_Authorizer VARCHAR2,
25 X_Type_Lookup_Code VARCHAR2,
26 X_Transferred_To_Oe_Flag VARCHAR2,
27 X_Attribute_Category VARCHAR2,
28 X_Attribute1 VARCHAR2,
29 X_Attribute2 VARCHAR2,
30 X_Attribute3 VARCHAR2,
31 X_Attribute4 VARCHAR2,
32 X_Attribute5 VARCHAR2,
33 X_On_Line_Flag VARCHAR2,
34 X_Preliminary_Research_Flag VARCHAR2,
35 X_Research_Complete_Flag VARCHAR2,
36 X_Preparer_Finished_Flag VARCHAR2,
37 X_Preparer_Finished_Date DATE,
38 X_Agent_Return_Flag VARCHAR2,
39 X_Agent_Return_Note VARCHAR2,
40 X_Cancel_Flag VARCHAR2,
41 X_Attribute6 VARCHAR2,
42 X_Attribute7 VARCHAR2,
43 X_Attribute8 VARCHAR2,
44 X_Attribute9 VARCHAR2,
45 X_Attribute10 VARCHAR2,
46 X_Attribute11 VARCHAR2,
47 X_Attribute12 VARCHAR2,
48 X_Attribute13 VARCHAR2,
49 X_Attribute14 VARCHAR2,
50 X_Attribute15 VARCHAR2,
51 X_Ussgl_Transaction_Code VARCHAR2,
52 X_Government_Context VARCHAR2,
53 X_Interface_Source_Code VARCHAR2,
54 X_Interface_Source_Line_Id NUMBER,
55 X_Closed_Code VARCHAR2,
56 X_Manual BOOLEAN,
57 p_org_id IN NUMBER DEFAULT NULL -- <R12 MOAC>
58 );
59
60 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
61
62 /* Ben bug#465696 created this procedure to resolve the performance problem.
63 See POXRIHDB.pls for detailed explanation.
64 */
65
66 PROCEDURE get_real_segment1(x_requisition_header_id NUMBER,
67 x_type_lookup_code VARCHAR2,
68 x_currency_code VARCHAR2,
69 x_segment1 IN OUT NOCOPY VARCHAR2);
70
71 PROCEDURE Check_Unique(X_rowid VARCHAR2,
72 X_segment1 VARCHAR2);
73
74
75 FUNCTION get_req_total(P_header_id NUMBER)
76 return number;
77 -- pragma restrict_references (get_req_total,WNDS);
78
79 /* Start Bug#3406460 overloaded the function to calculate header total*/
80 /* by rounding the line totals to the precision */
81
82 FUNCTION get_req_total(P_header_id NUMBER,
83 P_currency_code VARCHAR2)
84 return number;
85
86 /*End Bug #3406460*/
87 END PO_REQUISITION_HEADERS_PKG;