DBA Data[Home] [Help]

APPS.ZX_RATES_PKG dependencies on ZX_RATES_B

Line 123: cursor C is select ROWID from ZX_RATES_B

119:
120: ) is
121: X_ORG_ID NUMBER;
122: X_TAX_TYPE VARCHAR2(30);
123: cursor C is select ROWID from ZX_RATES_B
124: where TAX_RATE_ID = X_TAX_RATE_ID ;
125: begin
126: insert into ZX_RATES_B (
127: TAX_RATE_ID,

Line 126: insert into ZX_RATES_B (

122: X_TAX_TYPE VARCHAR2(30);
123: cursor C is select ROWID from ZX_RATES_B
124: where TAX_RATE_ID = X_TAX_RATE_ID ;
125: begin
126: insert into ZX_RATES_B (
127: TAX_RATE_ID,
128: TAX_RATE_CODE,
129: CONTENT_OWNER_ID,
130: EFFECTIVE_FROM,

Line 494: from ZX_RATES_B

490: ALLOW_EXCEPTIONS_FLAG,
491: SOURCE_ID,
492: -- DESCRIPTION, commented as part of fix for bug# 6820043
493: TAXABLE_BASIS_FORMULA_CODE
494: from ZX_RATES_B
495: where TAX_RATE_ID = X_TAX_RATE_ID
496: for update of TAX_RATE_ID nowait;
497: recinfo c%rowtype;
498: cursor c1 is select

Line 711: update ZX_RATES_B set

707: X_TAX_TYPE VARCHAR2(30);
708: X_RETURN_STATUS VARCHAR2(1) ; --bug#6992215
709:
710: begin
711: update ZX_RATES_B set
712: TAX_RATE_CODE = X_TAX_RATE_CODE,
713: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID,
714: EFFECTIVE_FROM = X_EFFECTIVE_FROM,
715: EFFECTIVE_TO = X_EFFECTIVE_TO,

Line 878: delete from ZX_RATES_B

874: where TAX_RATE_ID = X_TAX_RATE_ID;
875: if (sql%notfound) then
876: raise no_data_found;
877: end if;
878: delete from ZX_RATES_B
879: where TAX_RATE_ID = X_TAX_RATE_ID;
880: if (sql%notfound) then
881: raise no_data_found;
882: end if;

Line 891: from ZX_RATES_B B

887: begin
888: delete from ZX_RATES_TL T
889: where not exists
890: (select NULL
891: from ZX_RATES_B B
892: where B.TAX_RATE_ID = T.TAX_RATE_ID
893: );
894: update ZX_RATES_TL T set (
895: TAX_RATE_NAME