APPS.PV_GE_HIST_LOG_PKG dependencies on PV_GE_HISTORY_LOG_B

Line 66: INSERT INTO pv_ge_history_log_b(

62:
63: px_object_version_number := nvl(px_object_version_number, 1);
64:
65:
66: INSERT INTO pv_ge_history_log_b(
67: entity_history_log_id,
68: object_version_number,
69: arc_history_for_entity_code,
70: history_for_entity_id,

Line 158: Update pv_ge_history_log_b

154: )
155:
156: IS
157: BEGIN
158: Update pv_ge_history_log_b
159: SET
160: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
161: object_version_number = nvl(p_object_version_number,0) + 1 ,
162: arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),

Line 211: DELETE FROM pv_ge_history_log_b

207: p_entity_history_log_id NUMBER,
208: p_object_version_number NUMBER)
209: IS
210: BEGIN
211: DELETE FROM pv_ge_history_log_b
212: WHERE entity_history_log_id = p_entity_history_log_id
213: AND object_version_number = p_object_version_number;
214: If (SQL%NOTFOUND) then
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 241: FROM pv_ge_history_log_b

237: p_object_version_number NUMBER)
238: IS
239: CURSOR C IS
240: SELECT *
241: FROM pv_ge_history_log_b
242: WHERE entity_history_log_id = p_entity_history_log_id
243: AND object_version_number = p_object_version_number
244: FOR UPDATE OF entity_history_log_id NOWAIT;
245: Recinfo C%ROWTYPE;