88: err_stat VARCHAR2(30);
89:
90: begin
91:
92: err_stat := FND_API.G_RET_STS_SUCCESS;
93:
94: insert into ZX_REGIMES_B (
95: PARENT_REGIME_CODE,
96: TAX_REGIME_ID,
286: X_CREATED_BY, X_CREATION_DATE, X_LAST_UPDATED_BY, X_LAST_UPDATE_DATE,
287: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_ID,
288: X_PROGRAM_LOGIN_ID, X_PROGRAM_APPLICATION_ID);
289: end if;
290: if(err_stat <> FND_API.G_RET_STS_SUCCESS) then
291: raise no_data_found;
292: end if;
293: end INSERT_ROW;
294:
707:
708: begin
709:
710: update_flg := FALSE;
711: err_stat := FND_API.G_RET_STS_SUCCESS;
712:
713: OPEN C1;
714: FETCH C1 INTO R1;
715: CLOSE C1;
807: X_LAST_UPDATED_BY, X_LAST_UPDATE_DATE,
808: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_ID,
809: X_PROGRAM_LOGIN_ID, X_PROGRAM_APPLICATION_ID);
810:
811: if(err_stat <> FND_API.G_RET_STS_SUCCESS) then
812: raise no_data_found;
813: end if;
814: --Update zx_taxes_vl table if the rep_tax_auth_id or coll_tax_auth_id has been updated
815: -- Check if update of reporting tax authority id or collecting tax authority has occurred..