APPS.XLE_HISTORIES_PKG dependencies on XLE_HISTORIES

Line 1: PACKAGE BODY XLE_Histories_PKG AS

1: PACKAGE BODY XLE_Histories_PKG AS
2: /* $Header: xlehistb.pls 120.1 2005/07/26 17:10:23 shijain ship $ */
3:
4: PROCEDURE Insert_Row(
5: x_history_id IN OUT NOCOPY NUMBER,

Line 21: INSERT INTO xle_histories (

17: p_last_update_login IN NUMBER DEFAULT NULL,
18: p_object_version_number IN NUMBER
19: ) IS
20: BEGIN
21: INSERT INTO xle_histories (
22: history_id,
23: source_table,
24: source_id,
25: source_column_name,

Line 37: xle_histories_s.NEXTVAL,

33: created_by,
34: last_update_login,
35: object_version_number
36: ) VALUES (
37: xle_histories_s.NEXTVAL,
38: DECODE(p_source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
39: DECODE(p_source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
40: DECODE(p_source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
41: DECODE(p_source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),

Line 72: UPDATE xle_histories SET

68: p_last_update_login IN NUMBER DEFAULT NULL,
69: p_object_version_number IN NUMBER
70: ) IS
71: BEGIN
72: UPDATE xle_histories SET
73: source_table = DECODE(p_source_table, NULL, source_table, FND_API.G_MISS_CHAR, NULL, p_source_table),
74: source_id = DECODE(p_source_id, NULL, source_id, FND_API.G_MISS_NUM, NULL, p_source_id),
75: source_column_name = DECODE(p_source_column_name, NULL, source_column_name, FND_API.G_MISS_CHAR, NULL, p_source_column_name),
76: source_column_value = DECODE(p_source_column_value, NULL, source_column_value, FND_API.G_MISS_CHAR, NULL, p_source_column_value),

Line 93: DELETE FROM xle_histories

89: END Update_Row;
90:
91: PROCEDURE Delete_Row(p_history_id IN NUMBER) IS
92: BEGIN
93: DELETE FROM xle_histories
94: WHERE history_id = p_history_id;
95:
96: IF (sql%notfound) THEN
97: RAISE no_data_found;

Line 118: SELECT * FROM xle_histories

114: p_last_update_login IN NUMBER DEFAULT NULL,
115: p_object_version_number IN NUMBER
116: ) IS
117: CURSOR C IS
118: SELECT * FROM xle_histories
119: WHERE history_id = p_history_id
120: FOR UPDATE OF history_id NOWAIT;
121: Recinfo C%ROWTYPE;
122: BEGIN

Line 181: END XLE_Histories_PKG;

177: APP_EXCEPTION.Raise_Exception;
178: END IF;
179: END Lock_Row;
180:
181: END XLE_Histories_PKG;
182: