APPS.PV_REFERRALS_PKG dependencies on PV_REFERRALS_B

Line 89: cursor C is select ROWID from PV_REFERRALS_B

85: X_ATTRIBUTE22 in VARCHAR2,
86: X_ATTRIBUTE23 in VARCHAR2,
87: X_ATTRIBUTE24 in VARCHAR2
88: ) is
89: cursor C is select ROWID from PV_REFERRALS_B
90: where REFERRAL_ID = X_REFERRAL_ID
91: ;
92: begin
93: insert into PV_REFERRALS_B (

Line 93: insert into PV_REFERRALS_B (

89: cursor C is select ROWID from PV_REFERRALS_B
90: where REFERRAL_ID = X_REFERRAL_ID
91: ;
92: begin
93: insert into PV_REFERRALS_B (
94: ACTUAL_CURRENCY_CODE,
95: BENEFIT_TYPE_CODE,
96: REFERRAL_ID,
97: CUSTOMER_CONTACT_PHONE_TYPE,

Line 457: from PV_REFERRALS_B

453: ATTRIBUTE21,
454: ATTRIBUTE22,
455: ATTRIBUTE23,
456: ATTRIBUTE24
457: from PV_REFERRALS_B
458: where REFERRAL_ID = X_REFERRAL_ID
459: for update of REFERRAL_ID nowait;
460: recinfo c%rowtype;
461:

Line 724: update PV_REFERRALS_B set

720: X_ATTRIBUTE23 in VARCHAR2,
721: X_ATTRIBUTE24 in VARCHAR2
722: ) is
723: begin
724: update PV_REFERRALS_B set
725: ACTUAL_CURRENCY_CODE = X_ACTUAL_CURRENCY_CODE,
726: BENEFIT_TYPE_CODE = X_BENEFIT_TYPE_CODE,
727: CUSTOMER_CONTACT_PHONE_TYPE = X_CUSTOMER_CONTACT_PHONE_TYPE,
728: CUSTOMER_CONTACT_EMAIL_ADDRESS = X_CUSTOMER_CONTACT_EMAIL_ADDRE,

Line 835: delete from PV_REFERRALS_B

831: if (sql%notfound) then
832: raise no_data_found;
833: end if;
834:
835: delete from PV_REFERRALS_B
836: where REFERRAL_ID = X_REFERRAL_ID;
837:
838: if (sql%notfound) then
839: raise no_data_found;

Line 849: from PV_REFERRALS_B B

845: begin
846: delete from PV_REFERRALS_TL T
847: where not exists
848: (select NULL
849: from PV_REFERRALS_B B
850: where B.REFERRAL_ID = T.REFERRAL_ID
851: );
852:
853: update PV_REFERRALS_TL T set (