APPS.PV_GQ_ELEMENTS_PKG dependencies on PV_GE_QSNR_ELEMENTS_B

Line 70: INSERT INTO pv_ge_qsnr_elements_b(

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

Line 164: Update pv_ge_qsnr_elements_b

160: )
161:
162: IS
163: BEGIN
164: Update pv_ge_qsnr_elements_b
165: SET
166: qsnr_element_id = DECODE( p_qsnr_element_id, null, qsnr_element_id, FND_API.G_MISS_NUM, null, p_qsnr_element_id),
167: --object_version_number = object_version_number + 1 ,
168: object_version_number = DECODE( px_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, px_object_version_number+1),

Line 219: DELETE FROM pv_ge_qsnr_elements_b

215: p_qsnr_element_id NUMBER,
216: p_object_version_number NUMBER)
217: IS
218: BEGIN
219: DELETE FROM pv_ge_qsnr_elements_b
220: WHERE qsnr_element_id = p_qsnr_element_id
221: AND object_version_number = p_object_version_number;
222: If (SQL%NOTFOUND) then
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 249: FROM pv_ge_qsnr_elements_b

245: p_object_version_number NUMBER)
246: IS
247: CURSOR C IS
248: SELECT *
249: FROM pv_ge_qsnr_elements_b
250: WHERE qsnr_element_id = p_qsnr_element_id
251: AND object_version_number = p_object_version_number
252: FOR UPDATE OF qsnr_element_id NOWAIT;
253: Recinfo C%ROWTYPE;

Line 353: cursor C is select ROWID from PV_GE_QSNR_ELEMENTS_B

349: X_LAST_UPDATE_DATE in DATE,
350: X_LAST_UPDATED_BY in NUMBER,
351: X_LAST_UPDATE_LOGIN in NUMBER
352: ) is
353: cursor C is select ROWID from PV_GE_QSNR_ELEMENTS_B
354: where QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID
355: ;
356: begin
357: insert into PV_GE_QSNR_ELEMENTS_B (

Line 357: insert into PV_GE_QSNR_ELEMENTS_B (

353: cursor C is select ROWID from PV_GE_QSNR_ELEMENTS_B
354: where QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID
355: ;
356: begin
357: insert into PV_GE_QSNR_ELEMENTS_B (
358: QSNR_ELEMENT_ID,
359: OBJECT_VERSION_NUMBER,
360: ARC_USED_BY_ENTITY_CODE,
361: USED_BY_ENTITY_ID,

Line 448: from PV_GE_QSNR_ELEMENTS_B

444: QSNR_ELMT_TYPE,
445: ENTITY_ATTR_ID,
446: QSNR_ELMT_PAGE_NUM,
447: IS_REQUIRED_FLAG
448: from PV_GE_QSNR_ELEMENTS_B
449: where QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID
450: for update of QSNR_ELEMENT_ID nowait;
451: recinfo c%rowtype;
452:

Line 516: update PV_GE_QSNR_ELEMENTS_B set

512: X_LAST_UPDATED_BY in NUMBER,
513: X_LAST_UPDATE_LOGIN in NUMBER
514: ) is
515: begin
516: update PV_GE_QSNR_ELEMENTS_B set
517: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
518: ARC_USED_BY_ENTITY_CODE = X_ARC_USED_BY_ENTITY_CODE,
519: USED_BY_ENTITY_ID = X_USED_BY_ENTITY_ID,
520: QSNR_ELMT_SEQ_NUM = X_QSNR_ELMT_SEQ_NUM,

Line 559: delete from PV_GE_QSNR_ELEMENTS_B

555: if (sql%notfound) then
556: raise no_data_found;
557: end if;
558:
559: delete from PV_GE_QSNR_ELEMENTS_B
560: where QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID;
561:
562: if (sql%notfound) then
563: raise no_data_found;