APPS.ZX_STATUS_PKG dependencies on ZX_STATUS_B

Line 50: cursor C is select ROWID from ZX_STATUS_B

46: X_PROGRAM_LOGIN_ID in NUMBER,
47: X_CONTENT_OWNER_ID in NUMBER,
48: X_OBJECT_VERSION_NUMBER in NUMBER
49: ) is
50: cursor C is select ROWID from ZX_STATUS_B
51: where TAX_STATUS_ID = X_TAX_STATUS_ID
52: ;
53: begin
54: insert into ZX_STATUS_B (

Line 54: insert into ZX_STATUS_B (

50: cursor C is select ROWID from ZX_STATUS_B
51: where TAX_STATUS_ID = X_TAX_STATUS_ID
52: ;
53: begin
54: insert into ZX_STATUS_B (
55: TAX_STATUS_ID,
56: TAX_STATUS_CODE,
57: EFFECTIVE_FROM,
58: EFFECTIVE_TO,

Line 254: from ZX_STATUS_B

250: PROGRAM_ID,
251: PROGRAM_LOGIN_ID,
252: CONTENT_OWNER_ID,
253: OBJECT_VERSION_NUMBER
254: from ZX_STATUS_B
255: where TAX_STATUS_ID = X_TAX_STATUS_ID
256: for update of TAX_STATUS_ID nowait;
257: recinfo c%rowtype;
258: cursor c1 is select

Line 408: update ZX_STATUS_B set

404: X_CONTENT_OWNER_ID in NUMBER,
405: X_OBJECT_VERSION_NUMBER in NUMBER
406: ) is
407: begin
408: update ZX_STATUS_B set
409: TAX_STATUS_CODE = X_TAX_STATUS_CODE,
410: EFFECTIVE_FROM = X_EFFECTIVE_FROM,
411: EFFECTIVE_TO = X_EFFECTIVE_TO,
412: TAX = X_TAX,

Line 474: delete from ZX_STATUS_B

470: where TAX_STATUS_ID = X_TAX_STATUS_ID;
471: if (sql%notfound) then
472: raise no_data_found;
473: end if;
474: delete from ZX_STATUS_B
475: where TAX_STATUS_ID = X_TAX_STATUS_ID;
476: if (sql%notfound) then
477: raise no_data_found;
478: end if;

Line 487: from ZX_STATUS_B B

483: begin
484: delete from ZX_STATUS_TL T
485: where not exists
486: (select NULL
487: from ZX_STATUS_B B
488: where B.TAX_STATUS_ID = T.TAX_STATUS_ID
489: );
490: update ZX_STATUS_TL T set (
491: TAX_STATUS_NAME