APPS.PV_GE_NOTIF_RULES_PKG dependencies on PV_GE_NOTIF_RULES_B

Line 80: INSERT INTO pv_ge_notif_rules_b(

76:
77: px_object_version_number := nvl(px_object_version_number, 1);
78:
79:
80: INSERT INTO pv_ge_notif_rules_b(
81: notif_rule_id,
82: object_version_number,
83: arc_notif_for_entity_code,
84: notif_for_entity_id,

Line 196: Update pv_ge_notif_rules_b

192: )
193:
194: IS
195: BEGIN
196: Update pv_ge_notif_rules_b
197: SET
198: notif_rule_id = DECODE( p_notif_rule_id, null, notif_rule_id, FND_API.G_MISS_NUM, null, p_notif_rule_id),
199: object_version_number = nvl(p_object_version_number,0) + 1 ,
200: arc_notif_for_entity_code = DECODE( p_arc_notif_for_entity_code, null, arc_notif_for_entity_code, FND_API.g_miss_char, null, p_arc_notif_for_entity_code),

Line 257: DELETE FROM pv_ge_notif_rules_b

253: p_notif_rule_id NUMBER,
254: p_object_version_number NUMBER)
255: IS
256: BEGIN
257: DELETE FROM pv_ge_notif_rules_b
258: WHERE notif_rule_id = p_notif_rule_id
259: AND object_version_number = p_object_version_number;
260: If (SQL%NOTFOUND) then
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 287: FROM pv_ge_notif_rules_b

283: p_object_version_number NUMBER)
284: IS
285: CURSOR C IS
286: SELECT *
287: FROM pv_ge_notif_rules_b
288: WHERE notif_rule_id = p_notif_rule_id
289: AND object_version_number = p_object_version_number
290: FOR UPDATE OF notif_rule_id NOWAIT;
291: Recinfo C%ROWTYPE;

Line 326: from pv_ge_notif_rules_b b

322: BEGIN
323: delete from pv_ge_notif_rules_tl T
324: where not exists
325: (select NULL
326: from pv_ge_notif_rules_b b
327: where b.notif_rule_id = t.notif_rule_id
328: );
329:
330: update pv_ge_notif_rules_tl t set (