DBA Data[Home] [Help]

APPS.XLE_HISTORIES_PKG dependencies on XLE_HISTORIES_S

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),