APPS.ZX_FORMULA_PKG dependencies on ZX_FORMULA_B

Line 59: cursor C is select ROWID from ZX_FORMULA_B

55: X_Enabled_Flag in VARCHAR2,
56: X_CONTENT_OWNER_ID in NUMBER,
57: X_OBJECT_VERSION_NUMBER in NUMBER) is
58:
59: cursor C is select ROWID from ZX_FORMULA_B
60: where FORMULA_ID = X_FORMULA_ID ;
61: begin
62: insert into ZX_FORMULA_B (
63: FORMULA_ID,

Line 62: insert into ZX_FORMULA_B (

58:
59: cursor C is select ROWID from ZX_FORMULA_B
60: where FORMULA_ID = X_FORMULA_ID ;
61: begin
62: insert into ZX_FORMULA_B (
63: FORMULA_ID,
64: Formula_Type_Code,
65: FORMULA_CODE,
66: TAX_REGIME_CODE,

Line 302: from ZX_FORMULA_B

298: PROGRAM_LOGIN_ID,
299: Enabled_Flag,
300: CONTENT_OWNER_ID,
301: OBJECT_VERSION_NUMBER
302: from ZX_FORMULA_B
303: where FORMULA_ID = X_FORMULA_ID
304: for update of FORMULA_ID nowait;
305:
306: recinfo c%rowtype;

Line 590: update ZX_FORMULA_B

586: AND Enabled_Flag = 'Y'
587: AND NUMERIC_RESULT = X_FORMULA_ID;
588: end if;
589:
590: update ZX_FORMULA_B
591: set Formula_Type_Code = X_Formula_Type_Code,
592: FORMULA_CODE = X_FORMULA_CODE,
593: TAX_REGIME_CODE = X_TAX_REGIME_CODE,
594: TAX = X_TAX,

Line 676: delete from ZX_FORMULA_B

672: if (sql%notfound) then
673: raise no_data_found;
674: end if;
675:
676: delete from ZX_FORMULA_B
677: where FORMULA_ID = X_FORMULA_ID;
678:
679: if (sql%notfound) then
680: raise no_data_found;

Line 694: from ZX_FORMULA_B B

690: is
691: begin
692: delete from ZX_FORMULA_TL T
693: where not exists (select NULL
694: from ZX_FORMULA_B B
695: where B.FORMULA_ID = T.FORMULA_ID);
696:
697: update ZX_FORMULA_TL T
698: set (FORMULA_NAME, FORMULA_DESCRIPTION) =

Line 800: INSERT INTO ZX_FORMULA_B (FORMULA_ID,

796: begin
797:
798: if x_formula_id.count <> 0 then
799: forall i in x_formula_id.first..x_formula_id.last
800: INSERT INTO ZX_FORMULA_B (FORMULA_ID,
801: Formula_Type_Code,
802: FORMULA_CODE,
803: TAX_REGIME_CODE,
804: TAX,