APPS.PV_GE_BENEFITS_PKG dependencies on PV_GE_BENEFITS_B

Line 37: cursor C is select ROWID from PV_GE_BENEFITS_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from PV_GE_BENEFITS_B
38: where BENEFIT_ID = X_BENEFIT_ID
39: ;
40: begin
41: insert into PV_GE_BENEFITS_B (

Line 41: insert into PV_GE_BENEFITS_B (

37: cursor C is select ROWID from PV_GE_BENEFITS_B
38: where BENEFIT_ID = X_BENEFIT_ID
39: ;
40: begin
41: insert into PV_GE_BENEFITS_B (
42: BENEFIT_ID,
43: OBJECT_VERSION_NUMBER,
44: BENEFIT_TYPE_CODE,
45: BENEFIT_STATUS_CODE,

Line 195: from PV_GE_BENEFITS_B

191: ATTRIBUTE12,
192: ATTRIBUTE13,
193: ATTRIBUTE14,
194: ATTRIBUTE15
195: from PV_GE_BENEFITS_B
196: where BENEFIT_ID = X_BENEFIT_ID
197: for update of BENEFIT_ID nowait;
198: recinfo c%rowtype;
199:

Line 315: update PV_GE_BENEFITS_B set

311: X_LAST_UPDATED_BY in NUMBER,
312: X_LAST_UPDATE_LOGIN in NUMBER
313: ) is
314: begin
315: update PV_GE_BENEFITS_B set
316: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
317: BENEFIT_TYPE_CODE = X_BENEFIT_TYPE_CODE,
318: BENEFIT_STATUS_CODE = X_BENEFIT_STATUS_CODE,
319: BENEFIT_CODE = X_BENEFIT_CODE,

Line 509: update PV_GE_BENEFITS_B set

505: X_LAST_UPDATE_LOGIN in NUMBER
506: )
507: IS
508: BEGIN
509: update PV_GE_BENEFITS_B set
510: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
511: BENEFIT_TYPE_CODE = X_BENEFIT_TYPE_CODE,
512: BENEFIT_STATUS_CODE = X_BENEFIT_STATUS_CODE,
513: BENEFIT_CODE = X_BENEFIT_CODE,

Line 554: delete from PV_GE_BENEFITS_B

550: if (sql%notfound) then
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: end if;
553:
554: delete from PV_GE_BENEFITS_B
555: where BENEFIT_ID = X_BENEFIT_ID;
556:
557: if (sql%notfound) then
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 568: from PV_GE_BENEFITS_B B

564: begin
565: delete from PV_GE_BENEFITS_TL T
566: where not exists
567: (select NULL
568: from PV_GE_BENEFITS_B B
569: where B.BENEFIT_ID = T.BENEFIT_ID
570: );
571:
572: update PV_GE_BENEFITS_TL T set (

Line 686: from PV_GE_BENEFITS_B

682: L_BENEFIT_ID number;
683:
684: cursor C_OBJ_VERNO is
685: select OBJECT_VERSION_NUMBER
686: from PV_GE_BENEFITS_B
687: where BENEFIT_ID = l_BENEFIT_ID;
688:
689: cursor c_chk_benefit_exists is
690: select 'x'

Line 691: from PV_GE_BENEFITS_B

687: where BENEFIT_ID = l_BENEFIT_ID;
688:
689: cursor c_chk_benefit_exists is
690: select 'x'
691: from PV_GE_BENEFITS_B
692: where BENEFIT_ID = l_BENEFIT_ID;
693:
694:
695: BEGIN