APPS.ZX_JURISDICTIONS_PKG dependencies on ZX_JURISDICTIONS_B

Line 52: cursor C is select ROWID from ZX_JURISDICTIONS_B

48: X_OBJECT_VERSION_NUMBER in NUMBER,
49: X_TAX_ACCT_SRC_JURISDICT_ID in NUMBER,
50: X_TAX_EXMPT_SRC_JURISDICT_ID in NUMBER
51: ) is
52: cursor C is select ROWID from ZX_JURISDICTIONS_B
53: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID
54: ;
55: begin
56: insert into ZX_JURISDICTIONS_B (

Line 56: insert into ZX_JURISDICTIONS_B (

52: cursor C is select ROWID from ZX_JURISDICTIONS_B
53: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID
54: ;
55: begin
56: insert into ZX_JURISDICTIONS_B (
57: TAX_JURISDICTION_ID,
58: TAX_JURISDICTION_CODE,
59: EFFECTIVE_FROM,
60: EFFECTIVE_TO,

Line 264: from ZX_JURISDICTIONS_B

260: ALLOW_TAX_REGISTRATIONS_FLAG,
261: OBJECT_VERSION_NUMBER,
262: TAX_ACCT_SRC_JURISDICT_ID,
263: TAX_EXMPT_SRC_JURISDICT_ID
264: from ZX_JURISDICTIONS_B
265: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID
266: for update of TAX_JURISDICTION_ID nowait;
267: recinfo c%rowtype;
268: cursor c1 is select

Line 422: update ZX_JURISDICTIONS_B set

418: X_TAX_ACCT_SRC_JURISDICT_ID in NUMBER,
419: X_TAX_EXMPT_SRC_JURISDICT_ID in NUMBER
420: ) is
421: begin
422: update ZX_JURISDICTIONS_B set
423: TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE,
424: EFFECTIVE_FROM = X_EFFECTIVE_FROM,
425: EFFECTIVE_TO = X_EFFECTIVE_TO,
426: TAX_REGIME_CODE = X_TAX_REGIME_CODE,

Line 490: delete from ZX_JURISDICTIONS_B

486: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID;
487: if (sql%notfound) then
488: raise no_data_found;
489: end if;
490: delete from ZX_JURISDICTIONS_B
491: where TAX_JURISDICTION_ID = X_TAX_JURISDICTION_ID;
492: if (sql%notfound) then
493: raise no_data_found;
494: end if;

Line 503: from ZX_JURISDICTIONS_B B

499: begin
500: delete from ZX_JURISDICTIONS_TL T
501: where not exists
502: (select NULL
503: from ZX_JURISDICTIONS_B B
504: where B.TAX_JURISDICTION_ID = T.TAX_JURISDICTION_ID
505: );
506: update ZX_JURISDICTIONS_TL T set (
507: TAX_JURISDICTION_NAME