APPS.PV_GE_HL_PARAM_PKG dependencies on PV_GE_HISTORY_LOG_PARAMS

Line 66: INSERT INTO pv_ge_history_log_params(

62: --dbms_output.put_line('value of px_hist_log_id '||to_char(px_history_log_param_id));
63: px_object_version_number := nvl(px_object_version_number, 1);
64:
65:
66: INSERT INTO pv_ge_history_log_params(
67: history_log_param_id,
68: entity_history_log_id,
69: param_name,
70: object_version_number,

Line 124: Update pv_ge_history_log_params

120: p_lookup_type VARCHAR2)
121:
122: IS
123: BEGIN
124: Update pv_ge_history_log_params
125: SET
126: history_log_param_id = DECODE( p_history_log_param_id, null, history_log_param_id, FND_API.G_MISS_NUM, null, p_history_log_param_id),
127: 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),
128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),

Line 167: DELETE FROM pv_ge_history_log_params

163: p_history_log_param_id NUMBER,
164: p_object_version_number NUMBER)
165: IS
166: BEGIN
167: DELETE FROM pv_ge_history_log_params
168: WHERE history_log_param_id = p_history_log_param_id
169: AND object_version_number = p_object_version_number;
170: If (SQL%NOTFOUND) then
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 197: FROM pv_ge_history_log_params

193: p_object_version_number NUMBER)
194: IS
195: CURSOR C IS
196: SELECT *
197: FROM pv_ge_history_log_params
198: WHERE history_log_param_id = p_history_log_param_id
199: AND object_version_number = p_object_version_number
200: FOR UPDATE OF history_log_param_id NOWAIT;
201: Recinfo C%ROWTYPE;