APPS.PV_GE_CHKLST_RESP_PKG dependencies on PV_GE_CHKLST_RESPONSES

Line 67: INSERT INTO pv_ge_chklst_responses(

63:
64: px_object_version_number := nvl(px_object_version_number, 1);
65:
66:
67: INSERT INTO pv_ge_chklst_responses(
68: chklst_response_id,
69: checklist_item_id,
70: object_version_number,
71: arc_response_for_entity_code,

Line 122: Update pv_ge_chklst_responses

118: p_last_update_login NUMBER)
119:
120: IS
121: BEGIN
122: Update pv_ge_chklst_responses
123: SET
124: chklst_response_id = DECODE( p_chklst_response_id, null, chklst_response_id, FND_API.G_MISS_NUM, null, p_chklst_response_id),
125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
126: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 164: DELETE FROM pv_ge_chklst_responses

160: p_chklst_response_id NUMBER,
161: p_object_version_number NUMBER)
162: IS
163: BEGIN
164: DELETE FROM pv_ge_chklst_responses
165: WHERE chklst_response_id = p_chklst_response_id
166: AND object_version_number = p_object_version_number;
167: If (SQL%NOTFOUND) then
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 194: FROM pv_ge_chklst_responses

190: p_object_version_number NUMBER)
191: IS
192: CURSOR C IS
193: SELECT *
194: FROM pv_ge_chklst_responses
195: WHERE chklst_response_id = p_chklst_response_id
196: AND object_version_number = p_object_version_number
197: FOR UPDATE OF chklst_response_id NOWAIT;
198: Recinfo C%ROWTYPE;