APPS.PV_GE_CHKLST_PKG dependencies on PV_GE_CHKLST_ITEMS_B

Line 70: INSERT INTO pv_ge_chklst_items_b(

66:
67: px_object_version_number := nvl(px_object_version_number, 1);
68:
69:
70: INSERT INTO pv_ge_chklst_items_b(
71: checklist_item_id,
72: object_version_number,
73: arc_used_by_entity_code,
74: used_by_entity_id,

Line 156: Update pv_ge_chklst_items_b

152: )
153:
154: IS
155: BEGIN
156: Update pv_ge_chklst_items_b
157: SET
158: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
159: object_version_number = nvl(p_object_version_number,0) + 1 ,
160: arc_used_by_entity_code = DECODE( p_arc_used_by_entity_code, null, arc_used_by_entity_code, FND_API.g_miss_char, null, p_arc_used_by_entity_code),

Line 207: DELETE FROM pv_ge_chklst_items_b

203: p_checklist_item_id NUMBER,
204: p_object_version_number NUMBER)
205: IS
206: BEGIN
207: DELETE FROM pv_ge_chklst_items_b
208: WHERE checklist_item_id = p_checklist_item_id
209: AND object_version_number = p_object_version_number;
210: If (SQL%NOTFOUND) then
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 237: FROM pv_ge_chklst_items_b

233: p_object_version_number NUMBER)
234: IS
235: CURSOR C IS
236: SELECT *
237: FROM pv_ge_chklst_items_b
238: WHERE checklist_item_id = p_checklist_item_id
239: AND object_version_number = p_object_version_number
240: FOR UPDATE OF checklist_item_id NOWAIT;
241: Recinfo C%ROWTYPE;