[Home] [Help]
PACKAGE: APPS.OE_PARAMETERS_PKG
Source
1 PACKAGE OE_PARAMETERS_PKG as
2 /* $Header: OEXPARAS.pls 120.1 2005/06/08 03:40:32 appldev $ */
3
4 -- Pack J
5 -- Record Type for oe_sys_parameters_all attributes
6 TYPE sys_param_all_rec_type IS RECORD
7 (Org_id NUMBER
8 ,Parameter_Code VARCHAR2(80) --<R12.MOAC>
9 ,Parameter_Value VARCHAR2(240)
10 ,Creation_Date DATE
11 ,Created_By NUMBER(15)
12 ,Last_Update_Date DATE
13 ,Last_Updated_By NUMBER(15)
14 ,Last_Update_Login NUMBER(15)
15 ,Context VARCHAR2(30)
16 ,Attribute1 VARCHAR2(240)
17 ,Attribute2 VARCHAR2(240)
18 ,Attribute3 VARCHAR2(240)
19 ,Attribute4 VARCHAR2(240)
20 ,Attribute5 VARCHAR2(240)
21 ,Attribute6 VARCHAR2(240)
22 ,Attribute7 VARCHAR2(240)
23 ,Attribute8 VARCHAR2(240)
24 ,Attribute9 VARCHAR2(240)
25 ,Attribute10 VARCHAR2(240)
26 ,Attribute11 VARCHAR2(240)
27 ,Attribute12 VARCHAR2(240)
28 ,Attribute13 VARCHAR2(240)
29 ,Attribute14 VARCHAR2(240)
30 ,Attribute15 VARCHAR2(240));
31
32 --- Procedures for oe_sys_parameters_all table
33 Procedure Insert_Row(p_sys_param_all_rec IN
34 oe_parameters_pkg.sys_param_all_rec_type,
35 x_row_id OUT NOCOPY VARCHAR2);
36 Procedure Lock_Row(p_row_id IN VARCHAR2);
37 Procedure Update_Row(x_row_id IN OUT NOCOPY VARCHAR2,
38 p_sys_param_all_rec IN
39 oe_parameters_pkg.sys_param_all_rec_type);
40 --- End
41
42 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
43 X_Organization_Id NUMBER,
44 X_Last_Update_Date DATE,
45 X_Last_Updated_By NUMBER ,
46 X_Creation_Date DATE ,
47 X_Created_By NUMBER ,
48 X_Last_Update_Login NUMBER,
49 X_Master_Organization_Id NUMBER,
50 X_customer_relationships_flag varchar2,
51 X_Audit_trail_Enable_Flag varchar2,
52 --MRG BGN
53 X_Compute_Margin_Flag VARCHAR2,
54 --MRG END
55 --freight rating begin
56 X_Freight_Rating_Enabled_Flag VARCHAR2,
57 X_Fte_Ship_Method_Enabled_Flag VARCHAR2,
58 --freight rating end
59 X_Context VARCHAR2,
60 X_Attribute1 VARCHAR2,
61 X_Attribute2 VARCHAR2,
62 X_Attribute3 VARCHAR2,
63 X_Attribute4 VARCHAR2,
64 X_Attribute5 VARCHAR2,
65 X_Attribute6 VARCHAR2,
66 X_Attribute7 VARCHAR2,
67 X_Attribute8 VARCHAR2,
68 X_Attribute9 VARCHAR2,
69 X_Attribute10 VARCHAR2,
70 X_Attribute11 VARCHAR2,
71 X_Attribute12 VARCHAR2,
72 X_Attribute13 VARCHAR2,
73 X_Attribute14 VARCHAR2,
74 X_Attribute15 VARCHAR2
75 );
76
77 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
78 X_Organization_Id NUMBER,
79 X_Master_Organization_Id NUMBER,
80 x_customer_relationships_flag varchar2,
81 X_Audit_trail_Enable_Flag VARCHAR2,
82 --MRG BGN
83 X_Compute_Margin_Flag VARCHAR2,
84 --MRG END
85 --freight rating begin
86 X_Freight_Rating_Enabled_Flag VARCHAR2,
87 X_Fte_Ship_Method_Enabled_Flag VARCHAR2,
88 --freight rating end
89 X_Context VARCHAR2,
90 X_Attribute1 VARCHAR2,
91 X_Attribute2 VARCHAR2,
92 X_Attribute3 VARCHAR2,
93 X_Attribute4 VARCHAR2,
94 X_Attribute5 VARCHAR2,
95 X_Attribute6 VARCHAR2,
96 X_Attribute7 VARCHAR2,
97 X_Attribute8 VARCHAR2,
98 X_Attribute9 VARCHAR2,
99 X_Attribute10 VARCHAR2,
100 X_Attribute11 VARCHAR2,
101 X_Attribute12 VARCHAR2,
102 X_Attribute13 VARCHAR2,
103 X_Attribute14 VARCHAR2,
104 X_Attribute15 VARCHAR2
105 );
106
107 PROCEDURE Update_Row(X_Rowid VARCHAR2,
108 X_Organization_Id NUMBER,
109 X_Last_Update_Date DATE,
110 X_Last_Updated_By NUMBER,
111 X_Last_Update_Login NUMBER,
112 X_Master_Organization_Id NUMBER,
113 x_customer_relationships_flag varchar2,
114 X_Audit_trail_Enable_Flag VARCHAR2,
115 --MRG BGN
116 X_Compute_Margin_Flag VARCHAR2,
117 --MRG END
118 --freight rating begin
119 X_Freight_Rating_Enabled_Flag VARCHAR2,
120 X_Fte_Ship_Method_Enabled_Flag VARCHAR2,
121 --freight rating end
122 X_Context VARCHAR2,
123 X_Attribute1 VARCHAR2,
124 X_Attribute2 VARCHAR2,
125 X_Attribute3 VARCHAR2,
126 X_Attribute4 VARCHAR2,
127 X_Attribute5 VARCHAR2,
128 X_Attribute6 VARCHAR2,
129 X_Attribute7 VARCHAR2,
130 X_Attribute8 VARCHAR2,
131 X_Attribute9 VARCHAR2,
132 X_Attribute10 VARCHAR2,
133 X_Attribute11 VARCHAR2,
134 X_Attribute12 VARCHAR2,
135 X_Attribute13 VARCHAR2,
136 X_Attribute14 VARCHAR2,
137 X_Attribute15 VARCHAR2
138 );
139 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
140
141 END OE_PARAMETERS_PKG;