DBA Data[Home] [Help]

APPS.OE_PARAMETERS_PKG dependencies on OE_PARAMETERS_PKG

Line 1: PACKAGE BODY OE_PARAMETERS_PKG as

1: PACKAGE BODY OE_PARAMETERS_PKG as
2: /* $Header: OEXPARAB.pls 115.21 2004/05/05 12:22:17 rmoharan ship $ */
3: --Pack J
4: -- Start of comments
5: -- API name : Insert_Row

Line 10: -- oe_parameters_pkg.sys_param_all_rec_type Required

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: --
12: -- OUT : x_row_id OUT VARCHAR2
13: --
14: -- End of Comments

Line 16: oe_parameters_pkg.sys_param_all_rec_type,

12: -- OUT : x_row_id OUT VARCHAR2
13: --
14: -- End of Comments
15: PROCEDURE Insert_Row(p_sys_param_all_rec IN
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

Line 144: -- oe_parameters_pkg.sys_param_all_rec_type Required

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
145: --
146: -- IN OUT : x_row_id IN VARCHAR2
147: --
148: -- End of Comments

Line 152: oe_parameters_pkg.sys_param_all_rec_type)

148: -- End of Comments
149:
150: PROCEDURE Update_Row(x_row_id IN OUT NOCOPY VARCHAR2,
151: p_sys_param_all_rec IN
152: oe_parameters_pkg.sys_param_all_rec_type)
153:
154: IS
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 543: END OE_PARAMETERS_PKG;

539: end if;
540: END Delete_Row;
541:
542:
543: END OE_PARAMETERS_PKG;