APPS.OE_AGREEMENTS_PKG dependencies on OE_AGREEMENTS_B

Line 71: cursor C is select ROWID from OE_AGREEMENTS_B

67: X_AGREEMENT_SOURCE_CODE in VARCHAR2, --Added by rchellam for OKC
68: X_ORIG_SYSTEM_AGR_ID in NUMBER, --Added by rchellam for OKC
69: X_INVOICE_TO_CUSTOMER_ID in NUMBER -- Added for bug#4029589
70: ) is
71: cursor C is select ROWID from OE_AGREEMENTS_B
72: where AGREEMENT_ID = X_AGREEMENT_ID
73: ;
74: l_x_rowid VARCHAR2(240); /* file.sql.39 changes */
75: begin

Line 76: insert into OE_AGREEMENTS_B (

72: where AGREEMENT_ID = X_AGREEMENT_ID
73: ;
74: l_x_rowid VARCHAR2(240); /* file.sql.39 changes */
75: begin
76: insert into OE_AGREEMENTS_B (
77: TP_ATTRIBUTE2,
78: TP_ATTRIBUTE3,
79: TP_ATTRIBUTE4,
80: TP_ATTRIBUTE5,

Line 374: from OE_AGREEMENTS_B

370: ATTRIBUTE8,
371: AGREEMENT_SOURCE_CODE, --added by rchellam for OKC
372: ORIG_SYSTEM_AGR_ID, --added by rchellam for OKC
373: INVOICE_TO_CUSTOMER_ID -- Added for bug#4029589
374: from OE_AGREEMENTS_B
375: where AGREEMENT_ID = X_AGREEMENT_ID
376: for update of AGREEMENT_ID nowait;
377: recinfo c%rowtype;
378:

Line 594: update OE_AGREEMENTS_B set

590: X_ORIG_SYSTEM_AGR_ID in NUMBER, --added by rchellam for OKC
591: X_INVOICE_TO_CUSTOMER_ID in NUMBER -- Added for bug#4029589
592: ) is
593: begin
594: update OE_AGREEMENTS_B set
595: TP_ATTRIBUTE2 = X_TP_ATTRIBUTE2,
596: TP_ATTRIBUTE3 = X_TP_ATTRIBUTE3,
597: TP_ATTRIBUTE4 = X_TP_ATTRIBUTE4,
598: TP_ATTRIBUTE5 = X_TP_ATTRIBUTE5,

Line 689: delete from OE_AGREEMENTS_B

685: if (sql%notfound) then
686: raise no_data_found;
687: end if;
688:
689: delete from OE_AGREEMENTS_B
690: where AGREEMENT_ID = X_AGREEMENT_ID;
691:
692: if (sql%notfound) then
693: raise no_data_found;

Line 703: from OE_AGREEMENTS_B B

699: begin
700: delete from OE_AGREEMENTS_TL T
701: where not exists
702: (select NULL
703: from OE_AGREEMENTS_B B
704: where B.AGREEMENT_ID = T.AGREEMENT_ID
705: );
706:
707: update OE_AGREEMENTS_TL T set (