APPS.SO_AGREEMENTS_PKG dependencies on SO_AGREEMENTS_B

Line 46: cursor C is select ROWID from SO_AGREEMENTS_B

42: X_LAST_UPDATE_DATE in DATE,
43: X_LAST_UPDATED_BY in NUMBER,
44: X_LAST_UPDATE_LOGIN in NUMBER
45: ) is
46: cursor C is select ROWID from SO_AGREEMENTS_B
47: where AGREEMENT_ID = X_AGREEMENT_ID
48: ;
49: begin
50: insert into SO_AGREEMENTS_B (

Line 50: insert into SO_AGREEMENTS_B (

46: cursor C is select ROWID from SO_AGREEMENTS_B
47: where AGREEMENT_ID = X_AGREEMENT_ID
48: ;
49: begin
50: insert into SO_AGREEMENTS_B (
51: END_DATE_ACTIVE,
52: CONTEXT,
53: ATTRIBUTE1,
54: ATTRIBUTE2,

Line 241: from SO_AGREEMENTS_B

237: AGREEMENT_CONTACT_ID,
238: INVOICE_TO_SITE_USE_ID,
239: SALESREP_ID,
240: START_DATE_ACTIVE
241: from SO_AGREEMENTS_B
242: where AGREEMENT_ID = X_AGREEMENT_ID
243: for update of AGREEMENT_ID nowait;
244: recinfo c%rowtype;
245:

Line 385: update SO_AGREEMENTS_B set

381: X_LAST_UPDATED_BY in NUMBER,
382: X_LAST_UPDATE_LOGIN in NUMBER
383: ) is
384: begin
385: update SO_AGREEMENTS_B set
386: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
387: CONTEXT = X_CONTEXT,
388: ATTRIBUTE1 = X_ATTRIBUTE1,
389: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 453: delete from SO_AGREEMENTS_B

449: if (sql%notfound) then
450: raise no_data_found;
451: end if;
452:
453: delete from SO_AGREEMENTS_B
454: where AGREEMENT_ID = X_AGREEMENT_ID;
455:
456: if (sql%notfound) then
457: raise no_data_found;

Line 467: from SO_AGREEMENTS_B B

463: begin
464: delete from SO_AGREEMENTS_TL T
465: where not exists
466: (select NULL
467: from SO_AGREEMENTS_B B
468: where B.AGREEMENT_ID = T.AGREEMENT_ID
469: );
470:
471: update SO_AGREEMENTS_TL T set (