APPS.OE_PARAMETERS_PKG dependencies on OE_SYS_PARAMETERS_ALL

Line 7: -- Description : Inserts record in Oe_Sys_Parameters_All table.

3: --Pack J
4: -- Start of comments
5: -- API name : Insert_Row
6: -- Type : Public
7: -- Description : Inserts record in Oe_Sys_Parameters_All table.
8: -- Parameters :
9: -- IN : p_sys_param_all_rec IN
10: -- oe_parameters_pkg.sys_param_all_rec_type Required
11: --

Line 20: SELECT rowid FROM oe_sys_parameters_all

16: oe_parameters_pkg.sys_param_all_rec_type,
17: x_row_id OUT NOCOPY VARCHAR2)
18: IS
19: CURSOR get_rowid IS
20: SELECT rowid FROM oe_sys_parameters_all
21: WHERE nvl(org_id, -99) = nvl(p_sys_param_all_rec.org_Id, -99)
22: AND parameter_code = p_sys_param_all_rec.parameter_code;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 27: INSERT INTO oe_sys_parameters_all(

23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN
27: INSERT INTO oe_sys_parameters_all(
28: org_id,
29: creation_date,
30: created_by,
31: last_update_date,

Line 92: -- Description : Locks the record in Oe_Sys_Parameters_All table for the rowid.

88:
89: -- Start of comments
90: -- API name : Lock_Row
91: -- Type : Public
92: -- Description : Locks the record in Oe_Sys_Parameters_All table for the rowid.
93: -- Parameters :
94: -- IN : p_row_id IN VARCHAR2 Required
95: --
96: -- OUT :

Line 112: FROM oe_sys_parameters_all

108: attribute8,attribute9,
109: attribute10,attribute11,
110: attribute12,attribute13,
111: attribute14,attribute15
112: FROM oe_sys_parameters_all
113: WHERE rowid = p_row_id
114: FOR UPDATE OF parameter_value NOWAIT;
115:
116: l_recinfo lock_param_all%ROWTYPE;

Line 140: -- Description : update the record in Oe_Sys_Parameters_All table for the rowid if not found

136:
137: -- Start of comments
138: -- API name : Update_Row
139: -- Type : Public
140: -- Description : update the record in Oe_Sys_Parameters_All table for the rowid if not found
141: -- insert the record.
142: -- Parameters :
143: -- IN : p_sys_param_all_rec IN
144: -- oe_parameters_pkg.sys_param_all_rec_type Required

Line 161: UPDATE oe_sys_parameters_all

157: --
158: BEGIN
159: IF x_row_id IS NOT NULL THEN
160:
161: UPDATE oe_sys_parameters_all
162: SET
163: org_id = p_sys_param_all_rec.org_id,
164: last_update_date = p_sys_param_all_rec.Last_Update_Date,
165: last_updated_by = p_sys_param_all_rec.Last_Updated_By,

Line 528: DELETE FROM oe_sys_parameters_all

524: END Update_Row;
525: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
526: BEGIN
527: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
528: DELETE FROM oe_sys_parameters_all
529: WHERE rowid = X_Rowid;
530: /*
531: ELSE
532: