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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
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),
42: DECODE(p_effective_from, NULL, XLE_UTILITY_PUB.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_effective_from),
43: DECODE(p_effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
44: DECODE(p_comment, FND_API.G_MISS_CHAR, NULL, p_comment),
45: XLE_UTILITY_PUB.LAST_UPDATE_DATE,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
46: XLE_UTILITY_PUB.LAST_UPDATED_BY,
47: XLE_UTILITY_PUB.CREATION_DATE,
48: XLE_UTILITY_PUB.CREATED_BY,
49: XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
50: DECODE(p_object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
51: ) RETURNING
52: history_id
53: INTO
54: x_history_id;
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
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),
77: effective_from = DECODE(p_effective_from, NULL, effective_from, FND_API.G_MISS_DATE, NULL, p_effective_from),
78: effective_to = DECODE(p_effective_to, NULL, effective_to, FND_API.G_MISS_DATE, NULL, p_effective_to),
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
83: object_version_number= DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
79: comments = DECODE(p_comment, NULL, comments, FND_API.G_MISS_CHAR, NULL, p_comment),
80: last_update_date = XLE_UTILITY_PUB.LAST_UPDATE_DATE,
81: last_updated_by = XLE_UTILITY_PUB.LAST_UPDATED_BY,
82: last_update_login = XLE_UTILITY_PUB.LAST_UPDATE_LOGIN,
83: object_version_number= DECODE(p_object_version_number, NULL, object_version_number, FND_API.G_MISS_NUM, NULL, p_object_version_number)
84: WHERE history_id = p_history_id;
85:
86: IF (sql%notfound) THEN
87: RAISE no_data_found;