APPS.PV_PG_INVITE_HEADERS_PKG dependencies on PV_PG_INVITE_HEADERS_B

Line 67: INSERT INTO pv_pg_invite_headers_b(

63:
64: px_object_version_number := nvl(px_object_version_number, 1);
65:
66:
67: INSERT INTO pv_pg_invite_headers_b(
68: invite_header_id,
69: object_version_number,
70: qp_list_header_id,
71: invite_type_code,

Line 163: Update pv_pg_invite_headers_b

159: )
160:
161: IS
162: BEGIN
163: Update pv_pg_invite_headers_b
164: SET
165: invite_header_id = DECODE( p_invite_header_id, null, invite_header_id, FND_API.G_MISS_NUM, null, p_invite_header_id),
166: object_version_number = nvl(p_object_version_number,0) + 1 ,
167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),

Line 217: DELETE FROM pv_pg_invite_headers_b

213: p_invite_header_id NUMBER,
214: p_object_version_number NUMBER)
215: IS
216: BEGIN
217: DELETE FROM pv_pg_invite_headers_b
218: WHERE invite_header_id = p_invite_header_id
219: AND object_version_number = p_object_version_number;
220: If (SQL%NOTFOUND) then
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 247: FROM pv_pg_invite_headers_b

243: p_object_version_number NUMBER)
244: IS
245: CURSOR C IS
246: SELECT *
247: FROM pv_pg_invite_headers_b
248: WHERE invite_header_id = p_invite_header_id
249: AND object_version_number = p_object_version_number
250: FOR UPDATE OF invite_header_id NOWAIT;
251: Recinfo C%ROWTYPE;